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

Tammeka II

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 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 ESTONIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Levadia	3	7	5	35
2	Pärnu	3	5	4	29
3	Tammeka II	3	4	7	27
4	Tartu Welco	3	4	4	19

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 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

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 B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Kuressaare	36	117	48	74
2	FC Elva	36	67	39	68
3	Tartu Welco	36	74	50	64
4	Tammeka II	36	89	64	59
5	Tallinna	36	72	53	55
6	Sillamäe	36	70	61	54
7	Joker	36	74	66	52
8	Viimsi JK	36	56	64	51
9	Flora Tallin	36	27	85	20
10	Tulevik II	36	26	142	12

TEMPORADA 2012/2013

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	94	41	70
2	Johvi	36	80	39	69
3	Flora Tallin	36	56	54	57
4	Rakvere	36	68	58	56
5	Tartu SK 10	36	58	67	54
6	Tammeka II	36	70	57	52
7	Vändra	36	61	55	46
8	Tulevik	36	49	57	46
9	FC Puuma	36	40	91	29
10	Kiviõli	36	60	117	25

TEMPORADA 2011/2012

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FCI Tallinn	36	94	33	83
2	Flora Tallin	36	66	32	69
3	Rakvere	36	66	58	68
4	Tartu SK 10	36	65	58	54
5	Levadia	36	77	56	53
6	Kiviõli	36	78	83	44
7	FC Puuma	36	55	61	43
8	Tammeka II	36	55	83	37
9	Vaprus	36	43	72	36
10	Lootus	36	40	103	19

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

TEMPORADA 2007/2008

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	83	33	72
2	Kuressaare	36	67	35	69
3	Flora Tallin	36	62	41	62
4	Paide	36	58	44	54
5	Warrior	36	46	54	51
6	Kiviõli	36	51	66	44
7	Tammeka II	36	60	63	43
8	Rakvere	36	53	82	37
9	TVMK Tallinn	36	58	98	36
10	Ajax	36	57	79	30

TEMPORADA 2006/2007

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	95	20	86
2	Flora Tallin	36	97	33	78
3	Sillamäe	36	67	40	69
4	TVMK Tallinn	36	81	68	53
5	Tammeka II	36	51	39	53
6	Nomme Kalju	36	74	69	51
7	Warrior	36	72	73	44
8	Tulevik II	36	37	84	34
9	Valk Tartu	36	49	93	29
10	FC Elva	36	17	121	8

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 Segunda B Estoni.

USO DE MEMORIA

5,837,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1364
Total Execution Time	0.1384

CADENA URL

/historico/Tammeka-Ii

GET DATOS

$_GET['/historico/Tammeka-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0031	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 = 'Tammeka-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=13371 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=13371 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13371 AND type_rel = 2
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
0.0047	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 = '13371' ORDER BY l.year DESC,cat.coefficient DESC
0.0038	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 = '13371' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0043	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 = '13371' 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.0031	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=13371 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,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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 75178 AND teamId = 13371
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 13371
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 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.0022	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 = '13371' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13371' and rp.type = 4
0.0021	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 = '13371' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 13371 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.0028	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 = 13371 AND (e.action = 4 or e.action = 5) 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 = 13371 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 13371 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 = 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.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 = 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.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* `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 = 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.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 = 65707 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.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* `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.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* `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.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 = 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.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* `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.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 = 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.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* `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 = 20883 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* `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 = 14942 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 = 14943 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* `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.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* `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
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 = 14947 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* `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 = 14948 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Tammeka II

Tammeka II

Selecciona un equipo

Competiciones que juega

Segunda B Estonia

RIVALES EN Segunda B Estoni.