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

B36 Torshavn

Entrenador: Dan Brimsvík

TEMPORADA 2023/2024
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Víkingur Víkingur 6 20 3 18
2 HB Tórshavn Tórshavn 6 12 5 15
3 Kí Klaksvík Klaksvík 6 14 6 12
4 NSÍ Runavík NSÍ 6 14 9 12
5 07 Vestur 07 Vestur 6 10 8 11
6 B36 Torshavn Torshavn 6 11 8 10
7 EB / Streymur Streymur 6 9 12 4
8 Skála ÍF Skála ÍF 6 8 12 4
9 B68 Toftir B68 Toftir 6 2 12 1
10 ÍF Fuglafjørdur Fuglafjørdu 6 3 28 0
TEMPORADA 2022/2023
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Kí Klaksvík Klaksvík 27 66 19 67
2 Víkingur Víkingur 27 76 23 60
3 HB Tórshavn Tórshavn 27 68 23 58
4 B36 Torshavn Torshavn 27 54 27 57
5 07 Vestur 07 Vestur 27 42 41 40
6 EB / Streymur Streymur 27 25 53 25
7 B68 Toftir B68 Toftir 27 29 48 23
8 ÍF Fuglafjørdur Fuglafjørdu 27 23 67 20
9 AB Argir AB Argir 27 27 63 18
10 TB Tvøroyri Tvøroyri 27 15 61 16
TEMPORADA 2021/2022
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Kí Klaksvík Klaksvík 27 78 7 77
2 Víkingur Víkingur 27 69 24 58
3 HB Tórshavn Tórshavn 27 56 27 55
4 B36 Torshavn Torshavn 27 48 29 38
5 EB / Streymur Streymur 27 31 54 35
6 B68 Toftir B68 Toftir 27 37 50 30
7 07 Vestur 07 Vestur 27 34 61 29
8 AB Argir AB Argir 27 33 63 29
9 NSÍ Runavík NSÍ 27 31 59 21
10 Skála ÍF Skála ÍF 27 25 68 10
TEMPORADA 2020/2021
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Kí Klaksvík Klaksvík 27 99 12 72
2 HB Tórshavn Tórshavn 27 87 22 61
3 Víkingur Víkingur 27 59 27 60
4 NSÍ Runavík NSÍ 27 54 38 47
5 B36 Torshavn Torshavn 27 51 33 45
6 07 Vestur 07 Vestur 27 36 74 28
7 EB / Streymur Streymur 27 28 53 25
8 B68 Toftir B68 Toftir 27 33 66 25
9 ÍF Fuglafjørdur Fuglafjørdu 27 26 70 16
10 TB Tvøroyri Tvøroyri 27 17 95 3
TEMPORADA 2019/2020
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 81 23 69
2 NSÍ Runavík NSÍ 27 58 26 63
3 Kí Klaksvík Klaksvík 27 72 25 62
4 B36 Torshavn Torshavn 27 77 37 59
5 Víkingur Víkingur 27 55 44 47
6 ÍF Fuglafjørdur Fuglafjørdu 27 34 59 26
7 EB / Streymur Streymur 27 26 65 24
8 TB Tvøroyri Tvøroyri 27 20 42 18
9 AB Argir AB Argir 27 21 73 10
10 Skála ÍF Skála ÍF 27 22 72 7
TEMPORADA 2018/2019
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Kí Klaksvík Klaksvík 26 59 18 63
2 B36 Torshavn Torshavn 27 53 23 63
3 NSÍ Runavík NSÍ 27 65 31 57
4 HB Tórshavn Tórshavn 27 62 28 51
5 Víkingur Víkingur 26 50 32 51
6 Skála ÍF Skála ÍF 27 38 32 37
7 AB Argir AB Argir 27 32 66 21
8 TB Tvøroyri Tvøroyri 27 20 57 19
9 EB / Streymur Streymur 27 25 63 18
10 ÍF Fuglafjørdur Fuglafjørdu 27 27 81 6
TEMPORADA 2017/2018
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 58 18 73
2 NSÍ Runavík NSÍ 27 64 25 55
3 B36 Torshavn Torshavn 27 58 33 53
4 Kí Klaksvík Klaksvík 27 48 25 51
5 Víkingur Víkingur 27 39 37 39
6 Skála ÍF Skála ÍF 27 31 42 29
7 TB Tvøroyri Tvøroyri 27 27 42 28
8 EB / Streymur Streymur 27 30 53 21
9 AB Argir AB Argir 27 16 55 18
10 07 Vestur 07 Vestur 27 30 71 17
TEMPORADA 2016/2017
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Víkingur Víkingur 27 62 33 52
2 Kí Klaksvík Klaksvík 27 50 26 52
3 B36 Torshavn Torshavn 27 62 39 48
4 NSÍ Runavík NSÍ 27 57 35 46
5 HB Tórshavn Tórshavn 27 43 31 39
6 Skála ÍF Skála ÍF 27 31 40 33
7 EB / Streymur Streymur 27 34 49 32
8 TB Tvøroyri Tvøroyri 27 31 45 29
9 07 Vestur 07 Vestur 27 37 59 28
10 ÍF Fuglafjørdur Fuglafjørdu 27 23 73 12
TEMPORADA 2015/2016
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Víkingur Víkingur 27 59 25 61
2 Kí Klaksvík Klaksvík 27 64 26 60
3 NSÍ Runavík NSÍ 27 60 36 55
4 B36 Torshavn Torshavn 27 46 28 49
5 HB Tórshavn Tórshavn 27 44 30 43
6 ÍF Fuglafjørdur Fuglafjørdu 27 42 59 32
7 TB Tvøroyri Tvøroyri 27 31 48 27
8 Skála ÍF Skála ÍF 27 25 41 26
9 AB Argir AB Argir 27 31 49 18
10 B68 Toftir B68 Toftir 27 20 80 7
TEMPORADA 2014/2015
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B36 Torshavn Torshavn 27 60 25 61
2 NSÍ Runavík NSÍ 27 73 37 54
3 Víkingur Víkingur 27 68 35 53
4 HB Tórshavn Tórshavn 27 43 32 43
5 Kí Klaksvík Klaksvík 27 50 41 41
6 ÍF Fuglafjørdur Fuglafjørdu 27 44 56 27
7 TB Tvøroyri Tvøroyri 27 36 47 26
8 AB Argir AB Argir 27 35 42 24
9 Suduroy Suduroy 27 39 68 22
10 EB / Streymur Streymur 27 27 92 11
TEMPORADA 2013/2014
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B36 Torshavn Torshavn 27 53 25 61
2 HB Tórshavn Tórshavn 27 59 20 60
3 Víkingur Víkingur 27 60 30 49
4 NSÍ Runavík NSÍ 27 53 42 40
5 EB / Streymur Streymur 27 41 33 40
6 Kí Klaksvík Klaksvík 27 41 38 36
7 ÍF Fuglafjørdur Fuglafjørdu 27 36 52 28
8 AB Argir AB Argir 27 30 61 25
9 Skála ÍF Skála ÍF 27 19 54 17
10 B68 Toftir B68 Toftir 27 23 60 17
TEMPORADA 2012/2013
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 68 34 54
2 ÍF Fuglafjørdur Fuglafjørdu 27 55 48 49
3 B36 Torshavn Torshavn 27 48 35 46
4 NSÍ Runavík NSÍ 27 54 47 45
5 EB / Streymur Streymur 27 55 36 41
6 Víkingur Víkingur 27 41 42 41
7 AB Argir AB Argir 27 36 48 31
8 Kí Klaksvík Klaksvík 27 54 55 28
9 TB Tvøroyri Tvøroyri 27 27 48 23
10 07 Vestur 07 Vestur 27 25 70 14
TEMPORADA 2011/2012
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 EB / Streymur Streymur 27 50 27 58
2 ÍF Fuglafjørdur Fuglafjørdu 27 55 23 54
3 HB Tórshavn Tórshavn 27 56 34 45
4 Kí Klaksvík Klaksvík 27 59 44 45
5 Víkingur Víkingur 27 43 35 45
6 B36 Torshavn Torshavn 27 42 36 38
7 NSÍ Runavík NSÍ 27 38 42 31
8 TB Tvøroyri Tvøroyri 27 30 50 24
9 B68 Toftir B68 Toftir 27 23 43 24
10 Suduroy Suduroy 27 16 78 9
TEMPORADA 2010/2011
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B36 Torshavn Torshavn 27 63 28 67
2 EB / Streymur Streymur 27 66 33 60
3 Víkingur Víkingur 27 62 31 59
4 NSÍ Runavík NSÍ 27 58 47 41
5 Kí Klaksvík Klaksvík 27 48 50 34
6 B68 Toftir B68 Toftir 27 44 44 32
7 ÍF Fuglafjørdur Fuglafjørdu 27 36 44 28
8 HB Tórshavn Tórshavn 27 46 56 26
9 07 Vestur 07 Vestur 27 30 65 24
10 B71 Sandoy B71 Sandoy 27 25 80 11
TEMPORADA 2009/2010
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 49 32 54
2 EB / Streymur Streymur 27 65 30 51
3 NSÍ Runavík NSÍ 27 60 33 48
4 ÍF Fuglafjørdur Fuglafjørdu 27 50 41 43
5 Víkingur Víkingur 27 44 35 43
6 B36 Torshavn Torshavn 27 44 36 40
7 B68 Toftir B68 Toftir 27 42 47 31
8 B71 Sandoy B71 Sandoy 27 24 65 23
9 Suduroy Suduroy 27 33 54 22
10 AB Argir AB Argir 27 27 65 14
TEMPORADA 2008/2009
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 59 37 55
2 EB / Streymur Streymur 27 56 34 50
3 Víkingur Víkingur 27 51 36 47
4 NSÍ Runavík NSÍ 27 56 46 44
5 B68 Toftir B68 Toftir 27 48 41 43
6 AB Argir AB Argir 27 29 35 34
7 ÍF Fuglafjørdur Fuglafjørdu 27 45 48 30
8 B36 Torshavn Torshavn 27 37 53 28
9 Kí Klaksvík Klaksvík 27 30 57 24
10 07 Vestur 07 Vestur 27 39 63 19
TEMPORADA 2007/2008
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 EB / Streymur Streymur 27 54 33 55
2 HB Tórshavn Tórshavn 27 57 22 49
3 B36 Torshavn Torshavn 27 34 25 48
4 NSÍ Runavík NSÍ 27 41 33 47
5 Víkingur Víkingur 27 43 33 42
6 B68 Toftir B68 Toftir 27 24 38 36
7 ÍF Fuglafjørdur Fuglafjørdu 27 32 46 31
8 Kí Klaksvík Klaksvík 27 31 39 28
9 B71 Sandoy B71 Sandoy 27 26 47 23
10 Skála ÍF Skála ÍF 27 22 48 19
TEMPORADA 2006/2007
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 NSÍ Runavík NSÍ 27 52 24 61
2 EB / Streymur Streymur 27 58 33 54
3 B36 Torshavn Torshavn 27 46 22 52
4 HB Tórshavn Tórshavn 27 59 34 49
5 GÍ Gøta GÍ Gøta 27 45 53 38
6 Skála ÍF Skála ÍF 27 26 39 34
7 Kí Klaksvík Klaksvík 27 44 47 33
8 B71 Sandoy B71 Sandoy 27 39 49 32
9 AB Argir AB Argir 27 30 55 17
10 VB / Sumba VB / Sumba 27 27 70 11
TEMPORADA 2005/2006
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 61 36 55
2 EB / Streymur Streymur 27 63 30 54
3 B36 Torshavn Torshavn 27 45 32 47
4 Kí Klaksvík Klaksvík 27 54 39 45
5 NSÍ Runavík NSÍ 27 50 39 42
6 GÍ Gøta GÍ Gøta 27 39 34 41
7 Skála ÍF Skála ÍF 27 33 29 31
8 VB / Sumba VB / Sumba 27 24 73 20
9 B68 Toftir B68 Toftir 27 34 58 18
10 ÍF Fuglafjørdur Fuglafjørdu 27 29 62 16
TEMPORADA 2004/2005
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B36 Torshavn Torshavn 27 38 17 54
2 HB Tórshavn Tórshavn 27 66 35 50
3 Skála ÍF Skála ÍF 27 55 30 50
4 NSÍ Runavík NSÍ 27 58 44 50
5 EB / Streymur Streymur 27 48 35 43
6 ÍF Fuglafjørdur Fuglafjørdu 27 32 57 27
7 Kí Klaksvík Klaksvík 27 40 52 25
8 VB / Sumba VB / Sumba 27 36 57 24
9 GÍ Gøta GÍ Gøta 27 35 58 23
10 TB Tvøroyri Tvøroyri 27 26 49 22

  USO DE MEMORIA  
6,819,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5125
Total Execution Time  0.5143
  CADENA URL  
/historico/B36-Torshavn
  GET DATOS  
$_GET['/historico/B36-Torshavn']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0259  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 = 72100
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4019 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4019 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0133  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 (84994,85273,87704,461464,871340) ORDER BY n.cover_points DESC, update_date DESC
0.0140  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 = '4019' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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 = 72099 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 4019 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 = 74850 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 70883 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 66692 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 55312 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 48715 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 42591 AND t.round = 27 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 `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 = 37849 AND t.round = 27 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 `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 = 20307 AND t.round = 27 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 `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 = 9126 AND t.round = 27 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 `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 = 5257 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 10567 AND t.round = 27 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 = 10566 AND t.round = 27 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 `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 = 10565 AND t.round = 27 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 `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 = 10564 AND t.round = 27 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 `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 = 10563 AND t.round = 27 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 = 10562 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 10561 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2006` 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 = 10560 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2005` 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 = 10559 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC