4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Raków Częstochowa

Raków Częstochowa

Entrenador: Dawid Szwarga

Temporada 1997/1998
TEMPORADA 1997/1998
LIGA POLACA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 52 23 66
2 Polonia Warszawa Polonia 34 46 30 63
3 Wisla Kraków Wisla 34 50 30 61
4 Widzew Łódź Widzew 34 53 34 61
5 Legia Warszawa Legia 34 50 32 59
6 Ruch Chorzów Ruch 34 48 39 55
7 Amica Wronki Amica Wronki 34 38 31 50
8 Górnik Zabrze Górnik 34 48 42 48
9 Odra Wodzislaw Slaski Odra 34 51 50 48
10 Lech Poznań Lech Poznań 34 41 37 46
11 Stomil Olsztyn Stomil 34 38 45 45
12 GKS Katowice Katowice 34 37 33 43
13 Zaglebie Lubin Zaglebie 34 39 40 43
14 Pogon Szczecin Pogon 34 36 40 43
15 Petrochemia Petrochemia 34 28 54 38
16 Dyskobolia Grodzisk Dyskobolia 34 30 55 29
17 KSZO Ostrowiec KSZO 34 24 47 24
18 Raków Częstochowa Raków 34 21 68 17
TEMPORADA 1996/1997
LIGA POLACA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 74 21 81
2 Legia Warszawa Legia 34 66 27 77
3 Odra Wodzislaw Slaski Odra 34 51 44 55
4 GKS Katowice Katowice 34 47 40 53
5 Amica Wronki Amica Wronki 34 41 40 52
6 LKS Lódz LKS Lódz 34 55 45 49
7 Zaglebie Lubin Zaglebie 34 44 38 49
8 Polonia Warszawa Polonia 34 40 44 48
9 Lech Poznań Lech Poznań 34 40 40 44
10 Stomil Olsztyn Stomil 34 45 46 44
11 Raków Częstochowa Raków 34 35 39 44
12 Wisla Kraków Wisla 34 33 42 42
13 Górnik Zabrze Górnik 34 40 45 41
14 Ruch Chorzów Ruch 34 41 41 40
15 GKS Bełchatów Bełchatów 34 36 43 40
16 Hutnik Nowa Huta Hutnik Nowa 34 34 46 35
17 Śląsk Wrocław Śląsk 34 24 56 24
18 Sokol Tychy Sokol Tychy 34 18 67 21
TEMPORADA 1995/1996
LIGA POLACA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 84 22 88
2 Legia Warszawa Legia 34 95 22 85
3 Hutnik Nowa Huta Hutnik Nowa 34 48 43 52
4 LKS Lódz LKS Lódz 34 44 38 49
5 Amica Wronki Amica Wronki 34 35 37 48
6 Stomil Olsztyn Stomil 34 32 41 46
7 Lech Poznań Lech Poznań 34 45 40 45
8 Zaglebie Lubin Zaglebie 34 34 35 44
9 Raków Częstochowa Raków 34 33 36 44
10 Sokol Tychy Sokol Tychy 34 36 40 44
11 GKS Katowice Katowice 34 36 37 43
12 Górnik Zabrze Górnik 34 45 52 43
13 Śląsk Wrocław Śląsk 34 39 41 42
14 Pogon Szczecin Pogon 34 33 41 42
15 GKS Bełchatów Bełchatów 34 40 54 42
16 Lechia Gdansk Lechia 34 39 59 40
17 Stal Mielec Stal Mielec 34 33 67 28
18 Siarka Tarnobrzeg Siarka 34 24 70 15
TEMPORADA 1994/1995
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 34 58 20 51
2 Widzew Łódź Widzew 34 48 25 45
3 GKS Katowice Katowice 34 45 27 42
4 Zaglebie Lubin Zaglebie 34 48 41 42
5 Górnik Zabrze Górnik 34 48 40 37
6 Lech Poznań Lech Poznań 34 47 40 34
7 LKS Lódz LKS Lódz 34 39 41 34
8 Pogon Szczecin Pogon 34 33 34 33
9 Hutnik Nowa Huta Hutnik Nowa 34 37 39 32
10 Sokol Tychy Sokol Tychy 34 33 43 32
11 Lechia Gdansk Lechia 34 46 41 31
12 Stal Mielec Stal Mielec 34 44 50 31
13 Raków Częstochowa Raków 34 31 43 31
14 Stomil Olsztyn Stomil 34 35 40 30
15 Petrochemia Petrochemia 34 35 43 30
16 Ruch Chorzów Ruch 34 39 46 29
17 Stal Stalowa Wola Stal Stalowa 34 34 47 29
18 Warta Poznan Warta Poznan 34 35 75 19

  USO DE MEMORIA  
5,262,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1181
Total Execution Time  0.1193
  CADENA URL  
/historico/Rakow-Cz-Stochowa/1998
  GET DATOS  
$_GET['/historico/Rakow-Cz-Stochowa/1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0055  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 = 'Rakow-Cz-Stochowa' 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.0023  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=17740 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=17740 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0050  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 = 8806
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17740 AND type_rel = 2
0.0069  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 = '17740' ORDER BY l.year DESC,cat.coefficient DESC
0.0057  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 = '17740' AND l.year = 1998 ORDER BY l.year DESC,cat.coefficient DESC
0.0084  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 = '17740' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  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 = 8806 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0074  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=17740 AND l.year in (1997,1998,1999) ORDER BY l.id DESC, l.year DESC ;
0.0024  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 (8808) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 8808 AND teamId = 17740
0.0047  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 = 8806 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0028  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 = '17740' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17740' and rp.type = 4
0.0023  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 = '17740' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 8806 WHERE rp.league_id = 8806 AND rp.teamId = 17740 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.0023  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 = 8806 WHERE rp.league_id = 8806 AND rp.teamId = 17740 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 8806 WHERE rp.league_id = 8806 AND rp.teamId = 17740 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 17740 AND l.year <= 1998 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032  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 = 8806 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 8808 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 8809 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 8812 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 8806 ORDER BY nameShow LIMIT 100