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

Estadísticas

ENTRA
Luca Magazzú11
D. Villa11
Valentino Soplantai9
D. Magonara8
L. Rizzo6
M. Righetti6
Tommaso Sanguineti6
Giacomo Avellino4
Yves Vianson4
Tommaso Suarato4
Ray Omoregbe4
Giovanbattista Romanengo4
Giorgio Lionetti3
Lorenzo Trocino3
Tommaso Garrone3
Lombardi2
F. Masini2
M. Cericola2
Nicola Mulattieri2
G. Kruhs1
N. Marcellusi1
Mattia Giammaresi1
Samuele Scremin1
Davide Ghigliotti1
Alessandro Bitti1
Michele Lupinacci1
D. Vannucci1
SALE
Giorgio Lionetti11
Tommaso Sanguineti10
Giovanbattista Romanengo9
Lombardi8
Tommaso Suarato8
Luca Magazzú7
M. Righetti7
Tommaso Garrone4
Valentino Soplantai4
G. Kruhs3
Davide Ghigliotti3
Michele Lupinacci3
M. Cericola3
D. Villa3
F. Masini3
M. Berardi3
D. Vannucci2
L. Rizzo2
Mattia Giammaresi2
N. Marcellusi2
D. Magonara2
Lorenzo Ferraro1
Samuele Scremin1
Nicola Mulattieri1

  USO DE MEMORIA  
5,137,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2433
Total Execution Time  0.2453
  CADENA URL  
/estadisticas/lavagnese
  GET DATOS  
$_GET['/estadisticas/lavagnese']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0127  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'lavagnese' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0109  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0220  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 = 73979
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6849 AND type_rel = 2
0.0118  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 = '6849' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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 = 73979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 events2024 e ON e.player_id = p.id AND e.league_id = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 6849 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 events2024 e ON e.player_id = p.id AND e.league_id = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 6849 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 events2024 e ON e.player_id = p.id AND e.league_id = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 6849 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30