4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del TJK Legion Sub 17

Estadísticas

ENTRA
Artem Martseniuk9
Aleksei Anikin7
Martin Slavgorodski7
Devid Loberg6
B. Vasyl5
Krill Bogdanov4
Artjom Kravtsenko4
Ilja Djumin4
Sergei Igašev3
M. Tsistjakov3
Daniel Moškov3
Dmitri Prigoda2
Nikita Filyaev2
Artjom Tikhonov1
A. Zijazov1
Dmytro Poleiko1
Dmitry Spiridonov1
Denis Podberezski1
E. Zestjakov1
Artur Prasol1
SALE
Martin Slavgorodski6
Sergei Igašev5
M. Tsistjakov5
Pavel Sedjakin5
C. Nosach5
Aleksandr Komarov5
A. Jakovenko4
Matvei Bukatsjov4
Artjom Kravtsenko3
Aleksandr Blinov3
Artjom Krivonos3
M. Malosev2
Artjom Tikhonov2
Denis Podberezski2
Dmitry Spiridonov2
Lev Luzin2
A. Zijazov1
Krill Bogdanov1
E. Zestjakov1
Devid Loberg1
Dmitri Prigoda1
Ilja Djumin1
Andres Kippar1
Artur Prasol1

  USO DE MEMORIA  
4,668,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2475
Total Execution Time  0.2487
  CADENA URL  
/estadisticas/Tjk-Legion-Sub-17
  GET DATOS  
$_GET['/estadisticas/Tjk-Legion-Sub-17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=118305 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2096 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 = '118305' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = '118305' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '118305' and rp.type = 4
0.0127  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 = '118305' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 events2023 e ON e.player_id = p.id AND e.league_id = 71478 WHERE rp.league_id = 71478 AND rp.teamId = 118305 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.0134  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 events2023 e ON e.player_id = p.id AND e.league_id = 71478 WHERE rp.league_id = 71478 AND rp.teamId = 118305 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 events2023 e ON e.player_id = p.id AND e.league_id = 71478 WHERE rp.league_id = 71478 AND rp.teamId = 118305 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2023 e ON e.player_id = p.id AND e.league_id = 71478 WHERE rp.league_id = 71478 AND rp.teamId = 118305 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2023 e ON e.player_id = p.id AND e.league_id = 71478 WHERE rp.league_id = 71478 AND rp.teamId = 118305 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 events2023 e ON e.player_id = p.id AND e.league_id = 71478 WHERE rp.league_id = 71478 AND rp.teamId = 118305 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30