4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Sociedad - Deportivo Alavés
Jornada 6
FINALIZADO
10
41
2432 Pts. Elo
57%
2º

2065 Pts. Elo
43%
17º

3-0
Jueves, 26 Septiembre 2019, 21:00
  • Asistencia: 28.720 espectadores
M. Oyarzabal 19'
1 - 0
Willian José 32'
2 - 0
M. Oyarzabal 41'
3 - 0

Real Sociedad

4-5-1
Alineación Inicial
Suplentes

Deportivo Alavés

4-3-3
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
M. Oyarzabal
minuto 19'
Gol de
Willian José
minuto 32'
Gol de penalti
M. Oyarzabal
minuto 41'

Tarjetas

minuto 27'T. Amarilla M. Wakaso
minuto 49'T. Amarilla Tomás Pina
T. Amarilla
Portu
minuto 61'
minuto 74'T. Amarilla Manu García
minuto 85'2a Amarilla y Roja Manu García

Ocasiones

Penalti fallado
Portu
minuto 87'
minuto 87'Penalti parado F. Pacheco

Cambios

minuto 46'Entra en el partido Aleix Vidal
minuto 46'Sale del partido M. Wakaso
Entra en el partido
Alexander Isak
minuto 46'
Sale del partido
Willian José
minuto 46'
Entra en el partido
Adnan Januzaj
minuto 60'
Sale del partido
M. Oyarzabal
minuto 60'
minuto 60'Entra en el partido Manu García
minuto 60'Sale del partido Tomás Pina
minuto 75'Entra en el partido J. Guidetti
minuto 75'Sale del partido Borja Sainz
Entra en el partido
R. Le Normand
minuto 75'
Sale del partido
A. Gorosabel
minuto 75'

Otros

Asistencia
M. Ødegaard
minuto 19'
Asistencia
M. Oyarzabal
minuto 32'
minuto 39'Penalti cometido Adrián Marín
minuto 85'Penalti cometido Manu García

Estadísticas del partido

Real Sociedad Real Deportivo Alavés Deportivo
57%
Posesión del balón
 43%
3
Goles
 0
6
Tiros a puerta
 0
12
Tiros fuera
 4
18
Total tiros
 4
0
Paradas del portero
 3
5
Saques de esquina
 3
1
Fueras de juego
 2
1
Tarjetas Amarillas
 4
0
Tarjetas Rojas
 1
2
Asistencias
 0
3
Sustituciones
 3
7
Faltas
 18
0
Penalti cometido
 2
4 Comentarios
  • alavesitoj
    Hace 4 años alavesitoj dice: Me da la impresion que esta temporada la vamos a pasar canutas con este equipo con los jugadores que ha contratado este secretario tecnico que creo tiene poco acierto o ninguno viendo lo que nos trae todos los años ( Torres , Santos, Guideti , Lucas , Joselu y cia) que no jugaban en los equipos de procedencia y dejamos salir aotros que podian ser validos como Demiroovic, en fin creo nos tenemos que ir encomendando a la Virgen Blanca en espera de milagros
  • saulvc24
    Hace 4 años saulvc24 dice: Porra: Real Sociedad 2-1 Alavés
  • babazorro90
    Hace 4 años babazorro90 dice: Goazen Glorioso 1-1!!
  • susifutbolera
    Hace 4 años susifutbolera dice: 2-1

Partido televisado en...
Canal Medio Idioma País
Gol Play TV Castellano
DirecTV Sport TV Latino
Tigo Sports TV Latino
DIRECTV Sports TV Latino
DIRECTV Sports TV Latino
SKY Sports TV Latino
DIRECTV Sports TV -
DIRECTV Sports TV -

  USO DE MEMORIA  
7,352,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5108
Total Execution Time  0.5118
  CADENA URL  
/partido_49844/Real-Sociedad/Alaves/2020
  GET DATOS  
$_GET['/partido_49844/Real-Sociedad/Alaves/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0006   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '49844' AND c.`match_id` = '46361' AND c.comment_id IN (26887182,26885879,26875275,26856345) GROUP BY c.comment_id
0.0125  SELECT data1 FROM stats2020 t WHERE league_id = 49844 AND teamId = 6279972 and type = 33
0.0126  SELECT data1 FROM stats2020 t WHERE league_id = 49844 AND teamId = 6279962 and type = 33
0.0129  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '46361' and rp.type = 2020 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 46361 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0128  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 46361 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0132   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '26887182' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0137   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '26885879' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0136   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '26875275' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0131   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '26856345' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='46361' AND `active` = 1 AND year = 2020
0.0148  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='49844' AND relp.team_id=6279972 WHERE relp.in_squad=1 and mp.`match_id` = '46361' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0136  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='49844' AND relp.team_id=6279962 WHERE relp.in_squad=1 and mp.`match_id` = '46361' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46361 AND extraId = 49844 AND type_rel = 4
0.0134  SELECT /*115 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points,u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 46361 AND rel.extraId = 49844 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2019-07-28 21:00:00' AND n.creation_date<'2019-11-25 20:00:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 46361 AND league_id = 49844 AND year = 2020