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

Quick Boys

Entrenador: Thomas Duivenvoorden

Temporada 2017/2018
TEMPORADA 2017/2018
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 34 68 32 71
2 Scheveningen Scheveningen 34 68 44 65
3 DVS'33 DVS'33 34 74 37 62
4 Jong Almere City Jong Almere 34 73 54 61
5 Groningen Sub 21 Groningen 34 72 34 58
6 Quick Boys Quick Boys 34 63 45 58
7 Jong Volendam Jong 34 60 48 56
8 ODIN '59 ODIN '59 34 56 51 49
9 DOVO DOVO 34 54 52 49
10 Twente Sub 21 Twente 34 52 45 48
11 ASWH ASWH 34 52 51 47
12 Harkemase Boys Harkemase 34 55 56 46
13 VVOG VVOG 34 36 51 42
14 ONS Sneek ONS Sneek 34 62 88 37
15 Capelle Capelle 34 44 57 35
16 Spijkenisse Spijkenisse 34 56 83 33
17 ACV Assen ACV Assen 34 57 83 32
18 Magreb 90 Magreb 90 34 31 122 10
TEMPORADA 2016/2017
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 34 74 36 70
2 Lisse Lisse 34 55 38 65
3 Rijnsburgse Boys Rijnsburgse 34 84 62 61
4 ASWH ASWH 34 64 53 58
5 Scheveningen Scheveningen 34 54 48 56
6 Jong Volendam Jong 34 60 56 56
7 DVS'33 DVS'33 34 54 49 48
8 Harkemase Boys Harkemase 34 55 60 46
9 Groningen Sub 21 Groningen 34 48 46 45
10 VVOG VVOG 34 49 55 44
11 Quick Boys Quick Boys 34 47 54 43
12 Capelle Capelle 34 42 52 41
13 ONS Sneek ONS Sneek 34 51 60 40
14 Jong Almere City Jong Almere 34 63 61 38
15 ODIN '59 ODIN '59 34 58 63 36
16 SteDoCo SteDoCo 34 46 69 35
17 Huizen Huizen 34 38 57 33
18 Rijnvogels Rijnvogels 34 55 78 33
TEMPORADA 2015/2016
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Quick Boys Quick Boys 26 58 16 64
2 VV Noordwijk Noordwijk 26 63 19 62
3 ASWH ASWH 26 53 25 48
4 Rijnvogels Rijnvogels 26 41 32 45
5 Spijkenisse Spijkenisse 26 48 41 45
6 Jodan Boys Jodan Boys 26 40 28 42
7 Ter Leede Ter Leede 26 36 40 40
8 Hoek Hoek 26 29 37 34
9 Zwaluwen Zwaluwen 26 37 51 30
10 Haaglandia Zaterdag Haaglandia 26 35 49 30
11 Xerxes DZB Xerxes DZB 26 32 43 24
12 Heinenoord Heinenoord 26 21 52 20
13 Sportlust 46 Sportlust 26 27 56 18
14 Deltasport Deltasport 26 29 60 14
TEMPORADA 2014/2015
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 26 69 26 64
2 Quick Boys Quick Boys 26 49 28 48
3 RVVH RVVH 26 40 30 43
4 ASWH ASWH 26 53 31 41
5 Zwaluwen Zwaluwen 26 42 41 41
6 Spijkenisse Spijkenisse 26 43 36 40
7 VV Noordwijk Noordwijk 26 42 39 38
8 Rijnvogels Rijnvogels 26 47 47 36
9 Ter Leede Ter Leede 26 41 42 35
10 Xerxes Xerxes 26 41 56 29
11 Smitshoek Smitshoek 26 37 52 28
12 Kloetinge Kloetinge 26 34 50 28
13 SHO SHO 26 37 70 23
14 S Gravenzande SV Gravenzande 26 29 56 16
TEMPORADA 2013/2014
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Sparta Nijkerk Sparta 26 61 31 60
2 Ajax Amateurs Ajax 26 59 28 53
3 Quick Boys Quick Boys 26 51 37 50
4 DVS'33 DVS'33 26 49 38 43
5 Huizen Huizen 26 52 44 37
6 Bennekom Bennekom 26 41 38 35
7 ODIN '59 ODIN '59 26 41 43 34
8 SDC Putten SDC Putten 26 46 51 32
9 RKAV Volendam RKAV 26 43 56 32
10 VVA .71 VVA .71 26 38 49 30
11 DOVO DOVO 26 36 45 29
12 Montfoort Montfoort 26 38 55 26
13 Sportlust 46 Sportlust 26 26 38 23
14 SDV Barneveld Barneveld 26 23 51 19
TEMPORADA 2012/2013
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Ter Leede Ter Leede 26 56 20 54
2 DOVO DOVO 26 39 29 46
3 Ajax Amateurs Ajax 26 53 27 42
4 ODIN '59 ODIN '59 26 43 32 40
5 VVA .71 VVA .71 26 42 43 40
6 Montfoort Montfoort 26 37 43 40
7 Huizen Huizen 26 57 42 38
8 Quick Boys Quick Boys 26 54 40 37
9 Bennekom Bennekom 26 43 41 37
10 Sportlust 46 Sportlust 26 32 44 34
11 Apeldoorn CSV Apeldoorn 26 39 47 29
12 ARC Alphense Alphense 26 43 65 26
13 RKAV Volendam RKAV 26 35 58 26
14 DTS Ede DTS Ede 26 27 69 13
TEMPORADA 2011/2012
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Jodan Boys Jodan Boys 24 41 23 49
2 Ter Leede Ter Leede 24 46 30 42
3 Quick Boys Quick Boys 24 41 34 41
4 Huizen Huizen 23 37 34 39
5 Sparta Nijkerk Sparta 24 39 34 34
6 Bennekom Bennekom 24 35 33 34
7 RKAV Volendam RKAV 24 39 49 34
8 DOVO DOVO 24 35 38 33
9 Sportlust 46 Sportlust 24 44 51 33
10 Voorschoten .97 Voorschoten 24 49 41 32
11 ODIN '59 ODIN '59 23 35 34 31
12 Zwaluwen .30 Zwaluwen 24 32 45 24
13 SDC Putten SDC Putten 24 30 57 18
TEMPORADA 2010/2011
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Quick Boys Quick Boys 26 64 25 58
2 VV Noordwijk Noordwijk 26 57 24 58
3 Young Boys Young Boys 26 58 34 51
4 Scheveningen Scheveningen 26 47 28 46
5 Excelsior Maassluis Excelsior 26 51 39 45
6 ODIN '59 ODIN '59 26 40 29 44
7 RKAV Volendam RKAV 26 52 54 34
8 Voorschoten .97 Voorschoten 26 32 49 32
9 Ter Leede Ter Leede 26 28 51 30
10 Jodan Boys Jodan Boys 26 35 45 29
11 Zwaluwen .30 Zwaluwen 26 36 45 27
12 Huizen Huizen 26 38 54 23
13 Vitesse Delft Vitesse 26 28 53 18
14 Swift Swift 26 28 64 17
TEMPORADA 2009/2010
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 BVV Barendrecht Barendrecht 26 66 21 61
2 Capelle Capelle 26 57 34 54
3 Rijnsburgse Boys Rijnsburgse 26 48 25 49
4 Lisse Lisse 26 49 36 41
5 Katwijk Katwijk 26 45 43 39
6 ARC Alphense Alphense 26 41 43 39
7 VV Noordwijk Noordwijk 26 45 37 38
8 ASWH ASWH 26 47 43 38
9 Ter Leede Ter Leede 26 50 46 34
10 Scheveningen Scheveningen 26 44 52 31
11 Quick Boys Quick Boys 26 39 48 30
12 RVVH RVVH 26 31 45 30
13 DOTO DOTO 26 21 66 15
14 TOGR TOGR 26 24 68 8
TEMPORADA 2008/2009
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Rijnsburgse Boys Rijnsburgse 26 63 22 65
2 Capelle Capelle 26 54 32 51
3 BVV Barendrecht Barendrecht 26 50 24 49
4 ASWH ASWH 26 48 34 47
5 Ter Leede Ter Leede 26 52 45 42
6 Quick Boys Quick Boys 26 56 47 41
7 Katwijk Katwijk 26 39 33 41
8 Lisse Lisse 26 48 51 37
9 VV Noordwijk Noordwijk 26 42 49 28
10 Scheveningen Scheveningen 26 36 54 28
11 DOTO DOTO 26 25 54 26
12 Excelsior Maassluis Excelsior 26 31 48 24
13 ARC Alphense Alphense 26 27 47 24
14 Heerjansdam Heerjansdam 26 27 58 15
TEMPORADA 2007/2008
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Lisse Lisse 26 54 27 56
2 Rijnsburgse Boys Rijnsburgse 26 55 28 47
3 Quick Boys Quick Boys 26 53 38 46
4 Capelle Capelle 26 39 30 40
5 DOTO DOTO 26 39 44 36
6 Katwijk Katwijk 26 35 38 35
7 VV Noordwijk Noordwijk 26 42 33 34
8 BVV Barendrecht Barendrecht 26 36 33 33
9 ASWH ASWH 26 42 45 33
10 Ter Leede Ter Leede 26 25 32 31
11 Zwaluwen .30 Zwaluwen 26 47 64 31
12 Excelsior Maassluis Excelsior 26 35 46 30
13 SHO SHO 26 34 49 21
14 TOGR TOGR 26 31 60 19
TEMPORADA 2006/2007
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 65 29 59
2 Sparta Nijkerk Sparta 25 59 34 49
3 Quick Boys Quick Boys 25 56 32 48
4 Nunspeet Nunspeet 26 49 37 44
5 Spakenburg Spakenburg 26 47 35 42
6 GVVV GVVV 26 48 35 40
7 Hoek Hoek 26 57 48 39
8 Ajax Amateurs Ajax 26 34 41 31
9 Bennekom Bennekom 26 43 51 30
10 Kloetinge Kloetinge 26 29 42 29
11 SV Geinoord SV Geinoord 26 31 49 29
12 Huizen Huizen 26 26 41 23
13 VVOG VVOG 26 27 50 23
14 GOES GOES 26 21 68 5
TEMPORADA 2005/2006
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Rijnsburgse Boys Rijnsburgse 27 44 23 51
2 Lisse Lisse 26 54 36 49
3 DOTO DOTO 26 48 35 49
4 Katwijk Katwijk 26 47 35 41
5 Ter Leede Ter Leede 27 33 33 41
6 Quick Boys Quick Boys 25 39 32 37
7 VV Noordwijk Noordwijk 25 43 42 35
8 Excelsior Maassluis Excelsior 26 43 45 35
9 Capelle Capelle 26 36 39 33
10 Ajax Amateurs Ajax 26 26 34 30
11 Kloetinge Kloetinge 26 30 47 30
12 Hoek Hoek 26 44 52 28
13 ARC Alphense Alphense 26 35 47 21
14 Scheveningen Scheveningen 26 22 44 17
TEMPORADA 2004/2005
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 46 31 52
2 Capelle Capelle 26 45 35 48
3 Quick Boys Quick Boys 26 60 45 47
4 Rijnsburgse Boys Rijnsburgse 26 53 36 42
5 Spakenburg Spakenburg 26 52 42 40
6 SHO SHO 26 39 36 37
7 Sparta Nijkerk Sparta 26 40 41 37
8 Scheveningen Scheveningen 26 41 42 36
9 Excelsior Maassluis Excelsior 26 42 45 32
10 Deltasport Deltasport 26 38 33 31
11 Katwijk Katwijk 26 39 46 31
12 TOGR TOGR 26 34 55 25
13 Huizen Huizen 26 37 48 24
14 Voorschoten .97 Voorschoten 26 25 56 15

  USO DE MEMORIA  
6,669,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7260
Total Execution Time  0.7273
  CADENA URL  
/historico/Quick-Boys/2018
  GET DATOS  
$_GET['/historico/Quick-Boys/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0182  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 = 'Quick-Boys' AND l.year = 2018 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.0127  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=7158 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=7158 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=7158 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=7158 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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 = 38963
0.0133  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 = 38951
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7158 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7158 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 (407176,1075606) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '7158' ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '7158' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '7158' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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 = 38951 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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 = 38963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=7158 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (49832,44605,44455,38427) 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.0142  SELECT count(id) as num_players from rel_players WHERE league_id = 44605 AND teamId = 7158
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 44455 AND teamId = 7158
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 49832 AND teamId = 7158
0.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 7158
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 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 = 38963 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '7158' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7158' and rp.type = 4
0.0136  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 = '7158' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0169  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 events2018 e ON e.player_id = p.id AND e.league_id = 38963 WHERE rp.league_id = 38963 AND rp.teamId = 7158 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.0179  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 events2018 e ON e.player_id = p.id AND e.league_id = 38963 WHERE rp.league_id = 38963 AND rp.teamId = 7158 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  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 events2018 e ON e.player_id = p.id AND e.league_id = 38963 WHERE rp.league_id = 38963 AND rp.teamId = 7158 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 7158 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138  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 = 38963 AND t.round = 34 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 `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 = 33929 AND t.round = 34 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 `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 = 15936 AND t.round = 26 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 `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 = 9388 AND t.round = 26 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 `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 = 9393 AND t.round = 26 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 = 2189 AND t.round = 26 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 `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 = 1713 AND t.round = 26 ORDER BY team.conference 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 `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 = 20374 AND t.round = 26 ORDER BY team.conference 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 `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 = 20378 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 20381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 20386 AND t.round = 26 ORDER BY team.conference 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 `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 = 20390 AND t.round = 26 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 `tables2006` 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 = 20392 AND t.round = 26 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 `tables2005` 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 = 20396 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 38963 ORDER BY nameShow LIMIT 100