4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Oviedo - Osasuna
Jornada 15
FINALIZADO
00
00
1505 Pts. Elo
1º

683 Pts. Elo
8º

7-1
Domingo, 05 Marzo 1933, 00:00
Casuco 2'
1 - 0
1 - 1
 20' Iturralde
Lángara 30'
2 - 1
Lángara 40'
3 - 1
Mugarra 50'
4 - 1
Lángara 60'
5 - 1
Casuco 70'
6 - 1
Inciarte 80'
7 - 1

Eventos del partido

Goles

CasucoGol de
Casuco
minuto 2'
minuto 20'IturraldeGol de Iturralde
LángaraGol de penalti
Lángara
minuto 30'
LángaraGol de
Lángara
minuto 40'
MugarraGol de
Mugarra
minuto 50'
LángaraGol de
Lángara
minuto 60'
CasucoGol de
Casuco
minuto 70'
InciarteGol de
Inciarte
minuto 80'

Alineaciones

Real Oviedo

Real Oviedo

4-4-2
Alineación Inicial
Osasuna

Osasuna

4-4-2
Alineación Inicial



  USO DE MEMORIA  
5,616,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1029
Total Execution Time  0.1038
  CADENA URL  
/partido/Real-Oviedo/Osasuna/1933
  GET DATOS  
$_GET['/partido/Real-Oviedo/Osasuna/1933']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0078  SELECT data1 FROM stats1933 t WHERE league_id = 10383 AND teamId = 159337 and type = 33
0.0018  SELECT data1 FROM stats1933 t WHERE league_id = 10383 AND teamId = 159343 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '930' and rp.type = 1933 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 = 930 AND year = 1933 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 930 AND year = 1933 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='930' AND `active` = 1 AND year = 1933
0.0119  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='10383' AND relp.team_id=159337 WHERE relp.in_squad=1 and mp.`match_id` = '930' AND mp.year='1933' ORDER BY mp.`team` ASC, p.`role` ASC
0.0133  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='10383' AND relp.team_id=159343 WHERE relp.in_squad=1 and mp.`match_id` = '930' AND mp.year='1933' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=930 AND extraId = 10383 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 930 AND league_id = 10383 AND year = 1933