4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico Juval
TEMPORADA 2022/2023
4ª ANDALUZA MÁLAGA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 UD Los Prados Sub 16 Prados 22 134 14 62
2 Cartama Cartama 22 95 36 57
3 CD Ronda Futbol Base Ronda Futbol 22 128 38 52
4 UD Santa Rosalia Maqueda Santa 22 106 58 46
5 Athletic de Coin B Athletic 22 65 46 38
6 Atletico Estacion Sub 16 Atletico 22 60 69 30
7 CD Campanillas Campanillas 22 45 64 26
8 CD Athletic Puerta Blanca Athletic 22 51 88 24
9 Roma Luz C.F. Roma C.F. 22 47 78 19
10 Alhaurin de la torre C Alhaurin 22 35 66 18
11 Atletico Juval Atletico 22 32 112 7
12 CD Conejito de Malaga Conejito 22 29 158 2
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 D. Hermanas S.Andres Sub 16 Hermanas 29 95 42 73
2 Atletico Juval Atletico 29 105 38 71
3 Atletico Estacion Sub 16 Atletico 30 88 35 70
4 Antequera Antequera 30 82 49 52
5 Romeral Sub 16 Romeral 30 84 60 51
6 Puerto Malagueño C Puerto 30 66 49 48
7 La Unidad Nueva Malaga Unidad Nueva 30 49 59 45
8 Faro de Torrox Asociacion Faro Torrox 29 67 73 42
9 Rincon A Rincon A 30 70 72 41
10 Mortadelo A Mortadelo A 30 64 73 37
11 Malaka Sub 16 Malaka 30 65 74 36
12 San Estanislao Sub 16 Estanislao 30 44 67 36
13 Olimpica Victoriana Sub 16 Olimpica 29 72 85 34
14 AD Cortijillo Bazan Cortijillo 30 57 75 26
15 EF Velez Francisco Castejon Velez 30 33 74 16
16 Pizarra Atlético Pizarra 30 41 157 5
TEMPORADA 2020/2021
4ª ANDALUZA MÁLAGA CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Juventud de Torremolinos B Juventud 17 81 18 46
2 Marbella Paraiso B Marbella 16 58 14 40
3 CD Alora CD Alora 19 59 33 39
4 Esteponense B Esteponense 16 50 25 37
5 Atletico Juval Atletico 16 59 13 34
6 CD Campanillas Campanillas 17 61 46 29
7 Athletic de Coin B Athletic 16 56 41 25
8 Cartama Cartama 18 37 53 19
9 CD Alhaurino C Alhaurino 19 31 61 19
10 Alh. De La Torre Sub 16 B Alh. Torre 16 32 46 17
11 Los Prados B Prados 15 23 56 11
12 Athl. Puerta Blanca Sub 16 Athl. Puerta 18 25 77 7
13 Benalmádena Atlético B Benalmádena 19 12 101 3
TEMPORADA 2019/2020
2ª ANDALUZA FEMENINA CADETE MÁLAGA
Equipo PJ GF GC Puntos
1 Escuela MCF Fem B Escuela 20 140 29 51
2 CD Ciudad De Estepona CF A Ciudad 19 127 34 50
3 Rincon A Rincon A 20 124 34 50
4 Lauro CD Lauro CD 20 123 35 44
5 Portada Alta Atco. Portada Alta 20 128 65 37
6 CD Torreón Cala Mijas Torreón 19 77 67 31
7 Pablo Picasso CD AS DVA CF Pablo 19 127 79 30
8 Candor CF Candor CF 20 84 73 29
9 Atletico Juval Atletico 20 73 69 28
10 CD Atletico Benamiel CF Atletico 19 74 81 22
11 Santa Rosalia Maqueda UD Santa 19 61 86 18
12 Escuela MCF Fem C Escuela 20 58 96 17
13 CD Ciudad De Estepona CF B Ciudad 18 31 100 12
14 CD Mijas CD Mijas 20 41 155 9
15 Juventud Fuengirola CF Juventud 5 9 42 2
16 Lauro CD B Lauro CD B 20 9 241 0
TEMPORADA 2018/2019
4ª ANDALUZA MÁLAGA CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 Guadalmar CD Guadalmar 28 113 32 79
2 Pizarra Pizarra 28 171 13 77
3 CD Ronda Futbol Base Ronda Futbol 28 117 32 69
4 Athletic Puerta Blanca Athletic 28 101 48 57
5 Churriana Churriana 28 67 69 46
6 D. Hermanas S.Andres Sub 16 Hermanas 28 68 65 45
7 Roma Luz CF B Roma 28 92 67 42
8 Conejito de Malaga Conejito 28 55 70 41
9 Alora Sub 16 Alora 28 69 89 33
10 Cartama Cartama 28 65 80 32
11 Atletico Juval Atletico 28 56 72 31
12 Ronda UD Ronda UD 28 62 85 29
13 Los Prados B Prados 28 52 87 22
14 Atletico Estacion A Atletico 28 51 190 8
15 Alhaurín de la Torre Alhaurín 28 23 163 2
TEMPORADA 2017/2018
4ª ANDALUZA MÁLAGA CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 26 de Febrero Sub 16 Febrero 24 119 42 58
2 Carlinda Sub 16 Carlinda 24 71 21 56
3 Malaka A Malaka A 24 95 33 54
4 Athletic Puerta Blanca Athletic 24 88 29 52
5 Olimpica Victoriana Sub 16 Olimpica 24 80 42 50
6 D. Hermanas S.Andres Sub 16 Hermanas 24 75 51 40
7 Atletico Juval Atletico 24 80 58 35
8 Puerto Malagueño CJ GI Puerto 24 55 56 33
9 AD Cortijillo Bazan Cortijillo 24 49 48 31
10 Roma Luz CF B Roma 24 38 83 17
11 El Palo FC Sub 16 B Palo 24 56 98 15
12 Torcal La Paz Torcal 24 56 156 6
13 La Unidad Nueva Malaga A Unidad Nueva 24 26 171 2
TEMPORADA 2016/2017
4ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 La Cala A La Cala A 24 126 38 67
2 26 de Febrero Sub 16 Febrero 25 155 52 56
3 Atletico Juval Atletico 24 114 36 54
4 Lauro A Lauro A 24 80 44 49
5 Rincon A Rincon A 24 75 50 44
6 San Estanislao Sub 16 Estanislao 24 71 66 42
7 Los Prados UD Prados 24 60 45 39
8 AD Cortijillo Bazan Cortijillo 24 63 57 37
9 Puerto de la Torre A Puerto Torre 24 57 80 26
10 Alhaurin de la Torre Sub 16 Alhaurin 24 61 100 22
11 La Unidad Nueva Malaga A Unidad Nueva 25 34 139 10
12 Carlinda Sub 16 Carlinda 24 34 104 9
13 Portada Alta Atlético B Portada Alta 24 32 131 7
14 Malaka Sub 16 Malaka 2 1 21 0
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Mortadelo B Mortadelo B 30 159 19 82
2 D. Hermanas S.Andres Sub 16 Hermanas 30 141 42 78
3 Churriana Churriana 30 124 24 72
4 Atletico Juval Atletico 30 111 40 63
5 Tiro Pichon Sub 16 B Tiro Pichon 30 84 42 55
6 La Cala B La Cala B 30 95 67 49
7 Athletic Puerta Blanca Athletic 30 68 81 45
8 Los Morales Sub Sub 16 B Morales 30 61 53 45
9 Santa Julia Santa Julia 30 78 82 41
10 Roma Luz CF B Roma 30 73 99 37
11 Guadalmar CD Guadalmar 30 101 91 36
12 Conejito de Malaga Conejito 30 68 82 33
13 Alora Sub 16 Alora 30 67 84 31
14 Campanillas Campanillas 30 33 108 18
15 San Julian Atletico Sub 16 Julian 30 27 245 11
16 Malaga Catlético Malaga 30 13 144 7
TEMPORADA 2014/2015
4ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 La Unidad Nueva Malaga A Unidad Nueva 26 95 22 69
2 Mortadelo A Mortadelo A 26 112 21 64
3 Atletico Estacion A Atletico 26 114 35 57
4 Puerto Malagueño CJ GI Puerto 26 73 47 47
5 La Cala A La Cala A 26 113 57 46
6 AD Cortijillo Bazan Cortijillo 26 74 38 46
7 Romeral Sub 16 Romeral 26 62 41 42
8 Atletico Juval Atletico 26 53 36 37
9 Rincon A Rincon A 26 54 64 32
10 El Palo FC Sub 16 B Palo 26 47 75 28
11 Lauro Sub 16 Lauro 26 43 118 17
12 Puerto Torre Morales A Puerto Torre 26 34 114 17
13 Amigos del Deporte Colmenar Amigos 26 40 143 10
14 Portada Alta Portada Alta 26 35 138 10

  USO DE MEMORIA  
5,652,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1230
Total Execution Time  0.1245
  CADENA URL  
/historico/Atletico-Juval-Cadete
  GET DATOS  
$_GET['/historico/Atletico-Juval-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0023  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 = 'Atletico-Juval-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.0031  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 = 'Atletico-Juval-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=25555 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=25555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=25555 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=25555 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=25555 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=25555 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=25555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=25555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=25555 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=25555 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=25555 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=25555 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 69866
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25555 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=768 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 = '25555' 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 = '25555' 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 = '25555' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 70183 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 69866 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=25555 AND l.year in (2022,2023,2024) 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 (70183,69866) 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 = 69866 AND teamId = 25555
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70183 AND teamId = 25555
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 = 69866 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '25555' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25555' and rp.type = 4
0.0021  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 = '25555' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 25555 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70183 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.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 `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 = 69866 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 `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 = 66113 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 = 60451 AND t.round = 26 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 `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 = 52907 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 `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 = 55433 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.0026  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 = 45489 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 `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 = 40279 AND t.round = 26 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 `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 = 35091 AND t.round = 26 ORDER BY team.conference 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 `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 = 17294 AND t.round = 30 ORDER BY team.conference 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 `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 = 4887 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC