4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del A.D. Apademar A
TEMPORADA 2022/2023
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba Cf Sub 16 Córdoba 30 114 21 82
2 Don Bosco CF Sub 16 Bosco 30 98 30 69
3 CD Los Califas Balompie Califas 30 88 40 65
4 Atlético Seneca Atlético 30 81 29 62
5 Figueroa CD Figueroa CD 30 97 59 57
6 CD Apedem A CD Apedem A 30 80 51 54
7 Lucecor FS Lucecor FS 30 103 64 53
8 Pozoblanco Pozoblanco 30 105 68 47
9 Palma del Rio Atlético Palma 30 81 64 45
10 Salerm Cosmetics Puente Gen Salerm 30 69 78 45
11 Salvador Allende Salvador 30 50 80 32
12 CD de Futbol Juanin Y Diego Futbol 30 45 68 25
13 Rud La Carlota B Carlota 30 41 142 19
14 A.D. Apademar A A.D. 30 35 101 18
15 C.D. Stadium C.D. Stadium 30 30 102 12
16 Fundacion Lucena Fundacion 30 28 148 6
TEMPORADA 2021/2022
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Juanin Y Diego Sub 16 Juanin Diego 28 86 23 67
2 Fundacion Lucena Fundacion 28 100 42 59
3 Figueroa CD Figueroa CD 28 71 36 56
4 CD Los Califas Balompie Califas 28 75 58 55
5 Atlético Seneca Atlético 28 88 37 53
6 CD Apedem A CD Apedem A 28 69 40 53
7 Don Bosco CF Sub 16 Bosco 28 45 40 47
8 A.D. Apademar A A.D. 28 61 69 39
9 Salerm Cosmetics Puente Gen Salerm 28 63 56 37
10 Pozoblanco Pozoblanco 28 59 75 32
11 C.D. Stadium C.D. Stadium 28 50 95 23
12 Salvador Allende Salvador 28 43 62 22
13 Futbol Base Egabrense Futbol Base 28 58 101 21
14 Palomera Naranjo Cultural Palomera 28 39 81 20
15 CD AD Miralbaida Miralbaida 28 27 119 11
16 Alcazar CD Alcazar CD 0 0 0 0
TEMPORADA 2020/2021
2ª ANDALUZA CÓRDOBA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Don Bosco CF Sub 16 Bosco 9 23 7 20
2 A.D. Apademar A A.D. 10 23 14 19
3 Atlético Seneca Atlético 8 16 9 19
4 Futbol Base Egabrense Futbol Base 9 15 22 11
5 Atletico Menciano Atletico 5 10 10 7
6 Salerm Cosmetics Puente Gen Salerm 9 11 14 7
7 Alcazar CD Alcazar CD 9 7 15 6
8 C.D. Stadium C.D. Stadium 9 11 25 6
TEMPORADA 2019/2020
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Apedem A CD Apedem A 22 86 18 55
2 Don Bosco CF Sub 16 Bosco 23 66 19 54
3 Pozoblanco Pozoblanco 22 74 24 50
4 Atlético Seneca Atlético 22 85 27 49
5 Juanin Y Diego Sub 16 Juanin Diego 23 63 31 47
6 A.D. Apademar A A.D. 22 61 24 40
7 Futbol Base Egabrense Futbol Base 23 54 43 37
8 Salerm Cosmetics Puente Gen Salerm 23 52 40 33
9 Rud La Carlota A Carlota 22 45 51 31
10 C.D. Stadium C.D. Stadium 22 53 52 29
11 Villa del Rio Servicio Depo Villa 23 44 54 25
12 Figueroa CD Figueroa CD 20 33 44 19
13 Deportivo Córdoba CF Deportivo 21 52 66 19
14 Alcazar CD Alcazar CD 23 24 95 10
15 Baenense Atletico Baenense 23 16 169 3
16 La Rambla de Futbol Base Rambla 16 13 64 1
TEMPORADA 2018/2019
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Los Califas Balompie Califas 30 115 19 75
2 CD Deportivo Cordoba CF Deportivo 30 104 30 72
3 A.D. Apademar A A.D. 30 104 32 72
4 Juanin Y Diego Sub 16 Juanin Diego 30 107 24 69
5 Atlético Seneca Atlético 30 109 25 64
6 Don Bosco CF Sub 16 Bosco 30 91 39 62
7 CD Apedem A CD Apedem A 30 70 57 45
8 Futbol Base Egabrense Futbol Base 30 72 56 41
9 C.D. Stadium C.D. Stadium 30 79 105 39
10 Villa del Rio Servicio Depo Villa 30 56 75 33
11 Rud La Carlota A Carlota 30 67 81 32
12 Alcazar CD Alcazar CD 30 41 100 28
13 Fundacion Lucena Fundacion 30 37 89 23
14 Palma del Rio Atlético Palma 30 52 152 21
15 Atlético Villanueva FB Atlético 30 48 123 15
16 Salvador Allende Salvador 30 15 160 7
TEMPORADA 2017/2018
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Pozoblanco Pozoblanco 30 109 21 81
2 Juanin Y Diego Sub 16 Juanin Diego 30 116 38 70
3 Palma del Rio Atlético Palma 30 109 34 69
4 A.D. Apademar A A.D. 30 99 31 60
5 CD Apedem A CD Apedem A 30 92 48 57
6 CD Los Califas Balompie Califas 30 75 45 50
7 Don Bosco CF B Bosco 30 59 65 49
8 Rud La Carlota A Carlota 30 53 51 48
9 Futbol Base Egabrense Futbol Base 30 60 50 44
10 Salvador Allende Salvador 30 48 42 37
11 Alcazar CD Alcazar CD 30 40 45 36
12 Fundacion Lucena Fundacion 30 49 74 36
13 Palomera Naranjo Cultural Palomera 30 39 86 23
14 CD Colonia de Fuente Palmer Colonia 30 35 134 18
15 Baenense Atletico Baenense 30 50 136 13
16 Montalbeño Montalbeño 30 23 156 0
TEMPORADA 2016/2017
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Salerm Cosmetics Puente Gen Salerm 30 147 25 80
2 Futbol Base Egabrense Futbol Base 30 85 35 67
3 Pozoblanco Pozoblanco 30 91 42 63
4 Salvador Allende Salvador 30 107 33 61
5 Don Bosco CF B Bosco 30 67 50 57
6 CD Apedem A CD Apedem A 30 67 53 46
7 Rud La Carlota A Carlota 30 77 69 46
8 Palma del Rio Atlético Palma 30 59 59 46
9 CD Los Califas Balompie Califas 30 66 56 44
10 Montalbeño Montalbeño 30 67 77 42
11 A.D. Apademar A A.D. 30 73 92 30
12 Palomera Naranjo Cultural Palomera 30 53 98 29
13 CD Colonia de Fuente Palmer Colonia 30 51 100 24
14 Sporting de Benameji Sporting 30 46 104 18
15 Villafranca Villafranca 30 45 129 17
16 Atletico Aguilarense Atletico 30 34 113 12
TEMPORADA 2015/2016
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Posadas CF Posadas 33 155 49 85
2 A.D. Apademar A A.D. 33 113 53 75
3 Rud La Carlota A Carlota 33 87 31 70
4 CD Colonia de Fuente Palmer Colonia 33 105 61 61
5 Villafranca C Villafranca 33 118 86 59
6 Los Califas Balompie B Califas 33 67 62 53
7 Atletico Aguilarense Atletico 33 122 124 52
8 La Rambla de Futbol Base Rambla 33 105 82 52
9 Deportivo Cordoba Deportivo 33 85 73 49
10 La Ribera del Guadalquivir Ribera 33 125 126 49
11 CD Hinojosa CD Hinojosa 33 64 59 46
12 C.D. Stadium C.D. Stadium 33 64 90 41
13 CD Castro Del Rio-Cajasol Castro 33 64 74 39
14 Salvador Allende Salvador 33 73 127 30
15 Villa del Rio Servicio Depo Villa 33 65 107 26
16 El Higueron El Higueron 33 63 143 19
17 Peñarroya Pueblonuevo Peñarroya 17 37 57 17
18 Figueroa CD Figueroa CD 33 60 168 5
TEMPORADA 2014/2015
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba CF Sub 16 Córdoba 28 114 25 78
2 Atlético Seneca Atlético 28 89 30 68
3 Los Califas Balompie Califas 28 94 39 64
4 Salvador Allende Salvador 28 67 51 49
5 Egabrense FB Egabrense 28 61 47 44
6 Lucena Lucena 28 68 56 41
7 Montalbeño Montalbeño 28 40 48 38
8 Deportivo Córdoba CF Deportivo 28 54 43 37
9 Pozoblanco Pozoblanco 28 55 44 36
10 Palma del Rio Atlético Palma 28 46 55 36
11 Atlético Villanueva FB Atlético 28 50 76 32
12 Salerm Cosmetics Puente Gen Salerm 28 38 79 25
13 Palomera-Naranjo Palomera-Nar 28 46 99 17
14 A.D. Apademar A A.D. 28 45 98 14
15 Peñarroya Pueblonuevo Peñarroya 28 25 102 11
16 Figueroa CD Figueroa CD 0 0 0 0

  USO DE MEMORIA  
5,618,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1267
Total Execution Time  0.1279
  CADENA URL  
/historico/Apademar-Cadete
  GET DATOS  
$_GET['/historico/Apademar-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0024  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 = 'Apademar-Cadete' 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.0038  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 = 'Apademar-Cadete' 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.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=25251 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=25251 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=25251 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=25251 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=25251 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=25251 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=25251 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=25251 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=25251 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=25251 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=25251 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 70162
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25251 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=759 AND type_rel = 3
0.0021  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 = '25251' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '25251' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '25251' 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 = 70162 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=25251 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (70162) 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_base WHERE league_id = 70162 AND teamId = 25251
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 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 = 70162 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '25251' 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 = '25251' 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 = '25251' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 25251 AND l.year <= 2023 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 `tables2023_base` 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 = 70162 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_base` 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 = 66040 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_base` 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 = 59535 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_base` 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 = 60386 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `tables2020_base` 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 = 52410 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.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 `tables2019_base` 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 = 45915 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 `tables2018_base` 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 = 40490 AND t.round = 30 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_base` 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 = 34341 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 `tables2016_base` 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 = 17288 AND t.round = 34 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 = 4866 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC