4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Coruxo - Deportivo Fabril
Jornada 32
FINALIZADO
30
30
328 Pts. Elo
8º

233 Pts. Elo
11º

1-2
Sábado, 20 Abril 2024, 17:00
M. García 28'
1 - 0
1 - 1
 92' Álex Alfaro
1 - 2
 95' Mati Castillo
Coruxo

Coruxo

4-5-1
Alineación Inicial
Suplentes
Deportivo Fabril

Deportivo Fabril

4-5-1
Alineación Inicial
Suplentes
Coruxo
Deportivo Fabril
T. Amarilla
Gol
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
T. Amarilla
Sale del partido
Sale del partido
Entra en el partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
T. Amarilla
Entra en el partido
T. Amarilla
T. Amarilla
Gol
T. Amarilla
Gol

Eventos del partido

Goles

M. GarcíaGol de
M. García
minuto 28'
minuto 92'Álex AlfaroGol de Álex Alfaro
minuto 95'Mati CastilloGol de Mati Castillo

Tarjetas

minuto 21'Ángel PuertoT. Amarilla Ángel Puerto
B. MarchanteT. Amarilla
B. Marchante
minuto 65'
minuto 88'Jorge MartínezT. Amarilla Jorge Martínez
D. VidalT. Amarilla
D. Vidal
minuto 90'
minuto 90'Mati CastilloT. Amarilla Mati Castillo
Pitu DoncelT. Amarilla
Pitu Doncel
minuto 94'

Cambios

minuto 60'Mario NájeraSale del partido Mario Nájera
minuto 60'Mati CastilloEntra en el partido Mati Castillo
minuto 60'Ángel PuertoSale del partido Ángel Puerto
minuto 60'A. GuerreroEntra en el partido A. Guerrero
Pietro TomaselliEntra en el partido
Pietro Tomaselli
minuto 65'
Mateo MíguezSale del partido
Mateo Míguez
minuto 65'
minuto 74'A. PereiraSale del partido A. Pereira
minuto 74'Kevin SánchezSale del partido Kevin Sánchez
minuto 74'Jorge MartínezEntra en el partido Jorge Martínez
minuto 74'Á. MardonesEntra en el partido Á. Mardones
NaveiraEntra en el partido
Naveira
minuto 75'
M. GarcíaSale del partido
M. García
minuto 75'
minuto 86'Jairo NoriegaSale del partido Jairo Noriega
minuto 86'Thymos CaroutasEntra en el partido Thymos Caroutas
VanderEntra en el partido
Vander
minuto 88'
Alex ReySale del partido
Alex Rey
minuto 88'
DavoSale del partido
Davo
minuto 88'
AndriuEntra en el partido
Andriu
minuto 88'
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
TVG2 TV Castellano

  USO DE MEMORIA  
7,141,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2722
Total Execution Time  0.2732
  CADENA URL  
/partido/Coruxo/Deportivo-B
  GET DATOS  
$_GET['/partido/Coruxo/Deportivo-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0057   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 = 'Coruxo' AND dt2.basealias = 'Deportivo-B'
0.0025  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 = 'Coruxo' AND dt2.basealias = 'Deportivo-B'
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72362 AND teamId = 6587599 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72362 AND teamId = 6587604 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 = '196850' 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 = 196850 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 196850 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='196850' AND `active` = 1 AND year = 2024
0.0098  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='72362' AND relp.team_id=6587599 WHERE relp.in_squad=1 and mp.`match_id` = '196850' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0075  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='72362' AND relp.team_id=6587604 WHERE relp.in_squad=1 and mp.`match_id` = '196850' 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=196850 AND extraId = 72362 AND type_rel = 4
0.0018  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 = 196850 AND league_id = 72362 AND year = 2024