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

Marsaxlokk FC

Entrenador: Winston Muscat

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA MALTA
Equipo PJ GF GC Puntos
1 Hamrun Spartans Hamrun 25 60 15 61
2 Floriana FC Floriana FC 25 52 16 57
3 Sliema Wanderers Sliema 25 31 12 47
4 Marsaxlokk FC Marsaxlokk 25 40 22 43
5 Birkirkara Birkirkara 25 26 25 35
6 Naxxar Lions FC Naxxar Lions 25 32 33 35
7 Hibernians Hibernians 25 28 27 34
8 Balzan FC Balzan FC 25 25 28 31
9 Gzira United Gzira United 25 35 32 30
10 Santa Lucía Santa Lucía 25 23 39 29
11 Mosta Mosta 25 17 32 28
12 Valletta FC Valletta FC 25 21 29 24
13 Sirens Sirens 25 17 47 16
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
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
TERCERA MALTA
Equipo PJ GF GC Puntos
1 Fgura United FC Fgura United 24 44 18 53
2 St. Georges FC Georges 24 40 16 53
3 Mgarr United FC Mgarr United 24 45 22 51
4 Marsaxlokk FC Marsaxlokk 24 40 23 47
5 Birzebbuga St. Peters FC Birzebbuga 24 40 26 43
6 Melita Melita 24 40 27 39
7 Rabat Ajax Rabat Ajax 24 37 26 37
8 Kalkara Kalkara 24 30 46 23
9 Mellieha Mellieha 24 21 36 22
10 Luqa St. Andrew's Luqa 24 23 48 21
11 Zabbar St. Patrick Zabbar 24 16 31 20
12 St. Venera St. Venera 24 17 47 16
13 Siggiewi Siggiewi 24 14 41 13
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 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
LIGA MALTA GRUPO 1
Equipo PJ GF GC Puntos
1 Valletta FC Valletta FC 22 52 17 55
2 Hibernians Hibernians 22 55 16 51
3 Floriana FC Floriana FC 22 34 19 42
4 Sliema Wanderers Sliema 22 34 24 35
5 Birkirkara Birkirkara 22 34 29 35
6 Balzan FC Balzan FC 22 28 34 31
7 Qormi FC Qormi FC 22 36 37 29
8 Mosta Mosta 22 23 35 23
9 Mqabba FC Mqabba FC 22 25 43 20
10 Hamrun Spartans Hamrun 22 31 52 19
11 Tarxien Rainbows Tarxien 22 26 44 18
12 Marsaxlokk FC Marsaxlokk 22 25 53 11
TEMPORADA 2010/2011
LIGA MALTA GRUPO 2
Equipo PJ GF GC Puntos
1 Valletta FC Valletta FC 10 17 6 42
2 Floriana FC Floriana FC 10 21 12 34
3 Birkirkara Birkirkara 10 17 15 29
4 Marsaxlokk FC Marsaxlokk 10 20 18 26
5 Tarxien Rainbows Tarxien 10 16 23 23
6 Hamrun Spartans Hamrun 10 13 30 16
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
LIGA MALTA GRUPO 2
Equipo PJ GF GC Puntos
1 Hibernians Hibernians 10 24 6 42
2 Valletta FC Valletta FC 10 19 7 40
3 Birkirkara Birkirkara 10 12 17 27
4 Marsaxlokk FC Marsaxlokk 10 18 19 25
5 Sliema Wanderers Sliema 10 9 17 25
6 Floriana FC Floriana FC 10 7 23 16
TEMPORADA 2007/2008
LIGA MALTA GRUPO 1
Equipo PJ GF GC Puntos
1 Valletta FC Valletta FC 18 40 16 36
2 Marsaxlokk FC Marsaxlokk 18 35 26 33
3 Sliema Wanderers Sliema 18 31 18 32
4 Floriana FC Floriana FC 18 33 28 28
5 Birkirkara Birkirkara 18 27 18 27
6 Hamrun Spartans Hamrun 18 30 29 27
7 Hibernians Hibernians 18 22 19 25
8 Msida St Joseph Msida Joseph 18 25 35 21
9 Pieta Hotspurs Pieta 18 21 40 15
10 Mqabba FC Mqabba FC 18 15 50 6
TEMPORADA 2006/2007
LIGA MALTA GRUPO 2
Equipo PJ GF GC Puntos
1 Marsaxlokk FC Marsaxlokk 10 29 13 47
2 Sliema Wanderers Sliema 10 17 13 35
3 Birkirkara Birkirkara 10 16 17 34
4 Valletta FC Valletta FC 10 14 13 30
5 Floriana FC Floriana FC 6 13 10 22
6 Hibernians Hibernians 10 14 19 21
7 Msida St Joseph Msida Joseph 10 8 23 19
8 Pieta Hotspurs Pieta 6 13 9 18
9 Marsa FC Marsa FC 6 8 8 10
10 St. Georges FC Georges 6 12 19 10

  USO DE MEMORIA  
6,445,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6146
Total Execution Time  0.6158
  CADENA URL  
/historico/Marsaxlokk-Fc
  GET DATOS  
$_GET['/historico/Marsaxlokk-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0292  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 = 72280
0.0151  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 = 74508
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1656 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=421 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 421 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 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 (1303320,1294805,1234413,961278,940326) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '1656' 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.0146  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.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 = '1656' 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 = '1656' 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 = '1656' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 1656 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 26 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 `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.0147  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.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 = 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.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 `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.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 `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 = 44315 AND t.round = 26 ORDER BY team.conference 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 `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.0147  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.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 `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.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 `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 = 16057 AND t.round = 10 ORDER BY team.conference 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 `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 = 8611 AND t.round = 22 ORDER BY team.conference 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 `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 = 16044 AND t.round = 18 ORDER BY team.conference 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 `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 = 16045 AND t.round = 10 ORDER BY team.conference 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 `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.0147  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 = 16048 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 16049 AND t.round = 10 ORDER BY team.conference 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 `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 = 16051 AND t.round = 7 ORDER BY team.conference 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 `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 = 16050 AND t.round = 18 ORDER BY team.conference 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 `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 = 16052 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 16053 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC