4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Racing de Pravia
TEMPORADA 2023/2024
TERCERA RFFPA GRUPO 4
Equipo PJ GF GC Puntos
1 Praviano B Praviano B 27 74 27 63
2 Astur Vegadense Astur 27 76 26 63
3 Boal CF Boal CF 27 73 30 59
4 Racing de Pravia Racing 27 76 44 58
5 Real Avilés B Real Avilés 28 69 40 56
6 Real Tapia CF Real Tapia 27 44 27 47
7 C. Hispano B Hispano 28 56 35 47
8 CD Pillarno CD Pillarno 27 41 45 41
9 La Caridad La Caridad 28 32 47 37
10 Marino de Cudillero Marino 28 42 50 30
11 Cornellana Cornellana 27 31 47 24
12 UD Castros UD Castros 28 32 59 21
13 Llaranes B Llaranes B 28 31 91 19
14 Puerto Vega B Puerto Vega 28 29 70 18
15 La Espina La Espina 27 15 83 9
TEMPORADA 2022/2023
TERCERA RFFPA GRUPO 4
Equipo PJ GF GC Puntos
1 Navia CF Navia CF 28 87 12 69
2 Barcia CF B Barcia CF B 28 82 38 63
3 Avilés Stadium CF B Avilés 28 71 33 63
4 Astur Vegadense Astur 28 73 28 60
5 Marino de Cudillero Marino 28 50 42 43
6 Racing de Pravia Racing 28 50 57 42
7 C. Hispano B Hispano 28 59 54 40
8 Puerto Vega B Puerto Vega 28 43 40 35
9 Boal CF Boal CF 28 30 57 35
10 Villa de Pravia Villa Pravia 28 39 40 34
11 UD Castros UD Castros 28 36 58 31
12 La Caridad La Caridad 28 41 57 27
13 Miranda C.F. Miranda C.F. 28 43 72 25
14 Rayo Villalegre Rayo 28 41 85 23
15 CD Pillarno CD Pillarno 28 27 99 9
TEMPORADA 2021/2022
SEGUNDA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Muros Balompié Muros 24 49 20 49
2 Llaranes CF Llaranes CF 24 27 9 49
3 Narcea Narcea 24 46 23 45
4 Puerto Vega FC Puerto Vega 24 47 28 42
5 CD Raices CD Raices 24 45 41 40
6 Llanera B Llanera B 24 46 37 38
7 CD Treviense Treviense 24 34 33 36
8 Club Hispano Club Hispano 24 46 42 35
9 Marino de Cudillero Marino 24 34 53 28
10 Navia CF Navia CF 24 33 47 25
11 GD Bosco GD Bosco 24 26 41 21
12 Astur Vegadense Astur 24 23 45 17
13 Racing de Pravia Racing 24 22 59 10
TEMPORADA 2020/2021
TERCERA RFFPA GRUPO 5
Equipo PJ GF GC Puntos
1 CD Raices CD Raices 8 40 8 21
2 Racing de Pravia Racing 8 20 14 21
3 Miranda C.F. Miranda C.F. 8 10 17 12
4 Rayo Villalegre Rayo 8 10 22 4
5 Versalles CF Versalles 8 8 27 1
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
TERCERA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Covadonga B Covadonga B 28 105 27 67
2 Marino de Cudillero Marino 28 70 13 67
3 Juventud Estadio Juventud 28 60 26 58
4 Rosal FC Rosal FC 28 70 42 58
5 Grujoan Grujoan 28 81 34 56
6 Boal CF Boal CF 28 67 22 56
7 La Corredoria Corredoria 28 68 50 52
8 Racing de Pravia Racing 28 50 35 46
9 Navia CF Navia CF 28 53 61 35
10 Soto del Barco Soto Barco 28 62 69 30
11 Stiaua d'Asturies Stiaua 28 31 69 26
12 San Esteban de Pravia Esteban 28 21 103 16
13 Minas Oviedo Minas Oviedo 28 44 87 14
14 San Juan La Carisa Juan Carisa 28 32 85 11
15 Grisu CF Grisu CF 28 30 121 6

  USO DE MEMORIA  
5,179,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.4443
Total Execution Time  0.4459
  CADENA URL  
/historico/Racing-De-Pravia-Senior
  GET DATOS  
$_GET['/historico/Racing-De-Pravia-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0153  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 = 'Racing-De-Pravia-Senior' 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.0145  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=112882 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=112882 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=112882 AND type_rel = 2
0.0147  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 = '112882' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '112882' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '112882' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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=112882 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73717) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73717 AND teamId = 112882
0.0147  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 = '112882' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '112882' and rp.type = 4
0.0147  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 = '112882' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 73717 WHERE rp.league_id = 73717 AND rp.teamId = 112882 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.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 = 73717 WHERE rp.league_id = 73717 AND rp.teamId = 112882 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73717 WHERE rp.league_id = 73717 AND rp.teamId = 112882 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 112882 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 73717 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.0149  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 = 68987 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.0148  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 = 63767 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.0147  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 = 62049 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.0149  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.0149  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 = 45246 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC