4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Luzi 2008
TEMPORADA 2023/2024
PRIMERA ALBANIA
Equipo PJ GF GC Puntos
1 AF Elbasani AF Elbasani 31 68 30 73
2 Bylis Ballsh Bylis Ballsh 31 53 28 70
3 Flamurtari Vlorë Flamurtari 31 45 28 55
4 Vora Vora 31 58 47 48
5 Apolonia Fier Apolonia 31 43 28 46
6 Korabi Peshkopi Korabi 31 38 31 44
7 Kastrioti Krujë Kastrioti 31 39 45 36
8 Lushnja Lushnja 31 36 53 34
9 Burreli Burreli 31 23 40 34
10 Besa Kavajë Besa Kavajë 31 32 47 32
11 Luzi 2008 Luzi 2008 31 38 52 30
12 Tomori Berat Tomori Berat 31 21 65 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
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Luzi 2008 Luzi 2008 22 67 13 53
2 Oriku Oriku 22 61 11 53
3 Veleçiku Koplik Veleçiku 22 61 13 51
4 Gramshi Gramshi 22 38 31 38
5 Murlani Murlani 22 48 25 35
6 KF Iliria KF Iliria 22 30 26 31
7 KF Elbasani KF Elbasani 22 36 51 28
8 Shenkolli Shenkolli 22 36 56 25
9 Bulqiza Bulqiza 22 33 63 24
10 Ada Velipojë Velipojë 22 23 38 19
11 Klosi Klosi 22 21 45 16
12 Internacional Tirana Internaciona 22 15 97 0
TEMPORADA 2020/2021
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Shkumbini Peqin Shkumbini 24 84 11 64
2 Sopoti Librazhd Sopoti 24 71 20 55
3 Tërbuni Pukë Tërbuni 24 52 19 51
4 Luzi 2008 Luzi 2008 24 45 17 46
5 Bulqiza Bulqiza 24 54 44 41
6 Gramshi Gramshi 24 33 31 40
7 KF Iliria KF Iliria 24 56 36 34
8 Ada Velipojë Velipojë 24 29 49 30
9 Valbona Valbona 24 28 39 26
10 Klosi Klosi 24 17 53 16
11 Internacional Tirana Internaciona 24 34 74 15
12 Shenkolli Shenkolli 24 29 67 14
13 Mirdita Mirdita 24 15 87 1
14 Spartaku Tiranë Spartaku 0 0 0 0
TEMPORADA 2019/2020
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Vora Vora 21 61 14 53
2 Luzi 2008 Luzi 2008 22 59 25 53
3 Partizani Tirana II Partizani 22 55 22 45
4 Sopoti Librazhd Sopoti 22 40 23 41
5 Gramshi Gramshi 22 37 28 38
6 Mirdita Mirdita 22 38 44 37
7 Tirana II Tirana II 22 22 35 24
8 Vllaznia Shkodër II Vllaznia 22 25 39 22
9 Ada Velipojë Velipojë 21 29 50 21
10 Klosi Klosi 22 33 55 20
11 Spartaku Tiranë Spartaku 22 28 52 19
12 Internacional Tirana Internaciona 22 27 67 6
13 Kamza Kamza 0 0 0 0
TEMPORADA 2018/2019
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tërbuni Pukë Tërbuni 22 52 19 50
2 Luzi 2008 Luzi 2008 22 44 15 47
3 Gramshi Gramshi 22 41 21 46
4 Partizani Tirana II Partizani 22 45 26 43
5 Sopoti Librazhd Sopoti 22 51 25 41
6 Spartaku Tiranë Spartaku 22 43 26 37
7 Vllaznia Shkodër II Vllaznia 22 44 43 33
8 Klosi Klosi 22 27 35 22
9 Tirana II Tirana II 22 30 52 22
10 Ada Velipojë Velipojë 22 29 65 15
11 Internacional Tirana Internaciona 22 14 46 9
12 Kukësi II Kukësi II 22 17 64 9
13 Kevitan Kevitan 0 0 0 0
TEMPORADA 2017/2018
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Vora Vora 24 69 20 64
2 Veleçiku Koplik Veleçiku 24 62 14 61
3 Klosi Klosi 24 47 28 52
4 Spartaku Tiranë Spartaku 24 55 40 38
5 Luzi 2008 Luzi 2008 24 35 28 35
6 Partizani Tirana II Partizani 24 43 31 35
7 Gramshi Gramshi 24 36 39 32
8 Tirana II Tirana II 24 36 35 31
9 Internacional Tirana Internaciona 24 32 47 28
10 Sopoti Librazhd Sopoti 24 35 44 23
11 Kukësi II Kukësi II 24 39 56 22
12 Ada Velipojë Velipojë 24 31 78 19
13 Kevitan Kevitan 24 24 84 8
14 Mamurrasi Mamurrasi 0 0 0 0
TEMPORADA 2016/2017
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 KF Egnatia KF Egnatia 24 45 10 67
2 Vllaznia Shkodër II Vllaznia 24 53 24 53
3 Vora Vora 24 56 33 45
4 Partizani Tirana II Partizani 24 41 28 42
5 Albpetrol Patos Albpetrol 24 31 25 40
6 Kukësi II Kukësi II 24 41 36 33
7 Tirana II Tirana II 24 38 44 31
8 Gramshi Gramshi 24 35 36 31
9 Luzi 2008 Luzi 2008 24 22 25 26
10 Veleçiku Koplik Veleçiku 24 23 34 23
11 Internacional Tirana Internaciona 24 18 40 20
12 Ada Velipojë Velipojë 24 32 61 18
13 Kevitan Kevitan 24 16 55 9
TEMPORADA 2015/2016
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Shenkolli Shenkolli 22 35 12 49
2 Partizani Tirana II Partizani 22 40 18 46
3 Kevitan Kevitan 22 35 16 44
4 KF Egnatia KF Egnatia 22 31 23 39
5 Albpetrol Patos Albpetrol 22 24 27 30
6 Veleçiku Koplik Veleçiku 22 30 28 29
7 Vora Vora 22 31 33 27
8 Gramshi Gramshi 22 18 27 21
9 Sukthi Sukthi 22 25 35 20
10 Internacional Tirana Internaciona 22 23 39 20
11 Tirana II Tirana II 22 26 46 19
12 Luzi 2008 Luzi 2008 22 19 33 18
TEMPORADA 2014/2015
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Korabi Peshkopi Korabi 24 45 12 67
2 Erzeni Shijak Erzeni 24 65 23 61
3 Partizani Tirana II Partizani 24 43 16 49
4 Luzi 2008 Luzi 2008 24 34 19 42
5 Vora Vora 24 39 30 34
6 Shenkolli Shenkolli 24 38 33 32
7 Sukthi Sukthi 24 33 33 31
8 Albpetrol Patos Albpetrol 24 27 29 28
9 Tirana II Tirana II 24 44 50 27
10 Domosdova Prrenjas Domosdova 24 26 53 20
11 Teuta Durrës II Teuta 24 28 42 19
12 Olimpiku Tiranë Olimpiku 24 34 68 16
13 Skrapari Skrapari 24 22 70 16
TEMPORADA 2013/2014
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 KF Iliria KF Iliria 24 56 15 63
2 Besëlidhja Lezhë Besëlidhja 24 59 8 62
3 Vora Vora 24 35 19 47
4 Sukthi Sukthi 24 44 20 42
5 Olimpiku Tiranë Olimpiku 24 38 30 34
6 Partizani Tirana II Partizani 24 36 31 33
7 Turbina Cërrik Turbina 24 29 45 30
8 Erzeni Shijak Erzeni 24 37 44 27
9 Korabi Peshkopi Korabi 24 35 44 23
10 Shenkolli Shenkolli 24 29 43 23
11 Domosdova Prrenjas Domosdova 24 26 75 18
12 KF Egnatia KF Egnatia 24 25 47 16
13 Luzi 2008 Luzi 2008 24 20 48 16
TEMPORADA 2012/2013
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Veleçiku Koplik Veleçiku 18 38 18 39
2 Olimpiku Tiranë Olimpiku 18 30 16 38
3 Sukthi Sukthi 18 30 17 30
4 Vora Vora 18 28 21 29
5 Turbina Cërrik Turbina 18 24 29 26
6 Korabi Peshkopi Korabi 18 20 23 25
7 Luzi 2008 Luzi 2008 18 25 28 24
8 Domosdova Prrenjas Domosdova 18 17 22 20
9 Erzeni Shijak Erzeni 18 19 31 18
10 KF Egnatia KF Egnatia 18 12 38 4
TEMPORADA 2011/2012
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tërbuni Pukë Tërbuni 16 36 9 42
2 Sukthi Sukthi 16 41 16 38
3 Veleçiku Koplik Veleçiku 16 23 19 27
4 Luzi 2008 Luzi 2008 16 24 23 24
5 Olimpiku Tiranë Olimpiku 16 24 18 23
6 KF Egnatia KF Egnatia 16 13 18 18
7 Korabi Peshkopi Korabi 16 15 27 10
8 Erzeni Shijak Erzeni 16 20 38 9
9 Pashtriku Has Pashtriku 16 15 43 5
TEMPORADA 2010/2011
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Kukësi Kukësi 26 59 22 60
2 KF Iliria KF Iliria 26 45 19 58
3 Skrapari Skrapari 26 40 26 47
4 Sukthi Sukthi 26 44 24 45
5 Luzi 2008 Luzi 2008 26 36 25 45
6 Rubiku Rubiku 26 36 36 42
7 Veleçiku Koplik Veleçiku 26 36 18 41
8 Naftëtari Kuçovë Naftëtari 26 43 26 41
9 Erzeni Shijak Erzeni 26 31 20 37
10 KF Egnatia KF Egnatia 26 30 38 31
11 Korabi Peshkopi Korabi 26 21 35 28
12 Turbina Cërrik Turbina 26 20 56 19
13 Olimpiku Tiranë Olimpiku 26 22 49 14
14 Fieri Fieri 26 15 84 7
TEMPORADA 2009/2010
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Mamurrasi Mamurrasi 24 49 23 54
2 Tërbuni Pukë Tërbuni 24 43 14 51
3 Luzi 2008 Luzi 2008 24 48 18 50
4 Erzeni Shijak Erzeni 24 40 22 42
5 KF Iliria KF Iliria 24 34 29 36
6 Veleçiku Koplik Veleçiku 24 38 28 35
7 Sukthi Sukthi 24 28 31 31
8 Naftëtari Kuçovë Naftëtari 24 29 35 30
9 Olimpiku Tiranë Olimpiku 24 26 33 28
10 Kukësi Kukësi 24 24 31 27
11 KF Egnatia KF Egnatia 24 17 31 27
12 Korabi Peshkopi Korabi 24 19 50 16
13 Fieri Fieri 24 11 61 7
TEMPORADA 2008/2009
SEGUNDA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Gramshi Gramshi 22 50 18 51
2 Mamurrasi Mamurrasi 22 25 10 47
3 Erzeni Shijak Erzeni 22 29 22 37
4 Luzi 2008 Luzi 2008 22 31 22 35
5 Veleçiku Koplik Veleçiku 22 38 28 34
6 Kukësi Kukësi 22 25 26 30
7 KF Iliria KF Iliria 22 26 32 30
8 KF Egnatia KF Egnatia 22 20 25 27
9 Albpetrol Patos Albpetrol 22 20 25 23
10 Korabi Peshkopi Korabi 22 16 39 22
11 Fieri Fieri 22 25 39 21
12 Olimpiku Tiranë Olimpiku 22 18 37 12

  USO DE MEMORIA  
6,612,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1505
Total Execution Time  0.1517
  CADENA URL  
/historico/Luzi-2008
  GET DATOS  
$_GET['/historico/Luzi-2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0048  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.0048  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 = 73617
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60593 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=288 AND type_rel = 3
0.0051  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.0024  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.0049  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 = '60593' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0038  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 = 73617 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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.0070  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=60593 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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,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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73436 AND teamId = 60593
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73617 AND teamId = 60593
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60593
0.0024  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 = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '60593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60593' and rp.type = 4
0.0023  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 = '60593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 60593 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.0036  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 = 60593 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 60593 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 60593 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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.0022  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 = 64311 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.0024  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 = 60006 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.0022  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 = 51449 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.0025  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 = 45366 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 40658 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 35695 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 15525 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 9284 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 9288 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 2233 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1867 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 14916 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 14920 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 14918 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 73436 ORDER BY nameShow LIMIT 100