4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Hadera Sub 19

Estadísticas

ENTRA
Shalev Vazan12
A. Yehuda10
Noam Pirka10
Shadi Hasdiya9
Shalev Valgrshtein9
Y. Dahan9
Yosef Shadafni8
Sif Halabi7
Almog Yamaran7
Maxim Kandman6
A. Slutzky6
D. Eytam6
B. Andarge5
Roi Peretz5
Liam Aluk5
Ori Alfasi5
O. Ben Dor4
I. Avitan4
A. Dahesh4
Andrew Kharoufy3
T. Ziziashvili3
Raz Airshenzon3
Ohad Zluf2
Omer Khaled2
Roee Meir1
Michael Eylon1
Shalev Gabizon1
SALE
Liam Aluk12
A. Yehuda10
T. Ziziashvili10
N. Shemesh9
Ori Alfasi8
Raz Airshenzon7
Almog Yamaran7
B. Andarge6
R. Shvartz6
O. Alklay4
D. Eytam4
R. Shalem4
Liam Ohayon4
Roi Peretz4
Shalev Valgrshtein3
Shalev Vazan3
Eran Feldman2
Sif Halabi2
A. Dahesh2
Adam Amir2
Y. Dahan2
Shadi Hasdiya2
Eyal Zevdia2
Maxim Kandman2
I. Avitan2
Yosef Shadafni1
Bashar Abdach1
Omer Khaled1
Ohad Zluf1
A. Slutzky1

  USO DE MEMORIA  
4,828,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2150
Total Execution Time  0.2170
  CADENA URL  
/estadisticas/Hapoel-Hadera-Sub20
  GET DATOS  
$_GET['/estadisticas/Hapoel-Hadera-Sub20']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0252  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 = 73243
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119759 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1557 AND type_rel = 3
0.0127  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 = '119759' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73243 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 119759 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 119759 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0177  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 119759 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30