4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
36 jugadores
Quart de Les Valls Quart Valls
J. Salas J. Salas
J. Largacha J. Largacha
J. Ávila J. Ávila
J. William J. William
I. Dos I. Dos
B. Yaira B. Yaira
Z. Edegar Z. Edegar
R. Gaspar R. Gaspar
S. Hardy S. Hardy
S. Moutawafiq S. Moutawafiq
D. Anguix D. Anguix
L. Nicolas L. Nicolas
I. El I. El
N. Lozano N. Lozano
M. Clyde M. Clyde
N. Dueñas N. Dueñas
N. John N. John
S. Pérez S. Pérez
C. Pascual C. Pascual 26 años POR
Claudio Pardo Claudio Pardo 20 años POR
A. Lopez A. Lopez DEF
A. Cerezo A. Cerezo DEF
A. Marco A. Marco 29 años MED
D. Jiménez D. Jiménez 21 años MED
V. Segarra V. Segarra 28 años MED
D. Sebastian D. Sebastian 21 años MED
I. Beta I. Beta MED
Jose Torrente Jose Torrente MED
S. Villalba S. Villalba MED
Borja Quirant Borja Quirant 28 años 184cm 75kg MED
S. Pandura S. Pandura 22 años MED
Sergio Martinez Sergio Martinez 25 años MED
K. Ben K. Ben DEL
Youris Elias Youris Elias 19 años DEL
Juan Peleran Juan Peleran 24 años 178cm 85kg DEL
Bosch Bosch 31 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Paterna CF Paterna CF 26 46 23 53
2 Odisea FC Odisea FC 26 40 19 50
3 Mare Nostrum Puerto Sagunto Mare Nostrum 25 40 23 43
4 Moncofa Moncofa 26 41 28 41
5 CD Roda B CD Roda B 27 39 36 39
6 Quart de Les Valls Quart Valls 27 56 41 38
7 Benicarló Benicarló 26 44 38 37
8 Cabanes Cabanes 27 38 41 37
9 CF Albuixech Albuixech 26 33 36 35
10 Nules Nules 26 30 47 33
11 Vinaròs Vinaròs 26 45 55 32
12 CF Alcalá CF Alcalá 26 55 45 30
13 Ibarsos Ibarsos 25 30 52 28
14 C.F San Pedro Pedro 25 23 37 28
15 Tavernes Blanques CF Tavernes 25 33 45 26
16 Puzol Puzol 27 44 71 25

  USO DE MEMORIA  
7,376,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2371
Total Execution Time  0.2391
  CADENA URL  
/valenciana2024/grupo1/jugadores
  GET DATOS  
$_GET['/valenciana2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT type FROM routes WHERE alias = 'valenciana2024'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'valenciana' 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 id,name,alias,stepParent FROM categories WHERE parentId=6 ORDER BY order_id ASC
0.0020  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 = 73769 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73769 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0127  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 = 73769 AND dt.id IN (2726,468,1934,1831,10152,9225,6094,46000,45996,46039,46002,83486,113079,122166,11974,139071) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 15:18:30' 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-28 15:18:30' 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-28 15:18:30' 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-28 15:18:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0422  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 = 73769 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73769 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.1029  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 = 73769 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73769 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0143  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 = 73769 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73769 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052  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 = 73769 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