4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Marconi Stallions
TEMPORADA 2023/2024
SEGUNDA AUSTRALIA GRUPO 3
Equipo PJ GF GC Puntos
1 Western Sydney Wanderers II Western 13 43 22 30
2 Rockdale City Suns Rockdale 13 33 17 29
3 APIA Leichhardt Tigers APIA 13 42 20 28
4 Marconi Stallions Marconi 13 29 14 28
5 Sydney United Sydney 13 27 21 26
6 Blacktown City Demons Blacktown 13 34 19 25
7 St George City FA George City 13 18 18 23
8 Wollongong Wolves Wollongong 13 28 20 20
9 Sydney Olympic Sydney 13 24 20 16
10 St. George Saints George 13 17 26 16
11 Manly United Manly United 13 15 27 12
12 Hills Brumbies Hills 13 16 31 12
13 Nws Spirit Nws Spirit 13 15 25 9
14 Sutherland Sharks Sutherland 13 10 29 8
15 Sydney Sub 21 Sydney 13 15 38 8
16 Central Coast II Central 13 18 37 7
TEMPORADA 2022/2023
SEGUNDA AUSTRALIA GRUPO 4
Equipo PJ GF GC Puntos
1 APIA Leichhardt Tigers APIA 30 64 35 65
2 Rockdale City Suns Rockdale 30 60 45 59
3 Blacktown City Demons Blacktown 30 58 32 57
4 Marconi Stallions Marconi 30 64 35 56
5 St George City FA George City 30 62 40 51
6 Sydney Sub 21 Sydney 30 49 52 46
7 Wollongong Wolves Wollongong 30 57 43 43
8 Manly United Manly United 30 41 43 42
9 Sydney Olympic Sydney 30 51 53 39
10 Sydney United Sydney 30 42 48 39
11 Nws Spirit Nws Spirit 30 40 53 39
12 Central Coast II Central 30 42 57 33
13 Western Sydney Wanderers II Western 30 52 61 31
14 Sutherland Sharks Sutherland 30 21 35 31
15 Mt Druitt Town Druitt Town 30 31 61 23
16 Bulls Academy Bulls 30 24 65 15
TEMPORADA 2021/2022
SEGUNDA AUSTRALIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sydney Olympic Sydney 22 40 27 41
2 Manly United Manly United 22 36 24 41
3 Blacktown City Demons Blacktown 22 43 25 40
4 Marconi Stallions Marconi 22 43 31 40
5 APIA Leichhardt Tigers APIA 22 41 33 35
6 Rockdale City Suns Rockdale 22 39 36 35
7 Sydney Sub 21 Sydney 22 53 45 32
8 Sydney United Sydney 22 32 42 29
9 Wollongong Wolves Wollongong 22 37 42 20
10 Mt Druitt Town Druitt Town 22 37 52 19
11 Northbridge Bulls Northbridge 22 32 57 18
12 Sutherland Sharks Sutherland 22 28 47 13
TEMPORADA 2020/2021
SEGUNDA AUSTRALIA GRUPO 4
Equipo PJ GF GC Puntos
1 Blacktown City Demons Blacktown 17 36 17 36
2 Sydney United Sydney 17 31 17 32
3 Rockdale City Suns Rockdale 17 28 22 27
4 Manly United Manly United 17 24 23 27
5 Sydney Olympic Sydney 17 22 19 24
6 Mt Druitt Town Druitt Town 17 21 25 23
7 Wollongong Wolves Wollongong 17 23 33 22
8 APIA Leichhardt Tigers APIA 17 20 21 21
9 Marconi Stallions Marconi 17 24 25 19
10 Northbridge Bulls Northbridge 17 32 31 16
11 Sutherland Sharks Sutherland 17 19 32 14
12 Sydney Sub 21 Sydney 17 29 44 14
TEMPORADA 2019/2020
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 Rockdale City Suns Rockdale 11 20 9 24
2 Wollongong Wolves Wollongong 11 24 14 24
3 Sydney United Sydney 11 26 20 22
4 Sydney Olympic Sydney 11 17 10 21
5 Sydney Sub 21 Sydney 11 26 19 19
6 Blacktown City Demons Blacktown 11 19 15 15
7 Marconi Stallions Marconi 11 14 14 14
8 Manly United Manly United 11 14 18 12
9 Northbridge Bulls Northbridge 11 11 18 10
10 Mt Druitt Town Druitt Town 11 11 22 9
11 Western Sydney Wanderers II Western 11 14 22 8
12 APIA Leichhardt Tigers APIA 11 12 27 7
TEMPORADA 2018/2019
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 Wollongong Wolves Wollongong 22 52 17 51
2 APIA Leichhardt Tigers APIA 22 42 28 42
3 Blacktown City Demons Blacktown 22 31 24 38
4 Sydney United Sydney 22 31 32 33
5 Marconi Stallions Marconi 22 42 30 32
6 Mt Druitt Town Druitt Town 21 41 41 29
7 Sydney Olympic Sydney 21 29 31 29
8 Sutherland Sharks Sutherland 22 36 33 28
9 Manly United Manly United 22 26 34 28
10 Rockdale City Suns Rockdale 22 28 44 26
11 Sydney Sub 21 Sydney 22 33 52 21
12 Hakoah Sydney Hakoah 22 12 37 11
TEMPORADA 2017/2018
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 Sydney Olympic Sydney 22 40 19 48
2 APIA Leichhardt Tigers APIA 22 62 28 45
3 Sydney United Sydney 22 36 29 38
4 Blacktown City Demons Blacktown 21 26 19 33
5 Rockdale City Suns Rockdale 22 39 43 31
6 Marconi Stallions Marconi 22 30 34 30
7 Hakoah Sydney Hakoah 22 33 32 28
8 Manly United Manly United 22 33 32 28
9 Wollongong Wolves Wollongong 22 23 36 27
10 Sutherland Sharks Sutherland 22 30 39 23
11 Bonnyrigg White Eagles Bonnyrigg 21 29 50 21
12 Sydney Sub 21 Sydney 22 27 47 16
TEMPORADA 2014/2015
SEGUNDA AUSTRALIA GRUPO 8
Equipo PJ GF GC Puntos
1 Blacktown City Demons Blacktown 22 54 24 48
2 APIA Leichhardt Tigers APIA 22 56 31 45
3 Bonnyrigg White Eagles Bonnyrigg 22 49 35 43
4 Sydney Olympic Sydney 22 44 32 39
5 South Coast Wolves South Coast 22 31 36 32
6 Rockdale City Suns Rockdale 22 31 33 30
7 Blacktown Spartans Blacktown 22 41 50 30
8 Sydney United Sydney 22 39 45 29
9 Manly United Manly United 22 39 38 27
10 Sutherland Sharks Sutherland 22 36 42 24
11 Parramatta Eagles Parramatta 22 22 35 20
12 Marconi Stallions Marconi 22 14 55 7
TEMPORADA 2013/2014
SEGUNDA AUSTRALIA GRUPO 8
Equipo PJ GF GC Puntos
1 Bonnyrigg White Eagles Bonnyrigg 22 41 21 47
2 Blacktown Spartans Blacktown 22 55 34 46
3 Blacktown City Demons Blacktown 22 48 22 44
4 Sydney Olympic Sydney 22 35 27 35
5 Rockdale City Suns Rockdale 22 26 24 34
6 Sutherland Sharks Sutherland 22 43 42 30
7 South Coast Wolves South Coast 22 32 32 27
8 Marconi Stallions Marconi 22 28 36 25
9 Sydney United Sydney 22 25 29 24
10 Manly United Manly United 22 31 46 24
11 APIA Leichhardt Tigers APIA 22 31 51 20
12 St. George FC George 22 18 49 16
TEMPORADA 2012/2013
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 Sydney United Sydney 22 47 27 48
2 Sutherland Sharks Sutherland 22 47 26 44
3 Bonnyrigg White Eagles Bonnyrigg 22 44 30 43
4 Rockdale City Suns Rockdale 22 37 21 39
5 Marconi Stallions Marconi 22 29 26 37
6 Blacktown City Demons Blacktown 22 45 35 35
7 Sydney Olympic Sydney 22 30 29 29
8 Manly United Manly United 22 31 37 25
9 Blacktown Spartans Blacktown 22 28 31 23
10 Mariners Academy Mariners 22 30 62 15
11 APIA Leichhardt Tigers APIA 22 29 48 14
12 South Coast Wolves South Coast 22 28 53 14
TEMPORADA 2011/2012
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bonnyrigg White Eagles Bonnyrigg 22 50 17 53
2 Sydney Olympic Sydney 22 37 26 38
3 Marconi Stallions Marconi 22 32 28 38
4 South Coast Wolves South Coast 22 41 39 37
5 Blacktown City Demons Blacktown 22 40 34 32
6 APIA Leichhardt Tigers APIA 22 32 31 31
7 Rockdale City Suns Rockdale 22 30 33 30
8 Sutherland Sharks Sutherland 22 34 36 29
9 Sydney United Sydney 22 27 38 25
10 Manly United Manly United 22 26 33 23
11 Blacktown Spartans Blacktown 22 26 44 21
12 Parramatta Eagles Parramatta 22 19 35 17
TEMPORADA 2010/2011
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sydney Olympic Sydney 22 40 26 43
2 Sydney United Sydney 22 38 23 39
3 Sutherland Sharks Sutherland 22 31 28 38
4 Blacktown City Demons Blacktown 22 35 22 37
5 Bonnyrigg White Eagles Bonnyrigg 22 33 24 33
6 Manly United Manly United 22 33 37 31
7 South Coast Wolves South Coast 22 35 36 30
8 Rockdale City Suns Rockdale 22 23 29 28
9 Marconi Stallions Marconi 22 25 24 24
10 APIA Leichhardt Tigers APIA 22 24 36 23
11 Bankstown City Lions Bankstown 22 29 44 22
12 Parramatta Eagles Parramatta 22 19 36 16
TEMPORADA 2009/2010
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bonnyrigg White Eagles Bonnyrigg 22 45 20 45
2 Blacktown City Demons Blacktown 22 42 27 40
3 Sydney United Sydney 22 39 26 39
4 APIA Leichhardt Tigers APIA 22 39 37 39
5 Marconi Stallions Marconi 22 26 26 36
6 Sutherland Sharks Sutherland 22 36 29 31
7 Rockdale City Suns Rockdale 22 23 23 30
8 Bankstown City Lions Bankstown 22 37 41 26
9 Manly United Manly United 22 24 31 25
10 South Coast Wolves South Coast 22 32 39 22
11 Sydney Olympic Sydney 22 29 40 21
12 Bankstown Berries Bankstown 22 17 50 12
TEMPORADA 2008/2009
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sydney United Sydney 22 42 22 46
2 Marconi Stallions Marconi 22 44 22 39
3 Sutherland Sharks Sutherland 22 46 26 38
4 Bankstown City Lions Bankstown 22 39 31 38
5 Manly United Manly United 22 33 22 37
6 Bankstown Berries Bankstown 22 37 37 30
7 Blacktown City Demons Blacktown 22 29 31 28
8 Sydney Olympic Sydney 22 37 43 28
9 Bonnyrigg White Eagles Bonnyrigg 22 28 39 26
10 Penrith Nepean United Penrith 22 19 31 23
11 APIA Leichhardt Tigers APIA 22 30 38 22
12 Wollongong Wolves Wollongong 22 20 62 5
TEMPORADA 2007/2008
SEGUNDA AUSTRALIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sutherland Sharks Sutherland 22 48 19 44
2 Wollongong Wolves Wollongong 22 39 19 44
3 Sydney Olympic Sydney 22 38 23 41
4 Manly United Manly United 22 42 21 39
5 Sydney United Sydney 22 29 21 34
6 APIA Leichhardt Tigers APIA 22 41 35 34
7 Bankstown City Lions Bankstown 22 27 27 27
8 Bankstown Berries Bankstown 22 30 41 24
9 Marconi Stallions Marconi 22 29 41 19
10 Macarthur Rams SC Macarthur 22 16 41 19
11 Penrith Nepean United Penrith 22 25 50 17
12 Blacktown City Demons Blacktown 22 14 40 16
TEMPORADA 2006/2007
SEGUNDA AUSTRALIA GRUPO 7
Equipo PJ GF GC Puntos
1 Blacktown City Demons Blacktown 4 9 6 9
2 Manly United Manly United 3 5 5 4
3 Bankstown City Lions Bankstown 3 4 5 3
4 Marconi Stallions Marconi 2 1 3 1
TEMPORADA 2003/2004
LIGA AUSTRALIANA
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 56 22 57
2 Parramatta Power Parramatta 24 58 30 51
3 Adelaide United Adelaide 24 28 25 40
4 Marconi Stallions Marconi 24 29 25 38
5 South Melbourne South 24 39 21 37
6 Brisbane Strikers Brisbane 24 28 33 32
7 Spirit FC Spirit FC 24 31 33 30
8 Sydney Olympic Sydney 24 26 31 29
9 South Coast Wolves South Coast 24 34 41 29
10 Sydney United Sydney 24 18 25 29
11 Newcastle Jets Newcastle 24 18 33 24
12 FC Melbourne Knights Melbourne 24 21 41 23
13 NZ Knights NZ Knights 24 25 51 15
TEMPORADA 2002/2003
LIGA AUSTRALIANA GRUPO 1
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 50 19 53
2 Sydney Olympic Sydney 24 51 28 51
3 Parramatta Power Parramatta 24 48 29 37
4 Newcastle Jets Newcastle 24 37 25 37
5 Adelaide City Adelaide 24 40 34 37
6 Spirit FC Spirit FC 24 37 44 36
7 South Melbourne South 24 36 37 35
8 Sydney United Sydney 24 23 31 27
9 FC Melbourne Knights Melbourne 24 38 52 27
10 Brisbane Strikers Brisbane 24 38 45 26
11 NZ Knights NZ Knights 24 26 45 24
12 Marconi Stallions Marconi 24 25 42 23
13 South Coast Wolves South Coast 24 25 43 23
TEMPORADA 2001/2002
LIGA AUSTRALIANA
Equipo PJ GF GC Puntos
1 Perth Glory Perth Glory 24 52 23 55
2 Newcastle Jets Newcastle 24 33 21 42
3 Sydney Olympic Sydney 24 37 24 40
4 Brisbane Strikers Brisbane 24 40 33 37
5 South Melbourne South 24 30 22 36
6 FC Melbourne Knights Melbourne 24 41 40 36
7 Parramatta Power Parramatta 24 34 30 34
8 Spirit FC Spirit FC 24 36 39 34
9 Marconi Stallions Marconi 24 32 36 30
10 South Coast Wolves South Coast 24 28 43 25
11 Sydney United Sydney 24 27 37 24
12 Adelaide City Adelaide 24 27 39 20
13 NZ Knights NZ Knights 24 28 58 14

  USO DE MEMORIA  
6,591,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1513
Total Execution Time  0.1525
  CADENA URL  
/historico/Marconi-Stallions
  GET DATOS  
$_GET['/historico/Marconi-Stallions']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0038  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 = 'Marconi-Stallions' 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.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=15266 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=15266 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74842
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15266 AND type_rel = 2
0.0045  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 = '15266' ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '15266' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '15266' 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 = 74842 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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=15266 AND l.year in (2023,2024,2025) 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 (74842) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74842 AND teamId = 15266
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 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 = 74842 AND t.round = 13 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '15266' 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 = '15266' and rp.type = 4
0.0022  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 = '15266' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 74842 WHERE rp.league_id = 74842 AND rp.teamId = 15266 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.0026  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 = 74842 WHERE rp.league_id = 74842 AND rp.teamId = 15266 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 74842 WHERE rp.league_id = 74842 AND rp.teamId = 15266 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 15266 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74842 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 70871 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 66272 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.0041  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 = 60620 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.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 `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 = 53841 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.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 `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 = 48426 AND t.round = 22 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 `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 = 42072 AND t.round = 22 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 `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 = 4513 AND t.round = 22 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 `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 = 10835 AND t.round = 22 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 `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 = 3293 AND t.round = 22 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 `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 = 28254 AND t.round = 22 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 `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 = 28263 AND t.round = 22 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 `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 = 28270 AND t.round = 22 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 `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 = 28276 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 28281 AND t.round = 22 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 `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 = 26752 AND t.round = 18 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 `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 = 26764 AND t.round = 3 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 `tables2004` 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 = 9956 AND t.round = 26 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 `tables2003` 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 = 9957 AND t.round = 26 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 `tables2002` 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 = 9959 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC