4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2023
 
Liga Polaca Sub 17 2023 G 1
2022/2023

CLJ GR.1 Jesienna-Wiosenna

Liga Polaca Sub 17 2023 G 1

  • Legia Warszawa Sub 17
  • AP Jag. Bialystok Sub 17
  • UKS SMS Lodz Sub 17
  • Wisła Kraków Sub 17
  • S.S.M. Wisla Plock Sub 17
  • Korona Kielce Sub 17
  • Escola Varsovia Sub 17
  • Cracovia Kraków Sub 17
  • MKS Polonia W-Wa Sub 17
  • Stal Rzeszów Sub 17
  • Motor Lublin Sub 17
  • Hutnik Krakow Sub 17
  • Resovia Rzeszów Sub 17
  • Podlasie Biała Sub 17
  • Widzew Łódź Sub 17
  • LKS Lodz Sub 17
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Legia Warszawa Sub 17 Legia 30 116 35 76
2 AP Jag. Bialystok Sub 17 Jag. 30 82 42 58
3 UKS SMS Lodz Sub 17 Lodz 30 63 56 54
4 Wisła Kraków Sub 17 Wisła 30 68 56 50
5 S.S.M. Wisla Plock Sub 17 S.S.M. Wisla 30 78 71 50
6 Korona Kielce Sub 17 Korona 30 66 68 50
7 Escola Varsovia Sub 17 Escola 30 60 44 43
8 Cracovia Kraków Sub 17 Cracovia 30 64 68 41
9 MKS Polonia W-Wa Sub 17 Polonia W-Wa 30 51 73 36
10 Stal Rzeszów Sub 17 Stal 30 49 59 35
11 Motor Lublin Sub 17 Motor Lublin 30 36 48 35
12 Hutnik Krakow Sub 17 Hutnik 30 41 60 34
13 Resovia Rzeszów Sub 17 Resovia 30 42 52 33
14 Podlasie Biała Sub 17 Podlasie 30 44 70 31
15 Widzew Łódź Sub 17 Widzew 30 35 58 30
16 LKS Lodz Sub 17 Lodz 30 37 72 22
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Legia Warszawa Sub 17 Legia 14 51 20 32
2 Jag. Bialystok SSA SUB 17 Jag. 14 36 17 30
3 MKS Polonia W-Wa Sub 17 Polonia W-Wa 14 38 24 21
4 AP Jag. Bialystok Sub 17 Jag. 14 25 24 19
5 Widzew Łódź Sub 17 Widzew 14 21 22 17
6 Stomil Olsztyn Sub 17 Stomil 14 22 39 17
7 UKS SMS Lodz Sub 17 Lodz 14 27 38 12
8 MKS Zabkovia Zabki Sub 17 Zabkovia 14 12 48 6

  USO DE MEMORIA  
5,145,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3433
Total Execution Time  0.3452
  CADENA URL  
/liga-polaca-sub-172023/grupo1/historico
  GET DATOS  
$_GET['/liga-polaca-sub-172023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0124  SELECT type FROM routes WHERE alias = 'liga-polaca-sub-172023'
0.0260  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga-polaca-sub-17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2591 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2591 ORDER BY order_id ASC
0.0126  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 69944 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2591 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 69944 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 66748 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:48:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:48:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:48:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:48:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0248  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 69944 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 69944 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0243  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 69944 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 69944 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 69944 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 69944 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0151  SELECT *,(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 = 69944 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC