4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spartak Trnava II
TEMPORADA 2019/2020
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 16 29 11 37
2 Považská Bystrica Považská 16 24 15 28
3 Marcelová Marcelová 16 20 15 27
4 Gabčíkovo Gabčíkovo 15 25 19 26
5 Lednické Rovne Lednické 16 25 25 26
6 Malženice Malženice 15 29 16 25
7 Beluša Beluša 16 22 15 23
8 Slovan Duslo Sala Slovan Duslo 16 23 21 22
9 Nitra II Nitra II 16 24 24 22
10 Zlaté Moravce - Vrablé II Zlaté 16 19 23 20
11 Veľké Ludince Veľké 16 19 20 19
12 Spartak Trnava II Spartak 16 20 23 19
13 Nove Mesto Nad Vahom Nove Mesto. 16 13 17 18
14 Slovan Galanta Slovan 16 20 22 17
15 Nové Zámky Nové Zámky 16 13 42 10
16 Kalna nad Hronom Kalna Hronom 16 15 32 9
TEMPORADA 2018/2019
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Beluša Beluša 28 48 21 57
2 MŠK Púchov MŠK Púchov 28 46 24 55
3 Malženice Malženice 29 64 30 52
4 Nitra II Nitra II 28 49 43 46
5 Gabčíkovo Gabčíkovo 28 50 36 43
6 Považská Bystrica Považská 28 51 41 42
7 Spartak Trnava II Spartak 28 47 46 41
8 Kalna nad Hronom Kalna Hronom 30 33 39 41
9 Slovan Duslo Sala Slovan Duslo 28 48 38 40
10 Lednické Rovne Lednické 29 34 33 39
11 Zlaté Moravce - Vrablé II Zlaté 28 37 41 34
12 Nove Mesto Nad Vahom Nove Mesto. 30 27 41 34
13 Veľké Ludince Veľké 28 29 41 31
14 Slovan Galanta Slovan 28 29 46 25
15 Nové Zámky Nové Zámky 28 23 95 10
16 Slovan Trenčianske T. Slovan 0 0 0 0
TEMPORADA 2017/2018
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Dubnica Dubnica 34 83 10 86
2 Borčice Borčice 34 78 35 71
3 Nové Zámky Nové Zámky 34 58 31 71
4 Lednické Rovne Lednické 34 61 33 66
5 Slovan Galanta Slovan 34 58 42 53
6 DAC II DAC II 34 51 38 52
7 Zlaté Moravce - Vrablé II Zlaté 34 60 53 52
8 Spartak Trnava II Spartak 34 59 46 50
9 MŠK Púchov MŠK Púchov 34 68 49 48
10 Nitra II Nitra II 34 57 47 48
11 Veľké Ludince Veľké 34 50 57 47
12 Gabčíkovo Gabčíkovo 34 55 47 46
13 Slovan Duslo Sala Slovan Duslo 34 49 65 45
14 Slovan Nemsova Slovan 34 46 59 42
15 Beluša Beluša 34 50 62 38
16 Baník Horná Nitra Baník 34 36 75 25
17 Spartak Bánovce Spartak 34 23 90 20
18 Topoľčany Topoľčany 34 25 128 12
TEMPORADA 2016/2017
SEGUNDA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Poprad Poprad 9 40 8 24
2 Sobota Sobota 9 17 17 16
3 Odeva Lipany Odeva Lipany 9 14 19 11
4 Haniska Haniska 9 4 31 1
5 MFK Dukla MFK Dukla 10 17 12 22
6 Spartak Trnava II Spartak 10 24 11 21
7 Slovan Bratislava II Slovan 10 18 15 21
8 Nove Mesto Nad Vahom Nove Mesto. 10 16 7 16
9 Svätý Jur Svätý Jur 10 10 22 6
10 Fomat Martin Fomat Martin 10 7 25 1
TEMPORADA 2015/2016
SEGUNDA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Spartak Trnava II Spartak 10 20 6 25
2 Dukla Dukla 10 21 8 20
3 Poprad Poprad 8 21 8 20
4 Nove Mesto Nad Vahom Nove Mesto. 10 16 14 16
5 Teplička nad Váhom Teplička 8 13 12 13
6 Spišská Nová Ves Spišská 8 17 13 10
7 Dunajská Lužná Dunajská 10 11 14 10
8 Sobota Sobota 8 11 16 10
9 Slovan Duslo Sala Slovan Duslo 10 13 19 8
10 Senec Senec 10 9 29 5
11 Haniska Haniska 8 3 16 4
TEMPORADA 2014/2015
SEGUNDA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Skalica Skalica 22 40 16 49
2 Žilina II Žilina II 22 43 33 41
3 Nitra Nitra 22 39 22 40
4 Sered Sered 22 39 22 39
5 Slovan Duslo Sala Slovan Duslo 22 33 24 37
6 Senec Senec 22 28 21 34
7 Pohronie Pohronie 22 32 35 33
8 Slovan Bratislava II Slovan 22 18 30 26
9 Spartak Trnava II Spartak 22 20 35 20
10 Šamorín Šamorín 22 21 34 19
11 Dubnica Dubnica 22 25 42 15
12 Nove Mesto Nad Vahom Nove Mesto. 22 15 39 13
TEMPORADA 2013/2014
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Podbrezová Podbrezová 33 64 16 82
2 Bardejov Bardejov 33 49 25 61
3 Zemplin Michalovce Zemplin 33 55 28 61
4 Tatran Prešov Tatran 33 56 28 60
5 Senec Senec 33 39 32 49
6 Spartak Trnava II Spartak 33 57 64 39
7 Sobota Sobota 33 32 39 38
8 Dubnica Dubnica 33 30 64 35
9 Pohronie Pohronie 33 38 60 34
10 Slovan Duslo Sala Slovan Duslo 33 30 45 32
11 FC ŠTK 1914 ŠTK 1914 33 33 55 31
12 Liptovsky Mikulas Liptovsky 33 25 52 28
TEMPORADA 2012/2013
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Trnava II Spartak 30 59 30 55
2 Slovan Bratislava II Slovan 30 55 40 50
3 Sered Sered 30 62 48 50
4 Slovan Levice Slovan 30 40 30 49
5 Piešťany Piešťany 30 46 37 49
6 Topoľčany Topoľčany 30 51 51 46
7 Nové Zámky Nové Zámky 30 51 38 45
8 Spartak Vráble Spartak 30 47 47 44
9 Dunajská Lužná Dunajská 30 30 28 41
10 Nove Mesto Nad Vahom Nove Mesto. 30 37 37 39
11 FC Petržalka Petržalka 30 30 43 36
12 OSK Moravany nad Váhom Moravany 30 40 55 35
13 Slovan Nemsova Slovan 30 30 37 34
14 Domino Bratislava Domino 30 29 44 34
15 Vrbové Vrbové 30 21 38 34
16 Nitra II Nitra II 30 27 52 29
TEMPORADA 2011/2012
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Slovan Duslo Sala Slovan Duslo 28 62 25 59
2 Šamorín Šamorín 28 48 21 52
3 Nove Mesto Nad Vahom Nove Mesto. 28 45 36 51
4 Sered Sered 28 45 28 48
5 Spartak Vráble Spartak 28 43 35 41
6 Slovan Bratislava II Slovan 28 49 45 41
7 Spartak Trnava II Spartak 28 60 55 39
8 Dunajská Lužná Dunajská 28 29 39 39
9 Vrbové Vrbové 28 27 40 36
10 Nové Zámky Nové Zámky 28 34 34 34
11 Nitra II Nitra II 28 39 43 34
12 Pezinok Pezinok 28 23 35 34
13 OSK Moravany nad Váhom Moravany 28 32 52 30
14 Slovan Nemsova Slovan 28 38 52 29
15 Topoľčany Topoľčany 28 29 63 18
16 Púchov Púchov 0 0 0 0
TEMPORADA 2010/2011
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 30 63 14 67
2 Slovan Nemsova Slovan 30 55 23 60
3 Spartak Vráble Spartak 30 38 36 52
4 Nove Mesto Nad Vahom Nove Mesto. 30 55 33 51
5 Nitra II Nitra II 30 51 45 47
6 Slovan Bratislava II Slovan 30 45 32 46
7 Vrbové Vrbové 30 38 39 45
8 Spartak Trnava II Spartak 30 47 42 41
9 Nové Zámky Nové Zámky 30 37 47 37
10 Topoľčany Topoľčany 30 36 46 37
11 OSK Moravany nad Váhom Moravany 30 31 51 37
12 Pezinok Pezinok 30 33 43 36
13 Šamorín Šamorín 30 45 39 35
14 FK Rača FK Rača 30 32 59 29
15 Jaslovské Bohunice Jaslovské 30 35 64 27
16 Bernolákovo Bernolákovo 30 31 59 25
TEMPORADA 2009/2010
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Senec Senec 30 51 21 71
2 OSK Moravany nad Váhom Moravany 30 49 32 52
3 Spartak Trnava II Spartak 30 47 40 46
4 Spartak Myjava Spartak 30 27 22 46
5 Nové Zámky Nové Zámky 30 33 29 46
6 Bernolákovo Bernolákovo 30 42 40 43
7 Slovan Bratislava II Slovan 30 41 32 42
8 Nitra II Nitra II 30 52 43 41
9 Nove Mesto Nad Vahom Nove Mesto. 30 42 42 41
10 Slovan Nemsova Slovan 30 36 37 41
11 Spartak Vráble Spartak 30 36 32 40
12 Jaslovské Bohunice Jaslovské 30 34 38 40
13 Vrbové Vrbové 30 25 34 34
14 FK Rača FK Rača 30 36 42 33
15 Topoľčany Topoľčany 30 37 54 28
16 DAC II DAC II 30 26 76 17
TEMPORADA 2008/2009
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Púchov Púchov 29 63 20 64
2 Senec Senec 30 61 33 61
3 Spartak Vráble Spartak 30 52 23 58
4 Slovan Bratislava II Slovan 30 65 38 58
5 OSK Moravany nad Váhom Moravany 29 38 40 46
6 Nitra II Nitra II 30 52 39 44
7 Spartak Trnava II Spartak 30 60 53 44
8 Slovan Nemsova Slovan 30 42 42 40
9 Petržalka II Petržalka 30 34 34 39
10 Vrbové Vrbové 30 32 38 38
11 Jaslovské Bohunice Jaslovské 30 32 51 37
12 Nove Mesto Nad Vahom Nove Mesto. 30 32 47 35
13 Topoľčany Topoľčany 30 32 48 34
14 FK Rača FK Rača 30 35 48 31
15 Dúbravka Bratislava Dúbravka 30 35 52 31
16 Iskra Petržalka Iskra 30 19 78 8
TEMPORADA 2005/2006
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 FC VSS Kosice Kosice 30 67 12 73
2 Slovan Bratislava Slovan 30 47 25 63
3 Senec Senec 30 65 35 60
4 Sobota Sobota 30 49 23 56
5 Tatran Prešov Tatran 30 37 22 52
6 LAFC Lučenec LAFC 30 40 34 52
7 Zemplin Michalovce Zemplin 30 38 30 48
8 Zlaté Moravce Zlaté 30 33 25 48
9 Slovan Duslo Sala Slovan Duslo 30 42 29 45
10 Podbrezová Podbrezová 30 39 30 44
11 Futura Humenné Futura 30 35 45 37
12 DAC DAC 30 27 51 27
13 Odeva Lipany Odeva Lipany 30 27 61 22
14 Spartak Trnava II Spartak 30 17 56 17
15 Družstevník Báč Družstevní 30 17 63 16
16 Nitra II Nitra II 30 25 64 15

  USO DE MEMORIA  
6,131,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.1838
Total Execution Time  0.1855
  CADENA URL  
/historico/Spartak-Trnava-Ii
  GET DATOS  
$_GET['/historico/Spartak-Trnava-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0025  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 = 'Spartak-Trnava-Ii' 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.0047  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 = 'Spartak-Trnava-Ii' 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=25021 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=25021 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=25021 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=25021 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=25021 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=25021 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=25021 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=25021 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=25021 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=25021 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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=25021 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=25021 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=25021 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=25021 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=25021 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=25021 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=25021 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=25021 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=25021 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=25021 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=25021 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 50485
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25021 AND type_rel = 2
0.0023  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 = '25021' AND l.year = 2020 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 = '25021' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '25021' 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 = 50485 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=25021 AND l.year in (2019,2020,2021) 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 (50485) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 50485 AND teamId = 25021
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 `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 = 50485 AND t.round = 16 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0029  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 = '25021' 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 = '25021' and rp.type = 4
0.0021  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 = '25021' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 50485 WHERE rp.league_id = 50485 AND rp.teamId = 25021 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50485 WHERE rp.league_id = 50485 AND rp.teamId = 25021 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50485 WHERE rp.league_id = 50485 AND rp.teamId = 25021 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 25021 AND l.year <= 2020 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 `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 = 50485 AND t.round = 16 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 `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 = 44373 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39128 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 33685 AND t.round = 22 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 = 38661 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 15807 AND t.round = 22 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 `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 = 23888 AND t.round = 10 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 = 12479 AND t.round = 10 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 `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 = 4828 AND t.round = 22 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 `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 = 2873 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 24456 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24468 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 24476 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24481 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 `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 = 24490 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 14266 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 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 = 50485 ORDER BY nameShow LIMIT 100