4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Gwann
TEMPORADA 2023/2024
TERCERA MALTA GRUPO 1
Equipo PJ GF GC Puntos
1 Mtarfa Mtarfa 22 71 13 55
2 Birzebbuga St. Peters FC Birzebbuga 22 67 26 49
3 Qrendi Qrendi 22 55 28 41
4 Mellieha Mellieha 22 50 29 37
5 Xghajra Tornados Xghajra 22 33 30 37
6 Rabat Ajax Rabat Ajax 22 31 29 34
7 Mqabba FC Mqabba FC 22 33 32 34
8 Pembroke Athleta FC Pembroke 22 50 51 30
9 St. Venera St. Venera 22 32 47 25
10 Siggiewi Siggiewi 22 22 47 18
11 Kalkara Kalkara 22 30 73 16
12 Mdina Knights Mdina 22 6 75 1
13 Mgarr United FC Mgarr United 20 68 18 46
14 Qormi FC Qormi FC 20 47 31 37
15 Marsaskala Marsaskala 20 39 28 37
16 San Gwann San Gwann 20 52 29 35
17 Gharghur Gharghur 20 34 25 34
18 Kirkop United Kirkop 20 52 27 32
19 Vittoriosa Stars Vittoriosa 20 50 27 32
20 St. Georges FC Georges 20 47 35 31
21 Ghaxaq Ghaxaq 20 34 63 14
22 Dingli Swallows Dingli 20 18 67 10
23 Ta' Xbiex Ta' Xbiex 20 23 114 6
TEMPORADA 2022/2023
SEGUNDA MALTA GRUPO 3
Equipo PJ GF GC Puntos
1 Swieqi United Swieqi 28 53 38 50
2 Fgura United FC Fgura United 28 57 39 41
3 Saint Andrews Saint 28 37 40 40
4 Lija Lija 28 51 54 39
5 Attard Attard 28 39 45 37
6 Marsa FC Marsa FC 28 40 42 35
7 San Gwann San Gwann 28 33 45 34
8 Qrendi Qrendi 28 38 52 31
9 Marsaskala Marsaskala 28 50 57 29
10 Vittoriosa Stars Vittoriosa 28 27 57 22
11 Mqabba FC Mqabba FC 28 29 56 22
12 Mtarfa Mtarfa 28 21 45 21
TEMPORADA 2021/2022
SEGUNDA MALTA GRUPO 1
Equipo PJ GF GC Puntos
1 Pembroke Athleta FC Pembroke 20 49 16 48
2 Marsaxlokk FC Marsaxlokk 20 40 22 41
3 Zejtun Corinthians FC Zejtun 20 44 24 40
4 Naxxar Lions FC Naxxar Lions 20 37 22 37
5 Melita Melita 20 28 22 33
6 San Gwann San Gwann 20 38 22 30
7 Lija Lija 20 39 37 28
8 Mqabba FC Mqabba FC 20 29 41 20
9 Vittoriosa Stars Vittoriosa 20 23 61 16
10 Rabat Ajax Rabat Ajax 20 20 42 13
11 St. Georges FC Georges 20 13 51 5
TEMPORADA 2020/2021
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Marsa FC Marsa FC 22 54 21 50
2 Pembroke Athleta FC Pembroke 22 41 18 47
3 San Gwann San Gwann 22 43 32 36
4 Zebbug Rangers Zebbug 22 45 30 34
5 Swieqi United Swieqi 22 41 30 34
6 Naxxar Lions FC Naxxar Lions 20 28 25 30
7 Qrendi Qrendi 21 28 39 29
8 Pieta Hotspurs Pieta 21 35 35 27
9 Saint Andrews Saint 22 29 33 27
10 Vittoriosa Stars Vittoriosa 21 20 25 27
11 Marsaxlokk FC Marsaxlokk 19 25 13 26
12 Fgura United FC Fgura United 21 26 35 26
13 Mqabba FC Mqabba FC 21 19 29 24
14 St. Georges FC Georges 20 16 40 13
15 Qormi FC Qormi FC 22 15 60 7
TEMPORADA 2019/2020
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Marsa FC Marsa FC 19 52 26 40
2 Marsaxlokk FC Marsaxlokk 18 42 14 38
3 San Gwann San Gwann 19 35 15 38
4 Mgarr United FC Mgarr United 18 29 18 32
5 Rabat Ajax Rabat Ajax 18 27 25 31
6 Melita Melita 19 29 21 28
7 Zurrieq FC Zurrieq FC 19 26 18 28
8 Mellieha Mellieha 18 16 31 21
9 Zabbar St. Patrick Zabbar 18 13 21 20
10 Kalkara Kalkara 19 28 44 20
11 Birzebbuga St. Peters FC Birzebbuga 18 17 44 16
12 Xghajra Tornados Xghajra 19 22 38 13
13 Luqa St. Andrew's Luqa 18 13 34 9
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
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Qormi FC Qormi FC 26 49 23 59
2 Pieta Hotspurs Pieta 26 58 29 55
3 Zejtun Corinthians FC Zejtun 26 53 31 48
4 Zebbug Rangers Zebbug 26 46 29 47
5 Mqabba FC Mqabba FC 26 48 28 46
6 San Gwann San Gwann 26 46 38 42
7 Vittoriosa Stars Vittoriosa 26 41 44 35
8 Pembroke Athleta FC Pembroke 26 45 32 31
9 Qrendi Qrendi 26 33 40 29
10 Sirens Sirens 26 40 49 28
11 Marsa FC Marsa FC 26 40 51 28
12 Zabbar St. Patrick Zabbar 26 35 55 23
13 Melita Melita 26 27 53 19
14 Rabat Ajax Rabat Ajax 26 19 78 5
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
TERCERA MALTA
Equipo PJ GF GC Puntos
1 San Gwann San Gwann 26 59 16 59
2 Hamrun Spartans Hamrun 26 65 22 56
3 Senglea Athletic Senglea 26 71 24 55
4 Gharghur Gharghur 26 41 31 44
5 Zabbar St. Patrick Zabbar 26 47 32 43
6 Zejtun Corinthians FC Zejtun 26 30 26 43
7 Siggiewi Siggiewi 26 45 45 39
8 Mellieha Mellieha 26 30 35 38
9 Sirens Sirens 26 45 44 35
10 Swieqi United Swieqi 26 35 40 33
11 Marsa FC Marsa FC 26 36 47 28
12 Dingli Swallows Dingli 26 25 52 19
13 Ghaxaq Ghaxaq 26 17 57 15
14 Xghajra Tornados Xghajra 26 15 90 5
TEMPORADA 2013/2014
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Mqabba FC Mqabba FC 26 48 26 52
2 Fgura United FC Fgura United 26 36 15 49
3 Pembroke Athleta FC Pembroke 26 46 32 49
4 Zabbar St. Patrick Zabbar 26 45 20 46
5 San Gwann San Gwann 26 52 37 46
6 Gharghur Gharghur 26 46 38 39
7 Mellieha Mellieha 26 32 26 37
8 Senglea Athletic Senglea 26 45 35 33
9 Marsa FC Marsa FC 26 37 49 31
10 Dingli Swallows Dingli 26 35 34 29
11 Siggiewi Siggiewi 26 36 56 28
12 Marsaskala Marsaskala 26 28 46 27
13 Kirkop United Kirkop 26 24 57 20
14 Mdina Knights Mdina 26 27 66 10
TEMPORADA 2012/2013
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Zebbug Rangers Zebbug 26 66 25 62
2 Msida St Joseph Msida Joseph 26 51 29 52
3 Zurrieq FC Zurrieq FC 26 43 26 50
4 St. Georges FC Georges 26 51 25 49
5 San Gwann San Gwann 26 49 34 44
6 Fgura United FC Fgura United 26 49 39 41
7 Pembroke Athleta FC Pembroke 26 42 30 37
8 Siggiewi Siggiewi 26 40 48 29
9 Mellieha Mellieha 26 28 44 28
10 Kirkop United Kirkop 26 26 43 27
11 Zabbar St. Patrick Zabbar 26 26 43 26
12 Gharghur Gharghur 26 33 49 22
13 Mgarr United FC Mgarr United 26 25 55 17
14 St. Venera St. Venera 26 34 73 17
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
TEMPORADA 2010/2011
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Zejtun Corinthians FC Zejtun 22 42 11 52
2 Rabat Ajax Rabat Ajax 22 45 12 41
3 Naxxar Lions FC Naxxar Lions 22 43 26 40
4 Birzebbuga St. Peters FC Birzebbuga 22 31 28 37
5 Mellieha Mellieha 22 30 20 36
6 Zabbar St. Patrick Zabbar 22 31 32 36
7 San Gwann San Gwann 22 33 40 31
8 Zebbug Rangers Zebbug 22 30 40 27
9 Zurrieq FC Zurrieq FC 22 27 41 23
10 Senglea Athletic Senglea 22 32 42 19
11 Gzira United Gzira United 22 33 51 18
12 Mgarr United FC Mgarr United 22 16 50 13
TEMPORADA 2009/2010
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Marsaxlokk FC Marsaxlokk 18 42 14 41
2 Vittoriosa Stars Vittoriosa 18 28 13 36
3 Balzan FC Balzan FC 18 26 18 31
4 St. Georges FC Georges 18 28 32 29
5 Mosta Mosta 18 31 28 27
6 Mqabba FC Mqabba FC 18 30 30 21
7 Melita Melita 18 21 31 19
8 Pieta Hotspurs Pieta 18 14 25 17
9 Zabbar St. Patrick Zabbar 18 14 34 17
10 San Gwann San Gwann 18 21 30 11
TEMPORADA 2008/2009
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Dingli Swallows Dingli 18 35 18 34
2 Vittoriosa Stars Vittoriosa 18 34 21 34
3 Pieta Hotspurs Pieta 18 36 25 33
4 St. Georges FC Georges 18 34 32 27
5 Zabbar St. Patrick Zabbar 18 24 24 27
6 Mqabba FC Mqabba FC 18 28 24 24
7 Mosta Mosta 18 20 22 22
8 San Gwann San Gwann 18 31 38 22
9 Rabat Ajax Rabat Ajax 18 20 36 17
10 Senglea Athletic Senglea 18 18 40 8
TEMPORADA 2006/2007
SEGUNDA MALTA
Equipo PJ GF GC Puntos
1 Hamrun Spartans Hamrun 18 34 11 39
2 Mqabba FC Mqabba FC 18 33 25 34
3 Tarxien Rainbows Tarxien 18 30 25 28
4 Zabbar St. Patrick Zabbar 18 31 23 27
5 Senglea Athletic Senglea 18 27 22 27
6 Qormi FC Qormi FC 18 32 26 25
7 Vittoriosa Stars Vittoriosa 18 27 27 22
8 Mosta Mosta 18 26 32 22
9 San Gwann San Gwann 18 20 39 11
10 Naxxar Lions FC Naxxar Lions 18 20 50 9

  USO DE MEMORIA  
6,589,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1274
Total Execution Time  0.1286
  CADENA URL  
/historico/Sam-Gwann
  GET DATOS  
$_GET['/historico/Sam-Gwann']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0029  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 = 'Sam-Gwann' 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.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=61353 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=61353 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61353 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1611 AND type_rel = 3
0.0022  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 = '61353' AND l.year = 2024 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 = '61353' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=61353 AND l.year in (2023,2024,2025) 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 (72502,70908,70367) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 70908 AND teamId = 61353
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72502 AND teamId = 61353
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 70367 AND teamId = 61353
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 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 = 72502 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '61353' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61353' and rp.type = 4
0.0019  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 = '61353' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 = 72502 WHERE rp.league_id = 72502 AND rp.teamId = 61353 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.0019  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 = 72502 WHERE rp.league_id = 72502 AND rp.teamId = 61353 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 72502 WHERE rp.league_id = 72502 AND rp.teamId = 61353 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 61353 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72502 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.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 `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 = 68504 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 70908 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `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 = 63551 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.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 `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 = 57799 AND t.round = 24 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 = 51031 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.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 = 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.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 `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 = 38895 AND t.round = 26 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 `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.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 `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.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 `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 = 9433 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 `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 = 16093 AND t.round = 26 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 = 16094 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 `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
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 `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 = 16096 AND t.round = 33 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 `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 = 16035 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 `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 = 16036 AND t.round = 18 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 `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 = 16038 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC