4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Brattvåg
TEMPORADA 2023/2024
TERCERA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Viking FK II Viking 4 11 8 9
2 Jerv Jerv 4 6 3 9
3 FK Arendal FK Arendal 4 5 3 9
4 Eik Tønsberg Tønsberg 4 9 7 8
5 Vard Vard 4 7 4 7
6 Brattvåg Brattvåg 4 10 6 6
7 Brann II Brann II 4 10 11 6
8 Sotra SK Sotra SK 4 3 4 5
9 Hødd Hødd 4 7 6 4
10 Lysekloster Lysekloster 4 5 7 4
11 Flekkeroy Flekkeroy 4 5 8 4
12 Ørn Horten Ørn Horten 4 4 5 3
13 Notodden Notodden 4 2 5 2
14 Kvik Halden Kvik Halden 4 4 11 2
TEMPORADA 2022/2023
TERCERA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Egersund Egersund 26 73 21 62
2 Lyn 1896 FK Lyn 1896 FK 26 74 23 62
3 FK Arendal FK Arendal 26 55 38 44
4 Grorud IL Grorud IL 26 31 27 36
5 Notodden Notodden 26 41 38 36
6 Kjelsås Kjelsås 26 25 28 35
7 Ørn Horten Ørn Horten 26 41 40 33
8 Brattvåg Brattvåg 26 39 41 33
9 Flekkeroy Flekkeroy 26 33 35 32
10 Vålerenga II Vålerenga 26 33 68 31
11 Vard Vard 26 33 47 27
12 Træff Træff 26 31 64 26
13 Fram Fram 26 37 57 25
14 Aalesunds FK II Aalesunds 26 29 48 23
TEMPORADA 2021/2022
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Hødd Hødd 26 54 15 60
2 Ull Kisa Ull Kisa 26 73 36 56
3 Levanger Levanger 26 62 38 43
4 Kjelsås Kjelsås 26 45 20 42
5 Gjøvik-Lyn Gjøvik-Lyn 26 43 59 40
6 Træff Træff 26 49 44 36
7 Alta IF Alta IF 26 38 45 36
8 Tromsdalen Tromsdalen 26 28 35 35
9 Brattvåg Brattvåg 26 47 52 33
10 Bærum Bærum 26 36 46 31
11 Vålerenga II Vålerenga 26 43 67 29
12 Eidsvold TF Eidsvold TF 26 35 54 28
13 Asker Asker 26 32 47 24
14 Frigg Frigg 26 38 65 20
TEMPORADA 2020/2021
TERCERA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Kongsvinger Kongsvinger 26 88 26 68
2 Hødd Hødd 26 67 18 60
3 Asker Asker 26 60 37 49
4 Tromsdalen Tromsdalen 26 52 34 45
5 Brattvåg Brattvåg 26 55 48 41
6 Kvik Halden Kvik Halden 26 46 48 41
7 Alta IF Alta IF 26 49 47 41
8 Eidsvold TF Eidsvold TF 26 45 47 39
9 Bærum Bærum 26 41 51 30
10 Moss Moss 26 44 51 29
11 Vålerenga II Vålerenga 26 43 63 26
12 Florö SK Florö SK 26 29 63 18
13 Fløya Fløya 26 29 72 14
14 Senja Senja 26 22 65 11
TEMPORADA 2019/2020
TERCERA NORUEGA GRUPO 3
Equipo PJ GF GC Puntos
1 Fredrikstad Fredrikstad 6 15 7 13
2 Skeid Skeid 6 7 4 13
3 Brattvåg Brattvåg 5 6 11 5
4 Hødd Hødd 4 7 7 4
5 Alta IF Alta IF 4 8 9 4
6 Tromsdalen Tromsdalen 5 5 7 4
7 Kvik Halden Kvik Halden 4 8 11 4
TEMPORADA 2018/2019
TERCERA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 IL Stjørdals-Blink Stjørdals-B 26 69 22 60
2 Kvik Halden Kvik Halden 26 57 26 58
3 Fredrikstad Fredrikstad 26 52 28 53
4 Egersund Egersund 26 60 36 45
5 Levanger Levanger 26 38 40 41
6 FK Arendal FK Arendal 26 49 40 39
7 Hødd Hødd 26 40 45 35
8 Moss Moss 26 35 46 34
9 Brattvåg Brattvåg 26 43 50 33
10 Nardo Nardo 26 27 43 29
11 Bryne Bryne 26 30 41 28
12 Vidar Vidar 26 32 51 21
13 Sola Fotball Sola Fotball 26 32 61 20
14 Byåsen Byåsen 26 28 63 17
TEMPORADA 2017/2018
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Skeid Skeid 26 59 25 56
2 KFUM Oslo KFUM Oslo 26 47 32 47
3 Hødd Hødd 26 43 30 47
4 Egersund Egersund 26 47 28 44
5 Bryne Bryne 26 45 38 41
6 FK Arendal FK Arendal 26 37 34 36
7 Kjelsås Kjelsås 26 38 36 35
8 Brattvåg Brattvåg 26 37 51 35
9 Vidar Vidar 26 41 51 33
10 Nardo Nardo 26 33 44 31
11 IL Stjørdals-Blink Stjørdals-B 26 39 48 28
12 Flekkeroy Flekkeroy 26 39 55 28
13 Vålerenga II Vålerenga 26 54 62 26
14 Vard Vard 26 31 56 14
TEMPORADA 2016/2017
CUARTA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 Brattvåg Brattvåg 26 78 27 56
2 Lysekloster Lysekloster 26 55 32 56
3 SK Herd SK Herd 26 57 48 42
4 Fyllingsdalen Fyllingsdale 26 61 50 41
5 Sotra SK Sotra SK 26 52 43 41
6 Varegg Varegg 26 51 54 40
7 Spjelkavik Spjelkavik 26 45 44 35
8 Förde Förde 26 47 49 34
9 Brann II Brann II 26 48 47 30
10 Stord Stord 26 48 58 30
11 Os Turn Os Turn 26 45 55 30
12 Haugesund II Haugesund 26 37 60 27
13 Fjora Fjora 26 41 73 26
14 Aalesunds FK II Aalesunds 26 35 60 17
TEMPORADA 2015/2016
TERCERA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Elverum Elverum 26 68 13 64
2 HamKam HamKam 26 63 27 56
3 Hønefoss Hønefoss 26 49 35 42
4 Brumunddal Brumunddal 26 32 34 41
5 Nybergsund IL-Trysil Nybergsund 26 52 45 40
6 Byåsen Byåsen 26 44 49 40
7 Nardo Nardo 26 28 36 39
8 Brattvåg Brattvåg 26 41 37 38
9 IL Stjørdals-Blink Stjørdals-B 26 53 41 37
10 Strindheim Strindheim 26 50 60 30
11 Gjøvik-Lyn Gjøvik-Lyn 26 27 44 28
12 Molde FK II Molde FK II 26 43 49 27
13 Rosenborg II Rosenborg 26 31 66 20
14 Tynset Tynset 26 20 65 9
TEMPORADA 2014/2015
CUARTA NORUEGA GRUPO 8
Equipo PJ GF GC Puntos
1 Brattvåg Brattvåg 26 67 21 64
2 Kristiansund FK Kristiansund 26 64 56 47
3 SK Herd SK Herd 26 67 42 46
4 Sogndal II Sogndal II 26 51 43 46
5 Spjelkavik Spjelkavik 26 39 29 44
6 Stryn IL Stryn IL 26 51 45 39
7 Volda Volda 26 53 46 38
8 Årdal Årdal 26 45 40 38
9 Hødd II Hødd II 26 59 47 36
10 Bergsøy Bergsøy 26 46 49 34
11 Florø II Florø II 26 50 45 31
12 Kristiansund II Kristiansund 26 45 60 28
13 Eid IL Eid IL 26 37 98 10
14 Skarbøvik Skarbøvik 26 21 74 8
TEMPORADA 2013/2014
CUARTA NORUEGA GRUPO 9
Equipo PJ GF GC Puntos
1 Strindheim Strindheim 26 97 25 70
2 Brattvåg Brattvåg 26 88 35 55
3 Orkla Orkla 26 80 42 52
4 Sverresborg Sverresborg 26 71 59 43
5 Kolstad Kolstad 26 68 62 37
6 KIL / Hemne KIL / Hemne 26 64 65 35
7 Heimdal Heimdal 26 58 63 35
8 Buvik Buvik 26 62 69 34
9 Kristiansund II Kristiansund 26 48 51 33
10 Charlottenlund Charlottenlu 26 57 70 32
11 Nardo II Nardo II 26 38 76 28
12 Averøykameratene Averøykamer 26 39 48 27
13 Sunndal Fotball Sunndal 26 48 85 26
14 Træff II Træff II 26 16 84 10
TEMPORADA 2012/2013
CUARTA NORUEGA GRUPO 9
Equipo PJ GF GC Puntos
1 SK Herd SK Herd 26 86 30 65
2 Brattvåg Brattvåg 26 68 34 49
3 Kristiansund II Kristiansund 26 79 42 48
4 Bergsøy Bergsøy 26 54 62 43
5 Aalesunds FK II Aalesunds 26 68 50 41
6 Averøykameratene Averøykamer 26 59 54 40
7 Hødd II Hødd II 26 47 56 40
8 Sunndal Fotball Sunndal 26 58 57 32
9 Elnesvågen og Omegn IL Elnesvågen 26 59 63 32
10 Larsnes / Gursken Larsnes 26 46 52 30
11 Spjelkavik Spjelkavik 26 41 62 29
12 Volda Volda 26 37 63 27
13 Surnadal Surnadal 26 40 77 21
14 Stranda Stranda 26 39 79 21
TEMPORADA 2011/2012
CUARTA NORUEGA GRUPO 9
Equipo PJ GF GC Puntos
1 Skarbøvik Skarbøvik 26 78 21 64
2 Sunndal Fotball Sunndal 26 90 49 56
3 Brattvåg Brattvåg 26 65 41 48
4 SK Herd SK Herd 26 76 39 47
5 Bergsøy Bergsøy 26 51 56 39
6 Hødd II Hødd II 26 70 47 38
7 Averøykameratene Averøykamer 26 51 62 38
8 Elnesvågen og Omegn IL Elnesvågen 26 73 78 37
9 Stranda Stranda 26 45 60 33
10 Larsnes / Gursken Larsnes 26 51 60 31
11 Volda Volda 26 53 58 30
12 Surnadal Surnadal 26 45 68 28
13 Dahle Dahle 26 32 79 21
14 Hareid Hareid 26 36 98 10

  USO DE MEMORIA  
6,311,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6626
Total Execution Time  0.6639
  CADENA URL  
/historico/Brattvag
  GET DATOS  
$_GET['/historico/Brattvag']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0179  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 = 'Brattvag' 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.0132  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=17786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=17786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=17786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=17786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 74960
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17786 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=351 AND type_rel = 3
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 351 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1155528,848042,841191,803208,67140) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '17786' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '17786' 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 = 74960 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=17786 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (75723,74960,71432) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 74960 AND teamId = 17786
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 75723 AND teamId = 17786
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17786
0.0142  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 = 74960 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136  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 = '17786' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17786' 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 = '17786' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 74960 WHERE rp.league_id = 74960 AND rp.teamId = 17786 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.0164  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 = 74960 WHERE rp.league_id = 74960 AND rp.teamId = 17786 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 74960 WHERE rp.league_id = 74960 AND rp.teamId = 17786 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 = 17786 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74960 AND t.round = 4 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 `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 = 70813 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.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 `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 = 66264 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.0141  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 = 61140 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.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 = 53743 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.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 = 59971 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.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 = 48604 AND t.round = 26 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 `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 = 42253 AND t.round = 26 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 `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 = 38249 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 20368 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 48816 AND t.round = 26 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 `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 = 48835 AND t.round = 26 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 `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 = 48847 AND t.round = 26 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 `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 = 48859 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74960 ORDER BY nameShow LIMIT 100