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

FK Vozdovac

Entrenador: N. Mitić

TEMPORADA 2023/2024
LIGA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Novi Pazar Novi Pazar 32 39 42 39
2 FK Spartak Subotica Spartak 32 30 44 38
3 Radnicki Nis Radnicki 32 35 41 37
4 FK Vozdovac FK Vozdovac 32 39 48 34
5 IMT Novi Beograd Novi Beograd 32 35 48 34
6 Javor Ivanjica Javor 32 29 47 32
7 Železničar Pancevo Železničar 32 35 60 28
8 Radnik Surdulica Radnik 32 20 46 17
TEMPORADA 2022/2023
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 37 96 19 97
2 FK TSC FK TSC 37 66 32 75
3 FK Cukaricki Cukaricki 37 65 38 75
4 Partizan Belgrade Partizan 37 68 34 71
5 Vojvodina Novi Sad Vojvodina 37 59 35 63
6 Novi Pazar Novi Pazar 37 40 49 51
7 FK Vozdovac FK Vozdovac 37 29 52 46
8 Radnički Kragujevac Radnički 37 37 43 42
TEMPORADA 2021/2022
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 37 95 19 100
2 Partizan Belgrade Partizan 37 85 13 98
3 FK Cukaricki Cukaricki 37 54 34 60
4 Radnicki Nis Radnicki 37 40 39 51
5 FK Vozdovac FK Vozdovac 37 48 45 49
6 FK TSC FK TSC 37 51 56 48
7 Vojvodina Novi Sad Vojvodina 37 44 51 45
8 Napredak Krusevac Napredak 37 31 51 38
TEMPORADA 2020/2021
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 38 114 20 108
2 Partizan Belgrade Partizan 38 95 20 95
3 FK Cukaricki Cukaricki 38 69 34 74
4 Vojvodina Novi Sad Vojvodina 38 62 41 71
5 FK TSC FK TSC 38 68 50 58
6 Radnik Surdulica Radnik 38 55 49 55
7 Mladost Lučani Mladost 38 43 59 54
8 Proleter Novi Sad Proleter 38 40 47 53
9 Metalac GM Metalac GM 38 48 53 52
10 FK Spartak Subotica Spartak 38 54 53 52
11 Napredak Krusevac Napredak 38 44 51 50
12 Novi Pazar Novi Pazar 38 50 60 49
13 Radnicki Nis Radnicki 38 37 39 49
14 FK Vozdovac FK Vozdovac 38 49 59 48
15 Rad Beograd Rad Beograd 38 44 57 48
16 Javor Ivanjica Javor 38 45 53 46
17 Inđija Inđija 38 29 66 35
18 FK Zlatibor Cajetina Zlatibor 38 28 64 29
19 Mačva Šabac Mačva 38 26 81 25
20 Bačka Palanka Bačka 38 24 68 16
TEMPORADA 2019/2020
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 30 68 18 78
2 Partizan Belgrade Partizan 30 69 25 64
3 Vojvodina Novi Sad Vojvodina 30 47 27 62
4 FK TSC FK TSC 30 59 34 59
5 Radnicki Nis Radnicki 30 51 37 52
6 FK Cukaricki Cukaricki 30 42 36 51
7 FK Spartak Subotica Spartak 30 46 48 46
8 FK Vozdovac FK Vozdovac 30 45 41 45
9 Mladost Lučani Mladost 30 31 40 43
10 Napredak Krusevac Napredak 30 33 41 33
11 Radnik Surdulica Radnik 30 34 50 31
12 Proleter Novi Sad Proleter 30 30 42 30
13 Javor Ivanjica Javor 30 43 62 28
14 Inđija Inđija 30 26 48 25
15 Rad Beograd Rad Beograd 30 23 63 15
16 Mačva Šabac Mačva 30 18 53 13
TEMPORADA 2018/2019
LIGA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Radnik Surdulica Radnik 7 13 10 28
2 FK Spartak Subotica Spartak 7 9 9 27
3 FK Vozdovac FK Vozdovac 7 8 11 25
4 Mačva Šabac Mačva 7 8 12 25
5 Rad Beograd Rad Beograd 7 6 5 23
6 Dinamo Vranje Dinamo 7 6 5 23
7 Zemun Zemun 7 17 6 21
8 Bačka Palanka Bačka 7 5 14 18
TEMPORADA 2017/2018
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 7 21 4 60
2 Partizan Belgrade Partizan 7 12 10 43
3 Radnicki Nis Radnicki 7 17 11 37
4 FK Spartak Subotica Spartak 7 7 10 37
5 FK Vozdovac FK Vozdovac 7 7 13 33
6 FK Cukaricki Cukaricki 7 11 18 32
7 Napredak Krusevac Napredak 7 8 13 30
8 Vojvodina Novi Sad Vojvodina 7 10 14 28
TEMPORADA 2016/2017
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 7 19 5 58
2 Crvena Zvezda Crvena 7 18 8 55
3 Vojvodina Novi Sad Vojvodina 7 7 5 43
4 Mladost Lučani Mladost 7 11 15 36
5 Radnicki Nis Radnicki 7 10 10 32
6 Napredak Krusevac Napredak 7 9 13 30
7 FK Vozdovac FK Vozdovac 7 6 13 27
8 Javor Ivanjica Javor 7 2 13 22
TEMPORADA 2015/2016
LIGA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 7 15 8 54
2 Partizan Belgrade Partizan 7 13 7 40
3 FK Cukaricki Cukaricki 7 11 13 39
4 Vojvodina Novi Sad Vojvodina 7 13 6 36
5 Radnicki Nis Radnicki 7 14 12 35
6 Borac Čačak Borac 7 9 14 30
7 FK Vozdovac FK Vozdovac 7 4 7 25
8 Radnik Surdulica Radnik 7 7 19 25
TEMPORADA 2014/2015
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 67 22 71
2 Crvena Zvezda Crvena 30 46 20 64
3 FK Cukaricki Cukaricki 30 48 24 57
4 Vojvodina Novi Sad Vojvodina 30 44 36 52
5 Novi Pazar Novi Pazar 30 39 28 47
6 Rad Beograd Rad Beograd 30 33 38 43
7 Mladost Lučani Mladost 30 41 47 40
8 OFK Beograd OFK Beograd 30 35 43 39
9 Radnicki Nis Radnicki 30 25 31 37
10 Jagodina Jagodina 30 38 45 35
11 FK Spartak Subotica Spartak 30 23 33 34
12 FK Vozdovac FK Vozdovac 30 24 37 34
13 Borac Čačak Borac 30 29 35 33
14 Napredak Krusevac Napredak 30 23 34 31
15 Donji Srem Donji Srem 30 25 42 26
16 Radnički Kragujevac Radnički 30 17 42 19
TEMPORADA 2013/2014
LIGA SERBIA
Equipo PJ GF GC Puntos
1 Crvena Zvezda Crvena 30 66 27 72
2 Partizan Belgrade Partizan 30 64 20 71
3 Jagodina Jagodina 30 40 30 48
4 Vojvodina Novi Sad Vojvodina 30 38 32 45
5 FK Cukaricki Cukaricki 30 30 31 44
6 Radnicki Nis Radnicki 30 28 22 43
7 FK Vozdovac FK Vozdovac 30 34 35 42
8 Novi Pazar Novi Pazar 30 32 34 39
9 Napredak Krusevac Napredak 30 42 44 35
10 FK Spartak Subotica Spartak 30 24 37 34
11 OFK Beograd OFK Beograd 30 31 43 33
12 Donji Srem Donji Srem 30 29 40 32
13 Radnički Kragujevac Radnički 30 30 49 32
14 Rad Beograd Rad Beograd 30 19 37 29
15 Javor Ivanjica Javor 30 29 38 29
16 Sloboda Uzice Sloboda 30 21 38 28
TEMPORADA 2012/2013
SEGUNDA SERBIA
Equipo PJ GF GC Puntos
1 Napredak Krusevac Napredak 34 74 25 80
2 FK Cukaricki Cukaricki 34 52 26 67
3 FK Vozdovac FK Vozdovac 34 49 22 63
4 Proleter Novi Sad Proleter 34 53 43 57
5 Metalac GM Metalac GM 34 48 32 56
6 Jedinstvo Putevi Jedinstvo 34 40 32 56
7 Borac Čačak Borac 34 47 25 54
8 Bežanija Bežanija 34 41 32 44
9 Mladost Lučani Mladost 34 31 35 43
10 Sloga Kraljevo Sloga 34 32 39 43
11 Timok Timok 34 37 48 43
12 Inđija Inđija 34 27 35 42
13 Teleoptik Teleoptik 34 25 43 36
14 Radnički Nova Pazova Radnički 34 35 44 35
15 Banat Zrenjanin Banat 34 29 47 35
16 Mladenovac Mladenovac 34 21 41 32
17 Kolubara Kolubara 34 30 48 27
18 RFK Novi Sad Novi 34 17 71 21
TEMPORADA 2011/2012
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 FK Vozdovac FK Vozdovac 30 60 17 66
2 Radnički Obrenovac Radnički 30 42 23 59
3 Zemun Zemun 30 39 30 54
4 Žarkovo Žarkovo 30 37 26 47
5 Šumadija Jagnjilo Šumadija 30 61 41 46
6 Sopot Sopot 30 35 20 46
7 Hajduk Beograd Hajduk 30 32 43 41
8 Sinđelić Beograd Sinđelić 30 41 35 40
9 Kovačevac Kovačevac 30 34 41 38
10 Padinska Skela Padinska 30 29 29 37
11 Dorćol Dorćol 30 27 39 36
12 FK Beograd FK Beograd 30 28 43 36
13 BASK BASK 30 39 46 35
14 Srem Jakovo Srem Jakovo 30 28 45 34
15 Balkan Mirijevo Balkan 30 17 34 31
16 Slavija Beograd Slavija 30 17 54 22

  USO DE MEMORIA  
6,201,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1313
Total Execution Time  0.1326
  CADENA URL  
/historico/Vozdovac
  GET DATOS  
$_GET['/historico/Vozdovac']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0042  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 = 72238
0.0025  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 = 74071
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13455 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13455 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (499525) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '13455' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '13455' 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 = 74071 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 75863 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=13455 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (75863,74071,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75863 AND teamId = 13455
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74071 AND teamId = 13455
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13455
0.0020  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 = '13455' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13455' and rp.type = 4
0.0020  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 = '13455' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 75863 WHERE rp.league_id = 75863 AND rp.teamId = 13455 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.0028  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 = 75863 WHERE rp.league_id = 75863 AND rp.teamId = 13455 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75863 WHERE rp.league_id = 75863 AND rp.teamId = 13455 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 13455 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72238 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.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 `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 = 75863 AND t.round = 3 ORDER BY team.conference ASC,t.position 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 `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 = 67770 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.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 `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 = 71506 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.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 `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 = 63172 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.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 `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 = 67315 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.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 `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 = 56989 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 49967 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.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 `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 = 43962 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 `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 = 49453 AND t.round = 7 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 `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 = 38794 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 `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 = 43253 AND t.round = 7 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 `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 = 33340 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 `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 = 38288 AND t.round = 7 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 `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 = 15339 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 `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 = 23658 AND t.round = 7 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 `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 = 3820 AND t.round = 30 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 `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 = 2872 AND t.round = 30 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 `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 = 14845 AND t.round = 34 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 `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 = 25190 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC