4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Llanera

UD Llanera

Entrenador: Chuchi Collado

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UD Llanera UD Llanera 31 96 22 78
2 Sporting Atlético Sporting 31 58 13 67
3 UC Ceares UC Ceares 31 47 24 61
4 L´Entregu CF L´Entregu 31 49 29 61
5 Lealtad Villaviciosa Lealtad 31 48 24 59
6 CD Praviano CD Praviano 31 32 21 53
7 CD Tuilla CD Tuilla 31 50 39 45
8 Urraca CF Urraca CF 31 30 31 42
9 CD Colunga CD Colunga 31 36 38 41
10 Caudal Deportivo Caudal 31 31 31 39
11 SD Lenense Proinastur Lenense 31 28 44 33
12 Llanes Llanes 31 33 50 33
13 Avilés Stadium Avilés 31 28 41 32
14 Real Titánico Real 31 39 59 30
15 Condal Condal 31 24 48 30
16 Luarca CF Luarca CF 31 36 65 25
17 UD Gijón Industrial Gijón 31 29 61 24
18 Barcia CF Barcia CF 31 23 77 9
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Covadonga Covadonga 30 53 21 65
2 Sporting Atlético Sporting 30 56 21 64
3 L´Entregu CF L´Entregu 30 42 28 60
4 UD Llanera UD Llanera 30 49 26 55
5 CD Praviano CD Praviano 30 40 23 53
6 Caudal Deportivo Caudal 30 41 21 50
7 Lealtad Villaviciosa Lealtad 30 31 27 43
8 Llanes Llanes 30 36 40 40
9 Real Titánico Real 30 28 44 36
10 CD Colunga CD Colunga 30 35 39 36
11 CD Tuilla CD Tuilla 30 39 52 36
12 UC Ceares UC Ceares 30 35 44 34
13 Luarca CF Luarca CF 30 21 32 30
14 Condal Condal 30 20 42 25
15 Avilés Stadium Avilés 30 25 52 23
16 Valdesoto Valdesoto 30 22 61 14
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Pontevedra Pontevedra 34 66 35 65
2 Unión Adarve Unión 34 54 39 61
3 CDA Navalcarnero Navalcarnero 34 41 32 57
4 Coruxo Coruxo 34 46 32 52
5 Palencia Cristo Atlético Palencia 34 51 41 52
6 Bergantiños FC Bergantiños 34 36 37 49
7 Leganés B Leganés B 34 44 34 48
8 SD Compostela Compostela 34 47 38 47
9 Real Avilés Industrial Real Avilés 34 43 37 47
10 Arenteiro Arenteiro 34 35 35 45
11 Langreo Langreo 34 40 41 44
12 Marino de Luanco Marino 34 38 38 43
13 Gimnástica Segoviana Gimnástica 34 37 42 42
14 CD Móstoles Móstoles 34 37 44 41
15 Salamanca UDS Salamanca 34 26 29 41
16 UD Llanera UD Llanera 34 39 55 40
17 Arosa Arosa 34 32 48 39
18 UC Ceares UC Ceares 34 23 78 18
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UC Ceares UC Ceares 20 29 16 44
2 Real Avilés Industrial Real Avilés 20 33 13 40
3 UD Llanera UD Llanera 20 38 28 38
4 Caudal Deportivo Caudal 20 36 18 38
5 UD Gijón Industrial Gijón 20 34 27 27
6 SD Lenense Proinastur Lenense 20 24 27 25
7 CD Praviano CD Praviano 20 23 28 24
8 Navarro Navarro 20 18 26 22
9 Mosconia Mosconia 20 15 28 20
10 Vallobin CD Vallobin CD 20 14 32 17
11 Avilés Stadium Avilés 20 12 33 12
12 L´Entregu CF L´Entregu 18 32 13 40
13 EI San Martín Martín 18 31 21 33
14 Llanes Llanes 18 29 16 32
15 CD Tuilla CD Tuilla 18 25 19 27
16 Real Titánico Real 18 19 25 23
17 Urraca CF Urraca CF 18 9 12 22
18 Condal Condal 18 13 19 22
19 CD Colunga CD Colunga 18 11 17 20
20 Club Siero Club Siero 18 12 23 15
21 Valdesoto Valdesoto 18 10 26 12
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Lealtad Villaviciosa Lealtad 28 44 12 62
2 UD Llanera UD Llanera 28 48 26 59
3 CD Covadonga Covadonga 28 65 33 57
4 Caudal Deportivo Caudal 28 54 21 56
5 CD Tuilla CD Tuilla 28 42 25 55
6 Llanes Llanes 28 47 30 48
7 Urraca CF Urraca CF 28 34 25 43
8 UD Gijón Industrial Gijón 28 42 36 39
9 L´Entregu CF L´Entregu 28 26 36 34
10 Condal Condal 28 29 37 32
11 CD Praviano CD Praviano 28 37 42 32
12 Mosconia Mosconia 28 29 33 31
13 Navarro Navarro 28 26 35 31
14 SD Lenense Proinastur Lenense 28 28 48 29
15 UC Ceares UC Ceares 28 28 37 27
16 Real Avilés Industrial Real Avilés 28 34 50 25
17 Vallobin CD Vallobin CD 28 19 32 25
18 EI San Martín Martín 28 26 49 24
19 CD Colunga CD Colunga 28 25 53 23
20 Club Siero Club Siero 28 25 48 20
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Lealtad Villaviciosa Lealtad 38 72 16 90
2 Marino de Luanco Marino 38 77 22 90
3 Caudal Deportivo Caudal 38 72 29 75
4 CD Covadonga Covadonga 38 80 42 73
5 UD Llanera UD Llanera 38 65 42 70
6 Llanes Llanes 38 52 38 65
7 CD Tuilla CD Tuilla 38 67 47 64
8 L´Entregu CF L´Entregu 38 42 36 57
9 Mosconia Mosconia 38 51 42 55
10 CD Praviano CD Praviano 38 43 49 51
11 Condal Condal 38 40 48 48
12 CD Colunga CD Colunga 38 38 48 44
13 UC Ceares UC Ceares 38 35 51 44
14 Real Avilés Industrial Real Avilés 38 32 65 37
15 EI San Martín Martín 38 35 53 36
16 Club Siero Club Siero 38 35 60 36
17 UD Gijón Industrial Gijón 38 38 64 35
18 Madalena Madalena 38 37 70 34
19 Universidad Oviedo Universidad 38 30 61 30
20 UD San Claudio Claudio 38 23 81 17
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Vetusta Real Oviedo 38 73 19 82
2 Langreo Langreo 38 89 23 78
3 Marino de Luanco Marino 38 70 21 76
4 Llanes Llanes 38 65 48 75
5 CD Covadonga Covadonga 38 83 46 72
6 UC Ceares UC Ceares 38 46 30 60
7 CD Tuilla CD Tuilla 38 60 41 59
8 CD Praviano CD Praviano 38 45 37 58
9 L´Entregu CF L´Entregu 38 53 50 53
10 EI San Martín Martín 38 41 50 51
11 Mosconia Mosconia 38 39 57 50
12 UD Gijón Industrial Gijón 38 52 55 47
13 Condal Condal 38 39 67 44
14 CD Colunga CD Colunga 38 44 60 42
15 UD Llanera UD Llanera 38 48 65 39
16 Club Siero Club Siero 38 34 70 36
17 Real Avilés Industrial Real Avilés 38 35 64 32
18 Valdesoto Valdesoto 38 27 55 30
19 Atlético de Lugones Atlético 38 22 68 28
20 TSK Roces TSK Roces 38 29 68 24
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting Atlético Sporting 38 112 18 92
2 Real Avilés Industrial Real Avilés 38 90 34 85
3 Langreo Langreo 38 78 26 84
4 CD Tuilla CD Tuilla 38 61 35 84
5 Real Oviedo Vetusta Real Oviedo 38 78 32 75
6 Marino de Luanco Marino 38 61 36 75
7 CD Covadonga Covadonga 38 69 50 63
8 Condal Condal 38 65 50 62
9 UC Ceares UC Ceares 38 47 63 49
10 Llanes Llanes 38 53 44 48
11 CD Colunga CD Colunga 38 51 59 48
12 Mosconia Mosconia 38 38 84 35
13 UD Llanera UD Llanera 38 38 61 35
14 CD Praviano CD Praviano 38 46 78 35
15 L´Entregu CF L´Entregu 38 27 66 33
16 Club Siero Club Siero 38 36 83 33
17 Atlético de Lugones Atlético 38 42 78 31
18 Tineo Tineo 38 42 71 31
19 SD Lenense Proinastur Lenense 38 50 84 30
20 Urraca CF Urraca CF 38 32 64 27
TEMPORADA 2015/2016
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 L´Entregu CF L´Entregu 38 70 30 78
2 UD Llanera UD Llanera 38 69 28 76
3 SD Lenense Proinastur Lenense 38 54 28 76
4 Andés Andés 38 60 38 73
5 EI San Martín Martín 38 61 34 72
6 Navarro Navarro 38 58 27 71
7 Nalón CF Nalón CF 38 63 38 70
8 CD Turón CD Turón 38 57 49 60
9 Valdesoto Valdesoto 38 54 50 58
10 Unión Comercial Unión 38 51 48 50
11 Luarca CF Luarca CF 38 54 60 50
12 Madalena Madalena 38 58 62 48
13 Candás CF Candás CF 38 48 64 46
14 UD San Claudio Claudio 38 46 46 45
15 Universidad Oviedo Universidad 38 34 54 45
16 Berrón Berrón 38 48 59 41
17 CD Rayo Carbayín Rayo 38 47 71 41
18 SCD Campomanes Campomanes 38 35 66 33
19 Real Avilés Cf B Real Avilés 38 26 83 17
20 La Fresneda Fresneda 38 36 94 14
TEMPORADA 2014/2015
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 Club Siero Club Siero 38 69 39 69
2 CD Colunga CD Colunga 38 60 39 69
3 Tineo Tineo 38 63 42 68
4 CD Rayo Carbayín Rayo 38 63 47 67
5 Sd Llano 2000 Llano 2000 38 45 23 62
6 EI San Martín Martín 38 59 53 54
7 Valdesoto Valdesoto 38 57 55 53
8 UD Llanera UD Llanera 38 63 61 52
9 Candás CF Candás CF 38 49 48 51
10 CD Turón CD Turón 38 50 50 51
11 SCD Campomanes Campomanes 38 51 56 51
12 UD San Claudio Claudio 38 41 42 50
13 Unión Comercial Unión 38 35 48 50
14 Madalena Madalena 38 52 55 49
15 Luarca CF Luarca CF 38 41 43 48
16 Navarro Navarro 38 42 45 48
17 Real Tapia CF Real Tapia 38 46 58 43
18 Boal CF Boal CF 38 36 56 38
19 Muros Balompié Muros 38 44 62 34
20 CD Raíces CD Raíces 38 36 80 25
TEMPORADA 2013/2014
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 TSK Roces TSK Roces 38 75 32 77
2 Llanes Llanes 38 86 41 76
3 Astur Astur 38 71 38 76
4 Mosconia Mosconia 38 78 38 70
5 CD Colunga CD Colunga 38 68 44 66
6 CD Rayo Carbayín Rayo 38 67 50 61
7 Navarro Navarro 38 47 35 61
8 Valdesoto Valdesoto 38 59 46 55
9 Atlético Siero Atlético 38 56 53 52
10 Sd Llano 2000 Llano 2000 38 46 44 52
11 Tineo Tineo 38 38 47 51
12 UD Llanera UD Llanera 38 58 56 50
13 Muros Balompié Muros 38 56 54 50
14 U.Comercial U.Comercial 38 50 52 49
15 CD Turón CD Turón 38 68 69 47
16 Boal CF Boal CF 38 51 59 46
17 SCD Campomanes Campomanes 38 54 65 45
18 Nalón CF Nalón CF 38 34 54 39
19 Pumarín CF Pumarín CF 38 53 65 31
20 Navia CF Navia CF 38 21 194 3
TEMPORADA 2010/2011
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 CD Covadonga Covadonga 38 70 18 91
2 Colloto Colloto 38 74 41 73
3 Pumarín CF Pumarín CF 38 51 23 70
4 Atlético de Lugones Atlético 38 59 39 66
5 Tineo Tineo 38 47 38 66
6 Urraca CF Urraca CF 38 64 62 53
7 Narcea Narcea 38 39 51 53
8 Valdesoto Valdesoto 38 52 52 52
9 La Caridad La Caridad 38 47 48 51
10 SCD Campomanes Campomanes 38 59 51 50
11 Real Avilés Industrial B Real Avilés 38 50 49 50
12 L´Entregu CF L´Entregu 38 50 47 48
13 Club Siero Club Siero 38 49 62 48
14 Universidad de Oviedo B Universidad 38 52 68 46
15 U.Comercial U.Comercial 38 43 59 45
16 San Martín San Martín 38 57 64 44
17 Deportiva Piloñesa Deportiva 38 43 64 44
18 Mosconia Mosconia 38 52 70 42
19 Astur Astur 38 45 62 37
20 UD Llanera UD Llanera 38 37 72 26

  USO DE MEMORIA  
7,067,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5327
Total Execution Time  0.5339
  CADENA URL  
/historico/Ud-Llanera
  GET DATOS  
$_GET['/historico/Ud-Llanera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0252  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 = 73781
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4689 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0132  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 = '4689' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72568 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 72261 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=4689 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75879,73781,72261,71489,71432) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 72261 AND teamId = 4689
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 4689
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 4689
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73781 AND teamId = 4689
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4689
0.0133  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 = 72261 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '4689' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4689' and rp.type = 4
0.0127  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 = '4689' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 4689 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.0144  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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 4689 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 72261 WHERE rp.league_id = 72261 AND rp.teamId = 4689 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 4689 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 67976 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.0131  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 = 62380 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.0144  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 = 58580 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.0146  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 = 50270 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 44390 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 39026 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 16699 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 4081 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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` 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 = 2589 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2011` 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 = 1129 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC