Partido Sevilla Sub 19 - Spartak Moskva Sub 19

Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Sevilla Sub 19 - Spartak Moskva Sub 19 Sevilla Sub 19 - Spartak Moskva Sub 19

Jornada 4

FINALIZADO

1252 Pts. Elo

3º

Sevilla Sub 19

688 Pts. Elo

2º

Spartak Moskva Sub 19

3-3

Miércoles, 01 Noviembre 2017, 14:00

		0 - 1	17'	M. Ignatov
Pepe Calderón	41'	1 - 1
A. Viedma	45'	2 - 1
Charaf	53'	3 - 1
		3 - 2	55'	Aleksandr Rudenko
		3 - 3	90'	I. Mazurov

Eventos del partido

Goles

minuto 17'

Gol de M. Ignatov

Gol de

Pepe Calderón

minuto 41'

Gol de

A. Viedma

minuto 45'

Gol de

Charaf

minuto 53'

minuto 55'

Gol de Aleksandr Rudenko

minuto 90'

Gol de I. Mazurov

Tarjetas

minuto 27'

T. Amarilla A. Voropaev

minuto 57'

T. Amarilla Aleksandr Rudenko

minuto 76'

T. Amarilla M. Ignatov

T. Amarilla

Charaf

minuto 86'

minuto 90'

T. Amarilla A. Maksimenko

T. Amarilla

A. Viedma

minuto 90'

T. Amarilla Petr Volodkin

minuto 90'

T. Amarilla D. Markitesov

Cambios

minuto 54'

Sale del partido K. Orekhov

minuto 54'

Entra en el partido I. Mazurov

Entra en el partido

J. Delgado

minuto 67'

Sale del partido

Pepe Calderón

minuto 67'

Entra en el partido

M. Espinar

minuto 70'

Sale del partido

Kike Ríos

minuto 70'

minuto 82'

Entra en el partido D. Markitesov

minuto 82'

Sale del partido A. Voropaev

Entra en el partido

F. Nuñez

minuto 83'

Sale del partido

José Lara

minuto 83'

minuto 90'

Sale del partido Petr Volodkin

minuto 90'

Entra en el partido Denis Patsev

Otros

minuto 17'

Asistencia N. Rasskazov

Asistencia

Simo

minuto 45'

Asistencia

Pepe Calderón

minuto 53'

minuto 55'

Asistencia D. Proshlyakov

minuto 90'

Asistencia S. Bakaev

Alineaciones

Sevilla Sub 19

4-3-3

Alineación Inicial

13

Alfonso Pastor
5
70'

Kike Ríos
3

Javi Vázquez
2

V. Fattore
6

Genaro
15

Espinar
14

Charaf
12

A. Viedma
7
67'

Pepe Calderón
16

Simo
7
83'

José Lara

Suplentes

1

Jonatan Morilla
18
70'

M. Espinar
3

M Candela
4

F. Carmona
18
83'

F. Nuñez
2
67'

J. Delgado
8

Alvarito

Spartak Moskva Sub 19

4-3-3

Alineación Inicial

98

A. Maksimenko
96

M. Aktisov
26

L. Mironov
36
82'

A. Voropaev
92

N. Rasskazov
43
90'

Petr Volodkin
75

M. Ignatov
80
54'

K. Orekhov
79

Aleksandr Rudenko
87

S. Bakaev
61

D. Proshlyakov

Suplentes

85

Vlad Eleferenko
59

A. Zepatta
53

Artem Gorbulin
42
90'

Denis Patsev
89

D. Mitroga
74
82'

D. Markitesov
82
54'

I. Mazurov

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2068

Sevilla		Spartak

Partido televisado en...

Canal	Medio	Idioma	País
beIN Sports	TV	Castellano

NOTICIAS RELACIONADAS

Ver otras noticias destacadas »

Otros partidos

Liverpool Sub 19 3-0 Maribor Sub 19 6

Clasificación | Jornada 4

LIGAS RELACIONADAS

USO DE MEMORIA

5,920,152 bytes

BENCHMARKS

Loading Time Base Classes	0.0009
Controller Execution Time ( Match / Index )	0.2073
Total Execution Time	0.2083

CADENA URL

/partido/Sevilla-Fc-Juvenil/Spartak-Moskva-Sub19/2018

GET DATOS

$_GET['/partido/Sevilla-Fc-Juvenil/Spartak-Moskva-Sub19/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0059	SELECT c., c.stadium as real_stadium, 2018 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* calendars2018 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 = 'Sevilla-Fc-Juvenil' AND dt2.basealias = 'Spartak-Moskva-Sub19'
0.0023	SELECT c., 2018 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* calendars2018 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 = 'Sevilla-Fc-Juvenil' AND dt2.basealias = 'Spartak-Moskva-Sub19'
0.0044	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 39655
0.0019	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2018 AS ev WHERE ev.match_id=574977 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0031	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=39655 WHERE dp.id IN (342638,343150,341550,341534,319378,389432,397923,290159,319373,434554,403004,428362,428416,342298,285683,343148,715727,290160,463389,403840,428202) AND (rp.team_id=817553 OR rp.team_id=817554)
0.0018	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2018 AS ev WHERE ev.match_id=574977 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0026	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=39655 WHERE dp.id IN (290160,342638,397923,343150,341550,463389,341534,403004,389432,319378,403840,428362,428416,342298,434554,285683,343148,290159,428202,319373,715727) AND (rp.team_id=817553 OR rp.team_id=817554)
0.0017	SELECT data1 FROM stats2018 t WHERE league_id = 39655 AND teamId = 817553 and type = 33
0.0018	SELECT data1 FROM stats2018 t WHERE league_id = 39655 AND teamId = 817554 and type = 33
0.0019	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 39655 AND id_match = 574977
0.0024	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='39655' AND relp.team_id = drea.team_id WHERE rel.team_number=675482 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0025	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='39655' AND relp.team_id = drea.team_id WHERE rel.team_number=675483 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0064	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='39655' AND relp.team_id=817553 WHERE mp.`match_id` = '574977' AND mp.year='2018' AND p.id NOT IN (364666,342298,341547,433846,290473,341536,341534,341550,343150,463389,343148,290159,428203,325048,397923,290160,319373,342638,403004,319378,428202,403840) ORDER BY mp.`team` ASC, p.`role` ASC
0.0060	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='39655' AND relp.team_id=817554 WHERE mp.`match_id` = '574977' AND mp.year='2018' AND p.id NOT IN (364666,342298,341547,433846,290473,341536,341534,341550,343150,463389,343148,290159,428203,325048,397923,290160,319373,342638,403004,319378,428202,403840) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019	SELECT kit FROM kit_data_real WHERE league_id = 39655 AND id_match = 574977
0.0019	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '574977' and rp.type = 2018 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '574977' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 39655 AND rel.team1 = 817553 AND rel.team2 = 817554 ORDER BY FIELD(m.location,'es','en') DESC
0.0018	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 574977 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0018	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 574977 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0022	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 39655 AND rel.team1 = 817553 AND rel.team2 = 817554 ORDER BY FIELD(m.location,'es','en') DESC
0.0020	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 39655 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018	SELECT teamId FROM teams WHERE id = 817553
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2018 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2018 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 4883 OR c.datateam2 = 4883) ORDER BY shedule DESC LIMIT 10
0.0017	SELECT teamId FROM teams WHERE id = 817554
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2018 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2018 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 66236 OR c.datateam2 = 66236) ORDER BY shedule DESC LIMIT 10
0.0020	SELECT teamId FROM teams WHERE id = 817553
0.0020	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2018 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2018 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 4883 OR c.datateam2 = 4883) ORDER BY shedule ASC LIMIT 10
0.0018	SELECT teamId FROM teams WHERE id = 817554
0.0020	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2018 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2018 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 66236 OR c.datateam2 = 66236) ORDER BY shedule ASC LIMIT 10
0.0020	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2018` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 39655 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 12
0.0018	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 = 39655 AND t.round = 4 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2018` WHERE league_id = 39655 AND round >= 6 AND round <= 6 AND team = 817553 ORDER BY round ASC
0.0085	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 = 39655 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0080	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2018 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2018 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2018 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 817553 AND c.team2 = 817554 AND c.league_id = 39655
0.0018	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='574977' AND `active` = 1 AND year = 2018
0.0018	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='574977' AND `active` = 1 AND year = 2018
0.0019	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='39655' AND relp.team_id=817553 WHERE relp.in_squad=1 and mp.`match_id` = '574977' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018	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='39655' AND relp.team_id=817554 WHERE relp.in_squad=1 and mp.`match_id` = '574977' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '39655' AND id_match = '574977'
0.0018	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '675482' ORDER BY rating DESC LIMIT 1
0.0026	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '675483' ORDER BY rating DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=574977 AND extraId = 39655 AND type_rel = 4
0.0019	SELECT year FROM leagues WHERE id=39655
0.0018	SELECT shedule FROM calendars2018 WHERE id=574977
0.0018	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 = 574977 AND rel.extraId = 39655 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2017-09-02 15:00:00' AND n.creation_date<'2017-12-31 14:00:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0017	SELECT rating1, rating2 FROM calendars_elo WHERE id=574977 AND league_id=39655 AND year=2018
0.0018	SELECT avg_rating FROM elo_teams WHERE id=4883
0.0018	SELECT avg_rating FROM elo_teams WHERE id=66236
0.0018	SELECT position FROM tables2018 WHERE team=817553 AND league_id=39655 AND round=4
0.0018	SELECT position FROM tables2018 WHERE team=817554 AND league_id=39655 AND round=4
0.0018	SELECT * FROM futbol.calendars_lineups WHERE id = 574977 AND league_id = 39655 AND year = 2018


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra: