30 Jun 21	Finalizado	FK Khimki	0 - 1	Fakel	0
30 Jun 21	Finalizado	Volgar Astrakhan	1 - 2	Fakel	2
26 Jun 21	Finalizado	Fakel	1 - 1	Veles	1
21 Jun 21	Finalizado	Fakel	2 - 0	Torpedo Moscow	0
20 Feb 21	Finalizado	Fakel	1 - 1	Dinamo Minsk	0
17 Feb 21	Finalizado	Volgar Astrakhan	0 - 0	Fakel	0
10 Feb 21	Finalizado	Fakel	4 - 0	Kaysar Kyzylorda	0
07 Feb 21	Finalizado	FC Irtysh Omsk	1 - 2	Fakel	0
03 Feb 21	Finalizado	Fakel	5 - 0	Chertanovo	0
31 Ene 21	Finalizado	Fakel	2 - 0	Bardejov	0
24 Ene 21	Finalizado	Fakel	1 - 1	Rad Beograd	0

Copa Rusa »

26 Ago 20

Finalizado

SKA-Khabarovsk

0 - 0

Fakel

Primera Rusia »

15 May 21	Finalizado	Akron Tolyatti	0 - 2	Fakel	0
08 May 21	Finalizado	Fakel	0 - 0	Torpedo Moscow	0
02 May 21	Finalizado	Shinnik Yaroslavl	0 - 2	Fakel	0
28 Abr 21	Finalizado	Spartak Moskva II	3 - 5	Fakel	0
24 Abr 21	Finalizado	Fakel	1 - 1	Volgar Astrakhan	0
17 Abr 21	Finalizado	Krylia Sovetov	5 - 1	Fakel	0
11 Abr 21	Finalizado	Fakel	1 - 0	Tekstilshchik	0
07 Abr 21	Finalizado	Alaniya Vladikavkaz	2 - 0	Fakel	1
03 Abr 21	Finalizado	Fakel	1 - 1	Neftekhimik	1
28 Mar 21	Finalizado	Dinamo Bryansk	0 - 2	Fakel	0
24 Mar 21	Finalizado	Fakel	3 - 1	FC Irtysh Omsk	0
20 Mar 21	Finalizado	Tom Tomsk	0 - 3	Fakel	1
14 Mar 21	Finalizado	Fakel	4 - 1	Chertanovo	0
10 Mar 21	Finalizado	FK Nizhny Novgorod	1 - 2	Fakel	1
06 Mar 21	Finalizado	Yenisey	1 - 3	Fakel	0
27 Feb 21	Finalizado	FC Orenburg	1 - 2	Fakel	0
05 Dic 20	Finalizado	Fakel	1 - 1	Chayka	0
29 Nov 20	Finalizado	Fakel	3 - 0	SKA-Khabarovsk	0
25 Nov 20	Finalizado	Fakel	0 - 0	Veles	0
21 Nov 20	Finalizado	Baltika Kaliningrad	0 - 0	Fakel	0
15 Nov 20	Finalizado	Fakel	6 - 2	FC Krasnodar II	0
11 Nov 20	Finalizado	Torpedo Moscow	4 - 1	Fakel	2
07 Nov 20	Finalizado	Fakel	2 - 0	Shinnik Yaroslavl	0
01 Nov 20	Finalizado	Fakel	1 - 1	Spartak Moskva II	0
28 Oct 20	Finalizado	Volgar Astrakhan	2 - 1	Fakel	0
24 Oct 20	Finalizado	Fakel	1 - 1	Krylia Sovetov	0
17 Oct 20	Finalizado	Tekstilshchik	0 - 0	Fakel	0
13 Oct 20	Finalizado	Fakel	0 - 0	Alaniya Vladikavkaz	3
09 Oct 20	Finalizado	Neftekhimik	3 - 1	Fakel	3
04 Oct 20	Finalizado	Fakel	0 - 0	Dinamo Bryansk	4
27 Sep 20	Finalizado	FC Irtysh Omsk	1 - 0	Fakel	0
23 Sep 20	Finalizado	Fakel	0 - 0	Tom Tomsk	0
19 Sep 20	Finalizado	Chertanovo	0 - 3	Fakel	0
13 Sep 20	Finalizado	Fakel	0 - 1	FK Nizhny Novgorod	0
09 Sep 20	Finalizado	Fakel	1 - 0	Yenisey	19
05 Sep 20	Finalizado	Fakel	0 - 2	FC Orenburg	2
31 Ago 20	Finalizado	Chayka	2 - 1	Fakel	12
22 Ago 20	Finalizado	SKA-Khabarovsk	1 - 0	Fakel	2
16 Ago 20	Finalizado	Veles	1 - 1	Fakel	1
12 Ago 20	Finalizado	Fakel	0 - 1	Baltika Kaliningrad	0
08 Ago 20	Finalizado	FC Krasnodar II	3 - 1	Fakel	0
01 Ago 20	Finalizado	Fakel	1 - 0	Akron Tolyatti	2

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Fakel Temporada 2020/2021

		Edad	Altura	Peso
Portero
1	A. Sautin	36	195	-	-	-	2
79	D. Ermakov	25	190	74	-	-	-
30	D. Kortnev	34	188	86	-	-	-
Defensa
4	A. Dashaev	35	180	71	1	-	3
5	A. Solovjev	28	185	-	1	-	1
70	Dmitri Kalugin	26	175	-	-	-	-
5	Dmitri Neplyuev	23	181	-	-	-	-
25	M. Smirnov	33	189	85	1	-	2
39	N. Pejcinovic	36	185	80	4	-	4
3	N. Zajtsev	34	191	85	2	-	5
	Nikolay Zaytsev	34	-	-	-	-	-
21	O. Krasilnichenko	27	172	68	-	-	-
92	S. Bryzgalov	31	182	76	3	1	10
88	V. Masternoy	28	179	71	-	1	8
26	V. Pochivalin	32	178	65	-	1	6
80	V. Turukin	24	178	-	-	-	-
2	Vasily Cherov	28	185	81	-	-	-
55	Vladislav Parshikov	28	171	-	-	-	-
Centrocampista
87	D. Korobov	29	170	64	-	-	3
6	Denis Shepilov	23	184	69	-	-	3
56	Maksim Sedov	23	179	68	-	-	2
33	N. Zamaliev	34	177	72	1	1	9
34	O. Dmitriev	28	180	74	7	-	7
10	R. Akbashev	32	177	64	6	-	11
80	V. Tsarukyan	22	170	-	-	-	-
9	Vladislav Korobkin	23	174	68	-	-	-
Delantero
15	A. Nikitin	23	178	70	4	1	10
9	A. Podbeltsev	31	187	-	-	-	-
22	A. Razborov	29	178	76	12	-	5
11	I. Mazurov	24	182	-	3	-	4
14	K. Appaev	34	192	68	5	-	10
7	M. Grigoryev	33	188	73	-	1	3
19	M. Maksimov	28	190	83	8	-	6
77	M. Petrusev	29	175	-	1	-	1
8	M. Zemskov	29	176	-	1	-	1
91	P. Yákovlev	33	180	72	2	-	6
17	Roman Pukhov	23	180	-	-	-	-

Noticias de Primera Rusia

Ver últimas noticias

"A Cubarsí le puedes hacer líder; no deberías, pero puedes... sin exigirle la Champions"

BeSoccer - Jueves, 04 Abril 2024

4 6.427

Franc Artiga, ex entrenador de las categorías inferiores del Barça y actual técnico del Rodina ruso, charló con 'EFE' sobre los desafíos del FC Barcelona. El míster aplaudió la progresión de talentos como el de Pau Cubarsí, pero advirtió a Xavi de los peligros. "Se le puede dar el rol de líder del equipo a un chaval de 17 años, no deberías, pero puedes...", comentó.

Fallece Aleksandr Kozlov a los 29 años, canterano del Spartak

BeSoccer - Viernes, 15 Julio 2022

3 3.509

Este viernes ha fallecido Aleksandr Kozlov, canterano del Spartak de Moscú, a los 29 años de edad debido a un coágulo de sangre durante un entrenamiento con el equipo amateur en el que jugaba, según señala el medio ruso 'Baza News'.

Sorpresa: El Nápoles anunció el fichaje del 'Messi georgiano'

BeSoccer - Viernes, 01 Julio 2022

3 8.826

La directiva del Nápoles presentó a su primer fichaje en este mercado: Khvicha Kvaratskhelia, centrocampista de 21 años que es conocido en el mundo del fútbol como el 'Messi georgiano'.

El City abre sus puertas a un futbolista ucraniano refugiado

BeSoccer - Viernes, 01 Abril 2022

0 997

El jugador ucraniano Andrii Kravchuk ha recibido el permiso de la Premier League para poder entrenarse con el Manchester City después de abandonar el Torpedo de Moscú.

Oleksandr Kaplienko, otro ucraniano que deja un equipo ruso

BeSoccer - Jueves, 03 Marzo 2022

0 1.310

Los jugadores ucranianos que compiten en clubes rusos siguen cancelando sus contratos. El último ha sido Oleksandr Kaplienko, uno de los laterales del Torpedo de Moscú.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Primera Rusia

Pos	Equipos		Pts
1		Krylia Sovetov	101
2		FC Orenburg	94
3		FK Nizhny Novgorod	88
4		Alaniya Vladikavkaz	77
5		Baltika Kaliningrad	73
6		Torpedo Moscow	72
7		Neftekhimik	70
8		Veles	66
9		Fakel	64
10		Yenisey	63
11		SKA-Khabarovsk	60
12		Chayka	56
13		Volgar Astrakhan	54
14		Spartak Moskva II	49
15		Tekstilshchik	47
16		FC Krasnodar II	45
17		Akron Tolyatti	42
18		Tom Tomsk	41
19		FC Irtysh Omsk	35
20		Dinamo Bryansk	32
21		Chertanovo	27
22		Shinnik Yaroslavl	25

	Ascenso : Krylia Sovetov, FC Orenburg
	Playoff Ascenso : FK Nizhny Novgorod, Alaniya Vladikavkaz
	Descenso : FC Krasnodar II, Akron Tolyatti, Tom Tomsk, FC Irtysh Omsk, Dinamo Bryansk, Chertanovo, Shinnik Yaroslavl

RIVALES EN Primera Rusia

RIVALES EN Copa Rusa

USO DE MEMORIA

6,186,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5518
Total Execution Time	0.5537

CADENA URL

/Fakel/2021

GET DATOS

$_GET['/Fakel/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0186	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fakel' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0132	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13452 AND type_rel = 2
0.0168	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '13452' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0157	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '13452' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57359 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2021 as c ON c.league_id = l.id WHERE (c.datateam1 = 13452 or c.datateam2 = 13452) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0135	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2021 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 13452 or c.datateam2 = 13452) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0133	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2021 as c ON c.league_id = l.id INNER JOIN events2021 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 13452 or c.datateam2 = 13452) AND l.year = 2021)
0.0130	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=13452 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0127	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (63895,63115,62807) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 63115 AND teamId = 13452
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 63895 AND teamId = 13452
0.0270	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 13452
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2021` 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 = 57359 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 57359 WHERE rp.league_id = 57359 AND rp.teamId = 13452 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 57359 WHERE rp.league_id = 57359 AND rp.teamId = 13452 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 57359 WHERE rp.league_id = 57359 AND rp.teamId = 13452 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 13452 AND rp.league_id = 57359 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0132	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6383165 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0126	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6383165
0.0137	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6383165 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0141	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6383165 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0134	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6383165 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0139	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6383165 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0183	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6383165 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0130	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 57359 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Fakel

Información sobre Fakel

Información

Internet

Opciones de envio

Datos del equipo

Histórico de participación

Primera Rusia

Copa Rusa Grupo 1

Partidos Amistosos

Premier League Rusia

Segunda B Rusia Grupo 4

Amistosos Selecciones No Oficiales

Premier League Rusia - Play Offs Ascenso

Partidos del Fakel

Estadísticas

Plantilla del Fakel Temporada 2020/2021

Noticias de Primera Rusia

"A Cubarsí le puedes hacer líder; no deberías, pero puedes... sin exigirle la Champions"

Fallece Aleksandr Kozlov a los 29 años, canterano del Spartak

Sorpresa: El Nápoles anunció el fichaje del 'Messi georgiano'

El City abre sus puertas a un futbolista ucraniano refugiado

Oleksandr Kaplienko, otro ucraniano que deja un equipo ruso

Fakel

Selecciona un equipo

Competiciones que juega

Primera Rusia

RIVALES EN Primera Rusia

RIVALES EN Copa Rusa


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos