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

Clasificación

Equipo PJ GF GC Puntos
1 Lorca Deportiva B Lorca 26 66 19 62
2 CD Lumbreras Lumbreras 26 72 19 59
3 Juvenia Juvenia 26 57 34 55
4 CD Zeneta CD Zeneta 26 47 23 54
5 EF Alhama EF Alhama 26 47 23 51
6 Deportivo Murcia Deportivo 26 59 25 51
7 UD Alberca UD Alberca 26 47 45 41
8 CD Alberca CD Alberca 26 61 45 39
9 San Gines de La Jara Gines Jara 26 48 49 37
10 AD Palmeral AD Palmeral 26 42 41 31
11 Roldan AD Roldan AD 26 42 60 25
12 Alcantarilla FC B Alcantarilla 26 41 62 20
13 CFB Totana CFB Totana 26 32 66 19
14 EF Dolores de Pacheco Dolores 26 28 61 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,340,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3371
Total Execution Time  0.3391
  CADENA URL  
/primera_regional_murcia2024/grupo1/jugadores
  GET DATOS  
$_GET['/primera_regional_murcia2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0252  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1454 ORDER BY order_id ASC
0.0126  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.0291  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0237  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.0364  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.0146  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.0201  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