4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Amica Wronki
TEMPORADA 2000/2001
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 66 27 62
2 Pogon Szczecin Pogon 30 43 33 53
3 Legia Warszawa Legia 30 45 29 50
4 Polonia Warszawa Polonia 30 38 30 46
5 Zaglebie Lubin Zaglebie 30 43 40 46
6 Ruch Chorzów Ruch 30 50 46 44
7 Amica Wronki Amica Wronki 30 48 44 44
8 GKS Katowice Katowice 30 28 22 42
9 Odra Wodzislaw Slaski Odra 30 39 46 39
10 Dyskobolia Grodzisk Dyskobolia 30 35 38 37
11 Śląsk Wrocław Śląsk 30 32 38 36
12 Widzew Łódź Widzew 30 33 40 36
13 Górnik Zabrze Górnik 30 29 35 34
14 Stomil Olsztyn Stomil 30 22 41 34
15 Wisła Płock Wisła 30 37 55 31
16 Ruch Radzionków Ruch 30 27 51 31
TEMPORADA 1999/2000
LIGA POLACA
Equipo PJ GF GC Puntos
1 Polonia Warszawa Polonia 30 57 25 65
2 Wisla Kraków Wisla 30 64 38 56
3 Ruch Chorzów Ruch 30 53 32 55
4 Legia Warszawa Legia 30 53 34 52
5 Zaglebie Lubin Zaglebie 30 42 37 45
6 Amica Wronki Amica Wronki 30 43 37 44
7 Widzew Łódź Widzew 30 48 54 40
8 Odra Wodzislaw Slaski Odra 30 34 38 37
9 Stomil Olsztyn Stomil 30 33 43 37
10 Ruch Radzionków Ruch 30 38 49 37
11 Dyskobolia Grodzisk Dyskobolia 30 29 46 36
12 Pogon Szczecin Pogon 30 42 53 34
13 Petrochemia Petrochemia 30 35 49 34
14 Górnik Zabrze Górnik 30 42 41 32
15 LKS Lódz LKS Lódz 30 28 42 28
16 Lech Poznań Lech Poznań 30 34 57 25
TEMPORADA 1998/1999
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 75 23 73
2 Widzew Łódź Widzew 30 50 33 56
3 Legia Warszawa Legia 30 41 25 56
4 Lech Poznań Lech Poznań 30 55 36 54
5 Polonia Warszawa Polonia 30 38 31 46
6 Ruch Radzionków Ruch 30 40 35 41
7 Górnik Zabrze Górnik 30 34 31 39
8 Zaglebie Lubin Zaglebie 30 42 44 38
9 Stomil Olsztyn Stomil 30 29 38 37
10 Ruch Chorzów Ruch 30 23 36 36
11 Amica Wronki Amica Wronki 30 31 39 34
12 LKS Lódz LKS Lódz 30 33 45 34
13 Pogon Szczecin Pogon 30 33 54 33
14 Odra Wodzislaw Slaski Odra 30 33 41 32
15 GKS Bełchatów Bełchatów 30 26 48 28
16 GKS Katowice Katowice 30 25 49 23
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

  USO DE MEMORIA  
5,932,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1685
Total Execution Time  0.1697
  CADENA URL  
/historico/Amica-Wronki/2001
  GET DATOS  
$_GET['/historico/Amica-Wronki/2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0038  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 = 'Amica-Wronki' 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.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=59510 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=59510 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=59510 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=59510 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 = 8800
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59510 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=117 AND type_rel = 3
0.0476  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 117 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0031  SELECT /*53 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 (1314732,1314730,1314687,1314542,1314489) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '59510' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '59510' AND l.year = 2001 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '59510' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '59510' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 8800 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=59510 AND l.year in (2000,2001,2002) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (42362,26327,23064,10975,10677) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 10677 AND teamId = 59510
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 10975 AND teamId = 59510
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 42362 AND teamId = 59510
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23064 AND teamId = 59510
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 26327 AND teamId = 59510
0.0020  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 = '59510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59510' and rp.type = 4
0.0021  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 = '59510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 10975 WHERE rp.league_id = 10975 AND rp.teamId = 59510 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.0028  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 = 10975 WHERE rp.league_id = 10975 AND rp.teamId = 59510 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 10975 WHERE rp.league_id = 10975 AND rp.teamId = 59510 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 59510 AND l.year <= 2001 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 `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 = 8800 AND t.round = 30 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 `tables2000` 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 = 8803 AND t.round = 30 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 `tables1999` 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 = 8805 AND t.round = 30 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 `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.0029  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.0030  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