4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del NK Krka
TEMPORADA 2023/2024
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Nafta Lendava Nafta 27 53 26 55
2 ND Gorica ND Gorica 26 46 20 51
3 Beltinci Beltinci 26 39 18 50
4 Primorje Primorje 26 41 23 50
5 Brinje-Grosuplje Brinje-Grosu 27 48 29 48
6 Triglav Kranj Triglav 27 42 27 48
7 Bistrica iz Slovenske Bistrica 26 39 38 38
8 Rudar Velenje Rudar 27 32 44 33
9 Dekani Dekani 26 28 33 29
10 ND Bilje ND Bilje 26 39 48 29
11 NK Tolmin NK Tolmin 27 29 43 29
12 ND Dravinja Kostroj Dravinja 27 27 42 29
13 NK Krka NK Krka 27 33 47 27
14 Ilirija 1911 Ilirija 1911 27 27 41 25
15 Tabor Sežana Tabor 27 34 56 25
16 Fužinar Fužinar 27 30 52 24
TEMPORADA 2022/2023
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NK Rogaška NK Rogaška 30 52 23 68
2 Aluminij Aluminij 30 58 23 64
3 Ilirija 1911 Ilirija 1911 30 55 30 54
4 NK Krka NK Krka 30 46 28 53
5 Beltinci Beltinci 30 47 45 44
6 Nafta Lendava Nafta 30 50 43 41
7 Primorje Primorje 30 42 40 41
8 Brinje-Grosuplje Brinje-Grosu 30 30 37 38
9 Bistrica iz Slovenske Bistrica 30 39 40 37
10 ND Bilje ND Bilje 30 40 53 37
11 Dekani Dekani 30 27 29 35
12 Triglav Kranj Triglav 30 33 52 35
13 Rudar Velenje Rudar 30 41 51 32
14 Fužinar Fužinar 30 39 56 31
15 NK Krsko NK Krsko 30 36 59 24
16  Roltek Dob Roltek Dob 30 37 63 21
TEMPORADA 2021/2022
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 ND Gorica ND Gorica 30 55 20 72
2 Triglav Kranj Triglav 30 55 19 62
3 NK Krka NK Krka 30 54 35 51
4 NK Rogaška NK Rogaška 30 51 38 51
5 Rudar Velenje Rudar 30 51 43 49
6 Nafta Lendava Nafta 30 68 36 47
7 ND Bilje ND Bilje 30 38 39 45
8 Primorje Primorje 30 46 36 41
9  Roltek Dob Roltek Dob 30 45 46 39
10 Ilirija 1911 Ilirija 1911 30 35 37 38
11 Fužinar Fužinar 30 46 52 37
12 Beltinci Beltinci 30 34 47 35
13 Dekani Dekani 30 31 38 31
14 NK Krsko NK Krsko 30 25 54 26
15 Brežice Brežice 30 28 60 20
16 Drava Ptuj Drava Ptuj 30 30 92 20
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
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Triglav Kranj Triglav 25 64 23 61
2  Roltek Dob Roltek Dob 25 61 26 54
3 Ankaran Hrvatini Ankaran 25 45 29 45
4 Brežice Brežice 25 36 42 36
5 Drava Ptuj Drava Ptuj 25 45 55 31
6 Brda Dobrovo Brda Dobrovo 25 27 34 26
7 Zarica Kranj Zarica Kranj 25 26 53 23
8 NK Krka NK Krka 25 40 42 22
9 NK Verzej NK Verzej 25 21 45 20
10 Zavrč Zavrč 9 13 29 3
TEMPORADA 2015/2016
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 36 75 25 74
2 Maribor Maribor 36 78 37 68
3 Domžale Domžale 36 46 31 55
4 ND Gorica ND Gorica 36 48 49 52
5 Celje Celje 36 32 46 45
6 Rudar Velenje Rudar 36 34 52 41
7 NK Krsko NK Krsko 36 24 48 41
8 Zavrč Zavrč 36 32 41 40
9 FC Koper FC Koper 36 40 54 40
10 NK Krka NK Krka 36 30 56 34
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
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 78 31 77
2 FC Koper FC Koper 36 52 36 69
3 Rudar Velenje Rudar 36 55 33 63
4 ND Gorica ND Gorica 36 60 32 58
5 Zavrč Zavrč 36 58 64 53
6 Domžale Domžale 36 47 36 45
7 NK Olimpija Ljubljana Olimpija 36 39 56 42
8 Celje Celje 36 30 58 37
9 NK Krka NK Krka 36 31 64 31
10 Triglav Kranj Triglav 36 34 74 26
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
TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo PJ GF GC Puntos
1 NK Krka NK Krka 26 77 31 58
2 Ankaran Hrvatini Ankaran 26 57 33 47
3 Dekani Dekani 26 41 32 44
4 Ivančna Gorica Ivančna 26 44 38 40
5 NK Tolmin NK Tolmin 26 44 41 40
6 Zagorje Zagorje 26 36 44 39
7 MNK Izola MNK Izola 26 45 49 36
8 Kamnik Kamnik 26 37 39 35
9 Zarica Kranj Zarica Kranj 26 53 57 35
10 Brda Dobrovo Brda Dobrovo 26 37 46 35
11 ND Adria Miren Adria Miren 26 32 41 29
12 Ilirska Bistrica Ilirska 26 40 43 28
13 Jesenice Jesenice 26 26 49 23
14 Svoboda Ljubljana Svoboda 26 23 49 22
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
TEMPORADA 2007/2008
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Rudar Velenje Rudar 27 70 31 50
2 Bonifika Koper Bonifika 27 44 29 43
3 Bela Krajina Bela Krajina 27 40 30 43
4 Aluminij Aluminij 27 39 30 41
5 Mura 05 Mura 05 27 31 42 37
6 Zavrč Zavrč 27 36 35 36
7 NK Krsko NK Krsko 27 33 42 36
8 Zagorje Zagorje 27 43 45 35
9 Triglav Kranj Triglav 27 36 40 35
10 NK Krka NK Krka 27 23 71 17
TEMPORADA 2001/2002
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Dravograd Dravograd 30 76 24 74
2 NK Ljubljana Ljubljana 30 89 12 72
3 Aluminij Aluminij 30 73 22 71
4 Ivančna Gorica Ivančna 30 65 32 57
5 NK Drava Ptuj Drava Ptuj 30 57 36 51
6 Bela Krajina Bela Krajina 30 65 40 48
7 ND Dravinja Kostroj Dravinja 30 37 24 43
8 Dekani Dekani 30 46 43 41
9 Nafta Lendava Nafta 30 46 52 39
10 Železničar Maribor Železničar 30 37 44 39
11 Zagorje Zagorje 30 36 45 37
12 Brda Dobrovo Brda Dobrovo 30 33 61 33
13 Triglav Bakovci Triglav 30 29 85 24
14 Tabor Sežana Tabor 30 31 73 23
15 NK Pohorje NK Pohorje 30 36 73 15
16 NK Krka NK Krka 30 15 105 8
TEMPORADA 2000/2001
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Triglav Kranj Triglav 29 68 19 70
2 Smartno 1928 Smartno 1928 29 60 31 62
3 Aluminij Aluminij 29 62 29 60
4 Dekani Dekani 29 55 31 56
5 NK Krka NK Krka 29 46 41 51
6 ND Dravinja Kostroj Dravinja 29 28 36 41
7 Svoboda Ljubljana Svoboda 29 50 40 40
8 Zagorje Zagorje 29 36 33 37
9 Nafta Lendava Nafta 29 32 31 37
10 Železničar Maribor Železničar 29 40 49 37
11 Ivančna Gorica Ivančna 29 45 50 36
12 NK Pohorje NK Pohorje 29 28 54 31
13 Beltinci Beltinci 29 37 60 25
14 NK Šentjur NK Šentjur 15 23 27 21
15 Brda Dobrovo Brda Dobrovo 29 39 74 17
16 Renkovci Renkovci 29 35 79 13

  USO DE MEMORIA  
7,182,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6317
Total Execution Time  0.6332
  CADENA URL  
/historico/Krka
  GET DATOS  
$_GET['/historico/Krka']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11794 AND type_rel = 2
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=389 AND type_rel = 3
0.0182  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 = '11794' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0182  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=11794 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0154  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,72187,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.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 72187 AND teamId = 11794
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 11794
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11794
0.0173  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 11794 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.0168  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 11794 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 11794 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 11794 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0155  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 = 72187 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 68064 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.0159  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 = 63332 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.0151  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.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 `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.0152  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.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 `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.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 = 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.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 `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 = 33393 AND t.round = 27 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 = 15441 AND t.round = 36 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 = 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.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 `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 = 2488 AND t.round = 36 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 = 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.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 `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 = 24381 AND t.round = 26 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 `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.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 `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.0151  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
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 `tables2008` 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 = 15277 AND t.round = 27 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 `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 = 23726 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 `tables2001` 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 = 23728 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 72187 ORDER BY nameShow LIMIT 100