4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
47 jugadores
Mollet Mollet
I. Liñan I. Liñan
C. Ortiz C. Ortiz
I. Fernandez I. Fernandez
P. Cabrera P. Cabrera
B. Polo B. Polo 26 años
Jean Cortes Jean Cortes
A. Pons A. Pons
D. Martínez D. Martínez
V. Silvestre V. Silvestre
A. Castro A. Castro
V. Grande V. Grande
E. Hinestroza E. Hinestroza
J. Spitia J. Spitia
K. Kyrylo K. Kyrylo
Michael Cabrera Michael Cabrera
N. Krasic N. Krasic
M. Viver M. Viver
M. Machado M. Machado
J. C. Carrillo J. C. Carrillo
D. Garcia D. Garcia
I. Benhamnon I. Benhamnon
C. Rueda C. Rueda
Iván García Iván García POR
Juanma Juanma 34 años POR
A. Medina A. Medina POR
F. Gimenez F. Gimenez DEF
D. Garcia D. Garcia DEF
Calvo Calvo 22 años DEF
G. Contreras G. Contreras 23 años 174cm 73kg DEF
M. Rodirguez M. Rodirguez 18 años DEF
Sekhou Sekhou DEF
Adria Balagua Adria Balagua DEF
A. Varese A. Varese DEF
D. Guillén D. Guillén 23 años 175cm 62kg MED
Corzo Corzo 28 años MED
Fábregas Fábregas 25 años 179cm 67kg MED
R. Castellvell R. Castellvell MED
P. Ortega P. Ortega 20 años MED
Xavi Torres Xavi Torres 29 años MED
I. Marcano I. Marcano MED
Gonzalo Carmona Gonzalo Carmona 30 años 185cm DEL
D. Castro D. Castro 27 años DEL
Adrian Martinez Adrian Martinez DEL
S. Estrada S. Estrada 28 años DEL
Aaron Reinon Aaron Reinon 23 años DEL
B. Danjo B. Danjo DEL
I. Sadio I. Sadio 17 años DEL
31 jugadores
Bescanó Bescanó
C. Caparros C. Caparros
J. Pàmies J. Pàmies
Paneque Paneque 30 años
N. Genoher N. Genoher
M. Gumaneh M. Gumaneh
M. Losilla M. Losilla
G. Artero G. Artero
Musa Musa
L. Servellon L. Servellon
J. Tarrenchs J. Tarrenchs
E. Touray E. Touray
M. Ciurana M. Ciurana
A. Tarres A. Tarres
L. Guiteras L. Guiteras
S. Gonzalez S. Gonzalez
O. Carreras O. Carreras
J. Quer J. Quer
Mario Mendoza Mario Mendoza 22 años POR
Pol Tarrenchs Pol Tarrenchs 27 años DEF
R. Gómez R. Gómez DEF
P. Castell P. Castell 24 años DEF
C. Puig C. Puig 26 años DEF
Toni Gamell Toni Gamell 25 años DEF
Pep Piany Pep Piany 24 años MED
I. Pérez I. Pérez MED
Brice Brice 35 años MED
Alexis Sánchez Alexis Sánchez 33 años MED
J. Turón J. Turón 26 años MED
Biel Biel 26 años MED
Zaka Zaka 23 años DEL
A. Feixas A. Feixas 33 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Manlleu Manlleu 26 52 27 58
2 Argentona Argentona 26 41 24 49
3 Caldes Montbui Caldes 26 40 31 42
4 Tossa Tossa 26 45 39 39
5 Bescanó Bescanó 26 51 45 38
6 Montcada Montcada 26 43 36 37
7 Can Gibert Can Gibert 26 33 28 37
8 Mollet Mollet 26 40 39 36
9 Parets Parets 26 31 27 35
10 Banyoles Banyoles 26 41 39 35
11 Roses Roses 26 39 47 35
12 Cardedeu Cardedeu 26 26 37 30
13 Blanes Blanes 26 32 47 30
14 EF Bosc de Tosca Bosc Tosca 26 35 51 25
15 Mataró Mataró 26 36 43 23
16 Begur Begur 26 30 55 21

  USO DE MEMORIA  
7,347,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3846
Total Execution Time  0.3866
  CADENA URL  
/primera_catalana2024/grupo1/jugadores
  GET DATOS  
$_GET['/primera_catalana2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_catalana' 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.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=75 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 75 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0132  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 (1231079,1220404,1167252,1146026,1139448) ORDER BY n.cover_points DESC, update_date DESC
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=75 ORDER BY order_id ASC
0.0132  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 = 72878 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72878 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0422  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 = 72878 AND dt.id IN (1639,424,6090,18289,18483,18141,18502,18178,18133,18179,18517,18151,18382,18143,18490,21230) ORDER BY dt.relations DESC,dp.role ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 16:22:00' 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-05-03 16:22:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 16:22:00' 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-05-03 16:22:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0203  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 = 72878 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72878 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.0279  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 = 72878 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72878 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 = 72878 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72878 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0182  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 = 72878 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