4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
57 jugadores
Deportivo Murcia Deportivo Murcia
J. Cruz J. Cruz
A. Clemente A. Clemente
L. Iniesta L. Iniesta
D. Galeano D. Galeano
A. Franco A. Franco
L. Vera L. Vera
M. Anzam M. Anzam
S. Vega S. Vega
H. Miralles H. Miralles
A. Bouassaba A. Bouassaba
B. Maheta B. Maheta
E. De Prados E. De Prados
F. Tomas F. Tomas
M. González M. González
S. Sabai S. Sabai
J. Manuel J. Manuel
B. Valencia B. Valencia
A. Jemia A. Jemia
Y. Ouamlouk Y. Ouamlouk
D. Rubio D. Rubio
Y. Zaghnoun Y. Zaghnoun
D. Azmanov D. Azmanov
M. Benataya M. Benataya
J. Sánchez J. Sánchez
A. Navarro A. Navarro
Toni Toni 25 años POR
C. Nicolas C. Nicolas 27 años 185cm 70kg POR
N. Chehab N. Chehab POR
Abraham Abraham 30 años DEF
Caste Caste 23 años DEF
J. Luis J. Luis DEF
Cristóbal Soto Cristóbal Soto 21 años DEF
Víctor Manuel Víctor Manuel 17 años 173cm 74kg DEF
Nono Nono 30 años DEF
A. Viveros A. Viveros 26 años DEF
M. Martínez M. Martínez 22 años DEF
E. Mendez E. Mendez DEF
J. Ríos J. Ríos MED
Carlitos Almada Carlitos Almada MED
Á. Sánchez Á. Sánchez MED
Sebastián Sebastián 21 años MED
M. Santiago M. Santiago 23 años 175cm 75kg MED
I. Fernandez I. Fernandez 21 años MED
R. Hernández R. Hernández MED
Roberto Roberto 24 años MED
A. Nahuel A. Nahuel MED
Alberto Mayol Alberto Mayol 26 años 168cm MED
J. Vega J. Vega MED
M. Minguela M. Minguela MED
A. Lorenzo A. Lorenzo DEL
S. Jimenez S. Jimenez DEL
Estupinán Estupinán 21 años DEL
Kevin Garces Kevin Garces 23 años DEL
B. Jesus B. Jesus DEL
Achraf Lhaoui Achraf Lhaoui DEL
Paredes Paredes DEL
Monas Monas 24 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Lorca Deportiva B Lorca 27 69 19 65
2 CD Lumbreras Lumbreras 27 75 21 62
3 CD Zeneta CD Zeneta 27 52 23 57
4 Juvenia Juvenia 27 57 34 56
5 EF Alhama EF Alhama 26 47 23 51
6 Deportivo Murcia Deportivo 27 59 28 51
7 UD Alberca UD Alberca 27 49 46 44
8 CD Alberca CD Alberca 27 61 50 39
9 San Gines de La Jara Gines Jara 26 48 49 37
10 AD Palmeral AD Palmeral 27 44 44 31
11 Roldan AD Roldan AD 27 43 62 25
12 Alcantarilla FC B Alcantarilla 27 43 62 23
13 CFB Totana CFB Totana 27 32 66 20
14 EF Dolores de Pacheco Dolores 27 28 63 18
15 Deportivo Huracán Deportivo 26 22 55 16
16 Club Futbol Base H-O Club Futbol 26 20 104 8

  USO DE MEMORIA  
7,369,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3561
Total Execution Time  0.3581
  CADENA URL  
/primera_regional_murcia2024/grupo1/jugadores
  GET DATOS  
$_GET['/primera_regional_murcia2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0105  SELECT type FROM routes WHERE alias = 'primera_regional_murcia2024'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_murcia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1454 AND type_rel = 3
0.0110  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1454 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (999350,275156) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1454 ORDER BY order_id ASC
0.0107  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73793 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73793 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0272  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 73793 AND dt.id IN (10552,58757,10545,58754,103060,112660,66440,153008,122320,153006,153007,152996,153002,153003,153005,152657) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 04:46:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 04:46:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 04:46:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 04:46:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_murcia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0233  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73793 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73793 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0384  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73793 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73793 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0130  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73793 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73793 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  SELECT *,(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 = 73793 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC