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 Stavropol

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rubin Yalta	6	10	3	15
2	Astrakhan	6	9	2	14
3	Legion	6	8	4	13
4	Forte	5	12	6	9
5	Rostov	6	14	9	9
6	SKChF	6	4	3	9
7	Biolog	5	7	6	8
8	Pobeda	7	7	7	8
9	Kuban	7	8	10	8
10	Stroitel KS	5	6	7	7
11	Angusht	5	3	3	6
12	Spartak	6	9	10	6
13	Nart	6	6	9	6
14	Dinamo	6	4	8	5
15	Druzhba	6	4	7	4
16	Alania	6	7	16	4
17	Dinamo	4	1	9	1

TEMPORADA 2022/2023

SEGUNDA B RUSIA - TRANSICIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	SKA Rostov	8	16	9	19
2	SKChF	8	13	3	18
3	Spartak	8	13	7	16
4	Dinamo	8	10	10	9
5	Biolog	8	12	15	8
6	Pobeda	8	8	14	7
7	Dinamo	8	7	12	6
8	Alania	8	8	17	4

TEMPORADA 2021/2022

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dynamo	32	62	12	80
2	SKA Rostov	32	71	22	76
3	Chayka	32	88	24	70
4	Forte	32	55	31	61
5	Chernomorets	32	70	35	60
6	Kuban	32	46	31	54
7	Anzhi	32	46	35	48
8	Legion	32	44	31	46
9	Biolog	32	50	45	44
10	Spartak	32	32	28	40
11	Tuapse	32	36	60	38
12	Druzhba	32	25	44	32
13	Mashuk-KMV	32	47	54	31
14	Dinamo	32	40	57	29
15	Rotor	32	26	74	21
16	Alania	32	32	97	12
17	Essentuki	32	16	106	10

TEMPORADA 2020/2021

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kuban	32	88	22	80
2	Kuban	32	63	24	77
3	Chernomorets	32	57	19	72
4	Legion	32	56	22	61
5	SKA Rostov	32	70	34	59
6	Anzhi	32	59	43	51
7	Dinamo	32	51	45	48
8	Dynamo	32	48	42	47
9	Forte	32	53	32	47
10	Spartak	32	43	38	42
11	Biolog	32	61	53	39
12	Krasnodar	32	40	57	36
13	Mashuk-KMV	32	40	56	34
14	Druzhba	32	27	79	25
15	Inter	32	28	89	18
16	Tuapse	32	37	112	15
17	Essentuki	32	26	80	13

TEMPORADA 2019/2020

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Volgar	19	45	7	50
2	Alaniya	19	54	13	46
3	Druzhba	19	29	26	34
4	Chernomorets	19	40	22	33
5	Dynamo	19	19	24	26
6	SKA Rostov	19	25	25	26
7	Biolog	19	20	22	26
8	Legion	18	16	21	24
9	Dinamo	18	29	25	24
10	Mashuk-KMV	19	22	17	24
11	Kuban	19	22	37	20
12	Inter	19	24	38	20
13	Spartak	19	18	37	19
14	Krasnodar	19	19	38	18
15	Anzhi	17	24	28	10
16	Spartak	19	14	40	8

TEMPORADA 2018/2019

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Chayka	28	64	14	70
2	Kuban	28	47	19	67
3	Volgar	28	48	22	59
4	Chernomorets	28	55	23	52
5	Druzhba	28	33	36	45
6	Spartak	28	39	29	43
7	Legion	28	30	21	42
8	Biolog	28	32	39	37
9	Dinamo	28	36	48	34
10	Alaniya	28	34	41	30
11	Mashuk-KMV	28	31	40	29
12	Krasnodar	28	37	51	28
13	SKA Rostov	28	19	33	24
14	Angusht	28	13	47	15
15	Akademiya	28	11	66	9

TEMPORADA 2017/2018

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Armavir	32	70	16	79
2	Afips	32	70	15	78
3	Chayka	32	51	25	58
4	Krasnodar	32	58	37	54
5	Chernomorets	32	45	27	51
6	Druzhba	32	36	45	50
7	Spartak	32	36	27	44
8	SKA Rostov	32	40	38	44
9	Legion	32	32	29	43
10	Akademiya	32	26	42	42
11	Mashuk-KMV	32	27	32	38
12	Biolog	32	28	44	34
13	Alaniya	32	26	41	32
14	Dinamo	32	39	69	31
15	Angusht	32	29	56	28
16	Anzhi II	32	26	52	25
17	Kuban	32	25	69	25

TEMPORADA 2016/2017

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rotor	30	66	24	67
2	FC Armavir	30	44	18	62
3	Afips	30	42	24	62
4	Chayka	30	44	25	52
5	Krasnodar	30	47	28	50
6	Chernomorets	30	37	21	50
7	FK Sochi	30	44	32	48
8	SKA Rostov	30	31	33	40
9	Druzhba	30	36	45	38
10	Alaniya	30	26	36	37
11	Biolog	30	26	44	34
12	Dinamo	30	23	42	29
13	Angusht	30	18	32	27
14	Mashuk-KMV	30	30	54	26
15	Legion	30	22	52	24
16	Kuban	30	22	48	23

TEMPORADA 2015/2016

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spartak	26	43	6	63
2	Afips	26	35	27	49
3	Krasnodar	26	53	26	48
4	Chernomorets	26	35	22	48
5	Angusht	26	24	17	41
6	SKA Rostov	26	34	24	38
7	Dinamo	26	30	30	35
8	Mashuk-KMV	26	26	32	35
9	Akhmat	26	32	31	31
10	Biolog	26	21	34	27
11	Alaniya	26	19	37	25
12	Mitos	26	30	48	23
13	Astrakhan	26	23	49	21
14	Druzhba	26	22	44	20

TEMPORADA 2014/2015

SEGUNDA B RUSIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	FC Armavir	12	19	9	28
2	Vityaz	12	25	12	25
3	Afips	12	22	9	24
4	Dinamo	12	16	12	23
5	Chernomorets	12	26	12	22
6	Spartak	12	11	13	13
7	Mashuk-KMV	12	14	18	13
8	Druzhba	12	11	15	12
9	Biolog	12	10	14	12
10	Mitos	12	11	22	12
11	FK Taganrog	12	10	23	11
12	Angusht	12	9	25	6
13	Syzran-2003	5	8	1	11
14	KamAZ	5	4	5	7
15	Rubin Kazan	5	5	5	6
16	Zenit	5	5	6	5
17	Chelyabinsk	5	3	5	5
18	Volga	5	2	5	5

TEMPORADA 2011/2012

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rotor	34	67	16	79
2	FC Armavir	34	53	21	72
3	Slavyanskiy	34	47	24	64
4	Dagdizel	34	45	28	59
5	Mashuk-KMV	34	43	33	59
6	Astrakhan	34	64	49	56
7	Angusht	34	48	46	50
8	Dinamo	34	51	41	49
9	Mitos	34	48	42	48
10	Gazprom	34	39	39	45
11	Druzhba	34	42	44	41
12	FK Beslan	34	41	59	41
13	FK Taganrog	34	40	51	37
14	Olimpia	34	37	56	34
15	Biolog	34	32	40	33
16	Energiya	34	35	68	32
17	Alania	34	29	71	30
18	SKA Rostov	34	26	59	28

TEMPORADA 2009/2010

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	32	63	20	76
2	FC Armavir	32	41	15	69
3	Mashuk-KMV	32	53	27	62
4	Astrakhan	32	58	35	58
5	Krasnodar	32	51	27	56
6	FK Beslan	32	36	37	45
7	Gazprom	32	40	51	44
8	Mitos	32	47	45	42
9	Druzhba	32	37	40	41
10	Angusht	32	37	43	40
11	Energiya	32	43	52	39
12	Dagdizel	32	42	42	37
13	Dinamo	32	34	47	37
14	SKA Rostov	32	34	39	36
15	FK Taganrog	32	28	53	28
16	Avtodor	32	31	50	23
17	Bataisk 2007	32	19	71	15

TEMPORADA 2008/2009

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Zhemchuzhina	34	91	22	89
2	Stavropol	34	66	37	71
3	Olimpia	34	65	28	70
4	FC Armavir	34	54	32	63
5	Avtodor	35	52	40	60
6	Mashuk-KMV	35	47	44	53
7	Energiya	34	41	33	48
8	Bataisk 2007	34	43	39	45
9	Krasnodar	34	40	43	45
10	Astrakhan	34	36	39	43
11	Druzhba	34	45	47	42
12	Dinamo	34	45	44	41
13	SKA Rostov	33	48	61	39
14	Dagdizel	34	46	65	38
15	Gazprom	34	28	54	33
16	Angusht	34	36	61	31
17	Rotor	34	23	72	21
18	FK Taganrog	33	27	72	18

TEMPORADA 2007/2008

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Volgar	34	72	17	83
2	Bataisk 2007	34	73	31	76
3	Krasnodar	34	60	23	72
4	Olimpia	34	71	31	71
5	Dinamo	33	50	46	56
6	Zhemchuzhina	34	48	30	54
7	Dagdizel	34	35	45	46
8	Gazprom	34	38	41	44
9	Energiya	34	44	48	42
10	Druzhba	33	38	57	39
11	FK Taganrog	33	34	41	36
12	Nika Krasnyi	34	35	60	36
13	Rotor	34	40	62	35
14	Krasnodar	34	35	53	33
15	Astrakhan	34	31	56	33
16	FK Sochi	34	27	55	32
17	Spartak	33	28	45	30
18	Avtodor	34	39	57	30

TEMPORADA 2006/2007

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	28	68	25	67
2	Dinamo	28	47	28	56
3	Bataisk 2007	28	46	28	55
4	Rotor	28	56	29	53
5	Druzhba	28	39	32	51
6	Gazprom	28	40	36	46
7	FK Taganrog	27	41	27	43
8	Krasnodar	27	33	31	38
9	FK Sochi	28	35	39	34
10	Olimpia	28	30	46	33
11	Energiya	28	33	43	28
12	Astrakhan	28	24	38	28
13	Avtodor	28	28	48	25
14	Spartak	28	22	49	19
15	Tekstilshchi	28	15	58	13

TEMPORADA 2005/2006

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos

Competiciones que juega

Segunda B Rusia Grupo 1

Pos	Equipos		Pts
1		Rubin Yalta	15
2		Astrakhan	14
3		Legion Makhachkala	13
4		Forte Taganrog	9
5		FK Rostov II	9
6		SKChF Sevastopol	9
7		Biolog Novokubansk	8
8		Pobeda Khasavyurt	8
9		FC Kuban Holding	8
10		Stroitel KS	7
11		Angusht	6
12		Spartak Nalchik	6
13		Nart Cherkessk	6
14		Dinamo Stavropol	5
15		Druzhba Maykop	4
16		Alania Vladikavkaz II	4
17		Dinamo Makhachkala II	1

	Ascenso : Rubin Yalta
	Descenso : Alania Vladikavkaz II, Dinamo Makhachkala II

RIVALES EN Copa Rusa

RIVALES EN Segunda B Rusia

USO DE MEMORIA

6,892,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.6745
Total Execution Time	0.6766

CADENA URL

/historico/Dinamo-Stavropol

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0139	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-Stavropol' 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.0125	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=19967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=19967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=19967 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=19967 AND type_rel = 2
0.0156	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 = '19967' ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '19967' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137	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 = 75608 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151	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=19967 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134	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 (75608,74363,73402) 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.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 75608 AND teamId = 19967
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 74363 AND teamId = 19967
0.0169	SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 19967
0.0137	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 = 75608 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '19967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19967' and rp.type = 4
0.0128	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 = '19967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 75608 WHERE rp.league_id = 75608 AND rp.teamId = 19967 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.0133	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 = 75608 WHERE rp.league_id = 75608 AND rp.teamId = 19967 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 75608 WHERE rp.league_id = 75608 AND rp.teamId = 19967 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 19967 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128	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 = 75608 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 68280 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 71606 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 72434 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 74363 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 63367 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 57805 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 50436 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 44476 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 39156 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 33934 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 15682 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 4367 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 14064 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 25103 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 25116 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 25135 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 25153 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 25158 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 25169 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Dinamo Stavropol

Dinamo Stavropol

Selecciona un equipo

Competiciones que juega

Segunda B Rusia Grupo 1

RIVALES EN Copa Rusa

RIVALES EN Segunda B Rusia