4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1972/1973
Equipo PJ GF GC Puntos
1 Stal Mielec Stal Mielec 26 47 21 36
2 Ruch Chorzów Ruch 26 29 16 33
3 Gwardia Warszawa Gwardia 26 31 22 30
4 Górnik Zabrze Górnik 26 23 15 30
5 Wisla Kraków Wisla 26 31 28 30
6 LKS Lódz LKS Lódz 26 26 26 29
7 Energetyk ROW Rybnik Energetyk 26 20 21 26
8 Legia Warszawa Legia 26 29 28 23
9 Pogon Szczecin Pogon 26 28 30 23
10 Zagłębie Sosnowiec Zagłębie 26 30 31 22
11 Zaglebie Walbrzych Zaglebie 26 22 31 22
12 Lech Poznań Lech Poznań 26 16 26 22
13 TS Polonia Bytom Polonia 26 20 42 20
14 Odra Opole Odra Opole 26 21 36 18
Ver
TEMPORADA 1971/1972
Equipo PJ GF GC Puntos
1 Górnik Zabrze Górnik 26 45 23 37
2 Zagłębie Sosnowiec Zagłębie 26 31 26 33
3 Legia Warszawa Legia 26 36 20 32
4 Ruch Chorzów Ruch 26 46 33 30
5 Stal Mielec Stal Mielec 26 29 19 30
6 Gwardia Warszawa Gwardia 26 28 21 28
7 Odra Opole Odra Opole 26 25 27 27
8 Zaglebie Walbrzych Zaglebie 26 22 21 26
9 Wisla Kraków Wisla 26 29 34 25
10 TS Polonia Bytom Polonia 26 19 31 21
11 Pogon Szczecin Pogon 26 24 37 20
12 LKS Lódz LKS Lódz 26 24 39 19
13 Stal Rzeszow Stal Rzeszow 26 20 32 18
14 Szombierki Bytom Szombierki 26 24 39 18
Ver
TEMPORADA 1970/1971
Equipo PJ GF GC Puntos
1 Górnik Zabrze Górnik 26 43 21 39
2 Legia Warszawa Legia 26 39 20 34
3 Zaglebie Walbrzych Zaglebie 26 24 24 27
4 Pogon Szczecin Pogon 26 23 32 27
5 Ruch Chorzów Ruch 26 43 32 25
6 Szombierki Bytom Szombierki 26 30 32 25
7 Zagłębie Sosnowiec Zagłębie 26 32 37 25
8 Wisla Kraków Wisla 26 26 36 25
9 Stal Rzeszow Stal Rzeszow 26 34 26 24
10 Stal Mielec Stal Mielec 26 27 33 24
11 Gwardia Warszawa Gwardia 26 24 28 23
12 TS Polonia Bytom Polonia 26 15 22 23
13 Energetyk ROW Rybnik Energetyk 26 15 22 22
14 GKS Katowice Katowice 26 20 30 21
Ver
TEMPORADA 1969/1970
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 26 43 17 57
2 Górnik Zabrze Górnik 26 35 20 48
3 Ruch Chorzów Ruch 26 42 20 47
4 TS Polonia Bytom Polonia 26 27 22 42
5 Zagłębie Sosnowiec Zagłębie 26 36 32 38
6 Gwardia Warszawa Gwardia 26 26 23 35
7 GKS Katowice Katowice 26 19 18 34
8 Stal Rzeszow Stal Rzeszow 26 30 36 32
9 Wisla Kraków Wisla 26 20 28 31
10 Szombierki Bytom Szombierki 26 25 33 29
11 Zaglebie Walbrzych Zaglebie 26 20 28 28
12 Pogon Szczecin Pogon 26 21 31 27
13 Odra Opole Odra Opole 26 22 36 27
14 KS Cracovia KS Cracovia 26 16 38 13
Ver
TEMPORADA 1927/1928
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 28 98 36 62
2 Warta Poznan Warta Poznan 28 63 39 56
3 Legia Warszawa Legia 28 77 43 53
4 KS Cracovia KS Cracovia 28 70 42 51
5 FC Katowice FC Katowice 28 64 49 51
6 Pogon Lwow Pogon Lwow 28 61 55 45
7 Polonia Warszawa Polonia 28 63 61 44
8 Czarni Lwów Czarni Lwów 28 54 51 42
9 Turystów Lodz Turystów 28 51 49 42
10 Warszawianka Warszawianka 28 50 60 40
11 LKS Lódz LKS Lódz 28 58 57 35
12 Ruch Chorzów Ruch 28 43 54 35
13 Hasmonea Lwów Hasmonea 28 43 71 21
14 Slask Swietochlowice Slask 28 29 86 17
15 TKS Torun TKS Torun 28 28 99 8
Ver
TEMPORADA 1926/1927
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 26 95 32 59
2 FC Katowice FC Katowice 26 67 43 54
3 Warta Poznan Warta Poznan 26 79 55 47
4 Pogon Lwow Pogon Lwow 27 72 43 45
5 Legia Warszawa Legia 26 70 65 39
6 Turystów Lodz Turystów 26 52 57 39
7 LKS Lódz LKS Lódz 26 54 51 36
8 TKS Torun TKS Torun 26 56 86 35
9 Czarni Lwów Czarni Lwów 26 45 50 34
10 Polonia Warszawa Polonia 26 61 68 34
11 Ruch Chorzów Ruch 26 35 54 32
12 Hasmonea Lwów Hasmonea 27 56 85 31
13 Warszawianka Warszawianka 26 52 64 26
14 Jutrzenka Kraków Jutrzenka 26 41 82 14
Ver
TEMPORADA 1924/1925
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 4 10 3 9
2 LKS Lódz LKS Lódz 4 9 4 9
3 Wyzwolenie Wyzwolenie 4 0 12 0
Ver
TEMPORADA 1922/1923
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 6 20 6 13
2 Warta Poznan Warta Poznan 6 20 9 11
3 LKS Lódz LKS Lódz 6 21 11 10
4 Iskra Pszczyna Iskra 6 1 36 0
Ver
TEMPORADA 1921/1922
Equipo PJ GF GC Puntos
1 Pogon Szczecin Pogon 6 37 6 15
2 KS Cracovia KS Cracovia 6 34 7 15
3 Śląsk Wrocław Śląsk 6 6 32 3
4 Ruch Chorzów Ruch 6 6 38 3
Ver
TEMPORADA 1920/1921
Equipo PJ GF GC Puntos
1 KS Cracovia KS Cracovia 8 31 7 22
2 Polonia Warszawa Polonia 8 13 9 15
3 Warta Poznan Warta Poznan 8 14 24 11
4 Pogon Szczecin Pogon 8 19 13 9
5 LKS Lódz LKS Lódz 8 7 31 1

  USO DE MEMORIA  
5,576,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1094
Total Execution Time  0.1114
  CADENA URL  
/polonia1973/grupo1/historico
  GET DATOS  
$_GET['/polonia1973/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0020  SELECT type FROM routes WHERE alias = 'polonia1973'
0.0047  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'polonia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0029  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 = 10722 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 128 AND group_code = 1 and tables = 1 AND year <= 1973 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0082  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 `tables1973` 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 = 10722 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 `tables1972` 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 = 10721 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061  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 `tables1971` 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 = 10720 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 `tables1970` 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 = 26386 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables1928` 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 = 26404 AND t.round = 30 ORDER BY team.conference 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 `tables1927` 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 = 26400 AND t.round = 27 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 `tables1925` 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 = 26394 AND t.round = 1 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 `tables1923` 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 = 26385 AND t.round = 6 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 `tables1922` 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 = 26382 AND t.round = 6 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 `tables1921` 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 = 26380 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:41:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:41:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:41:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:41:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'polonia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events1973 e ON e.player_id = p.id AND e.league_id = 10722 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10722 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.0028  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 events1973 e ON e.player_id = p.id AND e.league_id = 10722 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10722 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 events1973 e ON e.player_id = p.id AND e.league_id = 10722 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10722 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 10722 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC