4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del DUX Logroño Fem
TEMPORADA 2023/2024
PRIMERA FEDERACIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Deportivo Abanca Fem Deportivo 24 38 20 52
2 Barcelona B Fem Barcelona 23 48 17 51
3 Espanyol Fem Espanyol 24 41 16 48
4 Osasuna Fem Osasuna Fem 23 32 24 38
5 AEM Fem AEM Fem 23 21 14 38
6 Alhama ElPozo Fem Alhama 23 31 26 36
7 DUX Logroño Fem Logroño 23 28 30 31
8 Alba Fundación Fem Alba 23 25 28 29
9 Deportivo Alavés Fem Deportivo 23 24 25 28
10 Atlético B Fem Atlético 23 29 30 27
11 CP Cacereño Fem Cacereño 23 27 38 27
12 CE Europa Fem Europa 23 22 46 18
13 Athletic Club B Fem Athletic 24 18 35 17
14 Madrid CF B Fem Madrid 24 16 51 11
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona B Fem Barcelona 30 58 31 59
2 Eibar Fem Eibar Fem 30 31 18 53
3 Deportivo Abanca Fem Deportivo 30 52 29 53
4 Osasuna Fem Osasuna Fem 30 42 23 52
5 Granada CF Fem Granada 30 40 28 50
6 CP Cacereño Fem Cacereño 30 34 28 48
7 AEM Fem AEM Fem 30 35 30 47
8 DUX Logroño Fem Logroño 30 42 38 43
9 Espanyol Fem Espanyol 30 38 35 40
10 Alba Fundación Fem Alba 30 32 32 37
11 Athletic Club B Fem Athletic 30 34 51 36
12 Rayo Vallecano Fem Rayo 30 31 45 35
13 UDG Tenerife B Fem Tenerife 30 24 37 34
14 Real Oviedo Fem Real Oviedo 30 28 45 27
15 Córdoba CF Fem Córdoba 30 27 48 24
16 CD Juan Grande Fem Juan Grande 30 24 54 19
TEMPORADA 2021/2022
PRIMERA DIVISIÓN B FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem Levante 30 64 37 62
2 Espanyol Fem Espanyol 30 50 34 58
3 Osasuna Fem Osasuna Fem 30 56 33 57
4 DUX Logroño Fem Logroño 30 48 33 53
5 Barcelona B Fem Barcelona 30 52 32 51
6 Deportivo Abanca Fem Deportivo 30 49 29 51
7 AEM Fem AEM Fem 30 46 39 50
8 Real Oviedo Fem Real Oviedo 30 38 36 46
9 Zaragoza CFF Fem Zaragoza 30 45 45 43
10 Athletic Club B Fem Athletic 30 44 41 39
11 CD Parquesol Fem Parquesol 30 41 51 38
12 Racing Fem Racing Fem 30 37 43 38
13 Pradejon Fem Pradejon 30 32 53 30
14 Atlético B Fem Atlético 30 34 60 30
15 Real Sporting Fem Real 30 33 53 23
16 Seagull Fem Seagull Fem 30 23 73 9
TEMPORADA 2020/2021
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 34 167 15 99
2 Real Madrid Fem Real Madrid 34 75 33 74
3 Levante Fem Levante Fem 34 68 43 70
4 Atlético Fem Atlético 34 61 32 63
5 Real Sociedad Fem Real 34 66 44 61
6 Costa Adeje Tenerife Fem Costa Adeje 34 58 47 58
7 Madrid CFF Fem Madrid 34 49 44 53
8 Sevilla FC Fem Sevilla 34 42 50 45
9 Valencia Fem Valencia 34 51 60 44
10 Sporting Huelva Fem Sporting 34 37 48 44
11 Athletic Fem Athletic 34 43 60 40
12 Real Betis Fem Real Betis 34 34 62 35
13 Rayo Vallecano Fem Rayo 34 37 58 34
14 Eibar Fem Eibar Fem 34 32 62 33
15 Deportivo Abanca Fem Deportivo 34 39 81 29
16 Espanyol Fem Espanyol 34 31 70 25
17 DUX Logroño Fem Logroño 34 32 60 24
18 Santa Teresa Fem Santa Teresa 34 23 76 24
TEMPORADA 2019/2020
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 21 86 6 59
2 Atlético Fem Atlético 21 43 17 50
3 Levante Fem Levante Fem 21 40 21 45
4 Deportivo Abanca Fem Deportivo 21 46 38 37
5 Athletic Fem Athletic 21 30 23 35
6 Real Sociedad Fem Real 21 33 26 33
7 DUX Logroño Fem Logroño 21 31 41 29
8 Rayo Vallecano Fem Rayo 21 24 33 28
9 Costa Adeje Tenerife Fem Costa Adeje 21 24 35 24
10 Real Madrid Fem Real Madrid 21 33 48 23
11 Sevilla FC Fem Sevilla 21 25 33 22
12 Real Betis Fem Real Betis 21 25 33 20
13 Madrid CFF Fem Madrid 21 22 45 19
14 Sporting Huelva Fem Sporting 21 13 36 18
15 Valencia Fem Valencia 21 21 28 17
16 Espanyol Fem Espanyol 21 13 46 5
TEMPORADA 2018/2019
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Atlético Fem Atlético 30 96 19 84
2 Barcelona Fem Barcelona 30 94 15 78
3 Levante Fem Levante Fem 30 52 26 57
4 Costa Adeje Tenerife Fem Costa Adeje 30 46 40 54
5 Athletic Fem Athletic 30 48 33 50
6 Real Betis Fem Real Betis 30 47 35 48
7 Real Sociedad Fem Real 30 51 37 47
8 Valencia Fem Valencia 30 41 53 35
9 Espanyol Fem Espanyol 30 31 42 35
10 Sevilla FC Fem Sevilla 30 37 60 29
11 DUX Logroño Fem Logroño 30 38 60 29
12 Rayo Vallecano Fem Rayo 30 27 55 29
13 Madrid CFF Fem Madrid 30 31 65 27
14 Sporting Huelva Fem Sporting 30 22 50 25
15 Málaga CF Fem Málaga 30 26 67 25
16 Albacete Fem Albacete 30 38 68 24
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 DUX Logroño Fem Logroño 26 63 23 63
2 Athletic Club B Fem Athletic 26 96 28 61
3 Eibar Fem Eibar Fem 26 60 30 56
4 Osasuna Fem Osasuna Fem 26 50 26 50
5 SD San Ignacio Fem Ignacio 26 54 36 45
6 Oiartzun KE Fem Oiartzun 26 47 34 41
7 Añorga KKE Fem Añorga 26 48 40 40
8 Mulier FCN Fem Mulier 26 40 33 33
9 Pradejon Fem Pradejon 26 34 59 29
10 Aurrera Vitoria Fem Aurrera 26 37 56 29
11 Gasteizko Femenino Gasteizko 26 53 56 28
12 Pauldarrak Pauldarrak 26 36 51 27
13 Zarautz Zarautz 26 26 85 10
14 Ardoi Ardoi 26 11 98 4
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Athletic Club B Fem Athletic 26 81 26 68
2 SD San Ignacio Fem Ignacio 26 62 34 56
3 DUX Logroño Fem Logroño 26 59 20 55
4 Mulier FCN Fem Mulier 26 42 31 43
5 Añorga KKE Fem Añorga 26 50 42 36
6 Eibar Fem Eibar Fem 26 33 40 36
7 Aurrera Vitoria Fem Aurrera 26 52 51 34
8 Gasteizko Femenino Gasteizko 26 32 47 31
9 Pauldarrak Pauldarrak 26 34 46 31
10 Ardoi Ardoi 26 45 55 30
11 Burgos CF Fem Burgos 26 28 54 28
12 CD Mariño CD Mariño 26 18 40 26
13 CD Arratia Fem Arratia 26 34 61 26
14 Berriozar Fem Berriozar 26 36 59 23
TEMPORADA 2015/2016
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 DUX Logroño Fem Logroño 26 77 16 72
2 Mulier FCN Fem Mulier 26 81 38 62
3 Athletic Club B Fem Athletic 26 74 30 59
4 Añorga KKE Fem Añorga 26 69 44 52
5 Ardoi Ardoi 26 53 35 44
6 Aurrera Vitoria Fem Aurrera 26 62 53 37
7 Burgos CF Fem Burgos 26 31 68 29
8 SD San Ignacio Fem Ignacio 26 31 36 29
9 CD Mariño CD Mariño 26 35 39 27
10 Eibar Fem Eibar Fem 26 46 42 27
11 Pauldarrak Pauldarrak 26 40 69 23
12 CD Peñas Oscenses Fem Peñas 26 37 89 22
13 Leioako Leioako 26 28 71 17
14 Capiscol Capiscol 26 24 58 15
TEMPORADA 2014/2015
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Oiartzun KE Fem Oiartzun 26 111 13 70
2 Athletic Club B Fem Athletic 26 101 20 66
3 Aurrera Vitoria Fem Aurrera 26 75 43 55
4 Barakaldo CF Femenino Barakaldo 26 74 42 47
5 SD San Ignacio Fem Ignacio 26 50 27 47
6 DUX Logroño Fem Logroño 25 59 35 46
7 Añorga KKE Fem Añorga 26 56 49 41
8 CD Mariño CD Mariño 26 38 35 32
9 Abanto Club Abanto Club 26 34 62 25
10 Burgos CF Fem Burgos 26 32 72 24
11 Ardoi Ardoi 26 34 57 22
12 Sd Reocín Sd Reocín 26 48 68 21
13 Gazte Berriak Fem Gazte 25 21 95 10
14 Ud Aragonesa Aragonesa 26 12 127 5
TEMPORADA 2013/2014
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Athletic Club B Fem Athletic 26 70 26 65
2 Oiartzun KE Femenino Oiartzun 26 81 23 57
3 Osasuna Fem Osasuna Fem 26 64 33 46
4 SD Reocín Femenino Reocín 26 63 35 44
5 Añorga KKE Femenino Añorga 26 59 37 44
6 Pauldarrak Pauldarrak 26 64 47 41
7 SD San Ignacio Fem Ignacio 26 36 32 41
8 CD Aurrera de Vitoria Femen Aurrera 26 77 47 41
9 DUX Logroño Fem Logroño 26 54 36 38
10 Club Abanto Femenino Club Abanto 26 43 59 29
11 AD San Juan Femenino Juan 26 39 39 28
12 Barakaldo CF Femenino Barakaldo 26 32 50 21
13 CD Lagunak Femenino Lagunak 26 24 54 17
14 CF Mondragón Femenino Mondragón 26 3 191 1
TEMPORADA 2012/2013
TERCERA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Añorga KKE Fem Añorga 26 62 28 59
2 Sd San Ignacio Ignacio 26 41 25 52
3 Oiartzun KE Fem Oiartzun 26 63 29 50
4 Osasuna Fem Osasuna Fem 26 50 31 48
5 Athletic Club B Athletic 26 62 25 46
6 Aurrera Vitoria Fem Aurrera 26 53 29 46
7 Ad San Juan Ad San Juan 26 39 28 46
8 Pauldarrak Efkt Pauldarrak 26 46 30 45
9 DUX Logroño Fem Logroño 26 31 45 29
10 Abanto Club Abanto Club 26 36 36 28
11 Mondragón Cf Mondragón 26 28 37 25
12 Zarauzko Ke Femenino Zarauzko 26 37 79 14
13 Sd Eibar Sd Eibar 25 20 92 7
14 CD Castejón Fem Castejón 25 18 72 5

  USO DE MEMORIA  
6,297,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4246
Total Execution Time  0.4265
  CADENA URL  
/historico/Edf-Logrono-Femenina
  GET DATOS  
$_GET['/historico/Edf-Logrono-Femenina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0115  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 = 'Edf-Logrono-Femenina' 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.0105  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=51737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=51737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=51737 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=51737 AND type_rel = 2
0.0109  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 51737 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  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 (590587,457894,452235,461070,470755) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '51737' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '51737' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '51737' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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=51737 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (74006,73472) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 73472 AND teamId = 51737
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 51737
0.0107  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 = '51737' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '51737' and rp.type = 4
0.0107  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 = '51737' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0108  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 51737 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.0109  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 51737 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 51737 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 51737 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 = 63312 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.0109  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 = 56927 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 49997 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 43685 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 39303 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 35129 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 16652 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 4391 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2748 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 2116 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC