Sitios
- Twitter
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

FSC Dolgoprudniy

Temporada 2021/2022

TEMPORADA 2021/2022

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Torpedo	38	65	36	75
2	Fakel	38	60	33	74
3	FC Orenburg	38	64	37	74
4	SKA-Khabarov	38	48	38	65
5	Yenisey	38	58	55	63
6	Alaniya	38	75	53	60
7	Neftekhimik	38	60	43	58
8	Baltika	38	51	30	58
9	Spartak	38	48	55	58
10	Akron	38	47	40	58
11	Krasnodar	38	45	45	53
12	Kuban	38	45	48	49
13	Veles	38	45	48	48
14	Tom Tomsk	38	51	60	48
15	Dolgoprudniy	38	35	47	41
16	Volgar	38	30	43	39
17	KamAZ	38	29	45	37
18	Rotor	38	37	53	36
19	Metallurg	38	31	70	33
20	Tekstilshchi	38	31	76	23

TEMPORADA 2020/2021

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dolgoprudniy	30	45	18	68
2	Zenit II	30	56	26	59
3	Dinamo	30	63	37	58
4	Tver	29	53	27	56
5	Leningradets	30	51	29	54
6	Kazanka	30	52	39	48
7	Rodina	30	59	46	45
8	Zvezda	30	41	29	43
9	Torpedo	30	40	40	39
10	Znamya	30	31	39	33
11	Smolensk	30	26	46	31
12	Luki-Energiy	30	31	53	31
13	Murom	30	32	42	30
14	FK Chita	29	26	60	26
15	Kolomna	30	38	63	22
16	Zenit	30	15	65	18

TEMPORADA 2019/2020

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Veles	16	34	13	36
2	Dolgoprudniy	17	29	16	35
3	Zenit II	17	30	14	32
4	Torpedo	17	23	17	30
5	Leningradets	17	27	20	28
6	Olimp Khimki	16	18	15	26
7	Murom	16	31	23	24
8	Rodina	17	27	31	22
9	Pskov 747	16	15	26	21
10	Kazanka	16	26	27	17
11	Kolomna	17	15	24	15
12	Znamya	17	14	23	15
13	Luki-Energiy	16	15	29	13
14	Zvezda	17	9	35	6

TEMPORADA 2018/2019

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kazanka	24	53	27	52
2	Tekstilshchi	23	39	20	52
3	Veles	24	44	18	49
4	Dolgoprudniy	24	43	21	40
5	Leningradets	24	32	28	37
6	Murom	24	39	37	36
7	Znamya	24	29	27	34
8	Torpedo	23	28	27	30
9	Luki-Energiy	24	22	24	29
10	Pskov 747	24	34	42	29
11	Kolomna	24	26	56	21
12	Dnepr	22	16	53	14
13	Chertanovo	24	26	51	13

TEMPORADA 2017/2018

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Chertanovo	26	52	15	61
2	Tekstilshchi	26	49	20	54
3	Kazanka	26	50	23	52
4	Veles	26	46	32	46
5	Spartak	26	34	26	43
6	Dolgoprudniy	26	49	27	43
7	Pskov 747	26	30	36	37
8	Torpedo	26	38	34	36
9	Murom	26	24	28	32
10	Dynamo	26	29	35	32
11	Luki-Energiy	26	19	23	28
12	Dnepr	26	26	40	25
13	Kolomna	26	18	59	16
14	Znamya	26	12	78	4

TEMPORADA 2016/2017

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dynamo	26	63	19	64
2	Dolgoprudniy	26	53	20	56
3	Tekstilshchi	26	49	23	52
4	Dinamo	26	38	25	43
5	Spartak	26	39	22	43
6	Solaris	26	50	40	37
7	Torpedo	26	30	31	35
8	Domodedovo	26	21	32	33
9	Dnepr	26	35	37	29
10	Pskov 747	26	18	31	28
11	Strogino	26	18	42	23
12	Kolomna	26	19	43	21
13	Znamya	26	15	47	16
14	Volga Tver	26	14	50	16

TEMPORADA 2015/2016

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Khimki	28	53	14	69
2	Dolgoprudniy	28	49	30	55
3	Solaris	28	50	24	55
4	Tekstilshchi	28	49	23	53
5	Torpedo	28	37	24	51
6	Dynamo	28	44	31	47
7	Spartak	28	42	33	47
8	Pskov 747	28	38	38	38
9	Strogino	28	35	32	33
10	Dnepr	28	26	32	31
11	Volga Tver	28	26	43	28
12	Znamya	28	28	54	25
13	Domodedovo	28	30	52	22
14	Karelia	28	26	58	20
15	Kolomna	28	20	65	10

TEMPORADA 2014/2015

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Spartak	30	65	26	65
2	Zenit II	30	78	41	57
3	FK Khimki	30	42	26	54
4	Strogino	30	39	29	54
5	Tekstilshchi	30	51	29	53
6	Dolgoprudniy	30	45	39	51
7	FC Saturn	30	42	31	50
8	Torpedo	30	41	36	48
9	Pskov 747	30	39	38	42
10	Domodedovo	30	48	50	38
11	Volga Tver	30	36	54	32
12	Spartak	30	26	39	28
13	Dnepr	30	32	49	28
14	Solaris	30	39	59	28
15	Kolomna	30	28	67	23
16	Znamya	30	21	59	18

TEMPORADA 2013/2014

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tosno	32	51	16	71
2	Tekstilshchi	32	58	32	67
3	FK Khimki	32	67	37	58
4	Pskov 747	32	44	31	56
5	Dnepr	32	48	43	52
6	Torpedo	32	48	38	49
7	Sever	32	39	34	48
8	Lokomotiv	32	49	40	45
9	Dolgoprudniy	32	40	32	45
10	Zenit II	32	43	43	43
11	Strogino	32	37	39	39
12	Spartak	32	31	33	36
13	Kolomna	32	32	56	35
14	Znamya	32	19	52	30
15	FC Vologda	32	34	49	29
16	Volga Tver	32	28	52	26
17	Saint	32	16	57	20

TEMPORADA 2012/2013

SEGUNDA B RUSIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Khimik	26	37	18	52
2	Pskov 747	26	41	23	49
3	Tekstilshchi	26	34	20	49
4	Dolgoprudniy	26	31	28	45
5	Volga Tver	26	31	22	41
6	Dnepr	26	33	28	41
7	Lokomotiv	26	36	26	40
8	Spartak	26	24	20	40
9	Sever	26	34	31	37
10	Karelia	26	19	33	29
11	FC Vologda	26	25	37	24
12	Saint	26	24	45	19
13	Znamya	26	14	36	19
14	Piter	26	20	36	16

Competiciones que juega

Primera Rusia

Pos	Equipos		Pts
1		Torpedo Moscow	75
2		Fakel	74
3		FC Orenburg	74
4		SKA-Khabarovsk	65
5		Yenisey	63
6		Alaniya Vladikavkaz	60
7		Neftekhimik	58
8		Baltika Kaliningrad	58
9		Spartak Moskva II	58
10		Akron Tolyatti	58
11		FC Krasnodar II	53
12		PFC Kuban Krasnodar	49
13		Veles	48
14		Tom Tomsk	48
15		FSC Dolgoprudniy	41
16		Volgar Astrakhan	39
17		KamAZ	37
18		Rotor Volgograd	36
19		Metallurg Lipetsk	33
20		Tekstilshchik	23

	Ascenso : Torpedo Moscow, Fakel
	Playoff Ascenso : FC Orenburg, SKA-Khabarovsk
	Descenso : KamAZ, Rotor Volgograd, Metallurg Lipetsk, Tekstilshchik

RIVALES EN Primera Rusia

RIVALES EN Copa Rusa

USO DE MEMORIA

6,387,712 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1461
Total Execution Time	0.1474

CADENA URL

/historico/Fc-Dolgoprudny

GET DATOS

$_GET['/historico/Fc-Dolgoprudny']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0026	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 = 'Fc-Dolgoprudny' AND l.year = 2024 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.0040	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 = 'Fc-Dolgoprudny' 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.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=13400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13400 AND type_rel = 2
0.0022	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 = '13400' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = '13400' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 63115 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=13400 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (63327,63115,62807,57804) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 63115 AND teamId = 13400
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 57804 AND teamId = 13400
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 63327 AND teamId = 13400
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 13400
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2022` 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 = 63115 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0038	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 events2022 e ON e.player_id = p.id AND e.league_id = 63115 WHERE rp.league_id = 63115 AND rp.teamId = 13400 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.0033	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 events2022 e ON e.player_id = p.id AND e.league_id = 63115 WHERE rp.league_id = 63115 AND rp.teamId = 13400 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 events2022 e ON e.player_id = p.id AND e.league_id = 63115 WHERE rp.league_id = 63115 AND rp.teamId = 13400 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 13400 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	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* `tables2022` 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 = 63115 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `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 = 57804 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2020` 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 = 50435 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2019` 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 = 44474 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 39158 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables2017` 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 = 33933 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2016` 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 = 15685 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2015` 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 = 4366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2014` 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 = 2866 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables2013` 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 = 25095 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

FSC Dolgoprudniy

FSC Dolgoprudniy

Selecciona un equipo

Competiciones que juega

Primera Rusia

RIVALES EN Primera Rusia

RIVALES EN Copa Rusa