4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD San José - Numancia B
Jornada 20
FINALIZADO
30
20
269 Pts. Elo
18º

299 Pts. Elo
6º

0-1
Miércoles, 14 Marzo 2018, 17:00
0 - 1
 15' Frodo

Eventos del partido

Goles

minuto 15'FrodoGol de Frodo

Tarjetas

ChuspiT. Amarilla
Chuspi
minuto 18'
minuto 42'CotaT. Amarilla Cota
PachecoT. Amarilla
Pacheco
minuto 51'
AltelarreaT. Amarilla
Altelarrea
minuto 77'
minuto 85'Ander VidorretaT. Amarilla Ander Vidorreta

Cambios

A. GonzalezEntra en el partido
A. Gonzalez
minuto 56'
JonathanSale del partido
Jonathan
minuto 56'
VitiEntra en el partido
Viti
minuto 56'
BorjaSale del partido
Borja
minuto 56'
minuto 60'AlbitreEntra en el partido Albitre
minuto 60'ÁlvaroSale del partido Álvaro
minuto 67'R. VallejoSale del partido R. Vallejo
minuto 67'CristianEntra en el partido Cristian
minuto 85'BeliSale del partido Beli
minuto 85'I. AranaEntra en el partido I. Arana
R. MunillaEntra en el partido
R. Munilla
minuto 87'
PachecoSale del partido
Pacheco
minuto 87'

Alineaciones

CD San José

CD San José

4-4-2
Alineación Inicial
Suplentes
Numancia B

Numancia B

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,017,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4133
Total Execution Time  0.4142
  CADENA URL  
/partido/San-Jose-Soria/Numancia-B/2018
  GET DATOS  
$_GET['/partido/San-Jose-Soria/Numancia-B/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0126  SELECT data1 FROM stats2018 t WHERE league_id = 39032 AND teamId = 792070 and type = 33
0.0125  SELECT data1 FROM stats2018 t WHERE league_id = 39032 AND teamId = 792075 and type = 33
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '520486' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 520486 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 520486 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0254  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 `tables2018` 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 = 39032 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='520486' AND `active` = 1 AND year = 2018
0.0150  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='39032' AND relp.team_id=792070 WHERE relp.in_squad=1 and mp.`match_id` = '520486' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0173  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='39032' AND relp.team_id=792075 WHERE relp.in_squad=1 and mp.`match_id` = '520486' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=520486 AND extraId = 39032 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 520486 AND league_id = 39032 AND year = 2018