4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spar Gran Canaria Fem
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 UDG Tenerife B Fem Tenerife 26 45 10 57
2 Getafe Fem Getafe Fem 26 44 18 55
3 Real Union Tacuense Fem Real Union. 26 39 26 48
4 Fundación Canaria CDT Fundación 26 37 22 47
5 CD Juan Grande Fem Juan Grande 26 33 21 44
6 Elche CF Fem Elche 27 49 35 42
7 Málaga CF Fem Málaga 27 39 37 38
8 Levante B Fem Levante 26 38 37 37
9 Guiniguada Apolinario Fem Guiniguada 26 28 36 37
10 CFF Cáceres Fem Cáceres 27 27 37 34
11 Córdoba CF Fem Córdoba 26 30 36 29
12 Valencia B Fem Valencia 27 25 41 29
13 Spar Gran Canaria Fem Spar Gran C. 26 26 30 26
14 Unión Viera Fem Unión Viera 26 22 44 23
15 CFF Albacete Fem Albacete 26 14 47 19
16 La Solana Fem Solana 26 17 36 18
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Madrid CF B Fem Madrid 30 67 25 69
2 Levante B Fem Levante 30 60 20 67
3 Atlético Baleares Fem Atlético 30 61 26 66
4 Spar Gran Canaria Fem Spar Gran C. 30 50 29 58
5 Fundación Canaria CDT Fundación 30 49 34 53
6 Real Betis B Fem Real Betis 30 54 31 51
7 Valencia B Fem Valencia 30 58 45 49
8 CFF Cáceres Fem Cáceres 30 42 30 45
9 Real Union Tacuense Fem Real Union. 30 54 43 45
10 Málaga CF Fem Málaga 30 40 34 45
11 CFF Albacete Fem Albacete 30 29 46 34
12 Unión Viera Fem Unión Viera 30 35 55 29
13 La Solana Fem Solana 30 20 40 26
14 Almería Fem Almería 30 29 52 26
15 Pozoalbense Fem Pozoalbense 30 31 79 20
16 Santa Teresa Fem Santa Teresa 30 0 90 0
TEMPORADA 2021/2022
PRIMERA DIVISIÓN B FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Alhama ElPozo Fem Alhama 30 65 33 62
2 CP Cacereño Fem Cacereño 30 53 39 53
3 Granada CF Fem Granada 30 46 31 53
4 CD Juan Grande Fem Juan Grande 30 41 32 51
5 UDG Tenerife B Fem Tenerife 30 36 33 47
6 Alba Fundación Fem Alba 30 62 51 47
7 Madrid CF B Fem Madrid 30 54 46 46
8 Córdoba CF Fem Córdoba 30 42 34 45
9 Santa Teresa Fem Santa Teresa 30 38 30 44
10 Spar Gran Canaria Fem Spar Gran C. 30 48 49 37
11 Real Union Tacuense Fem Real Union. 30 35 41 36
12 Pozoalbense Fem Pozoalbense 30 40 57 33
13 La Solana Fem Solana 30 32 37 28
14 Real Betis B Fem Real Betis 30 33 55 28
15 Elche CF Fem Elche 30 37 54 28
16 CD Castellón Fem Castellón 30 26 66 23
TEMPORADA 2020/2021
PRIMERA DIVISIÓN B FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 CD Juan Grande Fem Juan Grande 24 29 26 36
2 Córdoba CF Fem Córdoba 24 36 34 36
3 La Solana Fem Solana 24 27 28 31
4 Spar Gran Canaria Fem Spar Gran C. 24 26 23 27
5 CD Castellón Fem Castellón 24 33 42 27
6 Levante B Fem Levante 24 31 43 26
7 UD Aldaia Fem Aldaia 24 24 38 22
8 Málaga CF Fem Málaga 24 30 40 20
9 Valencia B Fem Valencia 24 19 55 18
TEMPORADA 2019/2020
PRIMERA DIVISIÓN B FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Teresa Fem Santa Teresa 22 43 15 51
2 Granada CF Fem Granada 22 43 15 50
3 Albacete Fem Albacete 22 48 16 47
4 Villarreal Fem Villarreal 22 37 24 42
5 Málaga CF Fem Málaga 22 28 21 36
6 Alhama ElPozo Fem Alhama 22 40 31 35
7 Pozoalbense Fem Pozoalbense 22 36 39 32
8 Córdoba CF Fem Córdoba 22 21 21 31
9 CP Cacereño Fem Cacereño 22 36 36 30
10 UDG Tenerife B Fem Tenerife 22 27 36 28
11 Spar Gran Canaria Fem Spar Gran C. 22 34 36 27
12 Levante B Fem Levante 22 31 33 24
13 Valencia B Fem Valencia 22 24 34 21
14 CD Juan Grande Fem Juan Grande 22 28 39 16
15 Real Union Tacuense Fem Real Union. 22 18 57 12
16 Collerense Fem Collerense 22 31 72 9
TEMPORADA 2018/2019
TERCERA FEDERACIÓN FEMENINA GRUPO 7
Equipo PJ GF GC Puntos
1 Spar Gran Canaria Fem Spar Gran C. 26 255 7 75
2 Unión Viera Fem Unión Viera 26 166 21 72
3 CD Juan Grande Fem Juan Grande 26 255 15 69
4 Las Majoreras Fem Majoreras 26 76 35 53
5 UD Las Torres Torres 26 70 50 46
6 CFS La Garita Garita 26 67 71 39
7 CD Achamán Fem Achamán 26 59 58 38
8 Montaña Alta Montaña 26 60 63 38
9 Cardones Cardones 26 63 74 35
10 CD Casa Pastores-Iregui Casa 26 43 68 28
11 CD Firgas Fem Firgas 26 41 110 17
12 Yoñé La Garita Yoñé 26 31 161 13
13 CD Águilas CD Águilas 26 16 220 9
14 C.D. Vallinámar Femenino C.D. 26 14 255 3
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 10
Equipo PJ GF GC Puntos
1 Málaga CF Fem Málaga 4 6 1 12
2 Spar Gran Canaria Fem Spar Gran C. 4 7 6 3
3 SPA Alicante Fem Alicante 4 5 11 3
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 10
Equipo PJ GF GC Puntos
1 Spar Gran Canaria Fem Spar Gran C. 2 9 3 6
2 San Juan Tenerife Norte Juan 2 3 9 0
TEMPORADA 2015/2016
TERCERA FEDERACIÓN FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 Spar Gran Canaria Fem Spar Gran C. 26 193 13 73
2 CD Achamán Fem Achamán 26 178 18 69
3 Unión Viera Fem Unión Viera 26 127 19 63
4 CD Águilas CD Águilas 26 94 20 61
5 Las Majoreras Fem Majoreras 26 64 49 46
6 CD Las Coloradas Coloradas 26 56 69 42
7 UD Las Torres Torres 26 54 57 39
8 Flor de Lis Norte Flor Norte 26 43 49 32
9 Montaña Alta Montaña 26 26 79 24
10 Tagoror Tagoror 26 36 135 21
11 Yoñé La Garita Yoñé 26 29 111 19
12 CD Firgas Fem Firgas 26 27 98 18
13 5 Continentes Continentes 26 15 108 10
14 Villa de Agaete Villa Agaete 26 38 155 10
TEMPORADA 2014/2015
TERCERA FEDERACIÓN FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 Spar Gran Canaria Fem Spar Gran C. 18 203 7 52
2 CD Achamán Fem Achamán 18 129 19 44
3 CD Águilas CD Águilas 19 72 23 43
4 Unión Viera Fem Unión Viera 19 76 24 41
5 Las Majoreras Fem Majoreras 19 52 30 39
6 Vegueta Vegueta 18 56 38 28
7 Colegio Norte Colegio 19 33 52 28
8 UD Las Torres Torres 21 45 73 28
9 Costa Ayala Costa Ayala 20 48 96 17
10 Montaña Alta Montaña 19 36 81 16
11 Tagoror Tagoror 19 20 96 13
12 CD Firgas Fem Firgas 18 24 103 6
13 5 Continentes Continentes 19 14 166 1
TEMPORADA 2012/2013
TERCERA FEDERACIÓN FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 CD Achamán Fem Achamán 14 90 5 40
2 Spar Gran Canaria Fem Spar Gran C. 14 100 9 34
3 Unión Viera Cf Unión Viera 14 67 15 33
4 Orientación Marítima Fem Orientación 14 28 27 21
5 Ud Valbanera Femenino Valbanera 14 25 54 19
6 Cf Arbol Bonito Femenino Arbol Bonito 14 31 57 13
7 C.D. Vallinámar Femenino C.D. 14 8 83 6
8 5 Continentes Femenino Continentes 14 5 104 0
TEMPORADA 2011/2012
TERCERA FEDERACIÓN FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 Real Union Tacuense Fem Real Union. 18 76 17 52
2 Spar Gran Canaria Fem Spar Gran C. 18 54 25 40
3 CD Charco del Pino Femenino Charco Pino 18 74 36 33
4 Uj Costa Ayala Costa Ayala 18 52 41 33
5 Cd Tarsa Cd Tarsa 18 34 30 26
6 Orientación Marítima Fem Orientación 18 39 38 24
7 CD Achamán Fem Achamán 17 28 39 18
8 Unión Viera Cf Unión Viera 18 24 45 15
9 Atlético Perdoma Fem Atlético 17 12 64 8
10 Ud Vallemar Ud Vallemar 18 13 71 3

  USO DE MEMORIA  
5,901,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1126
Total Execution Time  0.1146
  CADENA URL  
/historico/Cd-Femarguin-Femenino
  GET DATOS  
$_GET['/historico/Cd-Femarguin-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
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 = 73460
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8932 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8932 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (71501,77221,81964,230807,233077) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '8932' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73460 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=8932 AND l.year in (2023,2024,2025) 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 (73659,73460,68940) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73460 AND teamId = 8932
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68940 AND teamId = 8932
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73659 AND teamId = 8932
0.0022  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 = 73460 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '8932' 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 = '8932' and rp.type = 4
0.0020  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 = '8932' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73460 WHERE rp.league_id = 73460 AND rp.teamId = 8932 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.0020  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 = 73460 WHERE rp.league_id = 73460 AND rp.teamId = 8932 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73460 WHERE rp.league_id = 73460 AND rp.teamId = 8932 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 8932 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73460 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 68579 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.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 `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 = 63313 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.0022  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 = 58766 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.0022  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 = 61823 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 49901 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.0022  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 = 44735 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 `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 = 39398 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 43274 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 43317 AND t.round = 2 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 `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 = 35133 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 43273 AND t.round = 1 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 `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 = 16658 AND t.round = 26 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 `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 = 4408 AND t.round = 26 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 = 2120 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 1853 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC