4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Centra Ostrów
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 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
TEMPORADA 2014/2015
CUARTA POLONIA GRUPO 4
Equipo PJ GF GC Puntos
1 Warta Poznan Warta Poznan 34 70 33 76
2 Sokół Kleczew Sokół 34 69 27 68
3 Lech Poznań II Lech Poznań 34 73 34 60
4 Polonia Środa Polonia 34 67 46 59
5 Start Warlubie Start 34 47 29 56
6 Nielba Wagrowiec Nielba 34 54 42 56
7 Centra Ostrów Centra 34 53 35 55
8 Jarota Jarocin Jarota 34 46 38 54
9 Ostrovia Ostrow Wielkop. Ostrovia 34 56 49 54
10 Wda Świecie Świecie 34 57 34 52
11 Sparta Brodnica Sparta 34 49 45 52
12 Unia Swarzędz Unia 34 64 47 46
13 Victoria Września Victoria 34 44 62 42
14 Pogoń Mogilno Pogoń 34 50 62 39
15 Unia Solec Kujawski Unia Solec. 34 39 66 31
16 Tarnovia T. Podgorne Tarnovia 34 46 82 27
17 Chełminianka Chełmno Chełminiank 34 39 91 21
18 Włocłavia Włocławek Włocłavia 34 17 118 8
TEMPORADA 2013/2014
CUARTA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sokół Kleczew Sokół 34 75 33 73
2 Start Warlubie Start 34 81 42 64
3 Unia Solec Kujawski Unia Solec. 34 58 30 61
4 Wda Świecie Świecie 34 60 42 61
5 Lech Poznań II Lech Poznań 34 70 51 60
6 Polonia Środa Polonia 34 60 39 56
7 Włocłavia Włocławek Włocłavia 34 51 42 55
8 Nielba Wagrowiec Nielba 34 58 41 54
9 Centra Ostrów Centra 34 53 51 51
10 Unia Swarzędz Unia 34 58 44 50
11 Pogoń Mogilno Pogoń 34 57 57 49
12 Polonia Leszno Polonia 34 48 45 48
13 TKP Elana Torun Elana Torun 34 42 48 47
14 Grom Plewiska Grom 34 51 64 43
15 Cuiavia Inowrocław Cuiavia 34 39 88 29
16 Dopiewo Dopiewo 34 39 68 27
17 Notecianka Pakość Notecianka 34 32 94 22
18 Fogo Luboń Fogo Luboń 34 28 81 20

  USO DE MEMORIA  
5,266,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5926
Total Execution Time  0.5939
  CADENA URL  
/historico/Centra-Ostrow
  GET DATOS  
$_GET['/historico/Centra-Ostrow']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0149  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 = 'Centra-Ostrow' 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.0153  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 = 'Centra-Ostrow' 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.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=60043 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=60043 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=60043 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=60043 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=60043 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=60043 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 38927
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60043 AND type_rel = 2
0.0146  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 = '60043' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '60043' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '60043' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '60043' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 38927 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=60043 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (38927) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 38927 AND teamId = 60043
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 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 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 = '60043' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60043' 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 = '60043' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166  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 events2018 e ON e.player_id = p.id AND e.league_id = 38927 WHERE rp.league_id = 38927 AND rp.teamId = 60043 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.0167  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 events2018 e ON e.player_id = p.id AND e.league_id = 38927 WHERE rp.league_id = 38927 AND rp.teamId = 60043 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0181  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 events2018 e ON e.player_id = p.id AND e.league_id = 38927 WHERE rp.league_id = 38927 AND rp.teamId = 60043 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 60043 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0165  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.0164  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.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 `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 = 9174 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0174  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 = 28010 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 38927 ORDER BY nameShow LIMIT 100