4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Logroñés

SD Logroñés

Entrenador: Aitor Larrazabal

Temporada 2019/2020
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 SD Logroñés Logroñés 28 68 12 70
2 CD Varea CD Varea 28 83 22 70
3 Casalarreina Casalarreina 28 59 26 61
4 Arnedo Arnedo 28 55 30 60
5 UD Logroñés B Logroñés 28 69 23 56
6 Anguiano Anguiano 28 64 35 55
7 Náxara Náxara 28 71 37 52
8 Oyonesa Oyonesa 28 51 36 46
9 CD Calahorra B Calahorra 28 49 38 46
10 CD Alfaro CD Alfaro 28 54 41 40
11 River Ebro River Ebro 28 42 47 33
12 CD Berceo CD Berceo 28 50 61 33
13 Pradejón Pradejón 28 36 53 27
14 Vianés Vianés 28 30 47 27
15 Alberite Alberite 28 32 59 26
16 Comillas CF Comillas CF 28 32 61 24
17 Calasancio Calasancio 28 20 65 22
18 La Calzada La Calzada 28 25 56 19
19 Yagüe Yagüe 28 20 73 16
20 Villegas Villegas 28 13 101 7
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 Haro Deportivo Haro 38 96 17 97
2 SD Logroñés Logroñés 38 98 29 91
3 Náxara Náxara 38 79 36 83
4 UD Logroñés B Logroñés 38 75 35 78
5 River Ebro River Ebro 38 76 48 78
6 CD Varea CD Varea 38 71 42 69
7 Anguiano Anguiano 38 77 49 67
8 CD Alfaro CD Alfaro 38 57 41 60
9 Yagüe Yagüe 38 59 60 53
10 Pradejón Pradejón 38 50 48 51
11 Oyonesa Oyonesa 38 41 43 45
12 Arnedo Arnedo 38 50 64 44
13 La Calzada La Calzada 38 49 73 40
14 CD Berceo CD Berceo 38 49 67 35
15 Alberite Alberite 38 41 90 35
16 Vianés Vianés 38 35 67 33
17 Calasancio Calasancio 38 29 71 33
18 Rapid de Murillo Rapid 38 39 84 28
19 Agoncillo Agoncillo 38 31 91 25
20 Autol Autol 38 29 76 25
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 CD Calahorra Calahorra 38 131 11 104
2 SD Logroñés Logroñés 38 111 21 101
3 Náxara Náxara 38 111 40 87
4 Haro Deportivo Haro 38 91 31 87
5 CD Varea CD Varea 38 84 42 78
6 Anguiano Anguiano 38 102 59 75
7 CD Alfaro CD Alfaro 38 84 43 69
8 UD Logroñés B Logroñés 38 79 48 65
9 CD Berceo CD Berceo 38 45 79 46
10 Pradejón Pradejón 38 55 69 45
11 River Ebro River Ebro 38 47 76 40
12 Yagüe Yagüe 38 57 112 40
13 Arnedo Arnedo 38 55 92 38
14 Vianés Vianés 38 33 73 35
15 Calasancio Calasancio 38 34 71 33
16 Agoncillo Agoncillo 38 46 80 33
17 Oyonesa Oyonesa 38 45 86 31
18 Casalarreina Casalarreina 38 37 86 31
19 CD Tedeón CD Tedeón 38 38 86 27
20 Villegas Villegas 38 26 106 21
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 CD Calahorra Calahorra 38 116 20 95
2 Náxara Náxara 38 117 30 91
3 SD Logroñés Logroñés 38 110 25 91
4 Anguiano Anguiano 38 115 40 91
5 Haro Deportivo Haro 38 115 33 91
6 CD Varea CD Varea 38 95 28 88
7 CD Alfaro CD Alfaro 38 78 56 75
8 UD Logroñés B Logroñés 38 64 45 65
9 Agoncillo Agoncillo 38 50 60 45
10 Oyonesa Oyonesa 38 45 74 39
11 Vianés Vianés 38 46 114 38
12 River Ebro River Ebro 38 50 81 38
13 CD Tedeón CD Tedeón 38 43 68 37
14 Arnedo Arnedo 38 39 66 35
15 Casalarreina Casalarreina 38 42 78 33
16 Villegas Villegas 38 37 85 33
17 Calasancio Calasancio 38 23 77 31
18 La Calzada La Calzada 38 35 84 29
19 San Marcial San Marcial 38 44 110 22
20 Rapid de Murillo Rapid 38 24 114 13
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 CD Calahorra Calahorra 38 110 19 99
2 SD Logroñés Logroñés 38 102 23 96
3 Haro Deportivo Haro 38 115 19 94
4 Náxara Náxara 38 98 37 91
5 CD Varea CD Varea 38 98 44 76
6 Anguiano Anguiano 38 74 36 75
7 CD Alfaro CD Alfaro 38 48 52 54
8 Agoncillo Agoncillo 38 49 57 48
9 Calasancio Calasancio 38 41 59 48
10 Oyonesa Oyonesa 38 51 69 45
11 River Ebro River Ebro 38 44 60 39
12 San Marcial San Marcial 38 33 57 36
13 Vianés Vianés 38 36 68 35
14 Villegas Villegas 38 30 64 34
15 La Calzada La Calzada 38 39 71 34
16 CD Tedeón CD Tedeón 38 34 75 34
17 Arnedo Arnedo 38 42 90 33
18 Pradejón Pradejón 38 28 69 33
19 Peña Balsamaiso CF Peña 38 52 96 30
20 Alberite Alberite 38 40 99 25
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 CD Varea CD Varea 38 123 29 98
2 CD Calahorra Calahorra 38 102 23 96
3 SD Logroñés Logroñés 38 105 34 92
4 Haro Deportivo Haro 38 93 25 85
5 Náxara Náxara 38 80 36 78
6 Anguiano Anguiano 38 65 34 74
7 CD Alfaro CD Alfaro 38 73 40 74
8 Agoncillo Agoncillo 38 69 49 63
9 La Calzada La Calzada 38 54 63 51
10 Oyonesa Oyonesa 38 35 52 50
11 Vianés Vianés 38 39 55 46
12 River Ebro River Ebro 38 52 75 41
13 Peña Balsamaiso CF Peña 38 38 74 37
14 Arnedo Arnedo 38 31 51 35
15 CD Tedeón CD Tedeón 38 29 78 32
16 Calasancio Calasancio 38 40 62 32
17 Villegas Villegas 38 23 65 31
18 Yagüe Yagüe 38 39 96 28
19 CF Ciudad Alfaro Ciudad 38 24 80 21
20 Casalarreina Casalarreina 38 25 118 14
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Racing 36 55 27 66
2 Racing Ferrol Racing 36 58 35 63
3 Real Avilés Industrial Real Avilés 36 53 31 63
4 Guijuelo Guijuelo 36 49 31 60
5 Real Oviedo Real Oviedo 36 52 42 57
6 Marino de Luanco Marino 36 50 34 54
7 Zamora Zamora 36 43 40 54
8 Sporting Atlético Sporting 36 52 50 50
9 CD Ourense CD Ourense 36 36 34 50
10 Burgos Burgos 36 38 44 46
11 UD Logroñés Logroñés 36 33 45 46
12 Tropezón Tropezón 36 38 55 44
13 SD Compostela Compostela 36 53 46 44
14 Cultural Leonesa Cultural 36 39 43 44
15 Coruxo Coruxo 36 38 47 44
16 Caudal Deportivo Caudal 36 41 50 39
17 SD Logroñés Logroñés 36 36 52 38
18 Celta Fortuna Celta 36 37 61 34
19 Noja Noja 36 36 70 24
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 38 57 22 82
2 Eibar Eibar 38 59 28 73
3 Bilbao Ath. Bilbao Ath. 38 64 35 71
4 Lleida Esportiu Lleida 38 56 34 66
5 Barakaldo Barakaldo 38 42 23 65
6 SD Amorebieta Amorebieta 38 48 39 60
7 Tudelano Tudelano 38 48 46 56
8 Real Unión Club Real Unión 38 53 39 55
9 Noja Noja 38 43 48 47
10 SD Logroñés Logroñés 38 37 60 46
11 Real Sociedad B Real 38 37 45 46
12 Sestao River Sestao River 38 34 40 43
13 Gimnástica Torrelavega Gimnástica 38 36 46 42
14 UD Logroñés Logroñés 38 27 37 42
15 Peña Sport Peña Sport 38 35 41 41
16 Deportivo Aragón Deportivo 38 44 52 41
17 Rayo Cantabria Rayo 38 37 52 41
18 CD Teruel CD Teruel 38 33 52 38
19 Osasuna Promesas Osasuna 38 40 65 36
20 Izarra Izarra 38 31 57 35
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 SD Logroñés Logroñés 38 91 30 96
2 CD Alfaro CD Alfaro 38 96 34 94
3 Haro Deportivo Haro 38 95 17 90
4 CD Varea CD Varea 38 91 40 79
5 Náxara Náxara 38 68 38 76
6 UD Logroñés B Logroñés 38 74 41 74
7 Anguiano Anguiano 38 58 37 65
8 Oyonesa Oyonesa 38 62 40 60
9 CD Calahorra Calahorra 38 64 46 58
10 Arnedo Arnedo 38 48 36 52
11 River Ebro River Ebro 38 39 63 43
12 Vianés Vianés 38 47 60 40
13 Pradejón Pradejón 38 36 77 37
14 Agoncillo Agoncillo 38 32 57 36
15 CD Berceo CD Berceo 38 37 59 34
16 San Marcial San Marcial 38 29 74 34
17 Calasancio Calasancio 38 32 62 29
18 CF Ciudad Alfaro Ciudad 38 27 78 22
19 CD Tedeón CD Tedeón 38 30 88 22
20 Bañuelos Bañuelos 38 27 106 15
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 Náxara Náxara 38 74 27 88
2 SD Logroñés Logroñés 38 78 29 88
3 Anguiano Anguiano 38 64 27 77
4 Haro Deportivo Haro 38 72 24 76
5 UD Logroñés B Logroñés 38 72 28 76
6 Arnedo Arnedo 38 67 26 76
7 CD Alfaro CD Alfaro 38 71 37 71
8 Oyonesa Oyonesa 38 72 40 70
9 CD Calahorra Calahorra 38 54 36 60
10 CD Varea CD Varea 38 57 42 53
11 CD Ebro CD Ebro 38 45 46 53
12 Calasancio Calasancio 38 31 46 38
13 Vianés Vianés 38 51 64 38
14 CD Berceo CD Berceo 38 33 52 33
15 San Marcial San Marcial 38 30 71 32
16 Agoncillo Agoncillo 38 28 53 32
17 Cenicero Cenicero 38 31 80 28
18 Pradejón Pradejón 38 27 74 27
19 Aldeano Aldeano 38 31 110 24
20 AF Calahorra Calahorra 38 27 103 20
TEMPORADA 2009/2010
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 SD Logroñés Logroñés 36 159 21 106
2 CD Varea CD Varea 37 98 33 91
3 UD Logroñés B Logroñés 38 96 29 88
4 Casalarreina Casalarreina 38 75 65 62
5 CD Tedeón CD Tedeón 38 71 54 60
6 Náxara B Náxara B 37 56 53 58
7 CD San Lorenzo Lorenzo 32 73 50 56
8 La Calzada La Calzada 38 65 62 55
9 Anguiano B Anguiano B 40 50 67 53
10 UF Rioja UF Rioja 36 60 59 50
11 Oyonesa B Oyonesa B 37 53 56 48
12 Calasancio B Calasancio 38 44 60 48
13 Bañuelos Bañuelos 37 49 72 46
14 Club Atlético Vianés B Club 38 55 68 41
15 Rapid de Murillo Rapid 38 48 70 39
16 Haro Promesas Haro 38 49 68 37
17 Autol Autol 37 38 68 35
18 Celta Cenicero Celta 38 50 98 32
19 Albelda Atletic Albelda 38 37 104 15
20 Santa María Santa María 38 28 105 13
21 CF Ciudad Alfaro Ciudad 5 13 5 9

  USO DE MEMORIA  
7,076,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1406
Total Execution Time  0.1418
  CADENA URL  
/historico/Sd-Logrones/2020
  GET DATOS  
$_GET['/historico/Sd-Logrones/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0030  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 = 'Sd-Logrones' AND l.year = 2020 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=4823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=4823 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=4823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=4823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4823 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 (755,1236,38399,50954,70823) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '4823' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '4823' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '4823' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 51355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=4823 AND l.year in (2019,2020,2021) 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 (61719,59872,58609,56547,56536,50284) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 58609 AND teamId = 4823
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 50284 AND teamId = 4823
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 59872 AND teamId = 4823
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 61719 AND teamId = 4823
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 56536 AND teamId = 4823
0.0101  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 4823
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 = '4823' 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 = '4823' and rp.type = 4
0.0024  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 = '4823' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4823' and rp.type = 4
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 events2020 e ON e.player_id = p.id AND e.league_id = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 4823 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 events2020 e ON e.player_id = p.id AND e.league_id = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 4823 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2020 e ON e.player_id = p.id AND e.league_id = 51355 WHERE rp.league_id = 51355 AND rp.teamId = 4823 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 4823 AND l.year <= 2020 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 `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 = 50284 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.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 `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 = 44404 AND t.round = 38 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 `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 = 39040 AND t.round = 38 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 `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 = 33366 AND t.round = 38 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 = 15458 AND t.round = 38 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 = 3925 AND t.round = 38 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 `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 = 1903 AND t.round = 38 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 `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 = 1448 AND t.round = 38 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 `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 = 1158 AND t.round = 38 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 `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 = 947 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC