4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 53 19 71
2 Slavia Praha Slavia Praha 30 42 22 59
3 Sigma Olomouc Sigma 30 38 21 55
4 Baník Ostrava Baník 30 51 35 50
5 Slovan Liberec Slovan 30 39 32 47
6 Jablonec Jablonec 30 47 33 46
7 Teplice Teplice 30 36 30 40
8 Viktoria Žižkov Viktoria 30 26 34 39
9 Drnovice Drnovice 30 35 43 38
10 Zbrojovka Brno Zbrojovka 30 42 42 37
11 SFC Opava SFC Opava 30 33 37 34
12 Hradec Králové Hradec 30 25 36 34
13 Viktoria Plzeň Viktoria 30 37 47 33
14 Pribram Pribram 30 37 50 33
15 České Budějovice České 30 26 43 31
16 Bohdanec Bohdanec 30 18 61 11
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 61 20 65
2 Slavia Praha Slavia Praha 30 59 24 61
3 Jablonec Jablonec 30 40 29 56
4 Zbrojovka Brno Zbrojovka 30 44 35 52
5 Slovan Liberec Slovan 30 33 30 46
6 České Budějovice České 30 38 40 44
7 Drnovice Drnovice 30 53 44 43
8 Sigma Olomouc Sigma 30 36 30 40
9 SFC Opava SFC Opava 30 34 35 40
10 Baník Ostrava Baník 30 33 35 37
11 Viktoria Plzeň Viktoria 30 33 37 32
12 Viktoria Žižkov Viktoria 30 17 33 29
13 Teplice Teplice 30 21 37 28
14 Hradec Králové Hradec 30 22 39 28
15 Karviná Karviná 30 25 50 25
16 Bohemians 1905 Bohemians 30 22 53 19
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 68 28 70
2 Sigma Olomouc Sigma 30 54 33 61
3 Jablonec Jablonec 30 45 26 53
4 Sparta Praha Sparta Praha 30 56 35 49
5 Drnovice Drnovice 30 53 40 48
6 SFC Opava SFC Opava 30 40 34 46
7 Slovan Liberec Slovan 30 34 30 44
8 Zbrojovka Brno Zbrojovka 30 39 42 43
9 Viktoria Plzeň Viktoria 30 33 34 39
10 Viktoria Žižkov Viktoria 30 38 43 37
11 České Budějovice České 30 35 47 37
12 Baník Ostrava Baník 30 40 46 35
13 Union Cheb Union Cheb 30 35 47 33
14 Hradec Králové Hradec 30 28 46 29
15 FC Trinity Zlín Trinity 30 17 38 27
16 Hradiste Hradiste 30 19 65 17
Ver
TEMPORADA 1994/1995
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 64 17 70
2 Slavia Praha Slavia Praha 30 52 20 64
3 Zbrojovka Brno Zbrojovka 30 52 27 54
4 Slovan Liberec Slovan 30 49 46 51
5 Viktoria Žižkov Viktoria 30 61 38 49
6 Drnovice Drnovice 30 46 44 48
7 České Budějovice České 30 29 28 46
8 Sigma Olomouc Sigma 30 31 31 43
9 Viktoria Plzeň Viktoria 30 32 37 40
10 Jablonec Jablonec 29 36 32 38
11 Baník Ostrava Baník 30 36 41 38
12 Hradec Králové Hradec 29 34 44 35
13 Union Cheb Union Cheb 30 29 45 31
14 FC Trinity Zlín Trinity 30 21 40 30
15 Bohemians 1905 Bohemians 30 35 62 23
16 Benešov Benešov 30 23 78 12
Ver
TEMPORADA 1993/1994
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 62 21 45
2 Slavia Praha Slavia Praha 30 55 28 39
3 Baník Ostrava Baník 30 52 25 36
4 Union Cheb Union Cheb 30 31 29 36
5 Viktoria Plzeň Viktoria 30 35 23 35
6 České Budějovice České 30 33 31 35
7 Sigma Olomouc Sigma 30 44 29 34
8 Viktoria Žižkov Viktoria 30 40 28 33
9 Slovan Liberec Slovan 30 36 32 32
10 Drnovice Drnovice 30 38 36 32
11 FC Trinity Zlín Trinity 30 37 48 27
12 Zbrojovka Brno Zbrojovka 30 38 46 26
13 Hradec Králové Hradec 30 29 40 24
14 Bohemians 1905 Bohemians 30 29 54 23
15 Vitkovice Vitkovice 30 22 64 13
16 FK Dukla Praha Dukla Praha 30 21 68 10

  USO DE MEMORIA  
5,608,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4403
Total Execution Time  0.4423
  CADENA URL  
/checa1998/grupo1/historico
  GET DATOS  
$_GET['/checa1998/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0147  SELECT type FROM routes WHERE alias = 'checa1998'
0.0297  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'checa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=30 ORDER BY order_id ASC
0.0149  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 = 8756 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 30 AND group_code = 1 and tables = 1 AND year <= 1998 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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 `tables1998` 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 = 8756 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1997` 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 = 8757 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1996` 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 = 8758 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1995` 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 = 8759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1994` 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 = 10676 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:58:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:58:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:58:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:58:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0265  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 events1998 e ON e.player_id = p.id AND e.league_id = 8756 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8756 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.0246  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 events1998 e ON e.player_id = p.id AND e.league_id = 8756 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8756 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0213  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 events1998 e ON e.player_id = p.id AND e.league_id = 8756 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8756 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0158  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 8756 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC