4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Viktoria Žižkov Viktoria 30 55 23 64
2 Bohemians 1905 Bohemians 30 47 21 60
3 SFC Opava SFC Opava 30 47 28 53
4 HFK Olomouc HFK Olomouc 30 40 28 53
5 Vysocina Jihlava Vysocina 30 49 26 51
6 Baník Sokolov Baník 30 36 33 46
7 Hradec Králové Hradec 30 41 34 43
8 Chmel Blšany Chmel 30 27 33 38
9 FK Viagem Ústí nad Labem Viagem 30 41 44 37
10 Jakubcovice Jakubcovice 30 35 44 37
11 FK Caslav FK Caslav 30 34 48 37
12 Vitkovice Vitkovice 30 31 50 32
13 Třinec Třinec 30 21 42 32
14 Hlučín Hlučín 30 24 34 29
15 Sigma Olomouc II Sigma 30 27 43 29
16 Bystrc Kníničky Bystrc 30 22 46 25
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 SK Kladno SK Kladno 29 45 19 57
2 České Budějovice České 30 55 26 55
3 FK Viagem Ústí nad Labem Viagem 30 47 39 49
4 Hradec Králové Hradec 30 31 28 49
5 Viktoria Žižkov Viktoria 29 40 33 43
6 SK Hanácká Hanácká 30 34 32 42
7 HFK Olomouc HFK Olomouc 30 27 31 41
8 Xaverov Xaverov 30 36 37 37
9 Vitkovice Vitkovice 30 26 33 36
10 Hlučín Hlučín 30 31 47 36
11 Kunovice Kunovice 30 35 43 35
12 AS Pardubice Pardubice 30 35 38 34
13 Sparta Praha II Sparta Praha 30 32 37 34
14 Sigma Olomouc II Sigma 30 33 40 34
15 Drnovice Drnovice 30 24 40 34
16 Zbrojovka Brno II Zbrojovka 30 24 32 32
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Mostecký Mostecký 28 58 30 61
2 Viktoria Plzeň Viktoria 28 32 23 46
3 Viktoria Žižkov Viktoria 28 42 36 46
4 Vysocina Jihlava Vysocina 27 43 29 45
5 SK Kladno SK Kladno 28 37 22 43
6 Vitkovice Vitkovice 28 35 30 42
7 Zbrojovka Brno II Zbrojovka 27 32 28 36
8 Hradec Králové Hradec 28 37 38 34
9 Kunovice Kunovice 28 29 42 33
10 Sparta Praha II Sparta Praha 28 24 30 32
11 Sigma Olomouc II Sigma 28 32 39 31
12 FK Viagem Ústí nad Labem Viagem 28 27 40 30
13 SK Hanácká Hanácká 28 29 45 28
14 AS Pardubice Pardubice 28 20 34 27
15 Tatran Prachatice Tatran 28 28 39 26
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Mladá Boleslav Mladá 30 50 24 55
2 Drnovice Drnovice 30 34 22 54
3 Bohemians 1905 Bohemians 30 37 21 51
4 SK Kladno SK Kladno 30 47 27 50
5 Vysocina Jihlava Vysocina 30 40 33 46
6 AS Pardubice Pardubice 30 40 35 46
7 Hradec Králové Hradec 30 27 30 39
8 Sparta Praha II Sparta Praha 30 32 24 38
9 Mostecký Mostecký 29 31 31 38
10 Vitkovice Vitkovice 30 28 36 37
11 Zbrojovka Brno II Zbrojovka 30 36 40 36
12 Sigma Olomouc II Sigma 29 39 49 35
13 Tatran Prachatice Tatran 30 31 49 34
14 HFK Olomouc HFK Olomouc 30 21 35 32
15 Kunovice Kunovice 29 23 42 30
16 Xaverov Xaverov 29 22 40 29
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 57 31 62
2 SFC Opava SFC Opava 30 51 26 60
3 Sparta Praha II Sparta Praha 30 35 23 48
4 Mostecký Mostecký 30 36 23 47
5 Vitkovice Vitkovice 30 38 28 47
6 Mladá Boleslav Mladá 30 35 27 46
7 Vysocina Jihlava Vysocina 30 43 34 44
8 Kunovice Kunovice 30 35 32 42
9 Xaverov Xaverov 30 44 56 41
10 Sigma Olomouc II Sigma 30 39 41 36
11 Pardubice Pardubice 29 38 44 36
12 HFK Olomouc HFK Olomouc 29 37 38 35
13 Neratovice-Byškovice Neratovice-B 30 26 30 31
14 Prostějov Prostějov 30 30 47 31
15 Chomutov Chomutov 30 34 65 25
16 Dolni Kounice Dolni 30 26 59 22
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 České Budějovice České 30 58 20 66
2 FC Trinity Zlín Trinity 30 56 24 64
3 Mladá Boleslav Mladá 30 40 29 52
4 Viktoria Plzeň Viktoria 30 56 34 50
5 Pardubice Pardubice 30 39 30 46
6 Xaverov Xaverov 30 44 36 46
7 Vysocina Jihlava Vysocina 30 47 46 42
8 Vitkovice Vitkovice 30 38 38 40
9 HFK Olomouc HFK Olomouc 29 36 39 37
10 Mostecký Mostecký 30 36 37 36
11 Prostějov Prostějov 30 33 34 36
12 Sigma Olomouc II Sigma 29 33 53 34
13 Chomutov Chomutov 30 30 50 34
14 Neratovice-Byškovice Neratovice-B 30 33 39 30
15 FK Kolín FK Kolín 30 22 56 21
16 Ratiskovice Ratiskovice 30 19 55 21
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Hradec Králové Hradec 30 55 28 66
2 SFC Opava SFC Opava 30 57 20 60
3 Ratiskovice Ratiskovice 30 44 26 51
4 FC Trinity Zlín Trinity 30 42 24 49
5 Xaverov Xaverov 29 49 30 47
6 Vysocina Jihlava Vysocina 30 38 31 47
7 Pardubice Pardubice 30 39 38 44
8 Mostecký Mostecký 30 27 27 38
9 Vitkovice Vitkovice 29 37 41 37
10 Chomutov Chomutov 30 46 50 36
11 Mladá Boleslav Mladá 30 34 42 36
12 Neratovice-Byškovice Neratovice-B 30 39 50 35
13 HFK Olomouc HFK Olomouc 29 37 45 32
14 Prostějov Prostějov 30 31 49 32
15 Karviná Karviná 29 24 61 22
16 Třinec Třinec 30 33 70 18
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Synot Synot 30 76 29 76
2 Viktoria Plzeň Viktoria 30 50 22 59
3 Ratiskovice Ratiskovice 29 46 31 50
4 Mostecký Mostecký 30 43 32 45
5 Nova Hut Ostrava Nova Ostrava 30 46 39 43
6 Bohdanec Bohdanec 30 36 33 43
7 Neratovice-Byškovice Neratovice-B 30 42 45 42
8 FC Trinity Zlín Trinity 30 44 33 41
9 Xaverov Xaverov 30 34 41 37
10 Třinec Třinec 30 39 60 37
11 Karviná Karviná 30 44 48 33
12 Prostějov Prostějov 30 39 47 33
13 Vitkovice Vitkovice 30 23 38 33
14 Mladá Boleslav Mladá 29 29 38 32
15 Postorna Postorna 30 30 47 25
16 Frýdek-Místek Frýdek-Mís 30 26 64 16

  USO DE MEMORIA  
5,816,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4384
Total Execution Time  0.4406
  CADENA URL  
/2_liga_republicacheca2007/grupo1/historico
  GET DATOS  
$_GET['/2_liga_republicacheca2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0128  SELECT type FROM routes WHERE alias = '2_liga_republicacheca2007'
0.0261  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_liga_republicacheca' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=367 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 367 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0141  SELECT /*53 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 (808298,779859,463893,375302) ORDER BY n.cover_points DESC, update_date DESC
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=367 ORDER BY order_id ASC
0.0136  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 = 8767 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 367 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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 = 8767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 8768 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 8770 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 8771 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 8772 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 8775 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2001` 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 = 8776 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2000` 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 = 8778 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 23:39:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 23:39:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 23:39:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 23:39:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_liga_republicacheca' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  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 events2007 e ON e.player_id = p.id AND e.league_id = 8767 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8767 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.0126  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 events2007 e ON e.player_id = p.id AND e.league_id = 8767 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8767 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  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 events2007 e ON e.player_id = p.id AND e.league_id = 8767 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8767 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  SELECT *,(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 = 8767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC