4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gostivar

Gostivar

Entrenador: Ismail Atalan

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Struga Struga 29 50 28 58
2 Shkupi Shkupi 29 40 18 58
3 KF Shkëndija Shkëndija 29 48 23 55
4 Sileks Sileks 29 33 35 41
5 Tikves Tikves 29 35 33 39
6 AP Brera AP Brera 29 26 26 37
7 Gostivar Gostivar 29 29 36 37
8 Rabotnički Rabotnički 29 25 31 35
9 Voska Sport Voska Sport 29 32 39 34
10 Vardar Skopje Vardar 29 21 40 29
11 Makedonija GP Makedonija 29 24 35 26
12 Bregalnica Štip Bregalnica 29 24 43 26
TEMPORADA 2022/2023
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Voska Sport Voska Sport 30 84 25 75
2 Gostivar Gostivar 30 71 11 73
3 Vardar Skopje Vardar 30 55 20 63
4 Pelister Pelister 30 64 26 58
5 Detonit Plachkovica Detonit 30 43 35 50
6 KF Besa KF Besa 30 43 29 48
7 FK Ohrid FK Ohrid 30 31 35 41
8 Aresimi Aresimi 30 41 35 40
9 Kozuv Gevgelija Kozuv 30 40 54 36
10 Belasica Belasica 30 36 47 35
11 Karaorman Struga Karaorman 30 30 40 34
12 Sasa Sasa 30 31 49 31
13 Teteks Teteks 30 31 78 31
14 Lokomotiva Skopje Lokomotiva 30 35 41 30
15 Sloga Vinica Sloga Vinica 30 26 47 25
16 FK Borec FK Borec 30 13 102 2
TEMPORADA 2021/2022
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Sileks Sileks 27 55 9 66
2 Voska Sport Voska Sport 27 51 14 59
3 Vardar Skopje Vardar 27 47 15 58
4 Gostivar Gostivar 27 36 37 37
5 Teteks Teteks 27 32 44 36
6 KF Besa KF Besa 27 41 28 35
7 FK Ohrid FK Ohrid 27 34 32 32
8 FK Korab FK Korab 27 33 43 27
9 Veleshta Veleshta 27 25 61 18
10 Kadino Skopje Kadino 27 13 84 7
TEMPORADA 2020/2021
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 FK Skopje FK Skopje 26 50 20 60
2 FK Ohrid FK Ohrid 26 26 13 46
3 Veleshta Veleshta 26 32 23 46
4 Gostivar Gostivar 26 33 30 43
5 FK Korab FK Korab 26 28 27 36
6 Kadino Skopje Kadino 26 24 24 28
7 Velazerimi 77 Velazerimi 26 26 34 27
8 Labunishta Labunishta 26 19 34 27
9 Drita Bogovinje Drita 26 28 41 21
10 Vardari Forino Vardari 18 15 35 13
TEMPORADA 2019/2020
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Pelister Pelister 16 32 14 33
2 FK Skopje FK Skopje 16 21 14 29
3 Labunishta Labunishta 16 25 18 27
4 Velazerimi 77 Velazerimi 16 15 19 25
5 Gostivar Gostivar 16 21 19 23
6 Vardari Forino Vardari 16 23 21 21
7 FK Korab FK Korab 16 24 23 21
8 Drita Bogovinje Drita 16 19 20 21
9 FK Ohrid FK Ohrid 16 15 29 14
10 Kadino Skopje Kadino 16 15 33 10
TEMPORADA 2018/2019
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Struga Struga 18 20 13 34
2 Gostivar Gostivar 18 29 22 27
3 Labunishta Labunishta 18 14 14 27
4 FK Skopje FK Skopje 18 21 14 26
5 Pelister Pelister 18 15 15 26
6 Velazerimi 77 Velazerimi 18 22 21 25
7 FK Korab FK Korab 18 23 21 23
8 FK Goblen FK Goblen 18 14 20 20
9 Gench Kalemler Gench 18 19 26 18
10 Teteks Teteks 18 14 25 16
TEMPORADA 2017/2018
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Makedonija GP Makedonija 27 49 23 56
2 Gostivar Gostivar 27 48 26 54
3 Vëllazërimi Vëllazërim 27 46 25 53
4 Struga Struga 27 44 30 45
5 Labunishta Labunishta 27 38 24 42
6 Teteks Teteks 27 40 42 39
7 Gorno Lisiče Gorno 27 32 46 35
8 Lokomotiva Skopje Lokomotiva 27 30 41 26
9 Zajazi Zajas Zajazi Zajas 27 24 62 17
10 Novaci Novaci 27 22 54 9
TEMPORADA 2015/2016
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Pobeda Junior Pobeda 27 40 23 47
2 Makedonija GP Makedonija 27 35 33 46
3 Teteks Teteks 27 27 25 39
4 Pelister Pelister 27 33 32 39
5 Vëllazërimi Vëllazërim 27 30 30 38
6 FK Skopje FK Skopje 27 27 23 36
7 Gorno Lisiče Gorno 27 26 29 36
8 Ljubanci Ljubanci 27 32 31 34
9 Gostivar Gostivar 27 29 34 33
10 Kozuv Gevgelija Kozuv 27 17 36 17
TEMPORADA 2014/2015
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Shkupi Shkupi 27 44 19 53
2 Mladost CD Mladost CD 27 40 27 47
3 Gostivar Gostivar 27 31 27 44
4 Makedonija GP Makedonija 27 29 18 41
5 FK Skopje FK Skopje 27 27 19 39
6 Vrapciste Vrapciste 27 31 24 39
7 Kozuv Gevgelija Kozuv 27 28 20 38
8 Gorno Lisiče Gorno 27 29 38 35
9 Drita Bogovinje Drita 27 26 38 27
10 Napredok Kičevo Napredok 27 23 78 9
TEMPORADA 2013/2014
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Rabotnički Rabotnički 33 66 35 62
2 Turnovo Turnovo 33 61 33 60
3 Metalurg Skopje Metalurg 33 48 29 59
4 KF Shkëndija Shkëndija 33 53 32 57
5 Vardar Skopje Vardar 33 55 32 56
6 Pelister Pelister 33 40 40 52
7 Bregalnica Štip Bregalnica 33 34 34 44
8 Renova Renova 33 42 46 44
9 Gorno Lisiče Gorno 33 34 37 39
10 Makedonija GP Makedonija 33 40 56 32
11 Napredok Kičevo Napredok 33 27 75 18
12 Gostivar Gostivar 33 19 70 15
TEMPORADA 2012/2013
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Makedonija GP Makedonija 30 60 21 67
2 Gostivar Gostivar 30 55 17 65
3 FK Skopje FK Skopje 30 59 18 63
4 Gorno Lisiče Gorno 30 47 16 61
5 FK Rufeja FK Rufeja 30 46 19 56
6 Miravci Miravci 30 50 29 53
7 Pobeda Junior Pobeda 30 34 44 39
8 Vrapciste Vrapciste 30 39 41 37
9 FK Korzo FK Korzo 30 42 42 35
10 Madzari Solidarnost Madzari 30 39 44 34
11 Novaci Novaci 30 40 57 34
12 Lokomotiva Skopje Lokomotiva 30 41 53 33
13 11 Oktomvri 11 Oktomvri 30 40 55 33
14 Babi Štip Babi Štip 30 35 44 30
15 Tikves Tikves 30 24 76 19
16 FK Ohrid FK Ohrid 30 25 100 13
TEMPORADA 2011/2012
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Pelister Pelister 30 42 23 61
2 Drita Bogovinje Drita 30 49 19 58
3 Gorno Lisiče Gorno 30 60 30 56
4 FK Skopje FK Skopje 30 50 26 56
5 Miravci Miravci 30 46 23 54
6 Makedonija GP Makedonija 30 48 31 48
7 Tikves Tikves 30 45 41 45
8 FK Rufeja FK Rufeja 30 48 35 44
9 Lokomotiva Skopje Lokomotiva 30 35 33 43
10 Gostivar Gostivar 30 39 34 41
11 Pobeda Junior Pobeda 30 36 38 41
12 FK Korab FK Korab 30 34 45 36
13 Vëllazërimi Vëllazërim 30 28 68 29
14 Osogovo Osogovo 30 29 64 22
15 Ohrid Lote Ohrid Lote 30 24 74 19
16 Belasica Belasica 30 27 56 18
TEMPORADA 2010/2011
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 11 Oktomvri 11 Oktomvri 26 50 19 54
2 FK Ohrid FK Ohrid 26 51 21 53
3 Tikves Tikves 26 45 27 48
4 Miravci Miravci 26 43 22 46
5 Belasica Belasica 26 39 26 43
6 Gostivar Gostivar 26 25 19 39
7 Drita Bogovinje Drita 26 37 29 35
8 Gorno Lisiče Gorno 26 41 49 35
9 Lokomotiva Skopje Lokomotiva 26 27 46 31
10 Ohrid Lote Ohrid Lote 26 40 49 29
11 Vëllazërimi Vëllazërim 26 28 56 27
12 Novaci Novaci 26 22 37 22
13 Cementarnica 55 Cementarnica 26 20 41 22
14 Vlaznimi Struga Vlaznimi 26 24 51 22

  USO DE MEMORIA  
6,219,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5820
Total Execution Time  0.5832
  CADENA URL  
/historico/Fk-Gostivar
  GET DATOS  
$_GET['/historico/Fk-Gostivar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0137  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 = 'Fk-Gostivar' 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.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=13275 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=13275 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=13275 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=13275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13275 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=302 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 302 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (860396,835971,810791,799136,674706) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '13275' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '13275' 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 = 73924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 72279 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=13275 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 (73924,72279,71432,68725) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72279 AND teamId = 13275
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 68725 AND teamId = 13275
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 13275
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13275
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 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 = 72279 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151  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 = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 13275 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.0159  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 = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 13275 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 13275 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 13275 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 68725 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.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 `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 = 64026 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.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 = 58426 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.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 `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 = 50614 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.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 `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 = 44791 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 38857 AND t.round = 27 ORDER BY team.conference 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 `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 = 15839 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 = 4180 AND t.round = 27 ORDER BY team.conference 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 `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 = 3589 AND t.round = 33 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 `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 = 2856 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 8666 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 `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 = 8669 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 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 = 72279 ORDER BY nameShow LIMIT 100