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

Dinamo Bryansk

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA A RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Spartak	10	11	3	21
2	Mashuk-KMV	10	8	7	15
3	Kaluga	9	13	9	14
4	Khimik	10	11	10	14
5	Avangard	10	9	11	14
6	Volga	10	15	10	13
7	Torpedo	10	10	11	11
8	Tekstilshchi	10	8	10	11
9	Irtysh Omsk	10	5	11	8
10	Dinamo	9	8	16	4

TEMPORADA 2022/2023

SEGUNDA B RUSIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Sokol	12	15	13	46
2	Dinamo	12	19	6	38
3	Rodina	12	19	10	36
4	Salyut	12	20	8	35
5	Avangard	12	17	14	34
6	Metallurg	12	17	19	34
7	Kaluga	12	16	17	33
8	Dinamo	12	14	18	26
9	FK Ryazan	12	11	19	25
10	Kosmos	12	10	14	22
11	FC Saturn	12	16	26	20
12	Sakhalinets	12	13	23	19

TEMPORADA 2021/2022

SEGUNDA B RUSIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Rodina	12	21	11	49
2	Sokol	12	28	12	42
3	Salyut	12	26	12	39
4	Dinamo	12	19	10	39
5	Strogino	12	20	15	37
6	Dinamo	12	12	18	28
7	Avangard	12	16	17	27
8	Saransk	12	13	18	27
9	Khimki II	12	16	15	22
10	FK Ryazan	12	9	15	17
11	Khabarovsk	12	4	16	17
12	Peresvet	12	10	35	12

TEMPORADA 2020/2021

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Krylia	42	100	26	101
2	FC Orenburg	42	78	33	94
3	Nizhny	42	67	28	88
4	Alaniya	42	74	40	77
5	Baltika	42	49	35	73
6	Torpedo	42	65	41	72
7	Neftekhimik	42	64	44	70
8	Veles	42	54	46	66
9	Fakel	42	57	43	64
10	Yenisey	42	52	54	63
11	SKA-Khabarov	42	52	47	60
12	Chayka	42	44	53	56
13	Volgar	42	47	45	54
14	Spartak	42	53	77	49
15	Tekstilshchi	42	32	51	47
16	Krasnodar	42	46	68	45
17	Akron	42	35	54	42
18	Tom Tomsk	42	32	50	41
19	Irtysh Omsk	42	33	61	35
20	Dinamo	42	24	66	32
21	Chertanovo	42	35	80	27
22	Shinnik	42	39	90	25

TEMPORADA 2019/2020

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dinamo	17	28	11	39
2	Sokol	17	37	10	37
3	Metallurg	17	30	9	37
4	Khimik	17	27	20	26
5	Salyut	17	23	23	26
6	FK Ryazan	17	29	26	24
7	Zorkiy	16	31	32	23
8	Ararat	17	34	36	23
9	Kaluga	17	24	23	22
10	FC Saturn	17	32	32	22
11	Khimki II	17	23	32	18
12	Strogino	17	15	28	17
13	Rotor	16	14	33	8
14	Kvant	17	8	40	8

TEMPORADA 2018/2019

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Torpedo	26	48	17	65
2	Sokol	26	49	18	58
3	Metallurg	26	47	25	51
4	Dinamo	26	40	21	48
5	Zorkiy	26	40	34	36
6	Kaluga	26	30	29	36
7	Khimik	26	24	33	32
8	Kvant	26	35	36	31
9	Salyut	26	26	30	31
10	FK Ryazan	26	26	31	31
11	Rotor	26	30	47	30
12	FC Saturn	26	23	40	23
13	Strogino	26	21	45	17
14	Khimki II	26	22	55	14

TEMPORADA 2017/2018

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ararat	26	52	17	63
2	Energomash	26	43	21	53
3	Spartak	26	37	23	46
4	Metallurg	26	35	32	43
5	Torpedo	26	44	22	42
6	Zorkiy	25	39	26	40
7	Sokol	26	36	38	39
8	FC Saturn	26	37	34	37
9	Strogino	26	38	37	36
10	Dinamo	26	33	29	34
11	Khimik	26	31	35	31
12	Kaluga	26	20	37	21
13	Rotor	26	19	51	11
14	Zenit Penza	25	12	74	11

TEMPORADA 2016/2017

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Avangard	24	28	16	45
2	Torpedo	24	36	19	42
3	FC Saturn	24	32	20	42
4	Energomash	24	47	24	41
5	Vityaz	24	43	35	40
6	Chertanovo	24	36	33	34
7	FK Ryazan	24	29	25	31
8	Metallurg	24	27	29	31
9	Dinamo	24	22	19	30
10	Kaluga	24	25	28	30
11	Zenit Penza	24	31	43	27
12	Arsenal Tula	24	24	52	17
13	FK Orel	24	13	50	15

TEMPORADA 2015/2016

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Tambov	26	41	19	54
2	Energomash	26	28	16	46
3	Metallurg	26	26	21	40
4	FK Ryazan	26	19	15	40
5	Avangard	26	33	22	39
6	Lokomotiv	26	27	19	39
7	Zenit Penza	26	25	21	38
8	Kaluga	26	24	27	33
9	Vityaz	26	31	32	31
10	Dinamo	26	22	25	31
11	Torpedo	26	21	28	30
12	Chertanovo	26	30	42	28
13	FK Orel	26	9	25	22
14	Arsenal Tula	26	22	46	16

TEMPORADA 2014/2015

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Fakel	30	64	14	80
2	FK Ryazan	30	51	13	69
3	Tambov	30	71	26	65
4	Lokomotiv	30	34	22	53
5	Metallurg	30	42	29	49
6	Kaluga	30	42	31	49
7	Zenit Penza	30	32	22	49
8	Vityaz	30	43	47	44
9	Avangard	30	45	35	43
10	Dinamo	30	30	26	38
11	Vybor-Kurbat	29	22	43	29
12	Podolye	30	30	58	28
13	FK Orel	30	25	59	20
14	Metallurg	29	16	54	19
15	Chertanovo	30	30	63	18
16	Arsenal Tula	30	19	54	11

TEMPORADA 2011/2012

PRIMERA RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mordovia	14	24	12	100
2	Alaniya	14	16	15	97
3	Nizhny	14	23	18	91
4	Shinnik	14	9	14	91
5	Ural	14	20	17	78
6	Dinamo	14	14	17	78
7	Sibir	14	15	18	76
8	Torpedo	14	13	23	68

TEMPORADA 2009/2010

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FC Kuban	38	51	20	80
2	Volga	38	62	25	71
3	Nizhny	38	60	41	70
4	KamAZ	38	55	43	66
5	Krasnodar	38	60	44	61
6	Mordovia	38	53	40	58
7	Ural	38	38	28	58
8	Zhemchuzhina	38	45	44	57
9	Volgar	38	45	48	57
10	Shinnik	38	43	31	55
11	SKA-Khabarov	38	37	39	53
12	Luch	38	42	42	52
13	FK Khimki	38	39	38	50
14	Dinamo	38	53	54	44
15	Baltika	38	38	47	43
16	Dynamo	38	32	53	37
17	Salyut	38	30	47	34
18	Rotor	38	27	64	34
19	Irtysh Omsk	38	26	52	28
20	Avangard	38	31	67	27

TEMPORADA 2008/2009

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Avangard	32	68	23	73
2	Dinamo	32	57	22	69
3	Avangard	32	50	17	67
4	Gubkin	32	51	29	58
5	Lokomotiv	32	43	21	56
6	Metallurg	32	51	41	56
7	FK Orel	32	48	36	51
8	FK Ryazan	32	39	34	45
9	Serpukhov	32	45	47	41
10	Spartak	31	39	45	41
11	Voronezh	32	44	48	39
12	Saturn-2	31	35	36	38
13	Dnepr	32	31	33	37
14	Znamya	32	38	50	33
15	Fakel	31	26	55	31
16	Nika Moskva	32	20	86	17
17	Yelets	31	8	70	9

TEMPORADA 2007/2008

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FK Rostov	42	78	29	96
2	FC Kuban	42	84	36	87
3	KamAZ	42	68	41	79
4	Ural	42	69	39	75
5	NoSta	42	59	37	73
6	Anzhi	42	63	35	72
7	Baltika	42	43	34	65
8	Chernomorets	42	51	38	61
9	SKA-Khabarov	42	63	60	61
10	Alaniya	42	50	47	59
11	Sibir	42	51	41	58
12	SKA Rostov	42	52	50	58
13	Salyut	42	51	51	58
14	Vityaz	42	49	57	58
15	Metallurg-Ku	42	44	42	57
16	SAC Moskva	42	55	57	57
17	Volga	42	50	65	49
18	Torpedo	42	47	69	49
19	Mashuk-KMV	42	39	79	32
20	Dinamo	42	31	80	27
21	Zvezda	42	36	95	23
22	Dinamo	42	30	81	22

TEMPORADA 2006/2007

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	Shinnik	42	68	30	92
2	Akhmat	42	69	27	90
3	Sibir	42	80	39	86
4	Ural	42	70	33	77
5	KamAZ	42	67	34	77
6	Torpedo	42	75	59	69
7	NoSta	42	63	40	64
8	Dinamo	42	49	52	59
9	Salyut	42	44	45	57
10	Anzhi	42	41	44	57
11	Zvezda	42	60	47	56
12	SKA-Khabarov	42	50	48	56
13	Alaniya	42	56	56	56
14	Mashuk-KMV	42	53	55	55
15	Baltika	42	53	49	54
16	SKA Rostov	42	50	60	53
17	Metallurg-Ku	42	53	70	53
18	Avangard	42	50	55	51
19	Mordovia	42	44	88	43
20	Tekstilshchi	42	38	68	38
21	Sodovik	42	32	65	34
22	Spartak-MZhK	42	21	122	7

TEMPORADA 2005/2006

PRIMERA RUSIA
Equipo		PJ	GF	GC	Puntos
1	FK Khimki	42	83	30	99
2	FC Kuban	42	92	25	97
3	Ural	42	67	23	90
4	KamAZ	42	54	26	77
5	SKA-Khabarov	42	67	40	71
6	Sodovik	42	59	35	69
7	Sibir	42	67	45	65
8	Akhmat	42	48	47	62
9	Avangard	42	45	38	61
10	Dinamo	42	42	38	61
11	Volgar	42	45	47	60
12	Salyut	42	46	58	56
13	Baltika	42	41	56	55
14	Mashuk-KMV	42	41	56	55
15	Anzhi	42	57	66	53
16	Dynamo	42	56	54	51
17	Lada	42	38	63	45
18	Spartak	42	46	60	43
19	Fakel	42	27	54	42
20	FC Oryol	42	35	72	29
21	Yenisey	42	30	80	21
22	Angusht	42	32	105	13

Competiciones que juega

Segunda A Rusia Grupo 4

Pos	Equipos		Pts
1		Spartak Kostroma	21
2		Mashuk-KMV	15
3		Kaluga	14
4		Khimik Dzerzhinsk	14
5		Avangard Kursk	14
6		Volga Ulyanovsk	13
7		Torpedo Miass	11
8		Tekstilshchik	11
9		FC Irtysh Omsk	8
10		Dinamo Bryansk	4

	Ascenso : Spartak Kostroma, Mashuk-KMV, Kaluga, Khimik Dzerzhinsk
	Playoff Descenso : FC Irtysh Omsk, Dinamo Bryansk

RIVALES EN Segunda A Rusia

RIVALES EN Copa Rusa

USO DE MEMORIA

7,113,048 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1730
Total Execution Time	0.1743

CADENA URL

/historico/Dinamo-Bryansk

GET DATOS

$_GET['/historico/Dinamo-Bryansk']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0050	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 = 'Dinamo-Bryansk' 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.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=19991 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=19991 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=19991 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=19991 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=19991 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 72430
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19991 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2827 AND type_rel = 3
0.0057	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 = '19991' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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 = '19991' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 72430 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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 = 73402 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034	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=19991 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (74618,73402,71432,71395) 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 = 74618 AND teamId = 19991
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71395 AND teamId = 19991
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 19991
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19991
0.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` 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 = 74618 AND t.round = 12 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '19991' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19991' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '19991' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046	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 events2024 e ON e.player_id = p.id AND e.league_id = 74618 WHERE rp.league_id = 74618 AND rp.teamId = 19991 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.0034	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 events2024 e ON e.player_id = p.id AND e.league_id = 74618 WHERE rp.league_id = 74618 AND rp.teamId = 19991 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 events2024 e ON e.player_id = p.id AND e.league_id = 74618 WHERE rp.league_id = 74618 AND rp.teamId = 19991 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 = 19991 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables2024` 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 = 72430 AND t.round = 18 ORDER BY team.conference ASC,t.position 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* `tables2024` 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 = 74618 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables2023` 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 = 68282 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables2023` 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 = 71395 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 63369 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 67129 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 57359 AND t.round = 42 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 = 50461 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.0027	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 = 38854 AND t.round = 26 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* `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 = 33931 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 = 15686 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 4369 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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* `tables2012` 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 = 10498 AND t.round = 38 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* `tables2012` 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 = 10499 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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* `tables2010` 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 = 10501 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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* `tables2009` 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 = 25142 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables2008` 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 = 12949 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables2007` 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 = 12950 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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* `tables2006` 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 = 12951 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Dinamo Bryansk

Dinamo Bryansk

Selecciona un equipo

Competiciones que juega

Segunda A Rusia Grupo 4

RIVALES EN Segunda A Rusia

RIVALES EN Copa Rusa