4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kalisz
TEMPORADA 2021/2022
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Stal Rzeszow Stal Rzeszow 34 75 35 77
2 Chojniczanka Chojnice Chojniczanka 34 72 31 73
3 Ruch Chorzów Ruch 34 48 27 63
4 Wigry Suwalki Wigry 34 58 38 60
5 Motor Lublin Motor Lublin 34 54 31 59
6 Radunia Stężyca Radunia 34 60 51 53
7 Lech Poznań II Lech Poznań 34 41 45 52
8 Garbarnia Kraków Garbarnia 34 51 43 48
9 Olimpia Elblag Olimpia 34 33 32 46
10 Pogon Siedlce Pogon 34 47 55 46
11 Wisla Pulawy Wisla Pulawy 34 56 54 44
12 Śląsk Wrocław II Śląsk 34 51 53 43
13 Kalisz Kalisz 34 43 48 42
14 Znicz Pruszkow Znicz 34 38 45 39
15 Hutnik Krakow Hutnik 34 38 55 35
16 Pogon Grod. Mazowiecki Pogon Grod. 34 34 54 31
17 Sokół Ostróda Sokół 34 32 77 19
18 GKS Bełchatów Bełchatów 34 17 74 18
TEMPORADA 2020/2021
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Gornik Polkowice Gornik 36 70 29 76
2 GKS Katowice Katowice 36 67 41 70
3 Chojniczanka Chojnice Chojniczanka 36 63 34 67
4 Wigry Suwalki Wigry 36 51 35 64
5 Kalisz Kalisz 36 51 40 57
6 SKRA Częstochowa SKRA 36 51 42 52
7 Śląsk Wrocław II Śląsk 36 61 57 52
8 Garbarnia Kraków Garbarnia 36 49 50 52
9 Stal Rzeszow Stal Rzeszow 36 58 60 50
10 Motor Lublin Motor Lublin 36 48 44 50
11 Sokół Ostróda Sokół 36 50 56 46
12 Hutnik Krakow Hutnik 36 47 61 45
13 Pogon Siedlce Pogon 36 61 62 42
14 Lech Poznań II Lech Poznań 36 47 58 40
15 Znicz Pruszkow Znicz 36 37 55 38
16 Olimpia Elblag Olimpia 36 39 52 37
17 Stargard Szczeciński Stargard 36 36 66 36
18 Olimpia Grudziadz Olimpia 36 42 67 36
19 Bytovia Bytow Bytovia 36 46 65 34
TEMPORADA 2019/2020
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kalisz Kalisz 18 41 12 45
2 Radunia Stężyca Radunia 18 37 10 40
3 Świt Skolwin Świt 18 30 7 39
4 Kotwica Kołobrzeg Kotwica 18 37 22 39
5 Mieszko Gniezno Mieszko 18 33 17 36
6 Unia Janikowo Unia 18 43 29 33
7 Sokół Kleczew Sokół 18 22 22 27
8 Starogard Gdański Starogard 18 19 20 25
9 Polonia Środa Polonia 18 28 24 23
10 Pogoń Szczecin II Pogoń 18 23 30 21
11 Chemik Police Chemik 18 21 27 21
12 Gwardia Koszalin Gwardia 18 19 37 18
13 Bałtyk Koszalin Bałtyk 18 17 35 17
14 Nielba Wagrowiec Nielba 18 22 38 16
15 Jarota Jarocin Jarota 18 18 24 15
16 Górnik Konin Górnik 18 22 37 14
17 Grom Nowy Staw Grom Nowy S. 18 19 35 14
18 Bałtyk Gdynia Bałtyk 18 12 37 10
TEMPORADA 2018/2019
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Lech Poznań II Lech Poznań 34 86 33 75
2 Radunia Stężyca Radunia 34 75 37 69
3 Kalisz Kalisz 34 70 37 69
4 Kotwica Kołobrzeg Kotwica 34 70 41 68
5 Mieszko Gniezno Mieszko 34 74 53 61
6 Polonia Środa Polonia 34 59 44 60
7 Świt Skolwin Świt 34 50 33 58
8 Bałtyk Gdynia Bałtyk 34 59 50 57
9 Sokół Kleczew Sokół 34 48 50 53
10 Starogard Gdański Starogard 34 56 37 51
11 Pogoń Szczecin II Pogoń 33 49 59 42
12 Górnik Konin Górnik 34 46 56 41
13 Bałtyk Koszalin Bałtyk 34 57 75 40
14 Jarota Jarocin Jarota 34 37 50 38
15 Gwardia Koszalin Gwardia 34 35 71 33
16 Chemik Bydgoszcz Chemik 34 38 66 30
17 Wierzyca Pelplin Wierzyca 34 34 81 14
18 Wda Świecie Świecie 33 20 90 8
TEMPORADA 2017/2018
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 TKP Elana Torun Elana Torun 34 71 24 77
2 Świt Skolwin Świt 34 70 27 73
3 Bałtyk Gdynia Bałtyk 34 74 36 69
4 Lech Poznań II Lech Poznań 34 69 34 66
5 Kalisz Kalisz 34 52 33 63
6 Polonia Środa Polonia 34 63 41 60
7 Sokół Kleczew Sokół 34 52 32 59
8 Kotwica Kołobrzeg Kotwica 34 48 37 57
9 Starogard Gdański Starogard 34 46 32 51
10 Pogoń Szczecin II Pogoń 34 44 54 49
11 Jarota Jarocin Jarota 34 45 50 42
12 Wierzyca Pelplin Wierzyca 34 38 47 42
13 Wda Świecie Świecie 34 52 72 35
14 Górnik Konin Górnik 34 40 61 34
15 Centra Ostrów Centra 34 38 67 32
16 Przodkowo Przodkowo 34 38 75 25
17 Unia Solec Kujawski Unia Solec. 34 33 80 19
18 Energetyk Gryfino Energetyk 34 9 80 11
TEMPORADA 2016/2017
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gwardia Koszalin Gwardia 34 55 32 66
2 Lech Poznań II Lech Poznań 34 71 38 65
3 Bałtyk Gdynia Bałtyk 34 55 34 64
4 Jarota Jarocin Jarota 34 57 47 59
5 TKP Elana Torun Elana Torun 34 70 42 58
6 Przodkowo Przodkowo 34 62 40 57
7 Sokół Kleczew Sokół 34 60 47 55
8 Świt Skolwin Świt 34 55 42 54
9 Kalisz Kalisz 34 44 44 54
10 Wda Świecie Świecie 34 66 53 49
11 Polonia Środa Polonia 34 44 44 47
12 Chwaszczyno Chwaszczyno 34 56 63 46
13 Pogoń Szczecin II Pogoń 34 46 50 44
14 Górnik Konin Górnik 34 44 51 40
15 Chemik Bydgoszcz Chemik 34 39 59 36
16 Pogoń Lębork Pogoń 34 36 71 30
17 Vineta Wolin Vineta Wolin 34 37 67 22
18 Leśnik - Rossa Manowo Leśnik 34 22 95 10
TEMPORADA 2015/2016
CUARTA POLONIA GRUPO 4
Equipo PJ GF GC Puntos
1 Warta Poznan Warta Poznan 30 57 24 62
2 Pelikan Niechanowo Pelikan 30 60 28 62
3 Lech Poznań II Lech Poznań 30 69 23 60
4 Sokół Kleczew Sokół 30 63 30 53
5 Jarota Jarocin Jarota 30 47 27 51
6 Polonia Środa Polonia 30 45 28 51
7 Wda Świecie Świecie 30 37 37 49
8 Kalisz Kalisz 30 41 41 45
9 TKP Elana Torun Elana Torun 30 51 41 44
10 Unia Swarzędz Unia 30 39 55 38
11 Start Warlubie Start 30 40 45 35
12 Centra Ostrów Centra 30 39 67 31
13 Ostrovia Ostrow Wielkop. Ostrovia 30 36 48 29
14 Nielba Wagrowiec Nielba 30 32 68 23
15 Sparta Brodnica Sparta 30 26 55 22
16 Kujawianka Kujawianka 30 26 91 12

  USO DE MEMORIA  
6,077,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6855
Total Execution Time  0.6867
  CADENA URL  
/historico/Kalisz/2022
  GET DATOS  
$_GET['/historico/Kalisz/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
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 = 'Kalisz' AND l.year = 2022 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.0153  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=80647 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=80647 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=80647 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=80647 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 63257
0.0153  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 = 63171
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80647 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=380 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 380 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1213703,1162606,632025,615056,275113) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '80647' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '80647' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '80647' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 63171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 63257 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=80647 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (68006,67710,67320) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 68006 AND teamId = 80647
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 67710 AND teamId = 80647
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 80647
0.0166  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 63257 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '80647' 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 = '80647' 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 = '80647' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0162  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 events2022 e ON e.player_id = p.id AND e.league_id = 63257 WHERE rp.league_id = 63257 AND rp.teamId = 80647 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.0160  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 events2022 e ON e.player_id = p.id AND e.league_id = 63257 WHERE rp.league_id = 63257 AND rp.teamId = 80647 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 events2022 e ON e.player_id = p.id AND e.league_id = 63257 WHERE rp.league_id = 63257 AND rp.teamId = 80647 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 80647 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2022` 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 = 63257 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2021` 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 = 58339 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2020` 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 = 50430 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2019` 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 = 44317 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 `tables2018` 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 = 38927 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2017` 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 = 33763 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2016` 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 = 15913 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 63257 ORDER BY nameShow LIMIT 100