4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mazur Karczew
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
TEMPORADA 2011/2012
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Radomiak Radom Radomiak 30 52 17 67
2 Kutno Kutno 30 46 21 59
3 KS Legionovia Legionowo Legionovia 30 47 25 51
4 Broń Radom Broń Radom 30 44 28 47
5 Piaseczno Piaseczno 30 36 35 45
6 Ursus Warszawa Ursus 30 46 35 43
7 Omega Kleszczów Omega 30 42 38 43
8 Start Otwock Start Otwock 30 34 30 43
9 Orzeł Wierzbica Orzeł 30 28 30 43
10 Sokół Aleksandrów Sokół 30 27 30 39
11 Zawisza Rzgów Zawisza 30 27 30 39
12 Mazur Karczew Mazur 30 32 34 35
13 Hutnik Warszawa Hutnik 30 38 42 34
14 Włókniarz Zelów Włókniarz 30 33 52 34
15 Warta Sieradz Warta 30 33 47 29
16 Narew Ostrołęka Narew 30 10 81 9
TEMPORADA 2010/2011
CUARTA POLONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Pogon Siedlce Pogon 30 71 36 61
2 Broń Radom Broń Radom 30 52 36 54
3 Włókniarz Zelów Włókniarz 30 44 33 53
4 Radomiak Radom Radomiak 30 50 27 51
5 Mazur Karczew Mazur 30 50 40 51
6 Kutno Kutno 30 52 41 49
7 Sokół Aleksandrów Sokół 30 39 28 46
8 KS Legionovia Legionowo Legionovia 30 44 40 46
9 Piaseczno Piaseczno 30 26 34 36
10 Narew Ostrołęka Narew 30 35 45 36
11 Ceramika Opoczno Ceramika 30 24 34 36
12 Ursus Warszawa Ursus 30 28 39 32
13 Warta Sieradz Warta 30 41 50 30
14 SMS Lodz SMS Lodz 30 39 54 29
15 Pilica Przedbórz Pilica 30 33 57 26
16 Piotrków Trybunalski Piotrków 30 29 63 22
TEMPORADA 2009/2010
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Nadarzyn Nadarzyn 30 51 21 66
2 Radomiak Radom Radomiak 30 59 23 63
3 Piaseczno Piaseczno 30 50 23 58
4 Pogon Siedlce Pogon 30 49 40 52
5 Kutno Kutno 30 59 42 50
6 Mazur Karczew Mazur 30 41 30 47
7 Warta Sieradz Warta 30 40 38 45
8 Narew Ostrołęka Narew 30 47 41 44
9 Włókniarz Zelów Włókniarz 30 30 33 39
10 KS Legionovia Legionowo Legionovia 30 32 41 39
11 SMS Lodz SMS Lodz 30 39 34 36
12 Omega Kleszczów Omega 30 36 41 33
13 Nadnarwianka Pułtusk Nadnarwianka 30 31 41 32
14 Wisła Płock II Wisła 30 43 63 30
15 Pogoń Zduńska Wola Pogoń 30 30 56 26
16 Stal Niewiadów Stal 30 11 81 8
TEMPORADA 2008/2009
CUARTA POLONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Swit Nowy Dwor Swit Nowy D. 30 69 21 78
2 Nadarzyn Nadarzyn 30 52 29 61
3 Narew Ostrołęka Narew 29 34 19 48
4 Warta Sieradz Warta 30 36 26 48
5 Mazur Karczew Mazur 30 34 24 48
6 Nadnarwianka Pułtusk Nadnarwianka 30 40 34 48
7 SMS Lodz SMS Lodz 30 42 31 45
8 Kutno Kutno 30 48 39 45
9 KS Legionovia Legionowo Legionovia 30 32 26 41
10 Omega Kleszczów Omega 29 35 34 37
11 Stal Niewiadów Stal 30 32 42 36
12 Wisła Płock II Wisła 30 47 52 34
13 Włókniarz KL Włókniarz 30 26 35 32
14 Broń Radom Broń Radom 30 30 59 28
15 Woy Bukowiec Opoczynski Bukowiec 30 28 57 19
16 Mazowsze Grójec Mazowsze 30 23 80 14

  USO DE MEMORIA  
5,400,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.4042
Total Execution Time  0.4054
  CADENA URL  
/historico/Mazur-Karczew
  GET DATOS  
$_GET['/historico/Mazur-Karczew']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0133  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 = 'Mazur-Karczew' 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.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=88395 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=88395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88395 AND type_rel = 2
0.0127  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 = '88395' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '88395' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '88395' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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 = '88395' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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=88395 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 88395
0.0138  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 = '88395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88395' and rp.type = 4
0.0127  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 = '88395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 88395 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.0126  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 88395 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 88395 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 = 88395 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0253  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.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 `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
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 `tables2012` 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 = 28064 AND t.round = 30 ORDER BY team.conference 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 `tables2011` 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 = 28067 AND t.round = 30 ORDER BY team.conference 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 `tables2009` 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 = 28086 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC