4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Samobor
TEMPORADA 2023/2024
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Segesta Segesta 17 37 19 33
2 Lučko Lučko 17 24 14 31
3 NK Trešnjevka Trešnjevka 17 34 26 30
4 Kurilovec Kurilovec 17 30 25 30
5 NK Maksimir NK Maksimir 17 39 22 29
6 Gaj Mače Gaj Mače 16 29 20 29
7 Dinamo OO Dinamo OO 17 25 27 29
8 Lukavec Lukavec 17 27 25 28
9 Vrapče Vrapče 17 32 28 27
10 NK Ponikve NK Ponikve 17 22 26 25
11 NK HASK Zagreb HASK Zagreb 17 30 29 19
12 Zagorec Zagorec 16 25 24 19
13 Samobor Samobor 17 18 26 19
14 Bistra Bistra 17 21 30 19
15 Tondach Bedekovcina Tondach 17 27 38 16
16 Petrinja Petrinja 17 16 31 16
17 NK Zelina NK Zelina 17 31 41 15
18 Sava Strmec Sava Strmec 17 13 29 13
TEMPORADA 2022/2023
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 NK Karlovac 1919 Karlovac 34 79 12 87
2 NK Maksimir NK Maksimir 34 73 48 68
3 Vrapče Vrapče 34 61 31 65
4 Lučko Lučko 34 60 46 58
5 Samobor Samobor 34 52 41 54
6 NK Ponikve NK Ponikve 34 48 48 53
7 Segesta Segesta 34 57 40 48
8 Sava Strmec Sava Strmec 34 43 59 47
9 NK Trešnjevka Trešnjevka 34 52 59 46
10 Lukavec Lukavec 34 37 49 43
11 Gaj Mače Gaj Mače 34 52 61 42
12 Kurilovec Kurilovec 34 38 51 40
13 NK HASK Zagreb HASK Zagreb 34 42 60 40
14 Petrinja Petrinja 34 49 61 39
15 Bistra Bistra 34 44 63 38
16 Dinamo OO Dinamo OO 34 55 67 37
17 Tekstilac Ravnice Tekstilac 34 36 50 36
18 Vrbovec Vrbovec 34 39 71 24
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 2014/2015
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo Zagreb II Dinamo 30 90 17 68
2 Rijeka II Rijeka II 30 51 21 62
3 NK Dugo Selo Dugo Selo 30 52 31 61
4 Dubrava Tim kabel Dubrava 30 55 24 60
5 Novigrad Novigrad 30 70 23 59
6 Istra 1961 II Istra 1961 30 48 42 46
7 Zagorec Zagorec 30 44 45 41
8 NK Trnje NK Trnje 30 44 48 41
9 NK HASK Zagreb HASK Zagreb 30 44 42 39
10 Vrapče Vrapče 30 32 39 37
11 NK Maksimir NK Maksimir 30 33 50 33
12 NK Špansko NK Špansko 30 46 60 31
13 Samobor Samobor 30 36 67 30
14 Vrbovec Vrbovec 30 27 74 26
15 Stupnik Stupnik 30 24 49 25
16 NK Zelina NK Zelina 30 18 82 14
TEMPORADA 2013/2014
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Maksimir NK Maksimir 30 59 40 59
2 NK Dugo Selo Dugo Selo 30 64 30 58
3 Bistra Donja Bistra Donja 30 49 21 58
4 Stupnik Stupnik 30 63 38 54
5 Vrbovec Vrbovec 30 49 26 54
6 Zagorec Zagorec 30 54 39 54
7 NK Trnje NK Trnje 30 63 38 53
8 Dubrava Tim kabel Dubrava 30 55 34 48
9 NK HASK Zagreb HASK Zagreb 30 47 30 46
10 Vrapče Vrapče 30 34 26 45
11 NK Špansko NK Špansko 30 41 67 35
12 Samobor Samobor 30 40 49 33
13 Kurilovec Kurilovec 30 29 48 28
14 NK Libertas NK Libertas 30 38 79 20
15 Klas Micevec Klas Micevec 30 19 59 18
16 NK Karlovac 1919 Karlovac 30 13 93 4
TEMPORADA 2012/2013
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Segesta Segesta 30 80 35 68
2 NK Dugo Selo Dugo Selo 30 60 32 58
3 NK Trnje NK Trnje 30 62 45 53
4 Vrapče Vrapče 30 41 26 51
5 Samobor Samobor 30 46 36 48
6 Stupnik Stupnik 30 53 50 46
7 Bistra Donja Bistra Donja 30 37 37 46
8 Kurilovec Kurilovec 30 53 39 44
9 NK Maksimir NK Maksimir 30 39 36 44
10 Dubrava Tim kabel Dubrava 30 41 32 42
11 Vrbovec Vrbovec 30 48 53 39
12 Tekstilac Ravnice Tekstilac 30 37 46 38
13 Lekenik Lekenik 30 35 45 36
14 NK Trešnjevka Trešnjevka 30 24 52 23
15 Gaj Mače Gaj Mače 30 22 67 19
16 Sava Strmec Sava Strmec 30 29 76 11
TEMPORADA 2008/2009
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 NK Rudes NK Rudes 34 63 24 76
2 Lučko Lučko 34 75 45 64
3 Vrapče Vrapče 34 58 45 56
4 Jadran Jadran 34 46 34 56
5 NK Polet NK Polet 34 59 51 48
6 Novalja Novalja 34 40 39 48
7 NK HASK Zagreb HASK Zagreb 33 54 52 45
8 Rovinj Rovinj 34 59 48 44
9 HNK Orijent Rijeka Orijent 34 45 41 44
10 NK Rudar Labin Rudar Labin 34 48 51 44
11 Nehaj Nehaj 34 37 41 44
12 Vrbovec Vrbovec 34 39 45 44
13 Grobničan Grobničan 34 40 58 43
14 NK Medulin NK Medulin 34 43 49 42
15 NK Radnik NK Radnik 34 38 46 40
16 NK Maksimir NK Maksimir 34 34 52 40
17 NK Pula Istra Pula Istra 34 36 67 37
18 Samobor Samobor 33 34 60 29
TEMPORADA 2001/2002
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 30 46 21 59
2 Uljanik Uljanik 29 52 26 56
3 Novalja Novalja 30 30 18 50
4 NK Uskok Klis Uskok Klis 30 48 32 49
5 NK Solin NK Solin 30 44 24 48
6 HNK Orijent Rijeka Orijent 30 36 37 46
7 NK Croatia Sesvete Croatia 29 31 29 42
8 Inter Zapresic Inter 30 46 40 41
9 GOŠK DBK GOŠK DBK 30 26 37 41
10 Imotski Imotski 30 36 40 40
11 Mosor Mosor 30 38 50 37
12 Zminj Zminj 29 25 41 36
13 Segesta Segesta 30 28 33 35
14 Samobor Samobor 30 31 40 31
15 NK Trnje NK Trnje 30 30 43 26
16 Vrbovec Vrbovec 29 23 59 23
TEMPORADA 1998/1999
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Vukovar '91 Vukovar '91 20 30 12 41
2 Belisce Belisce 20 43 26 39
3 Zagorec Zagorec 20 29 26 36
4 NK Cakovec NK Cakovec 20 31 18 35
5 Segesta Segesta 19 29 17 33
6 NK Istra 1961 Istra 1961 20 27 17 33
7 Buducnost Orehovica Buducnost 20 32 28 33
8 Split Split 20 30 16 32
9 NK Otok NK Otok 20 29 27 30
10 NK Jadran LP Jadran 20 34 25 29
11 Bjelovar Bjelovar 20 20 18 29
12 Imotski Imotski 20 24 31 23
13 HNK Đakovo Croatia Đakovo 19 22 20 22
14 NK Solin NK Solin 20 22 26 22
15 HNK Orijent Rijeka Orijent 20 21 33 22
16 NK Croatia Sesvete Croatia 20 24 33 21
17 Samobor Samobor 20 20 33 20
18 Posavina Posavina 20 15 37 11
19 Inter Zapresic Inter 20 13 52 9
TEMPORADA 1997/1998
LIGA CROATA HNL GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 22 46 18 49
2 HNK Hajduk Split Hajduk Split 22 36 20 43
3 NK Zagreb NK Zagreb 22 35 23 41
4 Hrvatski Dragovoljac Hrvatski 22 31 18 36
5 NK Osijek NK Osijek 22 29 26 32
6 Zadar Zadar 22 25 24 28
7 HNK Rijeka HNK Rijeka 22 20 24 26
8 NK Varazdin NK Varazdin 22 24 32 24
9 Suhopolje Suhopolje 22 17 24 23
10 NK Slaven Belupo Slaven 22 20 43 23
11 Samobor Samobor 22 23 35 22
12 HNK Sibenik HNK Sibenik 22 19 38 17

  USO DE MEMORIA  
6,114,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1236
Total Execution Time  0.1249
  CADENA URL  
/historico/Samobor
  GET DATOS  
$_GET['/historico/Samobor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0027  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 = 'Samobor' 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=59428 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=59428 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 73586
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59428 AND type_rel = 2
0.0024  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 = '59428' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '59428' 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 = 73586 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=59428 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 (73586) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73586 AND teamId = 59428
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 `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 = 73586 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '59428' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59428' and rp.type = 4
0.0020  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 = '59428' 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 events2024 e ON e.player_id = p.id AND e.league_id = 73586 WHERE rp.league_id = 73586 AND rp.teamId = 59428 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73586 WHERE rp.league_id = 73586 AND rp.teamId = 59428 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 73586 WHERE rp.league_id = 73586 AND rp.teamId = 59428 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 59428 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73586 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 68851 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.0036  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.0040  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.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 `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 = 9295 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 24834 AND t.round = 30 ORDER BY team.conference 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 `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 = 24823 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 = 24763 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 `tables2002` 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 = 8729 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 `tables1999` 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 = 8738 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables1998` 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 = 10236 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 73586 ORDER BY nameShow LIMIT 100