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 30 42 28 48
3 Kotwica Kołobrzeg Kotwica 30 54 42 47
4 Radunia Stężyca Radunia 30 42 36 46
5 Hutnik Krakow Hutnik 30 43 39 45
6 Chojniczanka Chojnice Chojniczanka 30 38 35 45
7 LKS Lodz II LKS Lodz II 30 44 40 44
8 Zagłębie Lubin II Zagłębie 30 44 41 42
9 Stal Stalowa Wola Stal Stalowa 30 34 35 42
10 TS Polonia Bytom Polonia 30 43 44 41
11 Olimpia Elblag Olimpia 30 33 40 38
12 Lech Poznań II Lech Poznań 30 33 42 38
13 Wisla Pulawy Wisla Pulawy 30 43 44 36
14 SKRA Częstochowa SKRA 30 33 34 36
15 Jastrzębie Jastrzębie 30 34 41 36
16 Olimpia Grudziadz Olimpia 30 31 37 34
17 Stomil Olsztyn Stomil 30 26 34 33
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,341,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1082
Total Execution Time  0.1096
  CADENA URL  
/historico/Kalisz
  GET DATOS  
$_GET['/historico/Kalisz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80647 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=380 AND type_rel = 3
0.0023  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.0023  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.0025  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.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 = 72234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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.0019  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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 72234 AND teamId = 80647
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 80647
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 80647
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 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 = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '80647' and rp.type = 4
0.0020  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.0047  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.0041  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.0030  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.0025  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.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 `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 = 31 ORDER BY team.conference ASC,t.position 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 `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.0024  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.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 `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.0023  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.0023  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.0023  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.0022  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.0023  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