4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Jarota Jarocin
TEMPORADA 2022/2023
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Olimpia Grudziadz Olimpia 34 73 18 76
2 Pogoń Szczecin II Pogoń 34 69 25 69
3 Polonia Środa Polonia 34 75 54 64
4 Zawisza Bydgoszcz Zawisza 34 69 45 62
5 Gedania Gdansk Gedania 34 63 59 61
6 Starogard Gdański Starogard 34 44 35 59
7 Świt Skolwin Świt 34 61 41 55
8 Nowe Skalmierzyce Nowe 34 51 46 54
9 Sokół Kleczew Sokół 34 53 48 47
10 Unia Swarzędz Unia 34 37 42 44
11 Cartusia Kartuzy Cartusia 34 37 40 43
12 Stargard Szczeciński Stargard 34 46 45 42
13 Stolem Gniewino Stolem 34 33 52 36
14 Vineta Wolin Vineta Wolin 34 47 66 35
15 Unia Solec Kujawski Unia Solec. 34 40 59 35
16 Jarota Jarocin Jarota 34 41 69 33
17 Bałtyk Gdynia Bałtyk 34 43 70 28
18 Unia Janikowo Unia 34 17 85 10
TEMPORADA 2021/2022
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kotwica Kołobrzeg Kotwica 34 75 25 78
2 Olimpia Grudziadz Olimpia 34 77 24 77
3 Unia Janikowo Unia 34 62 47 60
4 Pogoń Szczecin II Pogoń 34 60 36 58
5 Nowe Skalmierzyce Nowe 34 54 42 58
6 Świt Skolwin Świt 34 57 37 56
7 Sokół Kleczew Sokół 34 53 40 56
8 Zawisza Bydgoszcz Zawisza 34 57 51 50
9 Stargard Szczeciński Stargard 34 48 54 45
10 Polonia Środa Polonia 34 40 63 43
11 Starogard Gdański Starogard 34 44 51 42
12 Stolem Gniewino Stolem 34 43 66 41
13 Jarota Jarocin Jarota 34 40 47 36
14 Przodkowo Przodkowo 34 40 51 36
15 Bałtyk Gdynia Bałtyk 34 44 57 36
16 Bałtyk Koszalin Bałtyk 34 40 58 35
17 Kluczevia Stargard Kluczevia 34 28 65 26
18 TKP Elana Torun Elana Torun 34 36 84 21
TEMPORADA 2020/2021
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Radunia Stężyca Radunia 35 115 24 87
2 Świt Skolwin Świt 35 75 28 81
3 Polonia Środa Polonia 35 76 31 76
4 Starogard Gdański Starogard 35 48 46 61
5 Kotwica Kołobrzeg Kotwica 34 59 40 58
6 Sokół Kleczew Sokół 34 63 45 57
7 TKP Elana Torun Elana Torun 35 59 33 56
8 Unia Janikowo Unia 34 54 53 54
9 Jarota Jarocin Jarota 34 68 49 49
10 Bałtyk Koszalin Bałtyk 34 63 56 48
11 Nielba Wagrowiec Nielba 34 74 59 47
12 Swinoujscie Swinoujscie 34 48 55 47
13 Bałtyk Gdynia Bałtyk 35 43 52 47
14 Pomorzanin Toruń Pomorzanin 34 39 40 43
15 Unia Swarzędz Unia 34 51 44 41
16 Przodkowo Przodkowo 35 42 66 40
17 Gwardia Koszalin Gwardia 34 42 52 40
18 Pogoń Szczecin II Pogoń 35 61 68 39
19 Gryf Wejherowo Gryf 34 45 64 36
20 Górnik Konin Górnik 34 32 76 26
21 Chemik Police Chemik 34 28 96 18
22 Mieszko Gniezno Mieszko 34 15 123 4
TEMPORADA 2019/2020
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kalisz Kalisz 18 41 12 45
2 Radunia Stężyca Radunia 18 37 10 40
3 Świt Skolwin Świt 18 30 7 39
4 Kotwica Kołobrzeg Kotwica 18 37 22 39
5 Mieszko Gniezno Mieszko 18 33 17 36
6 Unia Janikowo Unia 18 43 29 33
7 Sokół Kleczew Sokół 18 22 22 27
8 Starogard Gdański Starogard 18 19 20 25
9 Polonia Środa Polonia 18 28 24 23
10 Pogoń Szczecin II Pogoń 18 23 30 21
11 Chemik Police Chemik 18 21 27 21
12 Gwardia Koszalin Gwardia 18 19 37 18
13 Bałtyk Koszalin Bałtyk 18 17 35 17
14 Nielba Wagrowiec Nielba 18 22 38 16
15 Jarota Jarocin Jarota 18 18 24 15
16 Górnik Konin Górnik 18 22 37 14
17 Grom Nowy Staw Grom Nowy S. 18 19 35 14
18 Bałtyk Gdynia Bałtyk 18 12 37 10
TEMPORADA 2018/2019
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Lech Poznań II Lech Poznań 34 86 33 75
2 Radunia Stężyca Radunia 34 75 37 69
3 Kalisz Kalisz 34 70 37 69
4 Kotwica Kołobrzeg Kotwica 34 70 41 68
5 Mieszko Gniezno Mieszko 34 74 53 61
6 Polonia Środa Polonia 34 59 44 60
7 Świt Skolwin Świt 34 50 33 58
8 Bałtyk Gdynia Bałtyk 34 59 50 57
9 Sokół Kleczew Sokół 34 48 50 53
10 Starogard Gdański Starogard 34 56 37 51
11 Pogoń Szczecin II Pogoń 33 49 59 42
12 Górnik Konin Górnik 34 46 56 41
13 Bałtyk Koszalin Bałtyk 34 57 75 40
14 Jarota Jarocin Jarota 34 37 50 38
15 Gwardia Koszalin Gwardia 34 35 71 33
16 Chemik Bydgoszcz Chemik 34 38 66 30
17 Wierzyca Pelplin Wierzyca 34 34 81 14
18 Wda Świecie Świecie 33 20 90 8
TEMPORADA 2017/2018
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 TKP Elana Torun Elana Torun 34 71 24 77
2 Świt Skolwin Świt 34 70 27 73
3 Bałtyk Gdynia Bałtyk 34 74 36 69
4 Lech Poznań II Lech Poznań 34 69 34 66
5 Kalisz Kalisz 34 52 33 63
6 Polonia Środa Polonia 34 63 41 60
7 Sokół Kleczew Sokół 34 52 32 59
8 Kotwica Kołobrzeg Kotwica 34 48 37 57
9 Starogard Gdański Starogard 34 46 32 51
10 Pogoń Szczecin II Pogoń 34 44 54 49
11 Jarota Jarocin Jarota 34 45 50 42
12 Wierzyca Pelplin Wierzyca 34 38 47 42
13 Wda Świecie Świecie 34 52 72 35
14 Górnik Konin Górnik 34 40 61 34
15 Centra Ostrów Centra 34 38 67 32
16 Przodkowo Przodkowo 34 38 75 25
17 Unia Solec Kujawski Unia Solec. 34 33 80 19
18 Energetyk Gryfino Energetyk 34 9 80 11
TEMPORADA 2016/2017
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gwardia Koszalin Gwardia 34 55 32 66
2 Lech Poznań II Lech Poznań 34 71 38 65
3 Bałtyk Gdynia Bałtyk 34 55 34 64
4 Jarota Jarocin Jarota 34 57 47 59
5 TKP Elana Torun Elana Torun 34 70 42 58
6 Przodkowo Przodkowo 34 62 40 57
7 Sokół Kleczew Sokół 34 60 47 55
8 Świt Skolwin Świt 34 55 42 54
9 Kalisz Kalisz 34 44 44 54
10 Wda Świecie Świecie 34 66 53 49
11 Polonia Środa Polonia 34 44 44 47
12 Chwaszczyno Chwaszczyno 34 56 63 46
13 Pogoń Szczecin II Pogoń 34 46 50 44
14 Górnik Konin Górnik 34 44 51 40
15 Chemik Bydgoszcz Chemik 34 39 59 36
16 Pogoń Lębork Pogoń 34 36 71 30
17 Vineta Wolin Vineta Wolin 34 37 67 22
18 Leśnik - Rossa Manowo Leśnik 34 22 95 10
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
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Energetyk ROW Rybnik Energetyk 34 69 32 72
2 Chojniczanka Chojnice Chojniczanka 34 58 27 71
3 Bytovia Bytow Bytovia 34 53 33 63
4 Zagłębie Sosnowiec Zagłębie 34 54 28 59
5 Kluczbork Kluczbork 34 54 28 57
6 Gornik Polkowice Gornik 34 59 42 56
7 Rozwoj Katowice Rozwoj 34 46 38 51
8 Chrobry Głogów Chrobry 34 38 39 48
9 Jarota Jarocin Jarota 34 36 35 44
10 Gryf Wejherowo Gryf 34 39 44 44
11 Calisia Kalisz Calisia 34 34 43 44
12 Raków Częstochowa Raków 34 43 44 43
13 Górnik Wałbrzych Górnik 34 34 43 42
14 Tur Turek Tur Turek 34 32 42 42
15 Ruch Zdzieszowice Ruch 34 38 55 34
16 MKS Olawa MKS Olawa 34 35 53 30
17 Lech Rypin Lech Rypin 34 24 80 29
18 TKP Elana Torun Elana Torun 34 12 52 19
TEMPORADA 2011/2012
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Miedz Legnica Miedz 34 62 23 64
2 GKS Tychy GKS Tychy 34 50 27 59
3 Bytovia Bytow Bytovia 34 47 45 54
4 Jarota Jarocin Jarota 34 41 36 52
5 Górnik Wałbrzych Górnik 34 37 29 50
6 TKP Elana Torun Elana Torun 34 46 41 50
7 Ruch Zdzieszowice Ruch 34 36 36 50
8 Chojniczanka Chojnice Chojniczanka 34 58 45 49
9 Chrobry Głogów Chrobry 34 36 38 49
10 Kluczbork Kluczbork 34 44 35 48
11 Energetyk ROW Rybnik Energetyk 34 46 59 44
12 Raków Częstochowa Raków 34 37 51 44
13 Czarni Żagań Czarni 34 34 53 44
14 Zagłębie Sosnowiec Zagłębie 34 46 45 40
15 Tur Turek Tur Turek 34 41 46 38
16 Calisia Kalisz Calisia 34 47 60 36
17 Bałtyk Gdynia Bałtyk 34 29 42 29
18 Nielba Wagrowiec Nielba 34 36 62 29
TEMPORADA 2010/2011
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Olimpia Grudziadz Olimpia 34 66 30 71
2 Zawisza Bydgoszcz Zawisza 34 56 24 66
3 GKS Tychy GKS Tychy 34 63 30 65
4 Miedz Legnica Miedz 34 45 31 56
5 Zagłębie Sosnowiec Zagłębie 34 49 36 55
6 Ruch Zdzieszowice Ruch 34 45 32 54
7 Chojniczanka Chojnice Chojniczanka 34 45 34 53
8 Bałtyk Gdynia Bałtyk 34 40 31 53
9 Nielba Wagrowiec Nielba 34 61 51 50
10 Górnik Wałbrzych Górnik 34 44 34 48
11 TKP Elana Torun Elana Torun 34 42 43 47
12 Czarni Żagań Czarni 34 54 47 45
13 Jarota Jarocin Jarota 34 40 34 45
14 Raków Częstochowa Raków 34 42 40 44
15 Tur Turek Tur Turek 34 51 71 30
16 Zielona Góra Zielona 34 25 66 22
17 Polonia Nowy Tomyśl Polonia Nowy 33 23 84 15
18 Polonia Słubice Polonia 33 11 84 10
TEMPORADA 2009/2010
TERCERA POLONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ruch Radzionków Ruch 34 61 25 76
2 Gornik Polkowice Gornik 34 56 31 68
3 Zagłębie Sosnowiec Zagłębie 34 44 21 62
4 Zawisza Bydgoszcz Zawisza 34 54 30 59
5 Nielba Wagrowiec Nielba 34 48 38 55
6 Olimpia Grudziadz Olimpia 34 44 40 53
7 Jarota Jarocin Jarota 34 42 39 48
8 GKS Tychy GKS Tychy 34 40 41 48
9 Czarni Żagań Czarni 34 46 42 47
10 Raków Częstochowa Raków 34 38 31 45
11 Bałtyk Gdynia Bałtyk 34 44 38 41
12 Polonia Słubice Polonia 34 31 47 39
13 Zielona Góra Zielona 34 33 54 36
14 Tur Turek Tur Turek 34 27 36 35
15 Miedz Legnica Miedz 34 33 58 35
16 TKP Elana Torun Elana Torun 34 31 47 34
17 Unia Janikowo Unia 34 44 72 33
18 Ślęza Wrocław Ślęza 34 30 56 22
TEMPORADA 2008/2009
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kluczbork Kluczbork 34 59 33 67
2 Pogon Szczecin Pogon 34 55 35 62
3 Gawin Królewska Wola Gawin 34 57 37 59
4 Nielba Wagrowiec Nielba 34 62 44 57
5 Raków Częstochowa Raków 34 46 32 54
6 Kotwica Kołobrzeg Kotwica 34 45 33 53
7 TKP Elana Torun Elana Torun 34 49 41 51
8 Zawisza Bydgoszcz Zawisza 34 47 43 51
9 Zagłębie Sosnowiec Zagłębie 34 36 31 49
10 Unia Janikowo Unia 34 30 27 48
11 GKS Tychy GKS Tychy 34 35 34 48
12 Jarota Jarocin Jarota 34 51 44 45
13 Miedz Legnica Miedz 34 39 51 39
14 Czarni Żagań Czarni 34 31 50 38
15 Victoria Koronowo Victoria 34 27 50 33
16 Zielona Góra Zielona 34 37 61 30
17 Chemik Police Chemik 34 31 65 28
18 Polonia Słubice Polonia 34 36 62 26
TEMPORADA 2007/2008
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Swinoujscie Swinoujscie 30 49 22 68
2 Unia Janikowo Unia 30 51 22 60
3 Nielba Wagrowiec Nielba 30 58 30 55
4 Jarota Jarocin Jarota 30 55 27 53
5 Kotwica Kołobrzeg Kotwica 30 46 29 53
6 Victoria Koronowo Victoria 30 54 33 47
7 TKP Elana Torun Elana Torun 30 32 26 46
8 Chemik Police Chemik 30 36 40 34
9 Kaszubia Kościerzyna Kaszubia 30 32 46 34
10 Wierzyca Pelplin Wierzyca 30 39 52 32
11 Rodlo Kwidzyn Rodlo 30 33 47 32
12 Mieszko Gniezno Mieszko 30 30 39 31
13 Kujawiak Włocławek Kujawiak 30 24 52 28
14 Rega Trzebiatów Rega 30 26 46 27
15 Zdrój Ciechocinek Zdrój 30 22 55 26
16 Cartusia Kartuzy Cartusia 30 27 48 22

  USO DE MEMORIA  
7,257,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1764
Total Execution Time  0.1776
  CADENA URL  
/historico/Jarota-Jarocin
  GET DATOS  
$_GET['/historico/Jarota-Jarocin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0023  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 = 'Jarota-Jarocin' 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.0035  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 = 'Jarota-Jarocin' 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 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=13386 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 68531
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13386 AND type_rel = 2
0.0022  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 = '13386' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '13386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '13386' 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 = 68531 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=13386 AND l.year in (2022,2023,2024) 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 (68531,67320) 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 = 68531 AND teamId = 13386
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 13386
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 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 = 68531 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '13386' 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 = '13386' 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 = '13386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 events2023 e ON e.player_id = p.id AND e.league_id = 68531 WHERE rp.league_id = 68531 AND rp.teamId = 13386 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 68531 WHERE rp.league_id = 68531 AND rp.teamId = 13386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 events2023 e ON e.player_id = p.id AND e.league_id = 68531 WHERE rp.league_id = 68531 AND rp.teamId = 13386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 13386 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68531 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 = 63688 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 `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 = 57485 AND t.round = 35 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 `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 = 50430 AND t.round = 18 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 `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 = 44317 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 = 38927 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 `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 = 33763 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 = 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.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 `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.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 `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 = 25080 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 `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 = 25076 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 `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 = 25066 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 `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 = 25051 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 `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 = 25048 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 `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 = 25017 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68531 ORDER BY nameShow LIMIT 100