4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2020/2021
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Sioni Sioni 36 74 36 81
2 Gagra Gagra 36 74 27 75
3 Merani Martvili Merani 36 65 44 64
4 Gareji Gareji 36 52 48 50
5 Merani Tbilisi Merani 36 58 58 47
6 Shevardeni 1906 Shevardeni 36 63 58 46
7 Zugdidi Zugdidi 36 47 71 46
8 WIT Georgia WIT Georgia 36 38 43 45
9 FC Rustavi FC Rustavi 36 46 58 39
10 Chikhura Chikhura 36 24 98 10
TEMPORADA 2019/2020
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Shukura Shukura 18 32 14 31
2 Samgurali Samgurali 18 23 12 30
3 Gagra Gagra 18 24 10 29
4 FC Rustavi FC Rustavi 18 35 27 26
5 Zugdidi Zugdidi 18 27 31 25
6 Shevardeni 1906 Shevardeni 18 28 38 25
7 Sioni Sioni 18 23 16 24
8 Merani Martvili Merani 18 23 20 24
9 WIT Georgia WIT Georgia 18 17 25 21
10 Aragvi Dusheti Aragvi 18 10 49 8
TEMPORADA 2018/2019
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Merani Tbilisi Merani 36 87 35 81
2 Samtredia Samtredia 36 63 28 77
3 FC Telavi FC Telavi 36 70 36 63
4 Shevardeni 1906 Shevardeni 36 47 48 52
5 Gagra Gagra 36 46 42 47
6 Shukura Shukura 36 36 46 46
7 Zugdidi Zugdidi 36 38 54 40
8 Guria Lanchkhuti Guria 36 39 64 36
9 Kolkheti Poti Kolkheti 36 31 80 34
10 Spartaki Tskhinvali Spartaki 36 38 62 32
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
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 36 72 25 83
2 Merani Martvili Merani 36 67 16 80
3 Sioni Sioni 36 52 48 59
4 Gagra Gagra 36 46 38 53
5 Samgurali Samgurali 36 46 46 53
6 WIT Georgia WIT Georgia 36 42 40 52
7 Spartaki Tskhinvali Spartaki 36 62 75 40
8 Guria Lanchkhuti Guria 36 47 68 37
9 Meshakhte Meshakhte 36 33 75 27
10 Zugdidi Zugdidi 36 32 68 25
TEMPORADA 2015/2016
TRANSICIÓN LIGA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Samtredia Samtredia 12 27 9 27
2 Dinamo Batumi Dinamo 12 20 5 20
3 FC Iberia 1999 Iberia 1999 12 17 12 19
4 Kolkheti Poti Kolkheti 12 10 18 18
5 Dila Gori Dila Gori 12 13 12 17
6 Sioni Sioni 12 13 19 11
7 Zugdidi Zugdidi 12 5 30 6
8 Chikhura Chikhura 12 27 11 29
9 Dinamo Tbilisi Dinamo 12 17 5 23
10 Torpedo Kutaisi Torpedo 12 16 12 15
11 Locomotive Tbilisi Locomotive 12 11 18 15
12 Shukura Shukura 12 10 13 12
13 Guria Lanchkhuti Guria 12 8 21 11
14 Spartaki Tskhinvali Spartaki 12 12 21 9
TEMPORADA 2014/2015
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dila Gori Dila Gori 30 50 21 64
2 Dinamo Batumi Dinamo 30 40 24 58
3 Dinamo Tbilisi Dinamo 30 56 28 58
4 Spartaki Tskhinvali Spartaki 30 47 37 53
5 Chikhura Chikhura 30 39 36 46
6 Samtredia Samtredia 30 40 31 45
7 Torpedo Kutaisi Torpedo 30 39 33 41
8 Shukura Shukura 30 36 38 41
9 Guria Lanchkhuti Guria 30 38 43 39
10 Kolkheti Poti Kolkheti 30 31 31 37
11 Merani Martvili Merani 30 29 33 36
12 Zugdidi Zugdidi 30 24 45 33
13 Sioni Sioni 30 32 46 32
14 FC Rustavi FC Rustavi 30 25 46 26
15 WIT Georgia WIT Georgia 30 27 40 26
16 Zestafoni Zestafoni 30 40 61 26
TEMPORADA 2013/2014
LIGA GEORGIA GRUPO 3
Equipo PJ GF GC Puntos
1 Dila Gori Dila Gori 0 0 0 32
2 Torpedo Kutaisi Torpedo 0 0 0 29
3 WIT Georgia WIT Georgia 0 0 0 29
4 Spartaki Tskhinvali Spartaki 0 0 0 20
5 Zugdidi Zugdidi 0 0 0 20
6 Merani Martvili Merani 0 0 0 15
TEMPORADA 2012/2013
LIGA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 10 25 4 78
2 Dila Gori Dila Gori 10 24 11 68
3 Torpedo Kutaisi Torpedo 10 16 12 64
4 Chikhura Chikhura 10 14 17 57
5 Zestafoni Zestafoni 10 5 18 42
6 Zugdidi Zugdidi 10 4 26 36
TEMPORADA 2011/2012
LIGA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Zestafoni Zestafoni 14 28 16 55
2 FC Rustavi FC Rustavi 14 21 9 55
3 Torpedo Kutaisi Torpedo 14 17 13 48
4 Kolkheti Poti Kolkheti 14 17 23 42
5 Dinamo Tbilisi Dinamo 14 20 15 40
6 Dila Gori Dila Gori 14 22 15 36
7 Merani Martvili Merani 14 19 33 23
8 Zugdidi Zugdidi 14 14 34 22
TEMPORADA 2005/2006
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Chikhura Chikhura 34 87 34 78
2 Merani Tbilisi Merani 34 59 27 74
3 Gagra Gagra 34 49 22 68
4 Dinamo Tbilisi II Dinamo 34 57 27 62
5 Meshakre Agara Meshakre 34 46 32 59
6 Meskheti Akhaltsikhe Meskheti 34 50 30 57
7 FC Ameri II FC Ameri II 34 40 29 51
8 FC Rustavi FC Rustavi 34 50 37 49
9 Guria Lanchkhuti Guria 34 50 47 47
10 WIT Georgia II Georgia 34 43 45 45
11 FC Tbilisi II Tbilisi 34 34 40 44
12 Meshakhte Meshakhte 34 38 40 42
13 Zugdidi Zugdidi 34 23 33 41
14 Chiatura Chiatura 34 38 56 37
15 Zestafoni II Zestafoni 34 23 44 36
16 Gareji Gareji 34 28 44 31
17 Locomotive Tbilisi II Locomotive 34 22 84 21
18 Liakhvi Achabeti Liakhvi 34 24 90 13
TEMPORADA 1998/1999
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 30 91 17 77
2 Torpedo Kutaisi Torpedo 30 73 27 67
3 Locomotive Tbilisi Locomotive 30 43 14 64
4 Kolkheti Poti Kolkheti 30 57 36 52
5 Dinamo Batumi Dinamo 30 49 22 50
6 WIT Georgia WIT Georgia 30 42 29 47
7 Merani Tbilisi Merani 30 37 29 45
8 Samtredia Samtredia 30 45 48 38
9 FC Arsenali Tbilisi Arsenali 30 34 44 38
10 Dila Gori Dila Gori 30 37 54 35
11 Samgurali Samgurali 30 32 57 33
12 FC Rustavi FC Rustavi 30 28 46 32
13 Sioni Sioni 30 27 52 28
14 TSU Tbilisi TSU Tbilisi 30 28 46 27
15 Zugdidi Zugdidi 30 21 70 20
16 Guria Lanchkhuti Guria 30 34 87 13
TEMPORADA 1997/1998
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 30 86 15 71
2 Dinamo Batumi Dinamo 30 58 19 61
3 Kolkheti Poti Kolkheti 30 56 27 57
4 Torpedo Kutaisi Torpedo 30 51 30 54
5 Zugdidi Zugdidi 30 43 51 49
6 Locomotive Tbilisi Locomotive 30 34 37 44
7 Merani Tbilisi Merani 30 39 33 39
8 TSU Tbilisi TSU Tbilisi 30 35 33 39
9 Dila Gori Dila Gori 30 31 36 37
10 WIT Georgia WIT Georgia 30 27 37 36
11 FC Rustavi FC Rustavi 30 32 41 34
12 Samgurali Samgurali 30 31 50 34
13 Sioni Sioni 30 49 47 31
14 Guria Lanchkhuti Guria 30 30 58 27
15 Chiatura Chiatura 30 25 59 26
16 Margveti Margveti 30 21 75 13
TEMPORADA 1996/1997
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 30 101 23 81
2 Kolkheti Poti Kolkheti 30 75 28 64
3 Dinamo Batumi Dinamo 30 71 22 62
4 Merani Tbilisi Merani 30 53 28 60
5 Torpedo Kutaisi Torpedo 30 70 58 46
6 Zugdidi Zugdidi 30 51 57 40
7 Margveti Margveti 30 44 66 38
8 Dila Gori Dila Gori 30 30 39 37
9 Sioni Sioni 30 30 39 36
10 FC Rustavi FC Rustavi 30 44 57 35
11 Samgurali Samgurali 30 35 54 35
12 TSU Tbilisi TSU Tbilisi 30 37 40 34
13 Guria Lanchkhuti Guria 30 33 63 33
14 Samtredia Samtredia 30 31 57 26
15 Kakheti Telavi Kakheti 30 29 66 26
16 Iveria Iveria 30 24 61 21
TEMPORADA 1995/1996
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 30 109 16 79
2 Samtredia Samtredia 30 96 38 68
3 Margveti Margveti 30 85 37 68
4 Kolkheti Poti Kolkheti 30 69 38 68
5 FC Rustavi FC Rustavi 30 70 36 66
6 Dinamo Batumi Dinamo 30 68 28 54
7 Torpedo Kutaisi Torpedo 30 69 49 52
8 Dila Gori Dila Gori 30 53 55 40
9 Sioni Sioni 30 38 64 33
10 Iveria Iveria 30 33 57 33
11 Zugdidi Zugdidi 30 42 63 30
12 Shevardeni 1906 Shevardeni 30 40 61 30
13 Guria Lanchkhuti Guria 30 35 74 27
14 Kakheti Telavi Kakheti 30 29 68 27
15 Egrisi Egrisi 30 42 90 17
16 Duruji Duruji 30 23 127 4
TEMPORADA 1994/1995
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 30 125 33 78
2 Samtredia Samtredia 30 75 25 74
3 Kolkheti Poti Kolkheti 30 72 28 63
4 Dinamo Batumi Dinamo 30 69 40 54
5 Zugdidi Zugdidi 30 58 54 46
6 Torpedo Kutaisi Torpedo 30 58 47 44
7 FC Rustavi FC Rustavi 30 48 37 44
8 Dila Gori Dila Gori 30 25 35 37
9 Margveti Margveti 30 35 53 36
10 Shevardeni 1906 Shevardeni 30 35 48 32
11 Iveria Iveria 30 42 58 31
12 Kakheti Telavi Kakheti 30 37 59 31
13 Guria Lanchkhuti Guria 30 36 81 30
14 Duruji Duruji 30 28 65 27
15 Sapovnela Sapovnela 30 34 76 24
16 Samgurali Samgurali 30 30 68 21
TEMPORADA 1993/1994
LIGA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Guria Lanchkhuti Guria 14 36 22 27
2 Kolkheti Poti Kolkheti 13 33 19 26
3 Dinamo Batumi Dinamo 14 31 22 25
4 Samtredia Samtredia 14 29 23 23
5 Torpedo Kutaisi Torpedo 14 23 27 21
6 Shukura Shukura 14 26 28 20
7 Zugdidi Zugdidi 13 27 34 13
8 Samgurali Samgurali 14 12 42 4
9 Amirani Amirani 0 0 0 0
10 Mziuri Mziuri 0 0 0 0
11 Tskhumi Tskhumi 0 0 0 0

  USO DE MEMORIA  
6,825,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1621
Total Execution Time  0.1639
  CADENA URL  
/historico/Zugdidi/2021
  GET DATOS  
$_GET['/historico/Zugdidi/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0035  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 = 'Zugdidi' AND l.year = 2021 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.0019  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=11152 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=11152 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=11152 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=11152 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 61399
0.0024  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=11152 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11152 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  SELECT /*35 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 (304127) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '11152' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '11152' 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.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 = 61399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=11152 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (66336,62807,61879) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 66336 AND teamId = 11152
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 61879 AND teamId = 11152
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 11152
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 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 = 61399 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0046  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 = 61399 WHERE rp.league_id = 61399 AND rp.teamId = 11152 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.0056  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 = 61399 WHERE rp.league_id = 61399 AND rp.teamId = 11152 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 61399 WHERE rp.league_id = 61399 AND rp.teamId = 11152 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 11152 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 = 61399 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.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 `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 = 55078 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 48700 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 39909 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15498 AND t.round = 30 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 `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 = 33343 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 `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 = 4149 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 `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 = 2882 AND t.round = 22 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 `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 = 10404 AND t.round = 10 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 `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 = 2206 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 `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 = 10405 AND t.round = 10 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 `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 = 10408 AND t.round = 14 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 `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 = 15192 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 14469 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 14468 AND t.round = 30 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 `tables1997` 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 = 14467 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1996` 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 = 14466 AND t.round = 30 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 `tables1995` 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 = 14465 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 `tables1994` 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 = 14462 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC