4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rioseco
TEMPORADA 2023/2024
1ª CASTILLA Y LEÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Villa de Simancas Villa 28 71 30 64
2 UD Sur UD Sur 28 80 56 60
3 CD Victoria CF Victoria 27 70 35 56
4 Atlético Tordesillas B Atlético 28 64 43 51
5 Boecillo Boecillo 28 73 48 49
6 La Pedraja La Pedraja 28 50 49 45
7 Rioseco Rioseco 28 63 49 41
8 Unión Arroyo Unión 27 47 56 39
9 Arces Arces 27 46 46 37
10 Betis CF B Betis CF B 28 61 59 34
11 Universidad de Valladolid Universidad 28 48 56 33
12 CD Medinense Medinense 27 43 72 31
13 Racing Valdestillas Racing 28 39 42 29
14 CD San Agustin Agustin 28 57 76 25
15 CD Laguna B CD Laguna B 27 36 81 20
16 Rayo Cenobia Rayo Cenobia 27 26 76 7
TEMPORADA 2022/2023
1ª CASTILLA Y LEÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Gimnástica Medinense Gimnástica 30 79 42 75
2 Universidad de Valladolid Universidad 30 86 28 66
3 Betis CF B Betis CF B 30 59 37 52
4 Rioseco Rioseco 30 57 51 47
5 Unión Arroyo Unión 30 70 58 46
6 Rayo Cenobia Rayo Cenobia 30 61 52 46
7 Boecillo Boecillo 30 61 57 45
8 Racing Valdestillas Racing 30 38 45 43
9 CD San Agustin Agustin 30 63 65 42
10 UD Sur UD Sur 30 60 62 42
11 Atlético Tordesillas B Atlético 30 50 52 38
12 Arces Arces 30 51 60 33
13 CD Don Bosco Bosco 30 55 79 30
14 M. Olmedo M. Olmedo 30 43 73 24
15 Parquesol Parquesol 30 30 69 21
16 San Pío X San Pío X 30 38 71 17
TEMPORADA 2021/2022
1ª CASTILLA Y LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Rioseco Rioseco 18 39 21 35
2 Universidad de Valladolid Universidad 18 37 21 35
3 CD San Agustin Agustin 18 40 23 33
4 CD Victoria CF Victoria 18 29 16 33
5 Parquesol Parquesol 18 38 25 31
6 Boecillo Boecillo 18 27 26 27
7 UD Sur UD Sur 18 39 45 27
8 Arces Arces 18 30 40 23
9 CD Don Bosco Bosco 18 25 42 13
10 Racing de Mayorga Racing 18 11 56 3
TEMPORADA 2016/2017
1ª CASTILLA Y LEÓN GRUPO 8
Equipo PJ GF GC Puntos
1 La Cisterniga Cisterniga 20 60 22 47
2 Gimnástica Medinense Gimnástica 20 46 17 41
3 Boecillo Boecillo 20 36 17 39
4 La Pedraja La Pedraja 20 59 26 37
5 CD San Agustin Agustin 20 54 27 36
6 Juventud Rondilla Juventud 20 56 33 35
7 Navarrés Navarrés 20 37 22 35
8 Rioseco Rioseco 20 33 22 35
9 M. Olmedo M. Olmedo 20 52 37 34
10 U.D.C. Sur U.D.C. Sur 20 31 35 27
11 Mojados B Mojados B 20 29 38 25
12 Belen Belen 20 39 53 20
13 Villa de Simancas B Villa 20 39 50 19
14 Arces Arces 20 34 46 16
15 Rueda Rueda 20 26 51 14
16 San Isidro San Isidro 20 12 147 0
TEMPORADA 2015/2016
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Unionistas CF Unionistas 34 114 27 88
2 Zamora B Zamora B 34 70 32 71
3 CD Villa de Simancas Villa 34 76 32 64
4 Betis CF Betis CF 34 64 36 62
5 CD Mojados CD Mojados 34 68 44 62
6 Béjar Industrial Béjar 34 65 53 59
7 CD Ejido CD Ejido 34 50 47 47
8 Fresno de La Ribera Fresno 34 59 78 43
9 CD Onzonilla Onzonilla 34 41 61 40
10 Peñaranda Bracamonte Peñaranda 34 49 61 40
11 CD Navega CD Navega 34 41 58 40
12 Carbajosa De La Sagrada Carbajosa 34 43 56 39
13 Laguna CD Laguna CD 34 52 59 39
14 Veguellina CF Veguellina 34 32 57 37
15 La Virgen del Camino B Virgen 34 41 56 35
16 Navarrés Navarrés 34 61 93 33
17 Rioseco Rioseco 34 45 81 29
18 U.D.C. Sur U.D.C. Sur 34 50 90 29
TEMPORADA 2014/2015
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UD Santa Marta Santa Marta 32 93 21 75
2 Ciudad Rodrigo Ciudad 32 51 17 68
3 CD Ejido CD Ejido 32 52 27 59
4 Zamora B Zamora B 32 47 34 52
5 CD Mojados CD Mojados 32 65 54 48
6 Arroyo Pisuerga Arroyo 32 53 34 47
7 CD Onzonilla Onzonilla 32 49 43 44
8 Betis CF Betis CF 32 47 44 44
9 Veguellina CF Veguellina 32 38 45 43
10 Rioseco Rioseco 32 40 55 43
11 Béjar Industrial Béjar 32 48 51 41
12 Navarrés Navarrés 32 59 63 41
13 Carbajosa De La Sagrada Carbajosa 32 35 48 37
14 Gimnástica Medinense Gimnástica 32 36 53 35
15 Peñaranda Bracamonte Peñaranda 32 28 51 35
16 CD Navega CD Navega 32 36 64 34
17 Universidad de Valladolid Universidad 32 41 57 31
18 Racing Club Benavente Racing Club 32 36 93 20
TEMPORADA 2013/2014
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Villaralbo Villaralbo 32 61 28 68
2 CD Villa de Simancas Villa 32 64 39 64
3 CD Onzonilla Onzonilla 32 58 37 60
4 CD Mojados CD Mojados 32 49 34 49
5 CD Ejido CD Ejido 32 47 39 48
6 Universidad de Valladolid Universidad 32 47 45 45
7 Carbajosa De La Sagrada Carbajosa 32 43 34 44
8 Gimnástica Medinense Gimnástica 32 38 56 44
9 Béjar Industrial Béjar 32 40 48 40
10 Peñaranda Bracamonte Peñaranda 32 33 39 39
11 Rioseco Rioseco 32 44 58 39
12 CD Navega CD Navega 32 38 42 39
13 Betis CF Betis CF 32 38 52 39
14 Navarrés Navarrés 32 52 62 38
15 Zamora B Zamora B 32 37 45 37
16 Guijuelo B Guijuelo B 32 40 36 37
17 Benavente Benavente 32 33 68 24
18 CD Huracán Z Huracán 0 0 0 0
TEMPORADA 2011/2012
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Marta Santa Marta 32 73 20 69
2 Carbajosa De La Sagrada Carbajosa 31 55 35 60
3 CD Laguna CD Laguna 31 45 21 52
4 Rioseco Rioseco 31 38 36 50
5 Zamora B Zamora B 31 50 38 48
6 La Bañeza La Bañeza 31 53 45 47
7 Navarrés Navarrés 31 43 56 47
8 Cd Mojados Cd Mojados 31 49 49 46
9 CD Villaralbo B Villaralbo 31 37 50 46
10 Peñaranda Bracamonte Peñaranda 31 43 51 40
11 Benavente Benavente 32 59 77 40
12 CD Navega CD Navega 31 48 49 39
13 CD Victoria CF Victoria 31 50 56 36
14 Gimnástica Medinense Gimnástica 31 45 52 36
15 Flores Del Sil Flores 31 41 55 36
16 Hullera Vasco Leonesa Hullera 32 47 48 35
17 Real Salamanca Monterrey Real 31 35 73 22
TEMPORADA 2010/2011
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Salamanca Sub 19 B Salamanca 34 106 27 91
2 La Virgen del Camino Virgen 34 72 24 78
3 Béjar Industrial Béjar 34 62 26 69
4 Gimnástica Medinense Gimnástica 34 57 39 66
5 CD Victoria CF Victoria 34 53 44 56
6 CD Laguna CD Laguna 34 50 37 50
7 Rioseco Rioseco 34 48 49 49
8 Zamora B Zamora B 33 48 44 48
9 Uni. Valladolid Uni. 34 61 65 48
10 Flores Del Sil Flores 34 55 56 46
11 Benavente Benavente 34 56 64 45
12 Navarrés Navarrés 33 67 65 43
13 Navega Sub 19 Navega 34 40 49 43
14 La Bañeza La Bañeza 34 36 50 39
15 Carbajosa De La Sagrada Carbajosa 34 49 58 38
16 Guijuelo B Guijuelo B 34 42 51 38
17 Cd Villamor Cd Villamor 34 30 103 12
18 Ciudad Rodrigo Ciudad 34 33 114 7
TEMPORADA 2009/2010
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Ponferradina B Ponferradina 34 102 32 80
2 Benavente Benavente 34 86 42 73
3 Rioseco Rioseco 34 60 27 70
4 U.Valladolid U.Valladolid 34 65 45 55
5 Béjar Industrial Béjar 34 55 55 51
6 Guijuelo B Guijuelo B 34 47 38 49
7 CD Laguna CD Laguna 34 58 52 47
8 Navarrés Navarrés 34 57 70 46
9 La Virgen del Camino Virgen 34 46 39 44
10 Gimnástica Medinense Gimnástica 34 49 63 42
11 Zamora B Zamora B 34 43 49 41
12 Carbajosa De La Sagrada Carbajosa 34 44 52 41
13 La Bañeza La Bañeza 34 45 60 38
14 Ciudad Rodrigo Ciudad 34 42 55 36
15 Morales Del Vino Morales Vino 34 47 78 34
16 Coreses Coreses 34 46 82 34
17 Santovenia Santovenia 34 43 67 33
18 Arenas De Vega Arenas Vega 34 32 61 32
TEMPORADA 2008/2009
PREFERENTE C. LEÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Villaralbo Villaralbo 33 82 34 75
2 Atlético Tordesillas Atlético 33 69 23 75
3 CD Laguna CD Laguna 33 56 35 67
4 Rioseco Rioseco 33 46 35 60
5 Guijuelo B Guijuelo B 33 58 38 59
6 Ponferradina B Ponferradina 33 69 43 58
7 Gimnástica Medinense Gimnástica 33 49 50 48
8 Ciudad Rodrigo Ciudad 33 42 43 47
9 Benavente Benavente 33 46 56 41
10 La Bañeza La Bañeza 33 46 59 40
11 U.Valladolid U.Valladolid 33 50 56 39
12 Béjar Industrial Béjar 33 54 59 38
13 Villamayor Villamayor 33 51 58 35
14 La Virgen del Camino Virgen 33 34 57 34
15 Santovenia Santovenia 33 46 59 33
16 Zamora B Zamora B 33 45 58 33
17 Hullera Vasco Leonesa Hullera 33 28 60 29
18 Pinilla Zamora Pinilla 28 27 73 14
19 Pinilla Pinilla 5 4 6 7

  USO DE MEMORIA  
6,252,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5662
Total Execution Time  0.5674
  CADENA URL  
/historico/Rioseco
  GET DATOS  
$_GET['/historico/Rioseco']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0140  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 = 'Rioseco' 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.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=2165 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=2165 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 73906
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2165 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1298 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1298 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131  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 (1312772,1202745,912076,807251,716314) ORDER BY n.cover_points DESC, update_date DESC
0.0138  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 = '2165' ORDER BY l.year DESC,cat.coefficient DESC
0.0141  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 = '2165' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '2165' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 73906 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=2165 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 (73906) 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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 73906 AND teamId = 2165
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 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 = 73906 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '2165' 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 = '2165' and rp.type = 4
0.0130  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 = '2165' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 = 73906 WHERE rp.league_id = 73906 AND rp.teamId = 2165 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.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 = 73906 WHERE rp.league_id = 73906 AND rp.teamId = 2165 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73906 WHERE rp.league_id = 73906 AND rp.teamId = 2165 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 = 2165 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 73906 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 69054 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.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 `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 = 65692 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 34576 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16750 AND t.round = 34 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 `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 = 4091 AND t.round = 34 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 `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 = 2682 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 `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 = 1466 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 1152 AND t.round = 34 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 `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 = 854 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 311 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC