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

Torpedo Vladimir

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Baltika II	5	15	4	13
2	Rodina	5	9	3	11
3	Spartak	5	9	3	11
4	Dinamo	5	12	4	10
5	Torpedo	5	12	7	9
6	Zenit II	5	8	5	9
7	Dinamo	5	6	3	8
8	Chertanovo	5	8	7	8
9	Znamya	5	6	8	8
10	Dynamo	5	7	7	6
11	FC Saturn	4	4	8	6
12	Tver	5	7	11	4
13	Luki-Energiy	5	3	9	4
14	Zvezda	5	2	10	1
15	Irkutsk	4	2	11	1
16	Yenisey II	5	1	11	0

TEMPORADA 2022/2023

SEGUNDA B RUSIA - TRANSICIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Khimik	17	33	15	44
2	Zenit II	17	34	11	37
3	Irkutsk	17	23	9	37
4	Dinamo	17	30	23	30
5	Dinamo Kirov	17	27	19	29
6	Rodina	17	22	21	27
7	Baltika II	17	23	21	25
8	Zorkiy	17	16	17	25
9	Dynamo	17	19	18	23
10	Dinamo	17	17	17	22
11	Zvezda	17	41	31	20
12	Luki-Energiy	17	18	21	20
13	Znamya	17	20	25	20
14	Tver	17	16	23	15
15	Torpedo	17	21	32	15
16	Yenisey II	17	21	37	15
17	Elektron VN	17	11	38	13
18	Torpedo	17	11	25	11

TEMPORADA 2021/2022

SEGUNDA B RUSIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Torpedo	8	15	6	29
2	Dolgoprudny	7	10	7	28
3	Zenit II	10	27	18	26
4	Znamya	8	16	10	25
5	Baltika II	10	11	11	22
6	Chertanovo	8	9	15	22
7	Luki-Energiy	10	13	14	20
8	FK Chita	9	11	16	18
9	Khimik	8	9	24	13

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 2011/2012

PRIMERA RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	KamAZ	10	5	10	67
2	Yenisey	10	8	10	66
3	SKA-Khabarov	10	11	9	62
4	Torpedo	10	17	12	61
5	FC Orenburg	10	14	4	59
6	Baltika	10	11	9	59
7	Volgar	10	8	8	59
8	FK Khimki	10	7	13	56
9	Luch	10	7	7	54
10	Chernomorets	10	8	9	52
11	Fakel	10	8	13	40

TEMPORADA 2009/2010

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Torpedo	32	64	25	68
2	T. Moscow	32	58	30	64
3	Lokomotiv	32	49	29	60
4	Dinamo	32	51	36	55
5	Sheksna	32	40	38	49
6	Sever	32	40	34	47
7	Volochanin-R	32	41	42	46
8	Istra	32	45	41	44
9	Volga Tver	32	30	29	44
10	Dnepr	32	37	45	43
11	Pskov 747	32	41	55	40
12	Nara-ShBFR	32	34	32	39
13	Spartak	32	29	37	38
14	Zelenograd	32	36	44	36
15	Dinamo	32	34	51	32
16	Tekstilshchi	32	37	47	31
17	SAC Moskva	32	27	78	18

TEMPORADA 2008/2009

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dynamo	36	63	28	79
2	Torpedo	36	59	25	73
3	Spartak	36	47	27	67
4	Istra	36	56	42	62
5	Lokomotiv	36	62	38	58
6	Volga Tver	36	47	45	55
7	Dinamo	36	52	40	53
8	Sever	35	54	56	53
9	Volochanin-R	36	52	38	52
10	Pskov 747	36	51	49	48
11	Zelenograd	36	44	43	48
12	Dimitrov	35	39	36	47
13	Sheksna	36	44	45	46
14	Nara-ShBFR	36	47	55	42
15	T. Moscow	36	35	43	42
16	Smena-Zenit	36	36	52	39
17	Tekstilshchi	35	43	64	34
18	SAC Moskva	36	43	67	30
19	Spartak	35	9	90	2

TEMPORADA 2007/2008

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	MVD Rossii	35	73	37	78
2	Torpedo	34	52	11	76
3	Sheksna	33	43	24	64
4	Spartak	34	62	28	62
5	Volga Tver	34	41	30	53
6	Dynamo	35	53	43	51
7	Sever	33	42	43	47
8	FK Reutov	34	37	41	47
9	Spartak	35	40	40	44
10	Pskov 747	34	31	31	44
11	Dimitrov	35	38	46	43
12	T. Moscow	34	40	44	39
13	Dinamo	34	41	53	39
14	Istra	35	36	57	39
15	Zelenograd	33	42	49	37
16	Volochanin-R	34	30	46	36
17	Nara-ShBFR	35	36	58	36
18	Tekstilshchi	34	35	56	34
19	Smena-Zenit	33	34	69	21

TEMPORADA 2006/2007

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SAC Moskva	30	39	25	57
2	Dynamo	30	47	27	53
3	Sheksna	30	50	33	53
4	Torpedo	29	40	27	49
5	FK Reutov	29	41	32	48
6	Spartak	29	33	25	46
7	Smena-Zenit	30	45	47	41
8	Spartak	29	29	35	39
9	T. Moscow	30	35	41	38
10	Nara-ShBFR	30	27	33	36
11	Volochanin-R	30	32	42	36
12	Zelenograd	30	36	36	34
13	Dinamo	30	30	34	33
14	Volga Tver	30	28	39	32
15	Baltika II	30	29	49	31
16	Dnepr	30	29	45	30

Competiciones que juega

Segunda B Rusia Grupo 2

Pos	Equipos		Pts
1		Baltika II	13
2		Rodina Moskva III	11
3		Spartak Moskva II	11
4		Dinamo Moskva II	10
5		Torpedo Vladimir	9
6		Zenit II	9
7		Dinamo Vologda	8
8		Chertanovo	8
9		Znamya	8
10		Dynamo St Petersburg	6
11		FC Saturn	6
12		Tver	4
13		Luki-Energiya	4
14		Zvezda St. Petersburg	1
15		Irkutsk	1
16		Yenisey II	0

	Ascenso : Baltika II
	Descenso : Irkutsk, Yenisey II

RIVALES EN Copa Rusa

RIVALES EN Segunda B Rusia

USO DE MEMORIA

6,992,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1564
Total Execution Time	0.1576

CADENA URL

/historico/Torpedo-Vladimir

GET DATOS

$_GET['/historico/Torpedo-Vladimir']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0029	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 = 'Torpedo-Vladimir' 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=13409 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=13409 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=13409 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=13409 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 = 75689
0.0025	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 = 73402
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13409 AND type_rel = 2
0.0028	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 = '13409' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '13409' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '13409' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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.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 = 75689 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=13409 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 (75689,73402,72435,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 = 75689 AND teamId = 13409
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 72435 AND teamId = 13409
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 13409
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13409
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 = 75689 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '13409' 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 = '13409' and rp.type = 4
0.0020	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 = '13409' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030	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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 13409 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.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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 13409 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 13409 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 13409 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 75689 AND t.round = 5 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* `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 = 68281 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.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* `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 = 71393 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.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 = 72435 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.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* `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 = 63368 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.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* `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 = 67128 AND t.round = 10 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* `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.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* `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.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* `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.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* `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.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* `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.0031	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.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* `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* `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.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* `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 = 10500 AND t.round = 11 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 = 25120 AND t.round = 36 ORDER BY team.conference 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* `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 = 25141 AND t.round = 38 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* `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 = 25154 AND t.round = 36 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* `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 = 25161 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 75689 ORDER BY nameShow LIMIT 100

Torpedo Vladimir

Torpedo Vladimir

Selecciona un equipo

Competiciones que juega

Segunda B Rusia Grupo 2

RIVALES EN Copa Rusa

RIVALES EN Segunda B Rusia