4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Estepona Sub 16
TEMPORADA 2020/2021
2ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 CD Tiro Pichón Tiro Pichón 11 38 11 27
2 Estepona Sub 16 Estepona 10 33 5 26
3 Athletic Puerta Blanca Athletic 9 23 7 21
4 Romeral Sub 16 Romeral 10 30 12 17
5 Conejito de Malaga Conejito 10 18 19 15
6 La Mosca B La Mosca B 10 19 19 13
7 Athletic Club Fuengirola Athletic 10 13 19 13
8 UD San Pedro Pedro 10 12 23 7
9 Mortadelo Sub 16 Mortadelo 9 15 28 7
10 CD Rincón CD Rincón 10 13 31 6
11 Puerto de La Torre Los Mora Puerto Torre 9 6 46 0
TEMPORADA 2019/2020
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 24 67 26 57
2 Velez Francisco Castejon EF Velez 24 56 28 50
3 UD San Pedro Pedro 24 65 37 48
4 Estepona Sub 16 Estepona 23 52 25 47
5 Romeral Sub 16 Romeral 24 42 32 43
6 Conejito de Malaga Conejito 24 48 37 37
7 Antequera Antequera 24 51 47 36
8 Tiro Pichon Sub 16 B Tiro Pichon 22 41 33 35
9 CD Rincón CD Rincón 24 46 38 34
10 26 de Febrero Sub 16 Febrero 24 48 46 34
11 Alhaurin de La Torre Alhaurin 23 39 37 34
12 Mortadelo Sub 16 Mortadelo 23 41 45 32
13 D. Hermanas S.Andres Sub 16 Hermanas 24 44 59 28
14 Atletico Benamiel A Atletico 24 33 49 23
15 Puerto de La Torre Los Mora Puerto Torre 24 36 55 23
16 Athletic Club Fuengirola Athletic 23 39 47 22
17 Athletic Puerta Blanca Athletic 24 45 77 14
18 Peña Compadres Peña 24 20 95 4
TEMPORADA 2018/2019
3ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Estepona Sub 16 Estepona 30 118 21 84
2 Futbol Romeral Sub 16 B Futbol 30 163 42 76
3 Marbella Paraiso Sub 16 Marbella 30 118 43 71
4 Tiro Pichón B Tiro Pichón 30 111 41 65
5 Las Lagunas Las Lagunas 30 86 52 62
6 Alhaurino Alhaurino 30 70 50 50
7 Campillos Campillos 30 68 54 46
8 Alh. De La Torre Sub 16 B Alh. Torre 30 68 75 41
9 UD San Pedro Pedro 30 62 88 34
10 Benamiel Atletico Benamiel 30 56 83 33
11 Fuengirola Boliches Sub 16 Fuengirola 30 45 120 32
12 Costa Unida CF Costa Unida 30 53 90 30
13 Roma Luz C.F. Roma C.F. 30 48 76 27
14 Los Morales Sub Sub 16 B Morales 30 40 97 22
15 Benalmadena Atletico Benalmadena 30 27 94 15
16 Campanillas Campanillas 30 27 134 8
TEMPORADA 2016/2017
3ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Estacion Sub 16 Atletico 30 129 32 77
2 Athletic Club Fuengirola Athletic 30 99 32 69
3 Atletico Benamiel A Atletico 30 75 30 67
4 Marbella FC Marbella FC 30 66 40 61
5 Campanillas Campanillas 30 93 66 53
6 Alhaurino Alhaurino 30 68 53 49
7 Campillos Campillos 30 55 71 38
8 Conejito de Malaga Conejito 30 74 71 37
9 Fuengirola Boliches Sub 16 Fuengirola 30 60 85 36
10 Alhaurín de la Torre Alhaurín 30 55 70 33
11 San Pedro Brupocon Pedro 30 55 80 33
12 Peña Compadres Peña 30 47 74 33
13 Costa Unida Costa Unida 30 52 82 32
14 Estepona Sub 16 Estepona 30 50 53 31
15 Juventud de Torremolinos Juventud 30 32 116 18
16 D. Hermanas S.Andres Sub 16 Hermanas 30 45 100 15
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 San Pedro Brupocon Pedro 22 89 20 57
2 Estepona Sub 16 Estepona 22 97 11 56
3 Union Manilva Union 22 111 42 50
4 Marbella Paraiso B Marbella 22 62 28 45
5 Asdva Pablo Picaso Asdva Pablo 22 54 55 40
6 Vazquez Cultural Vazquez 22 61 46 37
7 Nueva Andalucia Nueva 22 51 63 36
8 Estepona Fútbol Senior Estepona 22 31 57 22
9 Las Chapas Futbol Chapas 22 58 68 17
10 Esteponense Esteponense 22 42 79 15
11 Ciudad de Estepona Ciudad 22 19 103 6
12 Marbella FC Marbella FC 22 19 122 6
TEMPORADA 2014/2015
4ª ANDALUZA MÁLAGA CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Peña Compadres Peña 26 147 22 73
2 Estepona Sub 16 Estepona 26 113 31 64
3 Ronda A Ronda A 26 129 39 63
4 Pablo Picaso AD Pablo Picaso 26 111 48 55
5 Union Manilva Union 26 120 79 44
6 Vazquez Cultural Vazquez 26 118 56 43
7 UD San Pedro Pedro 26 66 50 40
8 Marbella CF Marbella CF 26 69 60 38
9 Marbella Paraiso Sub 16 Marbella 26 86 64 36
10 Las Chapas Futbol Chapas 26 71 75 31
11 Esteponense Esteponense 26 37 106 19
12 Ciudad de Estepona Ciudad 26 56 141 19
13 Nueva Andalucia Nueva 26 19 198 4
14 Marbelli Atletico Marbelli 26 27 200 1

  USO DE MEMORIA  
5,173,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0694
Total Execution Time  0.0706
  CADENA URL  
/historico/Estepona-Futbol-Base-Cadete/2021
  GET DATOS  
$_GET['/historico/Estepona-Futbol-Base-Cadete/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0040  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 59161
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25594 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=449 AND type_rel = 3
0.0021  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '25594' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 59161 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=25594 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (64286,59161) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59161 AND teamId = 25594
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64286 AND teamId = 25594
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 59161 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '25594' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25594' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '25594' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 25594 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021_base` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 59161 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019_base` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 45929 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017_base` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 34347 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016_base` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 17297 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 4890 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 59161 ORDER BY nameShow LIMIT 100