4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Slavia Praha Sub 19 Slavia Praha 30 73 29 64
2 Sparta Praha Sub 19 Sparta Praha 30 62 24 62
3 Karvina Sub 19 Karvina 30 53 35 55
4 Pardubice Sub 19 Pardubice 30 46 34 55
5 Baník Ostrava Sub 19 Baník 30 59 34 53
6 Viktoria Plzeň Sub 19 Viktoria 30 56 36 50
7 Sigma Olomouc Sub 19 Sigma 30 58 33 46
8 Zbrojovka Brno Sub 19 Zbrojovka 30 68 45 45
9 České Budějovice Sub 19 České 30 44 50 45
10 Mladá Boleslav Sub 19 Mladá 30 45 49 39
11 Hradec Králové Sub 19 Hradec 30 38 57 39
12 Zlín Sub 19 Zlín 30 54 60 38
13 Slovácko Sub 19 Slovácko 30 40 47 33
14 Příbram Sub 19 Příbram 30 40 88 25
15 Meteor Praha Sub 19 Meteor Praha 30 35 87 18
16 Opava Sub 19 Opava 30 20 83 11
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Sparta Praha Sub 19 Sparta Praha 7 25 5 19
2 Slavia Praha Sub 19 Slavia Praha 8 25 14 18
3 Zlín Sub 19 Zlín 9 17 6 15
4 České Budějovice Sub 19 České 8 21 14 15
5 Viktoria Plzeň Sub 19 Viktoria 8 14 10 14
6 Pardubice Sub 19 Pardubice 6 14 8 13
7 Sigma Olomouc Sub 19 Sigma 7 11 14 13
8 Mladá Boleslav Sub 19 Mladá 7 15 12 11
9 Baník Ostrava Sub 19 Baník 7 18 18 11
10 Zbrojovka Brno Sub 19 Zbrojovka 6 12 12 9
11 Slovácko Sub 19 Slovácko 8 14 16 9
12 Hradec Králové Sub 19 Hradec 8 9 10 8
13 Příbram Sub 19 Příbram 8 11 21 5
14 Opava Sub 19 Opava 6 8 16 4
15 Karvina Sub 19 Karvina 7 3 21 1
16 Meteor Praha Sub 19 Meteor Praha 6 6 26 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Sparta Praha Sub 19 Sparta Praha 18 64 14 46
2 Slavia Praha Sub 19 Slavia Praha 19 58 25 43
3 Sigma Olomouc Sub 19 Sigma 18 51 28 35
4 Viktoria Plzeň Sub 19 Viktoria 18 31 19 35
5 Baník Ostrava Sub 19 Baník 18 41 24 34
6 Zbrojovka Brno Sub 19 Zbrojovka 18 34 30 32
7 Slovácko Sub 19 Slovácko 18 27 28 26
8 Hradec Králové Sub 19 Hradec 18 30 30 24
9 Příbram Sub 19 Příbram 18 32 36 23
10 Pardubice Sub 19 Pardubice 18 28 32 22
11 Opava Sub 19 Opava 19 26 43 18
12 Mladá Boleslav Sub 19 Mladá 18 27 50 16
13 Zlín Sub 19 Zlín 18 27 41 14
14 České Budějovice Sub 19 České 18 18 37 14
15 Karvina Sub 19 Karvina 18 18 41 14
16 Meteor Praha Sub 19 Meteor Praha 18 24 58 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Sparta Praha Sub 19 Sparta Praha 28 61 29 55
2 Slavia Praha Sub 19 Slavia Praha 28 61 34 53
3 Zbrojovka Brno Sub 19 Zbrojovka 28 64 47 51
4 Sigma Olomouc Sub 19 Sigma 28 54 37 51
5 Hradec Králové Sub 19 Hradec 28 46 39 48
6 Příbram Sub 19 Příbram 28 45 41 48
7 Zlín Sub 19 Zlín 28 45 32 42
8 Baník Ostrava Sub 19 Baník 28 50 50 42
9 Viktoria Plzeň Sub 19 Viktoria 28 59 52 39
10 České Budějovice Sub 19 České 28 34 47 38
11 Pardubice Sub 19 Pardubice 28 32 32 33
12 Karvina Sub 19 Karvina 28 38 49 32
13 Slovácko Sub 19 Slovácko 28 38 55 27
14 Mladá Boleslav Sub 19 Mladá 28 27 52 26
15 Dukla Praha Sub 19 Dukla Praha 28 43 72 23
16 Vysočina Jihlava Sub 19 Vysočina 28 29 58 23
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Zbrojovka Brno Sub 19 Zbrojovka 34 87 34 81
2 Sparta Praha Sub 19 Sparta Praha 34 95 32 80
3 Sigma Olomouc Sub 19 Sigma 34 96 32 76
4 Viktoria Plzeň Sub 19 Viktoria 34 97 57 65
5 Pardubice Sub 19 Pardubice 34 49 40 61
6 Slavia Praha Sub 19 Slavia Praha 34 78 53 55
7 Příbram Sub 19 Příbram 34 44 52 49
8 Hradec Králové Sub 19 Hradec 34 57 55 48
9 Slovácko Sub 19 Slovácko 34 58 60 48
10 Karvina Sub 19 Karvina 34 46 62 48
11 Zlín Sub 19 Zlín 34 67 62 47
12 Baník Ostrava Sub 19 Baník 34 57 62 44
13 Teplice Sub 19 Teplice 34 58 55 41
14 České Budějovice Sub 19 České 34 48 66 41
15 Mladá Boleslav Sub 19 Mladá 34 44 55 39
16 Bohemians 1905 Sub 19 Bohemians 34 41 83 26
17 Opava Sub 19 Opava 34 40 91 20
18 Frýdek-Místek Sub 19 Frýdek-Mís 34 26 137 20
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sparta Praha Sub 19 Sparta Praha 34 79 44 75
2 Hradec Králové Sub 19 Hradec 34 64 40 69
3 Viktoria Plzeň Sub 19 Viktoria 34 63 46 68
4 Slavia Praha Sub 19 Slavia Praha 34 83 51 65
5 Baník Ostrava Sub 19 Baník 34 65 52 55
6 Příbram Sub 19 Příbram 34 53 44 55
7 Sigma Olomouc Sub 19 Sigma 34 71 56 53
8 Mladá Boleslav Sub 19 Mladá 34 48 46 50
9 České Budějovice Sub 19 České 34 49 57 50
10 Pardubice Sub 19 Pardubice 34 52 41 48
11 Zbrojovka Brno Sub 19 Zbrojovka 34 80 76 47
12 Karvina Sub 19 Karvina 34 43 56 47
13 Zlín Sub 19 Zlín 34 46 46 45
14 Teplice Sub 19 Teplice 34 52 58 45
15 Slovácko Sub 19 Slovácko 34 49 57 45
16 Vysočina Jihlava Sub 19 Vysočina 34 44 59 43
17 Opava Sub 19 Opava 34 43 58 41
18 Hlučín Sub 19 Hlučín 34 32 129 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sparta Praha Sub 19 Sparta Praha 38 129 38 90
2 Příbram Sub 19 Příbram 38 81 52 67
3 Slovácko Sub 19 Slovácko 38 62 49 59
4 Zbrojovka Brno Sub 19 Zbrojovka 38 63 61 59
5 Hradec Králové Sub 19 Hradec 38 57 50 57
6 Baník Ostrava Sub 19 Baník 38 72 60 56
7 Viktoria Plzeň Sub 19 Viktoria 38 63 63 55
8 Karvina Sub 19 Karvina 38 54 58 53
9 České Budějovice Sub 19 České 38 56 59 52
10 Teplice Sub 19 Teplice 38 50 61 52
11 Vysočina Jihlava Sub 19 Vysočina 38 48 53 51
12 Mladá Boleslav Sub 19 Mladá 38 42 49 51
13 Sigma Olomouc Sub 19 Sigma 38 65 55 50
14 Opava Sub 19 Opava 38 52 65 49
15 Slavia Praha Sub 19 Slavia Praha 38 56 64 47
16 Zlín Sub 19 Zlín 38 51 59 46
17 Slovan Liberec Sub 19 Slovan 38 33 61 46
18 Pardubice Sub 19 Pardubice 38 54 69 45
19 Bohemians 1905 Sub 19 Bohemians 38 49 66 44
20 Jablonec Sub 19 Jablonec 38 34 79 35
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Příbram Sub 19 Příbram 42 119 40 101
2 Sparta Praha Sub 19 Sparta Praha 42 90 40 84
3 Karvina Sub 19 Karvina 42 77 48 79
4 Slavia Praha Sub 19 Slavia Praha 42 88 55 77
5 Vysočina Jihlava Sub 19 Vysočina 42 80 68 69
6 Sigma Olomouc Sub 19 Sigma 42 75 47 68
7 České Budějovice Sub 19 České 42 69 67 66
8 Slovácko Sub 19 Slovácko 42 69 58 65
9 Zbrojovka Brno Sub 19 Zbrojovka 42 65 53 62
10 Pardubice Sub 19 Pardubice 42 60 63 62
11 Viktoria Plzeň Sub 19 Viktoria 42 93 76 61
12 Baník Ostrava Sub 19 Baník 42 96 84 61
13 Mladá Boleslav Sub 19 Mladá 42 75 66 58
14 Slovan Liberec Sub 19 Slovan 42 67 75 55
15 Jablonec Sub 19 Jablonec 42 62 77 55
16 Bohemians 1905 Sub 19 Bohemians 42 70 73 54
17 Zlín Sub 19 Zlín 42 67 76 51
18 Hradec Králové Sub 19 Hradec 42 69 79 50
19 Teplice Sub 19 Teplice 42 60 73 46
20 Opava Sub 19 Opava 42 45 80 35
21 Hlučín Sub 19 Hlučín 42 26 116 19
22 Meteor Praha Sub 19 Meteor Praha 42 38 146 13
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Slavia Praha Sub 19 Slavia Praha 41 122 40 96
2 Sigma Olomouc Sub 19 Sigma 41 96 40 84
3 Zbrojovka Brno Sub 19 Zbrojovka 41 114 63 83
4 Příbram Sub 19 Příbram 41 103 60 79
5 Sparta Praha Sub 19 Sparta Praha 41 86 51 77
6 Slovácko Sub 19 Slovácko 41 78 66 65
7 Viktoria Plzeň Sub 19 Viktoria 41 85 69 63
8 Hradec Králové Sub 19 Hradec 41 69 72 61
9 Baník Ostrava Sub 19 Baník 41 102 79 60
10 Zlín Sub 19 Zlín 41 64 73 58
11 Vysočina Jihlava Sub 19 Vysočina 41 68 70 55
12 Bohemians 1905 Sub 19 Bohemians 41 72 72 53
13 Karvina Sub 19 Karvina 41 71 82 52
14 Jablonec Sub 19 Jablonec 41 76 101 52
15 Mladá Boleslav Sub 19 Mladá 41 68 79 51
16 Teplice Sub 19 Teplice 41 78 98 51
17 Slovan Liberec Sub 19 Slovan 41 61 71 50
18 České Budějovice Sub 19 České 41 69 79 48
19 Pardubice Sub 19 Pardubice 41 47 74 41
20 Baník Most Sub 19 Baník Most 41 51 85 33
21 Opava Sub 19 Opava 41 42 97 29
22 Frýdek-Místek Sub 19 Frýdek-Mís 41 46 147 24
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Mladá Boleslav Sub 19 Mladá 34 72 31 73
2 Slavia Praha Sub 19 Slavia Praha 34 77 34 71
3 Sigma Olomouc Sub 19 Sigma 34 79 49 70
4 Teplice Sub 19 Teplice 34 71 56 61
5 Sparta Praha Sub 19 Sparta Praha 34 67 43 60
6 Hradec Králové Sub 19 Hradec 34 73 60 55
7 Baník Ostrava Sub 19 Baník 34 64 51 54
8 Zbrojovka Brno Sub 19 Zbrojovka 34 58 54 49
9 Zlín Sub 19 Zlín 34 48 70 44
10 Slovácko Sub 19 Slovácko 34 59 53 43
11 Viktoria Plzeň Sub 19 Viktoria 34 58 66 42
12 Pardubice Sub 19 Pardubice 34 31 42 39
13 České Budějovice Sub 19 České 34 52 71 39
14 Bohemians 1905 Sub 19 Bohemians 34 52 67 38
15 Slovan Liberec Sub 19 Slovan 34 58 74 37
16 Opava Sub 19 Opava 34 49 81 31
17 Vysočina Jihlava Sub 19 Vysočina 34 41 61 30
18 Hlučín Sub 19 Hlučín 34 34 80 22

  USO DE MEMORIA  
6,464,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1694
Total Execution Time  0.1714
  CADENA URL  
/liga_republica_checa_sub_192022/grupo1/historico
  GET DATOS  
$_GET['/liga_republica_checa_sub_192022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_republica_checa_sub_192022'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_republica_checa_sub_19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1710 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1710 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63711 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1710 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0026  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 `tables2022` 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 = 63711 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2021` 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 = 57443 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 51546 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 49577 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 42952 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 36107 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 15890 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 10867 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2014` 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 = 25165 AND t.round = 41 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2013` 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 = 25166 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 07:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 07:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 07:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 07:08:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_republica_checa_sub_19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0314  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63711 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63711 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0357  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63711 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63711 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0041  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63711 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63711 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63711 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC