4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1997/1998
LIGA CHECA
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
TEMPORADA 1996/1997
LIGA CHECA
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
TEMPORADA 1995/1996
LIGA CHECA
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
TEMPORADA 1994/1995
LIGA CHECA
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
TEMPORADA 1993/1994
LIGA CHECA
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,625,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.5715
Total Execution Time  0.5738
  CADENA URL  
/historico/Sparta-Praha/1998
  GET DATOS  
$_GET['/historico/Sparta-Praha/1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0144  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Sparta-Praha' AND l.year = 1998 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 9701
0.0133  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 = 8756
0.0132  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 = 42337
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10050 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10050 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  SELECT /*35 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 (2898,6745,8526,8917,28406) ORDER BY n.cover_points DESC, update_date DESC
0.0139  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '10050' AND l.year = 1998 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '10050' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 9701 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 42337 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 8756 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=10050 AND l.year in (1997,1998,1999) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (42337,27554,10982,10973,9701,8757) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 8757 AND teamId = 10050
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 9701 AND teamId = 10050
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 10973 AND teamId = 10050
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 42337 AND teamId = 10050
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 27554 AND teamId = 10050
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 10982 AND teamId = 10050
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 9701 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137  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 events1998 e ON e.player_id = p.id AND e.league_id = 9701 WHERE rp.league_id = 9701 AND rp.teamId = 10050 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.0135  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 events1998 e ON e.player_id = p.id AND e.league_id = 9701 WHERE rp.league_id = 9701 AND rp.teamId = 10050 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 events1998 e ON e.player_id = p.id AND e.league_id = 9701 WHERE rp.league_id = 9701 AND rp.teamId = 10050 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 10050 AND l.year <= 1998 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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.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 `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.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 `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.0130  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.0130  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.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 9701 ORDER BY nameShow LIMIT 100