4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Peninsula Power
TEMPORADA 2023/2024
SEGUNDA AUSTRALIA GRUPO 6
Equipo PJ GF GC Puntos
1 Gold Coast Knights Gold Coast. 9 25 7 24
2 Wynnum Wolves Wynnum 9 18 23 19
3 Queensland Lions FC Queensland 9 26 14 18
4 Moreton City Excelsior Moreton City 8 21 14 16
5 Gold Coast United Gold Coast. 8 18 9 14
6 Peninsula Power Peninsula 8 13 11 13
7 Brisbane Roar Sub 21 Brisbane 9 17 15 12
8 Brisbane City Brisbane 9 11 24 9
9 Olympic FC Olympic FC 8 11 12 8
10 SC Wanderers Wanderers 9 14 21 7
11 Rochedale Rovers Rochedale 9 9 22 5
12 Redlands United Redlands 9 8 19 3
TEMPORADA 2022/2023
SEGUNDA AUSTRALIA GRUPO 6
Equipo PJ GF GC Puntos
1 Gold Coast Knights Gold Coast. 22 45 21 48
2 Moreton City Excelsior Moreton City 22 45 27 38
3 Gold Coast United Gold Coast. 22 27 23 36
4 Brisbane City Brisbane 22 44 30 35
5 Queensland Lions FC Queensland 22 37 29 34
6 Peninsula Power Peninsula 22 34 30 34
7 Rochedale Rovers Rochedale 22 33 31 30
8 SC Wanderers Wanderers 22 26 34 29
9 Brisbane Roar Sub 21 Brisbane 22 29 35 27
10 Redlands United Redlands 22 32 33 26
11 Olympic FC Olympic FC 22 28 39 19
12 Eastern Suburbs Brisbane Eastern 22 22 70 9
TEMPORADA 2021/2022
SEGUNDA AUSTRALIA GRUPO 4
Equipo PJ GF GC Puntos
1 Queensland Lions FC Queensland 22 74 32 51
2 Gold Coast Knights Gold Coast. 22 44 27 39
3 Peninsula Power Peninsula 22 50 35 39
4 Olympic FC Olympic FC 22 54 37 38
5 Brisbane City Brisbane 22 49 40 33
6 Gold Coast United Gold Coast. 22 37 34 32
7 Eastern Suburbs Brisbane Eastern 22 41 49 31
8 SC Wanderers Wanderers 22 37 38 30
9 Moreton City Excelsior Moreton City 22 49 38 28
10 Logan Lightning Logan 22 32 52 26
11 Brisbane Roar Sub 21 Brisbane 22 29 58 16
12 Capalaba Capalaba 22 24 80 5
TEMPORADA 2020/2021
SEGUNDA AUSTRALIA GRUPO 6
Equipo PJ GF GC Puntos
1 Peninsula Power Peninsula 26 72 25 60
2 Brisbane Roar Sub 21 Brisbane 26 82 31 55
3 Olympic FC Olympic FC 26 52 19 55
4 Queensland Lions FC Queensland 26 76 34 53
5 SC Wanderers Wanderers 26 58 42 51
6 Gold Coast Knights Gold Coast. 26 53 40 46
7 Moreton City Excelsior Moreton City 26 75 57 45
8 Gold Coast United Gold Coast. 26 47 39 37
9 Eastern Suburbs Brisbane Eastern 26 37 58 32
10 Logan Lightning Logan 26 44 54 29
11 Capalaba Capalaba 26 33 70 24
12 Redlands United Redlands 26 32 67 18
13 Brisbane Strikers Brisbane 26 21 81 8
14 Magpies Crusaders FC Magpies 26 20 85 8
TEMPORADA 2019/2020
SEGUNDA AUSTRALIA GRUPO 4
Equipo PJ GF GC Puntos
1 Peninsula Power Peninsula 24 61 25 60
2 Gold Coast Knights Gold Coast. 24 57 27 51
3 Olympic FC Olympic FC 23 50 21 50
4 Queensland Lions FC Queensland 24 64 26 46
5 Moreton City Excelsior Moreton City 25 48 57 33
6 Brisbane Roar Sub 21 Brisbane 24 42 41 30
7 Brisbane Strikers Brisbane 24 33 40 30
8 Eastern Suburbs Brisbane Eastern 24 46 50 29
9 Gold Coast United Gold Coast. 24 38 47 25
10 Redlands United Redlands 24 32 64 23
11 SC Wanderers Wanderers 22 38 51 22
12 Brisbane City Brisbane 24 38 51 21
13 Capalaba Capalaba 23 33 70 19
14 Magpies Crusaders FC Magpies 5 5 15 2
TEMPORADA 2018/2019
SEGUNDA AUSTRALIA GRUPO 4
Equipo PJ GF GC Puntos
1 Peninsula Power Peninsula 26 76 33 66
2 Queensland Lions FC Queensland 25 74 17 65
3 Gold Coast Knights Gold Coast. 26 71 22 64
4 Olympic FC Olympic FC 27 81 39 54
5 Brisbane Strikers Brisbane 27 79 46 46
6 Brisbane City Brisbane 27 67 47 45
7 Brisbane Roar Sub 21 Brisbane 26 57 46 38
8 Eastern Suburbs Brisbane Eastern 28 67 63 38
9 Gold Coast United Gold Coast. 27 43 48 37
10 Moreton City Excelsior Moreton City 28 43 50 31
11 Redlands United Redlands 27 39 73 28
12 Magpies Crusaders FC Magpies 28 42 103 26
13 Western Pride Western 26 37 62 25
14 SWQ Thunder SWQ Thunder 28 49 104 18
15 SC Wanderers Wanderers 28 22 94 6
TEMPORADA 2016/2017
BRISBANE
Equipo PJ GF GC Puntos
1 Rochedale Rovers Rochedale 22 50 28 45
2 Peninsula Power Peninsula 22 47 31 43
3 Queensland Lions FC Queensland 22 65 29 42
4 Mitchelton Mitchelton 22 47 41 32
5 Albany Creek Albany Creek 22 42 38 32
6 Eastern Suburbs Brisbane Eastern 22 41 31 31
7 Holland Park Hawks Holland Park 22 56 45 30
8 Souths United Souths 22 45 41 29
9 Ipswich Knights Ipswich 22 27 54 27
10 Grange Thistle Grange 22 37 57 22
11 Logan Lightning Logan 22 38 57 20
12 Capalaba Capalaba 22 32 75 15
TEMPORADA 2015/2016
BRISBANE
Equipo PJ GF GC Puntos
1 Queensland Lions FC Queensland 22 53 23 49
2 Mitchelton Mitchelton 22 46 34 41
3 Holland Park Hawks Holland Park 22 51 34 39
4 Peninsula Power Peninsula 22 44 29 38
5 Rochedale Rovers Rochedale 22 42 27 36
6 Capalaba Capalaba 22 49 42 33
7 Eastern Suburbs Brisbane Eastern 22 43 35 32
8 Albany Creek Albany Creek 22 44 37 32
9 Logan Lightning Logan 22 42 49 29
10 Ipswich Knights Ipswich 22 38 53 21
11 Univ. Queensland Univ. 22 21 55 15
12 North Pine North Pine 22 29 84 11
TEMPORADA 2014/2015
BRISBANE
Equipo PJ GF GC Puntos
1 Queensland Lions FC Queensland 22 53 20 50
2 Eastern Suburbs Brisbane Eastern 22 47 24 46
3 Mitchelton Mitchelton 22 44 26 40
4 Peninsula Power Peninsula 22 44 34 40
5 Rochedale Rovers Rochedale 22 38 31 34
6 Albany Creek Albany Creek 22 42 34 32
7 Logan Lightning Logan 22 40 38 27
8 Ipswich Knights Ipswich 22 31 46 27
9 Wolves Wolves 22 37 46 25
10 Capalaba Capalaba 22 33 37 24
11 Taringa Rovers Taringa 22 22 56 13
12 Univ. Queensland Univ. 22 31 70 9
TEMPORADA 2013/2014
BRISBANE
Equipo PJ GF GC Puntos
1 Wolves Wolves 21 67 16 60
2 Peninsula Power Peninsula 21 44 20 48
3 Queensland Lions FC Queensland 22 61 18 48
4 Eastern Suburbs Brisbane Eastern 21 36 17 38
5 Logan Lightning Logan 22 36 38 33
6 Capalaba Capalaba 22 43 49 30
7 Ipswich Knights Ipswich 22 42 49 29
8 Albany Creek Albany Creek 21 34 54 22
9 Rochedale Rovers Rochedale 21 38 49 21
10 Brisbane Force Brisbane 21 24 49 15
11 North Star North Star 21 29 75 13
12 Univ. Queensland Univ. 21 21 41 11
TEMPORADA 2012/2013
BRISBANE
Equipo PJ GF GC Puntos
1 Queensland Lions FC Queensland 22 68 21 56
2 Wolves Wolves 22 81 26 50
3 Peninsula Power Peninsula 22 63 25 49
4 Rochedale Rovers Rochedale 22 46 31 42
5 Eastern Suburbs Brisbane Eastern 22 48 28 40
6 Logan Lightning Logan 22 45 42 33
7 Capalaba Capalaba 22 46 50 32
8 Ipswich Knights Ipswich 22 28 40 28
9 Albany Creek Albany Creek 22 32 67 21
10 Brisbane Force Brisbane 22 31 71 13
11 North Star North Star 22 24 64 13
12 Univ. Queensland Univ. 22 19 66 8
TEMPORADA 2011/2012
BRISBANE
Equipo PJ GF GC Puntos
1 Redlands United Redlands 26 87 42 61
2 Wolves Wolves 26 75 30 60
3 Peninsula Power Peninsula 26 71 30 56
4 Rochedale Rovers Rochedale 26 78 36 52
5 Queensland Lions FC Queensland 26 66 40 46
6 Eastern Suburbs Brisbane Eastern 26 50 37 42
7 Capalaba Capalaba 26 47 37 42
8 Brisbane City Brisbane 26 69 47 40
9 Olympic FC Olympic FC 26 74 59 40
10 Univ. Queensland Univ. 26 24 66 22
11 Taringa Rovers Taringa 26 38 66 21
12 North Star North Star 26 45 84 20
13 North Pine North Pine 26 32 86 13
14 Souths United Souths 26 23 119 4
TEMPORADA 2010/2011
BRISBANE
Equipo PJ GF GC Puntos
1 Wolves Wolves 26 102 28 67
2 Rochedale Rovers Rochedale 26 72 34 59
3 Olympic FC Olympic FC 26 70 42 49
4 Peninsula Power Peninsula 26 58 34 43
5 Eastern Suburbs Brisbane Eastern 26 51 38 41
6 North Pine North Pine 26 47 41 40
7 Brisbane City Brisbane 26 41 38 40
8 Capalaba Capalaba 26 54 49 37
9 Redlands United Redlands 26 46 50 33
10 Taringa Rovers Taringa 26 41 65 33
11 Univ. Queensland Univ. 26 35 46 30
12 Souths United Souths 26 40 66 26
13 Mount Gravatt Hawks SC Mount 26 28 83 19
14 Pine Hills Pine Hills 26 22 93 3
TEMPORADA 2009/2010
BRISBANE
Equipo PJ GF GC Puntos
1 Rochedale Rovers Rochedale 26 81 25 65
2 Wolves Wolves 26 72 36 50
3 Capalaba Capalaba 26 51 30 50
4 Eastern Suburbs Brisbane Eastern 26 49 34 49
5 Olympic FC Olympic FC 26 61 43 48
6 Peninsula Power Peninsula 26 66 45 42
7 Pine Hills Pine Hills 26 41 56 35
8 Redlands United Redlands 26 59 63 33
9 Souths United Souths 26 42 51 27
10 Brisbane City Brisbane 26 55 66 26
11 Taringa Rovers Taringa 26 54 88 26
12 Mount Gravatt Hawks SC Mount 26 39 80 26
13 Beenleigh Beenleigh 26 46 73 22
14 Pine Rivers United Pine Rivers 26 29 55 17
TEMPORADA 2008/2009
BRISBANE
Equipo PJ GF GC Puntos
1 Rochedale Rovers Rochedale 22 62 30 50
2 Peninsula Power Peninsula 22 64 30 48
3 Wolves Wolves 22 52 21 45
4 Capalaba Capalaba 23 53 37 45
5 Brisbane City Brisbane 22 62 22 43
6 Eastern Suburbs Brisbane Eastern 22 40 35 36
7 Mount Gravatt Hawks SC Mount 22 32 36 30
8 Pine Rivers United Pine Rivers 22 35 43 28
9 Souths United Souths 22 32 44 27
10 Taringa Rovers Taringa 23 41 54 26
11 North Star North Star 22 32 66 20
12 North Pine North Pine 22 24 48 15
13 Mitchelton Mitchelton 22 15 78 1
TEMPORADA 2006/2007
SEGUNDA AUSTRALIA GRUPO 5
Equipo PJ GF GC Puntos
1 Rochedale Rovers Rochedale 22 62 25 52
2 Brisbane Strikers Brisbane 22 49 17 48
3 Gold Coast City Gold Coast. 22 40 28 43
4 Pine Rivers United Pine Rivers 22 37 34 38
5 Taringa Rovers Taringa 22 32 23 35
6 Souths United Souths 22 42 38 29
7 Mitchelton Mitchelton 22 33 38 25
8 Mount Gravatt Hawks SC Mount 22 36 41 24
9 Brisbane City Brisbane 22 25 36 24
10 Peninsula Power Peninsula 22 30 54 18
11 Wolves Wolves 22 18 46 17
12 Ipswich Knights Ipswich 22 18 42 16

  USO DE MEMORIA  
6,255,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7248
Total Execution Time  0.7261
  CADENA URL  
/historico/Peninsula-Power
  GET DATOS  
$_GET['/historico/Peninsula-Power']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0180  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 = 'Peninsula-Power' 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.0148  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=17378 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=17378 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0306  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 = 75152
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17378 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17378 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149  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 (175030) ORDER BY n.cover_points DESC, update_date DESC
0.0156  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 = '17378' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0166  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 = '17378' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 75152 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0169  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=17378 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (75152,72120) 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.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 75152 AND teamId = 17378
0.0166  SELECT count(id) as num_players from rel_players WHERE league_id = 72120 AND teamId = 17378
0.0168  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 = 75152 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 = '17378' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17378' and rp.type = 4
0.0156  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 = '17378' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0175  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 = 75152 WHERE rp.league_id = 75152 AND rp.teamId = 17378 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.0159  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 = 75152 WHERE rp.league_id = 75152 AND rp.teamId = 17378 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 75152 WHERE rp.league_id = 75152 AND rp.teamId = 17378 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 17378 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75152 AND t.round = 10 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 = 70904 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.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 `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 = 66480 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 = 61450 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.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 `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 = 53840 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 `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 = 48425 AND t.round = 30 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 `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 = 37875 AND t.round = 22 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 `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 = 20319 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 15722 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 3575 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 24563 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 = 24569 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 24575 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 `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 = 24583 AND t.round = 26 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 `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 = 24586 AND t.round = 24 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 `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 = 26758 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC