4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AD Guadalupe A
TEMPORADA 2021/2022
AUTO. MURCIA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Lorca CFB Lorca CFB 30 125 16 80
2 EFB Pinatar EFB Pinatar 30 126 26 76
3 FC Cartagena Cartagena 30 147 20 74
4 EF Torre Pacheco Torre 30 90 34 63
5 Academia Grana A Academia 30 110 47 56
6 AD Guadalupe A Guadalupe 30 61 54 47
7 Nueva Cartagena Nueva 30 43 40 42
8 Lumbreras Lumbreras 30 45 53 41
9 EF Los Alcázares Alcázares 30 64 87 41
10 Beniel Beniel 30 56 54 40
11 CD Mediterráneo Mediterráne 30 44 61 29
12 Cartagena FC Cartagena 30 54 73 29
13 Beniajan A Beniajan A 30 46 110 28
14 ACR EF Águilas Águilas 30 40 107 27
15 La Unión CF Unión 30 18 108 9
16 EF Santa Ana Santa 30 14 193 4
TEMPORADA 2020/2021
2ª MURCIA INFANTIL GRUPO 8
Equipo PJ GF GC Puntos
1 EF Murcia Promesas B Murcia 9 56 4 27
2 CD Puebla De Soto B Puebla Soto 9 42 7 24
3 El Palmar CF Palmar 8 46 7 21
4 CD Alberca CD Alberca 8 24 19 15
5 EFB Pinatar B Pinatar 9 20 39 10
6 Alhama A Alhama A 9 15 40 9
7 Reino de Murcia B Reino Murcia 9 17 22 7
8 AD Guadalupe A Guadalupe 9 17 37 6
9 CF Progreso C Progreso 10 5 67 0
TEMPORADA 2019/2020
2ª MURCIA INFANTIL
Equipo PJ GF GC Puntos
1 CD Ronda Sur A Ronda 19 99 12 57
2 Academico Murcia CF Academico 19 93 32 47
3 EF Murcia Promesas B Murcia 19 73 26 42
4 CD Barnes B CD Barnes B 19 56 25 38
5 CD Alberca CD Alberca 19 60 35 37
6 CF Progreso C Progreso 19 43 27 32
7 El Palmar CF Palmar 19 75 40 30
8 AD Vistalegre Murcia B Vistalegre 19 50 36 30
9 AD Palmeral AD Palmeral 19 60 49 28
10 AD Guadalupe A Guadalupe 19 52 45 24
11 Patiño CF Patiño CF 18 27 70 10
12 Beniajan CF A Beniajan 18 16 78 7
13 CD Santa Maria de Gracia Santa Maria 19 19 111 7
14 Gesa Churra EDMF B Gesa Churra 19 11 148 0
TEMPORADA 2018/2019
1ª MURCIA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Real Murcia CF B Real Murcia 30 116 22 75
2 AD Vistalegre Murcia UCAM Vistalegre 30 117 24 72
3 EMFB Jumilla EMFB Jumilla 30 74 23 66
4 UD Los Garres Garres 30 76 36 60
5 Bosco de Cieza Bosco Cieza 30 71 41 59
6 UCAM Murcia B UCAM Murcia 30 87 37 58
7 Ranero CF B Ranero CF B 30 71 39 51
8 Archena FC-Asesoria Rios Archena 30 87 52 47
9 ADM Lorqui B Lorqui 30 54 61 36
10 Beniel Beniel 30 56 77 35
11 CF Progreso CF Progreso 30 54 78 35
12 Bullas Deportivo Bullas 30 53 65 33
13 Villa de Fortuna Villa 30 46 85 31
14 AD Guadalupe A Guadalupe 30 54 58 27
15 Beniajan CF A Beniajan 30 33 147 9
16 Olimpico de Totana Olimpico 30 10 214 0
TEMPORADA 2017/2018
1ª MURCIA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Real Murcia CF B Real Murcia 30 123 34 76
2 El Palmar Ortopedias San An Palmar 30 112 29 70
3 Escuela Municipal Caravaca Escuela 30 87 39 61
4 Beniajan CF A Beniajan 30 62 31 56
5 Archena FC-Asesoria Rios Archena 30 55 67 51
6 EMFB Jumilla EMFB Jumilla 30 80 60 49
7 AD Guadalupe A Guadalupe 30 80 64 48
8 Olimpico de Totana Olimpico 30 88 67 46
9 Beniel Beniel 30 51 41 43
10 ADM Lorqui B Lorqui 30 51 67 41
11 Villa de Fortuna Villa 30 38 85 32
12 Atletico Torreño CF Atletico 30 33 69 31
13 EFB Puente Tocinos Puente 30 42 64 26
14 Vistalegre Murcia Vistalegre 30 46 85 25
15 Gesa Churra EDMF A Gesa Churra 30 32 104 13
16 Muleño Muleño 30 31 105 10
TEMPORADA 2016/2017
1ª MURCIA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 EF Torre Pacheco B Torre 30 108 12 81
2 EF Santa Ana Santa 30 92 34 65
3 Real Murcia CF B Real Murcia 29 57 33 58
4 Mazarron Futbol Base Mazarron 29 87 59 57
5 AD Guadalupe A Guadalupe 30 102 53 52
6 Gesa Churra EDMF A Gesa Churra 29 51 35 49
7 Olimpico de Totana Olimpico 30 77 56 48
8 ACR EF Águilas Águilas 30 65 49 47
9 Lorca CFB B Lorca CFB B 29 69 60 44
10 Cartagena FC B Cartagena 30 78 51 40
11 La Unión CF Unión 30 47 49 36
12 CF Base Totana Base Totana 30 72 74 32
13 Ciudad Jardin Ciudad 29 65 69 32
14 Roldan A Roldan A 30 38 84 24
15 Alhama Alhama 30 33 132 10
16 Nueva Vanguardia Nueva 25 6 197 0
TEMPORADA 2015/2016
1ª MURCIA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 UCAM Murcia B UCAM Murcia 30 112 29 76
2 EFB Puente Tocinos Puente 30 101 32 66
3 AD Guadalupe A Guadalupe 29 117 51 66
4 Acr Aguilas A Aguilas 29 82 33 65
5 Totana A Totana A 30 50 47 49
6 Lorca CFB B Lorca CFB B 30 52 47 45
7 Olimpic A Olimpic A 30 54 49 44
8 Ciudad Jardin A Ciudad 30 63 60 43
9 EF Torre Pacheco B Torre 30 69 63 39
10 CF Progreso CF Progreso 30 61 83 35
11 Cartagena FC B Cartagena 30 53 74 35
12 Gesa Churra EDMF A Gesa Churra 30 54 58 34
13 Huercal Overa A Huercal 30 43 69 30
14 CD Lumbreras A Lumbreras 30 47 70 28
15 Nueva Cartagena A Nueva 30 48 109 20
16 Club Atletico Pulpileño A Club 30 23 155 2

  USO DE MEMORIA  
5,320,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1081
Total Execution Time  0.1093
  CADENA URL  
/historico/Ad-Guadalupe-B-Infantil
  GET DATOS  
$_GET['/historico/Ad-Guadalupe-B-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0022  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 = 'Ad-Guadalupe-B-Infantil' 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.0028  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 = 'Ad-Guadalupe-B-Infantil' 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.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=129967 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=129967 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=129967 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=129967 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=129967 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=129967 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=129967 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=129967 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=129967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 66184
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=129967 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1461 AND type_rel = 3
0.0023  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 = '129967' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '129967' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
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 = '129967' 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 = 66184 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=129967 AND l.year in (2021,2022,2023) 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 (66184,62101,62074) 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 = 66184 AND teamId = 129967
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 62074 AND teamId = 129967
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 62101 AND teamId = 129967
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 `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 = 66184 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '129967' 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 = '129967' 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 = '129967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 129967 AND l.year <= 2022 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 `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 = 66184 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.0028  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 = 62074 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 62101 AND t.round = 18 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 `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 = 54258 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 45130 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 `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 = 40786 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 = 34418 AND t.round = 30 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 `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 = 20131 AND t.round = 30 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 = 66184 ORDER BY nameShow LIMIT 100