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

Kaluga

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 - TRANSICIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kaluga	17	50	6	39
2	Sakhalinets	17	38	21	36
3	Spartak	17	26	22	33
4	Dinamo	17	30	21	30
5	Arsenal Tula	17	24	16	30
6	Kompositum	17	28	20	29
7	FC Saturn	17	30	18	29
8	Khabarovsk	17	30	29	25
9	Zenit Penza	17	22	26	25
10	Sakhalin	17	16	19	23
11	Kosmos	17	24	28	23
12	Kvant	17	19	27	23
13	Znamya	17	18	26	22
14	Khimki II	17	20	28	19
15	FK Ryazan	17	24	27	15
16	Strogino	17	28	36	14
17	Kolomna	17	17	41	8
18	Peresvet	17	21	54	7

TEMPORADA 2021/2022

SEGUNDA B RUSIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Zenit Penza	10	18	7	36
2	Sakhalin	10	18	13	32
3	Kaluga	10	23	7	31
4	Arsenal Tula	10	14	20	30
5	Znamya	10	13	10	27
6	Kvant	10	10	9	27
7	FC Saturn	10	15	19	25
8	Fakel II	10	15	13	18
9	Metallurg	10	15	22	17
10	Kolomna	10	7	28	15

TEMPORADA 2020/2021

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Metallurg	29	59	25	63
2	FK Ryazan	30	57	33	59
3	Salyut	30	56	25	56
4	FC Saturn	29	60	29	55
5	Sokol	30	44	21	55
6	Strogino	30	51	42	48
7	Kaluga	30	50	37	47
8	Khimik	30	45	41	43
9	Znamya	29	41	38	40
10	Krasnyy	30	40	49	40
11	Avangard	30	35	41	36
12	Khimki II	30	42	65	32
13	Kvant	30	31	54	28
14	Metallurg	30	32	76	25
15	Fakel II	30	22	64	20
16	Sakhalin	29	26	51	19

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

SEGUNDA B RUSIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sokol	30	62	24	69
2	Fakel	30	47	21	60
3	Vityaz	30	51	32	60
4	Spartak	30	58	40	50
5	Dinamo	30	35	32	48
6	Kaluga	30	44	36	45
7	Avangard	30	37	39	42
8	Podolye	30	41	52	42
9	Metalurg	30	35	36	40
10	Zenit Penza	30	28	29	35
11	FK Ryazan	30	20	30	33
12	Tambov	30	38	44	31
13	Lokomotiv	30	31	42	29
14	FC Oryol	30	30	41	29
15	Metallurg	30	25	40	29
16	Metallurg	30	22	66	19

TEMPORADA 2012/2013

SEGUNDA B RUSIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Arsenal Tula	30	74	20	73
2	Fakel	30	55	33	64
3	Sokol	30	44	17	54
4	Metallurg	30	46	40	49
5	Kaluga	30	52	33	47
6	Zenit Penza	30	35	26	46
7	Podolye	30	50	40	44
8	Vityaz	30	41	42	43
9	Avangard	30	42	40	41
10	Lokomotiv	30	35	46	41
11	FK Ryazan	30	47	36	39
12	Gubkin	30	34	40	37
13	Metallurg	30	26	48	31
14	Metallurg	30	28	61	26
15	Spartak	30	28	77	21
16	FK Orel	30	18	56	11

TEMPORADA 2011/2012

SEGUNDA B RUSIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Salyut	39	78	31	83
2	Avangard	39	62	36	70
3	Vityaz	39	58	59	62
4	Metallurg	39	51	50	59
5	Lokomotiv	39	47	41	58
6	Gubkin	39	43	38	58
7	Metallurg	39	55	53	56
8	FK Orel	39	52	60	53
9	Sokol	39	56	55	52
10	Kaluga	39	37	41	52
11	Spartak	39	46	58	43
12	FK Ryazan	39	44	60	42
13	Podolye	39	33	56	35
14	Zenit Penza	39	22	46	32

TEMPORADA 2009/2010

SEGUNDA B RUSIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Torpedo	30	59	26	57
2	Gubkin	30	53	32	56
3	Metallurg	30	47	32	55
4	Fakel	30	53	28	54
5	Avangard	30	51	33	53
6	Vityaz	30	53	34	52
7	Zenit Penza	30	48	36	50
8	Metallurg	30	41	36	50
9	Lokomotiv	30	40	31	48
10	Kaluga	30	27	31	43
11	FK Ryazan	30	37	49	42
12	Saturn-2	30	40	45	37
13	FK Orel	30	44	43	31
14	Spartak	30	28	42	26
15	Znamya	30	26	71	11
16	Nika Moskva	30	11	89	3

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

6,533,112 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1475
Total Execution Time	0.1487

CADENA URL

/historico/Kaluga

GET DATOS

$_GET['/historico/Kaluga']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0033	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 = 'Kaluga' 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=13429 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=13429 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=13429 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=13429 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	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 = 74618
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13429 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2827 AND type_rel = 3
0.0029	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 = '13429' ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '13429' 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 = '13429' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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,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.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=13429 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,73402,72436,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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 74618 AND teamId = 13429
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71395 AND teamId = 13429
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72436 AND teamId = 13429
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 13429
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13429
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 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 = '13429' 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 = '13429' 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 = '13429' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029	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 = 13429 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.0026	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 = 13429 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 13429 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 13429 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.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 = 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.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 = 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.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 = 72436 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* `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.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* `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 = 67130 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.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 = 57803 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.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 = 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.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* `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 = 44473 AND t.round = 26 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* `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.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* `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.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* `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.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* `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.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 = 2867 AND t.round = 30 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* `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 = 25086 AND t.round = 30 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 = 25102 AND t.round = 39 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* `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 = 25125 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 74618 ORDER BY nameShow LIMIT 100

Kaluga

Kaluga

Selecciona un equipo

Competiciones que juega

Segunda A Rusia Grupo 4

RIVALES EN Segunda A Rusia

RIVALES EN Copa Rusa