4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Salas
TEMPORADA 2023/2024
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Vega FC Puerto Vega 32 78 30 74
2 Club Hispano Club Hispano 32 66 35 65
3 Atlético Camocha Atlético 32 58 39 55
4 Siderúrgico Llaranes CF Siderúrgico 32 50 36 55
5 Fabril CD Fabril CD 32 59 38 52
6 Navia CF Navia CF 32 43 36 49
7 Narcea Narcea 32 50 44 47
8 Tineo Tineo 32 41 46 44
9 Barcia CF B Barcia CF B 32 48 55 43
10 Codema CF Codema CF 32 52 61 40
11 Triple A Gijón Triple 32 49 54 38
12 Podes CF Podes CF 32 47 57 36
13 CD Salas CD Salas 32 39 46 36
14 Condal B Condal B 32 53 60 36
15 Gozón Gozón 32 47 58 34
16 CD Manuel Rubio Manuel Rubio 32 33 49 32
17 CD Treviense Treviense 32 28 53 29
18 GD Bosco GD Bosco 32 36 80 25
TEMPORADA 2022/2023
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 La Fresneda Fresneda 34 76 36 73
2 Muros Balompié Muros 34 79 43 69
3 La Guía Norte Astur Guía Norte 34 88 45 62
4 Siderúrgico Llaranes CF Siderúrgico 34 70 49 57
5 Puerto Vega FC Puerto Vega 34 62 56 53
6 Podes CF Podes CF 34 72 63 52
7 Quintueles CF Quintueles 34 50 53 47
8 CD Salas CD Salas 34 42 47 46
9 CD Treviense Treviense 34 50 59 46
10 Atlético Camocha Atlético 34 56 59 45
11 Narcea Narcea 34 59 57 41
12 CD Manuel Rubio Manuel Rubio 34 49 50 41
13 Gozón Gozón 34 50 60 41
14 Codema CF Codema CF 34 56 78 41
15 Club Hispano Club Hispano 34 51 61 40
16 Real Tapia CF Real Tapia 34 45 44 39
17 CD Raices CD Raices 34 46 75 31
18 Llanera B Llanera B 34 44 110 13
TEMPORADA 2021/2022
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Siderúrgico Llaranes CF Siderúrgico 22 68 19 54
2 CD Salas CD Salas 22 55 19 51
3 Avilés Stadium CF B Avilés 22 83 33 50
4 Rayo Villalegre Rayo 22 45 35 37
5 Versalles CF Versalles 22 45 35 37
6 Barcia CF B Barcia CF B 22 45 36 34
7 UD Castros UD Castros 22 35 46 30
8 CD Pillarno CD Pillarno 22 33 55 23
9 Miranda C.F. Miranda C.F. 22 29 50 18
10 La Caridad La Caridad 22 27 54 16
11 C. Hispano B Hispano 22 23 57 13
12 Puerto Vega B Puerto Vega 22 17 66 12
TEMPORADA 2020/2021
SEGUNDA RFFPA GRUPO 7
Equipo PJ GF GC Puntos
1 Narcea Narcea 8 20 12 17
2 Muros Balompié Muros 8 15 15 14
3 CD Treviense Treviense 8 15 12 10
4 Marino de Cudillero Marino 8 8 13 8
5 CD Salas CD Salas 8 8 14 6
TEMPORADA 2019/2020
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Salas CD Salas 21 49 19 51
2 Navia CF Navia CF 20 47 14 46
3 CD Pillarno CD Pillarno 20 39 20 42
4 Miranda C.F. Miranda C.F. 20 34 21 38
5 Mosconia B Mosconia B 21 32 22 35
6 Boal CF Boal CF 20 30 20 34
7 CD Raices CD Raices 21 42 30 33
8 Racing de Pravia Racing 21 48 36 32
9 Versalles CF Versalles 20 33 31 30
10 Soto del Barco Soto Barco 21 41 38 26
11 UD Castros UD Castros 21 25 36 24
12 La Braña B La Braña B 20 36 54 20
13 Rayo Villalegre Rayo 20 26 41 15
14 C. Hispano B Hispano 21 27 61 15
15 San Esteban de Pravia Esteban 21 11 77 3
TEMPORADA 2018/2019
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Llaranes CF Llaranes CF 34 76 33 74
2 Luarca CF Luarca CF 34 81 45 66
3 Podes CF Podes CF 34 86 54 66
4 Gozón Gozón 34 73 53 65
5 CD Treviense Treviense 34 73 50 57
6 Real Tapia CF Real Tapia 34 59 48 54
7 La Fresneda Fresneda 34 54 58 48
8 Barcia CF Barcia CF 34 65 46 47
9 Puerto Vega FC Puerto Vega 34 70 61 46
10 Club Hispano Club Hispano 34 49 48 44
11 La Caridad La Caridad 34 45 44 44
12 Astur Vegadense Astur 34 48 51 44
13 Muros Balompié Muros 34 53 68 43
14 GD Bosco GD Bosco 34 51 62 40
15 Narcea Narcea 34 43 65 39
16 Miranda C.F. Miranda C.F. 34 36 57 37
17 CD Salas CD Salas 34 36 78 29
18 UD Castros UD Castros 34 20 97 11
TEMPORADA 2017/2018
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Avilés Stadium Avilés 34 95 20 88
2 Luarca CF Luarca CF 34 75 20 84
3 Muros Balompié Muros 34 68 42 65
4 Real Tapia CF Real Tapia 34 81 57 59
5 Podes CF Podes CF 34 72 48 55
6 Llaranes CF Llaranes CF 34 55 43 54
7 Club Hispano Club Hispano 34 56 46 53
8 CD Treviense Treviense 34 62 57 51
9 GD Bosco GD Bosco 34 56 61 47
10 Narcea Narcea 34 51 48 44
11 Miranda C.F. Miranda C.F. 34 47 53 43
12 C.D. Valsa C.D. Valsa 34 50 49 42
13 Astur Vegadense Astur 34 38 54 40
14 CD Salas CD Salas 34 48 59 38
15 Real Avilés Cf B Real Avilés 34 55 67 34
16 La Caridad La Caridad 34 35 59 32
17 Boal CF Boal CF 34 31 93 17
18 Arenesco Arenesco 34 21 120 9
TEMPORADA 2016/2017
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Vallobin CD Vallobin CD 22 48 26 48
2 Pumarín Cf Pumarín Cf 22 50 20 47
3 Sd Colloto Sd Colloto 22 48 25 43
4 Real Tapia CF Real Tapia 22 42 24 38
5 Guillen Lafuerza Guillen 22 41 31 38
6 CD Salas CD Salas 22 38 28 36
7 Riosa Riosa 22 35 30 34
8 Real Juvencia Real 22 29 26 33
9 UD San Claudio B Claudio 22 34 31 32
10 La Caridad La Caridad 22 30 34 32
11 Boal CF Boal CF 22 36 37 30
12 La Fresneda Fresneda 22 46 46 28
13 Beredi Beredi 22 49 46 27
14 Juventud Estadio Juventud 22 24 38 23
15 Astur Vegadense Astur 22 26 43 18
16 Narcea Narcea 22 22 41 16
17 Atletico de Siero Atletico 22 34 66 12
18 SCD Campomanes Campomanes 22 17 57 11
TEMPORADA 2015/2016
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Muros Balompié Muros 34 91 30 84
2 Llaranes CF Llaranes CF 34 77 31 76
3 Real Tapia CF Real Tapia 34 64 40 70
4 Podes CF Podes CF 34 63 53 58
5 C.D. Valsa C.D. Valsa 34 53 41 57
6 CD Salas CD Salas 34 50 46 52
7 Narcea Narcea 34 49 42 51
8 La Guía Norte Astur Guía Norte 34 50 49 50
9 Boal CF Boal CF 34 54 50 50
10 Club Hispano Club Hispano 34 57 59 44
11 CD Manuel Rubio Manuel Rubio 34 61 56 44
12 Gozón Gozón 34 38 48 40
13 La Caridad La Caridad 34 52 64 39
14 Arenesco Arenesco 34 57 72 37
15 Astur Vegadense Astur 34 51 60 34
16 CD Pillarno CD Pillarno 34 33 58 33
17 Miranda C.F. Miranda C.F. 34 39 62 31
18 CD Raíces CD Raíces 34 20 98 10
TEMPORADA 2014/2015
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Salas CD Salas 29 119 22 74
2 La Corredoria Corredoria 29 79 22 64
3 Guillén Lafuerza Guillén 29 86 32 64
4 Rosal FC Rosal FC 29 85 36 64
5 CD Ujo CD Ujo 30 74 47 55
6 Minas Oviedo Minas Oviedo 30 68 52 51
7 Pumarin B Pumarin B 29 84 45 50
8 UD San Claudio B Claudio 29 56 42 49
9 CD Tineo B CD Tineo B 29 56 54 49
10 Stiaua d'Asturies Stiaua 29 39 62 31
11 Oviedo 06 Oviedo 06 29 42 68 31
12 Cubia FC Cubia FC 29 47 75 26
13 CD La Manjoya Manjoya 29 37 56 22
14 San Juan La Carisa Juan Carisa 29 42 111 18
15 Grisu CF Grisu CF 29 32 117 13
16 Centro Asturiano Centro 29 23 128 7
TEMPORADA 2008/2009
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 CD Praviano CD Praviano 38 64 24 83
2 Colloto Colloto 38 63 39 73
3 Luarca CF Luarca CF 38 70 43 69
4 Tineo Tineo 38 54 29 67
5 Atlético de Lugones Atlético 38 45 46 66
6 Racing De Sama Racing Sama 38 57 43 62
7 Real Tapia CF Real Tapia 38 59 52 54
8 L´Entregu CF L´Entregu 38 57 53 53
9 San Martín San Martín 38 51 47 53
10 La Caridad La Caridad 38 53 50 53
11 Narcea Narcea 38 61 51 52
12 Andés Andés 38 39 37 52
13 U.Comercial U.Comercial 38 50 62 50
14 Universidad de Oviedo B Universidad 38 59 65 45
15 Urraca CF Urraca CF 38 44 57 45
16 Valdesoto Valdesoto 38 61 66 44
17 Santiago De Aller Santiago 38 42 65 44
18 Atlético Camocha Atlético 38 38 84 33
19 Club Hispano Club Hispano 38 38 64 32
20 CD Salas CD Salas 38 35 63 27

  USO DE MEMORIA  
6,182,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1148
Total Execution Time  0.1160
  CADENA URL  
/historico/Cd-Salas
  GET DATOS  
$_GET['/historico/Cd-Salas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0027  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 = 'Cd-Salas' 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=20086 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=20086 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 73671
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20086 AND type_rel = 2
0.0024  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 = '20086' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '20086' 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 = 73671 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=20086 AND l.year in (2023,2024,2025) 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 (73671) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73671 AND teamId = 20086
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 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 = 73671 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '20086' 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 = '20086' 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 = '20086' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 73671 WHERE rp.league_id = 73671 AND rp.teamId = 20086 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.0030  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 = 73671 WHERE rp.league_id = 73671 AND rp.teamId = 20086 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 73671 WHERE rp.league_id = 73671 AND rp.teamId = 20086 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 = 20086 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73671 AND t.round = 32 ORDER BY team.conference ASC,t.position 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 `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 = 68982 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.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` 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 = 63770 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.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` 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 = 62266 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 `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 = 51426 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.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 = 45220 AND t.round = 34 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 `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 = 39201 AND t.round = 34 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 = 34042 AND t.round = 34 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` 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 = 16776 AND t.round = 34 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 `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 = 4317 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 `tables2009` 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 = 287 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC