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

TJK Legion

Entrenador: Denis Belov

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tartu Kalev	8	22	13	17
2	Tammeka II	8	16	7	17
3	Kuressaare	8	16	13	16
4	Trans II	8	17	11	14
5	Nõmme Kalju	8	24	18	12
6	TJK Legion	8	15	12	10
7	Läänemaa	8	17	21	10
8	Pärnu	8	13	20	10
9	Tulevik	8	11	22	4
10	Johvi	8	13	27	4

TEMPORADA 2022/2023

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Nõmme	36	114	29	90
2	Viimsi JK	36	67	35	71
3	Flora Tallin	36	86	53	69
4	Levadia	36	57	46	57
5	Tabasalu	36	81	70	55
6	FC Tallinn	36	72	65	52
7	Paide II	36	66	82	41
8	FC Elva	36	45	75	40
9	TJK Legion	36	37	97	21
10	Alliance FC	36	50	123	20

TEMPORADA 2021/2022

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FC Flora	36	94	21	97
2	Levadia	36	74	25	79
3	Paide	36	84	37	65
4	Nomme Kalju	36	59	30	65
5	Kuressaare	36	49	51	50
6	Tammeka	36	38	57	39
7	Narva Trans	36	43	58	38
8	Tallinna	36	42	92	35
9	TJK Legion	36	34	82	22
10	Vaprus	36	32	96	11

TEMPORADA 2020/2021

LIGA ESTONIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Levadia	32	84	38	78
2	FC Flora	32	90	23	77
3	Paide	32	66	35	62
4	Nomme Kalju	32	57	44	45
5	TJK Legion	32	49	48	40
6	Narva Trans	32	36	61	33

TEMPORADA 2019/2020

LIGA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	TJK Legion	30	26	44	31
2	Narva Trans	30	31	49	25
3	Kuressaare	30	28	63	24
4	Tallinna	30	20	68	20

TEMPORADA 2018/2019

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	TJK Legion	36	129	35	94
2	Flora Tallin	36	85	37	73
3	Vaprus	36	73	48	67
4	Tammeka II	36	59	55	58
5	FC Elva	36	67	63	56
6	Levadia	36	80	65	53
7	Alliance FC	36	51	82	40
8	Rakvere	36	35	98	28
9	Tallinna	36	38	84	25
10	Tartu Welco	36	39	89	24

TEMPORADA 2017/2018

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	TJK Legion	36	125	30	98
2	Tammeka II	36	108	40	72
3	Alliance FC	36	80	39	69
4	Pärnu	36	80	51	61
5	Nõmme	36	99	57	60
6	Võru	36	80	66	54
7	Vändra	36	61	96	38
8	Paide II	36	45	94	28
9	Flora Tallin	36	33	138	16
10	Ajax	36	35	135	16

TEMPORADA 2016/2017

TERCERA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	TJK Legion	26	119	40	60
2	Levadia III	26	97	50	52
3	Jogeva	26	71	53	50
4	Merkuur	26	84	68	50
5	Võru	26	55	30	45
6	Ajax	26	68	67	45
7	Tallinna	26	57	36	41
8	Narva United	26	57	74	39
9	JK Piraaja	26	43	51	34
10	Maardu II	26	72	72	32
11	Tartu Santos	26	64	84	24
12	Maardu	26	39	77	23
13	Ararat	26	36	74	17
14	Järve	26	13	99	6

TEMPORADA 2015/2016

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Merkuur	26	99	51	55
2	Ajax	26	55	39	51
3	Johvi	26	67	33	50
4	Tabasalu	26	63	48	45
5	Narva United	26	84	58	43
6	Levadia III	26	58	51	39
7	Tallinna	26	50	52	38
8	Võru	26	47	48	34
9	Jogeva	26	66	65	29
10	TJK Legion	26	55	62	29
11	Tartu Santos	26	57	68	26
12	JK Piraaja	26	33	61	22
13	Kuusalu Rada	26	32	85	20
14	Kiviõli	26	24	69	19

TEMPORADA 2014/2015

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Paide II	26	81	41	61
2	Tartu Welco	26	64	36	56
3	Johvi	26	69	38	54
4	Luunja	26	76	42	53
5	Visadus	26	80	55	51
6	Tabasalu	26	57	67	37
7	Võru	26	56	57	36
8	JK Piraaja	26	42	53	33
9	Tallinna	26	42	52	30
10	Jogeva	26	53	75	27
11	Kuusalu Rada	26	45	67	23
12	Levadia III	26	48	61	19
13	Ajax	26	42	69	18
14	TJK Legion	26	42	84	17

TEMPORADA 2013/2014

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tallinna	36	124	34	97
2	Tartu Santos	36	161	27	96
3	Emmaste	36	71	81	59
4	Sillamäe	36	74	64	55
5	Maardu FC	36	74	85	53
6	FC Elva	36	45	79	41
7	Alliance FC	36	53	77	37
8	Ararat	36	55	80	32
9	TJK Legion	36	53	111	27
10	Flora Tallin	36	44	116	24

TEMPORADA 2012/2013

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Nõmme Kalju	36	91	37	82
2	Vaprus	36	114	55	79
3	Sillamäe	36	81	53	66
4	Ararat	36	77	50	63
5	Emmaste	36	69	45	61
6	FC Elva	36	60	64	49
7	TJK Legion	36	55	81	41
8	Tallinna	36	42	86	31
9	Flora Tallin	36	40	107	26
10	Alliance FC	36	28	79	17

TEMPORADA 2011/2012

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Johvi	26	79	16	66
2	Nõmme Kalju	26	64	34	53
3	Sillamäe	26	82	26	51
4	TJK Legion	26	63	38	49
5	Ararat	26	58	46	43
6	Tallinna	26	58	46	41
7	Alko	26	65	74	33
8	Ajax	26	42	42	32
9	Maardu FC	26	62	61	31
10	Tallinna	26	45	49	31
11	Kaitseliit	26	56	61	29
12	Tallinna	26	26	59	21
13	MC Tallin	26	48	115	20
14	Velldoris	26	29	110	9

TEMPORADA 2010/2011

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tallinna	36	102	39	73
2	FCI Tallinn	36	101	47	68
3	Kiviõli	36	73	61	67
4	Levadia	36	67	43	60
5	Flora Tallin	36	70	51	58
6	FC Puuma	36	81	72	54
7	Lootus	36	59	75	38
8	Vaprus	36	55	63	35
9	TJK Legion	36	44	104	27
10	Warrior	36	34	131	16

TEMPORADA 2009/2010

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	107	28	89
2	Flora Tallin	36	93	45	72
3	Ajax	36	71	38	69
4	Kiviõli	36	89	72	60
5	Tallinna	36	67	65	53
6	TJK Legion	36	60	81	40
7	Vaprus	36	57	78	37
8	Warrior	36	57	93	33
9	Rakvere	36	45	99	28
10	Johvi	36	35	82	22

TEMPORADA 2008/2009

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	96	21	86
2	Lootus	36	88	48	74
3	Warrior	36	68	63	65
4	Ajax	36	75	53	64
5	Kiviõli	36	77	77	53
6	TJK Legion	36	63	76	44
7	Vaprus	36	64	77	39
8	Tulevik II	36	49	79	36
9	Flora Tallin	36	35	64	32
10	Rakvere	36	48	105	26

Competiciones que juega

Segunda B Estonia

Pos	Equipos		Pts
1		Tartu Kalev	17
2		Tammeka II	17
3		Kuressaare II	16
4		Trans II	14
5		Nõmme Kalju II	12
6		TJK Legion	10
7		Läänemaa Haapsalu	10
8		Pärnu Jalgpalliklubi	10
9		Tulevik Viljandi	4
10		Johvi Phoenix	4

	Ascenso : Tartu Kalev, Tammeka II
	Playoff Ascenso : Kuressaare II
	Playoff Descenso : Pärnu Jalgpalliklubi, Tulevik Viljandi
	Descenso : Johvi Phoenix

RIVALES EN Copa Estonia

RIVALES EN Segunda B Estoni.

USO DE MEMORIA

6,317,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1795
Total Execution Time	0.1806

CADENA URL

/historico/Tjk-Legion

GET DATOS

$_GET['/historico/Tjk-Legion']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0037	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 = 'Tjk-Legion' 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.0020	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=61366 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=61366 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=61366 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=61366 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0048	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 = 71963
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61366 AND type_rel = 2
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
0.0044	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 = '61366' ORDER BY l.year DESC,cat.coefficient DESC
0.0052	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 = '61366' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0040	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 = '61366' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032	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 = 71963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 75178 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=61366 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023	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 (75178,71963,71432,70893) 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.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 70893 AND teamId = 61366
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 75178 AND teamId = 61366
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 61366
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61366
0.0026	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 = '61366' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61366' and rp.type = 4
0.0024	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 = '61366' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0051	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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 61366 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.0045	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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 61366 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 61366 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 61366 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75178 AND t.round = 9 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 = 70893 AND t.round = 36 ORDER BY team.conference ASC,t.position 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* `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 = 66756 AND t.round = 36 ORDER BY team.conference ASC,t.position 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* `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 = 61105 AND t.round = 27 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* `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 = 65520 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.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* `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 = 55082 AND t.round = 27 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* `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 = 60124 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 48713 AND t.round = 36 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* `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 = 42641 AND t.round = 36 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* `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 = 38036 AND t.round = 26 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* `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 = 22219 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058	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 = 11805 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 9434 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 15379 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 27899 AND t.round = 26 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* `tables2011` 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 = 14944 AND t.round = 36 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* `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 = 14945 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 14946 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

TJK Legion

TJK Legion

Selecciona un equipo

Competiciones que juega

Segunda B Estonia

RIVALES EN Copa Estonia

RIVALES EN Segunda B Estoni.