4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CDJ Tamarite - Deportivo Aragón
Jornada 3
FINALIZADO
91
50
241 Pts. Elo
16º

469 Pts. Elo
11º

1-0
Domingo, 27 Diciembre 2020, 15:45
C. Bernadó 39'
1 - 0

Eventos del partido

Goles

C. BernadóGol de
C. Bernadó
minuto 39'

Tarjetas

C. BernadóT. Amarilla
C. Bernadó
minuto 35'
JordiT. Amarilla
Jordi
minuto 52'
minuto 56'Álvaro MartínT. Amarilla Álvaro Martín
minuto 62'Antonio SolaT. Amarilla Antonio Sola
GerardT. Amarilla
Gerard
minuto 64'
minuto 66'Arnau GaixasT. Amarilla Arnau Gaixas
E. TrotaT. Amarilla
E. Trota
minuto 66'
D. VarillaT. Amarilla
D. Varilla
minuto 66'
D. Varilla2a Amarilla y Roja
D. Varilla
minuto 80'
minuto 85'J. JimenezT. Amarilla J. Jimenez
David SalasT. Amarilla
David Salas
minuto 88'
AdriáT. Amarilla
Adriá
minuto 89'
minuto 89'Juan SebastiánT. Amarilla Juan Sebastián
CarruchasT. Amarilla
Carruchas
minuto 90'

Cambios

Éric ValesEntra en el partido
Éric Vales
minuto 46'
C. BernadóSale del partido
C. Bernadó
minuto 46'
minuto 60'Jaime SanchoSale del partido Jaime Sancho
minuto 60'Antonio SolaEntra en el partido Antonio Sola
minuto 60'Álvaro MartínSale del partido Álvaro Martín
minuto 60'J. JimenezEntra en el partido J. Jimenez
minuto 73'D. MarínSale del partido D. Marín
minuto 73'Miguel PucheEntra en el partido Miguel Puche
minuto 73'Álex VelaSale del partido Álex Vela
minuto 73'Andreu TorresEntra en el partido Andreu Torres
E. TrotaSale del partido
E. Trota
minuto 77'
Joel CasalsEntra en el partido
Joel Casals
minuto 77'
RickySale del partido
Ricky
minuto 81'
J. BerbegalEntra en el partido
J. Berbegal
minuto 81'
Alexis EspinosaEntra en el partido
Alexis Espinosa
minuto 89'
AdriáSale del partido
Adriá
minuto 89'

Alineaciones

CDJ Tamarite

CDJ Tamarite

4-4-2
Alineación Inicial
Suplentes
Deportivo Aragón

Deportivo Aragón

4-4-2
Alineación Inicial
Suplentes


Partido televisado en...
Canal Medio Idioma País
Aragón TVAragón TV TV Castellano es

  USO DE MEMORIA  
7,047,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3248
Total Execution Time  0.3258
  CADENA URL  
/partido/Tamarite/Real-Zaragoza-B/2021
  GET DATOS  
$_GET['/partido/Tamarite/Real-Zaragoza-B/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2021 t WHERE league_id = 58596 AND teamId = 6396681 and type = 33
0.0018  SELECT data1 FROM stats2021 t WHERE league_id = 58596 AND teamId = 6396682 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 = '123991' and rp.type = 2021 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 = 123991 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 123991 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='123991' AND `active` = 1 AND year = 2021
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='58596' AND relp.team_id=6396681 WHERE relp.in_squad=1 and mp.`match_id` = '123991' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0027  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='58596' AND relp.team_id=6396682 WHERE relp.in_squad=1 and mp.`match_id` = '123991' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=123991 AND extraId = 58596 AND type_rel = 4
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 123991 AND league_id = 58596 AND year = 2021