4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Estadísticas

ASISTENCIAS
Hugo5
Bombarda5
Erwin Koen3
E. Koeman2
Raymond Beerens2
Harris Huizingh2
Patrick Ax1
Melchior Schoenmakers1
Sander Van Gessel1
Paul Matthijs1
Magno1
Raymond Atteveld1
Marcel Peeper1
Leonardo Dos Santos1
ENTRA
Paul Matthijs12
Erwin Koen11
Mattias Rosén7
Sander Van Gessel6
Bombarda5
Sergio Ommel4
Mario Rodriguez4
Toine Rorije3
Leonardo Dos Santos3
Zephnad Wattimury3
J. Broerse2
Björn Schilder2
Melchior Schoenmakers2
Egbert Darwinkel2
Magno2
Marcel Peeper1
Patrick Ax1
Raymond Beerens1
Jeffrey Kooistra1
SALE
E. Koeman9
Hugo9
Bombarda9
Magno7
Toine Rorije6
Erwin Koen4
Mattias Rosén3
Leonardo Dos Santos3
Sander Van Gessel3
Marcel Peeper2
Raymond Atteveld2
Jan-Hendrik Veenhof2
Melchior Schoenmakers2
Patrick Lodewijks2
Harris Huizingh2
Björn Schilder1
Patrick Ax1
Mario Rodriguez1
Paul Matthijs1
K. Elshot1
Sergio Ommel1
Raymond Beerens1

  USO DE MEMORIA  
5,420,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4300
Total Execution Time  0.4312
  CADENA URL  
/estadisticas/Fc-Groningen/1998
  GET DATOS  
$_GET['/estadisticas/Fc-Groningen/1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0263  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 183
0.0153  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74913
0.0135  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74914
0.0132  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 12046
0.0138  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1068' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 183 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 12046 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74913 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1068 AND l.year in (1997,1998,1999) ORDER BY l.id DESC, l.year DESC ;
0.0130  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74930,13386,12064,184) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 184 AND teamId = 1068
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 13386 AND teamId = 1068
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 74930 AND teamId = 1068
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 12064 AND teamId = 1068
0.0142  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1998` 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 = 183 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0212  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1998 e ON e.player_id = p.id AND e.league_id = 183 WHERE rp.league_id = 183 AND rp.teamId = 1068 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0195  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1998 e ON e.player_id = p.id AND e.league_id = 183 WHERE rp.league_id = 183 AND rp.teamId = 1068 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0207  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1998 e ON e.player_id = p.id AND e.league_id = 183 WHERE rp.league_id = 183 AND rp.teamId = 1068 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0232  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1998 e ON e.player_id = p.id AND e.league_id = 183 WHERE rp.league_id = 183 AND rp.teamId = 1068 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1998 e ON e.player_id = p.id AND e.league_id = 183 WHERE rp.league_id = 183 AND rp.teamId = 1068 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1998 e ON e.player_id = p.id AND e.league_id = 183 WHERE rp.league_id = 183 AND rp.teamId = 1068 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30