4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1989/1990
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 30 45 25 38
2 Zaglebie Lubin Zaglebie 30 37 23 38
3 GKS Katowice Katowice 30 31 17 38
4 Górnik Zabrze Górnik 30 37 27 36
5 Legia Warszawa Legia 30 27 18 36
6 Olimpia Poznan Olimpia 30 35 23 34
7 LKS Lódz LKS Lódz 30 35 30 34
8 Zawisza Bydgoszcz Zawisza 30 36 25 33
9 Wisla Kraków Wisla 30 32 33 28
10 Śląsk Wrocław Śląsk 30 30 34 26
11 Stal Mielec Stal Mielec 30 27 38 26
12 Ruch Chorzów Ruch 30 31 36 25
13 Motor Lublin Motor Lublin 30 18 35 25
14 Zagłębie Sosnowiec Zagłębie 30 22 36 24
15 Widzew Łódź Widzew 30 22 39 20
16 Jagiellonia Bialystok Jagiellonia 30 19 45 19
TEMPORADA 1988/1989
LIGA POLACA
Equipo PJ GF GC Puntos
1 Ruch Chorzów Ruch 30 48 18 46
2 GKS Katowice Katowice 30 50 24 42
3 Górnik Zabrze Górnik 30 55 29 39
4 Legia Warszawa Legia 30 41 19 37
5 Stal Mielec Stal Mielec 30 35 27 33
6 Lech Poznań Lech Poznań 30 39 32 32
7 Widzew Łódź Widzew 30 27 27 30
8 Jagiellonia Bialystok Jagiellonia 30 22 27 30
9 Śląsk Wrocław Śląsk 30 34 35 28
10 Olimpia Poznan Olimpia 30 33 41 27
11 LKS Lódz LKS Lódz 30 34 45 27
12 Wisla Kraków Wisla 30 35 48 26
13 Jastrzębie Jastrzębie 30 24 43 24
14 Pogon Szczecin Pogon 30 34 50 23
15 Górnik Wałbrzych Górnik 30 22 44 19
16 Szombierki Bytom Szombierki 30 33 57 17
TEMPORADA 1987/1988
LIGA POLACA
Equipo PJ GF GC Puntos
1 Górnik Zabrze Górnik 30 65 30 45
2 Legia Warszawa Legia 30 39 27 38
3 GKS Katowice Katowice 30 40 23 37
4 LKS Lódz LKS Lódz 30 40 29 37
5 Widzew Łódź Widzew 30 28 24 31
6 Szombierki Bytom Szombierki 30 28 29 30
7 Śląsk Wrocław Śląsk 30 31 32 29
8 Lech Poznań Lech Poznań 30 29 30 29
9 Jagiellonia Bialystok Jagiellonia 30 24 25 29
10 Pogon Szczecin Pogon 30 32 36 29
11 Zaglebie Lubin Zaglebie 30 23 25 27
12 Lechia Gdansk Lechia 30 18 26 26
13 Olimpia Poznan Olimpia 30 36 46 25
14 Bałtyk Gdynia Bałtyk 30 27 41 24
15 Górnik Wałbrzych Górnik 30 24 36 23
16 Stal Stalowa Wola Stal Stalowa 30 31 56 21
TEMPORADA 1986/1987
LIGA POLACA
Equipo PJ GF GC Puntos
1 Górnik Zabrze Górnik 30 52 21 42
2 Pogon Szczecin Pogon 30 64 39 40
3 GKS Katowice Katowice 30 48 26 38
4 Legia Warszawa Legia 30 44 28 38
5 Śląsk Wrocław Śląsk 30 37 23 37
6 Widzew Łódź Widzew 30 34 29 35
7 Lech Poznań Lech Poznań 30 37 36 30
8 Zaglebie Lubin Zaglebie 30 27 27 28
9 Górnik Wałbrzych Górnik 30 31 43 27
10 LKS Lódz LKS Lódz 30 30 33 26
11 Olimpia Poznan Olimpia 30 22 38 26
12 TS Polonia Bytom Polonia 30 25 38 25
13 Lechia Gdansk Lechia 30 23 30 23
14 Ruch Chorzów Ruch 30 18 33 22
15 Stal Mielec Stal Mielec 30 27 45 22
16 Motor Lublin Motor Lublin 30 20 50 21
TEMPORADA 1985/1986
LIGA POLACA
Equipo PJ GF GC Puntos
1 Górnik Zabrze Górnik 30 70 17 46
2 Legia Warszawa Legia 30 55 29 42
3 Widzew Łódź Widzew 30 40 25 41
4 Lech Poznań Lech Poznań 30 36 29 36
5 GKS Katowice Katowice 30 46 45 31
6 Górnik Wałbrzych Górnik 30 41 50 30
7 Śląsk Wrocław Śląsk 30 39 36 29
8 LKS Lódz LKS Lódz 30 36 36 28
9 Ruch Chorzów Ruch 30 35 39 28
10 Pogon Szczecin Pogon 30 44 44 27
11 Stal Mielec Stal Mielec 30 25 32 25
12 Zaglebie Lubin Zaglebie 30 22 32 25
13 Motor Lublin Motor Lublin 30 33 47 25
14 Lechia Gdansk Lechia 30 23 35 24
15 Bałtyk Gdynia Bałtyk 30 28 47 23
16 Zagłębie Sosnowiec Zagłębie 30 24 54 20
TEMPORADA 1984/1985
LIGA POLACA
Equipo PJ GF GC Puntos
1 Górnik Zabrze Górnik 30 38 16 42
2 Legia Warszawa Legia 30 36 19 41
3 Widzew Łódź Widzew 30 34 16 38
4 Lech Poznań Lech Poznań 30 41 31 38
5 Zagłębie Sosnowiec Zagłębie 30 37 38 31
6 LKS Lódz LKS Lódz 30 31 32 30
7 Ruch Chorzów Ruch 30 28 28 29
8 Górnik Wałbrzych Górnik 30 32 35 29
9 Motor Lublin Motor Lublin 30 30 36 27
10 GKS Katowice Katowice 30 22 28 26
11 Pogon Szczecin Pogon 30 29 36 26
12 Lechia Gdansk Lechia 30 23 34 26
13 Bałtyk Gdynia Bałtyk 30 22 35 26
14 Śląsk Wrocław Śląsk 30 34 36 25
15 Radomiak Radom Radomiak 30 29 32 25
16 Wisla Kraków Wisla 30 19 33 21
TEMPORADA 1983/1984
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 30 47 21 42
2 Widzew Łódź Widzew 30 43 25 42
3 Pogon Szczecin Pogon 30 54 27 38
4 Górnik Zabrze Górnik 30 34 26 34
5 Legia Warszawa Legia 30 42 32 33
6 Górnik Wałbrzych Górnik 30 40 35 31
7 Ruch Chorzów Ruch 30 30 30 30
8 Śląsk Wrocław Śląsk 30 41 47 30
9 GKS Katowice Katowice 30 41 42 29
10 Motor Lublin Motor Lublin 30 22 24 29
11 Wisla Kraków Wisla 30 33 38 27
12 Zagłębie Sosnowiec Zagłębie 30 25 35 27
13 Bałtyk Gdynia Bałtyk 30 25 30 25
14 LKS Lódz LKS Lódz 30 29 43 25
15 KS Cracovia KS Cracovia 30 19 35 21
16 Szombierki Bytom Szombierki 30 23 58 17
TEMPORADA 1982/1983
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 30 42 31 39
2 Widzew Łódź Widzew 30 50 30 38
3 Ruch Chorzów Ruch 30 34 22 35
4 Pogon Szczecin Pogon 30 44 28 33
5 Wisla Kraków Wisla 30 44 36 32
6 Śląsk Wrocław Śląsk 30 35 34 30
7 LKS Lódz LKS Lódz 30 36 38 30
8 Legia Warszawa Legia 30 43 39 29
9 Szombierki Bytom Szombierki 30 34 37 29
10 Bałtyk Gdynia Bałtyk 30 28 31 29
11 Zagłębie Sosnowiec Zagłębie 30 29 37 29
12 Górnik Zabrze Górnik 30 30 38 28
13 GKS Katowice Katowice 30 28 34 27
14 KS Cracovia KS Cracovia 30 20 33 27
15 Stal Mielec Stal Mielec 30 27 36 24
16 Gwardia Warszawa Gwardia 30 26 46 21
TEMPORADA 1981/1982
LIGA POLACA
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Śląsk 30 40 22 39
2 Widzew Łódź Widzew 30 45 31 39
3 Legia Warszawa Legia 30 39 29 35
4 Stal Mielec Stal Mielec 30 33 26 35
5 Górnik Zabrze Górnik 30 35 27 33
6 Pogon Szczecin Pogon 30 44 43 33
7 Gwardia Warszawa Gwardia 30 36 34 32
8 Wisla Kraków Wisla 30 41 32 29
9 Zagłębie Sosnowiec Zagłębie 30 24 30 29
10 Szombierki Bytom Szombierki 30 38 30 28
11 Lech Poznań Lech Poznań 30 25 25 28
12 LKS Lódz LKS Lódz 30 30 39 28
13 Bałtyk Gdynia Bałtyk 30 24 36 26
14 Ruch Chorzów Ruch 30 29 35 25
15 Arka Gdynia Arka Gdynia 30 16 37 22
16 Motor Lublin Motor Lublin 30 34 57 19
TEMPORADA 1980/1981
LIGA POLACA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 30 39 25 39
2 Wisla Kraków Wisla 30 51 30 37
3 Legia Warszawa Legia 30 48 29 36
4 Szombierki Bytom Szombierki 30 51 33 36
5 Śląsk Wrocław Śląsk 30 32 28 36
6 Bałtyk Gdynia Bałtyk 30 30 27 36
7 Ruch Chorzów Ruch 30 36 39 30
8 Lech Poznań Lech Poznań 30 28 29 29
9 Arka Gdynia Arka Gdynia 30 40 42 28
10 Stal Mielec Stal Mielec 30 41 44 28
11 Motor Lublin Motor Lublin 30 36 45 28
12 Górnik Zabrze Górnik 30 20 27 27
13 LKS Lódz LKS Lódz 30 24 38 25
14 Zagłębie Sosnowiec Zagłębie 30 22 27 24
15 Zawisza Bydgoszcz Zawisza 30 25 43 23
16 Odra Opole Odra Opole 30 26 43 18
TEMPORADA 1979/1980
LIGA POLACA
Equipo PJ GF GC Puntos
1 Szombierki Bytom Szombierki 30 42 26 39
2 Widzew Łódź Widzew 30 47 39 36
3 Legia Warszawa Legia 30 38 31 36
4 Śląsk Wrocław Śląsk 30 40 34 36
5 Wisla Kraków Wisla 30 58 37 34
6 LKS Lódz LKS Lódz 30 38 40 32
7 Górnik Zabrze Górnik 30 36 38 32
8 Arka Gdynia Arka Gdynia 30 35 32 31
9 Odra Opole Odra Opole 30 21 26 31
10 Lech Poznań Lech Poznań 30 34 32 30
11 Ruch Chorzów Ruch 30 44 42 29
12 Zagłębie Sosnowiec Zagłębie 30 36 33 27
13 Stal Mielec Stal Mielec 30 28 34 26
14 Zawisza Bydgoszcz Zawisza 30 35 52 24
15 GKS Katowice Katowice 30 32 44 21
16 TS Polonia Bytom Polonia 30 23 47 16
TEMPORADA 1978/1979
LIGA POLACA
Equipo PJ GF GC Puntos
1 Ruch Chorzów Ruch 30 44 27 39
2 Widzew Łódź Widzew 30 37 26 39
3 Stal Mielec Stal Mielec 30 43 27 36
4 Szombierki Bytom Szombierki 30 42 27 35
5 Odra Opole Odra Opole 30 42 28 34
6 Legia Warszawa Legia 30 32 28 33
7 Lech Poznań Lech Poznań 30 34 38 30
8 GKS Katowice Katowice 30 28 36 30
9 Zagłębie Sosnowiec Zagłębie 30 22 25 29
10 Śląsk Wrocław Śląsk 30 23 27 29
11 Arka Gdynia Arka Gdynia 30 29 35 29
12 Wisla Kraków Wisla 30 42 43 26
13 LKS Lódz LKS Lódz 30 30 36 26
14 TS Polonia Bytom Polonia 30 23 39 24
15 Pogon Szczecin Pogon 30 31 41 22
16 Gwardia Warszawa Gwardia 30 22 41 19
TEMPORADA 1977/1978
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 35 23 39
2 Śląsk Wrocław Śląsk 30 36 30 38
3 Lech Poznań Lech Poznań 30 29 25 37
4 Legia Warszawa Legia 30 44 34 31
5 LKS Lódz LKS Lódz 30 29 29 31
6 Odra Opole Odra Opole 30 35 31 30
7 Arka Gdynia Arka Gdynia 30 30 35 30
8 Stal Mielec Stal Mielec 30 31 29 29
9 Zagłębie Sosnowiec Zagłębie 30 33 33 28
10 Pogon Szczecin Pogon 30 36 42 28
11 Widzew Łódź Widzew 30 34 40 28
12 TS Polonia Bytom Polonia 30 26 26 27
13 Ruch Chorzów Ruch 30 33 36 27
14 Zawisza Bydgoszcz Zawisza 30 29 32 27
15 Szombierki Bytom Szombierki 30 25 35 27
16 Górnik Zabrze Górnik 30 25 30 23
TEMPORADA 1976/1977
LIGA POLACA
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Śląsk 30 38 32 41
2 Widzew Łódź Widzew 30 46 31 38
3 Górnik Zabrze Górnik 30 41 32 37
4 Stal Mielec Stal Mielec 30 42 30 36
5 Zagłębie Sosnowiec Zagłębie 30 40 28 35
6 Pogon Szczecin Pogon 30 38 44 35
7 LKS Lódz LKS Lódz 30 35 29 33
8 Legia Warszawa Legia 30 40 38 30
9 Szombierki Bytom Szombierki 30 34 35 27
10 Wisla Kraków Wisla 30 32 33 27
11 Arka Gdynia Arka Gdynia 30 27 32 27
12 Odra Opole Odra Opole 30 36 39 26
13 Ruch Chorzów Ruch 30 30 40 26
14 Lech Poznań Lech Poznań 30 37 48 23
15 GKS Tychy GKS Tychy 30 33 41 21
16 Energetyk ROW Rybnik Energetyk 30 29 46 18
TEMPORADA 1975/1976
LIGA POLACA
Equipo PJ GF GC Puntos
1 Stal Mielec Stal Mielec 30 45 23 38
2 GKS Tychy GKS Tychy 30 38 34 38
3 Wisla Kraków Wisla 30 39 19 37
4 Ruch Chorzów Ruch 30 35 24 37
5 Widzew Łódź Widzew 30 33 33 32
6 Pogon Szczecin Pogon 30 46 42 31
7 Śląsk Wrocław Śląsk 30 36 33 31
8 Legia Warszawa Legia 30 44 46 29
9 Górnik Zabrze Górnik 30 38 39 28
10 Zagłębie Sosnowiec Zagłębie 30 37 38 28
11 Energetyk ROW Rybnik Energetyk 30 30 40 28
12 Lech Poznań Lech Poznań 30 33 46 27
13 LKS Lódz LKS Lódz 30 27 33 26
14 Szombierki Bytom Szombierki 30 37 42 25
15 Stal Rzeszow Stal Rzeszow 30 23 35 24
16 TS Polonia Bytom Polonia 30 19 33 21
TEMPORADA 1974/1975
LIGA POLACA
Equipo PJ GF GC Puntos
1 Ruch Chorzów Ruch 30 61 27 44
2 Stal Mielec Stal Mielec 30 40 24 38
3 Śląsk Wrocław Śląsk 30 40 31 36
4 Wisla Kraków Wisla 30 40 31 34
5 Zagłębie Sosnowiec Zagłębie 30 31 31 31
6 Legia Warszawa Legia 30 45 35 29
7 Górnik Zabrze Górnik 30 48 46 29
8 TS Polonia Bytom Polonia 30 25 31 28
9 Lech Poznań Lech Poznań 30 31 43 28
10 GKS Tychy GKS Tychy 30 34 38 27
11 Szombierki Bytom Szombierki 30 43 45 26
12 Pogon Szczecin Pogon 30 30 35 26
13 LKS Lódz LKS Lódz 30 26 34 26
14 Energetyk ROW Rybnik Energetyk 30 24 35 26
15 Gwardia Warszawa Gwardia 30 25 38 26
16 Arka Gdynia Arka Gdynia 30 26 45 26
TEMPORADA 1973/1974
LIGA POLACA
Equipo PJ GF GC Puntos
1 Ruch Chorzów Ruch 30 53 23 41
2 Górnik Zabrze Górnik 30 43 27 38
3 Stal Mielec Stal Mielec 30 41 24 37
4 Legia Warszawa Legia 30 38 28 34
5 Wisla Kraków Wisla 30 35 27 34
6 Energetyk ROW Rybnik Energetyk 30 24 28 29
7 LKS Lódz LKS Lódz 30 24 28 29
8 Pogon Szczecin Pogon 30 28 38 29
9 Gwardia Warszawa Gwardia 30 26 27 28
10 Lech Poznań Lech Poznań 30 25 26 28
11 Zagłębie Sosnowiec Zagłębie 30 22 31 27
12 TS Polonia Bytom Polonia 30 23 34 27
13 Śląsk Wrocław Śląsk 30 21 34 27
14 Szombierki Bytom Szombierki 30 26 31 26
15 Odra Opole Odra Opole 30 25 37 24
16 Zaglebie Walbrzych Zaglebie 30 22 33 22
TEMPORADA 1972/1973
LIGA POLACA
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
TEMPORADA 1971/1972
LIGA POLACA
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
TEMPORADA 1970/1971
LIGA POLACA
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

  USO DE MEMORIA  
7,703,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1782
Total Execution Time  0.1795
  CADENA URL  
/historico/Kp-Legia-Warszawa/1990
  GET DATOS  
$_GET['/historico/Kp-Legia-Warszawa/1990']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0042  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 = 'Kp-Legia-Warszawa' AND l.year = 1990 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.0019  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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0037  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 = 10703
0.0027  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 = 26340
0.0027  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 = 11033
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1465 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1465 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0033  SELECT /*35 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 (4368,4799,8908,11589,19665) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '1465' AND l.year = 1990 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '1465' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 10703 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 11033 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 26340 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=1465 AND l.year in (1989,1990,1991) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73011,26341,11033,10956,10704) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 10704 AND teamId = 1465
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 10956 AND teamId = 1465
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 26341 AND teamId = 1465
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 11033 AND teamId = 1465
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73011 AND teamId = 1465
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 FROM `tables1990` 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 = 10703 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '1465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1465' and rp.type = 4
0.0020  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 = '1465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1465' and rp.type = 4
0.0021  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 events1990 e ON e.player_id = p.id AND e.league_id = 10703 WHERE rp.league_id = 10703 AND rp.teamId = 1465 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.0019  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 events1990 e ON e.player_id = p.id AND e.league_id = 10703 WHERE rp.league_id = 10703 AND rp.teamId = 1465 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events1990 e ON e.player_id = p.id AND e.league_id = 10703 WHERE rp.league_id = 10703 AND rp.teamId = 1465 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 1465 AND l.year <= 1990 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 `tables1990` 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 = 10703 AND t.round = 30 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 `tables1989` 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 = 10702 AND t.round = 30 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 `tables1988` 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 = 10701 AND t.round = 30 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 `tables1987` 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 = 10700 AND t.round = 30 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 `tables1986` 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 = 10699 AND t.round = 30 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 `tables1985` 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 = 10698 AND t.round = 30 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 `tables1984` 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 = 10697 AND t.round = 30 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 `tables1983` 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 = 10696 AND t.round = 30 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 `tables1982` 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 = 10695 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1981` 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 = 10694 AND t.round = 30 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 `tables1980` 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 = 10693 AND t.round = 30 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 `tables1979` 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 = 10692 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1978` 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 = 10691 AND t.round = 30 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 `tables1977` 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 = 10690 AND t.round = 30 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 `tables1976` 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 = 10689 AND t.round = 30 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 `tables1975` 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 = 10688 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables1974` 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 = 10687 AND t.round = 30 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 `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.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 `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.0025  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