Resultados
« Jornada Anterior
Jornada 29
Jornada Siguiente »
 
19 Abr 24
Sin comenzar 		Korona Kielce Korona Kielce
18:00
 		Radomiak Radom Radomiak Radom más información ...
 
19 Abr 24
Sin comenzar 		Raków Częstochowa Raków Częstochowa
20:30
 		Górnik Zabrze Górnik Zabrze más información ...
 
20 Abr 24
Sin comenzar 		Pogon Szczecin Pogon Szczecin
15:00
 		Piast Gliwice Piast Gliwice más información ...
 
20 Abr 24
Sin comenzar 		Ruch Chorzów Ruch Chorzów
17:30
 		Widzew Łódź Widzew Łódź más información ...
 
20 Abr 24
Sin comenzar 		Zaglebie Lubin Zaglebie Lubin
20:00
 		Jagiellonia Bialystok Jagiellonia Bialystok más información ...
 
21 Abr 24
Sin comenzar 		KS Cracovia KS Cracovia
12:30
 		Puszcza Niepolomice Puszcza Niepolomice más información ...
 
21 Abr 24
Sin comenzar 		LKS Lódz LKS Lódz
15:00
 		Lech Poznań Lech Poznań más información ...
 
21 Abr 24
Sin comenzar 		Legia Warszawa Legia Warszawa
17:30
 		Śląsk Wrocław Śląsk Wrocław más información ...
 
22 Abr 24
Sin comenzar 		Warta Poznan Warta Poznan
19:00
 		Stal Mielec Stal Mielec más información 4
Clasificación
« Jornada Anterior
Jornada 29
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Jagiellonia Bialystok Jagiellonia 52 28 15 7 6 64 38
  • VICTORIA
  • Jagiellonia Bialys. 3
  • Śląsk Wrocław 1
  • VICTORIA
  • Radomiak Radom 0
  • Jagiellonia Bialys. 2
  • VICTORIA
  • Jagiellonia Bialys. 6
  • LKS Lódz 0
  • EMPATE
  • Legia Warszawa 1
  • Jagiellonia Bialys. 1
  • DERROTA
  • Jagiellonia Bialys. 1
  • KS Cracovia 3
2 Śląsk Wrocław Śląsk Wrocław 50 28 14 8 6 38 26
  • DERROTA
  • Jagiellonia Bialys. 3
  • Śląsk Wrocław 1
  • EMPATE
  • Śląsk Wrocław 0
  • Puszcza Niepolomic. 0
  • EMPATE
  • Piast Gliwice 2
  • Śląsk Wrocław 2
  • VICTORIA
  • Śląsk Wrocław 2
  • Warta Poznan 1
  • DERROTA
  • Górnik Zabrze 2
  • Śląsk Wrocław 0
3 Lech Poznań Lech Poznań 48 28 13 9 6 40 32
  • EMPATE
  • Górnik Zabrze 0
  • Lech Poznań 0
  • VICTORIA
  • Lech Poznań 2
  • Warta Poznan 0
  • EMPATE
  • Stal Mielec 0
  • Lech Poznań 0
  • VICTORIA
  • Lech Poznań 1
  • Pogon Szczecin 0
  • DERROTA
  • Puszcza Niepolomic. 2
  • Lech Poznań 1
4 Pogon Szczecin Pogon Szczecin 47 28 14 5 9 54 32
  • DERROTA
  • Pogon Szczecin 0
  • Zaglebie Lubin 2
  • EMPATE
  • Korona Kielce 2
  • Pogon Szczecin 2
  • VICTORIA
  • Pogon Szczecin 3
  • KS Cracovia 1
  • DERROTA
  • Lech Poznań 1
  • Pogon Szczecin 0
  • VICTORIA
  • Pogon Szczecin 5
  • Ruch Chorzów 0
5 Raków Częstochowa Raków 46 28 12 10 6 50 31
  • VICTORIA
  • Korona Kielce 0
  • Raków Częstochowa 2
  • EMPATE
  • LKS Lódz 1
  • Raków Częstochowa 1
  • EMPATE
  • Raków Częstochowa 1
  • Ruch Chorzów 1
  • DERROTA
  • Radomiak Radom 2
  • Raków Częstochowa 1
  • EMPATE
  • Raków Częstochowa 1
  • Legia Warszawa 1
6 Legia Warszawa Legia Warszawa 46 28 12 10 6 43 33
  • DERROTA
  • Widzew Łódź 1
  • Legia Warszawa 0
  • VICTORIA
  • Legia Warszawa 3
  • Piast Gliwice 1
  • VICTORIA
  • Górnik Zabrze 1
  • Legia Warszawa 3
  • EMPATE
  • Legia Warszawa 1
  • Jagiellonia Bialys. 1
  • EMPATE
  • Raków Częstochowa 1
  • Legia Warszawa 1
7 Górnik Zabrze Górnik Zabrze 45 28 13 6 9 38 32
  • EMPATE
  • Górnik Zabrze 0
  • Lech Poznań 0
  • VICTORIA
  • Ruch Chorzów 1
  • Górnik Zabrze 2
  • DERROTA
  • Górnik Zabrze 1
  • Legia Warszawa 3
  • VICTORIA
  • Zaglebie Lubin 1
  • Górnik Zabrze 2
  • VICTORIA
  • Górnik Zabrze 2
  • Śląsk Wrocław 0
8 Widzew Łódź Widzew Łódź 39 28 11 6 11 36 36
  • VICTORIA
  • Widzew Łódź 1
  • Legia Warszawa 0
  • EMPATE
  • KS Cracovia 2
  • Widzew Łódź 2
  • VICTORIA
  • Widzew Łódź 3
  • Korona Kielce 1
  • VICTORIA
  • Widzew Łódź 1
  • Piast Gliwice 0
  • EMPATE
  • Stal Mielec 0
  • Widzew Łódź 0
9 Stal Mielec Stal Mielec 38 28 10 8 10 33 34
  • VICTORIA
  • Stal Mielec 3
  • Ruch Chorzów 1
  • EMPATE
  • Zaglebie Lubin 0
  • Stal Mielec 0
  • EMPATE
  • Stal Mielec 0
  • Lech Poznań 0
  • DERROTA
  • Korona Kielce 1
  • Stal Mielec 0
  • EMPATE
  • Stal Mielec 0
  • Widzew Łódź 0
10 Radomiak Radom Radomiak Radom 35 28 9 8 11 34 43
  • VICTORIA
  • Piast Gliwice 2
  • Radomiak Radom 3
  • DERROTA
  • Radomiak Radom 0
  • Jagiellonia Bialys. 2
  • EMPATE
  • Puszcza Niepolomic. 1
  • Radomiak Radom 1
  • VICTORIA
  • Radomiak Radom 2
  • Raków Częstochowa 1
  • DERROTA
  • LKS Lódz 3
  • Radomiak Radom 2
11 Zaglebie Lubin Zaglebie Lubin 35 28 9 8 11 30 41
  • VICTORIA
  • Pogon Szczecin 0
  • Zaglebie Lubin 2
  • EMPATE
  • Zaglebie Lubin 0
  • Stal Mielec 0
  • EMPATE
  • Warta Poznan 1
  • Zaglebie Lubin 1
  • DERROTA
  • Zaglebie Lubin 1
  • Górnik Zabrze 2
  • DERROTA
  • Piast Gliwice 2
  • Zaglebie Lubin 0
12 KS Cracovia KS Cracovia 32 28 6 14 8 38 39
  • EMPATE
  • Korona Kielce 1
  • KS Cracovia 1
  • EMPATE
  • KS Cracovia 2
  • Widzew Łódź 2
  • DERROTA
  • Pogon Szczecin 3
  • KS Cracovia 1
  • EMPATE
  • KS Cracovia 2
  • LKS Lódz 2
  • VICTORIA
  • Jagiellonia Bialys. 1
  • KS Cracovia 3
13 Piast Gliwice Piast Gliwice 32 28 6 14 8 28 32
  • VICTORIA
  • Piast Gliwice 1
  • Puszcza Niepolomic. 0
  • DERROTA
  • Legia Warszawa 3
  • Piast Gliwice 1
  • EMPATE
  • Piast Gliwice 2
  • Śląsk Wrocław 2
  • DERROTA
  • Widzew Łódź 1
  • Piast Gliwice 0
  • VICTORIA
  • Piast Gliwice 2
  • Zaglebie Lubin 0
14 Warta Poznan Warta Poznan 31 28 7 10 11 26 33
  • DERROTA
  • Warta Poznan 0
  • LKS Lódz 1
  • DERROTA
  • Lech Poznań 2
  • Warta Poznan 0
  • EMPATE
  • Warta Poznan 1
  • Zaglebie Lubin 1
  • DERROTA
  • Śląsk Wrocław 2
  • Warta Poznan 1
  • VICTORIA
  • Warta Poznan 1
  • Korona Kielce 0
15 Puszcza Niepolomice Puszcza 29 28 6 11 11 34 46
  • DERROTA
  • Piast Gliwice 1
  • Puszcza Niepolomic. 0
  • EMPATE
  • Śląsk Wrocław 0
  • Puszcza Niepolomic. 0
  • EMPATE
  • Puszcza Niepolomic. 1
  • Radomiak Radom 1
  • EMPATE
  • Ruch Chorzów 0
  • Puszcza Niepolomic. 0
  • VICTORIA
  • Puszcza Niepolomic. 2
  • Lech Poznań 1
16 Korona Kielce Korona Kielce 27 28 5 12 11 30 38
  • DERROTA
  • Korona Kielce 0
  • Raków Częstochowa 2
  • EMPATE
  • Korona Kielce 2
  • Pogon Szczecin 2
  • DERROTA
  • Widzew Łódź 3
  • Korona Kielce 1
  • VICTORIA
  • Korona Kielce 1
  • Stal Mielec 0
  • DERROTA
  • Warta Poznan 1
  • Korona Kielce 0
17 LKS Lódz LKS Lódz 21 28 5 6 17 26 58
  • VICTORIA
  • Warta Poznan 0
  • LKS Lódz 1
  • EMPATE
  • LKS Lódz 1
  • Raków Częstochowa 1
  • DERROTA
  • Jagiellonia Bialys. 6
  • LKS Lódz 0
  • EMPATE
  • KS Cracovia 2
  • LKS Lódz 2
  • VICTORIA
  • LKS Lódz 3
  • Radomiak Radom 2
18 Ruch Chorzów Ruch Chorzów 20 28 2 14 12 29 47
  • DERROTA
  • Stal Mielec 3
  • Ruch Chorzów 1
  • DERROTA
  • Ruch Chorzów 1
  • Górnik Zabrze 2
  • EMPATE
  • Raków Częstochowa 1
  • Ruch Chorzów 1
  • EMPATE
  • Ruch Chorzów 0
  • Puszcza Niepolomic. 0
  • DERROTA
  • Pogon Szczecin 5
  • Ruch Chorzów 0
Campeón : Jagiellonia
: Śląsk Wrocław, Lech Poznań
Descenso : Korona Kielce, LKS Lódz, Ruch Chorzów
JUGADORES DESTACADOS

INFORMACIÓN

La Ekstraklasa es la máxima categoría de la liga de fútbol de Polonia (Ligapolska). Fue creada en 1927.


Es una liga de las menos importantes de Europa pero está situada sobre el puesto 20 mas o menos

Liga Polaca

19 Abr 24 18:00
Estadio Municipal De Kielce
19 Abr 24 20:30
Miejski Stadion Piłkarski `Raków´
20 Abr 24 15:00
Stadion Miejski Im. Floriana Krygiera
20 Abr 24 17:30
Estadio Ruch Chorzów
20 Abr 24 20:00
Stadion Zagłębia Lubin

  USO DE MEMORIA  
6,344,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3042
Total Execution Time  0.3063
  CADENA URL  
/polonia/grupo1/jornada29
  GET DATOS  
$_GET['/polonia/grupo1/jornada29']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=128 AND type_rel = 3
0.0111  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 128 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1308917,1277727,1235369,1231836,1227810) ORDER BY n.cover_points DESC, update_date DESC
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 05:16:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 05:16:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 05:16:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 05:16:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=72168 AND rel.round=29
0.0127  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72168 AND c.`round` = 29 ORDER BY shedule ASC LIMIT 200
0.0121  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 72168 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (19369,19373,19372,19374,19376,19368,19370,19371,19375) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0129  SELECT name,eventId,odds,id_,live_id,site, link FROM bet_relations WHERE typeId=40 AND (site='bet365' AND eventId IN (152724332,152724342,152724348,152724351,152724355,152724357,152724359,152724361,152724363)) ORDER BY FIELD(site,'mbet', 'bet365', 'sportium', 'marca', 'bwin', 'b888sport'), eventId ASC
0.0162  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 29 AND e.real_date IS NOT NULL AND e.league_id = 72168 ORDER BY total DESC LIMIT 40
0.0156  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 72168 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0110  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 = 72168 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  SELECT *,(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 = 72168 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72168 AND shedule >= '2024/04/01' AND shedule < '2024/05/01' ORDER BY shedule ASC
0.0105  SELECT data1, data2 FROM services_tags WHERE categoryId=128
0.0112  SELECT group_code, extraName from `leagues` WHERE categoryId=128 AND year=2024