4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico Jaén Sub 14
TEMPORADA 2023/2024
1ª ANDALUZA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 La Cañada Atlético Sub 14 Cañada 26 60 20 59
2 Granada Sub 14 B Granada 26 53 24 53
3 Marbella Paraiso Sub 14 Marbella 26 58 26 49
4 La Mosca Sub 14 Mosca 26 46 29 47
5 Malaka Sub 14 Malaka 26 42 23 44
6 Ciudad de Roquetas Sub 14 Ciudad 25 44 23 42
7 Ciudad de Granada Sub 14 Ciudad 25 47 29 41
8 Linares Deportivo Sub 14 Linares 26 43 39 40
9 Atletico Jaén Sub 14 Atletico 26 54 42 39
10 Alhaurín De La Torre Sub 14 Alhaurín 26 38 42 34
11 Úbeda Viva Sub 14 Úbeda Viva 25 42 43 32
12 Málaga Sub 14 B Málaga 26 36 35 29
13 Pavia Sub 14 Pavia 26 31 40 29
14 Español Albolote Sub 14 Español 25 27 49 24
15 Medina Lauxa Sub 14 Medina Lauxa 26 18 85 13
16 Los Molinos Sub 14 Molinos 26 12 102 1
TEMPORADA 2022/2023
2ª ANDALUZA JAÉN INFANTIL
Equipo PJ GF GC Puntos
1 Linares Deportivo Sub 14 Linares 30 118 33 80
2 Torreperogil Torreperogil 30 79 30 72
3 Carolinense CD Carolinense 30 92 45 71
4 Atletico Jaén Sub 14 Atletico 30 93 28 66
5 Guarroman Veteranos Guarroman 30 67 45 58
6 Úbeda Viva Sub 14 Úbeda Viva 30 74 68 46
7 Alcalá Enjoy Alcalá 30 89 89 46
8 Linares CF Linares CF 30 51 45 40
9 Recreativo Bailén Recreativo 30 49 52 39
10 Real Jaén Real Jaén 30 46 81 37
11 Betis Iliturgitano Betis 30 47 60 35
12 Jódar EM Jódar EM 30 43 80 25
13 Inter de Jaén Inter Jaén 30 46 82 24
14 Atlético Marteño Atlético 30 51 92 18
15 CD Jaén FC CD Jaén FC 30 53 113 18
16 Villacarrillo EMD Villacarrill 30 29 84 13
TEMPORADA 2021/2022
2ª ANDALUZA JAÉN INFANTIL
Equipo PJ GF GC Puntos
1 Úbeda Viva Sub 14 Úbeda Viva 19 91 14 54
2 Alcalá Enjoy Alcalá 20 87 34 49
3 Linares Deportivo Sub 14 Linares 20 69 19 42
4 EF Internacional B Internaciona 20 57 40 42
5 Atletico Jaén Sub 14 Atletico 20 46 38 31
6 Jódar EM Jódar EM 20 49 74 24
7 Villacarrillo EMD Villacarrill 18 48 61 22
8 Linares CF Linares CF 20 47 69 20
9 Recreativo Bailén Recreativo 20 37 64 16
10 Inter de Jaén Inter Jaén 20 13 77 8
11 Real Jaén Real Jaén 19 19 73 4
12 CD Vilches CD Vilches 0 0 0 0
TEMPORADA 2020/2021
1ª ANDALUZA INFANTIL GRUPO 7
Equipo PJ GF GC Puntos
1 Málaga CF Sub 14 Málaga 8 24 10 19
2 UD Almeria Sub 14 Almeria 8 21 16 16
3 Puerto Malagueño Sub 14 Puerto 8 16 13 13
4 UD Maracena UD Maracena 7 16 13 11
5 Tiro Pichon Sub 14 Tiro Pichon 8 17 16 8
6 Granada CF Sub 14 Granada 8 10 11 8
7 La Cañada Atlético Sub 14 Cañada 8 10 22 8
8 Atletico Jaén Sub 14 Atletico 7 5 18 3
TEMPORADA 2019/2020
1ª ANDALUZA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 14 Málaga 23 91 18 62
2 UD Almeria Sub 14 Almeria 23 61 27 52
3 Tiro Pichon Sub 14 Tiro Pichon 23 39 21 46
4 Ciudad de Granada Sub 14 Ciudad 23 41 24 40
5 Puerto Malagueño Sub 14 Puerto 23 38 29 37
6 Granada CF Sub 14 Granada 23 34 24 36
7 La Cañada Atlético Sub 14 Cañada 23 35 40 33
8 Marbella Paraiso Sub 14 Marbella 23 44 40 30
9 CD Santa Fe A Santa 23 33 44 27
10 We Sub 14 We Sub 14 23 32 48 27
11 Alhaurín De La Torre Sub 14 Alhaurín 23 37 49 26
12 Pavia Sub 14 Pavia 23 36 49 26
13 Atletico Jaén Sub 14 Atletico 23 30 54 22
14 El Ejido 2012 A Ejido 2012 23 35 57 21
15 Real Jaén Real Jaén 23 33 53 20
16 Úbeda Viva Sub 14 Úbeda Viva 23 21 63 11
TEMPORADA 2018/2019
2ª ANDALUZA JAÉN INFANTIL
Equipo PJ GF GC Puntos
1 Atletico Jaén Sub 14 Atletico 26 123 5 75
2 Linares Deportivo Sub 14 Linares 26 165 17 69
3 Bailen Bailen 26 99 25 62
4 Betis Iliturgitano Betis 26 67 37 56
5 Jódar EM Jódar EM 26 56 52 42
6 Alcala Enjoy Alcala Enjoy 26 67 67 39
7 Hispania de Torredelcampo Hispania 26 79 64 38
8 Mancha Real AD Mancha Real 26 75 66 38
9 Peña Deportiva Jiennense Peña 26 48 68 31
10 Villacarrillo EMD Villacarrill 26 50 79 23
11 UDC Torredonjimeno Torredonjime 26 35 98 21
12 Deportivo Jaén Deportivo 26 40 112 13
13 Veteranos Alcaudete Veteranos 26 38 121 13
14 CD Vilches CD Vilches 26 27 158 9
TEMPORADA 2017/2018
1ª ANDALUZA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 14 Málaga 30 134 14 79
2 UD Almeria Sub 14 Almeria 30 110 17 76
3 Granada CF Sub 14 Granada 30 106 32 68
4 Puerto Malagueño Sub 14 Puerto 30 67 28 59
5 Tiro Pichon Sub 14 Tiro Pichon 30 68 42 59
6 La Cañada Atlético Sub 14 Cañada 30 50 43 55
7 Ciudad de Granada Sub 14 Ciudad 30 54 57 42
8 We Sub 14 We Sub 14 30 29 37 42
9 Pavia Sub 14 Pavia 30 29 55 34
10 Motril Motril 30 48 78 30
11 Real Jaén Real Jaén 30 36 72 28
12 Antequera Sub 14 Antequera 30 31 94 28
13 Linares Deportivo Sub 14 Linares 30 32 92 27
14 Maracena A Maracena A 30 34 63 24
15 Atletico Jaén Sub 14 Atletico 30 40 77 23
16 UD Ciudad de Roquetas A Ciudad 30 26 93 18
TEMPORADA 2016/2017
1ª ANDALUZA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 14 Málaga 30 120 32 75
2 Puerto Malagueño Sub 14 Puerto 30 76 25 69
3 UD Almeria Sub 14 Almeria 30 92 24 66
4 Granada CF Sub 14 Granada 30 64 34 56
5 Real Jaén Real Jaén 30 62 38 56
6 Tiro Pichon Sub 14 Tiro Pichon 30 39 59 42
7 Atletico Jaén Sub 14 Atletico 30 62 56 41
8 Motril Motril 30 47 51 41
9 Ciudad de Granada Sub 14 Ciudad 30 35 49 36
10 La Cañada Atlético Sub 14 Cañada 30 41 52 35
11 We Sub 14 We Sub 14 30 34 45 35
12 Pavia Sub 14 Pavia 30 49 66 33
13 Malaka Sub 14 Malaka 30 43 82 33
14 EF de Velez Sub 14 Velez 30 24 47 32
15 AD Pol. Aguadulce A Pol. 30 33 78 26
16 CD Santa Fe A Santa 30 17 100 7
TEMPORADA 2015/2016
2ª ANDALUZA JAÉN INFANTIL
Equipo PJ GF GC Puntos
1 Atletico Jaén Sub 14 Atletico 26 94 17 70
2 Linares Deportivo Sub 14 Linares 26 97 41 63
3 Betis Iliturgitano Betis 26 104 49 62
4 Úbeda Viva Sub 14 Úbeda Viva 26 98 27 60
5 Peña Deportiva Jiennense Peña 26 71 54 40
6 Hispania de Torredelcampo Hispania 26 59 62 37
7 Alcalá Enjoy Alcalá 26 56 70 33
8 Jódar EM Jódar EM 26 69 80 32
9 Fundacion Real Jaen Fundacion 26 39 54 31
10 Quesada Quesada 26 55 69 30
11 Tosiria B Tosiria B 26 50 91 30
12 Carolinense CD Carolinense 26 43 97 16
13 Linares 2011 Linares 2011 26 36 94 15
14 Veteranos Alcaudete Veteranos 26 28 94 6
TEMPORADA 2014/2015
2ª ANDALUZA JAÉN INFANTIL
Equipo PJ GF GC Puntos
1 C.D. Tosiria C.D. Tosiria 26 110 11 71
2 Atletico Jaén Sub 14 Atletico 26 77 30 61
3 Úbeda Viva Úbeda Viva 25 103 29 58
4 Fundación R. Jaén Fundación 26 79 27 56
5 P.D. Jienense P.D. 26 85 37 51
6 C.D. Quesada C.D. Quesada 26 103 56 46
7 Veteranos Alcaudete Veteranos 26 85 56 41
8 Alcalá Enjoy Alcalá 26 71 53 34
9 Linares CF 2011 Linares 2011 25 66 63 33
10 Jódar EM Jódar EM 26 80 109 33
11 C.P. Bailén C.P. Bailén 25 51 80 22
12 Villacarrillo EMD Villacarrill 25 49 108 18
13 A.D. Mancha Real A.D. Mancha 26 20 152 6
14 C.D. Almidas C.D. Almidas 26 12 180 0
TEMPORADA 2013/2014
1ª ANDALUZA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 14 Málaga 30 145 22 85
2 Granada CF Sub 14 Granada 30 85 35 67
3 Tiro Pichon Sub 14 Tiro Pichon 30 102 51 64
4 Real Jaén Real Jaén 30 80 47 64
5 Puerto Malagueño Sub 14 Puerto 30 78 41 59
6 UD Almeria Sub 14 Almeria 30 81 46 58
7 EF de Velez Sub 14 Velez 30 66 74 41
8 CD Santa Fe A Santa 30 55 49 38
9 U.D. Maracena U.D. 30 60 66 37
10 Fuengirola Fuengirola 30 48 67 35
11 La Cañada Atlético Sub 14 Cañada 30 44 59 34
12 Roquetas Roquetas 30 51 107 32
13 Atletico Jaén Sub 14 Atletico 30 43 74 26
14 Vera Vera 30 41 124 22
15 Úbeda Viva Úbeda Viva 30 36 83 14
16 Vazquez Cultural B Vazquez 30 24 94 13

  USO DE MEMORIA  
5,803,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1036
Total Execution Time  0.1054
  CADENA URL  
/historico/Atletico-Jaen-Fc-Infantil
  GET DATOS  
$_GET['/historico/Atletico-Jaen-Fc-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0029  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-Jaen-Fc-Infantil' 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.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=71321 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=71321 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=71321 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=456 AND type_rel = 3
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 = '71321' 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 = '71321' AND l.year = 2024 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 = '71321' 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 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=71321 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 (74443,71187) 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 = 74443 AND teamId = 71321
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 71187 AND teamId = 71321
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 = '71321' 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 = '71321' 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 = '71321' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 71321 AND l.year <= 2024 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 `tables2024_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 = 74443 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 `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 = 68958 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 `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 = 71187 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 `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 = 64288 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.0027  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 = 66598 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.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 `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 = 59837 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.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 `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 = 60469 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 `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 = 62009 AND t.round = 8 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 `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 = 52960 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 `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 = 46201 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 39446 AND t.round = 30 ORDER BY team.conference 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 `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 = 34416 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 `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 = 17550 AND t.round = 26 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 = 4413 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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_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 = 3063 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC