4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Burreli
TEMPORADA 2023/2024
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 AF Elbasani AF Elbasani 30 66 30 70
2 Bylis Ballsh Bylis Ballsh 30 49 26 67
3 Flamurtari Vlorë Flamurtari 30 43 24 55
4 Vora Vora 30 58 45 48
5 Apolonia Fier Apolonia 30 43 27 46
6 Korabi Peshkopi Korabi 30 38 31 43
7 Lushnja Lushnja 30 36 51 34
8 Kastrioti Krujë Kastrioti 30 36 45 33
9 Besa Kavajë Besa Kavajë 30 32 47 31
10 Burreli Burreli 30 21 40 31
11 Luzi 2008 Luzi 2008 30 37 52 27
12 Tomori Berat Tomori Berat 30 21 62 17
TEMPORADA 2022/2023
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Skënderbeu Korçë Skënderbeu 26 37 13 49
2 Dinamo City Dinamo City 26 48 23 47
3 Flamurtari Vlorë Flamurtari 26 40 16 46
4 Tomori Berat Tomori Berat 26 29 27 43
5 Korabi Peshkopi Korabi 26 32 24 39
6 Apolonia Fier Apolonia 26 31 30 38
7 Luzi 2008 Luzi 2008 26 31 26 38
8 Besa Kavajë Besa Kavajë 26 32 26 37
9 Lushnja Lushnja 26 30 42 32
10 Burreli Burreli 26 22 29 31
11 Oriku Oriku 26 27 33 30
12 Turbina Cërrik Turbina 26 24 45 26
13 Tërbuni Pukë Tërbuni 26 16 41 24
14 Besëlidhja Lezhë Besëlidhja 26 17 41 17
TEMPORADA 2021/2022
PRIMERA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bylis Ballsh Bylis Ballsh 30 51 18 69
2 Erzeni Shijak Erzeni 30 57 18 67
3 Korabi Peshkopi Korabi 30 35 22 59
4 Apolonia Fier Apolonia 30 44 25 51
5 Tërbuni Pukë Tërbuni 30 21 16 47
6 Tomori Berat Tomori Berat 30 45 31 44
7 Lushnja Lushnja 30 31 27 42
8 Burreli Burreli 30 30 24 41
9 Besa Kavajë Besa Kavajë 30 36 40 40
10 Besëlidhja Lezhë Besëlidhja 30 45 54 39
11 Pogradeci Pogradeci 30 32 37 38
12 Turbina Cërrik Turbina 30 31 44 37
13 Butrinti Sarandë Butrinti 30 32 36 34
14 Maliqi Maliqi 30 32 62 23
15 Vora Vora 30 32 54 21
16 Shkumbini Peqin Shkumbini 30 30 76 18
TEMPORADA 2020/2021
PRIMERA ALBANIA GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo City Dinamo City 22 32 13 47
2 Burreli Burreli 22 35 15 44
3 Korabi Peshkopi Korabi 22 28 14 43
4 Vora Vora 22 14 36 21
5 KF Egnatia KF Egnatia 20 36 10 46
6 Tomori Berat Tomori Berat 20 36 20 40
7 Pogradeci Pogradeci 20 32 26 33
8 Besa Kavajë Besa Kavajë 20 26 26 24
TEMPORADA 2019/2020
PRIMERA ALBANIA GRUPO 3
Equipo PJ GF GC Puntos
1 KF Egnatia KF Egnatia 8 7 6 31
2 Burreli Burreli 8 6 9 31
3 Dinamo City Dinamo City 8 11 3 27
4 Veleçiku Koplik Veleçiku 8 10 8 25
5 Tërbuni Pukë Tërbuni 8 9 17 23
6 Turbina Cërrik Turbina 10 25 9 38
7 KF Elbasani KF Elbasani 9 28 14 37
8 Oriku Oriku 9 9 10 37
9 Devolli Devolli 10 10 13 34
10 KF Iliria KF Iliria 10 17 21 33
11 Shenkolli Shenkolli 10 14 36 18
TEMPORADA 2018/2019
PRIMERA ALBANIA GRUPO 3
Equipo PJ GF GC Puntos
1 KF Iliria KF Iliria 8 10 10 14
2 Shenkolli Shenkolli 8 15 13 13
3 Burreli Burreli 8 7 6 13
4 Veleçiku Koplik Veleçiku 8 8 9 10
5 Vora Vora 8 10 12 7
6 Turbina Cërrik Turbina 8 14 7 15
7 Pogradeci Pogradeci 8 12 10 15
8 Apolonia Fier Apolonia 8 13 7 13
9 KF Elbasani KF Elbasani 8 9 12 13
10 Tomori Berat Tomori Berat 8 5 17 2
TEMPORADA 2017/2018
PRIMERA ALBANIA GRUPO 3
Equipo PJ GF GC Puntos
1 Besa Kavajë Besa Kavajë 8 13 13 22
2 Korabi Peshkopi Korabi 7 9 10 20
3 Burreli Burreli 7 6 6 19
4 Tërbuni Pukë Tërbuni 7 5 5 19
5 Vllaznia Shkodër II Vllaznia 7 10 9 11
6 KF Iliria KF Iliria 7 11 9 23
7 Shenkolli Shenkolli 8 15 19 22
8 Shkumbini Peqin Shkumbini 7 11 9 18
9 Turbina Cërrik Turbina 7 12 13 18
10 Naftëtari Kuçovë Naftëtari 7 9 8 11
TEMPORADA 2016/2017
PRIMERA ALBANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Besëlidhja Lezhë Besëlidhja 8 14 3 20
2 Kamza Kamza 8 12 6 16
3 Burreli Burreli 8 11 12 8
4 Erzeni Shijak Erzeni 8 13 21 5
5 Shenkolli Shenkolli 8 11 19 4
6 Lushnja Lushnja 8 13 6 20
7 Bylis Ballsh Bylis Ballsh 8 17 5 19
8 Pogradeci Pogradeci 8 10 12 9
9 Shkumbini Peqin Shkumbini 8 8 18 5
10 Tomori Berat Tomori Berat 8 10 17 3
TEMPORADA 2015/2016
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Kastrioti Krujë Kastrioti 27 61 27 63
2 Korabi Peshkopi Korabi 27 43 16 62
3 Besëlidhja Lezhë Besëlidhja 27 59 26 54
4 Erzeni Shijak Erzeni 27 47 45 34
5 Burreli Burreli 27 29 38 34
6 Kamza Kamza 27 33 44 30
7 Besa Kavajë Besa Kavajë 27 31 40 29
8 KF Iliria KF Iliria 27 34 45 28
9 Mamurrasi Mamurrasi 27 22 42 25
10 Ada Velipojë Velipojë 27 29 65 21
11 KF Luftëtari Luftëtari 27 53 9 68
12 Pogradeci Pogradeci 27 51 24 63
13 Apolonia Fier Apolonia 27 42 26 46
14 Dinamo City Dinamo City 27 27 32 33
15 Turbina Cërrik Turbina 27 29 37 31
16 Lushnja Lushnja 27 26 35 31
17 KF Elbasani KF Elbasani 27 27 45 29
18 Shkumbini Peqin Shkumbini 27 19 40 29
19 Sopoti Librazhd Sopoti 27 30 33 28
20 Butrinti Sarandë Butrinti 27 15 38 24
TEMPORADA 2014/2015
PRIMERA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tërbuni Pukë Tërbuni 27 55 12 69
2 Besëlidhja Lezhë Besëlidhja 27 56 13 65
3 Mamurrasi Mamurrasi 27 57 16 64
4 KF Iliria KF Iliria 27 25 25 33
5 Kastrioti Krujë Kastrioti 27 33 36 31
6 Burreli Burreli 27 38 45 31
7 Kamza Kamza 27 30 47 31
8 Ada Velipojë Velipojë 27 31 57 27
9 Besa Kavajë Besa Kavajë 27 25 45 23
10 Veleçiku Koplik Veleçiku 27 23 77 5
TEMPORADA 2013/2014
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 KF Elbasani KF Elbasani 30 46 32 60
2 Apolonia Fier Apolonia 30 37 14 56
3 Tërbuni Pukë Tërbuni 30 46 31 49
4 Tomori Berat Tomori Berat 30 29 36 44
5 Butrinti Sarandë Butrinti 30 38 27 44
6 Pogradeci Pogradeci 30 35 31 42
7 Shkumbini Peqin Shkumbini 30 35 38 40
8 Burreli Burreli 30 26 30 39
9 Dinamo City Dinamo City 30 33 32 39
10 KF Luftëtari Luftëtari 30 33 37 38
11 Veleçiku Koplik Veleçiku 30 33 39 37
12 Ada Velipojë Velipojë 30 33 44 37
13 Kamza Kamza 30 33 47 37
14 Mamurrasi Mamurrasi 30 41 43 36
15 Himara Himara 30 36 37 36
16 Albpetrol Patos Albpetrol 30 21 37 24
TEMPORADA 2012/2013
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Lushnja Lushnja 30 48 22 66
2 Partizani Tirana Partizani 30 39 33 56
3 Tërbuni Pukë Tërbuni 30 40 30 43
4 Mamurrasi Mamurrasi 30 48 45 43
5 Pogradeci Pogradeci 30 49 44 42
6 Himara Himara 30 32 29 42
7 Burreli Burreli 30 32 31 42
8 Ada Velipojë Velipojë 30 34 31 41
9 Kamza Kamza 30 38 47 41
10 Butrinti Sarandë Butrinti 30 38 33 40
11 Dinamo City Dinamo City 30 40 37 40
12 KF Elbasani KF Elbasani 30 42 46 40
13 Besëlidhja Lezhë Besëlidhja 30 28 30 38
14 KF Iliria KF Iliria 30 35 37 37
15 Gramshi Gramshi 30 18 41 31
16 Naftëtari Kuçovë Naftëtari 30 22 47 20
TEMPORADA 2011/2012
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 KF Luftëtari Luftëtari 30 59 22 72
2 Kukësi Kukësi 30 63 24 67
3 Lushnja Lushnja 30 49 16 64
4 Besa Kavajë Besa Kavajë 30 44 33 55
5 Besëlidhja Lezhë Besëlidhja 30 38 16 54
6 KF Elbasani KF Elbasani 30 44 48 39
7 Burreli Burreli 30 36 43 39
8 Gramshi Gramshi 30 37 44 38
9 Butrinti Sarandë Butrinti 30 32 36 37
10 Ada Velipojë Velipojë 30 34 35 36
11 KF Iliria KF Iliria 30 38 44 36
12 Mamurrasi Mamurrasi 30 35 48 34
13 Himara Himara 30 38 43 32
14 Gramozi Ersekë Gramozi 30 25 60 29
15 Vlora Vlora 30 24 54 18
16 Skrapari Skrapari 30 22 52 18
TEMPORADA 2010/2011
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Pogradeci Pogradeci 30 56 27 68
2 Tomori Berat Tomori Berat 30 50 24 63
3 Kamza Kamza 30 42 20 60
4 Apolonia Fier Apolonia 30 50 31 60
5 Besëlidhja Lezhë Besëlidhja 30 40 17 57
6 Mamurrasi Mamurrasi 30 30 29 43
7 Lushnja Lushnja 30 35 25 39
8 Gramozi Ersekë Gramozi 30 34 45 39
9 Ada Velipojë Velipojë 30 40 41 37
10 KF Luftëtari Luftëtari 30 23 34 37
11 Burreli Burreli 30 29 37 36
12 Vlora Vlora 30 36 47 34
13 Gramshi Gramshi 30 24 34 31
14 Tërbuni Pukë Tërbuni 30 27 42 31
15 Bilisht Sporti Bilisht 30 30 64 27
16 Partizani Tirana Partizani 30 16 45 17
TEMPORADA 2009/2010
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 Bylis Ballsh Bylis Ballsh 30 57 26 69
2 KF Elbasani KF Elbasani 30 56 25 62
3 Kamza Kamza 30 50 21 62
4 Lushnja Lushnja 30 59 10 60
5 Partizani Tirana Partizani 30 49 35 57
6 Pogradeci Pogradeci 30 40 39 48
7 Ada Velipojë Velipojë 30 46 34 42
8 KF Luftëtari Luftëtari 30 38 45 36
9 Besëlidhja Lezhë Besëlidhja 30 32 40 35
10 Gramshi Gramshi 30 23 34 32
11 Bilisht Sporti Bilisht 30 30 50 32
12 Burreli Burreli 30 26 41 31
13 Skrapari Skrapari 30 29 56 31
14 Memaliaj Memaliaj 30 23 37 29
15 Turbina Cërrik Turbina 30 35 53 28
16 Sopoti Librazhd Sopoti 30 14 61 15

  USO DE MEMORIA  
6,526,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.7011
Total Execution Time  0.7029
  CADENA URL  
/historico/Burreli
  GET DATOS  
$_GET['/historico/Burreli']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0142  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 = 'Burreli' 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.0125  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=9079 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=9079 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=9079 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 73436
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9079 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=288 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 288 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 (403000) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '9079' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '9079' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73436 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=9079 AND l.year in (2023,2024,2025) 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 (73617,73436,71777) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73436 AND teamId = 9079
0.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 73617 AND teamId = 9079
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71777 AND teamId = 9079
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 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 = 73436 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138  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 = 73436 WHERE rp.league_id = 73436 AND rp.teamId = 9079 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73436 WHERE rp.league_id = 73436 AND rp.teamId = 9079 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 73436 WHERE rp.league_id = 73436 AND rp.teamId = 9079 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 9079 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73436 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `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 = 68115 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.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 `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 = 63881 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.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 `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 = 60132 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 62038 AND t.round = 6 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 = 51070 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 55616 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.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 `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 = 45026 AND t.round = 18 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 `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 = 49130 AND t.round = 10 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 `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 = 39922 AND t.round = 18 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 = 43048 AND t.round = 10 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 = 35696 AND t.round = 18 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 = 49153 AND t.round = 10 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 = 15523 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 = 9276 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 9016 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 2043 AND t.round = 30 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 `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 = 1866 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 8879 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 8877 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC