4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Racing Ciudad de Madrid - Campamento
Jornada 14
FINALIZADO
81
50
38 Pts. Elo
8º

18 Pts. Elo
11º

0-0
Domingo, 17 Diciembre 2023, 16:48

Racing Ciudad de Madrid

4-4-2
Alineación Inicial
Suplentes

Campamento

4-4-2
Alineación Inicial
Suplentes
Racing Ciudad de Madrid
Campamento
T. Amarilla
T. Amarilla
T. Amarilla
2a Amarilla y Roja
T. Amarilla
T. Amarilla
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
T. Amarilla
T. Amarilla
T. Amarilla
Sale del partido
Entra en el partido
T. Amarilla
T. Amarilla
T. Amarilla
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido

Eventos del partido

Tarjetas

T. Amarilla
Alejandro
minuto 21'
T. Amarilla
A. Martínez
minuto 33'
minuto 34'T. Amarilla F. De La Cruz
2a Amarilla y Roja
Alejandro
minuto 51'
T. Amarilla
A. Diaz
minuto 54'
T. Amarilla
Provencio
minuto 55'
T. Amarilla
Esteban Pacheco
minuto 56'
minuto 76'T. Amarilla O. Santana
minuto 76'T. Amarilla M. Gonzalez
T. Amarilla
Rodajo
minuto 78'
minuto 85'T. Amarilla P. Batista
minuto 86'T. Amarilla Javier Olías
T. Amarilla
J. Fernandez
minuto 89'

Cambios

Entra en el partido
M. El Idrissi
minuto 57'
Sale del partido
A. Diaz
minuto 57'
minuto 61'Entra en el partido S. Fernández
minuto 61'Sale del partido F. De La Cruz
minuto 70'Entra en el partido D. Velasco
minuto 70'Entra en el partido L. Sevilla
minuto 70'Sale del partido F. Cevallos
minuto 70'Sale del partido Luismi
Sale del partido
Esteban Pacheco
minuto 79'
Entra en el partido
J. Fernandez
minuto 79'
Entra en el partido
Jorge Sánchez
minuto 90'
Sale del partido
Provencio
minuto 90'
Sale del partido
A. Martínez
minuto 90'
Entra en el partido
G. Culqui
minuto 90'
Sale del partido
Koke
minuto 90'
Entra en el partido
A. Carballar
minuto 90'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
7,036,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4279
Total Execution Time  0.4289
  CADENA URL  
/partido/Racing-Madrid-City-Fc/Campamento/2024
  GET DATOS  
$_GET['/partido/Racing-Madrid-City-Fc/Campamento/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73541 AND teamId = 6603993 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 73541 AND teamId = 6603987 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '495227' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 495227 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 495227 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0030  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 = 73541 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.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='495227' AND `active` = 1 AND year = 2024
0.0031  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='73541' AND relp.team_id=6603993 WHERE relp.in_squad=1 and mp.`match_id` = '495227' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0031  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='73541' AND relp.team_id=6603987 WHERE relp.in_squad=1 and mp.`match_id` = '495227' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=495227 AND extraId = 73541 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=495227 AND league_id=73541 AND year=2024
0.0018  SELECT avg_rating FROM elo_teams WHERE id=18765
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 495227 AND league_id = 73541 AND year = 2024