4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Recreativo - UCAM Murcia
Jornada 34
FINALIZADO
20
30
304 Pts. Elo
2º

381 Pts. Elo
5º

1-1
Domingo, 14 Mayo 2023, 12:00
0 - 1
 10' Manu Ramírez
Iago Díaz 72'
1 - 1

Recreativo

4-5-1
Alineación Inicial
Suplentes

UCAM Murcia

4-5-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

minuto 10'Gol de penalti Manu Ramírez
Gol de
Iago Díaz
minuto 72'

Tarjetas

minuto 35'T. Amarilla Javi Moreno
minuto 42'T. Amarilla Manu Ramírez
T. Amarilla
A. Trapero
minuto 46'
minuto 57'T. Amarilla Isra Cano
T. Amarilla
Rubén Serrano
minuto 60'

Ocasiones

Tiro al palo
Sergio Chinchilla
minuto 15'
minuto 18'Tiro al palo Isra Cano
minuto 28'Tiro al palo Javi Moreno

Cambios

Sale del partido
Josiel Núñez
minuto 23'
Entra en el partido
Israel Peter
minuto 23'
minuto 50'Sale del partido Yasser
minuto 50'Entra en el partido Mario Abenza
Sale del partido
P. Caballero
minuto 62'
Sale del partido
Salinas
minuto 62'
Entra en el partido
Dopi
minuto 62'
Entra en el partido
Iago Díaz
minuto 62'
minuto 66'Entra en el partido Chumbi
minuto 66'Entra en el partido Sala
minuto 66'Sale del partido Pito Camacho
minuto 66'Sale del partido Manu Ramírez
Sale del partido
Rubén Serrano
minuto 79'
Sale del partido
Fran Ávila
minuto 79'
Entra en el partido
Josema Gallego
minuto 79'
Entra en el partido
M. Mbaye
minuto 79'
minuto 84'Sale del partido Vicente Romero
minuto 84'Sale del partido Isra Cano
minuto 84'Entra en el partido R. Pescador
minuto 84'Entra en el partido Javi Ramírez

Otros

Lesionado
Josiel Núñez
minuto 22'
Penalti cometido
Rubén Serrano
minuto 9'
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
La 7 TV TV Castellano
Teleonuba TV Castellano

  USO DE MEMORIA  
6,972,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4831
Total Execution Time  0.4841
  CADENA URL  
/partido/Recreativo/Ucam-Murcia-C-F
  GET DATOS  
$_GET['/partido/Recreativo/Ucam-Murcia-C-F']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0177   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Recreativo' AND dt2.basealias = 'Ucam-Murcia-C-F'
0.0203   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Recreativo' AND dt2.basealias = 'Ucam-Murcia-C-F'
0.0149  SELECT data1 FROM stats2023 t WHERE league_id = 67968 AND teamId = 6519417 and type = 33
0.0146  SELECT data1 FROM stats2023 t WHERE league_id = 67968 AND teamId = 6519419 and type = 33
0.0158  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '269314' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0150  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 269314 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 269314 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0151  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='269314' AND `active` = 1 AND year = 2023
0.0187  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='67968' AND relp.team_id=6519417 WHERE relp.in_squad=1 and mp.`match_id` = '269314' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0366  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='67968' AND relp.team_id=6519419 WHERE relp.in_squad=1 and mp.`match_id` = '269314' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 269314 AND league_id = 67968 AND year = 2023