4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA POLACA
Equipo PJ GF GC Puntos
1 Jagiellonia Bialystok Jagiellonia 30 68 41 56
2 Górnik Zabrze Górnik 30 43 33 51
3 Śląsk Wrocław Śląsk 30 40 29 51
4 Lech Poznań Lech Poznań 29 43 34 51
5 Raków Częstochowa Raków 30 51 32 49
6 Pogon Szczecin Pogon 30 56 36 48
7 Legia Warszawa Legia 29 43 33 47
8 Widzew Łódź Widzew 30 39 39 42
9 Piast Gliwice Piast 30 32 32 38
10 Stal Mielec Stal Mielec 29 35 39 38
11 Zaglebie Lubin Zaglebie 29 31 43 35
12 Radomiak Radom Radomiak 29 34 47 35
13 Warta Poznan Warta Poznan 30 31 37 34
14 Puszcza Niepolomice Puszcza 29 35 46 32
15 KS Cracovia KS Cracovia 29 38 40 32
16 Korona Kielce Korona 29 34 38 30
17 Ruch Chorzów Ruch 30 34 52 23
18 LKS Lódz LKS Lódz 30 29 65 21
TEMPORADA 2022/2023
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 58 36 66
2 Ruch Chorzów Ruch 34 48 33 62
3 Termalica Nieciecza Termalica 34 55 37 61
4 Wisla Kraków Wisla 34 61 38 60
5 Puszcza Niepolomice Puszcza 34 49 36 58
6 Stal Rzeszow Stal Rzeszow 34 57 44 51
7 Podbeskidzie Podbeskidzie 34 56 47 49
8 Arka Gdynia Arka Gdynia 34 56 45 48
9 Chrobry Głogów Chrobry 34 44 53 46
10 GKS Katowice Katowice 34 41 39 44
11 Zagłębie Sosnowiec Zagłębie 34 33 43 42
12 Górnik Łęczna Górnik 34 40 45 40
13 GKS Tychy GKS Tychy 34 46 52 39
14 Resovia Rzeszów Resovia 34 43 51 38
15 Odra Opole Odra Opole 34 39 48 37
16 SKRA Częstochowa SKRA 34 19 50 31
17 Chojniczanka Chojnice Chojniczanka 34 35 57 27
18 Sandecja Nowy Sacz Sandecja 34 28 54 27
TEMPORADA 2021/2022
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Miedz Legnica Miedz 34 56 22 77
2 Widzew Łódź Widzew 34 53 38 62
3 Arka Gdynia Arka Gdynia 34 62 39 61
4 Korona Kielce Korona 34 46 37 56
5 Odra Opole Odra Opole 34 51 46 51
6 Chrobry Głogów Chrobry 34 43 34 50
7 Sandecja Nowy Sacz Sandecja 34 39 36 47
8 GKS Katowice Katowice 34 44 47 46
9 Podbeskidzie Podbeskidzie 34 48 41 45
10 LKS Lódz LKS Lódz 34 33 37 45
11 Resovia Rzeszów Resovia 34 42 39 44
12 GKS Tychy GKS Tychy 34 37 41 44
13 SKRA Częstochowa SKRA 34 28 41 38
14 Puszcza Niepolomice Puszcza 34 41 50 37
15 Zagłębie Sosnowiec Zagłębie 34 41 48 36
16 Stomil Olsztyn Stomil 34 32 52 35
17 Gornik Polkowice Gornik 34 32 54 29
18 Jastrzębie Jastrzębie 34 32 58 25
TEMPORADA 2020/2021
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Radomiak Radom Radomiak 34 49 20 68
2 Termalica Nieciecza Termalica 34 56 28 65
3 GKS Tychy GKS Tychy 34 49 27 63
4 Arka Gdynia Arka Gdynia 34 51 32 60
5 LKS Lódz LKS Lódz 34 59 41 58
6 Górnik Łęczna Górnik 34 47 30 56
7 Miedz Legnica Miedz 34 49 36 51
8 Odra Opole Odra Opole 34 35 41 49
9 Widzew Łódź Widzew 34 30 36 46
10 Sandecja Nowy Sacz Sandecja 34 42 50 45
11 Chrobry Głogów Chrobry 34 34 45 44
12 Korona Kielce Korona 34 31 46 41
13 Puszcza Niepolomice Puszcza 34 32 46 37
14 Jastrzębie Jastrzębie 34 32 48 35
15 Stomil Olsztyn Stomil 34 31 48 35
16 Resovia Rzeszów Resovia 34 27 45 32
17 Zagłębie Sosnowiec Zagłębie 34 35 43 30
18 GKS Bełchatów Bełchatów 34 24 51 23
TEMPORADA 2019/2020
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 7 12 7 53
2 Górnik Zabrze Górnik 7 12 9 53
3 Raków Częstochowa Raków 7 13 13 53
4 Wisła Płock Wisła 7 8 4 51
5 Wisla Kraków Wisla 7 7 9 45
6 Arka Gdynia Arka Gdynia 7 11 10 40
7 Korona Kielce Korona 7 8 11 35
8 LKS Lódz LKS Lódz 7 7 15 24
TEMPORADA 2018/2019
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Raków Częstochowa Raków 34 54 22 70
2 LKS Lódz LKS Lódz 34 58 23 69
3 Stal Mielec Stal Mielec 34 59 28 64
4 Sandecja Nowy Sacz Sandecja 34 35 29 55
5 Jastrzębie Jastrzębie 34 43 38 48
6 Podbeskidzie Podbeskidzie 34 52 46 48
7 GKS Tychy GKS Tychy 34 48 41 47
8 Termalica Nieciecza Termalica 34 45 46 46
9 Puszcza Niepolomice Puszcza 34 37 45 44
10 Stomil Olsztyn Stomil 34 38 43 43
11 Chojniczanka Chojnice Chojniczanka 34 49 49 42
12 Odra Opole Odra Opole 34 47 58 40
13 Warta Poznan Warta Poznan 34 31 43 39
14 Chrobry Głogów Chrobry 34 29 39 39
15 Wigry Suwalki Wigry 34 40 56 37
16 Bytovia Bytow Bytovia 34 45 50 37
17 GKS Katowice Katowice 34 34 45 37
18 Garbarnia Kraków Garbarnia 34 21 64 21
TEMPORADA 2017/2018
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Jastrzębie Jastrzębie 34 54 30 65
2 LKS Lódz LKS Lódz 34 47 23 65
3 Warta Poznan Warta Poznan 34 43 24 62
4 Garbarnia Kraków Garbarnia 34 48 35 57
5 Radomiak Radom Radomiak 34 52 37 55
6 Olimpia Elblag Olimpia 34 43 42 50
7 Siarka Tarnobrzeg Siarka 34 49 49 47
8 GKS Bełchatów Bełchatów 34 50 43 46
9 Gryf Wejherowo Gryf 34 42 46 46
10 Rozwoj Katowice Rozwoj 34 36 44 44
11 Energetyk ROW Rybnik Energetyk 34 49 57 44
12 Stal Stalowa Wola Stal Stalowa 34 44 39 44
13 Znicz Pruszkow Znicz 34 44 48 42
14 Stargard Szczeciński Stargard 34 35 39 41
15 Kluczbork Kluczbork 34 37 51 39
16 Wisla Pulawy Wisla Pulawy 34 34 44 36
17 Gwardia Koszalin Gwardia 34 36 72 28
18 KS Legionovia Legionowo Legionovia 34 36 56 27
TEMPORADA 2016/2017
CUARTA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Drwęca Nowe Miasto L Drwęca Nowe 34 80 33 75
2 LKS Lódz LKS Lódz 34 60 18 73
3 Widzew Łódź Widzew 34 57 34 66
4 Swit Nowy Dwor Swit Nowy D. 34 61 32 62
5 Lechia T. Mazowiecki Lechia 34 59 37 55
6 Sokół Ostróda Sokół 34 53 39 54
7 Pelikan Lowicz Pelikan 34 50 39 53
8 Legia Warszawa II Legia 34 58 51 53
9 Sokół Aleksandrów Sokół 34 46 34 49
10 LKS Łomża LKS Łomża 34 37 34 46
11 MKS Ełk MKS Ełk 34 45 51 44
12 Huragan Morag Huragan 34 43 39 43
13 Ursus Warszawa Ursus 34 43 44 42
14 Jagiellonia II Jagiellonia 34 34 50 40
15 Concordia Elblag Concordia 34 59 57 39
16 Huragan Wołomin Huragan 34 27 84 25
17 Ruch Wysokie Mazowieckie Ruch Wysokie 34 26 69 21
18 Motor Lubawa Motor Lubawa 34 15 108 5
TEMPORADA 2015/2016
CUARTA POLONIA GRUPO 5
Equipo PJ GF GC Puntos
1 Polonia Warszawa Polonia 34 62 25 68
2 Lechia T. Mazowiecki Lechia 34 79 37 65
3 Ursus Warszawa Ursus 34 56 26 65
4 Sokół Aleksandrów Sokół 34 53 24 65
5 Legia Warszawa II Legia 34 66 38 65
6 LKS Lódz LKS Lódz 34 71 37 64
7 Pelikan Lowicz Pelikan 34 58 29 64
8 Swit Nowy Dwor Swit Nowy D. 34 61 27 63
9 Blekitni Raciaz Blekitni 34 58 52 53
10 Warta Sieradz Warta 34 43 46 43
11 Broń Radom Broń Radom 34 51 72 37
12 Warta Dzialoszyn Warta 34 33 82 35
13 Pilica Białobrzegi Pilica 34 48 60 34
14 Oskar Przysucha Oskar 34 42 78 29
15 Energia Kozienice Energia 34 41 64 27
16 Pogon Grod. Mazowiecki Pogon Grod. 34 36 60 27
17 Start Otwock Start Otwock 34 24 86 22
18 Ner Poddebice Poddebice 34 31 70 21
TEMPORADA 2014/2015
CUARTA POLONIA GRUPO 5
Equipo PJ GF GC Puntos
1 Radomiak Radom Radomiak 34 61 19 75
2 Ursus Warszawa Ursus 34 51 27 58
3 Pelikan Lowicz Pelikan 34 52 32 57
4 Broń Radom Broń Radom 34 65 47 57
5 LKS Lódz LKS Lódz 34 50 39 53
6 Warta Sieradz Warta 34 50 52 51
7 Lechia T. Mazowiecki Lechia 34 48 37 49
8 Swit Nowy Dwor Swit Nowy D. 34 45 44 49
9 Sokół Aleksandrów Sokół 34 44 44 47
10 Pogon Grod. Mazowiecki Pogon Grod. 34 51 48 46
11 Legia Warszawa II Legia 34 51 55 46
12 Pilica Białobrzegi Pilica 34 53 54 45
13 Pogoń Siedlce II Pogoń 34 51 61 45
14 Polonia Warszawa Polonia 34 57 49 42
15 Omega Kleszczów Omega 34 42 54 35
16 Wieluń Wieluń 34 42 68 34
17 Start Otwock Start Otwock 34 56 70 32
18 Targówek Targówek 34 21 90 14
TEMPORADA 2012/2013
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zawisza Bydgoszcz Zawisza 34 69 26 66
2 KS Cracovia KS Cracovia 34 48 35 64
3 Termalica Nieciecza Termalica 34 54 28 63
4 Swinoujscie Swinoujscie 34 57 33 63
5 Arka Gdynia Arka Gdynia 34 46 29 57
6 GKS Tychy GKS Tychy 34 44 28 55
7 Dolcan Zabki Dolcan Zabki 34 52 41 54
8 Miedz Legnica Miedz 34 49 42 53
9 Olimpia Grudziadz Olimpia 34 39 34 51
10 GKS Katowice Katowice 34 43 36 50
11 Kolejarz Stroze Kolejarz 34 47 45 50
12 Górnik Łęczna Górnik 34 37 42 46
13 Stomil Olsztyn Stomil 34 37 45 38
14 Sandecja Nowy Sacz Sandecja 34 35 54 37
15 Brzesko Brzesko 34 38 54 32
16 Warta Poznan Warta Poznan 34 34 57 28
17 TS Polonia Bytom Polonia 34 29 64 22
18 LKS Lódz LKS Lódz 34 17 82 14
TEMPORADA 2011/2012
LIGA POLACA
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Śląsk 30 47 31 56
2 Ruch Chorzów Ruch 30 44 28 55
3 Legia Warszawa Legia 30 42 17 53
4 Lech Poznań Lech Poznań 30 42 22 52
5 Korona Kielce Korona 30 34 29 48
6 Polonia W. Polonia W. 30 33 32 45
7 Wisla Kraków Wisla 30 29 26 43
8 Górnik Zabrze Górnik 30 36 30 42
9 Zaglebie Lubin Zaglebie 30 36 42 40
10 Widzew Łódź Widzew 30 25 26 39
11 Jagiellonia Bialystok Jagiellonia 30 35 45 39
12 Podbeskidzie Podbeskidzie 30 26 39 35
13 GKS Bełchatów Bełchatów 30 34 36 31
14 Lechia Gdansk Lechia 30 21 30 31
15 LKS Lódz LKS Lódz 30 23 53 24
16 KS Cracovia KS Cracovia 30 20 41 22
TEMPORADA 2010/2011
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 59 34 71
2 Podbeskidzie Podbeskidzie 34 53 23 69
3 Swinoujscie Swinoujscie 34 58 34 66
4 Sandecja Nowy Sacz Sandecja 34 52 34 56
5 Piast Gliwice Piast 34 45 31 52
6 Pogon Szczecin Pogon 34 55 42 51
7 Górnik Łęczna Górnik 34 44 39 50
8 Warta Poznan Warta Poznan 34 44 43 50
9 Ruch Radzionków Ruch 34 34 32 46
10 Gornik Polkowice Gornik 34 31 39 42
11 GKS Katowice Katowice 34 47 57 41
12 Kolejarz Stroze Kolejarz 34 30 43 38
13 Dolcan Zabki Dolcan Zabki 34 33 39 37
14 Termalica Nieciecza Termalica 34 40 53 37
15 Kluczbork Kluczbork 34 36 44 36
16 KSZO Ostrowiec KSZO 34 32 43 36
17 Odra Wodzislaw Slaski Odra 34 29 58 32
18 Warta Gorzów Warta 34 28 62 29
TEMPORADA 2009/2010
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 62 17 77
2 Górnik Zabrze Górnik 34 47 30 61
3 Sandecja Nowy Sacz Sandecja 34 55 42 59
4 LKS Lódz LKS Lódz 34 51 45 55
5 Pogon Szczecin Pogon 34 46 35 51
6 Kluczbork Kluczbork 34 43 37 46
7 Swinoujscie Swinoujscie 34 33 36 46
8 KSZO Ostrowiec KSZO 34 37 46 46
9 Warta Gorzów Warta 34 34 33 45
10 Podbeskidzie Podbeskidzie 34 45 38 44
11 Warta Poznan Warta Poznan 34 49 45 44
12 Górnik Łęczna Górnik 34 38 45 44
13 GKS Katowice Katowice 34 41 41 43
14 Dolcan Zabki Dolcan Zabki 34 37 43 42
15 Wisła Płock Wisła 34 43 51 40
16 Znicz Pruszkow Znicz 34 32 48 39
17 Stal Stalowa Wola Stal Stalowa 34 32 58 25
18 Motor Lublin Motor Lublin 34 27 62 23
TEMPORADA 2008/2009
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 53 21 64
2 Legia Warszawa Legia 30 52 17 61
3 Lech Poznań Lech Poznań 30 51 24 59
4 Polonia Warszawa Polonia 30 40 23 54
5 GKS Bełchatów Bełchatów 30 40 28 54
6 Śląsk Wrocław Śląsk 30 40 34 45
7 TS Polonia Bytom Polonia 30 30 46 35
8 LKS Lódz LKS Lódz 30 27 43 35
9 Jagiellonia Bialystok Jagiellonia 30 28 34 34
10 Ruch Chorzów Ruch 30 22 32 34
11 Piast Gliwice Piast 30 17 26 33
12 Lechia Gdansk Lechia 30 30 44 32
13 Odra Wodzislaw Slaski Odra 30 23 40 32
14 Arka Gdynia Arka Gdynia 30 27 39 30
15 KS Cracovia KS Cracovia 30 24 40 30
16 Górnik Zabrze Górnik 30 20 33 29
TEMPORADA 2007/2008
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 68 18 77
2 Legia Warszawa Legia 30 48 17 63
3 Dyskobolia Grodzisk Dyskobolia 30 52 24 60
4 Lech Poznań Lech Poznań 30 55 32 57
5 Zaglebie Lubin Zaglebie 30 43 30 52
6 Korona Kielce Korona 30 38 32 51
7 KS Cracovia KS Cracovia 30 30 32 39
8 Górnik Zabrze Górnik 30 34 39 39
9 GKS Bełchatów Bełchatów 30 26 32 38
10 Ruch Chorzów Ruch 30 35 41 34
11 LKS Lódz LKS Lódz 30 25 31 30
12 Odra Wodzislaw Slaski Odra 30 28 47 29
13 TS Polonia Bytom Polonia 30 22 45 28
14 Jagiellonia Bialystok Jagiellonia 30 27 57 27
15 Widzew Łódź Widzew 30 27 42 26
16 Zagłębie Sosnowiec Zagłębie 30 19 58 16
TEMPORADA 2006/2007
LIGA POLACA
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 30 57 29 62
2 GKS Bełchatów Bełchatów 30 63 32 61
3 Legia Warszawa Legia 30 53 33 52
4 KS Cracovia KS Cracovia 30 48 41 49
5 Dyskobolia Grodzisk Dyskobolia 30 40 26 48
6 Lech Poznań Lech Poznań 30 53 36 47
7 Korona Kielce Korona 30 41 34 47
8 Wisla Kraków Wisla 30 41 25 46
9 LKS Lódz LKS Lódz 30 31 30 41
10 Arka Gdynia Arka Gdynia 30 43 39 40
11 Odra Wodzislaw Slaski Odra 30 29 36 40
12 Widzew Łódź Widzew 30 27 48 28
13 Górnik Łęczna Górnik 30 24 64 26
14 Górnik Zabrze Górnik 30 30 51 25
15 Wisła Płock Wisła 30 20 47 23
16 Pogon Szczecin Pogon 30 24 53 16
TEMPORADA 2005/2006
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 53 28 62
2 LKS Lódz LKS Lódz 34 42 21 58
3 Jagiellonia Bialystok Jagiellonia 34 48 30 56
4 Śląsk Wrocław Śląsk 34 38 35 56
5 Zagłębie Sosnowiec Zagłębie 34 48 34 54
6 Zawisza Bydgoszcz Zawisza 34 38 26 53
7 Ruch Chorzów Ruch 34 50 36 51
8 Piast Gliwice Piast 34 44 33 48
9 KSZO Ostrowiec KSZO 34 37 41 46
10 Gornik Polkowice Gornik 34 36 37 45
11 Lechia Gdansk Lechia 34 33 39 45
12 Heko Heko 34 40 42 43
13 Podbeskidzie Podbeskidzie 34 37 38 41
14 Radomiak Radom Radomiak 34 39 46 35
15 TS Polonia Bytom Polonia 34 32 51 35
16 Swit Nowy Dwor Swit Nowy D. 34 27 54 30
17 Szczakowianka Jaworzno Szczakowiank 34 28 63 29
18 Drwęca Nowe Miasto L Drwęca Nowe 34 31 47 26
TEMPORADA 2004/2005
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Korona Kielce Korona 34 51 33 67
2 GKS Bełchatów Bełchatów 34 58 35 66
3 Arka Gdynia Arka Gdynia 34 44 23 64
4 Widzew Łódź Widzew 34 44 26 58
5 Podbeskidzie Podbeskidzie 34 39 33 58
6 Jagiellonia Bialystok Jagiellonia 34 45 29 54
7 Kujawiak Wloclawek Kujawiak 34 48 36 54
8 Zagłębie Sosnowiec Zagłębie 34 48 44 54
9 LKS Lódz LKS Lódz 34 48 42 51
10 KSZO Ostrowiec KSZO 34 43 41 50
11 Swit Nowy Dwor Swit Nowy D. 34 34 30 49
12 Gornik Polkowice Gornik 34 29 42 41
13 Piast Gliwice Piast 34 29 37 36
14 Ruch Chorzów Ruch 34 36 50 35
15 Szczakowianka Jaworzno Szczakowiank 34 37 38 33
16 Radomiak Radom Radomiak 34 34 48 31
17 Mlawa Mlawa 34 25 47 28
18 Radomsko Radomsko 34 28 86 11

  USO DE MEMORIA  
7,877,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1516
Total Execution Time  0.1528
  CADENA URL  
/historico/Lks-Lodz
  GET DATOS  
$_GET['/historico/Lks-Lodz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0031  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 = 'Lks-Lodz' 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.0018  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=1568 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1568 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1568 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=1568 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1568 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1568 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (274745,275113,455046,1199318) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '1568' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '1568' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72168 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=1568 AND l.year in (2023,2024,2025) 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 (72171,72168,71432,67920) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 1568
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67920 AND teamId = 1568
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 1568
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1568
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 `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 = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '1568' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1568' and rp.type = 4
0.0019  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 = '1568' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 events2024 e ON e.player_id = p.id AND e.league_id = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 1568 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.0031  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 events2024 e ON e.player_id = p.id AND e.league_id = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 1568 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2024 e ON e.player_id = p.id AND e.league_id = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 1568 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 1568 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67920 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 63249 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 58338 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 49920 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.0021  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 `tables2020` 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 = 56792 AND t.round = 7 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 44126 AND t.round = 34 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 `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 = 38759 AND t.round = 34 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 `tables2017` 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 = 33762 AND t.round = 34 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 `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 = 15914 AND t.round = 34 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 `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 = 9175 AND t.round = 34 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 `tables2013` 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 = 8850 AND t.round = 34 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 `tables2012` 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 = 1363 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 `tables2011` 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 = 8845 AND t.round = 34 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 `tables2010` 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 = 8842 AND t.round = 34 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 `tables2009` 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 = 803 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 `tables2008` 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 = 8782 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2007` 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 = 8785 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 `tables2006` 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 = 8833 AND t.round = 34 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 `tables2005` 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 = 8832 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC