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

Rabotnički

Entrenador: Goran Stanic

TEMPORADA 2023/2024
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Shkëndija Shkëndija 31 53 25 61
2 Struga Struga 31 53 31 61
3 Shkupi Shkupi 31 40 22 58
4 Tikves Tikves 31 39 38 42
5 Rabotnički Rabotnički 31 29 32 41
6 Sileks Sileks 31 34 38 41
7 Voska Sport Voska Sport 31 36 40 40
8 Gostivar Gostivar 31 31 37 40
9 AP Brera AP Brera 31 29 30 38
10 Vardar Skopje Vardar 31 25 40 35
11 Bregalnica Štip Bregalnica 31 25 47 27
12 Makedonija GP Makedonija 31 24 38 26
TEMPORADA 2022/2023
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Struga Struga 30 53 19 68
2 Shkupi Shkupi 30 62 27 58
3 KF Shkëndija Shkëndija 30 43 23 57
4 Sileks Sileks 30 41 34 48
5 Bregalnica Štip Bregalnica 30 33 34 41
6 Tikves Tikves 30 40 37 40
7 Makedonija GP Makedonija 30 37 33 39
8 Rabotnički Rabotnički 30 37 48 37
9 AP Brera AP Brera 30 34 38 28
10 FK Skopje FK Skopje 30 17 44 22
11 FK Pobeda Prilep Pobeda 30 18 78 13
12 Renova Renova 0 0 0 0
TEMPORADA 2021/2022
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Shkupi Shkupi 33 66 21 76
2 AP Brera AP Brera 33 55 32 64
3 KF Shkëndija Shkëndija 33 49 26 60
4 Makedonija GP Makedonija 33 46 44 57
5 Renova Renova 33 43 29 50
6 Struga Struga 33 33 33 47
7 Bregalnica Štip Bregalnica 33 45 47 45
8 Rabotnički Rabotnički 33 29 35 43
9 FK Skopje FK Skopje 33 27 45 35
10 Tikves Tikves 33 36 38 34
11 FK Borec FK Borec 33 25 66 21
12 Pelister Pelister 33 16 54 14
TEMPORADA 2020/2021
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Shkëndija Shkëndija 33 69 26 75
2 Shkupi Shkupi 33 41 24 59
3 Struga Struga 33 39 24 57
4 Makedonija GP Makedonija 33 53 43 55
5 Rabotnički Rabotnički 33 45 39 48
6 Pelister Pelister 33 34 38 45
7 AP Brera AP Brera 33 32 36 41
8 FK Borec FK Borec 33 32 36 40
9 Sileks Sileks 33 49 45 36
10 Renova Renova 33 36 46 36
11 Vardar Skopje Vardar 33 32 60 31
12 Belasica Belasica 33 23 68 17
TEMPORADA 2019/2020
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 23 33 14 46
2 Sileks Sileks 23 24 21 36
3 KF Shkëndija Shkëndija 23 38 20 35
4 Renova Renova 23 25 33 31
5 Shkupi Shkupi 23 28 28 29
6 Makedonija GP Makedonija 23 24 28 29
7 AP Brera AP Brera 23 20 20 28
8 Rabotnički Rabotnički 23 21 29 28
9 FK Borec FK Borec 23 20 31 27
10 Struga Struga 23 19 28 25
TEMPORADA 2018/2019
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Shkëndija Shkëndija 36 80 29 79
2 Vardar Skopje Vardar 36 45 23 64
3 AP Brera AP Brera 36 45 35 58
4 Shkupi Shkupi 36 40 42 48
5 Renova Renova 36 53 49 47
6 Makedonija GP Makedonija 36 45 50 47
7 Rabotnički Rabotnički 36 43 49 46
8 Sileks Sileks 36 27 39 44
9 Belasica Belasica 36 37 49 38
10 FK Pobeda Prilep Pobeda 36 26 76 23
TEMPORADA 2017/2018
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Shkëndija Shkëndija 36 101 27 91
2 Vardar Skopje Vardar 36 53 41 56
3 Rabotnički Rabotnički 36 50 43 52
4 Shkupi Shkupi 36 51 46 51
5 Sileks Sileks 36 30 37 50
6 AP Brera AP Brera 36 43 47 42
7 Renova Renova 36 36 53 41
8 Pobeda Junior Pobeda 36 36 56 38
9 FK Skopje FK Skopje 36 24 43 35
10 Pelister Pelister 36 37 68 34
TEMPORADA 2016/2017
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 36 75 24 83
2 KF Shkëndija Shkëndija 36 71 39 70
3 Rabotnički Rabotnički 36 49 41 54
4 Pelister Pelister 36 44 35 52
5 Renova Renova 36 42 37 52
6 Sileks Sileks 36 41 43 47
7 Pobeda Junior Pobeda 36 34 50 41
8 Shkupi Shkupi 36 27 39 37
9 Bregalnica Štip Bregalnica 36 39 69 24
10 Makedonija GP Makedonija 36 35 80 23
TEMPORADA 2015/2016
LIGA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 5 8 2 15
2 KF Shkëndija Shkëndija 5 12 3 12
3 Rabotnički Rabotnički 5 4 4 7
4 Bregalnica Štip Bregalnica 5 4 6 5
5 Sileks Sileks 5 3 8 4
6 Shkupi Shkupi 5 1 9 0
TEMPORADA 2014/2015
LIGA MACEDONIA DEL NORTE GRUPO 1
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 27 46 15 61
2 Rabotnički Rabotnički 27 43 23 55
3 KF Shkëndija Shkëndija 27 49 27 47
4 Renova Renova 27 34 27 44
5 Sileks Sileks 27 26 34 34
6 Metalurg Skopje Metalurg 27 31 31 33
7 Bregalnica Štip Bregalnica 27 22 28 30
8 Turnovo Turnovo 27 21 30 30
9 Pelister Pelister 27 16 28 23
10 Teteks Teteks 27 17 62 11
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
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 33 71 21 68
2 Metalurg Skopje Metalurg 33 48 28 63
3 Turnovo Turnovo 33 49 31 63
4 Rabotnički Rabotnički 33 47 42 53
5 KF Shkëndija Shkëndija 33 52 49 44
6 Bregalnica Štip Bregalnica 33 37 35 43
7 Napredok Kičevo Napredok 33 29 39 43
8 Renova Renova 33 35 46 43
9 Drita Bogovinje Drita 33 35 50 40
10 Pelister Pelister 33 27 36 37
11 Teteks Teteks 33 22 47 25
12 Sileks Sileks 33 33 61 23
TEMPORADA 2011/2012
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 33 50 15 76
2 Metalurg Skopje Metalurg 33 53 16 67
3 KF Shkëndija Shkëndija 33 53 28 66
4 Renova Renova 33 56 38 52
5 Bregalnica Štip Bregalnica 33 51 47 45
6 Sileks Sileks 33 42 51 42
7 Napredok Kičevo Napredok 33 37 51 42
8 Rabotnički Rabotnički 33 50 45 41
9 Turnovo Turnovo 33 34 42 38
10 Teteks Teteks 33 23 48 35
11 FK Ohrid FK Ohrid 33 26 62 26
12 11 Oktomvri 11 Oktomvri 33 26 58 16
TEMPORADA 2010/2011
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Shkëndija Shkëndija 33 65 23 72
2 Metalurg Skopje Metalurg 33 48 24 61
3 Renova Renova 33 54 31 60
4 Rabotnički Rabotnički 33 53 31 55
5 Sileks Sileks 33 39 38 47
6 Turnovo Turnovo 33 35 35 45
7 Teteks Teteks 33 38 36 44
8 Bregalnica Štip Bregalnica 33 33 49 41
9 FK Skopje FK Skopje 33 36 39 37
10 Napredok Kičevo Napredok 33 30 48 37
11 Vardar Skopje Vardar 33 24 44 29
12 Pelister Pelister 33 25 82 18
TEMPORADA 2009/2010
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Renova Renova 26 45 21 55
2 Rabotnički Rabotnički 26 38 20 50
3 Metalurg Skopje Metalurg 26 35 16 47
4 Pelister Pelister 26 28 27 39
5 Sileks Sileks 26 29 33 32
6 Vardar Skopje Vardar 26 31 28 30
7 Teteks Teteks 26 31 30 30
8 Turnovo Turnovo 26 27 35 26
9 FK Milano Kumanovo Milano 26 14 81 6
10 Makedonija GP Makedonija 10 23 5 0
11 FK Pobeda Prilep Pobeda 0 0 0 0
12 Sloga Jugomagnat Sloga 10 9 14 0
TEMPORADA 2008/2009
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Makedonija GP Makedonija 30 46 15 61
2 FK Milano Kumanovo Milano 30 48 35 55
3 Renova Renova 30 41 26 54
4 Rabotnički Rabotnički 30 40 25 47
5 Vardar Skopje Vardar 30 35 23 45
6 Turnovo Turnovo 30 25 39 37
7 Sileks Sileks 30 38 41 36
8 FK Pobeda Prilep Pobeda 30 31 47 32
9 Metalurg Skopje Metalurg 30 25 35 29
10 Pelister Pelister 30 25 42 28
11 Napredok Kičevo Napredok 30 26 52 21
TEMPORADA 2007/2008
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Rabotnički Rabotnički 33 51 11 79
2 FK Milano Kumanovo Milano 33 74 35 66
3 Pelister Pelister 33 42 27 58
4 Vardar Skopje Vardar 33 44 40 47
5 Renova Renova 33 34 34 47
6 FK Pobeda Prilep Pobeda 33 48 48 45
7 Makedonija GP Makedonija 33 34 42 44
8 Napredok Kičevo Napredok 33 38 49 42
9 Sileks Sileks 33 33 36 41
10 Bashkimi Bashkimi 33 40 63 30
11 KF Shkëndija Shkëndija 33 26 57 26
12 Cementarnica 55 Cementarnica 33 24 46 24
TEMPORADA 2006/2007
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 FK Pobeda Prilep Pobeda 33 73 42 71
2 Rabotnički Rabotnički 33 75 25 67
3 Makedonija GP Makedonija 33 65 29 64
4 Vardar Skopje Vardar 33 63 34 59
5 Renova Renova 33 54 31 59
6 Pelister Pelister 33 37 32 45
7 Napredok Kičevo Napredok 33 50 47 45
8 Bashkimi Bashkimi 33 54 60 42
9 Sileks Sileks 33 54 50 41
10 KF Shkëndija Shkëndija 33 39 63 38
11 Bregalnica Štip Bregalnica 33 19 97 13
12 Vëllazërimi Vëllazërim 33 22 95 9

  USO DE MEMORIA  
6,646,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6791
Total Execution Time  0.6803
  CADENA URL  
/historico/Rabotni-Ki
  GET DATOS  
$_GET['/historico/Rabotni-Ki']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0265  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 = 72279
0.0130  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 = 73924
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17731 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17731 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  SELECT /*35 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 (5320,320394) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = '17731' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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.0132  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.0185  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=17731 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 (73924,72279,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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72279 AND teamId = 17731
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 17731
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17731
0.0128  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 = '17731' 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 = '17731' 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 = '17731' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 17731 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.0142  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 = 17731 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 17731 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 17731 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 `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 = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 68122 AND t.round = 33 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 = 63538 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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 = 57381 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 50135 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.0139  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 = 44668 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 38855 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 33947 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 15466 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 24432 AND t.round = 5 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 `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 = 13701 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 4151 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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.0154  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 = 2207 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 8651 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 8652 AND t.round = 33 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 `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 = 8653 AND t.round = 31 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 `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 = 8654 AND t.round = 33 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 = 8655 AND t.round = 33 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 `tables2007` 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 = 8656 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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