4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UCD La Cañada Atlético
TEMPORADA 2022/2023
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Malagueño Sub 16 Puerto 30 87 31 67
2 UD Almería Sub 16 Almería 30 67 36 66
3 Granada CF Sub 16 Granada 30 57 29 63
4 Linares Deportivo Sub 16 Linares 30 56 34 54
5 UD La Mosca Sub 16 Mosca 30 64 46 46
6 Alhaurin de La Torre Alhaurin 30 47 61 43
7 UDC Pavia Sub 16 Pavia 30 42 47 42
8 Estepona Sub 16 Estepona 29 40 41 41
9 Marbella CF Sub 16 Marbella 30 49 46 40
10 Atlético Jaén Sub 16 Atlético 30 56 59 40
11 Atarfe Industrial Sub 16 Atarfe 30 42 47 37
12 UCD La Cañada Atlético Cañada 30 32 45 32
13 El Ejido 1969 Ejido 1969 30 52 58 31
14 U.D. Ciudad de Roquetas U.D. Ciudad 30 34 60 24
15 La Mojonera La Mojonera 28 34 61 22
16 Veteranos Alcaudete A Veteranos 29 30 88 18
TEMPORADA 2021/2022
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Arenas de Armilla Sub 16 Arenas 34 91 40 82
2 CD San Félix Félix 34 110 44 75
3 Puerto Malagueño Sub 16 Puerto 34 67 34 66
4 Granada CF Sub 16 Granada 34 84 50 61
5 UD La Mosca Sub 16 Mosca 34 83 59 60
6 Estepona Sub 16 Estepona 34 66 32 58
7 Marbella CF Sub 16 Marbella 34 69 47 56
8 Linares Deportivo Sub 16 Linares 34 53 48 51
9 UDC Pavia Sub 16 Pavia 34 66 61 49
10 UCD La Cañada Atlético Cañada 34 58 61 47
11 Atlético Jaén Sub 16 Atlético 33 64 57 45
12 UD Almería Sub 16 Almería 34 64 75 45
13 La Mojonera La Mojonera 34 51 67 41
14 Betis Iliturgitano Betis 34 36 73 38
15 Ciudad de Granada Ciudad 34 52 61 36
16 We Futbol Club Sub 16 Futbol Club 33 37 63 29
17 Real Jaén Sub 16 Real Jaén 33 30 116 14
18 Polideportivo Aguadulce Polideportiv 33 20 113 11
TEMPORADA 2020/2021
DIVISIÓN DE HONOR CADETE ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Granada CF Sub 16 Granada 18 43 15 43
2 Málaga CF Sub 16 Málaga 18 25 5 40
3 CD 26 De Febrero Sub 16 Febrero 18 23 18 32
4 UD Almeria Sub 16 Almeria 18 30 17 30
5 We Futbol Club Sub 16 Futbol Club 18 21 25 23
6 CD Tiro Pichón Tiro Pichón 18 15 22 21
7 Atlético Jaén Sub 16 Atlético 18 22 37 18
8 CD San Félix Félix 18 14 24 17
9 Puerto Malagueño Sub 16 Puerto 18 15 26 13
10 UCD La Cañada Atlético Cañada 18 13 32 13
TEMPORADA 2019/2020
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 23 65 8 63
2 Real Betis Sub 16 Real Betis 23 52 15 51
3 Málaga CF Sub 16 Málaga 23 45 22 44
4 Granada CF Sub 16 Granada 23 48 33 44
5 UCD La Cañada Atlético Cañada 23 34 24 36
6 Puerto Malagueño Sub 16 Puerto 23 30 24 34
7 CD Asoc. Dva. Nervión Asoc. Dva.. 23 32 38 32
8 CD 26 De Febrero Sub 16 Febrero 23 31 37 30
9 Cádiz CF Sub 16 Cádiz 23 23 24 29
10 UD Almeria Sub 16 Almeria 23 29 35 28
11 CD San Félix Félix 23 24 35 26
12 Córdoba CF Sub 16 Córdoba 23 29 39 25
13 Recreativo de Huelva Sub 16 Recreativo 23 27 53 23
14 CD Tiro Pichón Tiro Pichón 23 22 45 21
15 CD Altair Sub 16 Altair 23 31 49 19
16 Peloteros Sierra Sur Sub 16 Peloteros 23 18 59 14
TEMPORADA 2018/2019
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 CD Tiro Pichón Tiro Pichón 30 80 41 63
2 UCD La Cañada Atlético Cañada 30 83 42 61
3 Polideportivo Aguadulce Polideportiv 30 66 45 57
4 Ciudad de Granada Ciudad 30 85 40 56
5 UDC Pavia Sub 16 Pavia 30 63 44 54
6 UD Almería B Almería 30 70 49 52
7 Atlético Jaén Sub 16 Atlético 30 71 59 46
8 Real Jaén Sub 16 Real Jaén 30 44 39 44
9 We Futbol Club Sub 16 Futbol Club 30 40 36 41
10 UD Motril UD Motril 30 49 52 40
11 Granada CF Sub 16 Granada 30 51 57 40
12 UD La Mosca Sub 16 Mosca 30 64 74 39
13 Peña Compadres Peña 30 45 58 32
14 Santa Fe Santa Fe 30 26 58 20
15 CD Roquetas CD Roquetas 30 32 90 19
16 Alcalá Enjoy Alcalá 30 35 120 7
TEMPORADA 2017/2018
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 30 58 19 71
2 Real Betis Sub 16 Real Betis 30 83 25 70
3 Málaga CF Sub 16 Málaga 30 73 36 67
4 CD Altair Sub 16 Altair 30 71 41 53
5 Granada CF Sub 16 Granada 30 71 41 52
6 UD Almeria Sub 16 Almeria 30 50 33 50
7 Córdoba CF Sub 16 Córdoba 30 60 45 46
8 Cádiz CF Sub 16 Cádiz 30 35 40 39
9 CD 26 De Febrero Sub 16 Febrero 30 44 50 39
10 CD San Félix Félix 30 46 57 33
11 CD Asoc. Dva. Nervión Asoc. Dva.. 30 46 68 33
12 UD Maracena Sub 16 Maracena 30 44 60 32
13 CD Alcala Sub 16 Alcala 30 30 47 29
14 UCD La Cañada Atlético Cañada 30 31 52 27
15 Peloteros Sierra Sur Sub 16 Peloteros 30 34 73 15
16 CD Roquetas CD Roquetas 30 20 109 7
TEMPORADA 2016/2017
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 Sevilla 30 70 17 72
2 Real Betis Sub 16 Real Betis 30 85 31 67
3 Málaga CF Sub 16 Málaga 30 74 35 64
4 UD Almeria Sub 16 Almeria 30 51 25 58
5 Córdoba CF Sub 16 Córdoba 30 54 46 52
6 Granada CF Sub 16 Granada 30 45 44 49
7 CD San Félix Félix 30 43 53 38
8 CD Altair CD Altair 30 45 49 37
9 CD 26 De Febrero Sub 16 Febrero 30 43 55 37
10 UCD La Cañada Atlético Cañada 30 42 57 36
11 Cádiz CF Sub 16 Cádiz 30 45 65 33
12 CD Asoc. Dva. Nervión Asoc. Dva.. 30 43 47 32
13 Puerto Malagueño Sub 16 Puerto 30 35 39 32
14 Recreativo de Huelva Sub 16 Recreativo 30 36 59 29
15 Séneca CF Sub 16 Séneca 30 49 78 27
16 Real Jaén Sub 16 Real Jaén 30 31 91 16
TEMPORADA 2015/2016
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 16 Málaga 30 130 26 77
2 CD 26 De Febrero Sub 16 Febrero 30 102 51 69
3 UD Almeria Sub 16 Almeria 30 94 30 65
4 Puerto Malagueño Sub 16 Puerto 30 73 35 62
5 Real Jaén Sub 16 Real Jaén 30 75 49 52
6 Granada CF Sub 16 Granada 30 71 44 51
7 CD San Félix Félix 30 68 47 46
8 UCD La Cañada Atlético Cañada 30 54 50 43
9 Alhaurin de La Torre Alhaurin 30 52 57 42
10 UD Maracena Sub 16 Maracena 30 67 73 39
11 CD Roquetas CD Roquetas 30 46 61 36
12 UD La Mosca Sub 16 Mosca 30 49 90 31
13 Atarfe Industrial Sub 16 Atarfe 30 38 86 24
14 Estrellas Chana Estrellas 30 49 95 22
15 Atlético Jaén Sub 16 Atlético 30 36 88 22
16 Cd Oriente Cd Oriente 30 19 141 4
TEMPORADA 2014/2015
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 16 Málaga 30 101 17 75
2 Puerto Malagueño Sub 16 Puerto 30 98 27 71
3 Granada CF Sub 16 Granada 30 82 22 68
4 UD Almeria Sub 16 Almeria 30 102 46 61
5 U.D.E. Chana U.D.E. Chana 30 53 45 52
6 Real Jaén Sub 16 Real Jaén 30 69 42 49
7 UD Maracena Sub 16 Maracena 30 54 51 49
8 UCD La Cañada Atlético Cañada 30 58 57 40
9 UD La Mosca Sub 16 Mosca 30 51 74 33
10 CD 26 De Febrero Sub 16 Febrero 30 51 105 32
11 CD Roquetas CD Roquetas 30 34 51 31
12 Alhaurin de La Torre Alhaurin 30 44 59 30
13 Los Molinos CF Molinos 30 47 75 29
14 E.M.D Villacarrillo E.M.D 30 40 87 24
15 La Mojonera La Mojonera 30 37 92 18
16 Ud Fuengirola L. Boliches C Fuengirola 30 36 107 15
TEMPORADA 2013/2014
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 16 Málaga 30 101 17 84
2 U.D. Almería U.D. 30 68 34 57
3 La Mojonera La Mojonera 30 53 44 51
4 UD La Mosca Sub 16 Mosca 30 50 45 50
5 Puerto Malagueño Sub 16 Puerto 30 66 53 50
6 Estrellas Chana UD Estrellas 30 52 50 46
7 Real Jaén Sub 16 Real Jaén 30 64 54 43
8 Atlético Jaén Atlético 30 54 70 40
9 Granada Granada 30 51 56 39
10 UCD La Cañada Atlético Cañada 30 45 53 38
11 Ud Fuengirola L. Boliches C Fuengirola 30 52 73 36
12 CD 26 De Febrero Sub 16 Febrero 30 45 57 34
13 Los Molinos CF Molinos 30 57 67 34
14 Tiro Pichón Tiro Pichón 30 45 71 31
15 Arenas de Armilla Sub 16 Arenas 30 36 55 29
16 CD Linares CF 2011 Linares 2011 30 37 77 16
TEMPORADA 2012/2013
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 16 Málaga 30 110 15 81
2 Polideportivo Almeria Polideportiv 30 93 15 77
3 Puerto Malagueño Sub 16 B Puerto 30 69 44 52
4 UD La Mosca Sub 16 Mosca 30 74 54 51
5 UCD La Cañada Atlético Cañada 30 55 42 48
6 Arenas de Armilla Sub 16 Arenas 30 50 50 44
7 Atlético Jaén Sub 16 Atlético 30 59 57 43
8 Cp Granada 74 Granada 30 56 48 39
9 Real Jaén Sub 16 Real Jaén 30 47 58 38
10 CD 26 De Febrero Sub 16 Febrero 30 54 61 37
11 Ud Fuengirola L. Boliches C Fuengirola 30 41 55 36
12 La Mojonera Cf Mojonera 30 45 58 36
13 Unión Estepona Cf Unión 30 51 70 35
14 P.D.Garrucha P.D.Garrucha 30 47 83 28
15 Cd Oriente Cd Oriente 30 26 67 20
16 P.Jienense P.Jienense 30 28 128 14
TEMPORADA 2011/2012
1ª ANDALUZA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Málaga CF Sub 16 Málaga 30 116 25 84
2 Ud Fuengirola L. Boliches C Fuengirola 30 65 29 71
3 UD Almería Sub 16 Almería 30 83 29 69
4 Granada Cf Granada Cf 30 62 38 45
5 Puerto Malagueño Gi Puerto 30 53 35 45
6 Real Jaén Sub 16 Real Jaén 30 52 59 45
7 UCD La Cañada Atlético Cañada 30 58 68 42
8 CD 26 De Febrero Sub 16 Febrero 30 49 55 40
9 Atlético Jaén Sub 16 Atlético 30 29 38 37
10 Unión Estepona Cf Unión 30 52 64 37
11 Cd Oriente Cd Oriente 30 37 59 36
12 La Mojonera La Mojonera 30 46 57 35
13 Los Molinos CF Molinos 30 54 79 33
14 Loja Cd Loja Cd 30 40 45 29
15 Betis Iliturgitano Betis 30 36 60 19
16 Cd Linares Cf 2011 Linares 2011 30 29 121 7

  USO DE MEMORIA  
6,012,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0940
Total Execution Time  0.0952
  CADENA URL  
/historico/Ucd-La-Canada-Atletico-Cadete
  GET DATOS  
$_GET['/historico/Ucd-La-Canada-Atletico-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0042  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 = 68956
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19807 AND type_rel = 2
0.0025  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 = '19807' 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 = '19807' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '19807' 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 = 68956 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=19807 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 (68956) 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 = 68956 AND teamId = 19807
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 = 68956 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 = '19807' 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 = '19807' 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 = '19807' 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 = 19807 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 = 68956 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 = 64286 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.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 = 62001 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.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 = 59694 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.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 = 52903 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.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 `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 = 44971 AND t.round = 30 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 `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 = 39447 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` 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 = 38053 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 `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 = 17287 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 `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 = 4319 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 `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 = 3341 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 `tables2013_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 = 2661 AND t.round = 30 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_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 = 1756 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC