4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kalisz
TEMPORADA 2023/2024
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Pogon Siedlce Pogon 30 47 38 52
2 Kalisz Kalisz 29 42 27 48
3 Kotwica Kołobrzeg Kotwica 29 53 41 46
4 Radunia Stężyca Radunia 30 42 36 46
5 Chojniczanka Chojnice Chojniczanka 30 38 35 45
6 LKS Lodz II LKS Lodz II 29 43 39 43
7 Zagłębie Lubin II Zagłębie 29 44 40 42
8 Hutnik Krakow Hutnik 29 39 38 42
9 TS Polonia Bytom Polonia 29 42 40 41
10 Stal Stalowa Wola Stal Stalowa 29 33 34 41
11 Lech Poznań II Lech Poznań 29 33 41 38
12 SKRA Częstochowa SKRA 29 33 33 36
13 Olimpia Elblag Olimpia 29 32 40 35
14 Wisla Pulawy Wisla Pulawy 29 42 44 33
15 Olimpia Grudziadz Olimpia 29 30 36 33
16 Jastrzębie Jastrzębie 29 33 41 33
17 Stomil Olsztyn Stomil 29 25 34 30
18 Sandecja Nowy Sacz Sandecja 30 29 43 28
TEMPORADA 2022/2023
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Polonia Warszawa Polonia 35 60 38 68
2 Znicz Pruszkow Znicz 34 49 37 59
3 Kotwica Kołobrzeg Kotwica 34 45 33 59
4 Stomil Olsztyn Stomil 34 51 32 57
5 Wisla Pulawy Wisla Pulawy 34 56 38 56
6 Motor Lublin Motor Lublin 34 52 37 55
7 Kalisz Kalisz 34 63 45 54
8 Pogon Siedlce Pogon 34 41 42 48
9 Olimpia Elblag Olimpia 34 40 36 47
10 Jastrzębie Jastrzębie 34 41 45 47
11 Lech Poznań II Lech Poznań 34 45 60 42
12 Hutnik Krakow Hutnik 34 41 48 40
13 Radunia Stężyca Radunia 34 47 57 39
14 Zagłębie Lubin II Zagłębie 34 44 68 38
15 Gornik Polkowice Gornik 34 46 52 37
16 Siarka Tarnobrzeg Siarka 34 37 57 33
17 Garbarnia Kraków Garbarnia 34 52 65 32
18 Śląsk Wrocław II Śląsk 34 38 57 31
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,350,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5184
Total Execution Time  0.5196
  CADENA URL  
/historico/Kalisz
  GET DATOS  
$_GET['/historico/Kalisz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0136  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 = 2024 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.0126  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.0125  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.0125  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.0125  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.0254  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 = 72234
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80647 AND type_rel = 2
0.0129  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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.0127  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 = 72234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (72234,72171,71432) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72234 AND teamId = 80647
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 80647
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 80647
0.0126  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.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '80647' and rp.type = 4
0.0126  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.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 72234 WHERE rp.league_id = 72234 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.0136  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 events2024 e ON e.player_id = p.id AND e.league_id = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 80647 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2024 e ON e.player_id = p.id AND e.league_id = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 80647 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 `tables2024` 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 = 72234 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2023` 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 = 68006 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.0130  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.0131  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.0128  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.0129  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.0130  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.0130  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.0131  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