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

Gudja United

Entrenador: Renzo Cumbo

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA MALTA
Equipo PJ GF GC Puntos
1 Hamrun Spartans Hamrun 25 59 15 61
2 Floriana FC Floriana FC 25 52 15 57
3 Sliema Wanderers Sliema 25 31 12 47
4 Marsaxlokk FC Marsaxlokk 24 38 22 40
5 Hibernians Hibernians 24 28 25 34
6 Birkirkara Birkirkara 24 24 23 34
7 Naxxar Lions FC Naxxar Lions 24 28 33 32
8 Gzira United Gzira United 24 34 30 30
9 Balzan FC Balzan FC 24 25 28 30
10 Mosta Mosta 24 17 32 27
11 Santa Lucía Santa Lucía 24 21 38 26
12 Valletta FC Valletta FC 24 21 25 24
13 Sirens Sirens 24 15 45 15
14 Gudja United Gudja United 25 12 62 6
TEMPORADA 2022/2023
LIGA MALTA GRUPO 1
Equipo PJ GF GC Puntos
1 Hamrun Spartans Hamrun 26 45 10 69
2 Birkirkara Birkirkara 26 50 20 50
3 Gzira United Gzira United 26 46 19 48
4 Balzan FC Balzan FC 26 37 32 46
5 Mosta Mosta 26 47 33 46
6 Hibernians Hibernians 26 45 37 46
7 Valletta FC Valletta FC 26 37 23 37
8 Floriana FC Floriana FC 26 30 26 37
9 Sirens Sirens 26 25 32 33
10 Gudja United Gudja United 26 28 39 29
11 Marsaxlokk FC Marsaxlokk 26 28 38 25
12 Santa Lucía Santa Lucía 26 20 49 15
13 Zebbug Rangers Zebbug 26 21 58 14
14 Pieta Hotspurs Pieta 26 22 65 12
TEMPORADA 2021/2022
LIGA MALTA GRUPO 2
Equipo PJ GF GC Puntos
1 Hibernians Hibernians 27 46 23 54
2 Floriana FC Floriana FC 27 38 21 51
3 Hamrun Spartans Hamrun 27 33 24 45
4 Gzira United Gzira United 27 46 38 43
5 Birkirkara Birkirkara 27 35 27 41
6 Gudja United Gudja United 27 29 35 32
TEMPORADA 2020/2021
LIGA MALTA
Equipo PJ GF GC Puntos
1 Hamrun Spartans Hamrun 23 56 20 56
2 Hibernians Hibernians 23 53 20 51
3 Gzira United Gzira United 23 49 21 46
4 Birkirkara Birkirkara 23 45 25 44
5 Sliema Wanderers Sliema 23 39 31 40
6 Mosta Mosta 23 41 36 36
7 Valletta FC Valletta FC 23 27 35 33
8 Santa Lucía Santa Lucía 23 38 35 29
9 Sirens Sirens 23 27 35 28
10 Balzan FC Balzan FC 23 31 29 27
11 Gudja United Gudja United 23 29 35 27
12 Floriana FC Floriana FC 23 26 34 27
13 Zejtun Corinthians FC Zejtun 23 28 40 24
14 Tarxien Rainbows Tarxien 23 25 48 21
15 Lija Lija 23 25 46 20
16 Senglea Athletic Senglea 23 13 62 2
TEMPORADA 2019/2020
LIGA MALTA
Equipo PJ GF GC Puntos
1 Floriana FC Floriana FC 20 38 15 41
2 Valletta FC Valletta FC 20 32 22 38
3 Hibernians Hibernians 20 34 20 37
4 Sirens Sirens 20 30 26 35
5 Birkirkara Birkirkara 20 30 20 33
6 Gzira United Gzira United 20 35 19 32
7 Balzan FC Balzan FC 20 33 29 28
8 Mosta Mosta 20 29 35 28
9 Hamrun Spartans Hamrun 20 24 25 25
10 Sliema Wanderers Sliema 20 24 22 24
11 Gudja United Gudja United 20 24 30 24
12 Santa Lucía Santa Lucía 20 24 33 23
13 Senglea Athletic Senglea 20 21 39 16
14 Tarxien Rainbows Tarxien 20 18 61 4
TEMPORADA 2018/2019
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Sirens Sirens 26 60 19 59
2 Gudja United Gudja United 26 43 29 49
3 Santa Lucía Santa Lucía 26 68 32 48
4 Naxxar Lions FC Naxxar Lions 26 47 35 45
5 Pembroke Athleta FC Pembroke 26 34 22 40
6 Zebbug Rangers Zebbug 26 35 30 37
7 Lija Lija 26 49 50 35
8 Mqabba FC Mqabba FC 26 26 38 35
9 Swieqi United Swieqi 26 38 39 34
10 Zejtun Corinthians FC Zejtun 26 35 32 32
11 Qrendi Qrendi 26 41 50 32
12 Vittoriosa Stars Vittoriosa 26 27 36 29
13 San Gwann San Gwann 26 30 52 23
14 Marsa FC Marsa FC 26 17 86 5
TEMPORADA 2017/2018
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Gudja United Gudja United 24 43 13 46
2 Santa Lucía Santa Lucía 24 50 26 46
3 Swieqi United Swieqi 24 39 19 44
4 Fgura United FC Fgura United 24 48 27 43
5 Siggiewi Siggiewi 24 43 24 41
6 Marsaxlokk FC Marsaxlokk 24 42 31 39
7 Birzebbuga St. Peters FC Birzebbuga 24 42 37 36
8 Kalkara Kalkara 24 47 49 36
9 Mgarr United FC Mgarr United 24 39 45 35
10 Luqa St. Andrew's Luqa 24 30 53 22
11 St. Georges FC Georges 24 16 49 18
12 Attard Attard 24 21 42 16
13 Gharghur Gharghur 24 16 61 7
TEMPORADA 2016/2017
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Zejtun Corinthians FC Zejtun 26 54 15 65
2 Qrendi Qrendi 26 64 22 61
3 San Gwann San Gwann 26 69 18 60
4 Zabbar St. Patrick Zabbar 26 50 20 59
5 Swieqi United Swieqi 26 45 43 37
6 Birzebbuga St. Peters FC Birzebbuga 26 32 31 36
7 Siggiewi Siggiewi 26 40 34 35
8 Mgarr United FC Mgarr United 26 37 38 30
9 Attard Attard 26 24 53 27
10 Marsaxlokk FC Marsaxlokk 26 28 31 23
11 St. Georges FC Georges 26 33 49 23
12 Gudja United Gudja United 26 20 61 22
13 Mellieha Mellieha 26 24 52 21
14 Ghaxaq Ghaxaq 26 17 70 11
TEMPORADA 2015/2016
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Gzira United Gzira United 26 58 13 64
2 Hamrun Spartans Hamrun 26 57 17 61
3 Senglea Athletic Senglea 26 47 21 52
4 Pieta Hotspurs Pieta 26 32 28 44
5 Lija Lija 26 40 28 40
6 Vittoriosa Stars Vittoriosa 26 39 31 37
7 Mqabba FC Mqabba FC 26 44 33 35
8 Zebbug Rangers Zebbug 26 30 32 32
9 Rabat Ajax Rabat Ajax 26 28 37 32
10 Fgura United FC Fgura United 26 24 35 30
11 Melita Melita 26 24 48 28
12 San Gwann San Gwann 26 30 50 27
13 St. Georges FC Georges 26 20 46 19
14 Gudja United Gudja United 26 22 76 9
TEMPORADA 2014/2015
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Pembroke Athleta FC Pembroke 26 54 22 55
2 Saint Andrews Saint 26 49 32 51
3 Gzira United Gzira United 26 46 31 45
4 Melita Melita 26 36 28 45
5 Fgura United FC Fgura United 26 32 27 43
6 Gudja United Gudja United 26 46 32 41
7 St. Georges FC Georges 26 43 38 41
8 Lija Lija 26 45 43 38
9 Vittoriosa Stars Vittoriosa 26 44 43 38
10 Mqabba FC Mqabba FC 26 40 36 36
11 Rabat Ajax Rabat Ajax 26 27 37 29
12 Zurrieq FC Zurrieq FC 26 29 46 22
13 Msida St Joseph Msida Joseph 26 27 64 15
14 Birzebbuga St. Peters FC Birzebbuga 26 25 64 12
TEMPORADA 2013/2014
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Pieta Hotspurs Pieta 24 68 22 58
2 Zebbug Rangers Zebbug 24 51 38 45
3 Saint Andrews Saint 24 55 45 40
4 Gzira United Gzira United 24 38 31 35
5 Gudja United Gudja United 24 41 45 34
6 Melita Melita 24 36 35 33
7 Lija Lija 24 44 44 33
8 St. Georges FC Georges 24 33 40 31
9 Zurrieq FC Zurrieq FC 24 40 40 30
10 Birzebbuga St. Peters FC Birzebbuga 24 40 47 29
11 Msida St Joseph Msida Joseph 24 35 43 27
12 Hamrun Spartans Hamrun 24 31 42 19
13 Zejtun Corinthians FC Zejtun 24 26 66 17
TEMPORADA 2012/2013
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Naxxar Lions FC Naxxar Lions 22 47 22 44
2 Vittoriosa Stars Vittoriosa 22 41 28 44
3 Pieta Hotspurs Pieta 22 46 22 43
4 Lija Lija 22 42 30 42
5 Saint Andrews Saint 22 43 32 38
6 Marsaxlokk FC Marsaxlokk 22 38 44 32
7 Gudja United Gudja United 22 35 36 30
8 Gzira United Gzira United 22 26 29 24
9 Birzebbuga St. Peters FC Birzebbuga 22 38 43 23
10 Zejtun Corinthians FC Zejtun 22 21 35 21
11 Dingli Swallows Dingli 22 21 50 16
12 Mqabba FC Mqabba FC 22 24 51 8
TEMPORADA 2011/2012
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Gzira United Gzira United 26 58 16 60
2 Gudja United Gudja United 26 57 20 54
3 Mellieha Mellieha 26 51 27 52
4 Gharghur Gharghur 26 57 37 44
5 Zebbug Rangers Zebbug 26 47 30 43
6 San Gwann San Gwann 26 43 35 39
7 Msida St Joseph Msida Joseph 26 42 29 36
8 Kirkop United Kirkop 26 44 52 35
9 St. Venera St. Venera 26 27 45 33
10 Zurrieq FC Zurrieq FC 26 26 40 29
11 Siggiewi Siggiewi 26 31 51 27
12 Attard Attard 26 30 56 25
13 Senglea Athletic Senglea 26 34 71 15
14 Luqa St. Andrew's Luqa 26 24 62 15

  USO DE MEMORIA  
6,383,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6936
Total Execution Time  0.6948
  CADENA URL  
/historico/Gudja-United
  GET DATOS  
$_GET['/historico/Gudja-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0157  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 = 'Gudja-United' 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.0145  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=14038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=14038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=14038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=14038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14038 AND type_rel = 2
0.0150  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 = '14038' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '14038' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '14038' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 74508 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 72280 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=14038 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (74508,72280,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72280 AND teamId = 14038
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 74508 AND teamId = 14038
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 14038
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 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 = 72280 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '14038' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14038' and rp.type = 4
0.0146  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 = '14038' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 72280 WHERE rp.league_id = 72280 AND rp.teamId = 14038 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.0157  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 = 72280 WHERE rp.league_id = 72280 AND rp.teamId = 14038 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 72280 WHERE rp.league_id = 72280 AND rp.teamId = 14038 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 14038 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72280 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 68111 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 63251 AND t.round = 22 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 `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 = 67092 AND t.round = 5 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 `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 = 57798 AND t.round = 28 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 `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 = 50107 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.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 `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 = 44313 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 `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 = 44314 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 33789 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 15727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 3869 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 2988 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 16032 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 16095 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC