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

Estadísticas

ASISTENCIAS
A. Aouchiche5
D. Bouanga4
Arnaud Nordin4
M. Camara2
Charles Abi2
M. Trauco2
Yvan Neyou2
R. Boudebouz1
R. Hamouma1
Y. Macon1
Mathieu Debuchy1
Z. Youssouf1
Wahbi Khazri1
H. Moukoudi1
ENTRA
L. Gourna-Douath16
M. Rivera15
Charles Abi15
Z. Youssouf15
A. Aouchiche13
A. Moueffek13
Arnaud Nordin12
R. Hamouma10
K. Monnet-Paquet9
R. Boudebouz7
Wahbi Khazri6
D. Bouanga6
Saidou Sow5
M. Trauco4
J. Krasso4
A. Modeste4
T. Tormin3
A. Sissoko3
B. Benkhedim2
Yvan Neyou2
M. Saban1
A. Dioussé1
Yann M'vila1
R. Souici1
W. Fofana1
Y. Lhery1
A. Coulibaly1
Mathieu Debuchy1
M. Tshibuabua1
T. Kolodziejczak1
SALE
Arnaud Nordin19
D. Bouanga19
A. Aouchiche19
Wahbi Khazri16
Yvan Neyou15
Z. Youssouf12
R. Hamouma12
Charles Abi8
L. Gourna-Douath7
K. Monnet-Paquet7
R. Boudebouz6
Mathieu Debuchy5
M. Camara4
M. Trauco3
A. Modeste3
A. Moueffek3
P. Retsos2
T. Kolodziejczak2
A. Sissoko2
B. Gabard2
J. Krasso2
Saidou Sow1
Gabriel Silva1
Y. Macon1
M. Rivera1
B. Benkhedim1
H. Moukoudi1

  USO DE MEMORIA  
5,387,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0650
Total Execution Time  0.0663
  CADENA URL  
/estadisticas/Saint-Etienne/2021
  GET DATOS  
$_GET['/estadisticas/Saint-Etienne/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0045  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 = 'Saint-Etienne' AND l.year = 2021 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.0019  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=2203 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2203 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2203 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2203 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0069  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 = '2203' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0045  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 events2021 e ON e.player_id = p.id AND e.league_id = 56825 WHERE rp.league_id = 56825 AND rp.teamId = 2203 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0047  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 events2021 e ON e.player_id = p.id AND e.league_id = 56825 WHERE rp.league_id = 56825 AND rp.teamId = 2203 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 events2021 e ON e.player_id = p.id AND e.league_id = 56825 WHERE rp.league_id = 56825 AND rp.teamId = 2203 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30