4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mortadelo A
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 D. Hermanas S.Andres Sub 16 Hermanas 29 95 42 73
2 Atletico Juval Atletico 29 105 38 71
3 Atletico Estacion Sub 16 Atletico 30 88 35 70
4 Antequera Antequera 30 82 49 52
5 Romeral Sub 16 Romeral 30 84 60 51
6 Puerto Malagueño C Puerto 30 66 49 48
7 La Unidad Nueva Malaga Unidad Nueva 30 49 59 45
8 Faro de Torrox Asociacion Faro Torrox 29 67 73 42
9 Rincon A Rincon A 30 70 72 41
10 Mortadelo A Mortadelo A 30 64 73 37
11 Malaka Sub 16 Malaka 30 65 74 36
12 San Estanislao Sub 16 Estanislao 30 44 67 36
13 Olimpica Victoriana Sub 16 Olimpica 29 72 85 34
14 AD Cortijillo Bazan Cortijillo 30 57 75 26
15 EF Velez Francisco Castejon Velez 30 33 74 16
16 Pizarra Atlético Pizarra 30 41 157 5
TEMPORADA 2020/2021
3ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Malagueño C Puerto 9 38 9 20
2 Olimpica Victoriana Sub 16 Olimpica 8 33 10 17
3 Velez F. Castejón Sub 16 Velez 8 25 7 17
4 Atletico Estacion Sub 16 Atletico 9 30 15 16
5 Cortijillo Bazan Cortijillo 9 32 20 12
6 UD Fuengirola Los Boliches Fuengirola 9 14 33 8
7 Guadalmar CD Guadalmar 9 4 54 4
8 Mortadelo A Mortadelo A 9 9 37 2
TEMPORADA 2019/2020
3ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 La Mosca B La Mosca B 22 97 34 58
2 Malaka Sub 16 Malaka 22 78 38 51
3 Jose Santacruz Sub 16 Jose 22 54 50 41
4 Roma Luz C.F. Roma C.F. 22 63 60 35
5 Antequera B CF Antequera 21 38 39 35
6 Atlético Juval Atlético 22 31 30 32
7 UD Fuengirola Los Boliches Fuengirola 22 52 48 31
8 Atletico Estacion Sub 16 Atletico 21 64 62 30
9 Guadalmar CD Guadalmar 22 39 51 27
10 Fútbol Romeral Fútbol 22 40 45 26
11 Puerto Malagueño C Puerto 22 57 59 25
12 Mortadelo A Mortadelo A 22 34 48 25
13 Archidona Atlético Archidona 22 30 50 22
14 El Palo FC Sub 16 Palo 20 52 62 20
15 Mijas Las Lagunas B Mijas 18 19 49 15
16 Cortijillo Bazan Cortijillo 20 32 55 14
TEMPORADA 2018/2019
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 26 de Febrero Sub 16 Febrero 30 102 25 78
2 Puerto de La Torre Los Mora Puerto Torre 30 117 41 71
3 Jose Santacruz Sub 16 Jose 30 121 48 69
4 La Mosca B La Mosca B 30 116 47 64
5 Atlético Juval Atlético 30 80 62 50
6 Puerto Malagueño C Puerto 30 74 50 47
7 Fútbol Romeral Fútbol 30 62 61 41
8 Atletico Estacion Sub 16 Atletico 30 70 78 41
9 Antequera B CF Antequera 30 71 82 39
10 Mortadelo A Mortadelo A 30 67 97 39
11 El Palo FC Sub 16 Palo 30 60 76 32
12 Peña Compadres Peña 30 60 108 31
13 Mijas Las Lagunas B Mijas 30 54 81 28
14 Asociacion Faro de Torrox Asociacion 30 34 82 24
15 La Unidad Nueva Malaga Unidad Nueva 30 41 109 24
16 Alh. De La Torre Sub 16 B Alh. Torre 30 42 124 9
TEMPORADA 2017/2018
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Puerto Malagueño C Puerto 30 116 12 85
2 Tiro Pichon Sub 16 B Tiro Pichon 30 128 50 68
3 Cortijillo Bazan Cortijillo 30 80 34 64
4 El Palo FC Sub 16 Palo 30 116 45 61
5 Atlético Juval Atlético 30 126 40 60
6 Romeral Sub 16 Romeral 30 90 41 60
7 Peña Compadres B Peña 30 92 50 52
8 Puerto de La Torre Los Mora Puerto Torre 30 87 78 49
9 Asociacion Faro de Torrox Asociacion 30 65 46 41
10 Jose Santacruz Sub 16 Jose 30 61 86 36
11 Mortadelo A Mortadelo A 30 53 74 35
12 La Unidad Nueva Malaga Unidad Nueva 30 38 76 27
13 CD Juventud De Torremolinos Juventud 30 51 105 23
14 La Mosca C La Mosca C 30 43 134 16
15 Algarrobo Algarrobo 30 44 110 14
16 La Cala A La Cala A 30 21 230 5
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 2
Equipo PJ GF GC Puntos
1 Puerto Malagueño CJ GI Puerto 30 172 18 86
2 Carlinda Sub 16 Carlinda 30 170 44 74
3 26 de Febrero Sub 16 Febrero 30 135 39 69
4 Romeral Sub 16 Romeral 30 114 42 65
5 Lauro A Lauro A 30 85 46 54
6 Mortadelo A Mortadelo A 30 94 61 51
7 Olimpica Victoriana Sub 16 Olimpica 30 121 79 48
8 AD Cortijillo Bazan Cortijillo 30 104 60 46
9 El Palo FC Sub 16 B Palo 30 93 105 38
10 Rincon A Rincon A 30 80 111 38
11 Portada Alta Atlético Portada Alta 30 49 127 30
12 Santa Rosalia Maqueda Santa 30 59 124 26
13 La Unidad Nueva Malaga A Unidad Nueva 30 47 97 25
14 San Estanislao Sub 16 Estanislao 30 61 189 24
15 Puerto de la Torre A Puerto Torre 30 40 200 11
16 Atletico Estacion A Atletico 30 53 135 10
TEMPORADA 2014/2015
4ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 La Unidad Nueva Malaga A Unidad Nueva 26 95 22 69
2 Mortadelo A Mortadelo A 26 112 21 64
3 Atletico Estacion A Atletico 26 114 35 57
4 Puerto Malagueño CJ GI Puerto 26 73 47 47
5 La Cala A La Cala A 26 113 57 46
6 AD Cortijillo Bazan Cortijillo 26 74 38 46
7 Romeral Sub 16 Romeral 26 62 41 42
8 Atletico Juval Atletico 26 53 36 37
9 Rincon A Rincon A 26 54 64 32
10 El Palo FC Sub 16 B Palo 26 47 75 28
11 Lauro Sub 16 Lauro 26 43 118 17
12 Puerto Torre Morales A Puerto Torre 26 34 114 17
13 Amigos del Deporte Colmenar Amigos 26 40 143 10
14 Portada Alta Portada Alta 26 35 138 10

  USO DE MEMORIA  
5,411,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1130
Total Execution Time  0.1143
  CADENA URL  
/historico/Mortadelo-A-Cadete
  GET DATOS  
$_GET['/historico/Mortadelo-A-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0023  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 = 'Mortadelo-A-Cadete' AND l.year = 2024 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.0029  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 = 'Mortadelo-A-Cadete' 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.0018  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=25538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 66113
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25538 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=454 AND type_rel = 3
0.0024  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 = '25538' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '25538' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '25538' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '25538' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 66113 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=25538 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (66113) 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.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66113 AND teamId = 25538
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 66113 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '25538' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25538' and rp.type = 4
0.0023  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 = '25538' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 25538 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 `tables2022_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 = 66113 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.0026  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 = 59505 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 52742 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.0027  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 = 45928 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 40574 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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.0031  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 = 17293 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 4887 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 66113 ORDER BY nameShow LIMIT 100