4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD El Esparragal
TEMPORADA 2023/2024
1ª REGIONAL MURCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Santomera Santomera 26 91 18 67
2 Unión Archena Unión 27 61 26 59
3 La Copa CF La Copa CF 27 60 44 53
4 Cotillas CD Cotillas CD 27 46 26 51
5 EF Altorreal Altorreal 27 60 47 48
6 CD El Esparragal Esparragal 27 54 42 46
7 Jumilla Atlético Jumilla 27 47 40 38
8 Cehegin Cehegin 27 46 41 35
9 Independiente Ceutí Independient 27 43 49 35
10 Villa de Fortuna Villa 27 43 56 33
11 CD Cieza B CD Cieza B 27 42 50 30
12 CD Ciudad de Mula Ciudad Mula 27 33 57 30
13 Atletico Cabezo de Torres B Atletico 27 40 66 29
14 CD Hoya del Campo Hoya Campo 27 44 53 28
15 CD Beniel CD Beniel 26 47 52 27
16 Ceuti Atletico A Ceuti 27 24 114 4
TEMPORADA 2022/2023
1ª REGIONAL MURCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ciudad de Calasparra Ciudad 20 52 19 50
2 Santomera Santomera 20 53 21 49
3 Cehegin Cehegin 20 41 25 37
4 AD Palmeral AD Palmeral 20 47 36 31
5 EF Altorreal Altorreal 20 39 35 28
6 CD Ciudad de Mula Ciudad Mula 20 27 47 22
7 CD Hoya del Campo Hoya Campo 20 32 37 21
8 Independiente Ceutí Independient 20 24 35 20
9 EF Ciudad de Yecla Ciudad Yecla 20 17 45 19
10 Atletico Cabezo de Torres B Atletico 20 31 46 17
11 CD El Esparragal Esparragal 20 26 43 15
TEMPORADA 2021/2022
PREFERENTE MURCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Muleño CF Muleño CF 28 56 24 61
2 Cieza Cieza 28 50 25 59
3 EDMF Churra EDMF Churra 28 39 24 51
4 Villa de Fortuna Villa 28 41 23 49
5 Unión Molinense Unión 28 44 34 47
6 CD Beniel CD Beniel 28 45 38 44
7 Abarán CF Abarán CF 28 38 35 42
8 Yeclano Deportivo B Yeclano 28 45 41 41
9 El Raal El Raal 28 36 35 39
10 Plus Ultra Plus Ultra 28 36 35 38
11 Santomera Santomera 28 33 29 36
12 Cehegin Cehegin 28 35 37 36
13 CD El Esparragal Esparragal 28 26 62 22
14 CD Hoya del Campo Hoya Campo 28 23 56 13
15 Independiente Ceutí Independient 28 24 73 9
TEMPORADA 2020/2021
PREFERENTE MURCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Archena Sport Archena 22 68 21 55
2 Villa de Fortuna Villa 22 45 15 53
3 Algezares UD Algezares 22 30 20 37
4 Santomera Santomera 22 30 24 34
5 Cieza Cieza 22 34 24 32
6 Aguilas FC B Aguilas 22 32 41 29
7 CD Algar CD Algar 22 30 26 27
8 Yeclano Deportivo B Yeclano 22 25 34 27
9 CD El Esparragal Esparragal 22 18 35 26
10 CD Beniel CD Beniel 22 30 38 25
11 Alcantarilla FC Alcantarilla 22 17 40 24
12 Atletico Pinatarense Atletico 22 12 53 5
TEMPORADA 2019/2020
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Racing Murcia Racing 27 76 23 67
2 CD Bullense CD Bullense 27 43 17 62
3 Abarán CF Abarán CF 27 56 31 57
4 FC La Unión Atl. Unión Atl. 27 62 34 45
5 CD Algar CD Algar 27 45 41 41
6 Mar Menor B Mar Menor B 27 44 38 37
7 Archena Sport Archena 27 41 41 36
8 Balsicas Atlético Balsicas 27 44 48 36
9 Villa de Fortuna Villa 27 45 50 36
10 Bala Azul Bala Azul 27 41 49 36
11 Cieza Cieza 27 34 40 32
12 EF Alhama EF Alhama 27 34 49 31
13 CD Beniel CD Beniel 27 42 50 29
14 Unión Molinense Unión 27 38 46 28
15 Ciudad de Calasparra Ciudad 27 39 54 28
16 Atletico Cabezo de Torres Atletico 27 28 55 28
17 CD El Esparragal Esparragal 27 36 61 25
18 Caravaca Caravaca 27 26 47 24
TEMPORADA 2018/2019
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 El Palmar El Palmar 34 63 29 78
2 Cartagena F.C. UCAM Cartagena 34 74 27 74
3 Abarán CF Abarán CF 34 89 37 69
4 Racing Murcia Racing 34 67 43 60
5 Plus Ultra Plus Ultra 34 53 34 59
6 Atletico Cabezo de Torres Atletico 34 58 40 57
7 Bala Azul Bala Azul 34 55 47 50
8 EF Alhama EF Alhama 34 42 46 48
9 Mar Menor B Mar Menor B 34 48 51 45
10 CD Bullense CD Bullense 34 45 50 43
11 CD Beniel CD Beniel 34 49 56 42
12 CD El Esparragal Esparragal 34 50 64 41
13 Villa de Fortuna Villa 34 59 76 38
14 Jumilla CD Jumilla CD 34 50 67 36
15 Balsicas Atlético Balsicas 34 45 62 33
16 Juvenia Juvenia 34 43 66 32
17 Montecasillas Montecasilla 34 49 78 32
18 Ind. De Ceutí Ind. Ceutí 34 30 96 13
TEMPORADA 2017/2018
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 CAP Ciudad de Murcia Ciudad 34 63 29 73
2 Olímpico de Totana Olímpico 34 52 31 68
3 CD Algar CD Algar 34 57 35 64
4 Mazarrón FC Mazarrón 34 70 45 60
5 Abarán CF Abarán CF 34 62 39 59
6 Plus Ultra Plus Ultra 34 44 30 58
7 EF Alhama EF Alhama 34 60 42 54
8 CD El Esparragal Esparragal 34 52 46 48
9 Unión Molinense Unión 34 44 50 45
10 CD Bullense CD Bullense 34 44 50 44
11 Balsicas Atlético Balsicas 34 51 57 40
12 Juvenia Juvenia 34 35 40 39
13 Cartagena F.C. UCAM Cartagena 34 37 61 35
14 Jumilla CD Jumilla CD 34 42 67 35
15 Racing Murcia Racing 34 46 59 32
16 Alquerias Alquerias 34 45 72 32
17 Abanilla Abanilla 34 49 74 30
18 Alcantarilla FC Alcantarilla 34 41 67 30
TEMPORADA 2016/2017
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Minerva Minerva 34 77 34 76
2 Bala Azul Bala Azul 34 78 46 71
3 FC Cartagena B Cartagena 34 86 46 62
4 Mazarrón FC Mazarrón 34 52 28 61
5 UD Los Garres Garres 34 45 25 61
6 Unión Molinense Unión 34 65 42 57
7 Alquerias Alquerias 34 61 41 56
8 Balsicas Atlético Balsicas 34 49 49 51
9 Alcantarilla FC Alcantarilla 34 39 32 47
10 Cartagena F.C. UCAM Cartagena 34 53 48 46
11 Jumilla CD Jumilla CD 34 49 56 43
12 Abanilla Abanilla 34 51 69 42
13 Racing Murcia Racing 34 60 73 36
14 CD El Esparragal Esparragal 34 46 60 34
15 Plus Ultra Plus Ultra 34 38 67 33
16 Caravaca Caravaca 34 41 68 32
17 Montecasillas Montecasilla 34 30 68 21
18 CD Lumbreras Lumbreras 34 25 93 14

  USO DE MEMORIA  
5,743,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5164
Total Execution Time  0.5177
  CADENA URL  
/historico/Cd-El-Esparragal-Preferente
  GET DATOS  
$_GET['/historico/Cd-El-Esparragal-Preferente']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0168  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 = 'Cd-El-Esparragal-Preferente' 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.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=96802 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=96802 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0281  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 = 73794
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=96802 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1454 AND type_rel = 3
0.0128  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 = '96802' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '96802' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '96802' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73794 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=96802 AND l.year in (2023,2024,2025) 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 (73794) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 73794 AND teamId = 96802
0.0136  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 73794 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131  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 = '96802' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '96802' and rp.type = 4
0.0138  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 = '96802' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0184  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73794 WHERE rp.league_id = 73794 AND rp.teamId = 96802 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73794 WHERE rp.league_id = 73794 AND rp.teamId = 96802 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73794 WHERE rp.league_id = 73794 AND rp.teamId = 96802 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 96802 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145  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 `tables2024` 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 = 73794 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables2023` 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 = 69363 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.0147  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` 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 = 64036 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.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 `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 = 59805 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.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 `tables2020` 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 = 51172 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0254  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` 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 = 45113 AND t.round = 34 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` 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 = 39329 AND t.round = 34 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 `tables2017` 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 = 33980 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC