4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Litomericko
TEMPORADA 2018/2019
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Slavoj Vyšehrad Slavoj 33 68 31 70
2 Sokol Zápy Sokol Zápy 33 62 37 67
3 Loko Vltavin Loko Vltavin 32 67 38 63
4 Radotín Radotín 33 52 34 59
5 Jiskra Domažlice Jiskra 33 62 42 56
6 Litomericko Litomericko 33 45 50 49
7 Převýšov Převýšov 32 49 52 48
8 Dobrovice Dobrovice 32 47 42 46
9 Benešov Benešov 33 50 58 42
10 Sokol Živanice Sokol 33 40 45 41
11 Velvary Velvary 33 50 58 40
12 Ústí nad Orlicí Ústí 32 32 44 40
13 Povltavská FA Povltavská 32 48 58 39
14 Králův Dvůr Králův 33 46 44 35
15 Písek Písek 32 44 62 29
16 Karlovy Vary Karlovy Vary 32 41 62 27
17 Sokol Brozany Sokol 32 32 62 24
18 Viktorie Jirny Viktorie 9 3 19 5
TEMPORADA 2017/2018
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Chrudim Chrudim 34 89 26 76
2 Loko Vltavin Loko Vltavin 34 69 40 71
3 Sokol Zápy Sokol Zápy 34 57 39 67
4 Jiskra Domažlice Jiskra 34 92 58 60
5 Viktorie Jirny Viktorie 34 49 44 56
6 Benešov Benešov 34 50 41 54
7 Povltavská FA Povltavská 34 63 68 53
8 Převýšov Převýšov 34 60 53 52
9 Králův Dvůr Králův 34 52 59 52
10 Písek Písek 34 58 44 51
11 Ústí nad Orlicí Ústí 34 39 48 51
12 Dobrovice Dobrovice 34 47 44 46
13 Slavoj Vyšehrad Slavoj 34 54 59 43
14 Litomericko Litomericko 34 47 59 43
15 Benátky nad Jizerou Benátky 34 50 62 40
16 Sokol Brozany Sokol 34 58 72 40
17 Sokol Čížová Sokol 34 33 88 18
18 Polaban Nymburk Polaban 34 18 81 15
TEMPORADA 2016/2017
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Viktorie Jirny Viktorie 34 79 41 73
2 Olympia Hradec Králové Olympia 34 73 34 70
3 Loko Vltavin Loko Vltavin 34 77 53 68
4 Tachov Tachov 34 77 58 64
5 Králův Dvůr Králův 34 55 33 63
6 Chrudim Chrudim 34 61 38 62
7 Převýšov Převýšov 34 52 35 60
8 Povltavská FA Povltavská 34 58 53 57
9 Jiskra Domažlice Jiskra 34 62 54 51
10 Dobrovice Dobrovice 34 59 58 49
11 Sokol Zápy Sokol Zápy 34 68 54 48
12 Písek Písek 34 53 57 47
13 Slavoj Vyšehrad Slavoj 34 60 70 45
14 Benátky nad Jizerou Benátky 34 41 55 40
15 Litomericko Litomericko 34 39 65 40
16 Benešov Benešov 34 47 77 32
17 Táborsko II Táborsko 34 35 97 23
18 Hořovicko Hořovicko 34 21 85 13
TEMPORADA 2015/2016
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Lovosice Lovosice 30 61 31 62
2 Český Brod Český Brod 30 65 29 60
3 SK Kladno SK Kladno 30 63 32 56
4 Sokol Libiš Sokol Libiš 30 52 37 53
5 Meteor Praha Meteor Praha 30 57 38 47
6 Baník Souš Baník Souš 30 47 40 46
7 Neratovice-Byškovice Neratovice-B 30 44 43 44
8 Rakovník Rakovník 30 44 44 41
9 Chomutov Chomutov 30 45 45 40
10 Polaban Nymburk Polaban 30 31 37 39
11 Horní Měcholupy Horní 30 33 43 37
12 Úvaly Úvaly 30 48 54 36
13 Litomericko Litomericko 30 40 58 36
14 Vilémov Vilémov 30 31 63 25
15 Litvínov Litvínov 30 28 62 22
16 FK Louny FK Louny 30 32 65 20
TEMPORADA 2014/2015
4. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Lovosice Lovosice 30 71 31 58
2 Sokol Brozany Sokol 30 61 33 58
3 Neratovice-Byškovice Neratovice-B 30 53 31 56
4 Litomericko Litomericko 30 59 40 56
5 SK Kladno SK Kladno 30 58 37 49
6 Motorlet Praha Motorlet 30 58 34 48
7 Sokol Libiš Sokol Libiš 30 46 42 48
8 Horní Měcholupy Horní 30 44 41 46
9 Baník Souš Baník Souš 30 42 36 45
10 Nové Strašecí Nové 30 44 46 42
11 Úvaly Úvaly 30 35 39 41
12 Litol Litol 30 55 75 39
13 Nový Bor Nový Bor 30 39 61 38
14 Krupka Krupka 30 44 71 31
15 LoKo Chomutov LoKo 30 39 51 27
16 Slavoj Žatec Slavoj 30 27 107 10

  USO DE MEMORIA  
5,716,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1194
Total Execution Time  0.1207
  CADENA URL  
/historico/Litom-Ice
  GET DATOS  
$_GET['/historico/Litom-Ice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0066  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 = 44269
0.0051  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 = 44300
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30977 AND type_rel = 2
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0041  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 = '30977' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0043  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 = '30977' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035  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 = 44269 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0057  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 = 44300 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046  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=30977 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0028  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 (49506,44300,44269) 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.0041  SELECT count(id) as num_players from rel_players WHERE league_id = 44269 AND teamId = 30977
0.0059  SELECT count(id) as num_players from rel_players WHERE league_id = 44300 AND teamId = 30977
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 30977
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44269 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '30977' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30977' and rp.type = 4
0.0022  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 = '30977' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046  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 events2019 e ON e.player_id = p.id AND e.league_id = 44269 WHERE rp.league_id = 44269 AND rp.teamId = 30977 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.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 events2019 e ON e.player_id = p.id AND e.league_id = 44269 WHERE rp.league_id = 44269 AND rp.teamId = 30977 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2019 e ON e.player_id = p.id AND e.league_id = 44269 WHERE rp.league_id = 44269 AND rp.teamId = 30977 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 30977 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44269 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38899 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33704 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16000 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9184 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC