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

NK Sesvete

Entrenador: Hrvoje Horvat

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Zrinski Osječko Zrinski 27 43 13 66
2 HNK Sibenik HNK Sibenik 27 53 17 64
3 Vukovar '91 Vukovar '91 28 46 29 52
4 NK Jarun NK Jarun 28 32 40 37
5 NK Sesvete NK Sesvete 28 32 32 36
6 NK Dugopolje Dugopolje 27 33 33 33
7 Dubrava Tim kabel Dubrava 28 28 39 32
8 HNK Cibalia HNK Cibalia 27 28 45 30
9 NK Croatia Zmijavci Croatia 28 32 39 29
10 HNK Orijent Rijeka Orijent 28 30 46 26
11 Bijelo Brdo Bijelo Brdo 27 26 36 24
12 NK Solin NK Solin 27 25 39 20
TEMPORADA 2022/2023
SEGUNDA CROACIA 2. NL
Equipo PJ GF GC Puntos
1 NK Sesvete NK Sesvete 30 64 24 65
2 Zrinski Osječko Zrinski 30 45 22 63
3 NK Jadran LP Jadran 30 54 23 60
4 Mladost Ždralovi Mladost 30 48 26 50
5 Bjelovar Bjelovar 30 46 31 46
6 NK Dugo Selo Dugo Selo 30 50 43 45
7 NK Opatija NK Opatija 30 48 42 45
8 Hrvace Hrvace 30 48 49 38
9 Belisce Belisce 30 39 47 37
10 Jadran Jadran 30 51 61 36
11 Marsonia Marsonia 30 40 52 36
12 Grobničan Grobničan 30 42 44 35
13 NK Trnje NK Trnje 30 43 55 34
14 Zagorec Zagorec 30 36 53 34
15 NK Osijek II Osijek 30 32 64 25
16 Medimurje Medimurje 30 22 72 15
TEMPORADA 2021/2022
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Varazdin NK Varazdin 30 56 29 63
2 NK Rudes NK Rudes 30 56 27 56
3 Inter Zapresic Inter 30 34 29 48
4 NK Jarun NK Jarun 30 46 38 44
5 NK Kustošija Kustošija 30 39 35 42
6 HNK Cibalia HNK Cibalia 30 44 42 41
7 Dinamo Zagreb II Dinamo 30 37 44 41
8 NK Solin NK Solin 30 41 41 40
9 HNK Orijent Rijeka Orijent 30 44 49 40
10 NK Dugopolje Dugopolje 30 40 46 40
11 Bijelo Brdo Bijelo Brdo 30 30 41 39
12 Dubrava Tim kabel Dubrava 30 39 39 39
13 NK Croatia Zmijavci Croatia 30 32 43 38
14 NK Sesvete NK Sesvete 30 37 41 34
15 NK Osijek II Osijek 30 25 36 34
16 NK Opatija NK Opatija 30 27 47 25
TEMPORADA 2020/2021
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 34 49 39 59
2 NK Rudes NK Rudes 34 52 41 57
3 Bijelo Brdo Bijelo Brdo 34 52 40 55
4 HNK Cibalia HNK Cibalia 34 50 43 51
5 NK Kustošija Kustošija 34 43 38 51
6 NK Sesvete NK Sesvete 34 62 59 51
7 NK Opatija NK Opatija 34 42 41 50
8 NK Dugopolje Dugopolje 34 49 45 48
9 Dubrava Tim kabel Dubrava 34 45 46 46
10 HNK Orijent Rijeka Orijent 34 52 49 45
11 Inter Zapresic Inter 34 49 41 45
12 NK Croatia Zmijavci Croatia 34 52 53 44
13 Dinamo Zagreb II Dinamo 34 45 41 43
14 NK Osijek II Osijek 34 42 42 42
15 Hajduk Split II Hajduk Split 34 58 60 41
16 NK Solin NK Solin 34 45 56 38
17 Junak Sinj Junak Sinj 34 46 58 34
18 Medjimurje Cakovec Medjimurje 34 44 85 34
TEMPORADA 2019/2020
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Sibenik HNK Sibenik 19 26 15 41
2 NK Croatia Zmijavci Croatia 19 28 17 33
3 HNK Orijent Rijeka Orijent 19 26 23 33
4 NK Sesvete NK Sesvete 19 28 22 29
5 NK Rudes NK Rudes 19 25 20 29
6 Hajduk Split II Hajduk Split 19 29 23 27
7 NK Osijek II Osijek 19 26 19 26
8 Dinamo Zagreb II Dinamo 19 20 21 26
9 Hrvatski Dragovoljac Hrvatski 19 21 26 26
10 NK Dugopolje Dugopolje 19 30 31 25
11 Medjimurje Cakovec Medjimurje 19 26 26 23
12 Dubrava Tim kabel Dubrava 19 21 24 23
13 NK Kustošija Kustošija 19 19 27 23
14 Bijelo Brdo Bijelo Brdo 19 18 23 22
15 NK Solin NK Solin 19 22 27 19
16 HNK Cibalia HNK Cibalia 19 13 34 13
TEMPORADA 2018/2019
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Varazdin NK Varazdin 26 40 30 51
2 HNK Sibenik HNK Sibenik 26 38 25 46
3 NK Osijek II Osijek 26 37 26 44
4 Hajduk Split II Hajduk Split 26 36 29 43
5 NK Dugopolje Dugopolje 26 29 25 43
6 NK Sesvete NK Sesvete 26 38 26 40
7 Dinamo Zagreb II Dinamo 26 31 26 37
8 Zadar Zadar 26 36 40 34
9 Bijelo Brdo Bijelo Brdo 26 31 37 28
10 NK Solin NK Solin 26 24 31 28
11 NK Kustošija Kustošija 26 20 28 28
12 Hrvatski Dragovoljac Hrvatski 26 23 29 27
13 Medjimurje Cakovec Medjimurje 26 26 42 25
14 Lučko Lučko 26 16 31 24
TEMPORADA 2017/2018
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Gorica HNK Gorica 33 44 29 62
2 NK Varazdin NK Varazdin 33 50 32 61
3 Dinamo Zagreb II Dinamo 33 43 25 61
4 NK Sesvete NK Sesvete 33 46 38 54
5 Hajduk Split II Hajduk Split 33 44 32 50
6 NK Dugopolje Dugopolje 33 34 37 46
7 HNK Sibenik HNK Sibenik 33 39 43 42
8 NK Kustošija Kustošija 33 34 39 40
9 Hrvatski Dragovoljac Hrvatski 33 37 48 34
10 Lučko Lučko 33 27 40 34
11 NK Solin NK Solin 33 31 48 34
12 Novigrad Novigrad 33 32 50 31
TEMPORADA 2016/2017
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Rudes NK Rudes 33 43 28 60
2 HNK Gorica HNK Gorica 33 53 31 57
3 NK Solin NK Solin 33 40 36 55
4 NK Sesvete NK Sesvete 33 53 36 52
5 Dinamo Zagreb II Dinamo 33 39 32 47
6 NK Dugopolje Dugopolje 33 36 32 46
7 HNK Sibenik HNK Sibenik 33 32 33 45
8 Novigrad Novigrad 33 28 35 42
9 Lučko Lučko 33 34 48 38
10 Hrvatski Dragovoljac Hrvatski 33 30 39 36
11 Imotski Imotski 33 36 58 31
12 NK Zagreb NK Zagreb 33 34 50 29
TEMPORADA 2015/2016
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Cibalia HNK Cibalia 33 54 20 70
2 HNK Sibenik HNK Sibenik 33 54 21 69
3 NK Sesvete NK Sesvete 33 56 40 52
4 HNK Gorica HNK Gorica 33 40 40 47
5 NK Rudes NK Rudes 33 47 44 43
6 Dinamo Zagreb II Dinamo 33 34 37 43
7 NK Dugopolje Dugopolje 33 38 41 40
8 Lučko Lučko 33 40 47 40
9 Imotski Imotski 33 40 50 40
10 Hrvatski Dragovoljac Hrvatski 33 29 39 40
11 Segesta Segesta 33 44 54 38
12 Zadar Zadar 33 30 73 23
TEMPORADA 2014/2015
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Inter Zapresic Inter 30 48 25 58
2 NK Sesvete NK Sesvete 30 53 30 53
3 HNK Gorica HNK Gorica 30 46 26 51
4 NK Rudes NK Rudes 30 36 28 42
5 Imotski Imotski 30 31 38 38
6 HNK Cibalia HNK Cibalia 30 36 44 38
7 NK Dugopolje Dugopolje 30 27 32 34
8 Segesta Segesta 30 31 42 34
9 Lučko Lučko 30 24 35 33
10 Hrvatski Dragovoljac Hrvatski 30 30 42 33
11 Bistra Bistra 30 18 38 27
12 Pomorac Pomorac 0 0 0 0
TEMPORADA 2013/2014
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
TEMPORADA 2012/2013
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 30 39 25 53
2 NK Solin NK Solin 30 43 39 51
3 NK Rudes NK Rudes 30 47 30 50
4 HNK Sibenik HNK Sibenik 30 42 31 48
5 Vinogradar Vinogradar 30 43 39 48
6 NK Zelina NK Zelina 30 46 30 46
7 Pomorac Pomorac 30 51 39 46
8 NK Dugopolje Dugopolje 30 39 42 46
9 Lučko Lučko 30 31 28 45
10 HNK Gorica HNK Gorica 30 40 35 40
11 NK Sesvete NK Sesvete 30 42 43 40
12 Mosor Mosor 30 31 40 38
13 Junak Sinj Junak Sinj 30 34 43 36
14 Imotski Imotski 30 26 41 31
15 Primorac Stobrec Primorac 30 25 43 28
16 NK HASK Zagreb HASK Zagreb 30 24 55 15
TEMPORADA 2011/2012
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Dugopolje Dugopolje 28 50 27 57
2 Pomorac Pomorac 28 63 30 56
3 Mosor Mosor 28 36 16 52
4 Vinogradar Vinogradar 28 47 32 50
5 Imotski Imotski 28 26 21 42
6 NK Rudes NK Rudes 28 42 33 41
7 HNK Gorica HNK Gorica 28 27 24 40
8 Hrvatski Dragovoljac Hrvatski 28 36 37 40
9 NK Sesvete NK Sesvete 28 34 31 39
10 Junak Sinj Junak Sinj 28 29 27 39
11 NK Solin NK Solin 28 35 45 35
12 Marsonia Marsonia 28 25 50 30
13 Medjimurje Cakovec Medjimurje 28 31 60 22
14 NK HASK Zagreb HASK Zagreb 28 33 52 21
15 NK Croatia Sesvete Croatia 28 23 52 15
TEMPORADA 2010/2011
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 NK Sesvete NK Sesvete 34 59 34 65
2 Grobničan Grobničan 34 66 44 64
3 NK Zelina NK Zelina 34 63 40 59
4 Vrapče Vrapče 34 54 31 59
5 Crikvenica Crikvenica 34 59 43 59
6 NK Dugo Selo Dugo Selo 34 48 45 52
7 NK Opatija NK Opatija 34 53 42 50
8 Segesta Segesta 34 51 48 50
9 Vrbovec Vrbovec 34 50 42 48
10 Rovinj Rovinj 34 51 48 48
11 HNK Orijent Rijeka Orijent 34 40 47 42
12 Krk Krk 34 47 59 41
13 Novalja Novalja 34 41 48 40
14 Jadran Jadran 34 31 45 40
15 Nehaj Nehaj 34 43 51 39
16 NK Medulin NK Medulin 34 35 49 37
17 NK Rudar Labin Rudar Labin 34 36 68 27
18 Moslavina Moslavina 34 46 89 27

  USO DE MEMORIA  
6,337,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1252
Total Execution Time  0.1267
  CADENA URL  
/historico/Nk-Radnik-Sesvete
  GET DATOS  
$_GET['/historico/Nk-Radnik-Sesvete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0029  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 = 'Nk-Radnik-Sesvete' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13154 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=13154 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=13154 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13154 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13154 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (125156) ORDER BY n.cover_points DESC, update_date DESC
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 = '13154' ORDER BY l.year DESC,cat.coefficient DESC
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 = '13154' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '13154' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72476 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=13154 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 (72476,71432,69560) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72476 AND teamId = 13154
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 69560 AND teamId = 13154
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13154
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72476 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '13154' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13154' 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 = '13154' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 72476 WHERE rp.league_id = 72476 AND rp.teamId = 13154 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 = 72476 WHERE rp.league_id = 72476 AND rp.teamId = 13154 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72476 WHERE rp.league_id = 72476 AND rp.teamId = 13154 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 13154 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 = 69560 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.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 `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 = 63277 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.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 = 57734 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.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 `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 = 50115 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 44241 AND t.round = 26 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 `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 = 38803 AND t.round = 33 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 `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 = 33948 AND t.round = 33 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 = 15721 AND t.round = 33 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 = 4157 AND t.round = 33 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 = 8701 AND t.round = 33 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 = 2834 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 `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 = 8705 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 `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 = 24794 AND t.round = 34 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 = 72476 ORDER BY nameShow LIMIT 100