4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del NK Opatija
TEMPORADA 2023/2024
SEGUNDA CROACIA 2. NL
Equipo PJ GF GC Puntos
1 NK Opatija NK Opatija 24 41 18 52
2 NK Križevci Križevci 25 44 21 51
3 NK Karlovac 1919 Karlovac 25 37 29 47
4 NK Kustošija Kustošija 25 47 22 46
5 Mladost Ždralovi Mladost 25 47 22 45
6 NK Jadran LP Jadran 25 35 21 40
7 Marsonia Marsonia 25 44 43 37
8 NK Dugo Selo Dugo Selo 25 31 31 30
9 Bjelovar Bjelovar 25 40 44 30
10 NK Trnje NK Trnje 25 27 42 29
11 Grobničan Grobničan 24 36 34 26
12 Hrvace Hrvace 24 35 48 26
13 Hrvatski Dragovoljac Hrvatski 25 25 41 26
14 Jadran Jadran 25 29 48 24
15 Krk Krk 25 20 36 23
16 Belisce Belisce 24 16 54 13
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
TERCERA CROACIA 3. NL GRUPO 5
Equipo PJ GF GC Puntos
1 NK Opatija NK Opatija 16 34 13 34
2 Grobničan Grobničan 16 39 18 30
3 NK Rudar Labin Rudar Labin 16 21 14 29
4 Crikvenica Crikvenica 16 23 16 27
5 Jadran Jadran 16 25 26 24
6 Krk Krk 16 27 30 24
7 NK Pazinka NK Pazinka 16 19 25 17
8 Vinodol Vinodol 16 17 26 17
9 Rovinj Rovinj 16 15 24 17
10 Novigrad Novigrad 16 20 30 16
11 Uljanik Uljanik 16 19 26 15
12 Nehaj Nehaj 16 11 22 15
TEMPORADA 2018/2019
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 34 93 37 80
2 Dubrava Tim kabel Dubrava 34 82 36 74
3 HNK Orijent Rijeka Orijent 34 72 47 68
4 NK Trnje NK Trnje 34 61 41 58
5 Kurilovec Kurilovec 34 64 41 55
6 NK HASK Zagreb HASK Zagreb 34 52 42 51
7 NK Dugo Selo Dugo Selo 34 49 60 50
8 NK Opatija NK Opatija 34 55 50 48
9 Jadran Jadran 34 55 61 47
10 Krk Krk 34 52 54 45
11 NK Ponikve NK Ponikve 34 42 56 44
12 Vrbovec Vrbovec 34 48 61 43
13 NK Maksimir NK Maksimir 34 54 58 42
14 Zagorec Zagorec 34 55 60 40
15 NK Špansko NK Špansko 34 47 75 38
16 NK Jarun NK Jarun 34 46 62 37
17 Novigrad Novigrad 34 50 66 33
18 NK Zagreb NK Zagreb 34 26 96 15
TEMPORADA 2017/2018
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 34 73 26 74
2 NK Opatija NK Opatija 34 55 28 69
3 Dubrava Tim kabel Dubrava 34 65 45 61
4 Vrbovec Vrbovec 34 53 38 58
5 Zagorec Zagorec 34 64 56 55
6 NK Maksimir NK Maksimir 34 57 50 49
7 Kurilovec Kurilovec 34 54 52 49
8 Krk Krk 34 45 54 45
9 NK Zagreb NK Zagreb 34 46 51 44
10 NK Trnje NK Trnje 34 52 57 42
11 NK HASK Zagreb HASK Zagreb 34 63 56 41
12 Jadran Jadran 34 46 49 41
13 NK Špansko NK Špansko 34 43 52 41
14 NK Dugo Selo Dugo Selo 34 38 49 41
15 NK Pazinka NK Pazinka 34 40 51 40
16 Vrapče Vrapče 34 52 54 39
17 NK Rudar Labin Rudar Labin 34 31 69 33
18 Segesta Segesta 34 36 76 31
TEMPORADA 2016/2017
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 30 69 19 66
2 NK Kustošija Kustošija 30 59 35 54
3 NK Trnje NK Trnje 30 44 24 54
4 Krk Krk 30 47 36 50
5 NK Opatija NK Opatija 30 58 51 49
6 Vrapče Vrapče 30 49 38 44
7 Jadran Jadran 30 50 53 43
8 NK HASK Zagreb HASK Zagreb 30 51 49 41
9 Dubrava Tim kabel Dubrava 30 38 46 41
10 NK Maksimir NK Maksimir 30 35 40 36
11 Segesta Segesta 30 45 53 36
12 Vrbovec Vrbovec 30 45 54 33
13 NK Dugo Selo Dugo Selo 30 33 51 33
14 Zagorec Zagorec 30 37 59 32
15 Samobor Samobor 30 29 37 28
16 Stupnik Stupnik 30 47 91 23
TEMPORADA 2015/2016
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Novigrad Novigrad 30 59 19 75
2 Vinogradar Vinogradar 30 65 23 60
3 NK Trnje NK Trnje 30 44 29 55
4 Samobor Samobor 30 49 37 48
5 Zagorec Zagorec 30 40 35 48
6 Krk Krk 30 41 28 47
7 Vrapče Vrapče 30 44 41 46
8 NK Maksimir NK Maksimir 30 40 34 43
9 NK Opatija NK Opatija 30 39 45 43
10 Rijeka II Rijeka II 30 43 49 42
11 Dubrava Tim kabel Dubrava 30 35 39 33
12 NK HASK Zagreb HASK Zagreb 30 22 43 30
13 NK Dugo Selo Dugo Selo 30 37 47 29
14 Vrbovec Vrbovec 30 20 43 24
15 Stupnik Stupnik 30 24 54 24
16 NK Špansko NK Špansko 30 23 59 20
TEMPORADA 2013/2014
TERCERA CROACIA 3. NL GRUPO 5
Equipo PJ GF GC Puntos
1 NK Opatija NK Opatija 28 64 30 64
2 Novigrad Novigrad 28 69 24 63
3 Krk Krk 28 49 30 47
4 Jadran Jadran 28 50 39 45
5 Mladost Fazana Mladost 28 34 35 43
6 HNK Orijent Rijeka Orijent 28 35 43 43
7 Rovinj Rovinj 28 40 44 37
8 Grobničan Grobničan 28 44 50 37
9 NK Buje NK Buje 28 31 47 34
10 NK Halubjan Viškovo Halubjan 28 32 41 33
11 NK Naprijed Hreljin Naprijed 28 29 34 32
12 Nehaj Nehaj 28 38 42 31
13 Crikvenica Crikvenica 28 29 47 31
14 NK Rudar Labin Rudar Labin 28 32 46 29
15 Vinodol Vinodol 28 19 43 21
TEMPORADA 2012/2013
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Grobničan Grobničan 30 71 32 67
2 NK Naprijed Hreljin Naprijed 30 44 32 49
3 Krk Krk 30 39 28 49
4 Rovinj Rovinj 30 46 30 46
5 NK Opatija NK Opatija 30 51 44 43
6 Vinodol Vinodol 30 37 33 43
7 NK Buje NK Buje 30 44 41 43
8 HNK Orijent Rijeka Orijent 30 46 45 43
9 Crikvenica Crikvenica 30 41 42 39
10 Nehaj Nehaj 30 32 42 36
11 NK Halubjan Viškovo Halubjan 30 25 35 36
12 NK Rudar Labin Rudar Labin 30 30 45 36
13 Jadran Jadran 30 35 38 35
14 Novigrad Novigrad 30 38 48 34
15 Novalja Novalja 30 21 39 32
16 NK Jedinstvo Jedinstvo 30 28 54 27
TEMPORADA 2011/2012
TERCERA CROACIA 3. NL GRUPO 4
Equipo PJ GF GC Puntos
1 Vrapče Vrapče 34 51 15 69
2 NK Zelina NK Zelina 34 65 30 69
3 NK Dugo Selo Dugo Selo 34 56 35 60
4 NK Opatija NK Opatija 34 39 38 54
5 Jadran Jadran 34 48 35 53
6 Segesta Segesta 34 44 47 48
7 Vrbovec Vrbovec 34 47 37 44
8 Novalja Novalja 34 43 43 43
9 NK Buje NK Buje 34 38 45 43
10 Grobničan Grobničan 34 54 54 41
11 Nehaj Nehaj 34 26 42 41
12 Dubrava Tim kabel Dubrava 34 49 55 40
13 Krk Krk 34 46 54 39
14 HNK Orijent Rijeka Orijent 34 38 48 39
15 Stupnik Stupnik 34 54 62 38
16 Crikvenica Crikvenica 34 38 49 38
17 Rovinj Rovinj 34 29 46 35
18 Vinodol Vinodol 34 41 71 32
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,559,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4597
Total Execution Time  0.4612
  CADENA URL  
/historico/Opatija
  GET DATOS  
$_GET['/historico/Opatija']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25080 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2677 AND type_rel = 3
0.0129  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 = '25080' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=25080 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72477,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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72477 AND teamId = 25080
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 25080
0.0127  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 = '25080' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25080' and rp.type = 4
0.0136  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 = '25080' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 72477 WHERE rp.league_id = 72477 AND rp.teamId = 25080 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.0132  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 = 72477 WHERE rp.league_id = 72477 AND rp.teamId = 25080 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 72477 WHERE rp.league_id = 72477 AND rp.teamId = 25080 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 25080 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 `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 = 72477 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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.0128  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.0131  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.0129  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 = 51152 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.0132  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 = 44727 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 39730 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 34138 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 15854 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 24837 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24813 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24805 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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