4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pogradeci
TEMPORADA 2023/2024
SEGUNDA ALBANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Pogradeci Pogradeci 17 33 8 45
2 KF Luftëtari Luftëtari 17 31 9 44
3 Shkumbini Peqin Shkumbini 18 27 12 39
4 Oriku Oriku 17 21 11 28
5 Labëria Labëria 18 24 24 27
6 Butrinti Sarandë Butrinti 17 22 17 24
7 Turbina Cërrik Turbina 17 20 26 20
8 Devolli Devolli 17 28 36 18
9 Delvina Delvina 18 21 31 14
10 Maliqi Maliqi 17 16 34 8
11 Këlcyra Këlcyra 17 6 41 3
TEMPORADA 2022/2023
SEGUNDA ALBANIA GRUPO 2
Equipo PJ GF GC Puntos
1 AF Elbasani AF Elbasani 22 64 12 58
2 Pogradeci Pogradeci 22 62 13 53
3 Labëria Labëria 22 28 15 39
4 Butrinti Sarandë Butrinti 22 26 24 35
5 Devolli Devolli 22 47 31 34
6 KF Luftëtari Luftëtari 22 38 32 34
7 Shkumbini Peqin Shkumbini 22 26 38 27
8 Delvina Delvina 22 26 35 26
9 Maliqi Maliqi 22 38 58 24
10 Tepelena Tepelena 22 21 48 24
11 Albpetrol Patos Albpetrol 22 18 50 16
12 Memaliaj Memaliaj 22 13 51 6
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 2
Equipo PJ GF GC Puntos
1 Kastrioti Krujë Kastrioti 6 10 9 47
2 Besëlidhja Lezhë Besëlidhja 6 11 7 39
3 Korabi Peshkopi Korabi 6 10 7 36
4 Erzeni Shijak Erzeni 6 7 15 26
5 Apolonia Fier Apolonia 6 19 12 51
6 Pogradeci Pogradeci 6 9 9 46
7 Lushnja Lushnja 6 12 11 44
8 Besa Kavajë Besa Kavajë 6 14 22 31
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 2
Equipo PJ GF GC Puntos
1 Kastrioti Krujë Kastrioti 7 13 3 39
2 Besëlidhja Lezhë Besëlidhja 8 6 10 32
3 KF Egnatia KF Egnatia 7 10 9 27
4 Erzeni Shijak Erzeni 7 9 10 25
5 Dinamo City Dinamo City 7 4 10 2
6 KF Tirana KF Tirana 7 18 6 42
7 Bylis Ballsh Bylis Ballsh 7 8 9 29
8 Apolonia Fier Apolonia 7 6 10 23
9 Pogradeci Pogradeci 8 10 15 22
10 Tomori Berat Tomori Berat 7 10 12 8
TEMPORADA 2016/2017
PRIMERA ALBANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Kamza Kamza 18 25 7 47
2 Besëlidhja Lezhë Besëlidhja 18 26 11 39
3 Erzeni Shijak Erzeni 18 32 14 37
4 Burreli Burreli 18 18 16 26
5 Shenkolli Shenkolli 18 16 23 23
6 Kastrioti Krujë Kastrioti 18 18 14 22
7 Besa Kavajë Besa Kavajë 18 10 18 18
8 Mamurrasi Mamurrasi 18 12 25 14
9 KF Iliria KF Iliria 18 12 26 14
10 Tërbuni Pukë Tërbuni 18 6 21 10
11 Lushnja Lushnja 18 31 12 41
12 Bylis Ballsh Bylis Ballsh 18 23 10 38
13 Pogradeci Pogradeci 18 21 16 29
14 Tomori Berat Tomori Berat 18 11 12 23
15 Apolonia Fier Apolonia 18 19 20 22
16 Shkumbini Peqin Shkumbini 18 10 18 22
17 Turbina Cërrik Turbina 18 16 20 21
18 Dinamo City Dinamo City 18 12 13 18
19 Sopoti Librazhd Sopoti 18 17 26 16
20 KF Elbasani KF Elbasani 18 15 28 16
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 2
Equipo PJ GF GC Puntos
1 Bylis Ballsh Bylis Ballsh 27 46 26 53
2 Lushnja Lushnja 27 36 18 53
3 Butrinti Sarandë Butrinti 27 34 22 41
4 Sopoti Librazhd Sopoti 27 31 34 36
5 KF Luftëtari Luftëtari 27 24 29 34
6 Dinamo City Dinamo City 27 27 26 33
7 Shkumbini Peqin Shkumbini 27 29 33 31
8 Pogradeci Pogradeci 27 21 29 31
9 Tomori Berat Tomori Berat 27 21 38 29
10 Naftëtari Kuçovë Naftëtari 27 18 32 25
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
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Skënderbeu Korçë Skënderbeu 26 45 16 57
2 Teuta Durrës Teuta 26 33 18 56
3 KF Tirana KF Tirana 26 33 21 53
4 Flamurtari Vlorë Flamurtari 26 42 20 46
5 Kastrioti Krujë Kastrioti 26 37 30 38
6 Bylis Ballsh Bylis Ballsh 26 40 37 35
7 Vllaznia Shkodër Vllaznia 26 39 33 35
8 Laçi Laçi 26 26 28 34
9 Shkumbini Peqin Shkumbini 26 37 45 31
10 Tomori Berat Tomori Berat 26 36 47 28
11 Kamza Kamza 26 22 32 27
12 Apolonia Fier Apolonia 26 27 46 21
13 Pogradeci Pogradeci 26 25 47 19
14 Dinamo City Dinamo City 26 19 41 13
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,557,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1182
Total Execution Time  0.1195
  CADENA URL  
/historico/Pogradeci
  GET DATOS  
$_GET['/historico/Pogradeci']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0040  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 = 'Pogradeci' 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.0018  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=6403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74170
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6403 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=289 AND type_rel = 3
0.0027  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 = '6403' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74170 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 74170 AND t.round = 21 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030  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 = 6403 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74170 AND t.round = 21 ORDER BY team.conference ASC,t.position 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 `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 = 69715 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.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 `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.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 = 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.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 `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.0032  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.0020  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 = 55615 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.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 `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.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 = 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.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 `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.0030  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 = 43047 AND t.round = 10 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 `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.0029  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.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 `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.0021  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 = 9277 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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.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 `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.0021  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 = 1572 AND t.round = 26 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 `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.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 `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