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 1996/1997
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,099,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4070
Total Execution Time  0.4083
  CADENA URL  
/historico/Rakow-Cz-Stochowa/1997
  GET DATOS  
$_GET['/historico/Rakow-Cz-Stochowa/1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0160  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 = 1997 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.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=17740 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=17740 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17740 AND type_rel = 2
0.0153  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 = 1997 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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.0148  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 (1996,1997,1998) ORDER BY l.id DESC, l.year DESC ;
0.0144  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 (8809) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 8809 AND teamId = 17740
0.0148  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.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17740' 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 = '17740' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 events1997 e ON e.player_id = p.id AND e.league_id = 8808 WHERE rp.league_id = 8808 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.0146  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 events1997 e ON e.player_id = p.id AND e.league_id = 8808 WHERE rp.league_id = 8808 AND rp.teamId = 17740 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 events1997 e ON e.player_id = p.id AND e.league_id = 8808 WHERE rp.league_id = 8808 AND rp.teamId = 17740 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 <= 1997 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0298  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.0172  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.0151  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