4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gwardia Koszalin
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
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 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 8
Equipo PJ GF GC Puntos
1 Vineta Wolin Vineta Wolin 30 71 21 70
2 Przodkowo Przodkowo 30 69 25 69
3 Bałtyk Gdynia Bałtyk 30 52 20 63
4 Świt Skolwin Świt 30 48 40 56
5 Chwaszczyno Chwaszczyno 30 55 47 49
6 Gwardia Koszalin Gwardia 30 42 36 45
7 Pogoń Szczecin II Pogoń 30 44 40 45
8 Drawa Drawa 30 45 43 45
9 Lechia Gdańsk II Lechia 30 38 32 44
10 Kaszubia Kościerzyna Kaszubia 30 41 48 36
11 Arka Gdynia II Arka Gdynia 30 48 52 32
12 Wierzyca Pelplin Wierzyca 30 34 52 31
13 Cartusia Kartuzy Cartusia 30 31 49 31
14 Gryf Słupsk Gryf Słupsk 30 28 60 23
15 Chemik Police Chemik 30 19 61 20
16 Bałtyk Koszalin Bałtyk 30 21 60 19
TEMPORADA 2014/2015
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Gryf Wejherowo Gryf 30 75 29 68
2 Lechia Gdańsk II Lechia 30 63 33 58
3 Kaszubia Kościerzyna Kaszubia 30 55 36 56
4 Gwardia Koszalin Gwardia 30 43 29 56
5 Chemik Police Chemik 30 31 30 50
6 Drawa Drawa 30 35 39 46
7 Bałtyk Gdynia Bałtyk 30 46 36 45
8 Cartusia Kartuzy Cartusia 30 45 44 42
9 Przodkowo Przodkowo 30 48 45 41
10 Arka Gdynia II Arka Gdynia 30 41 36 39
11 Pogoń Szczecin II Pogoń 30 38 39 39
12 Chwaszczyno Chwaszczyno 30 28 42 32
13 Bałtyk Koszalin Bałtyk 30 35 45 31
14 Rasel Dygowo Rasel Dygowo 30 31 52 24
15 Leśnik - Rossa Manowo Leśnik 30 28 57 23
16 Astra Ustronie Morskie Astra 30 31 81 18
TEMPORADA 2013/2014
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Kotwica Kołobrzeg Kotwica 30 69 34 60
2 Bałtyk Koszalin Bałtyk 30 56 26 55
3 Gwardia Koszalin Gwardia 30 37 24 52
4 Bałtyk Gdynia Bałtyk 30 46 35 48
5 Drawa Drawa 30 46 37 47
6 Cartusia Kartuzy Cartusia 30 43 41 47
7 Kaszubia Kościerzyna Kaszubia 30 49 42 46
8 Pogoń Szczecin II Pogoń 30 52 51 46
9 Arka Gdynia II Arka Gdynia 30 43 34 44
10 Lechia Gdańsk II Lechia 30 59 51 42
11 Leśnik - Rossa Manowo Leśnik 30 39 39 39
12 Pomorze Potęgowo Pomorze 30 40 60 37
13 Chemik Police Chemik 30 32 44 33
14 Koral Dębnica Koral 30 32 65 26
15 Energetyk Gryfino Energetyk 30 23 46 23
16 Polonia Gdańsk Polonia 30 22 59 21
TEMPORADA 2012/2013
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Stargard Szczeciński Stargard 30 57 28 61
2 Kotwica Kołobrzeg Kotwica 30 39 26 54
3 Lechia Gdańsk II Lechia 30 43 32 46
4 Drawa Drawa 30 44 42 46
5 Cartusia Kartuzy Cartusia 30 28 29 45
6 Gwardia Koszalin Gwardia 30 57 40 43
7 Pogoń Barlinek Pogoń 30 41 41 43
8 Arka Gdynia II Arka Gdynia 30 40 41 42
9 Bałtyk Gdynia Bałtyk 30 30 28 41
10 Koral Dębnica Koral 30 33 37 39
11 Chemik Police Chemik 30 42 38 38
12 Pogoń Szczecin II Pogoń 30 43 48 38
13 Energetyk Gryfino Energetyk 30 34 42 36
14 Polonia Gdańsk Polonia 30 46 46 34
15 Dąb Dębno Dąb Dębno 30 44 57 34
16 Gryf Słupsk Gryf Słupsk 30 22 68 18
TEMPORADA 2011/2012
CUARTA POLONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Gryf Wejherowo Gryf 30 63 18 64
2 Orkan Rumia Orkan Rumia 30 52 25 64
3 Kotwica Kołobrzeg Kotwica 30 50 23 63
4 Gwardia Koszalin Gwardia 30 35 33 46
5 Cartusia Kartuzy Cartusia 30 44 35 45
6 Pogoń Barlinek Pogoń 30 44 38 44
7 Stargard Szczeciński Stargard 30 37 39 40
8 Chemik Police Chemik 30 32 35 39
9 Lechia Gdańsk II Lechia 30 35 36 38
10 Gryf Słupsk Gryf Słupsk 30 35 35 37
11 Dąb Dębno Dąb Dębno 30 33 50 34
12 Koral Dębnica Koral 30 31 50 34
13 Drawa Drawa 30 36 45 33
14 Bałtyk Koszalin Bałtyk 30 28 35 30
15 Kaszubia Kościerzyna Kaszubia 30 27 41 30
16 Gryf Tczew Gryf Tczew 30 24 68 25
TEMPORADA 2010/2011
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Bytovia Bytow Bytovia 30 49 20 69
2 Stargard Szczeciński Stargard 30 51 28 57
3 Kotwica Kołobrzeg Kotwica 30 47 31 48
4 Dąb Dębno Dąb Dębno 30 29 30 47
5 Orkan Rumia Orkan Rumia 30 50 37 45
6 Pogoń Barlinek Pogoń 30 34 33 45
7 Gryf Wejherowo Gryf 30 42 32 43
8 Lechia Gdańsk II Lechia 30 37 31 43
9 Cartusia Kartuzy Cartusia 30 35 34 43
10 Kaszubia Kościerzyna Kaszubia 30 38 33 41
11 Gwardia Koszalin Gwardia 30 45 48 41
12 Chemik Police Chemik 30 35 46 37
13 Gryf Słupsk Gryf Słupsk 30 43 42 34
14 Energetyk Gryfino Energetyk 30 25 41 28
15 Rega Trzebiatów Rega 30 28 62 20
16 Orlęta Reda Orlęta Reda 30 18 58 15

  USO DE MEMORIA  
6,374,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8226
Total Execution Time  0.8238
  CADENA URL  
/historico/Gwardia-Koszalin
  GET DATOS  
$_GET['/historico/Gwardia-Koszalin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0150  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 = 'Gwardia-Koszalin' 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.0159  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 = 'Gwardia-Koszalin' 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.0146  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=60118 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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 = 57485
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60118 AND type_rel = 2
0.0148  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 = '60118' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '60118' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '60118' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = '60118' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 57485 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=60118 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (57485,56547) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 57485 AND teamId = 60118
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 60118
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153  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 = '60118' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60118' and rp.type = 4
0.0155  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 = '60118' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 events2021 e ON e.player_id = p.id AND e.league_id = 57485 WHERE rp.league_id = 57485 AND rp.teamId = 60118 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.0152  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 events2021 e ON e.player_id = p.id AND e.league_id = 57485 WHERE rp.league_id = 57485 AND rp.teamId = 60118 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 events2021 e ON e.player_id = p.id AND e.league_id = 57485 WHERE rp.league_id = 57485 AND rp.teamId = 60118 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 60118 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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.0157  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.0153  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.0152  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.0151  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.0150  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 = 15919 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 9178 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 28021 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 28053 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 28058 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 28072 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC