4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ironi Baka El Garbiya
TEMPORADA 2023/2024
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Raanana Hapoel 29 56 15 68
2 FC Tira FC Tira 29 56 28 56
3 Maccabi Kiryat Ata Bialik Maccabi 29 40 21 54
4 Kiryat Yam Kiryat Yam 29 56 31 53
5 Ironi Baka El Garbiya Ironi Baka. 29 43 24 53
6 Hapoel Bnei Zalafa Hapoel Bnei 29 46 45 38
7 Tzeirei Kfar Kanna Tzeirei Kfar 29 44 51 36
8 Maccabi Ahi Nazareth Maccabi 29 39 35 35
9 Hapoel Bueine Hapoel 29 41 39 34
10 Hapoel Migdal Hapoel 29 32 46 32
11 Tzeirei Umm Al-Fahm Tzeirei 29 38 53 32
12 Ironi Nesher Ironi Nesher 29 30 43 31
13 Hapoel Kfar Kana Hapoel Kfar 29 36 52 31
14 Maccabi Nujeidat Ahmed Maccabi 29 21 47 25
15 Tzeirey Taibe Tzeirey 29 32 45 24
16 Hapoel Kaukab Hapoel 29 22 57 16
TEMPORADA 2022/2023
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Ihud Bnei Shfaram Ihud Bnei S. 30 67 28 66
2 Tzeirei Kfar Kanna Tzeirei Kfar 30 56 24 60
3 Ironi Baka El Garbiya Ironi Baka. 30 60 22 59
4 Hapoel Raanana Hapoel 30 42 26 50
5 Hapoel Bnei Zalafa Hapoel Bnei 30 52 49 42
6 Maccabi Kiryat Ata Bialik Maccabi 30 40 40 40
7 Ironi Nesher Ironi Nesher 30 45 52 38
8 Maccabi Nujeidat Ahmed Maccabi 30 29 29 37
9 FC Tira FC Tira 30 38 42 37
10 Tzeirey Taibe Tzeirey 30 37 39 36
11 Hapoel Migdal Hapoel 30 51 61 36
12 Hapoel Kfar Kana Hapoel Kfar 30 46 61 35
13 Hapoel Kaukab Hapoel 30 33 44 34
14 Hapoel Bueine Hapoel 30 29 42 33
15 Hapoel Qalansawe Hapoel 30 24 53 31
16 Maccabi Ironi Tamra Maccabi 30 29 66 21
TEMPORADA 2021/2022
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Ironi Tiberias Ironi 34 60 24 72
2 FC Tira FC Tira 34 66 50 58
3 Tzeirey Taibe Tzeirey 34 50 29 57
4 Hapoel Herzliya Hapoel 34 59 41 56
5 Hapoel Bueine Hapoel 34 46 34 55
6 Maccabi Ironi Tamra Maccabi 34 46 41 54
7 Hapoel Bnei Zalafa Hapoel Bnei 34 52 39 54
8 Ironi Baka El Garbiya Ironi Baka. 34 52 39 52
9 Maccabi Kiryat Ata Bialik Maccabi 34 43 33 50
10 Hapoel Kfar Kana Hapoel Kfar 34 56 54 48
11 Tzeirei Kfar Kanna Tzeirei Kfar 34 69 52 48
12 Ironi Nesher Ironi Nesher 34 48 37 46
13 Hapoel Kaukab Hapoel 34 62 50 45
14 Hapoel Migdal Hapoel 34 41 49 42
15 Hapoel Bnei Fureidis Hapoel Bnei 34 41 67 36
16 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 34 38 66 26
17 Hapoel Iksal Hapoel Iksal 34 26 94 26
18 Rubi Shapira Rubi Shapira 34 34 90 24
TEMPORADA 2020/2021
TERCERA ISRAEL GRUPO 8
Equipo PJ GF GC Puntos
1 Hapoel Bnei Zalafa Hapoel Bnei 6 13 9 12
2 Rubi Shapira Rubi Shapira 6 14 5 11
3 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 6 13 11 11
4 Hapoel Migdal Hapoel 6 11 13 8
5 Ironi Baka El Garbiya Ironi Baka. 6 7 13 7
6 Tzeirey Taibe Tzeirey 6 9 11 5
7 Daburiyya Osama Daburiyya 6 3 8 3
TEMPORADA 2019/2020
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Iksal Hapoel Iksal 21 39 12 47
2 Hapoel Kaukab Hapoel 22 37 16 46
3 FC Tira FC Tira 22 31 19 40
4 Rubi Shapira Rubi Shapira 21 26 18 37
5 Maccabi Ironi Tamra Maccabi 21 28 22 31
6 Maccabi Kiryat Ata Bialik Maccabi 22 27 26 28
7 Ironi Baka El Garbiya Ironi Baka. 21 25 25 28
8 Hapoel Bnei Zalafa Hapoel Bnei 21 27 31 28
9 Hapoel Herzliya Hapoel 22 25 32 26
10 Hapoel Kfar Kana Hapoel Kfar 22 22 30 24
11 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 22 20 27 22
12 Daburiyya Osama Daburiyya 21 18 32 20
13 Ironi Tiberias Ironi 22 17 29 19
14 Hapoel Migdal Hapoel 21 24 29 18
15 Maccabi Kiryat Ata Maccabi 21 18 36 15
16 Hapoel Asi Gilboa Hapoel 0 0 0 0
TEMPORADA 2018/2019
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Umm al-Fahm Hapoel 28 55 19 63
2 Ironi Baka El Garbiya Ironi Baka. 28 52 31 48
3 Hapoel Herzliya Hapoel 28 40 34 46
4 Hapoel Kaukab Hapoel 28 44 41 46
5 FC Tira FC Tira 28 41 32 39
6 Hapoel Kfar Kana Hapoel Kfar 28 41 51 37
7 Rubi Shapira Rubi Shapira 28 39 28 36
8 Hapoel Bnei Zalafa Hapoel Bnei 28 31 34 34
9 Maccabi Kiryat Ata Maccabi 28 28 31 34
10 Hapoel Asi Gilboa Hapoel 28 35 43 34
11 Hapoel Migdal Hapoel 28 28 38 34
12 Ironi Tiberias Ironi 28 29 42 34
13 Maccabi Kiryat Ata Bialik Maccabi 28 26 31 33
14 Ironi Nesher Ironi Nesher 28 31 44 33
15 Hapoel Jerusalem Hapoel 28 32 53 31
16 Hapoel Shfara'am Hapoel 0 0 0 0
TEMPORADA 2017/2018
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Iksal Hapoel Iksal 30 70 34 63
2 Hapoel Umm al-Fahm Hapoel 30 50 20 58
3 Hapoel Herzliya Hapoel 30 53 21 57
4 Rubi Shapira Rubi Shapira 30 49 24 54
5 Ironi Tiberias Ironi 30 56 26 51
6 Hapoel Jerusalem Hapoel 30 39 22 48
7 Hapoel Shfara'am Hapoel 30 47 50 45
8 Ironi Baka El Garbiya Ironi Baka. 30 33 38 42
9 Maccabi Kiryat Ata Maccabi 30 34 29 40
10 FC Tira FC Tira 30 38 43 40
11 Maccabi Kiryat Ata Bialik Maccabi 30 42 42 36
12 Hapoel Asi Gilboa Hapoel 30 37 42 36
13 Hapoel Kfar Kana Hapoel Kfar 30 45 48 34
14 Hapoel Migdal Hapoel 30 35 52 30
15 Hapoel Beit Shean Hapoel Beit 30 23 73 16
16 Maccabi Daliyat Maccabi 30 15 102 10
TEMPORADA 2016/2017
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Hadera Hapoel 28 58 18 64
2 Rubi Shapira Rubi Shapira 28 51 24 55
3 Hapoel Iksal Hapoel Iksal 28 49 28 54
4 Ironi Tiberias Ironi 28 34 24 48
5 Hapoel Herzliya Hapoel 28 38 32 42
6 Hapoel Beit Shean Hapoel Beit 28 34 30 42
7 Maccabi Kiryat Ata Maccabi 28 38 32 37
8 Hapoel Migdal Hapoel 28 23 30 31
9 Hapoel Asi Gilboa Hapoel 28 20 37 30
10 Maccabi Kiryat Ata Bialik Maccabi 28 34 45 29
11 FC Tira FC Tira 28 22 35 29
12 Maccabi Daliyat Maccabi 28 34 51 29
13 Ironi Baka El Garbiya Ironi Baka. 28 23 44 28
14 Hapoel Kfar Kana Hapoel Kfar 28 22 30 27
15 Tzeirey Kfar Kana Tzeirey Kfar 28 20 40 25
16 Karmiel Safed Karmiel 0 0 0 0
TEMPORADA 2015/2016
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Ironi Nesher Ironi Nesher 30 52 18 64
2 Hapoel Hadera Hapoel 30 49 32 53
3 Ironi Tiberias Ironi 30 35 20 51
4 Hapoel Herzliya Hapoel 30 46 29 49
5 Maccabi Kiryat Ata Maccabi 30 35 23 45
6 Hapoel Kfar Kana Hapoel Kfar 30 30 31 43
7 Ironi Baka El Garbiya Ironi Baka. 30 34 29 42
8 Karmiel Safed Karmiel 30 36 43 39
9 Hapoel Migdal Hapoel 30 33 40 38
10 Hapoel Beit Shean Hapoel Beit 30 26 35 38
11 Hapoel Iksal Hapoel Iksal 30 32 33 37
12 Hapoel Asi Gilboa Hapoel 30 34 31 36
13 Maccabi Kiryat Ata Bialik Maccabi 30 28 37 36
14 Maccabi Daliyat Maccabi 30 33 36 29
15 Maccabi Ma'alot Tarshiha Maccabi 30 25 52 28
16 Hapoel Mejdel Krum Hapoel 30 16 55 17

  USO DE MEMORIA  
6,000,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5652
Total Execution Time  0.5665
  CADENA URL  
/historico/Hapoel-Ironi-Baka-El-Garbiya
  GET DATOS  
$_GET['/historico/Hapoel-Ironi-Baka-El-Garbiya']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0174  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 = 'Hapoel-Ironi-Baka-El-Garbiya' 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=80510 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=80510 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=80510 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 = 73895
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80510 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1570 AND type_rel = 3
0.0133  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 = '80510' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '80510' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '80510' 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 = 73895 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=80510 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 (73895,73841,67320) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73895 AND teamId = 80510
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 80510
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 80510
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 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 = 73895 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '80510' 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 = '80510' 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 = '80510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 = 73895 WHERE rp.league_id = 73895 AND rp.teamId = 80510 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 = 73895 WHERE rp.league_id = 73895 AND rp.teamId = 80510 AND (e.action = 4 or e.action = 5) 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 = 73895 WHERE rp.league_id = 73895 AND rp.teamId = 80510 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 80510 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73895 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 68502 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.0143  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 = 64365 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 59151 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.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 `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 = 62214 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.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 = 51096 AND t.round = 23 ORDER BY team.conference ASC,t.position 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 `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 = 44793 AND t.round = 30 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 `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 = 39728 AND t.round = 30 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 `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 = 36093 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 `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 = 15640 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC