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

NK Dugopolje

Entrenador: Mirko Labrovic

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 27 32 37 29
10 Bijelo Brdo Bijelo Brdo 27 26 36 24
11 HNK Orijent Rijeka Orijent 27 28 46 23
12 NK Solin NK Solin 27 25 39 20
TEMPORADA 2022/2023
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Rudes NK Rudes 33 56 26 64
2 Vukovar '91 Vukovar '91 33 57 25 63
3 HNK Cibalia HNK Cibalia 33 37 26 54
4 Bijelo Brdo Bijelo Brdo 33 41 37 44
5 NK Jarun NK Jarun 33 43 57 44
6 HNK Orijent Rijeka Orijent 33 45 45 43
7 NK Croatia Zmijavci Croatia 33 37 44 43
8 NK Solin NK Solin 33 47 55 43
9 Dubrava Tim kabel Dubrava 33 38 39 42
10 NK Dugopolje Dugopolje 33 30 35 41
11 NK Kustošija Kustošija 33 35 50 34
12 Hrvatski Dragovoljac Hrvatski 33 32 59 22
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
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Gorica HNK Gorica 30 54 21 64
2 Lučko Lučko 30 54 28 59
3 Pomorac Pomorac 30 50 23 56
4 NK Rudes NK Rudes 30 52 39 52
5 Imotski Imotski 30 35 32 48
6 NK Solin NK Solin 30 35 33 45
7 Medjimurje Cakovec Medjimurje 30 53 49 42
8 NK Dugopolje Dugopolje 30 39 30 41
9 Junak Sinj Junak Sinj 30 40 34 40
10 Vinogradar Vinogradar 30 43 38 40
11 NK Croatia Sesvete Croatia 30 37 41 40
12 Croatia Slavonski Croatia 30 42 42 39
13 NK HASK Zagreb HASK Zagreb 30 40 42 38
14 Mosor Mosor 30 32 41 34
15 Vukovar '91 Vukovar '91 30 21 83 20
16 Suhopolje Suhopolje 30 22 73 17
TEMPORADA 2009/2010
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Dugopolje Dugopolje 30 56 15 65
2 NK Raštane NK Raštane 30 65 28 61
3 NK Uskok Klis Uskok Klis 30 54 32 57
4 NK Jadran LP Jadran 30 49 42 48
5 Primorac Biograd Primorac 29 50 47 42
6 Velebit Benkovac Velebit 31 41 47 42
7 Dinara Knin Dinara Knin 30 31 36 39
8 Jadran KS Jadran KS 30 50 42 38
9 Zmaj Makarska Zmaj 30 46 50 38
10 Neretvanac Neretvanac 30 40 52 37
11 Zagora Unešić Zagora 31 39 53 37
12 Hrvace Hrvace 30 51 46 36
13 Primorac Stobrec Primorac 31 46 59 36
14 Neretva Neretva 30 34 49 35
15 NK Konavljanin Konavljanin 29 34 34 34
16 GOŠK DBK GOŠK DBK 30 27 58 31
17 NK Omiš NK Omiš 31 29 52 27
TEMPORADA 2008/2009
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Split Split 34 79 20 77
2 NK Raštane NK Raštane 33 69 33 68
3 Zmaj Makarska Zmaj 34 44 28 64
4 Velebit Benkovac Velebit 33 52 35 56
5 Primorac Biograd Primorac 33 57 41 53
6 GOŠK DBK GOŠK DBK 34 38 42 52
7 Zagora Unešić Zagora 34 47 44 50
8 NK Konavljanin Konavljanin 34 47 55 48
9 Hrvace Hrvace 33 56 44 47
10 Primorac Stobrec Primorac 34 52 62 47
11 Jadran KS Jadran KS 34 50 54 40
12 NK Jadran LP Jadran 34 31 49 40
13 NK Dugopolje Dugopolje 34 44 45 39
14 Neretva Neretva 34 39 54 38
15 Neretvanac Neretvanac 34 38 57 37
16 NK Omiš NK Omiš 34 28 41 35
17 Val Kaštel Stari Kaštel 34 35 66 34
18 Kaštel Gomilica Kaštel 34 30 66 30

  USO DE MEMORIA  
6,541,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4545
Total Execution Time  0.4563
  CADENA URL  
/historico/Nk-Dugopolje
  GET DATOS  
$_GET['/historico/Nk-Dugopolje']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13163 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13163 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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.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 = '13163' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=13163 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72476 AND teamId = 13163
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13163
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 `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.0149  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 = 13163 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68279 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 = 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.0146  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.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 `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.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 `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 = 8706 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 `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 = 24776 AND t.round = 32 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 `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 = 24749 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC