4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del EFB Pinatar
TEMPORADA 2021/2022
1ª MURCIA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Huércal-Overa CF Huércal-Ove 26 140 22 72
2 EF Torre Pacheco Torre 26 144 27 63
3 Cantera Futbol Lorca Deport Cantera 26 75 34 59
4 Lorca CFB B Lorca CFB B 26 125 44 57
5 FC Cartagena Cartagena 26 83 45 53
6 Mazarron Futbol Base Mazarron 26 79 88 39
7 C.D. Algar C.D. Algar 26 62 61 38
8 EFB Pinatar EFB Pinatar 26 45 43 32
9 Mar Menor A Mar Menor A 26 77 97 27
10 Peña Madridista de Lorca Peña 26 42 72 24
11 La Vaguada Cartagena A Vaguada 26 60 98 19
12 Cartagena FC Cartagena 26 37 81 19
13 AD San Cristobal Cristobal 26 26 113 11
14 CD Mediterráneo Mediterráne 26 13 183 4
TEMPORADA 2020/2021
2ª MURCIA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 EFB Pinatar EFB Pinatar 9 46 5 27
2 Mar Menor FC Menor 9 27 15 19
3 Dolores de Pacheco A Dolores 9 21 13 18
4 EF Torre Pacheco Torre 8 25 14 16
5 Club Deportivo Juvenia Club 9 25 18 16
6 La Aljorra A Aljorra 9 19 19 13
7 La Union La Union 9 5 27 4
8 EFB De Balsicas Balsicas 9 9 42 2
9 EF Los Alcázares Alcázares 9 5 29 1
TEMPORADA 2019/2020
AUTO. MURCIA INFANTIL
Equipo PJ GF GC Puntos
1 Real Murcia CF Real Murcia 23 120 14 63
2 EF Torre Pacheco Torre 23 86 19 61
3 UCAM Murcia UCAM Murcia 23 96 15 55
4 FC Cartagena Cartagena 23 91 21 51
5 Lorca CFB Lorca CFB 23 84 21 49
6 Ranero CF Ranero CF 21 62 21 42
7 EF Murcia Promesas Murcia 23 49 30 40
8 EMFB Jumilla EMFB Jumilla 23 37 37 37
9 Cartagena FC Cartagena 23 40 55 31
10 EFB Pinatar EFB Pinatar 23 47 58 25
11 CD Plus Ultra Plus Ultra 23 34 60 23
12 AD Vistalegre Murcia UCAM Vistalegre 23 32 47 21
13 CD Mediterráneo Mediterráne 23 44 69 21
14 SD Futbol Base Yecla Futbol Base 21 37 58 19
15 ADM Lorqui ADM Lorqui 23 23 90 14
16 EF Santa Ana Santa 23 30 98 14
17 La Unión CF Unión 23 9 127 7
18 UD Los Garres Garres 23 13 94 6
TEMPORADA 2018/2019
AUTO. MURCIA INFANTIL
Equipo PJ GF GC Puntos
1 Real Murcia CF Real Murcia 30 124 17 78
2 Lorca CFB Lorca CFB 30 101 27 75
3 UCAM Murcia UCAM Murcia 30 103 28 73
4 FC Cartagena Cartagena 30 96 36 64
5 Ranero CF Ranero CF 30 78 35 62
6 Cartagena FC Cartagena 30 67 51 56
7 EFB Pinatar EFB Pinatar 30 44 59 39
8 EF Murcia Promesas Murcia 30 59 64 37
9 EF Torre Pacheco Torre 30 32 70 35
10 CD Plus Ultra Plus Ultra 30 38 76 34
11 CD Mediterráneo Mediterráne 30 33 69 26
12 SD Futbol Base Yecla Futbol Base 30 41 102 25
13 ADM Lorqui ADM Lorqui 30 41 70 24
14 Escuela Municipal Caravaca Escuela 30 25 73 23
15 CF Molina San Miguel Molina 30 31 82 21
16 El Palmar E G Palmar 30 24 78 17
TEMPORADA 2017/2018
AUTO. MURCIA INFANTIL
Equipo PJ GF GC Puntos
1 EF Torre Pacheco Torre 30 105 22 82
2 Real Murcia CF Real Murcia 30 102 25 71
3 Ranero CF Ranero CF 30 72 24 60
4 Lorca CFB Lorca CFB 30 79 43 57
5 Cartagena FC Cartagena 30 65 36 56
6 UCAM Murcia UCAM Murcia 30 84 24 53
7 EF Murcia Promesas Murcia 30 66 44 51
8 SD Futbol Base Yecla Futbol Base 30 45 55 44
9 EFB Pinatar EFB Pinatar 30 52 77 37
10 FC Cartagena Cartagena 30 45 63 36
11 CF Molina San Miguel Molina 30 39 65 33
12 ADM Lorqui ADM Lorqui 30 37 65 31
13 CD Plus Ultra Plus Ultra 30 24 54 29
14 EF Santa Ana Santa 30 36 87 20
15 AD Vistalegre Murcia UCAM Vistalegre 30 22 113 13
16 Bosco de Cieza Kia Bosco Cieza 30 26 102 7
TEMPORADA 2016/2017
AUTO. MURCIA INFANTIL
Equipo PJ GF GC Puntos
1 Ciudad Jardin Ciudad 30 85 12 79
2 Real Murcia CF Real Murcia 30 89 26 78
3 UCAM Murcia UCAM Murcia 30 91 33 68
4 EF Torre Pacheco Torre 30 74 32 65
5 Lorca CFB Lorca CFB 30 58 40 55
6 CD Plus Ultra Plus Ultra 30 62 34 54
7 EF Murcia Promesas Murcia 30 51 39 49
8 Cartagena FC Cartagena 30 58 48 41
9 AD Vistalegre Murcia UCAM Vistalegre 30 42 46 40
10 Ranero CF Ranero CF 30 36 42 32
11 EFB Pinatar EFB Pinatar 30 44 67 32
12 ADM Lorqui ADM Lorqui 30 39 73 27
13 CF Molina San Miguel Molina 30 31 68 26
14 Beniajan CF A Beniajan 30 35 64 23
15 CF Progreso A Progreso 30 23 132 12
16 CD Mediterráneo Mediterráne 30 27 89 10
TEMPORADA 2015/2016
AUTO. MURCIA INFANTIL
Equipo PJ GF GC Puntos
1 Real Murcia CF Real Murcia 30 128 9 80
2 Ranero CF Ranero CF 30 122 17 80
3 Cartagena FC Cartagena 30 107 32 69
4 EF Torre Pacheco Torre 30 80 29 62
5 CF Progreso A Progreso 30 62 32 57
6 Lorca CFB Lorca CFB 30 59 38 48
7 Ciudad Jardin A Ciudad 30 85 60 48
8 AD Vistalegre Murcia UCAM Vistalegre 30 50 43 48
9 CD Mediterráneo Mediterráne 30 55 71 41
10 ADM Lorqui ADM Lorqui 30 63 51 36
11 CD Plus Ultra Plus Ultra 30 40 77 25
12 CF Molina San Miguel Molina 30 49 82 25
13 EFB Pinatar EFB Pinatar 30 38 93 24
14 EF Santa Ana Santa 30 44 89 24
15 Yecla Toldos Yeclasol A Yecla Toldos 30 44 104 19
16 AD Rincon de Seca Rincon Seca 30 18 217 3
TEMPORADA 2014/2015
1ª MURCIA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Mediterráneo Mediterráne 30 116 39 68
2 EFB Pinatar EFB Pinatar 30 103 41 67
3 Cartagena FC B Cartagena 30 84 40 65
4 Totana Totana 30 76 28 62
5 ACR EF Águilas Águilas 30 83 53 59
6 Huércal-Overa CF Huércal-Ove 30 63 50 48
7 EF Torre Pacheco B Torre 30 59 55 45
8 Atletico Pulpileño Atletico 30 64 65 44
9 Nueva Cartagena Nueva 30 71 62 40
10 Lorca CFB B Lorca CFB B 30 52 54 40
11 CF Progreso CF Progreso 30 49 57 39
12 Lumbreras Lumbreras 30 40 60 33
13 Lorca Estrella Roja Lorca 30 60 114 28
14 Roldan Roldan 30 44 102 25
15 Cabezo de Torres Cabezo 30 37 112 12
16 Los Alcazares Hidros Alcazares 30 34 103 11

  USO DE MEMORIA  
5,604,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5825
Total Execution Time  0.5837
  CADENA URL  
/historico/Efb-Pinatar-Infantil
  GET DATOS  
$_GET['/historico/Efb-Pinatar-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0133  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 = 'Efb-Pinatar-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.0163  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 = 'Efb-Pinatar-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.0133  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=59008 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59008 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1461 AND type_rel = 3
0.0141  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 = '59008' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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.0128  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=59008 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (66187,66184,62095) 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.0128  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66184 AND teamId = 59008
0.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66187 AND teamId = 59008
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 62095 AND teamId = 59008
0.0127  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 = '59008' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59008' and rp.type = 4
0.0129  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 = '59008' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 59008 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134  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.0130  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 = 66187 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.0129  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 = 62060 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.0131  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 = 62095 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.0130  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 = 54249 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.0133  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 = 45128 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 40778 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 34417 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 20130 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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_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 = 8581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC