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

Rijnsburgse Boys

Entrenador: Hein Leliveld

TEMPORADA 2013/2014
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 GVVV GVVV 30 73 44 54
2 Spakenburg Spakenburg 30 57 38 54
3 HHC Hardenberg Hardenberg 30 67 43 51
4 IJsselmeervogels IJsselmeervo 30 62 43 50
5 Rijnsburgse Boys Rijnsburgse 30 72 41 49
6 Excelsior Maassluis Excelsior 30 49 51 48
7 Kozakken Boys Kozakken 30 57 49 47
8 Lisse Lisse 30 48 42 47
9 Scheveningen Scheveningen 30 43 49 43
10 ONS Sneek ONS Sneek 30 52 66 42
11 BVV Barendrecht Barendrecht 30 53 57 39
12 Capelle Capelle 30 37 45 38
13 VV Noordwijk Noordwijk 30 40 56 36
14 Katwijk Katwijk 30 52 69 30
15 Excelsior .31 Excelsior 30 52 83 28
16 Ter Leede Ter Leede 30 32 70 22
TEMPORADA 2012/2013
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 30 77 47 56
2 BVV Barendrecht Barendrecht 30 51 34 54
3 GVVV GVVV 30 54 41 52
4 HHC Hardenberg Hardenberg 30 62 49 51
5 Rijnsburgse Boys Rijnsburgse 30 60 42 50
6 Lisse Lisse 30 52 42 50
7 Capelle Capelle 30 54 41 49
8 Kozakken Boys Kozakken 30 61 59 47
9 VV Noordwijk Noordwijk 30 51 48 44
10 Excelsior .31 Excelsior 30 49 58 40
11 Scheveningen Scheveningen 30 45 46 39
12 IJsselmeervogels IJsselmeervo 30 44 48 39
13 Spakenburg Spakenburg 30 47 54 35
14 Genemuiden Genemuiden 30 63 74 32
15 Jodan Boys Jodan Boys 30 38 58 32
16 DETO Twenterand DETO 30 18 85 7
TEMPORADA 2011/2012
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 30 84 44 65
2 Rijnsburgse Boys Rijnsburgse 30 76 36 64
3 Katwijk Katwijk 30 78 41 55
4 VV Noordwijk Noordwijk 30 66 43 55
5 GVVV GVVV 30 70 56 53
6 IJsselmeervogels IJsselmeervo 30 67 50 48
7 Genemuiden Genemuiden 30 60 55 47
8 Excelsior .31 Excelsior 30 39 47 45
9 HHC Hardenberg Hardenberg 30 48 59 45
10 Capelle Capelle 30 47 46 42
11 Lisse Lisse 30 48 56 38
12 BVV Barendrecht Barendrecht 30 39 40 36
13 Harkemase Boys Harkemase 30 39 61 25
14 SVZW SVZW 30 36 72 25
15 Montfoort Montfoort 30 34 73 20
16 ARC Alphense Alphense 30 36 88 10
TEMPORADA 2010/2011
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 30 68 39 62
2 Spakenburg Spakenburg 30 83 41 60
3 Rijnsburgse Boys Rijnsburgse 30 69 46 51
4 Katwijk Katwijk 30 47 38 49
5 Excelsior .31 Excelsior 30 48 45 45
6 Capelle Capelle 30 46 36 44
7 Genemuiden Genemuiden 30 51 63 43
8 HHC Hardenberg Hardenberg 30 48 37 42
9 BVV Barendrecht Barendrecht 30 35 36 42
10 Harkemase Boys Harkemase 30 53 52 41
11 Lisse Lisse 30 52 51 41
12 ARC Alphense Alphense 30 42 61 33
13 Apeldoorn CSV Apeldoorn 30 47 70 32
14 Flevo Boys Flevo Boys 30 40 68 29
15 Sparta Nijkerk Sparta 30 35 58 28
16 Hoek Hoek 30 27 50 24
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 1
Equipo PJ GF GC Puntos
1 Rijnsburgse Boys Rijnsburgse 25 62 30 55
2 Lisse Lisse 26 51 28 53
3 VV Noordwijk Noordwijk 26 42 34 46
4 Kozakken Boys Kozakken 26 44 43 40
5 ASWH ASWH 25 50 43 39
6 DOTO DOTO 26 52 48 39
7 Katwijk Katwijk 26 45 43 37
8 Ter Leede Ter Leede 25 47 43 36
9 SHO SHO 26 46 52 31
10 TOGR TOGR 26 34 48 29
11 Capelle Capelle 26 38 45 28
12 Excelsior Maassluis Excelsior 26 34 47 27
13 Vitesse Delft Vitesse 26 47 70 26
14 Heerjansdam Heerjansdam 25 39 57 23
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,104,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1316
Total Execution Time  0.1335
  CADENA URL  
/historico/Rijnsburgse-Boys/2014
  GET DATOS  
$_GET['/historico/Rijnsburgse-Boys/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0032  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 = 'Rijnsburgse-Boys' AND l.year = 2014 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.0019  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=7136 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7136 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=7136 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 2461
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 = 3323
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7136 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7136 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (533785,1220698) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '7136' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '7136' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '7136' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 3323 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 2461 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=7136 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (20635,4005) 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 = 4005 AND teamId = 7136
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 20635 AND teamId = 7136
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 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 = 2461 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '7136' 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 = '7136' and rp.type = 4
0.0022  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 = '7136' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 events2014 e ON e.player_id = p.id AND e.league_id = 2461 WHERE rp.league_id = 2461 AND rp.teamId = 7136 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.0033  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 events2014 e ON e.player_id = p.id AND e.league_id = 2461 WHERE rp.league_id = 2461 AND rp.teamId = 7136 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 events2014 e ON e.player_id = p.id AND e.league_id = 2461 WHERE rp.league_id = 2461 AND rp.teamId = 7136 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 7136 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 2461 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 2184 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 1711 AND t.round = 30 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 `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 = 10820 AND t.round = 30 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 `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.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 `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.0027  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.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 `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 = 20389 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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.0028  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.0027  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 = 2461 ORDER BY nameShow LIMIT 100