Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Mashuk-KMV

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

SEGUNDA B RUSIA - TRANSICIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Mashuk-KMV	6	9	2	12
2	Kuban	6	7	4	9
3	Rubin Yalta	6	6	4	9
4	Druzhba	6	5	9	8
5	Astrakhan	6	4	6	6
6	Legion	6	4	10	2

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 2013/2014

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Volgar	34	73	15	90
2	Chernomorets	34	74	19	85
3	Vityaz	34	48	31	60
4	Olimpia	34	51	35	58
5	Dagdizel	34	41	36	55
6	Mitos	34	42	27	54
7	Astrakhan	34	43	36	51
8	SKA Rostov	34	39	30	50
9	Gazprom	34	37	32	47
10	FC Armavir	34	41	41	46
11	FK Taganrog	34	38	47	43
12	Mashuk-KMV	34	28	54	34
13	Biolog	34	37	53	33
14	Alania	34	43	65	33
15	Druzhba	34	26	47	32
16	Akhmat	34	30	53	30
17	Krasnodar	34	35	66	27
18	Energiya	34	31	70	21

TEMPORADA 2012/2013

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Chernomorets	32	53	17	69
2	Angusht	32	45	19	69
3	FC Armavir	32	51	25	63
4	Astrakhan	32	62	31	62
5	Mashuk-KMV	32	37	20	53
6	FK Taganrog	32	50	34	51
7	Alania	32	50	37	49
8	Dagdizel	32	35	27	48
9	Biolog	32	41	38	45
10	Mitos	32	47	47	45
11	Energiya	32	36	42	44
12	Slavyanskiy	32	42	44	39
13	Druzhba	32	33	48	35
14	Gazprom	32	34	50	28
15	Olimpia	32	25	55	24
16	Volgar	32	27	62	20
17	SKA Rostov	32	8	80	9

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

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

Competiciones que juega

Segunda A Rusia Grupo 4

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

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

RIVALES EN Segunda A Rusia

RIVALES EN Copa Rusa

USO DE MEMORIA

7,014,416 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1366
Total Execution Time	0.1378

CADENA URL

/historico/Mashuk-Kmv

GET DATOS

$_GET['/historico/Mashuk-Kmv']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13439 AND type_rel = 2
0.0025	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13439 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019	SELECT /35 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' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (412147) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '13439' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 74618 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=13439 AND l.year in (2023,2024,2025) 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 (74618,74362,73402,71606,71432) 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 = 13439
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71606 AND teamId = 13439
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74362 AND teamId = 13439
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 13439
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13439
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 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 = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '13439' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13439' and rp.type = 4
0.0023	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 = '13439' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 13439 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.0028	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 = 13439 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 13439 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 13439 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 = 74618 AND t.round = 11 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* `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.0020	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.0024	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.0020	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 = 74362 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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.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* `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.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* `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.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* `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.0024	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.0024	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.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* `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.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 = 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.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* `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.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* `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 = 2870 AND t.round = 34 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* `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 = 25089 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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.0024	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.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* `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.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* `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

Mashuk-KMV

Mashuk-KMV

Selecciona un equipo

Competiciones que juega

Segunda A Rusia Grupo 4

RIVALES EN Segunda A Rusia

RIVALES EN Copa Rusa