4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Santa Marina de Mieres
TEMPORADA 2023/2024
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Turón CD Turón 31 69 22 76
2 UD San Claudio Claudio 31 77 32 66
3 Europa de Nava Europa Nava 31 55 24 66
4 Nalón CF Nalón CF 31 48 23 59
5 Grujoan Grujoan 31 57 34 55
6 Madalena Madalena 31 61 53 53
7 Real Juvencia Real 31 48 41 51
8 UP Langreo B Langreo 31 61 48 46
9 Ribadesella Ribadesella 31 54 36 43
10 CD San Jorge Jorge 31 41 39 42
11 Pumarín CF Pumarín CF 31 37 40 41
12 Quintueles CF Quintueles 31 42 63 33
13 Ribadedeva Ribadedeva 31 34 47 32
14 Lealtad de Villaviciosa B Lealtad 31 42 64 26
15 Arguero CF Arguero CF 31 31 66 25
16 CD La Manjoya Manjoya 31 23 51 24
17 Rosal FC Rosal FC 31 31 83 20
18 Santa Marina de Mieres Santa Marina 31 23 68 15
TEMPORADA 2022/2023
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Rosal FC Rosal FC 26 77 30 55
2 Santa Marina de Mieres Santa Marina 26 66 31 54
3 Riosa Riosa 26 75 26 52
4 CD La Manjoya Manjoya 26 58 23 52
5 La Corredoria Corredoria 26 91 34 51
6 SCD Campomanes Campomanes 25 55 31 46
7 Real Avilés B Real Avilés 26 79 40 42
8 Guillen Lafuerza Guillen 25 62 47 39
9 Oviedo City FC Oviedo City 26 63 53 33
10 CD Ujo CD Ujo 26 78 72 33
11 SD Colloto B Colloto 26 45 59 29
12 Centro Asturiano Oviedo Centro 26 40 77 19
13 Club Atletico de La Florida Club 26 30 105 13
14 Grisu CF Grisu CF 26 15 206 3
TEMPORADA 2021/2022
TERCERA RFFPA GRUPO 4
Equipo PJ GF GC Puntos
1 Atlético Siero Atlético 22 65 30 55
2 Santa Marina de Mieres Santa Marina 22 65 24 48
3 Lenense Proinastur B Lenense 22 67 29 46
4 CD San Jorge Jorge 22 65 31 44
5 L'Entregu B L'Entregu B 22 47 38 42
6 Arenas del Sella Arenas Sella 22 29 46 28
7 Lada Langreo Lada Langreo 22 26 37 25
8 CD Ujo CD Ujo 22 51 57 24
9 Colegio Riaño CF Colegio 22 40 46 24
10 CD Rayo Carbayín Rayo 22 28 64 17
11 CF Berron B CF Berron B 22 24 51 15
12 C. Europa B C. Europa B 22 19 73 7
TEMPORADA 2020/2021
TERCERA RFFPA GRUPO 6
Equipo PJ GF GC Puntos
1 Riosa Riosa 10 24 14 20
2 Santa Marina de Mieres Santa Marina 10 15 10 19
3 Lenense Proinastur B Lenense 10 15 12 17
4 L'Entregu B L'Entregu B 10 17 22 11
5 Colegio Riaño CF Colegio 10 19 23 8
6 C Santiago de Aller Santiago 10 12 21 8
TEMPORADA 2019/2020
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Llanera B Llanera B 22 84 33 53
2 Juventud Estadio Juventud 22 65 21 53
3 At. de Lugones B Lugones 22 66 27 50
4 La Corredoria Corredoria 22 64 27 48
5 Grujoan Grujoan 22 69 35 42
6 Santa Marina de Mieres Santa Marina 22 63 37 41
7 L'Entregu B L'Entregu B 22 54 31 41
8 Lenense Proinastur B Lenense 22 62 45 39
9 Rosal FC Rosal FC 22 59 40 38
10 C Santiago de Aller Santiago 22 54 40 30
11 Riosa Riosa 22 37 56 21
12 San Juan La Carisa Juan Carisa 22 29 74 19
13 Colegio Riaño CF Colegio 22 40 98 14
14 CD Turon B CD Turon B 22 44 77 13
15 Stiaua d'Asturies Stiaua 22 12 68 4
16 Grisu CF Grisu CF 22 20 113 4
TEMPORADA 2018/2019
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Europa de Nava Europa Nava 26 60 31 59
2 Independiente CF Independient 26 75 30 54
3 Club Siero B Club Siero 26 76 33 53
4 UD Sariego UD Sariego 26 67 24 52
5 CD San Jorge Jorge 26 71 38 51
6 Santa Marina de Mieres Santa Marina 26 64 68 41
7 Condal B Condal B 26 67 56 38
8 C Santiago de Aller Santiago 26 35 47 32
9 Atlético Siero Atlético 26 43 65 30
10 Canicas AC Canicas AC 26 42 62 23
11 Llanera B Llanera B 26 54 83 21
12 CF Berron B CF Berron B 26 29 68 21
13 Riosa Riosa 26 40 88 21
14 Lenense Proinastur B Lenense 26 34 64 19
TEMPORADA 2017/2018
TERCERA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 SCD Campomanes Campomanes 26 89 20 69
2 Deportiva Piloñesa Deportiva 26 101 22 63
3 Europa de Nava Europa Nava 26 49 29 55
4 Club Siero B Club Siero 26 65 45 46
5 UD Sariego UD Sariego 24 47 31 44
6 Quintueles CF Quintueles 25 49 34 38
7 Canicas AC Canicas AC 26 45 47 38
8 Iberia CF Iberia CF 26 50 44 36
9 CD San Jorge Jorge 26 40 40 31
10 C Santiago de Aller Santiago 24 34 35 29
11 Santa Marina de Mieres Santa Marina 25 38 58 20
12 Aguilar Balompie Aguilar 26 25 88 14
13 Atlético Siero Atlético 26 32 100 14
14 CF Berron B CF Berron B 26 27 98 11

  USO DE MEMORIA  
5,427,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5101
Total Execution Time  0.5113
  CADENA URL  
/historico/Cd-Santa-Marina-De-Mieres
  GET DATOS  
$_GET['/historico/Cd-Santa-Marina-De-Mieres']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0158  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-Santa-Marina-De-Mieres' 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.0146  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=103036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=103036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103036 AND type_rel = 2
0.0152  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 = '103036' ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '103036' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '103036' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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=103036 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (73670,71755) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73670 AND teamId = 103036
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71755 AND teamId = 103036
0.0154  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 = '103036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '103036' and rp.type = 4
0.0156  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 = '103036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0173  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 = 73670 WHERE rp.league_id = 73670 AND rp.teamId = 103036 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.0159  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 = 73670 WHERE rp.league_id = 73670 AND rp.teamId = 103036 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 73670 WHERE rp.league_id = 73670 AND rp.teamId = 103036 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 103036 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0295  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 = 73670 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.0151  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 = 68985 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.0158  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 = 63771 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.0158  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 = 62050 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.0165  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 = 51425 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.0165  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 = 45247 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 39811 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC