4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fjardabyggd
TEMPORADA 2020/2021
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Thróttur Vogar Thróttur 22 43 22 42
2 KV Reykjavík Reykjavík 22 40 29 41
3 Völsungur Völsungur 22 44 35 40
4 IF Magni IF Magni 22 45 36 37
5 KF Fjallabyggdar Fjallabyggda 22 42 33 35
6 UMF Njardvík Njardvík 22 45 29 32
7 Reynir Reynir 22 49 45 32
8 ÍR Reykjavík Reykjavík 22 40 36 31
9 Haukar Haukar 22 46 41 29
10 Leiknir Fáskrúðsfjörður Leiknir 22 31 45 24
11 Fjardabyggd Fjardabyggd 22 17 62 11
12 Kári Kári 22 27 56 9
TEMPORADA 2019/2020
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Kórdrengir Kórdrengir 20 45 13 46
2 Selfoss Selfoss 20 36 25 43
3 Thróttur Vogar Thróttur 20 39 19 41
4 UMF Njardvík Njardvík 20 39 26 40
5 Haukar Haukar 20 43 28 36
6 KF Fjallabyggdar Fjallabyggda 20 33 39 26
7 Kári Kári 20 33 31 25
8 Fjardabyggd Fjardabyggd 20 30 36 24
9 ÍR Reykjavík Reykjavík 20 31 39 19
10 Völsungur Völsungur 20 25 49 17
11 Vidir Gardur Vidir Gardur 20 24 52 16
12 Dalvík / Reynir Dalvík 20 25 46 11
TEMPORADA 2018/2019
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Leiknir Fáskrúðsfjörður Leiknir 23 47 23 46
2 Vestri Vestri 22 42 26 45
3 Selfoss Selfoss 22 55 26 44
4 KF Vídir KF Vídir 22 40 26 39
5 Thróttur Vogar Thróttur 23 38 37 33
6 Völsungur Völsungur 22 30 34 30
7 ÍR Reykjavík Reykjavík 22 34 35 29
8 Dalvík / Reynir Dalvík 22 30 32 29
9 Fjardabyggd Fjardabyggd 22 40 46 25
10 Kári Kári 22 41 51 24
11 KFG Gardabaer Gardabaer 22 35 56 19
12 Tindastoll Tindastoll 22 22 62 12
TEMPORADA 2017/2018
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Afturelding Afturelding 22 58 27 45
2 IF Grótta IF Grótta 22 54 28 45
3 Vestri Vestri 22 42 17 44
4 Völsungur Völsungur 22 45 31 40
5 Kári Kári 22 46 44 38
6 Thróttur Vogar Thróttur 22 36 31 33
7 Fjardabyggd Fjardabyggd 22 27 32 28
8 Tindastoll Tindastoll 22 28 53 24
9 KF Vídir KF Vídir 22 28 36 23
10 Leiknir Fáskrúðsfjörður Leiknir 22 31 36 22
11 IF Höttur IF Höttur 22 31 49 21
12 Huginn Huginn 22 13 55 6
TEMPORADA 2016/2017
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 UMF Njardvík Njardvík 22 51 29 50
2 Afturelding Afturelding 22 51 36 37
3 KF Vídir KF Vídir 22 51 45 37
4 IF Magni IF Magni 22 51 42 36
5 Huginn Huginn 22 41 28 34
6 Tindastoll Tindastoll 22 47 42 34
7 Völsungur Völsungur 22 55 47 30
8 Fjardabyggd Fjardabyggd 22 28 41 28
9 Vestri Vestri 22 34 35 27
10 IF Höttur IF Höttur 22 39 54 26
11 KV Reykjavík Reykjavík 22 37 57 21
12 Sindri Sindri 22 35 64 9
TEMPORADA 2015/2016
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 KA Akureyri KA Akureyri 22 42 16 51
2 Grindavík Grindavík 22 50 21 42
3 Keflavik Keflavik 22 31 20 35
4 Thór Thór 22 34 38 33
5 Haukar Haukar 22 31 35 31
6 Fram Fram 22 25 29 30
7 Leiknir Reykjavik Leiknir 22 21 28 29
8 Selfoss Selfoss 22 28 25 28
9 HK Kopavogur Kopavogur 22 32 45 22
10 Leiknir Fáskrúðsfjörður Leiknir 22 32 45 21
11 Huginn Huginn 22 20 34 21
12 Fjardabyggd Fjardabyggd 22 26 36 17
TEMPORADA 2014/2015
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Víkingur Ólafsvík Víkingur 22 53 14 54
2 Throttur Throttur 22 45 21 44
3 KA Akureyri KA Akureyri 22 42 22 41
4 Thór Thór 22 40 34 38
5 Grindavík Grindavík 22 41 30 36
6 Haukar Haukar 22 32 28 34
7 Fjardabyggd Fjardabyggd 22 35 37 31
8 HK Kopavogur Kopavogur 22 26 33 31
9 Fram Fram 22 34 45 21
10 Selfoss Selfoss 22 20 38 20
11 IF Grótta IF Grótta 22 10 39 15
12 BI/Bolungarvik BI/Bolungarv 22 22 59 10
TEMPORADA 2013/2014
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Fjardabyggd Fjardabyggd 22 53 20 51
2 IF Grótta IF Grótta 22 49 36 44
3 ÍR Reykjavík Reykjavík 22 41 24 40
4 Huginn Huginn 22 47 37 37
5 Sindri Sindri 22 34 37 30
6 Dalvík / Reynir Dalvík 22 28 33 27
7 KF Fjallabyggdar Fjallabyggda 22 29 39 27
8 UMF Njardvík Njardvík 22 36 42 24
9 Ægir Ægir 22 22 35 24
10 Afturelding Afturelding 22 35 36 22
11 Völsungur Völsungur 22 35 51 22
12 Reynir Reynir 22 30 49 22
TEMPORADA 2012/2013
CUARTA ISLANDIA
Equipo PJ GF GC Puntos
1 Fjardabyggd Fjardabyggd 18 67 14 45
2 Huginn Huginn 18 55 27 45
3 KFR KFR 18 38 40 28
4 KF Vídir KF Vídir 18 36 36 24
5 ÍH ÍH 18 34 56 24
6 Leiknir Fáskrúðsfjörður Leiknir 18 37 37 22
7 Grundarfjördur Grundarfjör 18 37 32 21
8 IF Magni IF Magni 18 33 41 20
9 Augnablik Augnablik 18 37 57 18
10 Kári Kári 18 22 56 17
TEMPORADA 2011/2012
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Völsungur Völsungur 22 36 21 46
2 KF Fjallabyggdar Fjallabyggda 22 51 23 43
3 HK Kopavogur Kopavogur 22 43 27 43
4 KV Reykjavík Reykjavík 22 43 26 40
5 Afturelding Afturelding 22 50 46 40
6 Dalvík / Reynir Dalvík 22 38 25 36
7 Reynir Reynir 22 35 41 31
8 UMF Njardvík Njardvík 22 31 35 30
9 Hamar Hveragerdi Hamar 22 36 41 21
10 IF Grótta IF Grótta 22 31 41 20
11 Fjardabyggd Fjardabyggd 22 31 48 15
12 KFR KFR 22 20 71 6
TEMPORADA 2010/2011
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Tindastoll Tindastoll 22 49 36 42
2 IF Höttur IF Höttur 22 48 31 41
3 UMF Njardvík Njardvík 22 63 44 39
4 Afturelding Afturelding 22 48 32 39
5 Dalvík / Reynir Dalvík 22 50 51 38
6 KF Fjallabyggdar Fjallabyggda 22 48 35 34
7 Fjardabyggd Fjardabyggd 22 33 36 34
8 Reynir Reynir 22 61 57 32
9 Hamar Hveragerdi Hamar 22 40 41 30
10 Völsungur Völsungur 22 54 56 26
11 Árborg Árborg 22 20 54 11
12 ÍH ÍH 22 30 71 8
TEMPORADA 2009/2010
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Víkingur Reykjavík Víkingur 22 46 23 48
2 Thór Thór 22 53 23 43
3 Leiknir Reykjavik Leiknir 22 32 19 43
4 Fjölnir Fjölnir 22 42 28 40
5 ÍA Akranes ÍA Akranes 22 44 28 35
6 ÍR Reykjavík Reykjavík 22 31 38 30
7 Throttur Throttur 22 32 37 29
8 HK Kopavogur Kopavogur 22 30 38 25
9 KA Akureyri KA Akureyri 22 29 43 24
10 IF Grótta IF Grótta 22 29 47 18
11 Fjardabyggd Fjardabyggd 22 26 47 17
12 UMF Njardvík Njardvík 22 14 37 13
TEMPORADA 2008/2009
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Selfoss Selfoss 22 53 26 47
2 Haukar Haukar 22 44 28 44
3 KA Akureyri KA Akureyri 23 35 26 38
4 HK Kopavogur Kopavogur 22 36 28 36
5 Fjardabyggd Fjardabyggd 21 29 31 33
6 Thór Thór 22 33 35 31
7 Leiknir Reykjavik Leiknir 22 32 33 29
8 ÍR Reykjavík Reykjavík 22 40 46 29
9 ÍA Akranes ÍA Akranes 22 26 27 28
10 Víkingur Reykjavík Víkingur 22 36 34 26
11 Afturelding Afturelding 22 25 45 16
12 Víkingur Ólafsvík Víkingur 22 24 54 13
TEMPORADA 2007/2008
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍBV ÍBV 22 43 17 50
2 Stjarnan Stjarnan 22 47 22 47
3 Selfoss Selfoss 22 54 36 46
4 KA Akureyri KA Akureyri 22 31 27 32
5 Víkingur Reykjavík Víkingur 22 32 30 29
6 Haukar Haukar 22 36 42 28
7 Leiknir Reykjavik Leiknir 22 33 40 26
8 Thór Thór 22 31 42 25
9 Fjardabyggd Fjardabyggd 22 31 37 24
10 Víkingur Ólafsvík Víkingur 22 19 29 24
11 UMF Njardvík Njardvík 22 26 42 19
12 KF Fjallabyggdar Fjallabyggda 22 17 36 12
TEMPORADA 2006/2007
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Grindavík Grindavík 22 47 21 47
2 Throttur Throttur 22 47 24 47
3 Fjölnir Fjölnir 22 61 29 45
4 ÍBV ÍBV 22 42 23 44
5 Fjardabyggd Fjardabyggd 22 23 17 37
6 Leiknir Reykjavik Leiknir 22 22 27 25
7 Thór Thór 22 33 40 24
8 UMF Njardvík Njardvík 22 25 32 23
9 Stjarnan Stjarnan 22 39 44 20
10 Víkingur Ólafsvík Víkingur 22 22 33 20
11 KA Akureyri KA Akureyri 22 14 45 19
12 Reynir Reynir 22 22 62 16

  USO DE MEMORIA  
6,228,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5618
Total Execution Time  0.5631
  CADENA URL  
/historico/Fjardabyggd
  GET DATOS  
$_GET['/historico/Fjardabyggd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0251  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 = 61449
0.0132  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 = 61295
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17955 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1621 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1621 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0126  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 (95788) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '17955' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = '17955' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 61449 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=17955 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (66781,61449) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 61449 AND teamId = 17955
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 66781 AND teamId = 17955
0.0126  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 = '17955' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17955' and rp.type = 4
0.0126  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 = '17955' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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 events2021 e ON e.player_id = p.id AND e.league_id = 61449 WHERE rp.league_id = 61449 AND rp.teamId = 17955 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.0131  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 events2021 e ON e.player_id = p.id AND e.league_id = 61449 WHERE rp.league_id = 61449 AND rp.teamId = 17955 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events2021 e ON e.player_id = p.id AND e.league_id = 61449 WHERE rp.league_id = 61449 AND rp.teamId = 17955 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 17955 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 61449 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.0128  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 = 55074 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.0128  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 = 49451 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 42884 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 37968 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 20270 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 9816 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 11813 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24883 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24052 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24054 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 21175 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 21174 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 21173 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 21172 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC