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
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 36 70 31 75
2 Dinamo Batumi Dinamo 36 57 31 70
3 FC Iberia 1999 Iberia 1999 36 67 36 70
4 Locomotive Tbilisi Locomotive 36 44 46 55
5 Chikhura Chikhura 36 48 44 47
6 Torpedo Kutaisi Torpedo 36 53 54 44
7 Dila Gori Dila Gori 36 40 44 43
8 FC Rustavi FC Rustavi 36 40 56 38
9 Sioni Sioni 36 38 80 38
10 WIT Georgia WIT Georgia 36 15 50 20
TEMPORADA 2017/2018
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 FC Iberia 1999 Iberia 1999 36 64 29 79
2 Dinamo Tbilisi Dinamo 36 73 38 69
3 Torpedo Kutaisi Torpedo 36 66 25 69
4 Chikhura Chikhura 36 54 33 64
5 Dila Gori Dila Gori 36 60 40 63
6 Locomotive Tbilisi Locomotive 36 43 55 44
7 FC Rustavi FC Rustavi 36 33 44 37
8 Sioni Sioni 36 39 65 31
9 Samtredia Samtredia 36 28 81 21
10 Kolkheti Poti Kolkheti 36 26 76 14
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 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
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 2
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 0 0 0 48
2 Zestafoni Zestafoni 0 0 0 40
3 Chikhura Chikhura 0 0 0 38
4 FC Rustavi FC Rustavi 0 0 0 33
5 Guria Lanchkhuti Guria 0 0 0 33
6 Sioni Sioni 0 0 0 33
TEMPORADA 2012/2013
LIGA GEORGIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 10 8 9 44
2 Merani Martvili Merani 10 8 15 34
3 Sioni Sioni 10 17 13 33
4 WIT Georgia WIT Georgia 10 10 13 33
5 Dinamo Batumi Dinamo 10 17 8 31
6 Kolkheti Poti Kolkheti 10 11 13 17
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 2010/2011
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Zestafoni Zestafoni 36 72 19 78
2 Dinamo Tbilisi Dinamo 36 55 22 72
3 FC Rustavi FC Rustavi 36 52 31 66
4 Torpedo Kutaisi Torpedo 36 31 22 55
5 WIT Georgia WIT Georgia 36 35 41 48
6 FC Baia Zugdidi Baia Zugdidi 36 36 51 44
7 Kolkheti Poti Kolkheti 36 25 47 40
8 Sioni Sioni 36 27 45 39
9 Spartaki Tskhinvali Spartaki 36 32 42 32
10 Samtredia Samtredia 36 27 72 25
TEMPORADA 2009/2010
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 36 70 24 83
2 Dinamo Tbilisi Dinamo 36 62 19 74
3 Zestafoni Zestafoni 36 59 31 68
4 WIT Georgia WIT Georgia 36 48 31 64
5 Spartaki Tskhinvali Spartaki 36 44 58 43
6 Sioni Sioni 36 27 43 38
7 Samtredia Samtredia 36 43 68 37
8 FC Baia Zugdidi Baia Zugdidi 36 29 48 32
9 Locomotive Tbilisi Locomotive 36 19 50 26
10 Gagra Gagra 36 30 59 24
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
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

  USO DE MEMORIA  
6,609,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1741
Total Execution Time  0.1754
  CADENA URL  
/historico/Fc-Metalurgi-Rustavi/2021
  GET DATOS  
$_GET['/historico/Fc-Metalurgi-Rustavi/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0037  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 = 'Fc-Metalurgi-Rustavi' 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.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=5704 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=5704 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=5704 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=5704 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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.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 = 66105
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5704 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5704 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (664532,680212) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '5704' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '5704' 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.0019  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 = 66105 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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.0026  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=5704 AND l.year in (2020,2021,2022) 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 (70680,67540,66336,62807) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 66336 AND teamId = 5704
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 67540 AND teamId = 5704
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 70680 AND teamId = 5704
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 5704
0.0021  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 = '5704' 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 = '5704' and rp.type = 4
0.0021  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 = '5704' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042  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 = 5704 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.0032  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 = 5704 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 5704 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 5704 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 `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.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 `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.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 `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 = 48699 AND t.round = 36 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 `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 = 42713 AND t.round = 36 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 `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.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 `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.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 = 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.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 `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.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 `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 = 10403 AND t.round = 10 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 `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 = 10406 AND t.round = 10 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 `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 = 10407 AND t.round = 22 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 `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.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 `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 = 10409 AND t.round = 36 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 `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 = 10410 AND t.round = 36 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 `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.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 `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.0019  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 = 61399 ORDER BY nameShow LIMIT 100