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

Estadísticas

ASISTENCIAS
Josip Brekalo7
E. Sahiti6
Marko Livaja4
Y. Benrahou4
Leon Dajaku3
V. Odjidja-Ofoe2
A. Trajkovski2
A. Kalik2
D. Mikanović1
Niko Sigur1
Fahd Moufi1
Ivan Dolček1
I. Diallo1
D. Melnjak1
L. Kleinheisler1
ENTRA
Leon Dajaku17
A. Kalik15
V. Odjidja-Ofoe14
Fahd Moufi11
Y. Benrahou9
A. Trajkovski8
L. Kleinheisler7
D. Mikanović7
Josip Elez7
Šimun Hrgović6
Filip Čuić6
Ivan Dolček6
N. Kalinić5
D. Prpic4
Ivan Perišić4
Tino Lauš3
E. Sahiti3
Mihael Zaper3
Niko Sigur2
Ferro2
I. Diallo2
Josip Brekalo2
Roko Brajković1
Jan Mlakar1
N. Skoko1
F. Krovinović1
Marko Livaja1
SALE
E. Sahiti26
F. Krovinović14
Niko Sigur10
Fahd Moufi10
Y. Benrahou10
Z. Šarlija8
A. Kalik8
V. Odjidja-Ofoe7
I. Diallo6
Leon Dajaku6
A. Trajkovski5
R. Pukštas4
Mihael Zaper4
Ivan Dolček4
Josip Elez3
N. Kalinić3
Marko Livaja3
F. Uremovic3
Jan Mlakar3
Josip Brekalo2
D. Melnjak2
Šimun Hrgović2
D. Mikanović2
L. Kleinheisler2
Roko Brajković1

  USO DE MEMORIA  
5,528,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.2482
Total Execution Time  0.2498
  CADENA URL  
/estadisticas/Hajduk-Split
  GET DATOS  
$_GET['/estadisticas/Hajduk-Split']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0167  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 = 'Hajduk-Split' 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.0134  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=9821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135  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=9821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0142  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 = '9821' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 events2024 e ON e.player_id = p.id AND e.league_id = 72109 WHERE rp.league_id = 72109 AND rp.teamId = 9821 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 72109 WHERE rp.league_id = 72109 AND rp.teamId = 9821 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 72109 WHERE rp.league_id = 72109 AND rp.teamId = 9821 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30