4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del VOC
TEMPORADA 2023/2024
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 ASWH ASWH 26 43 19 60
2 Smitshoek Smitshoek 26 38 34 43
3 Poortugaal Poortugaal 26 55 39 42
4 S Gravenzande SV Gravenzande 26 47 40 42
5 Capelle Capelle 26 37 30 42
6 Zwaluwen Zwaluwen 26 53 44 39
7 Westlandia Westlandia 26 42 37 38
8 SC Feyenoord Feyenoord 26 44 40 38
9 LRC LRC 26 52 47 35
10 HBS HBS 26 34 34 35
11 RKAVV RKAVV 26 34 38 30
12 Heerjansdam Heerjansdam 26 31 41 29
13 RVVH RVVH 26 44 44 28
14 Nieuwenhoorn Nieuwenhoorn 26 34 48 27
15 VOC VOC 26 44 69 27
16 DSO DSO 26 24 52 20
TEMPORADA 2022/2023
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Hoogeveen Hoogeveen 30 75 34 62
2 RKAVV RKAVV 30 48 21 61
3 Purmersteijn Purmersteijn 30 65 35 60
4 HBS HBS 30 66 41 56
5 Be Quick 1887 Quick 1887 30 55 25 55
6 SJC Noordwijk Noordwijk 30 63 59 50
7 ROHDA Raalte ROHDA Raalte 30 61 50 49
8 Westlandia Westlandia 30 57 56 48
9 Hollandia Hollandia 30 62 43 46
10 Heino Heino 30 43 40 37
11 Alphense Boys Alphense 30 49 68 35
12 VOC VOC 30 50 59 33
13 De Zouaven De Zouaven 30 46 71 27
14 RKVV Velsen RKVV Velsen 30 39 71 22
15 Alcides Alcides 30 28 82 15
16 VKW VKW 30 21 73 14
TEMPORADA 2021/2022
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 TOGB TOGB 28 63 36 62
2 HBS HBS 28 65 25 58
3 Hoogeveen Hoogeveen 28 77 40 56
4 SJC Noordwijk Noordwijk 28 74 47 55
5 Be Quick 1887 Quick 1887 28 66 29 52
6 RKAVV RKAVV 28 49 41 44
7 Purmersteijn Purmersteijn 28 56 51 38
8 Alphense Boys Alphense 28 57 65 38
9 RKVV Velsen RKVV Velsen 28 38 46 34
10 VOC VOC 28 45 53 33
11 Alcides Alcides 28 48 68 29
12 De Zouaven De Zouaven 28 46 63 27
13 TAC'90 TAC'90 28 41 68 26
14 SDO Bussum SDO Bussum 28 29 80 18
15 VV Emmen VV Emmen 28 26 68 17
TEMPORADA 2020/2021
HOOFDKLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Meerssen Meerssen 6 11 5 14
2 Baronie Baronie 5 20 0 13
3 AWC AWC 5 9 10 10
4 Halsteren Halsteren 5 10 6 9
5 SV Orion SV Orion 4 7 5 9
6 OJC Rosmalen Rosmalen 5 9 8 8
7 EHC Hoensbroek Hoensbroek 6 8 15 8
8 IFC IFC 5 9 6 7
9 Moerse Boys Moerse Boys 6 9 12 7
10 UDI '19 UDI '19 5 7 10 6
11 TOGB TOGB 5 7 11 5
12 VOC VOC 6 7 12 4
13 Juliana 31 Juliana 31 2 4 3 3
14 RKSV Minor RKSV Minor 6 9 16 2
15 RKSV Nuenen RKSV Nuenen 5 6 13 1
16 Leonidas Leonidas 0 0 0 0
TEMPORADA 2019/2020
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Hollandia Hollandia 20 42 20 43
2 JOS Watergraafsmeer Watergraafsm 19 47 24 40
3 RKAVV RKAVV 21 53 33 36
4 SJC Noordwijk Noordwijk 20 45 31 35
5 Alphense Boys Alphense 20 43 28 34
6 Hoogeveen Hoogeveen 19 36 31 33
7 Leonidas Leonidas 19 38 33 30
8 HBS HBS 20 30 26 29
9 Quick '20 Quick '20 20 52 46 28
10 SDO Bussum SDO Bussum 20 45 44 26
11 RKVV Velsen RKVV Velsen 19 28 30 26
12 Be Quick 1887 Quick 1887 21 32 25 25
13 VV Emmen VV Emmen 20 41 55 19
14 Alcides Alcides 20 24 48 14
15 MSC MSC 19 18 67 14
16 VOC VOC 21 25 58 11
TEMPORADA 2018/2019
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 VOC VOC 24 69 11 62
2 Moerse Boys Moerse Boys 24 61 23 58
3 VUC VUC 24 67 35 48
4 DHC Delft DHC Delft 24 61 24 44
5 Spartaan 20 Spartaan 20 24 51 38 37
6 FC Olympia FC Olympia 24 39 52 32
7 Rood-Wit-Willebrord Rood-Wit-Wil 24 49 50 31
8 GLZ Delfshaven Delfshaven 24 41 63 29
9 Den Hoorn Den Hoorn 24 29 42 27
10 DOSKO DOSKO 24 41 63 27
11 Zwervers Zwervers 24 38 63 19
12 Groeneweg Groeneweg 24 39 80 14
13 VELO VELO 24 28 69 10
14 BMT BMT 0 0 0 0
TEMPORADA 2017/2018
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 GVV Unitas GVV Unitas 24 69 14 62
2 Hoogland Hoogland 24 56 34 50
3 Nieuwerkerk Nieuwerkerk 24 59 44 43
4 VOC VOC 24 47 27 39
5 Den Hoorn Den Hoorn 24 44 32 38
6 FC Olympia FC Olympia 24 39 35 37
7 BMT BMT 24 44 41 36
8 VELO VELO 24 46 47 33
9 Poortugaal Poortugaal 24 29 52 28
10 Spartaan 20 Spartaan 20 24 57 65 26
11 FC Boshuizen Boshuizen 24 50 61 26
12 RVC 33 RVC 33 24 34 52 22
13 DVV Delft DVV Delft 24 14 84 6
14 Kocatepe Kocatepe 0 0 0 0
TEMPORADA 2016/2017
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Leonidas Leonidas 26 74 37 62
2 Alphense Boys Alphense 26 62 35 54
3 FC Boshuizen Boshuizen 26 63 36 50
4 VELO VELO 26 55 42 46
5 Nieuwerkerk Nieuwerkerk 26 34 32 35
6 FC Olympia FC Olympia 26 34 39 35
7 Poortugaal Poortugaal 26 53 57 34
8 SC Woerden SC Woerden 26 43 50 31
9 VOC VOC 26 32 40 30
10 OVV OVV 26 46 55 28
11 DRL DRL 26 46 66 28
12 Laakkwartier Laakkwartier 26 44 65 27
13 TAC'90 TAC'90 26 47 56 26
14 Zwervers Zwervers 26 38 61 19
TEMPORADA 2015/2016
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IFC IFC 24 67 20 60
2 FC Boshuizen Boshuizen 24 60 35 57
3 SJC Noordwijk Noordwijk 24 72 26 53
4 VOC VOC 24 47 41 39
5 VELO VELO 24 48 42 38
6 Zwervers Zwervers 24 45 50 31
7 DRL DRL 24 42 45 30
8 Poortugaal Poortugaal 24 49 51 28
9 FC Olympia FC Olympia 24 25 45 26
10 TAC'90 TAC'90 24 39 66 25
11 Wateringse Veld Wateringse 23 29 46 16
12 PFC PFC 24 24 59 16
13 GDA GDA 23 29 50 13
TEMPORADA 2014/2015
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Magreb 90 Magreb 90 24 61 32 52
2 De Dijk De Dijk 24 51 32 50
3 Vlissingen Vlissingen 24 47 41 43
4 OFC Oostzaan Oostzaan 24 54 38 38
5 HV & CV Quick Quick 24 50 51 36
6 Westlandia Westlandia 23 43 35 35
7 Chabab Chabab 23 47 48 34
8 JOS Watergraafsmeer Watergraafsm 24 44 50 33
9 DHC Delft DHC Delft 24 48 55 30
10 Hollandia Hollandia 24 37 38 27
11 VOC VOC 24 41 57 24
12 De Zouaven De Zouaven 24 31 52 21
13 AFC '34 AFC '34 24 33 58 17
14 Haaglandia Haaglandia 0 0 0 0
TEMPORADA 2013/2014
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Koninklijke HFC Koninklijke 26 62 36 56
2 EDO HFC EDO HFC 26 56 31 51
3 Westlandia Westlandia 26 64 43 49
4 De Zouaven De Zouaven 26 53 52 40
5 De Dijk De Dijk 26 47 46 39
6 VOC VOC 26 58 50 37
7 HV & CV Quick Quick 26 45 43 36
8 DOSKO DOSKO 26 45 47 36
9 DHC Delft DHC Delft 26 47 51 35
10 Hollandia Hollandia 26 39 42 34
11 GOES GOES 26 55 56 31
12 RKAVV RKAVV 26 42 62 31
13 Nieuwenhoorn Nieuwenhoorn 26 44 52 29
14 FC Boshuizen Boshuizen 26 41 87 8
TEMPORADA 2012/2013
EERSTE KLASSE ZONDAG GRUPO 2
Equipo PJ GF GC Puntos
1 VOC VOC 26 63 27 56
2 FC Boshuizen Boshuizen 26 51 32 46
3 De Meern De Meern 26 48 33 46
4 UVS UVS 26 43 34 43
5 Neptunus-Schiebroek Neptunus-Sch 26 44 37 43
6 VELO VELO 26 39 40 40
7 SJC Noordwijk Noordwijk 26 54 49 39
8 Magreb 90 Magreb 90 26 49 42 38
9 Nieuwerkerk Nieuwerkerk 26 42 45 36
10 Kocatepe Kocatepe 26 46 44 34
11 ADO Den Haag II Haag 26 43 46 33
12 PFC PFC 26 37 56 25
13 Excelsior .20 Excelsior 26 35 54 23
14 RKDEO RKDEO 26 24 79 10

  USO DE MEMORIA  
6,028,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6336
Total Execution Time  0.6350
  CADENA URL  
/historico/Voc
  GET DATOS  
$_GET['/historico/Voc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0153  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 = 'Voc' 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.0145  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=11265 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=11265 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11265 AND type_rel = 2
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=226 AND type_rel = 3
0.0152  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 226 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0161  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 (859778,183993,112119,50354,49516) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '11265' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '11265' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '11265' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=11265 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (72978,70056,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72978 AND teamId = 11265
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 70056 AND teamId = 11265
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 11265
0.0154  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 = '11265' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11265' and rp.type = 4
0.0155  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 = '11265' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 = 72978 WHERE rp.league_id = 72978 AND rp.teamId = 11265 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.0156  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 = 72978 WHERE rp.league_id = 72978 AND rp.teamId = 11265 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 72978 WHERE rp.league_id = 72978 AND rp.teamId = 11265 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 = 11265 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0163  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 = 72978 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.0162  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 = 70056 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.0167  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 = 63264 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.0164  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 = 58337 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 50984 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 45036 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 39758 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 33983 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 16016 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 9389 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 9396 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 2220 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC