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

Radomlje

Entrenador: Darjan Slavic

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Celje Celje 33 71 29 75
2 NK Olimpija Ljubljana Olimpija 33 68 41 63
3 Maribor Maribor 33 61 32 60
4 NK Bravo NK Bravo 33 39 40 45
5 FC Koper FC Koper 33 46 45 44
6 NS Mura NS Mura 33 40 52 41
7 Domžale Domžale 33 47 55 39
8 NK Rogaška NK Rogaška 33 34 58 33
9 Radomlje Radomlje 33 30 49 28
10 Aluminij Aluminij 33 31 66 27
TEMPORADA 2022/2023
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 36 60 39 73
2 Celje Celje 36 53 34 67
3 Maribor Maribor 36 70 43 62
4 Domžale Domžale 36 50 42 52
5 NS Mura NS Mura 36 50 45 52
6 FC Koper FC Koper 36 46 40 50
7 Radomlje Radomlje 36 35 53 44
8 NK Bravo NK Bravo 36 33 41 36
9 ND Gorica ND Gorica 36 31 57 27
10 Tabor Sežana Tabor 36 29 63 24
TEMPORADA 2021/2022
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 57 37 70
2 FC Koper FC Koper 36 54 38 67
3 NK Olimpija Ljubljana Olimpija 36 53 38 62
4 NS Mura NS Mura 36 57 50 57
5 NK Bravo NK Bravo 36 33 33 49
6 Radomlje Radomlje 36 47 52 46
7 Domžale Domžale 36 47 46 45
8 Celje Celje 36 46 50 42
9 Tabor Sežana Tabor 36 30 41 30
10 Aluminij Aluminij 36 33 72 24
TEMPORADA 2020/2021
SEGUNDA ESLOVENIA 2. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 Nafta Lendava Nafta 7 13 6 16
2 Radomlje Radomlje 7 12 6 12
3 Brežice Brežice 7 13 8 11
4 NK Krka NK Krka 7 12 10 11
5 Triglav Kranj Triglav 7 7 7 9
6 ND Bilje ND Bilje 7 15 17 8
7 Roltek Dob Roltek Dob 7 10 18 6
8 Rudar Velenje Rudar 7 6 16 4
TEMPORADA 2019/2020
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 FC Koper FC Koper 20 42 13 44
2 ND Gorica ND Gorica 20 40 22 41
3 Radomlje Radomlje 20 48 23 40
4 Nafta Lendava Nafta 20 45 24 37
5 Fužinar Fužinar 20 35 22 37
6 NK Krsko NK Krsko 20 37 25 31
7 NK Krka NK Krka 20 31 32 31
8 ND Bilje ND Bilje 20 28 25 29
9 Roltek Dob Roltek Dob 20 37 35 29
10 Dekani Dekani 20 29 40 24
11 Drava Ptuj Drava Ptuj 20 28 34 21
12 Beltinci Beltinci 20 20 36 20
13 Brda Dobrovo Brda Dobrovo 20 22 38 19
14 Brežice Brežice 20 13 29 16
15 NK Rogaška NK Rogaška 20 16 47 14
16 Dravograd Dravograd 20 23 49 10
TEMPORADA 2018/2019
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NK Bravo NK Bravo 30 70 28 69
2 Tabor Sežana Tabor 30 59 22 63
3 Radomlje Radomlje 30 71 38 59
4 NK Krka NK Krka 30 59 41 54
5 Nafta Lendava Nafta 30 52 35 50
6 Fužinar Fužinar 30 46 34 48
7 Drava Ptuj Drava Ptuj 30 49 35 45
8 Roltek Dob Roltek Dob 30 46 42 40
9 ND Bilje ND Bilje 30 33 54 36
10 NK Rogaška NK Rogaška 30 35 50 34
11 Beltinci Beltinci 30 35 57 31
12 Brda Dobrovo Brda Dobrovo 30 35 46 29
13 Dekani Dekani 30 44 65 28
14 Brežice Brežice 30 32 52 26
15 Ilirija 1911 Ilirija 1911 30 33 65 26
16 Ankaran Hrvatini Ankaran 30 27 62 25
TEMPORADA 2017/2018
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NS Mura NS Mura 30 86 22 72
2 Drava Ptuj Drava Ptuj 30 68 37 66
3 Nafta Lendava Nafta 30 69 28 64
4 Radomlje Radomlje 30 58 47 57
5 NK Krka NK Krka 30 49 47 49
6 NK Bravo NK Bravo 30 55 32 49
7 Tabor Sežana Tabor 30 46 37 48
8 Ilirija 1911 Ilirija 1911 30 44 53 39
9 Brda Dobrovo Brda Dobrovo 30 37 42 38
10 Roltek Dob Roltek Dob 30 41 46 37
11 Dekani Dekani 30 39 64 36
12 Brežice Brežice 30 36 51 30
13 NK Rogaška NK Rogaška 30 42 54 27
14 Fužinar Fužinar 30 46 70 26
15 Zarica Kranj Zarica Kranj 30 36 64 25
16 NK Verzej NK Verzej 30 23 81 16
TEMPORADA 2016/2017
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 63 30 73
2 ND Gorica ND Gorica 36 48 39 60
3 NK Olimpija Ljubljana Olimpija 36 49 35 60
4 Domžale Domžale 36 63 45 56
5 Celje Celje 36 48 39 55
6 FC Koper FC Koper 36 43 40 50
7 Rudar Velenje Rudar 36 49 53 41
8 NK Krsko NK Krsko 36 39 50 39
9 Aluminij Aluminij 36 38 52 38
10 Radomlje Radomlje 36 23 80 13
TEMPORADA 2015/2016
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Radomlje Radomlje 27 51 24 55
2 Aluminij Aluminij 27 61 29 50
3 Drava Ptuj Drava Ptuj 27 43 42 46
4 Triglav Kranj Triglav 27 43 25 44
5 Roltek Dob Roltek Dob 27 42 44 32
6 NK Verzej NK Verzej 27 41 54 32
7 AH Mes Tech AH Mes Tech 27 33 45 31
8 Zarica Kranj Zarica Kranj 27 27 46 31
9 NK Tolmin NK Tolmin 27 36 43 26
10 Šencur Šencur 27 38 63 22
TEMPORADA 2014/2015
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 74 32 79
2 Celje Celje 36 58 31 70
3 Domžale Domžale 36 52 22 68
4 NK Olimpija Ljubljana Olimpija 36 55 32 61
5 Zavrč Zavrč 36 38 52 49
6 Rudar Velenje Rudar 36 44 43 46
7 NK Krka NK Krka 36 38 54 40
8 FC Koper FC Koper 36 35 58 40
9 ND Gorica ND Gorica 36 40 46 37
10 Radomlje Radomlje 36 21 85 16
TEMPORADA 2013/2014
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Roltek Dob Roltek Dob 25 47 23 60
2 Radomlje Radomlje 25 57 32 47
3 Aluminij Aluminij 25 42 19 44
4 NK Verzej NK Verzej 25 50 47 41
5 NK Krsko NK Krsko 25 42 32 36
6 Smartno 1928 Smartno 1928 25 33 33 36
7 AH Mes Tech AH Mes Tech 25 37 37 35
8 Šencur Šencur 25 40 47 30
9 Šampion Celje Šampion 25 32 59 16
10 Bela Krajina Bela Krajina 25 9 60 6
TEMPORADA 2012/2013
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Zavrč Zavrč 27 69 25 64
2 Roltek Dob Roltek Dob 27 63 27 57
3 NK Krka NK Krka 27 63 24 53
4 NK Krsko NK Krsko 27 39 41 37
5 Radomlje Radomlje 27 38 42 34
6 Šencur Šencur 27 37 46 32
7 Šampion Celje Šampion 27 32 50 32
8 Smartno 1928 Smartno 1928 27 31 51 30
9 Bela Krajina Bela Krajina 27 24 56 25
10 ND Dravinja Kostroj Dravinja 27 32 66 17
TEMPORADA 2011/2012
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Aluminij Aluminij 27 54 12 68
2 Roltek Dob Roltek Dob 27 42 33 48
3 Šencur Šencur 27 46 35 43
4 NK Interblock Ljubljana Interblock 27 33 30 38
5 Radomlje Radomlje 27 36 42 32
6 NK Krsko NK Krsko 27 24 27 31
7 Šampion Celje Šampion 27 38 40 28
8 Bela Krajina Bela Krajina 27 31 40 28
9 ND Dravinja Kostroj Dravinja 27 25 49 28
10 Smartno 1928 Smartno 1928 27 33 54 27
TEMPORADA 2010/2011
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 Radomlje Radomlje 26 48 15 62
2 Dekani Dekani 26 53 30 51
3 Kamnik Kamnik 26 50 29 50
4 NK Tolmin NK Tolmin 26 50 31 46
5 Zarica Kranj Zarica Kranj 26 47 35 46
6 NK Krka NK Krka 26 59 41 42
7 NK Ljubljana Ljubljana 26 48 47 40
8 Ankaran Hrvatini Ankaran 26 46 48 37
9 Ivančna Gorica Ivančna 26 35 44 34
10 ND Adria Miren Adria Miren 26 45 39 32
11 Brda Dobrovo Brda Dobrovo 26 43 37 31
12 Portorož Piran Portorož 26 44 74 24
13 Sava Kranj Sava Kranj 26 18 62 8
14 NK Naklo NK Naklo 26 13 67 6
TEMPORADA 2009/2010
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 ND Adria Miren Adria Miren 26 62 29 54
2 Roltek Dob Roltek Dob 26 62 25 52
3 Brda Dobrovo Brda Dobrovo 26 60 27 49
4 Radomlje Radomlje 26 55 38 49
5 Zarica Kranj Zarica Kranj 26 51 44 42
6 Dekani Dekani 26 36 28 41
7 NK Tolmin NK Tolmin 26 49 45 41
8 Ankaran Hrvatini Ankaran 26 43 35 40
9 Kamnik Kamnik 26 37 39 33
10 NK Krka NK Krka 26 44 41 31
11 Sava Kranj Sava Kranj 26 24 53 23
12 Jezero Medvode Jezero 26 29 63 21
13 Šobec Lesce Šobec Lesce 26 27 68 20
14 Zagorje Zagorje 26 28 72 12
TEMPORADA 2008/2009
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 Šencur Šencur 25 66 20 60
2 Dekani Dekani 25 56 30 51
3 Radomlje Radomlje 25 56 33 47
4 NK Krka NK Krka 25 52 37 45
5 Brda Dobrovo Brda Dobrovo 25 38 28 38
6 Zarica Kranj Zarica Kranj 25 36 26 38
7 Roltek Dob Roltek Dob 25 41 40 32
8 Sava Kranj Sava Kranj 25 33 48 31
9 NK Tolmin NK Tolmin 25 33 37 28
10 Kamnik Kamnik 25 27 40 27
11 ND Slovan Ljubljana Slovan 25 29 58 27
12 ND Adria Miren Adria Miren 25 30 49 24
13 NK Korte NK Korte 25 25 45 23
14 Tabor Sežana Tabor 13 7 38 6

  USO DE MEMORIA  
6,515,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6463
Total Execution Time  0.6475
  CADENA URL  
/historico/Radomlje
  GET DATOS  
$_GET['/historico/Radomlje']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0188  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 = 'Radomlje' 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.0126  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=13504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=13504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=13504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=13504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0258  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 = 72128
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13504 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 15 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1286795,1284204,1252773,1200435,1189095) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '13504' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '13504' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72128 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=13504 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73730,72128,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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72128 AND teamId = 13504
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 13504
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13504
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 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 = 72128 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0143  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 = 72128 WHERE rp.league_id = 72128 AND rp.teamId = 13504 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.0145  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 = 72128 WHERE rp.league_id = 72128 AND rp.teamId = 13504 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 72128 WHERE rp.league_id = 72128 AND rp.teamId = 13504 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 13504 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134  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 = 72128 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.0141  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 = 63210 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 57519 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.0141  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 = 62246 AND t.round = 7 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 `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 = 50029 AND t.round = 20 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 `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 = 44073 AND t.round = 30 ORDER BY team.conference 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 `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 = 38804 AND t.round = 30 ORDER BY team.conference 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 `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 = 33391 AND t.round = 36 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 `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 = 15743 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 3880 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 2874 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15282 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 15281 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 24391 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 24394 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 24397 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC