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
M. Anzam M. Anzam
S. Vega S. Vega
A. Bouassaba A. Bouassaba
H. Miralles H. Miralles
E. De Prados E. De Prados
F. Tomas F. Tomas
B. Maheta B. Maheta
M. González M. González
L. Iniesta L. Iniesta
S. Sabai S. Sabai
J. Manuel J. Manuel
B. Valencia B. Valencia
D. Rubio D. Rubio
Y. Zaghnoun Y. Zaghnoun
A. Jemia A. Jemia
Y. Ouamlouk Y. Ouamlouk
D. Azmanov D. Azmanov
M. Benataya M. Benataya
J. Sánchez J. Sánchez
A. Navarro A. Navarro
A. Clemente A. Clemente
J. Cruz J. Cruz
A. Franco A. Franco
L. Vera L. Vera
D. Galeano D. Galeano
C. Nicolas C. Nicolas 27 años 185cm 70kg POR
Toni Toni 25 años POR
N. Chehab N. Chehab POR
Caste Caste 23 años DEF
E. Mendez E. Mendez DEF
Víctor Manuel Víctor Manuel 17 años 173cm 74kg DEF
J. Luis J. Luis DEF
Cristóbal Soto Cristóbal Soto 21 años DEF
M. Martínez M. Martínez 22 años DEF
Nono Nono 30 años DEF
Abraham Abraham 30 años DEF
A. Viveros A. Viveros 26 años DEF
J. Ríos J. Ríos MED
M. Minguela M. Minguela MED
Sebastián Sebastián 21 años MED
Carlitos Almada Carlitos Almada MED
M. Santiago M. Santiago 23 años 175cm 75kg MED
R. Hernández R. Hernández MED
Á. Sánchez Á. Sánchez MED
Alberto Mayol Alberto Mayol 26 años 168cm MED
J. Vega J. Vega MED
I. Fernandez I. Fernandez 21 años MED
Roberto Roberto 24 años MED
A. Nahuel A. Nahuel MED
B. Jesus B. Jesus DEL
A. Lorenzo A. Lorenzo DEL
Estupinán Estupinán 21 años DEL
Kevin Garces Kevin Garces 23 años DEL
S. Jimenez S. Jimenez DEL
Paredes Paredes DEL
Monas Monas 24 años DEL
Achraf Lhaoui Achraf Lhaoui 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 Juvenia Juvenia 27 58 34 58
4 CD Zeneta CD Zeneta 27 52 23 57
5 EF Alhama EF Alhama 27 51 23 54
6 Deportivo Murcia Deportivo 27 59 28 51
7 UD Alberca UD Alberca 27 49 46 44
8 San Gines de La Jara Gines Jara 27 50 50 40
9 CD Alberca CD Alberca 27 61 50 39
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 67 19
14 EF Dolores de Pacheco Dolores 27 28 63 18
15 Deportivo Huracán Deportivo 27 22 59 16
16 Club Futbol Base H-O Club Futbol 27 21 106 8

  USO DE MEMORIA  
7,357,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1268
Total Execution Time  0.1286
  CADENA URL  
/primera_regional_murcia2024/grupo1/jugadores
  GET DATOS  
$_GET['/primera_regional_murcia2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0021  SELECT type FROM routes WHERE alias = 'primera_regional_murcia2024'
0.0051  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.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1454 AND type_rel = 3
0.0040  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.0036  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.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1454 ORDER BY order_id ASC
0.0024  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.0025  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.0185  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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 21:46:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 21:46:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 21:46:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 21:46:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  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.0184  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.0036  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.0042  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 = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC