4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Warta Poznan

Warta Poznan

Entrenador: Dawid Szulczek

Temporada 2023/2024
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
LIGA POLACA
Equipo PJ GF GC Puntos
1 Raków Częstochowa Raków 34 63 24 75
2 Legia Warszawa Legia 34 57 37 66
3 Lech Poznań Lech Poznań 34 51 29 61
4 Pogon Szczecin Pogon 34 57 46 60
5 Piast Gliwice Piast 34 40 31 53
6 Górnik Zabrze Górnik 34 45 43 48
7 KS Cracovia KS Cracovia 34 41 35 46
8 Warta Poznan Warta Poznan 34 37 35 45
9 Zaglebie Lubin Zaglebie 34 35 44 45
10 Radomiak Radom Radomiak 34 34 41 44
11 Stal Mielec Stal Mielec 34 36 40 43
12 Widzew Łódź Widzew 34 38 47 41
13 Korona Kielce Korona 34 39 48 41
14 Jagiellonia Bialystok Jagiellonia 34 48 49 41
15 Śląsk Wrocław Śląsk 34 35 48 38
16 Wisła Płock Wisła 34 41 50 37
17 Lechia Gdansk Lechia 34 28 56 30
18 Miedz Legnica Miedz 34 33 55 23
TEMPORADA 2021/2022
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 34 67 24 74
2 Raków Częstochowa Raków 34 60 30 69
3 Pogon Szczecin Pogon 34 63 31 65
4 Lechia Gdansk Lechia 34 52 39 57
5 Piast Gliwice Piast 34 45 37 54
6 Wisła Płock Wisła 34 48 51 48
7 Radomiak Radom Radomiak 34 42 40 48
8 Górnik Zabrze Górnik 34 55 55 47
9 KS Cracovia KS Cracovia 34 40 42 46
10 Legia Warszawa Legia 34 46 48 43
11 Warta Poznan Warta Poznan 34 35 38 42
12 Jagiellonia Bialystok Jagiellonia 34 39 50 40
13 Zaglebie Lubin Zaglebie 34 43 59 38
14 Stal Mielec Stal Mielec 34 39 52 37
15 Śląsk Wrocław Śląsk 34 42 52 35
16 Termalica Nieciecza Termalica 34 36 56 32
17 Wisla Kraków Wisla 34 37 54 31
18 Górnik Łęczna Górnik 34 29 60 28
TEMPORADA 2020/2021
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 48 24 64
2 Raków Częstochowa Raków 30 46 25 59
3 Pogon Szczecin Pogon 30 36 23 52
4 Śląsk Wrocław Śląsk 30 36 32 43
5 Warta Poznan Warta Poznan 30 33 32 43
6 Piast Gliwice Piast 30 39 32 42
7 Lechia Gdansk Lechia 30 40 37 42
8 Zaglebie Lubin Zaglebie 30 38 40 41
9 Jagiellonia Bialystok Jagiellonia 30 39 48 37
10 Górnik Zabrze Górnik 30 31 33 37
11 Lech Poznań Lech Poznań 30 39 38 37
12 Wisła Płock Wisła 30 37 44 33
13 Wisla Kraków Wisla 30 39 42 33
14 KS Cracovia KS Cracovia 30 28 32 32
15 Stal Mielec Stal Mielec 30 31 47 29
16 Podbeskidzie Podbeskidzie 30 29 60 25
TEMPORADA 2019/2020
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Stal Mielec Stal Mielec 34 57 31 67
2 Podbeskidzie Podbeskidzie 34 64 35 65
3 Warta Poznan Warta Poznan 34 52 35 60
4 Radomiak Radom Radomiak 34 52 45 57
5 Miedz Legnica Miedz 34 49 44 51
6 Termalica Nieciecza Termalica 34 47 34 50
7 Chrobry Głogów Chrobry 34 41 44 49
8 Puszcza Niepolomice Puszcza 34 36 37 48
9 GKS Tychy GKS Tychy 34 60 53 47
10 Stomil Olsztyn Stomil 34 30 38 46
11 Sandecja Nowy Sacz Sandecja 34 45 49 44
12 Zagłębie Sosnowiec Zagłębie 34 49 55 44
13 Odra Opole Odra Opole 34 33 39 42
14 Jastrzębie Jastrzębie 34 41 46 41
15 GKS Bełchatów Bełchatów 34 36 45 40
16 Olimpia Grudziadz Olimpia 34 45 56 40
17 Chojniczanka Chojnice Chojniczanka 34 46 67 30
18 Wigry Suwalki Wigry 34 27 57 26
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
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Odra Opole Odra Opole 34 69 34 71
2 Raków Częstochowa Raków 34 64 29 71
3 Puszcza Niepolomice Puszcza 34 42 24 62
4 Radomiak Radom Radomiak 34 42 34 56
5 Olimpia Elblag Olimpia 34 59 49 50
6 Siarka Tarnobrzeg Siarka 34 51 50 47
7 Stargard Szczeciński Stargard 34 45 39 45
8 KS Legionovia Legionowo Legionovia 34 51 49 45
9 GKS Bełchatów Bełchatów 34 37 39 42
10 Stal Stalowa Wola Stal Stalowa 34 41 49 42
11 Energetyk ROW Rybnik Energetyk 34 39 47 41
12 Warta Poznan Warta Poznan 34 40 53 41
13 Rozwoj Katowice Rozwoj 34 32 39 39
14 Gryf Wejherowo Gryf 34 45 57 38
15 Polonia Warszawa Polonia 34 40 45 35
16 Kotwica Kołobrzeg Kotwica 34 39 52 35
17 Olimpia Zambrow Olimpia 34 37 55 33
18 TS Polonia Bytom Polonia 34 25 54 26
TEMPORADA 2015/2016
CUARTA POLONIA GRUPO 4
Equipo PJ GF GC Puntos
1 Warta Poznan Warta Poznan 30 57 24 62
2 Pelikan Niechanowo Pelikan 30 60 28 62
3 Lech Poznań II Lech Poznań 30 69 23 60
4 Sokół Kleczew Sokół 30 63 30 53
5 Jarota Jarocin Jarota 30 47 27 51
6 Polonia Środa Polonia 30 45 28 51
7 Wda Świecie Świecie 30 37 37 49
8 Kalisz Kalisz 30 41 41 45
9 TKP Elana Torun Elana Torun 30 51 41 44
10 Unia Swarzędz Unia 30 39 55 38
11 Start Warlubie Start 30 40 45 35
12 Centra Ostrów Centra 30 39 67 31
13 Ostrovia Ostrow Wielkop. Ostrovia 30 36 48 29
14 Nielba Wagrowiec Nielba 30 32 68 23
15 Sparta Brodnica Sparta 30 26 55 22
16 Kujawianka Kujawianka 30 26 91 12
TEMPORADA 2014/2015
CUARTA POLONIA GRUPO 4
Equipo PJ GF GC Puntos
1 Warta Poznan Warta Poznan 34 70 33 76
2 Sokół Kleczew Sokół 34 69 27 68
3 Lech Poznań II Lech Poznań 34 73 34 60
4 Polonia Środa Polonia 34 67 46 59
5 Start Warlubie Start 34 47 29 56
6 Nielba Wagrowiec Nielba 34 54 42 56
7 Centra Ostrów Centra 34 53 35 55
8 Jarota Jarocin Jarota 34 46 38 54
9 Ostrovia Ostrow Wielkop. Ostrovia 34 56 49 54
10 Wda Świecie Świecie 34 57 34 52
11 Sparta Brodnica Sparta 34 49 45 52
12 Unia Swarzędz Unia 34 64 47 46
13 Victoria Września Victoria 34 44 62 42
14 Pogoń Mogilno Pogoń 34 50 62 39
15 Unia Solec Kujawski Unia Solec. 34 39 66 31
16 Tarnovia T. Podgorne Tarnovia 34 46 82 27
17 Chełminianka Chełmno Chełminiank 34 39 91 21
18 Włocłavia Włocławek Włocłavia 34 17 118 8
TEMPORADA 2013/2014
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Chrobry Głogów Chrobry 34 55 17 68
2 Bytovia Bytow Bytovia 34 55 30 62
3 Zagłębie Sosnowiec Zagłębie 34 41 28 59
4 Stargard Szczeciński Stargard 34 58 40 55
5 Kluczbork Kluczbork 34 57 46 52
6 Górnik Wałbrzych Górnik 34 40 36 52
7 Rozwoj Katowice Rozwoj 34 40 36 52
8 TS Polonia Bytom Polonia 34 45 34 51
9 Warta Poznan Warta Poznan 34 52 50 51
10 Raków Częstochowa Raków 34 44 40 48
11 Gryf Wejherowo Gryf 34 52 49 45
12 Odra Opole Odra Opole 34 36 40 43
13 Ruch Zdzieszowice Ruch 34 50 52 41
14 Ostrovia Ostrow Wielkop. Ostrovia 34 32 43 38
15 Calisia Kalisz Calisia 34 39 57 36
16 Zielona Góra Zielona 34 37 51 34
17 Jarota Jarocin Jarota 34 31 56 32
18 Gornik Polkowice Gornik 34 15 74 17
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
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Piast Gliwice Piast 34 57 40 64
2 Pogon Szczecin Pogon 34 54 30 61
3 Zawisza Bydgoszcz Zawisza 34 47 39 59
4 Kolejarz Stroze Kolejarz 34 40 34 57
5 Termalica Nieciecza Termalica 34 42 26 56
6 Górnik Łęczna Górnik 34 50 37 54
7 Arka Gdynia Arka Gdynia 34 50 41 51
8 Swinoujscie Swinoujscie 34 46 43 49
9 Ruch Radzionków Ruch 34 46 51 48
10 Warta Poznan Warta Poznan 34 44 36 46
11 Olimpia Grudziadz Olimpia 34 46 41 43
12 Sandecja Nowy Sacz Sandecja 34 42 46 40
13 GKS Katowice Katowice 34 33 38 39
14 Dolcan Zabki Dolcan Zabki 34 40 53 39
15 TS Polonia Bytom Polonia 34 37 51 36
16 Wisła Płock Wisła 34 39 50 35
17 Gornik Polkowice Gornik 34 40 64 30
18 Olimpia Elblag Olimpia 34 33 66 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
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 55 23 72
2 Zaglebie Lubin Zaglebie 34 68 33 69
3 Korona Kielce Korona 34 51 37 61
4 Podbeskidzie Podbeskidzie 34 58 29 59
5 Górnik Łęczna Górnik 34 49 36 57
6 Znicz Pruszkow Znicz 34 42 29 55
7 Swinoujscie Swinoujscie 34 43 37 53
8 Dolcan Zabki Dolcan Zabki 34 35 31 49
9 Wisła Płock Wisła 34 45 41 47
10 Warta Poznan Warta Poznan 34 44 45 46
11 GKS Katowice Katowice 34 37 42 44
12 Stal Stalowa Wola Stal Stalowa 34 33 34 43
13 Jastrzębie Jastrzębie 34 37 48 41
14 Warta Gorzów Warta 34 39 54 36
15 Motor Lublin Motor Lublin 34 21 36 32
16 Tur Turek Tur Turek 34 29 56 30
17 Odra Opole Odra Opole 34 22 51 25
18 Kmita Zabierzów Kmita 34 11 57 21
TEMPORADA 2007/2008
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Lechia Gdansk Lechia 34 55 34 69
2 Śląsk Wrocław Śląsk 34 55 30 64
3 Arka Gdynia Arka Gdynia 34 61 30 62
4 Znicz Pruszkow Znicz 34 54 28 62
5 Piast Gliwice Piast 34 45 23 62
6 Podbeskidzie Podbeskidzie 34 53 27 58
7 Polonia Warszawa Polonia 34 45 36 50
8 Wisła Płock Wisła 34 52 51 50
9 Jastrzębie Jastrzębie 34 43 51 45
10 GKS Katowice Katowice 34 38 39 43
11 Stal Stalowa Wola Stal Stalowa 34 30 48 40
12 Odra Opole Odra Opole 34 28 39 35
13 Motor Lublin Motor Lublin 34 33 55 35
14 Warta Poznan Warta Poznan 34 29 45 32
15 Kmita Zabierzów Kmita 34 28 40 31
16 Tur Turek Tur Turek 34 23 46 31
17 LKS Łomża LKS Łomża 34 32 59 30
18 Pelikan Lowicz Pelikan 34 37 60 28
TEMPORADA 1994/1995
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 34 58 20 51
2 Widzew Łódź Widzew 34 48 25 45
3 GKS Katowice Katowice 34 45 27 42
4 Zaglebie Lubin Zaglebie 34 48 41 42
5 Górnik Zabrze Górnik 34 48 40 37
6 Lech Poznań Lech Poznań 34 47 40 34
7 LKS Lódz LKS Lódz 34 39 41 34
8 Pogon Szczecin Pogon 34 33 34 33
9 Hutnik Nowa Huta Hutnik Nowa 34 37 39 32
10 Sokol Tychy Sokol Tychy 34 33 43 32
11 Lechia Gdansk Lechia 34 46 41 31
12 Stal Mielec Stal Mielec 34 44 50 31
13 Raków Częstochowa Raków 34 31 43 31
14 Stomil Olsztyn Stomil 34 35 40 30
15 Petrochemia Petrochemia 34 35 43 30
16 Ruch Chorzów Ruch 34 39 46 29
17 Stal Stalowa Wola Stal Stalowa 34 34 47 29
18 Warta Poznan Warta Poznan 34 35 75 19
TEMPORADA 1993/1994
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 34 72 24 51
2 GKS Katowice Katowice 34 52 28 47
3 Górnik Zabrze Górnik 34 56 32 46
4 LKS Lódz LKS Lódz 34 49 24 45
5 Pogon Szczecin Pogon 34 39 24 41
6 Widzew Łódź Widzew 34 45 33 39
7 Ruch Chorzów Ruch 34 48 41 37
8 Hutnik Krakow Hutnik 34 33 30 37
9 Lech Poznań Lech Poznań 34 39 32 35
10 Sokol Tychy Sokol Tychy 34 41 40 33
11 Stal Mielec Stal Mielec 34 32 45 31
12 Zaglebie Lubin Zaglebie 34 40 47 30
13 Stal Stalowa Wola Stal Stalowa 34 25 37 30
14 Warta Poznan Warta Poznan 34 32 45 30
15 Wisla Kraków Wisla 34 30 46 25
16 Siarka Tarnobrzeg Siarka 34 25 57 19
17 Polonia Warszawa Polonia 34 28 61 19
18 Zawisza Bydgoszcz Zawisza 34 30 70 17
TEMPORADA 1927/1928
LIGA POLACA
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

  USO DE MEMORIA  
8,100,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1460
Total Execution Time  0.1472
  CADENA URL  
/historico/Warta-Poznan-57839
  GET DATOS  
$_GET['/historico/Warta-Poznan-57839']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0030  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 = 'Warta-Poznan-57839' 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.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=13363 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=13363 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=13363 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=13363 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 72171
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13363 AND type_rel = 2
0.0034  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 = '13363' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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=13363 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) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 13363
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 13363
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13363
0.0040  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 = 13363 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.0033  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 = 13363 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 = 13363 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 13363 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67771 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 `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 = 63126 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.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 `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 = 57378 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.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 `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 = 49994 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.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 `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.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 `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.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 `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 = 33388 AND t.round = 34 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 `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 = 15913 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 `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 = 9174 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 `tables2014` 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 = 3651 AND t.round = 34 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 `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.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 `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 = 8848 AND t.round = 34 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 `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.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 `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.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 `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 = 8840 AND t.round = 34 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 `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 = 8838 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 `tables1995` 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 = 8812 AND t.round = 34 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 `tables1994` 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 = 10679 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 `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