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

Racing Murcia

Entrenador: Víctor Guirao

Temporada 2021/2022
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Yeclano Deportivo Yeclano 34 71 21 80
2 FC Cartagena B Cartagena 34 61 32 60
3 Racing Murcia Racing 34 48 27 57
4 UCAM Murcia B UCAM Murcia 34 49 34 54
5 FC La Unión Atl. Unión Atl. 34 44 31 54
6 Lorca Deportiva Lorca 34 52 42 53
7 Real Murcia Imperial Real Murcia 34 49 46 51
8 Caravaca Caravaca 34 44 40 50
9 CAP Ciudad de Murcia Ciudad 34 47 45 47
10 CD Bullense CD Bullense 34 34 50 43
11 El Palmar El Palmar 34 41 44 43
12 Archena Sport Archena 34 48 49 43
13 Deportiva Minera Deportiva 34 39 51 42
14 Bala Azul Bala Azul 34 30 45 40
15 Cartagena F.C. UCAM Cartagena 34 35 49 38
16 Mazarrón FC Mazarrón 34 33 48 37
17 Huércal-Overa Huércal-Ove 34 26 54 25
18 UD Los Garres Garres 34 23 66 20
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Real Murcia Imperial Real Murcia 20 36 14 44
2 Águilas FC Águilas FC 20 43 8 44
3 At. Pulpileño Pulpileño 20 30 11 43
4 UD Los Garres Garres 20 22 21 27
5 CD Bullense CD Bullense 20 23 25 27
6 UCAM Murcia B UCAM Murcia 20 28 23 26
7 Olímpico de Totana Olímpico 20 17 23 23
8 El Palmar El Palmar 20 26 28 22
9 Minerva Minerva 20 24 36 20
10 EDMF Churra EDMF Churra 20 17 36 16
11 Plus Ultra Plus Ultra 20 11 52 9
12 Racing Cartagena Mar Menor Racing 20 27 12 43
13 FC Cartagena B Cartagena 20 38 10 40
14 Racing Murcia Racing 20 25 9 37
15 FC La Unión Atl. Unión Atl. 20 33 19 36
16 Cartagena F.C. UCAM Cartagena 20 30 27 32
17 Mazarrón FC Mazarrón 20 21 19 26
18 Deportiva Minera Deportiva 20 18 20 24
19 Huércal-Overa Huércal-Ove 20 17 27 22
20 CAP Ciudad de Murcia Ciudad 20 13 18 21
21 Muleño CF Muleño CF 20 18 31 16
22 Lorca FC Lorca FC 20 9 57 4
TEMPORADA 2019/2020
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Racing Murcia Racing 27 76 23 67
2 CD Bullense CD Bullense 27 43 17 62
3 Abarán CF Abarán CF 27 56 31 57
4 FC La Unión Atl. Unión Atl. 27 62 34 45
5 CD Algar CD Algar 27 45 41 41
6 Mar Menor B Mar Menor B 27 44 38 37
7 Archena Sport Archena 27 41 41 36
8 Balsicas Atlético Balsicas 27 44 48 36
9 Villa de Fortuna Villa 27 45 50 36
10 Bala Azul Bala Azul 27 41 49 36
11 Cieza Cieza 27 34 40 32
12 EF Alhama EF Alhama 27 34 49 31
13 CD Beniel CD Beniel 27 42 50 29
14 Unión Molinense Unión 27 38 46 28
15 Ciudad de Calasparra Ciudad 27 39 54 28
16 Atletico Cabezo de Torres Atletico 27 28 55 28
17 CD El Esparragal Esparragal 27 36 61 25
18 Caravaca Caravaca 27 26 47 24
TEMPORADA 2018/2019
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 El Palmar El Palmar 34 63 29 78
2 Cartagena F.C. UCAM Cartagena 34 74 27 74
3 Abarán CF Abarán CF 34 89 37 69
4 Racing Murcia Racing 34 67 43 60
5 Plus Ultra Plus Ultra 34 53 34 59
6 Atletico Cabezo de Torres Atletico 34 58 40 57
7 Bala Azul Bala Azul 34 55 47 50
8 EF Alhama EF Alhama 34 42 46 48
9 Mar Menor B Mar Menor B 34 48 51 45
10 CD Bullense CD Bullense 34 45 50 43
11 CD Beniel CD Beniel 34 49 56 42
12 CD El Esparragal Esparragal 34 50 64 41
13 Villa de Fortuna Villa 34 59 76 38
14 Jumilla CD Jumilla CD 34 50 67 36
15 Balsicas Atlético Balsicas 34 45 62 33
16 Juvenia Juvenia 34 43 66 32
17 Montecasillas Montecasilla 34 49 78 32
18 Ind. De Ceutí Ind. Ceutí 34 30 96 13
TEMPORADA 2017/2018
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 CAP Ciudad de Murcia Ciudad 34 63 29 73
2 Olímpico de Totana Olímpico 34 52 31 68
3 CD Algar CD Algar 34 57 35 64
4 Mazarrón FC Mazarrón 34 70 45 60
5 Abarán CF Abarán CF 34 62 39 59
6 Plus Ultra Plus Ultra 34 44 30 58
7 EF Alhama EF Alhama 34 60 42 54
8 CD El Esparragal Esparragal 34 52 46 48
9 Unión Molinense Unión 34 44 50 45
10 CD Bullense CD Bullense 34 44 50 44
11 Balsicas Atlético Balsicas 34 51 57 40
12 Juvenia Juvenia 34 35 40 39
13 Cartagena F.C. UCAM Cartagena 34 37 61 35
14 Jumilla CD Jumilla CD 34 42 67 35
15 Racing Murcia Racing 34 46 59 32
16 Alquerias Alquerias 34 45 72 32
17 Abanilla Abanilla 34 49 74 30
18 Alcantarilla FC Alcantarilla 34 41 67 30
TEMPORADA 2016/2017
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Minerva Minerva 34 77 34 76
2 Bala Azul Bala Azul 34 78 46 71
3 FC Cartagena B Cartagena 34 86 46 62
4 Mazarrón FC Mazarrón 34 52 28 61
5 UD Los Garres Garres 34 45 25 61
6 Unión Molinense Unión 34 65 42 57
7 Alquerias Alquerias 34 61 41 56
8 Balsicas Atlético Balsicas 34 49 49 51
9 Alcantarilla FC Alcantarilla 34 39 32 47
10 Cartagena F.C. UCAM Cartagena 34 53 48 46
11 Jumilla CD Jumilla CD 34 49 56 43
12 Abanilla Abanilla 34 51 69 42
13 Racing Murcia Racing 34 60 73 36
14 CD El Esparragal Esparragal 34 46 60 34
15 Plus Ultra Plus Ultra 34 38 67 33
16 Caravaca Caravaca 34 41 68 32
17 Montecasillas Montecasilla 34 30 68 21
18 CD Lumbreras Lumbreras 34 25 93 14

  USO DE MEMORIA  
5,923,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6480
Total Execution Time  0.6492
  CADENA URL  
/historico/Real-Murcia-City-Senior/2022
  GET DATOS  
$_GET['/historico/Real-Murcia-City-Senior/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0159  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 = 'Real-Murcia-City-Senior' AND l.year = 2022 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=90395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=90395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=90395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=90395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296  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 = 67509
0.0150  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 = 62397
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90395 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 90395 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (693668,701727,719860,863991,870597) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '90395' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '90395' 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,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 = 67509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 62397 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=90395 AND l.year in (2021,2022,2023) 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 (71489,67987,62807,62373,61780,59872,58592) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 67987 AND teamId = 90395
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 58592 AND teamId = 90395
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 59872 AND teamId = 90395
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 90395
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 62373 AND teamId = 90395
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 61780 AND teamId = 90395
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 90395
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 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 = 67509 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '90395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90395' and rp.type = 4
0.0146  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 = '90395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 events2022 e ON e.player_id = p.id AND e.league_id = 67509 WHERE rp.league_id = 67509 AND rp.teamId = 90395 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.0155  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 events2022 e ON e.player_id = p.id AND e.league_id = 67509 WHERE rp.league_id = 67509 AND rp.teamId = 90395 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 events2022 e ON e.player_id = p.id AND e.league_id = 67509 WHERE rp.league_id = 67509 AND rp.teamId = 90395 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 90395 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 62397 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.0169  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 = 58592 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.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 `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 = 51172 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 45113 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC