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

Nõmme Kalju II

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tartu Welco	36	92	42	74
2	Tallinna	36	99	53	67
3	Trans II	36	69	48	64
4	Tartu Kalev	36	85	71	61
5	Kuressaare	36	87	76	61
6	Tulevik	36	58	55	55
7	Tammeka II	36	63	70	44
8	Nõmme Kalju	36	90	103	41
9	Läänemaa	36	67	120	26
10	Pärnu	36	34	106	14

TEMPORADA 2021/2022

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FC Tallinn	36	117	38	81
2	Tabasalu	36	120	50	79
3	Tallinna	36	88	49	66
4	Tartu Welco	36	73	46	64
5	Tammeka II	36	70	59	56
6	Legion	36	60	86	42
7	Tartu Kalev	36	54	77	41
8	Läänemaa	36	49	84	37
9	Nõmme Kalju	36	49	103	33
10	Raplamaa	36	33	121	9

TEMPORADA 2020/2021

SEGUNDA B ESTONIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Läänemaa	3	9	3	7
2	Vändra	3	8	6	4
3	Nõmme Kalju	3	4	4	4
4	Legion	3	1	9	1

TEMPORADA 2019/2020

SEGUNDA B ESTONIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Nõmme Kalju	2	4	0	34
2	Võru	2	2	3	32
3	Keila	2	2	3	29
4	Rakvere	2	1	3	10

TEMPORADA 2018/2019

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Nõmme	36	118	38	85
2	Vändra	36	97	71	68
3	Pärnu	36	82	53	62
4	Nõmme Kalju	36	79	50	61
5	Viimsi JK	36	75	68	52
6	Keila	36	67	87	46
7	Tabasalu	36	85	80	43
8	Paide II	36	61	87	39
9	Võru	36	48	101	34
10	Põhja-Talli	36	54	131	29

TEMPORADA 2017/2018

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Maardu FC	36	126	38	88
2	Flora Tallin	36	115	31	71
3	Levadia	36	67	56	61
4	FC Elva	36	51	64	55
5	Rakvere	36	59	60	52
6	Tartu Welco	36	44	78	42
7	Tartu Santos	36	47	68	41
8	Tallinna	36	37	52	39
9	Keila	36	41	88	35
10	Nõmme Kalju	36	37	89	21

TEMPORADA 2016/2017

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Nõmme Kalju	36	73	43	69
2	Tallinna	36	71	40	64
3	Vändra	36	75	67	62
4	Keila	36	74	56	60
5	Alliance FC	36	55	48	51
6	Tammeka II	36	69	63	49
7	Joker	36	58	73	46
8	Viimsi JK	36	55	64	44
9	Paide II	36	50	79	34
10	Sillamäe	36	38	85	28

TEMPORADA 2015/2016

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tulevik	36	106	38	89
2	Flora Tallin	36	78	47	68
3	Tallinna	36	98	81	56
4	Maardu FC	36	83	75	54
5	Levadia	36	81	69	50
6	Tartu Santos	36	63	70	49
7	Tallinna	36	56	58	45
8	Nõmme Kalju	36	62	86	41
9	Vändra	36	48	96	32
10	Alliance FC	36	42	97	30

TEMPORADA 2014/2015

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Flora Tallin	37	76	42	72
2	Levadia	36	118	57	71
3	Tallinna	36	108	48	66
4	Rakvere	36	52	53	47
5	Nõmme Kalju	36	50	56	46
6	Tallinna	36	47	59	46
7	Tartu Santos	37	58	83	45
8	Kiviõli	36	60	87	45
9	Kuressaare	36	48	95	37
10	Vändra	36	43	80	36

TEMPORADA 2013/2014

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Flora Tallin	36	104	40	78
2	Levadia	36	102	52	68
3	Vaprus	36	109	78	60
4	Nõmme Kalju	36	69	62	57
5	Tulevik	36	58	51	55
6	Kiviõli	36	72	82	47
7	Kuressaare	36	69	81	47
8	Rakvere	36	61	67	44
9	Vändra	36	60	72	38
10	FC Puuma	36	32	151	7

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

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rakvere	26	100	29	66
2	Nõmme Kalju	26	94	19	61
3	Sillamäe	26	102	37	54
4	Alko	26	41	40	42
5	Johvi	26	48	37	37
6	Tallinna	26	57	59	36
7	Tallinna	26	59	48	35
8	Tallinna	26	49	64	34
9	MC Tallin	26	51	74	34
10	Kaitseliit	26	47	57	29
11	Legion	26	36	58	29
12	Tabasalu	26	28	48	27
13	Olympic	26	32	108	13
14	Ajax	26	33	99	11

TEMPORADA 2009/2010

TERCERA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos

Competiciones que juega

Segunda B Estonia

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

	Ascenso : Tammeka II, Tartu Kalev
	Playoff Ascenso : Kuressaare II
	Playoff Descenso : TJK Legion, Johvi Phoenix
	Descenso : Tulevik Viljandi

RIVALES EN Segunda B Estoni.

USO DE MEMORIA

5,776,456 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1269
Total Execution Time	0.1282

CADENA URL

/historico/Nomme-Kalju-Ii

GET DATOS

$_GET['/historico/Nomme-Kalju-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0026	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 = 'Nomme-Kalju-Ii' 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=17795 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=17795 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 75178
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17795 AND type_rel = 2
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
0.0025	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 = '17795' 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 = '17795' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '17795' 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 = 75178 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=17795 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 (75178,74643,67740,67320) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75178 AND teamId = 17795
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 67740 AND teamId = 17795
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74643 AND teamId = 17795
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 17795
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 = 75178 AND t.round = 9 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 = '17795' 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 = '17795' 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 = '17795' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031	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 = 17795 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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 17795 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 = 75178 WHERE rp.league_id = 75178 AND rp.teamId = 17795 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 17795 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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 = 70894 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.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 = 66759 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.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* `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 = 61476 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.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* `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 = 65678 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.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 = 55084 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.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 = 60010 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.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 = 48714 AND t.round = 36 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* `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 = 42546 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* `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 = 37789 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* `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 = 20333 AND t.round = 36 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 = 9430 AND t.round = 36 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* `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 = 2848 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* `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.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* `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.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* `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 = 27909 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 27933 AND t.round = 26 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 = 75178 ORDER BY nameShow LIMIT 100

Nõmme Kalju II

Nõmme Kalju II

Selecciona un equipo

Competiciones que juega

Segunda B Estonia

RIVALES EN Segunda B Estoni.