4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Vlašim Vlašim 34 70 16 83
2 Písek Písek 34 54 32 70
3 Sparta Krč Sparta Krč 34 45 33 57
4 Slavia Praha II Slavia Praha 34 35 26 56
5 Viktoria Žižkov II Viktoria 34 44 43 46
6 Varnsdorf Varnsdorf 34 42 36 45
7 Karlovy Vary Karlovy Vary 34 43 40 45
8 FC Táborsko Táborsko 34 39 48 44
9 České Budějovice II České 34 48 46 43
10 Viktoria Plzeň II Viktoria 34 40 42 43
11 Hlavice Hlavice 34 38 51 43
12 Mladá Boleslav II Mladá 34 51 46 42
13 Králův Dvůr Králův 34 45 64 40
14 Slovan Liberec II Slovan 34 46 55 39
15 Jablonec II Jablonec II 34 44 53 39
16 Slavoj Vyšehrad Slavoj 34 39 50 38
17 Náchod Náchod 34 38 66 37
18 Letohrad Letohrad 34 35 49 35
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Sigma Olomouc II Sigma 30 65 28 61
2 Znojmo Znojmo 30 57 35 60
3 Mutenice Mutenice 30 60 30 57
4 Karviná Karviná 30 48 30 50
5 Frýdek-Místek Frýdek-Mís 30 50 38 48
6 Břeclav Břeclav 30 40 38 48
7 Bystrc Kníničky Bystrc 30 42 34 47
8 Slovácko II Slovácko 30 36 38 42
9 Vysocina Jihlava II Vysocina 30 44 54 38
10 Zábřeh Zábřeh 30 28 50 38
11 Zbrojovka Brno II Zbrojovka 30 23 30 35
12 SK Hanácká Hanácká 30 34 39 34
13 Uničov Uničov 30 30 40 33
14 Zlín II Zlín II 30 31 49 27
15 SK Lipová SK Lipová 30 33 59 25
16 Dolní Benešov Dolní 30 22 51 21
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Fulnek Fulnek 30 64 30 64
2 Mutenice Mutenice 30 50 32 57
3 Slovácko II Slovácko 30 47 32 51
4 Uničov Uničov 30 50 35 49
5 Frýdek-Místek Frýdek-Mís 30 49 37 49
6 Zlín II Zlín II 30 38 27 47
7 Břeclav Břeclav 30 42 35 47
8 Karviná Karviná 30 47 40 42
9 Vysocina Jihlava II Vysocina 30 38 38 40
10 Zbrojovka Brno II Zbrojovka 30 43 45 39
11 Znojmo Znojmo 30 39 49 38
12 Dolní Benešov Dolní 30 33 42 37
13 SK Lipová SK Lipová 30 27 46 35
14 Baník Ostrava II Baník 30 31 34 34
15 Brumov Brumov 30 36 67 28
16 Hranice Hranice 30 28 73 16
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Jakubcovice Jakubcovice 30 49 21 61
2 Bystrc Kníničky Bystrc 29 35 25 50
3 Dolní Benešov Dolní 30 47 41 48
4 SK Lipová SK Lipová 30 49 33 47
5 Třinec Třinec 30 44 34 47
6 Uničov Uničov 30 35 28 46
7 Znojmo Znojmo 30 47 36 43
8 Baník Ostrava II Baník 30 35 36 40
9 Břeclav Břeclav 30 36 41 40
10 Zlín II Zlín II 29 34 33 39
11 Slovácko II Slovácko 30 38 38 37
12 Vitkovice B Vitkovice B 30 33 42 35
13 Vysocina Jihlava II Vysocina 30 36 47 33
14 Hranice Hranice 30 23 33 29
15 Kohoutovice Kohoutovice 30 19 38 27
16 Bystrice pod Hostýnem Bystrice 30 21 55 23
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 HFK Olomouc HFK Olomouc 30 60 23 68
2 Hlučín Hlučín 30 64 25 63
3 Uničov Uničov 30 67 39 53
4 Zlín II Zlín II 29 47 34 53
5 Baník Ostrava II Baník 30 38 27 48
6 Dolní Benešov Dolní 30 45 43 45
7 Vitkovice B Vitkovice B 30 35 36 42
8 Bystrc Kníničky Bystrc 30 43 39 41
9 Slovácko II Slovácko 30 49 48 39
10 Znojmo Znojmo 30 39 42 38
11 Bystrice pod Hostýnem Bystrice 29 39 45 37
12 Hranice Hranice 30 36 41 35
13 Třinec Třinec 30 31 52 30
14 Kohoutovice Kohoutovice 30 27 43 27
15 SK Lipová SK Lipová 30 28 54 23
16 Postorna Postorna 30 27 84 17
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 SK Hanácká Hanácká 30 60 28 69
2 Uničov Uničov 30 48 28 54
3 Synot B Synot B 30 56 37 54
4 Baník Ostrava II Baník 30 50 23 53
5 Bystrc Kníničky Bystrc 29 45 33 53
6 Třinec Třinec 30 41 30 47
7 Vitkovice B Vitkovice B 29 35 42 41
8 Hranice Hranice 30 46 48 40
9 Dolní Benešov Dolní 30 41 45 35
10 Znojmo Znojmo 30 47 54 34
11 Dolni Kounice Dolni 30 30 46 34
12 Zlín II Zlín II 30 30 35 33
13 Bystrice pod Hostýnem Bystrice 30 35 48 33
14 Postorna Postorna 30 36 41 32
15 Frýdek-Místek Frýdek-Mís 30 28 45 29
16 Prostějov Prostějov 30 30 75 25
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Drnovice Drnovice 29 49 26 63
2 Zbrojovka Brno II Zbrojovka 30 45 20 55
3 Baník Ostrava II Baník 29 67 25 54
4 Frýdek-Místek Frýdek-Mís 30 35 29 50
5 Hranice Hranice 30 38 25 47
6 Uničov Uničov 30 31 29 45
7 Znojmo Znojmo 30 42 40 43
8 SK Hanácká Hanácká 30 35 34 42
9 Dolní Benešov Dolní 30 44 39 41
10 Synot B Synot B 30 36 40 40
11 Postorna Postorna 30 30 54 37
12 Bystrice pod Hostýnem Bystrice 29 49 52 35
13 Třinec Třinec 30 44 59 34
14 Zlín II Zlín II 30 27 46 33
15 FC Kyjov 1919 Kyjov 1919 30 28 49 23
16 SK Detmarovice Detmarovice 29 19 52 20
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Sparta Praha II Sparta Praha 30 65 25 69
2 Tatran Prachatice Tatran 30 54 25 64
3 Slavia Praha II Slavia Praha 30 48 31 54
4 Varnsdorf Varnsdorf 31 59 41 52
5 FK Bohemians (Střížkov) Bohemians 30 49 42 48
6 Slovan Liberec II Slovan 30 54 46 44
7 Hradec Králové II Hradec 30 35 35 43
8 Sparta Krč Sparta Krč 31 36 38 40
9 Semily Semily 30 40 51 39
10 Teplice II Teplice II 30 43 42 38
11 Milin Milin 30 36 42 38
12 České Budějovice II České 30 38 37 34
13 Admira Praha Admira Praha 30 40 51 34
14 Karlovy Vary Karlovy Vary 30 34 47 33
15 Semice Semice 31 39 72 33
16 Union Celakovice Union 31 40 44 32
17 Chrudim Chrudim 30 32 52 32
18 SK Kladno SK Kladno 30 29 50 25

  USO DE MEMORIA  
5,931,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0831
Total Execution Time  0.0850
  CADENA URL  
/3_liga_republica_checa2009/grupo2/historico
  GET DATOS  
$_GET['/3_liga_republica_checa2009/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0017  SELECT type FROM routes WHERE alias = '3_liga_republica_checa2009'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_liga_republica_checa' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1524 ORDER BY order_id ASC
0.0019  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 = 24643 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1524 AND group_code = 2 and tables = 1 AND year <= 2009 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2009` 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 = 24643 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 `tables2008` 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 = 24640 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2007` 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 = 24511 AND t.round = 30 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 `tables2006` 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 = 24502 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2005` 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 = 24497 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 `tables2004` 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 = 24489 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2003` 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 = 24480 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 `tables2002` 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 = 24473 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 04:44:18' 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=2 AND last_update > '2024-05-10 04:44:18' 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-05-10 04:44:18' 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=3 AND last_update > '2024-05-10 04:44:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_liga_republica_checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2009 e ON e.player_id = p.id AND e.league_id = 24643 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24643 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.0020  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 events2009 e ON e.player_id = p.id AND e.league_id = 24643 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24643 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2009 e ON e.player_id = p.id AND e.league_id = 24643 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 24643 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 24643 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC