4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2000/2001
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 71 31 68
2 Sigma Olomouc Sigma 30 47 33 52
3 Slavia Praha Slavia Praha 30 46 32 52
4 Pribram Pribram 30 40 26 51
5 Viktoria Žižkov Viktoria 30 45 40 46
6 Slovan Liberec Slovan 30 39 31 45
7 Drnovice Drnovice 30 35 36 41
8 Teplice Teplice 30 45 39 40
9 Chmel Blšany Chmel 30 35 35 40
10 Bohemians 1905 Bohemians 30 33 34 40
11 Synot Synot 30 37 35 37
12 Jablonec Jablonec 30 26 40 32
13 Zbrojovka Brno Zbrojovka 30 24 35 30
14 Baník Ostrava Baník 30 28 45 30
15 České Budějovice České 30 32 56 26
16 Viktoria Plzeň Viktoria 30 30 65 21
TEMPORADA 1999/2000
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 81 23 76
2 Slavia Praha Slavia Praha 30 53 25 68
3 Drnovice Drnovice 30 36 32 48
4 Zbrojovka Brno Zbrojovka 30 35 33 42
5 Teplice Teplice 30 38 38 41
6 Pribram Pribram 30 33 36 40
7 Bohemians 1905 Bohemians 30 24 28 40
8 Slovan Liberec Slovan 30 21 24 38
9 Viktoria Žižkov Viktoria 30 37 41 37
10 Chmel Blšany Chmel 30 28 45 37
11 Baník Ostrava Baník 30 43 45 35
12 Sigma Olomouc Sigma 30 31 38 34
13 Jablonec Jablonec 30 24 36 32
14 České Budějovice České 30 34 49 32
15 SFC Opava SFC Opava 30 31 39 28
16 Hradec Králové Hradec 30 21 38 23
TEMPORADA 1998/1999
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 62 23 60
2 Teplice Teplice 30 55 30 55
3 Slavia Praha Slavia Praha 30 51 31 55
4 Sigma Olomouc Sigma 30 42 34 47
5 Baník Ostrava Baník 30 39 26 45
6 Chmel Blšany Chmel 30 48 44 42
7 Zbrojovka Brno Zbrojovka 30 37 33 41
8 Hradec Králové Hradec 30 33 40 39
9 Slovan Liberec Slovan 30 33 34 38
10 Viktoria Žižkov Viktoria 30 31 47 38
11 Drnovice Drnovice 30 35 44 37
12 Jablonec Jablonec 30 37 46 35
13 Pribram Pribram 30 28 41 33
14 SFC Opava SFC Opava 30 40 54 32
15 Viktoria Plzeň Viktoria 30 26 43 32
16 Karviná Karviná 30 28 55 23
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  
6,101,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6070
Total Execution Time  0.6092
  CADENA URL  
/historico/Sparta-Praha/2001
  GET DATOS  
$_GET['/historico/Sparta-Praha/2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0222  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 = 2001 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.0147  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.0145  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.0146  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.0145  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.0146  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.0152  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 = 9668
0.0151  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 = 8753
0.0152  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 = 27552
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10050 AND type_rel = 2
0.0149  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.0147  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.0158  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 = 2001 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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.0146  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 = 9668 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 27552 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 8753 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0173  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 (2000,2001,2002) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (40766,27553,9689,8754) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 8754 AND teamId = 10050
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 9689 AND teamId = 10050
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 40766 AND teamId = 10050
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 27553 AND teamId = 10050
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 9668 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10050' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10050' and rp.type = 4
0.0146  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10050' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 events2001 e ON e.player_id = p.id AND e.league_id = 9668 WHERE rp.league_id = 9668 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.0154  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 events2001 e ON e.player_id = p.id AND e.league_id = 9668 WHERE rp.league_id = 9668 AND rp.teamId = 10050 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 events2001 e ON e.player_id = p.id AND e.league_id = 9668 WHERE rp.league_id = 9668 AND rp.teamId = 10050 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 <= 2001 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145  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 = 9668 ORDER BY nameShow LIMIT 100