4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Borjomi
TEMPORADA 2018/2019
TERCERA GEORGIA
Equipo PJ GF GC Puntos
1 Merani Martvili Merani 14 26 6 35
2 Aragvi Dusheti Aragvi 14 25 11 28
3 Bakhmaro Bakhmaro 14 18 12 25
4 Kolkheti Khobi Kolkheti 14 17 17 21
5 Borjomi Borjomi 14 10 19 20
6 Samgurali Samgurali 14 14 13 19
7 Saburtalo II Saburtalo 14 21 25 19
8 Betlemi Betlemi 14 11 18 12
9 Meshakhte Meshakhte 14 12 21 9
10 Gori FC Gori FC 14 11 23 8
TEMPORADA 2017/2018
TERCERA GEORGIA
Equipo PJ GF GC Puntos
1 Zugdidi Zugdidi 38 65 31 84
2 Bakhmaro Bakhmaro 38 78 40 79
3 Guria Lanchkhuti Guria 38 59 31 73
4 Saburtalo II Saburtalo 38 60 50 67
5 Kolkheti Khobi Kolkheti 38 54 35 61
6 Aragvi Dusheti Aragvi 38 64 55 61
7 Borjomi Borjomi 38 66 56 61
8 Meshakhte Meshakhte 38 59 54 57
9 Gori FC Gori FC 38 58 48 53
10 Betlemi Betlemi 38 52 58 51
11 Samegrelo Samegrelo 38 63 55 48
12 Chiatura Chiatura 38 39 47 47
13 Varketili Varketili 38 58 58 47
14 Algeti Algeti 38 54 64 46
15 Mark Stars Mark Stars 38 59 65 46
16 Imereti Imereti 38 44 52 45
17 Gardabani Gardabani 38 39 63 39
18 FC Sulori Vani Sulori Vani 38 38 77 36
19 Samgurali II Samgurali 38 40 82 31
20 Matchakhela Matchakhela 38 35 63 28
TEMPORADA 2016/2017
TRANSICIÓN TERCERA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gori FC Gori FC 10 16 8 33
2 Algeti Algeti 10 24 10 31
3 Borjomi Borjomi 10 20 13 30
4 FC Sulori Vani Sulori Vani 10 10 19 30
5 Margveti Margveti 10 16 10 29
6 FC Skuri Tsalenjikha Skuri 10 14 12 24
7 Lazika Lazika 10 22 22 24
8 Chkherimela Chkherimela 10 17 17 23
9 Liakhvi Tskhinvali Liakhvi 10 28 19 19
10 Sapovnela Sapovnela 10 5 42 6
TEMPORADA 2015/2016
TRANSICIÓN SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 15 40 12 38
2 WIT Georgia WIT Georgia 16 34 14 36
3 Merani Martvili Merani 15 31 8 32
4 Samgurali Samgurali 16 29 24 32
5 Gagra Gagra 16 29 21 31
6 Meshakhte Meshakhte 16 25 12 29
7 Borjomi Borjomi 16 22 17 25
8 FC Sulori Vani Sulori Vani 16 20 21 24
9 Chiatura Chiatura 16 15 21 23
10 Lazika Lazika 16 31 32 22
11 FC Skuri Tsalenjikha Skuri 16 32 24 21
12 Kolkheti Khobi Kolkheti 16 20 24 21
13 Sapovnela Sapovnela 16 14 18 19
14 Imereti Imereti 13 20 20 15
15 Liakhvi Tskhinvali Liakhvi 15 16 36 10
16 Mark Stars Mark Stars 15 15 31 6
17 Chkherimela Chkherimela 15 13 42 6
18 Gardabani Gardabani 16 13 42 4
TEMPORADA 2014/2015
SEGUNDA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sapovnela Sapovnela 36 64 28 77
2 Borjomi Borjomi 36 40 43 54
3 Gagra Gagra 36 59 44 51
4 Betlemi Betlemi 36 51 50 49
5 Mertskhali Mertskhali 36 45 68 48
6 Algeti Algeti 36 47 39 47
7 Meshakhte Meshakhte 36 57 55 47
8 Kolkheti Khobi Kolkheti 36 46 48 47
9 FC Skuri Tsalenjikha Skuri 36 47 55 46
10 Dinamo Tbilisi II Dinamo 36 42 68 33
TEMPORADA 2013/2014
TERCERA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
TEMPORADA 2008/2009
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 WIT Georgia WIT Georgia 30 57 19 69
2 Dinamo Tbilisi Dinamo 30 70 21 63
3 FC Rustavi FC Rustavi 30 40 20 57
4 Zestafoni Zestafoni 30 43 27 52
5 Sioni Sioni 30 35 29 44
6 Locomotive Tbilisi Locomotive 30 35 33 38
7 Mglebi Zugdidi Mglebi 30 36 41 36
8 Meskheti Akhaltsikhe Meskheti 30 23 42 29
9 Gagra Gagra 30 23 48 28
10 Spartaki Tskhinvali Spartaki 30 28 46 25
11 Borjomi Borjomi 30 21 85 13
TEMPORADA 2007/2008
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 26 67 18 70
2 WIT Georgia WIT Georgia 26 45 14 60
3 Zestafoni Zestafoni 26 56 16 59
4 FC Rustavi FC Rustavi 26 26 16 52
5 FC Ameri FC Ameri 26 48 27 48
6 Meskheti Akhaltsikhe Meskheti 26 29 30 39
7 Mglebi Zugdidi Mglebi 26 27 33 33
8 Sioni Sioni 26 34 35 32
9 Borjomi Borjomi 26 32 39 31
10 Locomotive Tbilisi Locomotive 26 27 35 27
11 Spartaki Tskhinvali Spartaki 26 15 28 23
12 Merani Tbilisi Merani 26 15 54 19
13 Dinamo Batumi Dinamo 26 16 51 16
14 Dila Gori Dila Gori 26 12 53 8
TEMPORADA 2006/2007
LIGA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 26 57 9 63
2 Dinamo Tbilisi Dinamo 26 57 19 62
3 Zestafoni Zestafoni 26 55 11 57
4 FC Ameri FC Ameri 26 53 14 57
5 WIT Georgia WIT Georgia 26 40 28 45
6 Sioni Sioni 26 28 26 37
7 Torpedo Kutaisi Torpedo 26 24 35 31
8 Dinamo Batumi Dinamo 26 27 30 30
9 Borjomi Borjomi 26 29 35 30
10 Locomotive Tbilisi Locomotive 26 25 34 30
11 Merani Tbilisi Merani 26 20 41 26
12 Chikhura Chikhura 26 13 46 21
13 Dila Gori Dila Gori 26 21 56 15
14 Kakheti Telavi Kakheti 26 21 86 2
TEMPORADA 2005/2006
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Sioni Sioni 30 57 16 73
2 WIT Georgia WIT Georgia 30 53 17 68
3 Dinamo Tbilisi Dinamo 30 61 22 64
4 Zestafoni Zestafoni 30 44 22 61
5 Borjomi Borjomi 30 50 26 59
6 Dinamo Batumi Dinamo 30 42 21 58
7 FC Ameri FC Ameri 30 32 26 49
8 Locomotive Tbilisi Locomotive 30 41 48 37
9 Kakheti Telavi Kakheti 30 32 46 34
10 Kolkheti Poti Kolkheti 30 26 36 32
11 Dila Gori Dila Gori 30 35 44 31
12 Torpedo Kutaisi Torpedo 30 28 42 30
13 FC Tbilisi FC Tbilisi 30 29 44 29
14 FK Tskhinvali Tskhinvali 30 30 61 27
15 Dinamo Sokhumi Dinamo 30 26 70 18
16 Spartaki Tbilisi Spartaki 30 12 57 15
TEMPORADA 2004/2005
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 FC Ameri FC Ameri 30 93 18 72
2 Borjomi Borjomi 30 74 36 69
3 Spartaki Tbilisi Spartaki 30 52 36 57
4 WIT Georgia II Georgia 30 49 28 55
5 Kakheti Telavi Kakheti 30 57 41 55
6 Dinamo Tbilisi II Dinamo 30 64 50 49
7 Spartaki Tskhinvali Spartaki 30 39 36 46
8 Chikhura Chikhura 30 38 35 43
9 Locomotive Tbilisi II Locomotive 30 33 40 38
10 Guria Lanchkhuti Guria 30 30 45 38
11 FC Rustavi FC Rustavi 30 39 43 37
12 FC Tbilisi II Tbilisi 30 35 44 35
13 Iveria Iveria 30 31 45 35
14 Merani Tbilisi Merani 30 35 53 28
15 Gareji Gareji 30 26 70 17
16 Chiatura Chiatura 30 17 92 4
TEMPORADA 2001/2002
SEGUNDA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dila Gori Dila Gori 22 51 14 49
2 FC Milani Tsnori Milani 22 48 20 46
3 TSU Tbilisi TSU Tbilisi 22 40 14 45
4 Shukura Shukura 22 27 17 41
5 Locomotive Tbilisi II Locomotive 22 41 23 39
6 Spartaki Tskhinvali Spartaki 22 42 31 36
7 Dinamo Tbilisi II Dinamo 22 21 24 28
8 Lazika Lazika 22 28 40 25
9 Kolkheti Khobi Kolkheti 22 21 35 22
10 Samtredia Samtredia 22 20 39 19
11 Merani-91 II Merani-91 22 17 47 16
12 Borjomi Borjomi 22 16 68 7
TEMPORADA 2000/2001
SEGUNDA GEORGIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kolkheti Khobi Kolkheti 10 18 10 32
2 Borjomi Borjomi 10 12 8 32
3 Okeane Okeane 10 17 7 31
4 Iveria Iveria 10 23 9 25
5 Merani Tbilisi Merani 10 7 15 21
6 Dinamo Zugdidi Dinamo 10 0 28 12
TEMPORADA 1999/2000
SEGUNDA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spartaki Tskhinvali Spartaki 20 47 8 47
2 Borjomi Borjomi 20 41 14 47
3 Iveria Iveria 20 45 20 42
4 SA Iberia SA Iberia 20 28 18 35
5 Meskheti Akhaltsikhe Meskheti 20 44 36 31
6 Tskhumi Tskhumi 20 36 27 29
7 Gantiadi Kaspi Gantiadi 20 23 44 22
8 FC Mretebi Tbilisi Mretebi 20 20 37 20
9 SAU SAU 20 24 39 19
10 Vardzia Vardzia 20 17 55 14
11 Aragvi Dusheti Aragvi 20 22 49 13
12 Locomotive Tbilisi II Locomotive 20 35 16 45
13 Alazani Alazani 20 58 20 44
14 Arsenali II Arsenali II 20 43 22 43
15 Tchabukiani Tchabukiani 20 41 13 42
16 Zooveti Tbilisi Zooveti 20 40 29 35
17 Khalibii-97 Khalibii-97 20 27 33 24
18 Amirani Amirani 20 31 44 24
19 ShSS Akademia ShSS 20 16 18 21
20 Norchi Dinamoeli Tbilisi II Norchi 20 21 41 16
21 Gardabani Gardabani 20 20 55 11
22 Duruji Duruji 20 12 53 7

  USO DE MEMORIA  
6,210,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1166
Total Execution Time  0.1178
  CADENA URL  
/historico/Borjomi/2021
  GET DATOS  
$_GET['/historico/Borjomi/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
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 = 61879
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19211 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1504 AND type_rel = 3
0.0026  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 = '19211' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '19211' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 61879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=19211 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (67540,67095) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 67095 AND teamId = 19211
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67540 AND teamId = 19211
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 61879 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '19211' 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 = '19211' 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 = '19211' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 events2021 e ON e.player_id = p.id AND e.league_id = 61879 WHERE rp.league_id = 61879 AND rp.teamId = 19211 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.0021  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 events2021 e ON e.player_id = p.id AND e.league_id = 61879 WHERE rp.league_id = 61879 AND rp.teamId = 19211 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2021 e ON e.player_id = p.id AND e.league_id = 61879 WHERE rp.league_id = 61879 AND rp.teamId = 19211 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 19211 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 48864 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 42880 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 39923 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 39924 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 15751 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 33771 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 4177 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 24777 AND t.round = 30 ORDER BY team.conference 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 `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 = 10411 AND t.round = 33 ORDER BY team.conference 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 `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 = 10420 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2007` 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 = 10421 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2006` 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 = 10433 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2005` 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 = 15193 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 15196 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 15199 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 15201 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2000` 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 = 15202 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC