4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Miengo
TEMPORADA 2023/2024
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Gama SD Gama 7 6 1 17
2 SD Barreda Balompié Barreda 7 18 7 16
3 SD Textil Escudo Textil 7 10 4 13
4 CD Monte CD Monte 6 9 6 13
5 Peña Revilla SD Peña 7 7 4 11
6 SD San Martín Arena Martín 7 5 6 11
7 Cayón B Cayón B 7 10 10 10
8 Barquereño Barquereño 7 11 7 9
9 EMD Santillana Santillana 7 11 9 9
10 SD Solares B Solares 7 8 7 9
11 Ribamontán al Mar Ribamontán 7 6 4 8
12 FC Miengo FC Miengo 6 9 11 8
13 CD Naval B CD Naval B 7 7 10 6
14 Rayo Santa Cruz Rayo Santa. 7 8 12 6
15 Noja Noja 7 7 11 6
16 Arenas de Frajanas Arenas 7 3 8 6
17 Selaya Selaya 7 6 11 4
18 Estrella Roja Estrella 7 5 18 3
TEMPORADA 2022/2023
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Cayón B Cayón B 34 72 41 69
2 FC Miengo FC Miengo 34 73 39 67
3 CD Naval B CD Naval B 33 69 37 65
4 Peña Revilla SD Peña 34 60 29 65
5 SD Solares B Solares 33 78 43 63
6 Santiago Galas Santiago 34 51 44 53
7 Ayrón Club Ayrón Club 34 72 52 52
8 Rio Gandara CD Gandara 34 62 68 51
9 Minerva Fc Minerva Fc 34 62 65 45
10 Escobedo B Escobedo B 33 62 55 44
11 CD Calasanz CD Calasanz 34 45 57 44
12 Marina de Cudeyo Marina 33 50 58 42
13 Atlético España De Cueto Atlético 34 40 47 39
14 Ampuero FC Ampuero FC 34 46 65 39
15 Rinconeda Rinconeda 34 50 70 35
16 Valle Lebaniego Valle 34 46 78 34
17 CD Los Rios CD Los Rios 34 48 83 30
18 Atco. Mineros B Atco. 34 32 87 11
TEMPORADA 2021/2022
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Solares SD Solares 34 69 23 75
2 Revilla Revilla 34 68 30 69
3 SD Gama SD Gama 34 75 42 66
4 Velarde CF Velarde CF 34 72 28 65
5 CD Bezana CD Bezana 34 65 36 62
6 Atlético Mineros Atlético 34 60 48 55
7 CD Ramales CD Ramales 34 59 50 55
8 SD San Martín Arena Martín 34 52 51 52
9 Barquereño Barquereño 34 51 52 51
10 CD Monte CD Monte 34 48 58 47
11 Nueva Montaña Nueva 34 46 52 43
12 Arenas de Frajanas Arenas 34 48 61 39
13 Ribamontán al Mar Ribamontán 34 39 56 39
14 Rinconeda Rinconeda 34 48 67 37
15 FC Miengo FC Miengo 34 44 71 35
16 CD Los Rios CD Los Rios 34 51 86 31
17 Ampuero FC Ampuero FC 34 36 76 18
18 Ayrón Club Ayrón Club 34 31 75 18
TEMPORADA 2020/2021
PREFERENTE CANTABRIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Naval CD Naval 16 51 7 43
2 Atlético Mineros Atlético 16 35 15 34
3 Velarde CF Velarde CF 16 30 16 27
4 Arenas de Frajanas Arenas 16 21 20 26
5 FC Miengo FC Miengo 16 21 21 21
6 CD Los Rios CD Los Rios 16 24 27 21
7 EMD Santillana Santillana 16 26 29 19
8 EMF Meruelo EMF Meruelo 16 11 36 5
9 Atco. Deva Atco. Deva 16 5 53 4
TEMPORADA 2019/2020
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 25 51 17 53
2 Castro Castro 25 48 21 51
3 Rinconeda Rinconeda 25 46 21 51
4 FC Miengo FC Miengo 24 39 26 46
5 Nueva Montaña Nueva 25 55 39 40
6 Atlético Mineros Atlético 24 38 29 39
7 Noja Noja 25 32 30 36
8 CD Colindres Colindres 25 31 25 35
9 Velarde CF Velarde CF 25 39 35 35
10 CD Naval CD Naval 25 34 39 33
11 SD Gama SD Gama 25 28 31 30
12 Villaescusa SD Villaescusa 25 27 38 29
13 Valle Lebaniego Valle 25 33 50 28
14 EMF Meruelo EMF Meruelo 25 31 45 27
15 EMD Santillana Santillana 25 30 34 24
16 Atco. Deva Atco. Deva 25 28 45 22
17 CD Ramales CD Ramales 25 19 58 17
18 CD Los Rios CD Los Rios 25 23 49 15
TEMPORADA 2018/2019
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 FC Miengo FC Miengo 34 81 38 78
2 Atco. Deva Atco. Deva 34 75 32 78
3 Villaescusa SD Villaescusa 34 66 26 77
4 Arenas de Frajanas Arenas 34 68 35 72
5 Rayo Santa Cruz Rayo Santa. 34 58 43 61
6 Ampuero FC Ampuero FC 34 56 47 51
7 Atlético España De Cueto Atlético 34 65 65 50
8 Santoña CF Santoña CF 34 46 54 48
9 Vimenor B Vimenor B 34 56 55 46
10 Santiago Galas Santiago 34 58 59 41
11 Rio Gandara CD Gandara 34 64 72 39
12 Cd Montañas Del Pas Montañas 34 50 66 38
13 Reocin Reocin 34 52 66 37
14 Santillana B Santillana 34 44 58 35
15 Minerva Fc Minerva Fc 34 51 67 34
16 Marina de Cudeyo Marina 34 32 67 28
17 CD Calasanz CD Calasanz 34 43 75 27
18 CD Valdáliga Valdáliga 34 41 81 20
TEMPORADA 2017/2018
2ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Rio Gandara CD Gandara 38 130 45 87
2 FC Miengo FC Miengo 38 97 42 85
3 Rayo Santa Cruz Rayo Santa. 38 99 42 82
4 CD Valdáliga Valdáliga 38 90 49 77
5 CD Calasanz CD Calasanz 38 89 50 77
6 Cd Montañas Del Pas Montañas 38 80 43 76
7 Fortuna Camargo Fortuna 38 94 55 74
8 Juventud Atlético San Roman Juventud 37 79 59 67
9 Union club Union club 37 85 64 63
10 SD Solares B Solares 37 89 73 55
11 Jesus del Monte Jesus Monte 37 81 67 50
12 Toranzo CD Toranzo CD 38 64 79 50
13 CD Liendo CD Liendo 38 59 94 45
14 Los Rios B Los Rios B 38 50 112 34
15 AD Cubas AD Cubas 38 46 101 32
16 Peñacastillo Peñacastill 38 62 105 30
17 San Justo CD Justo 38 37 82 30
18 CD Comillas CD Comillas 38 35 74 29
19 Iguña SD Iguña SD 38 45 97 26
20 Olimpia FC Olimpia FC 38 40 118 15
TEMPORADA 2016/2017
2ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Santiago Galas Santiago 42 90 31 98
2 Sd Reocín Sd Reocín 42 95 45 95
3 Atlético Mineros Atlético 41 122 40 94
4 Rayo Santa Cruz Rayo Santa. 42 80 43 82
5 FC Miengo FC Miengo 42 95 45 81
6 CD Valdáliga Valdáliga 41 86 36 81
7 Cd Montañas Del Pas Montañas 42 81 47 74
8 Fortuna Camargo Fortuna 41 79 59 73
9 Union club Union club 42 84 68 70
10 Peñacastillo Peñacastill 42 93 88 65
11 San Justo CD Justo 42 67 55 63
12 SD Solares B Solares 42 67 56 62
13 Jesus del Monte Jesus Monte 41 76 75 55
14 Bezana B Bezana B 42 57 71 53
15 Toranzo CD Toranzo CD 42 72 72 46
16 Vimenor C Vimenor C 42 56 105 39
17 Atlético San Roman B Atlético 42 38 89 36
18 CD Liendo CD Liendo 42 67 113 34
19 Los Rios B Los Rios B 42 61 123 29
20 Iguña SD Iguña SD 42 33 80 25
21 Trasmiera Trasmiera 40 30 107 22
22 Olimpia FC Olimpia FC 42 36 117 12
TEMPORADA 2015/2016
2ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Villaescusa SD Villaescusa 36 129 41 86
2 Peña Revilla SD Peña 36 105 39 80
3 Santillana B Santillana 35 88 36 78
4 FC Miengo FC Miengo 36 80 42 71
5 Nueva Montaña B Nueva 35 85 51 70
6 Toranzo CD Toranzo CD 36 82 62 67
7 Rayo Cantabria Rayo 36 74 51 65
8 Rayo Santa Cruz Rayo Santa. 35 66 34 64
9 Fortuna Camargo Fortuna 35 68 78 45
10 Iguña SD Iguña SD 36 66 82 42
11 Jesus del Monte Jesus Monte 36 61 72 41
12 CD Liendo CD Liendo 36 54 70 38
13 Sd Reocín Sd Reocín 36 55 91 38
14 Los Rios B Los Rios B 36 50 77 37
15 Peñacastillo Peñacastill 36 65 100 35
16 San Justo CD Justo 36 47 77 33
17 Union club Union club 36 47 75 33
18 Olimpia FC Olimpia FC 36 33 97 21
19 SD Solares B Solares 36 31 111 17
TEMPORADA 2014/2015
2ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Ampuero FC Ampuero FC 34 80 28 79
2 Bezana B Bezana B 34 67 28 76
3 Valle Lebaniego Valle 34 92 41 75
4 Rio Gandara CD Gandara 34 94 38 74
5 Peña Revilla SD Peña 34 94 44 66
6 Villaescusa SD Villaescusa 34 75 52 61
7 Iguña SD Iguña SD 34 71 50 58
8 Jesus del Monte Jesus Monte 34 58 50 50
9 FC Miengo FC Miengo 34 50 47 45
10 San Justo CD Justo 34 52 60 43
11 Buelna B Buelna B 34 69 85 43
12 Fortuna Camargo Fortuna 34 61 72 40
13 Nueva Montaña B Nueva 34 60 57 39
14 SD Solares B Solares 34 38 68 30
15 Toranzo CD Toranzo CD 34 40 79 29
16 Rayo Santa Cruz Rayo Santa. 34 39 91 23
17 Velez Junior Soto Velez Junior 34 44 94 22
18 Olimpia FC Olimpia FC 34 25 125 12
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Noja Noja 38 82 18 87
2 Tropezón Tropezón 38 66 20 75
3 FC Miengo FC Miengo 38 58 29 72
4 Rayo Cantabria Rayo 38 58 25 71
5 Atco. Deva Atco. Deva 38 51 36 61
6 Santoña CF Santoña CF 38 49 49 57
7 SD Barreda Balompié Barreda 38 46 53 55
8 UM Escobedo UM Escobedo 38 53 51 54
9 CD Bezana CD Bezana 38 51 46 53
10 CD Guarnizo CD Guarnizo 38 53 60 47
11 CD Laredo CD Laredo 38 35 56 46
12 Revilla Revilla 38 36 41 45
13 CD Naval CD Naval 38 33 56 45
14 Velarde CF Velarde CF 38 49 48 45
15 SD Textil Escudo Textil 38 37 45 44
16 Ribamontán al Mar Ribamontán 38 42 46 43
17 Cayón Cayón 38 51 49 43
18 CD Comillas CD Comillas 38 37 67 39
19 Marina de Cudeyo Marina 38 33 82 30
20 Ampuero FC Ampuero FC 38 35 78 25
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Rayo Cantabria Rayo 38 64 15 91
2 UM Escobedo UM Escobedo 38 67 30 77
3 Ribamontán al Mar Ribamontán 38 51 26 71
4 CD Bezana CD Bezana 38 50 31 70
5 Santoña CF Santoña CF 38 52 42 68
6 Cayón Cayón 38 33 40 57
7 SD Barreda Balompié Barreda 38 55 46 54
8 SD Textil Escudo Textil 38 33 32 51
9 CD Naval CD Naval 38 32 33 49
10 Revilla Revilla 38 31 40 48
11 CD Laredo CD Laredo 38 36 40 45
12 CD Guarnizo CD Guarnizo 38 42 48 45
13 Velarde CF Velarde CF 38 32 47 44
14 CD Comillas CD Comillas 38 43 55 43
15 Castro Castro 38 44 49 42
16 Unión Club Unión Club 38 38 66 41
17 FC Miengo FC Miengo 38 34 36 40
18 Villaescusa SD Villaescusa 38 31 42 39
19 Ayrón Club Ayrón Club 38 32 48 37
20 CD Pontejos CD Pontejos 38 37 71 26

  USO DE MEMORIA  
6,553,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1402
Total Execution Time  0.1421
  CADENA URL  
/historico/Miengo-Fc
  GET DATOS  
$_GET['/historico/Miengo-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0034  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 = 'Miengo-Fc' 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.0062  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=20054 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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=20054 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20054 AND type_rel = 2
0.0024  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 = '20054' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=20054 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 (73447,68996) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73447 AND teamId = 20054
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 68996 AND teamId = 20054
0.0047  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 = '20054' 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 = '20054' and rp.type = 4
0.0035  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 = '20054' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 20054 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.0029  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 20054 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 20054 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 20054 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73447 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 68996 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.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 `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 = 63670 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` 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 = 58850 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.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 `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 = 51274 AND t.round = 25 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` 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 = 44659 AND t.round = 34 ORDER BY team.conference 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 `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 = 39199 AND t.round = 38 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 `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 = 34360 AND t.round = 42 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` 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 = 16815 AND t.round = 38 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 `tables2000` 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 = 22016 AND t.round = 38 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 `tables1999` 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 = 22000 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC