4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pogon Grod. Mazowiecki
TEMPORADA 2023/2024
CUARTA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Pogon Grod. Mazowiecki Pogon Grod. 27 72 27 57
2 Legia Warszawa II Legia 27 60 32 55
3 Unia Skierniewice Unia 27 54 35 49
4 GKS Bełchatów Bełchatów 27 47 35 46
5 Pelikan Lowicz Pelikan 27 44 22 46
6 Swit Nowy Dwor Swit Nowy D. 27 49 38 41
7 Lechia T. Mazowiecki Lechia 27 43 40 41
8 Broń Radom Broń Radom 27 30 33 39
9 Victoria Sulejówek Victoria 27 32 38 34
10 LKS Łomża LKS Łomża 27 33 41 33
11 Mławianka Mława Mławianka 27 33 37 32
12 Wikielec Wikielec 27 26 40 31
13 Olimpia Zambrow Olimpia 27 38 39 30
14 Jagiellonia II Jagiellonia 27 36 44 30
15 Warta Sieradz Warta 27 31 41 29
16 Concordia Elblag Concordia 27 35 62 27
17 KS Legionovia Legionowo Legionovia 27 34 54 25
18 Pilica Białobrzegi Pilica 27 26 65 19
TEMPORADA 2022/2023
CUARTA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 LKS Lodz II LKS Lodz II 34 76 41 68
2 KS Legionovia Legionowo Legionovia 34 71 43 64
3 Pogon Grod. Mazowiecki Pogon Grod. 34 62 39 64
4 Swit Nowy Dwor Swit Nowy D. 34 66 45 61
5 Legia Warszawa II Legia 34 66 48 55
6 Lechia T. Mazowiecki Lechia 34 51 43 55
7 Unia Skierniewice Unia 34 41 38 53
8 Mławianka Mława Mławianka 34 83 71 52
9 Jagiellonia II Jagiellonia 34 65 54 49
10 Pelikan Lowicz Pelikan 34 56 52 45
11 Pilica Białobrzegi Pilica 34 53 55 45
12 Sokół Ostróda Sokół 34 49 71 36
13 Olimpia Zambrow Olimpia 34 40 63 36
14 Broń Radom Broń Radom 34 60 76 35
15 Warta Sieradz Warta 34 39 53 34
16 Concordia Elblag Concordia 34 38 61 33
17 KS Blonianka Blonianka 34 35 68 30
18 Ursus Warszawa Ursus 34 42 72 25
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
CUARTA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Pogon Grod. Mazowiecki Pogon Grod. 35 84 37 77
2 Swit Nowy Dwor Swit Nowy D. 35 66 36 74
3 KS Legionovia Legionowo Legionovia 35 68 48 64
4 Polonia Warszawa Polonia 35 63 39 59
5 Kutno Kutno 34 55 47 55
6 Unia Skierniewice Unia 35 60 50 52
7 Ursus Warszawa Ursus 34 53 45 52
8 Znicz Biała Piska Znicz Biała 35 62 61 52
9 Legia Warszawa II Legia 35 61 54 51
10 Broń Radom Broń Radom 34 49 44 51
11 KS Blonianka Blonianka 34 65 51 50
12 Lechia T. Mazowiecki Lechia 34 49 66 49
13 Sokol Aleksandrow Sokol 34 53 31 48
14 Pelikan Lowicz Pelikan 34 47 46 47
15 Wikielec Wikielec 34 50 57 46
16 Concordia Elblag Concordia 34 44 46 45
17 Jagiellonia II Jagiellonia 35 57 69 44
18 RKS Radomsko Radomsko 34 51 50 42
19 Olimpia Zambrow Olimpia 34 51 59 40
20 Ruch Wysokie Mazowieckie Ruch Wysokie 34 32 71 23
21 Huragan Morag Huragan 34 39 76 22
22 KS Wasilków Wasilków 34 21 97 15
TEMPORADA 2019/2020
CUARTA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sokół Ostróda Sokół 18 38 19 37
2 Legia Warszawa II Legia 18 30 17 36
3 Sokol Aleksandrow Sokol 19 37 22 36
4 Swit Nowy Dwor Swit Nowy D. 19 32 20 33
5 Znicz Biała Piska Znicz Biała 19 33 24 32
6 Pelikan Lowicz Pelikan 19 37 26 32
7 Huragan Morag Huragan 19 26 21 30
8 Unia Skierniewice Unia 19 33 39 28
9 Concordia Elblag Concordia 19 23 25 27
10 Broń Radom Broń Radom 19 26 27 26
11 RKS Radomsko Radomsko 19 26 28 24
12 Olimpia Zambrow Olimpia 19 31 35 23
13 Pogon Grod. Mazowiecki Pogon Grod. 19 31 35 21
14 Lechia T. Mazowiecki Lechia 19 23 32 20
15 Ursus Warszawa Ursus 19 17 21 19
16 Ruch Wysokie Mazowieckie Ruch Wysokie 19 23 31 17
17 Polonia Warszawa Polonia 19 16 28 17
18 KS Wasilków Wasilków 19 12 44 9
TEMPORADA 2015/2016
CUARTA POLONIA GRUPO 5
Equipo PJ GF GC Puntos
1 Polonia Warszawa Polonia 34 62 25 68
2 Lechia T. Mazowiecki Lechia 34 79 37 65
3 Ursus Warszawa Ursus 34 56 26 65
4 Sokół Aleksandrów Sokół 34 53 24 65
5 Legia Warszawa II Legia 34 66 38 65
6 LKS Lódz LKS Lódz 34 71 37 64
7 Pelikan Lowicz Pelikan 34 58 29 64
8 Swit Nowy Dwor Swit Nowy D. 34 61 27 63
9 Blekitni Raciaz Blekitni 34 58 52 53
10 Warta Sieradz Warta 34 43 46 43
11 Broń Radom Broń Radom 34 51 72 37
12 Warta Dzialoszyn Warta 34 33 82 35
13 Pilica Białobrzegi Pilica 34 48 60 34
14 Oskar Przysucha Oskar 34 42 78 29
15 Energia Kozienice Energia 34 41 64 27
16 Pogon Grod. Mazowiecki Pogon Grod. 34 36 60 27
17 Start Otwock Start Otwock 34 24 86 22
18 Ner Poddebice Poddebice 34 31 70 21
TEMPORADA 2014/2015
CUARTA POLONIA GRUPO 5
Equipo PJ GF GC Puntos
1 Radomiak Radom Radomiak 34 61 19 75
2 Ursus Warszawa Ursus 34 51 27 58
3 Pelikan Lowicz Pelikan 34 52 32 57
4 Broń Radom Broń Radom 34 65 47 57
5 LKS Lódz LKS Lódz 34 50 39 53
6 Warta Sieradz Warta 34 50 52 51
7 Lechia T. Mazowiecki Lechia 34 48 37 49
8 Swit Nowy Dwor Swit Nowy D. 34 45 44 49
9 Sokół Aleksandrów Sokół 34 44 44 47
10 Pogon Grod. Mazowiecki Pogon Grod. 34 51 48 46
11 Legia Warszawa II Legia 34 51 55 46
12 Pilica Białobrzegi Pilica 34 53 54 45
13 Pogoń Siedlce II Pogoń 34 51 61 45
14 Polonia Warszawa Polonia 34 57 49 42
15 Omega Kleszczów Omega 34 42 54 35
16 Wieluń Wieluń 34 42 68 34
17 Start Otwock Start Otwock 34 56 70 32
18 Targówek Targówek 34 21 90 14
TEMPORADA 2013/2014
CUARTA POLONIA GRUPO 9
Equipo PJ GF GC Puntos
1 Ursus Warszawa Ursus 38 60 28 75
2 Broń Radom Broń Radom 38 68 42 73
3 Legia Warszawa II Legia 38 72 37 71
4 Warta Sieradz Warta 38 57 46 66
5 Kutno Kutno 38 56 41 64
6 Omega Kleszczów Omega 38 59 45 61
7 Pilica Białobrzegi Pilica 38 57 46 57
8 Lechia T. Mazowiecki Lechia 38 48 37 57
9 Start Otwock Start Otwock 38 53 43 56
10 Wieluń Wieluń 38 52 45 55
11 Pogon Grod. Mazowiecki Pogon Grod. 38 43 45 53
12 Targówek Targówek 38 46 53 53
13 Widzew Łódź II Widzew 38 66 65 51
14 Sokół Aleksandrów Sokół 38 32 39 51
15 Żyrardowianka Żyrardów Żyrardowian 38 41 64 42
16 Zawisza Rzgów Zawisza 38 36 51 41
17 Bełchatów II Bełchatów 38 53 74 37
18 Huragan Wołomin Huragan 38 40 53 35
19 Mechanik Radomsko Mechanik 38 29 58 32
20 Mazur Karczew Mazur 38 22 78 18
TEMPORADA 2012/2013
CUARTA POLONIA GRUPO 7
Equipo PJ GF GC Puntos
1 KS Legionovia Legionowo Legionovia 30 63 23 74
2 Sokół Aleksandrów Sokół 30 58 17 68
3 Ursus Warszawa Ursus 30 43 34 51
4 Lechia T. Mazowiecki Lechia 30 31 24 49
5 Targówek Targówek 30 51 43 48
6 Broń Radom Broń Radom 30 44 28 46
7 Omega Kleszczów Omega 30 48 41 45
8 Wieluń Wieluń 30 46 37 44
9 Kutno Kutno 30 40 42 41
10 Pogon Grod. Mazowiecki Pogon Grod. 30 50 56 38
11 Mazur Karczew Mazur 30 32 37 34
12 Start Otwock Start Otwock 30 42 50 33
13 Zawisza Rzgów Zawisza 30 33 45 30
14 Warta Sieradz Warta 30 27 46 27
15 Włókniarz Zelów Włókniarz 30 33 56 23
16 Orzeł Wierzbica Orzeł 30 21 83 20

  USO DE MEMORIA  
6,204,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1088
Total Execution Time  0.1102
  CADENA URL  
/historico/Pogon-Mazowiecki
  GET DATOS  
$_GET['/historico/Pogon-Mazowiecki']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0029  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 = 'Pogon-Mazowiecki' 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.0018  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=60070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0033  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60070 AND type_rel = 2
0.0022  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 = '60070' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '60070' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '60070' 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 = 72655 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=60070 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 (72655,71432,67710) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72655 AND teamId = 60070
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67710 AND teamId = 60070
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60070
0.0025  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 = '60070' 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 = '60070' 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 = '60070' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 72655 WHERE rp.league_id = 72655 AND rp.teamId = 60070 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.0037  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 = 72655 WHERE rp.league_id = 72655 AND rp.teamId = 60070 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72655 WHERE rp.league_id = 72655 AND rp.teamId = 60070 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 = 60070 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  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 = 68530 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.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 `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.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 `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 = 57484 AND t.round = 36 ORDER BY team.conference ASC,t.position 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 `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 = 50429 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 15914 AND t.round = 34 ORDER BY team.conference 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 `tables2015` 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 = 9175 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 `tables2014` 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 = 28024 AND t.round = 38 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 `tables2013` 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 = 28051 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC