4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Athletic Puerta Blanca
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
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Puerto Malagueño Sub 16 B Puerto 34 111 35 82
2 Antequera Antequera 34 95 43 73
3 Athletic Puerta Blanca Athletic 34 86 44 71
4 Velez F. Castejón Sub 16 Velez 34 81 56 65
5 Alhaurin de La Torre Alhaurin 34 76 49 64
6 Marbella FC Marbella FC 34 92 77 55
7 D. Hermanas S.Andres Sub 16 Hermanas 34 68 69 54
8 Atlético Benamiel Atlético 34 96 74 53
9 Rincon A Rincon A 34 70 60 47
10 UD San Pedro Pedro 34 54 61 47
11 Tiro Pichon Sub 16 B Tiro Pichon 34 76 68 46
12 Conejito de Malaga Conejito 34 62 61 42
13 Athletic Fuengirola Athletic 34 72 73 42
14 Mortadelo Sub 16 Mortadelo 34 56 104 36
15 Vazquez Cultural Vazquez 34 51 80 29
16 Ronda Union Deportiva Ronda Union 34 43 107 19
17 Cortijillo Bazan Cortijillo 34 31 93 15
18 UD Fuengirola Los Boliches Fuengirola 34 45 111 15
TEMPORADA 2017/2018
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 CD Tiro Pichón Tiro Pichón 34 135 33 87
2 Athletic Club Fuengirola Athletic 34 78 28 74
3 Puerto Malagueño Sub 16 B Puerto 34 98 38 71
4 Antequera Antequera 34 77 54 59
5 Atlético Benamiel Atlético 34 85 59 56
6 UD San Pedro Pedro 34 66 66 50
7 Vazquez Cultural Vazquez 34 72 61 49
8 CD Rincón CD Rincón 34 86 78 49
9 Mortadelo Sub 16 Mortadelo 34 59 56 47
10 Athletic Puerta Blanca Athletic 34 69 70 47
11 UD Fuengirola Los Boliches Fuengirola 34 81 79 43
12 D. Hermanas S.Andres Sub 16 Hermanas 34 68 96 41
13 La Mosca B La Mosca B 34 63 94 41
14 Atletico Estacion Sub 16 Atletico 34 72 91 38
15 La Unidad Nueva Malaga Unidad Nueva 34 45 48 37
16 Fútbol Romeral Fútbol 34 58 72 36
17 Alhaurin de La Torre Alhaurin 34 63 90 35
18 Roma Luz C.F. Roma C.F. 34 24 186 4
TEMPORADA 2016/2017
4ª ANDALUZA MÁLAGA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Mortadelo A Mortadelo A 26 178 19 73
2 Athletic Puerta Blanca Athletic 26 180 25 67
3 Los Morales Sub Sub 16 B Morales 26 143 29 66
4 La Unidad Nueva Malaga B Unidad Nueva 25 102 27 55
5 Lauro B Lauro B 26 80 45 45
6 Almogia Atletic Almogia 26 112 71 44
7 Olimpica Victoriana Sub 16 Olimpica 26 72 56 37
8 Rincon B Rincon B 26 82 76 37
9 Málaga C.F. SAD Fem Málaga C.F. 26 64 82 36
10 Santa Rosalia Maqueda Santa 26 58 87 27
11 Amigos del Deporte Colmenar Amigos 25 31 110 16
12 Santa Julia Santa Julia 26 47 197 11
13 San Estanislao B Estanislao 25 39 187 9
14 Internacional de La Paz Internaciona 25 46 223 6
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Mortadelo B Mortadelo B 30 159 19 82
2 D. Hermanas S.Andres Sub 16 Hermanas 30 141 42 78
3 Churriana Churriana 30 124 24 72
4 Atletico Juval Atletico 30 111 40 63
5 Tiro Pichon Sub 16 B Tiro Pichon 30 84 42 55
6 La Cala B La Cala B 30 95 67 49
7 Athletic Puerta Blanca Athletic 30 68 81 45
8 Los Morales Sub Sub 16 B Morales 30 61 53 45
9 Santa Julia Santa Julia 30 78 82 41
10 Roma Luz CF B Roma 30 73 99 37
11 Guadalmar CD Guadalmar 30 101 91 36
12 Conejito de Malaga Conejito 30 68 82 33
13 Alora Sub 16 Alora 30 67 84 31
14 Campanillas Campanillas 30 33 108 18
15 San Julian Atletico Sub 16 Julian 30 27 245 11
16 Malaga Catlético Malaga 30 13 144 7
TEMPORADA 2014/2015
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Athletic Puerta Blanca Athletic 30 141 32 74
2 Tiro Pichón B Tiro Pichón 30 98 36 74
3 CD Rincón CD Rincón 30 87 34 68
4 Antequera B CF Antequera 30 76 59 57
5 Futbol Base Torreño CDAD Futbol Base 30 66 49 54
6 D. Hermanas S.Andres Sub 16 Hermanas 30 92 43 53
7 Futbol Romeral Sub 16 B Futbol 30 72 63 45
8 Malaka C.F. Malaka C.F. 30 56 51 42
9 Atletico Archidona Atletico 30 75 83 36
10 El Palo FC Sub 16 Palo 30 47 72 36
11 Algarrobo UD Algarrobo 30 51 86 33
12 Faro de Torrox Faro Torrox 30 49 66 32
13 La Mosca C La Mosca C 30 64 100 32
14 Francisco Castejon B Francisco 30 45 67 28
15 Roma Luz CF B Roma 30 37 101 14
16 Vélez FC Vélez FC 30 50 164 11

  USO DE MEMORIA  
5,495,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5813
Total Execution Time  0.5825
  CADENA URL  
/historico/Athletic-Puerta-Blanca-Cadete/2021
  GET DATOS  
$_GET['/historico/Athletic-Puerta-Blanca-Cadete/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0177  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Athletic-Puerta-Blanca-Cadete' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0299  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.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19786 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=449 AND type_rel = 3
0.0170  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '19786' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0159  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 = '19786' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = '19786' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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.0151  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=19786 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (60450,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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 59161 AND teamId = 19786
0.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 60450 AND teamId = 19786
0.0148  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.0149  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 = 19786 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 60450 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0154  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 `tables2020_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 = 52470 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 45489 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 45901 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2018_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 = 40279 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2018_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 = 40486 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 34337 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 35092 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 17268 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 17294 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 4304 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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