4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del MOIK
TEMPORADA 2023/2024
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Qaradag FK Qaradag 23 39 15 49
2 Imisli FK Imisli FK 23 36 16 46
3 Shamakhi Shamakhi 23 49 19 45
4 MOIK MOIK 23 44 23 42
5 Karvan FK Karvan FK 23 30 28 35
6 Zaqatala Zaqatala 23 28 30 26
7 Mingachevir FK Mingachevir 23 17 32 25
8 Iravan Iravan 23 25 48 23
9 Difai Agsu Difai Agsu 23 27 40 17
10 Araz Saatli Araz Saatli 23 24 68 10
TEMPORADA 2022/2023
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Araz PFK Araz PFK 28 69 22 69
2 Neftçi II Neftçi II 28 67 32 59
3 Turan-T II Turan-T II 28 49 37 48
4 Qəbələ II Qəbələ 28 45 28 44
5 Səbail II Səbail II 28 46 44 44
6 Zaqatala Zaqatala 28 49 48 44
7 FC Kapaz II FC Kapaz II 28 41 36 43
8 MOIK MOIK 28 43 42 43
9 FK Qaradag FK Qaradag 28 30 23 41
10 Shamakhi FK II Shamakhi 28 40 56 37
11 Qarabag II Qarabag II 28 32 39 31
12 Zirə II Zirə II 28 28 41 28
13 Sumqayıt II Sumqayıt 28 36 60 22
14 Mingachevir FK Mingachevir 28 29 51 20
15 Imisli FK Imisli FK 28 21 66 20
TEMPORADA 2021/2022
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Qaradag FK Qaradag 24 48 14 55
2 Shamakhi FK II Shamakhi 24 46 23 44
3 Qarabag II Qarabag II 24 39 22 42
4 Sabah II Sabah II 24 37 29 39
5 Neftçi II Neftçi II 24 43 36 38
6 FC Kapaz FC Kapaz 24 35 31 36
7 MOIK MOIK 24 34 34 36
8 Zaqatala Zaqatala 24 35 34 33
9 Qəbələ II Qəbələ 24 36 37 33
10 Turan-T Turan-T 24 37 39 33
11 Sumqayıt II Sumqayıt 24 19 40 20
12 Səbail II Səbail II 24 24 56 15
13 Zirə II Zirə II 24 16 54 12
TEMPORADA 2020/2021
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Neftçi II Neftçi II 27 64 17 64
2 Zaqatala Zaqatala 27 54 34 56
3 Turan-T Turan-T 27 41 22 51
4 Sabah II Sabah II 27 47 37 45
5 Qarabag II Qarabag II 27 30 28 34
6 Shamakhi FK II Shamakhi 27 32 54 31
7 FK Qaradag FK Qaradag 27 29 41 29
8 FC Kapaz FC Kapaz 27 30 38 28
9 Sumqayıt II Sumqayıt 27 26 49 22
10 MOIK MOIK 27 30 63 20
TEMPORADA 2019/2020
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Turan-T Turan-T 17 29 18 37
2 Səbail II Səbail II 18 30 11 36
3 Zaqatala Zaqatala 17 36 16 35
4 Sabah II Sabah II 18 29 19 32
5 Neftçi II Neftçi II 18 27 15 29
6 FC Kapaz FC Kapaz 18 23 19 28
7 Shamakhi FK II Shamakhi 17 28 22 25
8 Sumqayıt II Sumqayıt 17 19 24 24
9 Qarabag II Qarabag II 17 36 21 24
10 MOIK MOIK 16 19 22 19
11 FC Agsu FC Agsu 18 13 45 13
12 Zirə II Zirə II 17 18 41 11
13 FK Qaradag FK Qaradag 18 10 44 7
TEMPORADA 2018/2019
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 MOIK MOIK 26 51 21 65
2 Sumqayıt II Sumqayıt 26 68 29 59
3 Neftçi II Neftçi II 26 51 28 52
4 Zaqatala Zaqatala 26 51 30 47
5 Qarabag II Qarabag II 26 51 35 45
6 Shamakhi FK II Shamakhi 26 41 32 40
7 AZAL PFC Baku AZAL Baku 26 31 25 40
8 Sabah II Sabah II 26 27 20 38
9 FK Qaradag FK Qaradag 26 24 39 30
10 Səbail II Səbail II 26 37 57 27
11 FC Kapaz FC Kapaz 26 22 40 24
12 Turan-T Turan-T 26 29 54 20
13 FC Agsu FC Agsu 26 24 62 17
14 Zirə II Zirə II 26 23 58 15
TEMPORADA 2017/2018
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Xəzər Xəzər 27 40 18 50
2 FK Qaradag FK Qaradag 27 44 31 46
3 AZAL PFC Baku AZAL Baku 27 30 20 45
4 MOIK MOIK 27 41 30 45
5 Sabah Sabah 27 41 33 40
6 Turan-T Turan-T 27 34 33 39
7 Binə Binə 27 31 37 33
8 FK Mugan FK Mugan 27 32 48 30
9 FC Agsu FC Agsu 27 25 48 28
10 Zaqatala Zaqatala 27 22 42 19
TEMPORADA 2016/2017
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Turan-T Turan-T 26 62 11 61
2 FK Sabail FK Sabail 26 80 25 57
3 FC Agsu FC Agsu 26 63 21 53
4 FK Qaradag FK Qaradag 26 64 31 52
5 Zaqatala Zaqatala 26 69 31 49
6 Shamkir Shamkir 26 41 20 48
7 FK Mugan FK Mugan 26 53 33 44
8 MOIK MOIK 26 47 31 36
9 Sahdah Sahdah 26 36 45 30
10 Şərurspor Şərurspor 25 36 51 25
11 Mingachevir FK Mingachevir 26 25 86 20
12 Bakili Bakili 26 30 99 11
13 Ravan Baku Ravan Baku 25 24 67 10
14 Göyazan Qazakh Göyazan 26 20 99 10
TEMPORADA 2015/2016
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Neftchala Neftchala 26 74 20 62
2 FK Qaradag FK Qaradag 26 59 28 58
3 MOIK MOIK 26 53 24 47
4 FC Agsu FC Agsu 26 46 29 47
5 Shamkir Shamkir 26 30 24 38
6 Zaqatala Zaqatala 26 47 36 36
7 Turan-T Turan-T 26 35 31 36
8 FK Mugan FK Mugan 26 28 26 32
9 FK Baku FK Baku 26 33 42 30
10 Bakili Bakili 26 34 46 30
11 Sahdah Sahdah 26 31 54 30
12 Şərurspor Şərurspor 26 45 44 28
13 Göyazan Qazakh Göyazan 26 17 42 17
14 Mingachevir FK Mingachevir 26 14 100 15
TEMPORADA 2014/2015
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Neftchala Neftchala 30 83 19 78
2 FC Agsu FC Agsu 30 70 22 67
3 Ravan Baku Ravan Baku 30 70 22 67
4 FK Qaradag FK Qaradag 30 57 25 65
5 Zira FK Zira FK 30 61 19 63
6 Turan-T Turan-T 30 75 37 50
7 Sahdah Sahdah 30 40 29 47
8 Susa Susa 30 49 31 46
9 FC Kapaz FC Kapaz 30 37 37 38
10 Bakili Bakili 30 46 61 34
11 Shamkir Shamkir 30 25 46 32
12 MOIK MOIK 30 26 60 29
13 FK Mugan FK Mugan 30 30 65 26
14 Mingachevir FK Mingachevir 30 24 82 18
15 Göyazan Qazakh Göyazan 30 15 91 12
16 Lokomotiv-Biləcəri Lokomotiv-Bi 30 10 72 10
TEMPORADA 2013/2014
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Araz PFK Araz PFK 30 66 11 79
2 FK Neftchala Neftchala 30 80 22 68
3 FK Qaradag FK Qaradag 30 52 14 63
4 FC Agsu FC Agsu 30 56 26 58
5 Sahdah Sahdah 30 55 22 55
6 Susa Susa 30 60 26 54
7 Turan-T Turan-T 30 52 46 44
8 Karvan FK Karvan FK 30 46 56 42
9 FK Mugan FK Mugan 30 29 33 40
10 Lokomotiv Balajary Lokomotiv 30 42 58 39
11 Shamkir Shamkir 30 28 42 31
12 MOIK MOIK 30 37 56 29
13 FC Kapaz FC Kapaz 30 29 37 25
14 Bakili Bakili 30 34 60 24
15 Göyazan Qazakh Göyazan 30 13 89 11
16 Mingachevir FK Mingachevir 30 11 92 11
TEMPORADA 2012/2013
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Qaradag FK Qaradag 23 59 8 60
2 FC Agsu FC Agsu 22 62 16 59
3 FK Neftchala Neftchala 22 45 15 51
4 Sahdah Sahdah 22 36 25 41
5 MOIK MOIK 22 33 28 35
6 Taraggi Taraggi 22 21 24 31
7 Bakili Bakili 22 30 32 27
8 Susa Susa 23 27 38 22
9 Lokomotiv Balajary Lokomotiv 22 26 38 20
10 FC Qala FC Qala 22 21 45 18
11 Mingachevir FK Mingachevir 22 24 51 16
12 Shamkir Shamkir 22 22 48 15
13 Göyazan Qazakh Göyazan 22 19 57 15
TEMPORADA 2011/2012
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Qaradag FK Qaradag 13 25 3 34
2 FK Neftchala Neftchala 13 24 6 30
3 Sahdah Sahdah 12 22 13 26
4 Karvan FK Karvan FK 12 21 13 23
5 FK Mugan FK Mugan 12 19 16 19
6 Susa Susa 12 14 11 18
7 Bakili Bakili 12 16 12 17
8 Araz PFK Araz PFK 12 15 18 17
9 Shamkir Shamkir 12 20 20 16
10 Taraggi Taraggi 12 15 16 15
11 Lokomotiv Balajary Lokomotiv 12 15 19 14
12 MOIK MOIK 12 17 23 9
13 Mingachevir FK Mingachevir 12 9 29 6
14 Göyazan Qazakh Göyazan 12 9 42 0
TEMPORADA 2010/2011
LIGA AZERBAIYÁN GRUPO 3
Equipo PJ GF GC Puntos
1 Gabala FK Gabala FK 10 12 4 51
2 FK Mugan FK Mugan 10 15 8 47
3 FC Kapaz FC Kapaz 10 10 10 36
4 Turan-T Turan-T 10 7 12 27
5 Simurq Simurq 10 8 18 19
6 MOIK MOIK 10 8 8 18
TEMPORADA 2009/2010
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FC Kapaz FC Kapaz 22 51 15 47
2 MOIK MOIK 22 48 25 47
3 Bakili Bakili 22 41 19 43
4 FK Qaradag FK Qaradag 22 38 26 39
5 Araz PFK Araz PFK 22 41 29 38
6 Ravan Baku Ravan Baku 22 32 28 37
7 ABN Barda ABN Barda 22 31 23 36
8 Sahdah Sahdah 22 33 24 32
9 FK Neftchala Neftchala 22 25 61 17
10 Mingachevir FK Mingachevir 22 24 51 15
11 FK Adliyye FK Adliyye 22 16 40 14
12 Göyazan Qazakh Göyazan 22 16 55 7
TEMPORADA 2008/2009
LIGA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Baku FK Baku 26 54 13 62
2 Shamakhi Shamakhi 26 54 16 61
3 Simurq Simurq 26 39 20 53
4 Khazar Lankaran Khazar 26 49 21 50
5 Gabala FK Gabala FK 26 35 22 49
6 AZAL PFC Baku AZAL Baku 26 32 18 44
7 Standard Sumgayit Standard 26 30 31 39
8 Neftçi Neftçi 26 30 21 36
9 Karvan FK Karvan FK 26 28 33 34
10 Qarabağ Qarabağ 26 28 21 33
11 Turan-T Turan-T 26 19 45 20
12 FK Mugan FK Mugan 26 19 53 14
13 Bakili Bakili 26 14 65 12
14 MOIK MOIK 26 12 64 5
TEMPORADA 2007/2008
SEGUNDA AZERBAIYÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Araz PFK Araz PFK 16 29 11 35
2 MOIK MOIK 16 26 15 34
3 Sahdah Sahdah 16 23 9 33
4 Göyazan Qazakh Göyazan 16 35 19 27
5 Neftçi II Neftçi II 8 14 4 18
6 Mingachevir FK Mingachevir 16 19 25 16
7 Khazar Lankaran II Khazar 16 13 26 10
8 Turan-T II Turan-T II 16 13 33 10
9 FK Qaradag FK Qaradag 8 6 12 8
10 Standard Sumgayit II Standard 16 10 34 8
TEMPORADA 2005/2006
LIGA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Baku FK Baku 26 42 12 58
2 Karvan FK Karvan FK 26 50 9 57
3 Neftçi Neftçi 26 51 16 54
4 Shamakhi Shamakhi 26 35 14 50
5 Qarabağ Qarabağ 26 32 31 40
6 Turan-T Turan-T 26 27 21 38
7 Khazar Lankaran Khazar 26 26 18 36
8 Araz PFK Araz PFK 26 31 36 35
9 Sahdah Sahdah 26 24 36 33
10 FC Kapaz FC Kapaz 26 35 42 29
11 Sumgayit Sumgayit 26 25 37 27
12 AZAL PFC Baku AZAL Baku 26 15 27 23
13 Göyazan Qazakh Göyazan 26 14 52 9
14 MOIK MOIK 26 11 67 9
TEMPORADA 2004/2005
LIGA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Khazar Lankaran Khazar 34 68 15 78
2 Neftçi Neftçi 34 52 18 78
3 Karvan FK Karvan FK 34 66 18 76
4 FK Baku FK Baku 34 59 14 73
5 Turan-T Turan-T 34 64 21 73
6 Qarabağ Qarabağ 34 61 31 71
7 Shamakhi Shamakhi 34 44 23 66
8 Araz PFK Araz PFK 34 35 23 57
9 FC Kapaz FC Kapaz 34 37 37 42
10 Karat Karat 34 40 62 40
11 Göyazan Qazakh Göyazan 34 30 52 33
12 Sumgayit Sumgayit 34 30 57 33
13 Shamkir Shamkir 34 34 48 32
14 Sahdah Sahdah 34 29 51 32
15 MOIK MOIK 34 24 34 30
16 FK Adliyye FK Adliyye 34 24 66 25
17 Bakili Bakili 34 21 69 14
18 FK Safa FK Safa 34 16 95 7

  USO DE MEMORIA  
6,806,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6450
Total Execution Time  0.6469
  CADENA URL  
/historico/Moik
  GET DATOS  
$_GET['/historico/Moik']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0178  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 = 'Moik' 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.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=15207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=15207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=15207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 74494
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15207 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=516 AND type_rel = 3
0.0135  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 = '15207' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient 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 = '15207' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 74494 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 = 73994 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=15207 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (74494,73994) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73994 AND teamId = 15207
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 74494 AND teamId = 15207
0.0127  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 = '15207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15207' and rp.type = 4
0.0127  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 = '15207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0132  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 = 73994 WHERE rp.league_id = 73994 AND rp.teamId = 15207 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.0130  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 = 73994 WHERE rp.league_id = 73994 AND rp.teamId = 15207 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73994 WHERE rp.league_id = 73994 AND rp.teamId = 15207 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 15207 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64274 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 `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 = 60163 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.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 `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 = 51065 AND t.round = 19 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 `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 = 45097 AND t.round = 26 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 `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 = 40388 AND t.round = 27 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 `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 = 35342 AND t.round = 26 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 = 15774 AND t.round = 26 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 `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 = 4842 AND t.round = 30 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 `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 = 3288 AND t.round = 30 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 `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 = 8936 AND t.round = 24 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 `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 = 8933 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 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 = 8917 AND t.round = 22 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 `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 = 10076 AND t.round = 10 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 `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 = 8931 AND t.round = 22 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 `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 = 8913 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 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 = 8923 AND t.round = 15 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 `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 = 8907 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 `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 = 8905 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC