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

Pribram

Entrenador: Roman Bednar

Temporada 2023/2024

Estadísticas

ASISTENCIAS
J. Husbauer5
E. Antwi3
Vaclav Dudl3
David Krch2
F. Matousek1
R. Jandera1
Jan Vokrinek1
Ondřej Novotný1
Michal Hosek1
Emmanuel Anih1
Pavel Hasek1
Felix Čejka1
ENTRA
David Krch12
T. Andronikou12
Vinny Nkwinga11
Emmanuel Anih11
Jan Vokrinek10
Jan Brabec9
Ondřej Novotný8
R. Jandera8
J. Hudec5
Felix Čejka4
F. Matousek4
Matyas Conk3
Csaba Biricz3
N. Fall3
E. Antwi3
N. Sunzu3
Michal Hosek3
Pavel Hasek2
T. Wagner2
Patrik Svestka1
Dominik Vott1
V. Jelinek1
J. Necas1
Vojtech Gornicky1
M. Babka1
SALE
J. Necas15
Vaclav Dudl11
David Krch9
Vinny Nkwinga9
N. Sunzu8
Patrik Svestka6
R. Jandera6
J. Husbauer5
Pavel Hasek5
Jan Vokrinek5
T. Andronikou4
Dominik Vott4
E. Antwi4
Felix Čejka4
Ondřej Novotný4
F. Matousek3
Matyas Conk2
N. Fall2
Michal Hosek2
Jan Brabec2
Emmanuel Anih2
Vojtech Hora1
T. Wagner1
J. Hudec1
D. Fisl1
Csaba Biricz1
M. Melichar1

  USO DE MEMORIA  
5,209,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1039
Total Execution Time  0.1053
  CADENA URL  
/estadisticas/P-Ibram
  GET DATOS  
$_GET['/estadisticas/P-Ibram']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10048 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10048 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0030  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (59209,69600,71127,536476,729613) ORDER BY n.cover_points DESC, update_date DESC
0.0059  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 = '10048' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030  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 = 72248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0068  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=10048 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024  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 (72506,72248,71877,71432) 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.0055  SELECT count(id) as num_players from rel_players WHERE league_id = 72248 AND teamId = 10048
0.0066  SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 10048
0.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 71877 AND teamId = 10048
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10048
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10048' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10048' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10048' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10048 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.0035  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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10048 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10048 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10048 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10048 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10048 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30