4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sevilla At. - CD Manchego Ciudad Real
Jornada 8
FINALIZADO
10
40
365 Pts. Elo
2º

205 Pts. Elo
16º

3-0
Domingo, 22 Octubre 2023, 11:30
C. Jiménez 32'
1 - 0
Isaac Romero 43'
2 - 0
Antonio Zarzana 59'
3 - 0

Eventos del partido

Goles

C. Jiménez Gol de (p.p)
C. Jiménez
minuto32'
Isaac RomeroGol de
Isaac Romero
minuto 43'
Antonio ZarzanaGol de
Antonio Zarzana
minuto 59'

Tarjetas

minuto 23'Juan DuránT. Amarilla Juan Durán
minuto 40'S. CasaisT. Amarilla S. Casais
Antonio ZarzanaT. Amarilla
Antonio Zarzana
minuto 40'
minuto 53'AleT. Amarilla Ale
minuto 74'João DiasT. Amarilla João Dias

Cambios

minuto 46'M. Van RooijenSale del partido M. Van Rooijen
minuto 46'S. CasaisSale del partido S. Casais
minuto 46'I. BaraceEntra en el partido I. Barace
minuto 46'Eduard CalinEntra en el partido Eduard Calin
minuto 62'Nacho RuizSale del partido Nacho Ruiz
minuto 62'Rodrigo GuiEntra en el partido Rodrigo Gui
Musa DrammehSale del partido
Musa Drammeh
minuto 62'
Isra DomínguezEntra en el partido
Isra Domínguez
minuto 62'
minuto 62'Álex CastroEntra en el partido Álex Castro
minuto 62'AleSale del partido Ale
Ibra SowEntra en el partido
Ibra Sow
minuto 73'
minuto 73'T. RossiEntra en el partido T. Rossi
Manu BuenoSale del partido
Manu Bueno
minuto 73'
João DanielEntra en el partido
João Daniel
minuto 73'
minuto 73'Fran RiveraSale del partido Fran Rivera
Antonio ZarzanaSale del partido
Antonio Zarzana
minuto 73'
Sergio MartínezEntra en el partido
Sergio Martínez
minuto 82'
Ramón MartínezSale del partido
Ramón Martínez
minuto 82'
Isaac RomeroSale del partido
Isaac Romero
minuto 82'
D. SantistebanEntra en el partido
D. Santisteban
minuto 82'

Otros

Musa DrammehAsistencia
Musa Drammeh
minuto 43'
Miguel CapiAsistencia
Miguel Capi
minuto 59'

Alineaciones

Sevilla At.

Sevilla At.

4-5-1
Alineación Inicial
Suplentes
CD Manchego Ciudad Real

CD Manchego Ciudad Real

4-4-2
Alineación Inicial
Suplentes


Partido televisado en...
Canal Medio Idioma País
SFC TVSFC TV TV Castellano es
SevillaFC YouTubeSevillaFC YouTube TV Castellano es
RFAF TVRFAF TV TV Castellano es

  USO DE MEMORIA  
7,008,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3592
Total Execution Time  0.3602
  CADENA URL  
/partido/Sevilla-B/Cd-Ciudad-Real
  GET DATOS  
$_GET['/partido/Sevilla-B/Cd-Ciudad-Real']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0074   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 = 'Sevilla-B' AND dt2.basealias = 'Cd-Ciudad-Real'
0.0032  SELECT c.*, 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, dt1.id 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 datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Sevilla-B' AND dt2.basealias = 'Cd-Ciudad-Real'
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72365 AND teamId = 6587688 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72365 AND teamId = 6587677 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '197508' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197508 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197508 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0030  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72365 AND c.`round` = 8 ORDER BY shedule ASC LIMIT 12
0.0029  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 = 72365 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 72365 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.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197508' AND `active` = 1 AND year = 2024
0.0070  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='72365' AND relp.team_id=6587688 WHERE relp.in_squad=1 and mp.`match_id` = '197508' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0056  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='72365' AND relp.team_id=6587677 WHERE relp.in_squad=1 and mp.`match_id` = '197508' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197508 AND extraId = 72365 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 197508 AND league_id = 72365 AND year = 2024