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

Nõmme United

Entrenador: Randin Rande

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	7	24	2	19
2	Nomme Kalju	8	18	9	17
3	FC Flora	8	16	12	13
4	Paide	7	12	8	12
5	Tammeka	7	10	5	11
6	Kuressaare	8	15	21	10
7	Tallinna	8	10	13	9
8	Vaprus	8	9	16	7
9	Nõmme	8	4	14	4
10	Narva Trans	7	7	25	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

SEGUNDA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Harju Laagri	36	97	46	76
2	Levadia	36	85	45	68
3	FC Elva	36	76	52	66
4	Viimsi JK	36	76	40	63
5	Flora Tallin	36	88	52	62
6	Nõmme	36	79	56	60
7	Paide II	36	75	88	52
8	Alliance FC	36	29	105	27
9	Tulevik	36	28	102	23
10	Pärnu	36	30	77	20

TEMPORADA 2020/2021

SEGUNDA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Maardu FC	3	7	1	73
2	Tallinna	3	7	1	71
3	Paide II	3	6	11	54
4	Nõmme	3	5	12	41

TEMPORADA 2019/2020

SEGUNDA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vaprus	5	9	6	65
2	Maardu FC	5	9	11	64
3	Nõmme	5	10	7	55
4	Flora Tallin	5	18	10	51
5	FC Elva	5	9	7	49
6	Tammeka II	5	4	18	39

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 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 1
Equipo		PJ	GF	GC	Puntos
1	Nõmme	26	158	18	71
2	Pärnu	26	102	28	60
3	Tabasalu	26	77	52	48
4	Ganvix	26	48	50	40
5	Saue JK	26	65	54	40
6	Tulevik II	26	55	71	40
7	Flora Tallin	26	43	49	34
8	Raplamaa	26	48	63	34
9	Otepää	26	63	69	32
10	Kuressaare	26	38	93	29
11	Imavere	26	42	83	29
12	Torva	26	41	67	28
13	Vaprus	26	42	66	28
14	Viimsi	26	30	89	11

TEMPORADA 2015/2016

TERCERA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Paide II	26	92	24	67
2	Keila	26	93	32	63
3	Nõmme	26	131	38	60
4	Pärnu	26	98	45	57
5	Saue JK	26	85	47	52
6	Viimsi	26	60	51	39
7	Torva	26	63	52	37
8	Imavere	26	70	77	31
9	Ganvix	26	47	59	29
10	Kuressaare	26	55	69	26
11	FC Forza	26	52	93	25
12	Ararat	26	41	101	19
13	Kose	26	20	92	10
14	Rummu	26	27	154	7

TEMPORADA 2014/2015

TERCERA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tallinna	26	130	61	63
2	Tulevik II	26	78	40	52
3	Ganvix	26	72	37	51
4	Nõmme	26	93	41	50
5	Keila	26	61	45	45
6	Viimsi JK	26	62	45	39
7	Imavere	26	59	68	37
8	Torva	26	60	47	35
9	Saue JK	26	51	57	34
10	Tondi	26	52	93	28
11	Kuressaare	26	43	66	26
12	Kose	26	48	75	26
13	Rummu	26	24	93	17
14	Metropool	26	30	95	12

TEMPORADA 2013/2014

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tallinna	24	117	43	59
2	Tallinna	24	77	27	57
3	Viimsi JK	24	60	46	37
4	Saue JK	24	52	42	36
5	Metropool	24	62	57	35
6	Keila	24	45	57	33
7	Tulevik II	24	43	49	30
8	Nõmme	24	69	75	28
9	Rummu	24	49	66	28
10	Tondi	24	44	73	28
11	Sörve	24	38	55	25
12	Läänemaa	24	36	65	25
13	MC Tallin	24	35	72	21
14	Tarvastu	0	0	0	0

TEMPORADA 2012/2013

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tartu Santos	26	138	16	73
2	Ganvix	26	57	60	48
3	Sörve	26	64	46	47
4	Nõmme	26	90	60	46
5	Jogeva	26	63	61	46
6	Rummu	26	66	56	40
7	Keila	26	67	48	39
8	Luunja	26	61	61	39
9	Tartu	26	53	75	35
10	Tulevik II	26	62	74	28
11	Tartu Welco	26	39	59	26
12	Metropool	26	41	88	25
13	Tarvastu	26	45	95	19
14	Kärdla LM	26	35	82	15

TEMPORADA 2011/2012

TERCERA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Emmaste	26	114	34	60
2	Tulevik	26	100	32	56
3	Vändra	26	68	39	51
4	FC Elva	26	65	29	50
5	Tartu	26	96	50	46
6	Paide Kumake	26	83	46	45
7	Pärnu II	26	78	75	38
8	Flora Tallin	26	76	77	37
9	Tarvastu	26	69	70	37
10	Keila	26	51	63	36
11	Ganvix	26	52	122	21
12	Sörve	26	32	72	20
13	Luunja	26	39	126	15
14	Nõmme	26	25	113	12

TEMPORADA 2010/2011

TERCERA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tartu SK 10	26	77	23	60
2	Tammeka II	26	71	29	60
3	Tulevik	26	85	42	52
4	Paide Kumake	26	64	28	52
5	Sörve	26	46	35	51
6	Luunja	26	65	52	48
7	Nõmme	26	55	56	39
8	Emmaste	26	54	46	30
9	Tartu	26	46	74	29
10	Ganvix	26	45	86	29
11	Tarvastu	26	32	67	21
12	Viljandi	26	11	28	20
13	Pärnu II	26	41	73	16
14	Rummu	26	31	84	10

TEMPORADA 2009/2010

TERCERA ESTONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tartu Santos	26	85	18	63
2	Emmaste	26	61	31	52
3	Nõmme	26	67	52	47
4	Pärnu II	26	66	53	45
5	Tarvastu	26	54	55	42
6	Tartu	26	72	51	40
7	Tammeka II	26	63	43	39
8	Tulevik II	26	52	63	35
9	Ganvix	26	66	61	31
10	Rummu	26	45	64	31
11	Vaprus	26	40	49	30
12	Sörve	26	41	50	29
13	Võru	26	40	89	23
14	FC Elva	26	13	86	9

Competiciones que juega

Liga Estonia

Pos	Equipos		Pts
1		Levadia	19
2		Nomme Kalju	17
3		FC Flora	13
4		Paide	12
5		Tammeka	11
6		Kuressaare	10
7		Tallinna Kalev	9
8		Vaprus Pärnu	7
9		Nõmme United	4
10		Narva Trans	4

	Previa de Champions (1ª Ronda) : Levadia
	: Nomme Kalju, FC Flora
	Playoff Descenso : Nõmme United
	Descenso : Narva Trans

RIVALES EN Copa Estonia

RIVALES EN Liga Estonia

USO DE MEMORIA

6,323,504 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6600
Total Execution Time	0.6612

CADENA URL

/historico/Nomme-United

GET DATOS

$_GET['/historico/Nomme-United']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0138	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-United' 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.0126	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=61381 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=61381 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=61381 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=61381 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256	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.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61381 AND type_rel = 2
0.0136	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 = '61381' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '61381' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150	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.0134	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 = 74844 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158	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=61381 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133	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 (74844,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.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 74844 AND teamId = 61381
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 70893 AND teamId = 61381
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 61381
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61381
0.0127	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 = '61381' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61381' and rp.type = 4
0.0126	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 = '61381' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0133	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 = 74844 WHERE rp.league_id = 74844 AND rp.teamId = 61381 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.0136	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 = 74844 WHERE rp.league_id = 74844 AND rp.teamId = 61381 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 74844 WHERE rp.league_id = 74844 AND rp.teamId = 61381 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 61381 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142	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 = 74844 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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.0136	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 = 66758 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.0130	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 = 61475 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.0129	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 = 65706 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.0128	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 = 55083 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.0127	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 = 60120 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.0129	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.0129	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.0128	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 = 38034 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 22220 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 11806 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 9435 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 27884 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 27900 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 27913 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 27928 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nõmme United

Nõmme United

Selecciona un equipo

Competiciones que juega

Liga Estonia

RIVALES EN Copa Estonia

RIVALES EN Liga Estonia