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

Resultados de Fútbol

Tulevik Viljandi

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tammeka II	8	16	7	17
2	Kuressaare	8	16	13	16
3	Tartu Kalev	7	20	12	14
4	Trans II	8	17	11	14
5	TJK Legion	7	14	10	10
6	Läänemaa	8	17	21	10
7	Pärnu	8	13	20	10
8	Nõmme Kalju	7	18	16	9
9	Johvi	7	11	21	4
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 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

LIGA ESTONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kuressaare	30	39	47	34
2	Tulevik	29	39	62	30
3	Tammeka	30	34	72	25
4	Vaprus	29	24	88	15

TEMPORADA 2019/2020

LIGA ESTONIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Tammeka	28	33	44	32
2	Tulevik	28	30	46	31

TEMPORADA 2018/2019

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FC Flora	36	110	21	90
2	Levadia	36	98	32	78
3	Nomme Kalju	36	79	34	77
4	Paide	36	78	30	74
5	Tammeka	36	57	62	49
6	Narva Trans	36	57	49	48
7	Tulevik	36	35	75	28
8	Tallinna	36	29	89	24
9	Kuressaare	36	24	87	23
10	Maardu FC	36	30	118	17

TEMPORADA 2017/2018

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Nomme Kalju	36	114	32	86
2	Levadia	36	109	26	84
3	FC Flora	36	116	32	83
4	Narva Trans	36	76	57	61
5	Paide	36	64	74	51
6	Tammeka	36	56	58	49
7	Tulevik	36	37	100	29
8	Tallinna	36	54	68	28
9	Kuressaare	36	34	115	21
10	Vaprus	36	25	123	13

TEMPORADA 2016/2017

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FC Flora	36	100	28	90
2	Levadia	36	106	20	84
3	Nomme Kalju	36	101	32	78
4	FCI Tallinn	36	103	47	65
5	Narva Trans	36	46	63	45
6	Paide	36	47	88	38
7	Tammeka	36	40	63	37
8	Sillamäe	36	52	76	36
9	Tulevik	36	34	95	28
10	Vaprus	36	29	146	8

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

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FC Flora	36	72	24	84
2	Levadia	37	78	32	77
3	Nomme Kalju	36	69	36	71
4	FCI Tallinn	37	50	32	63
5	Sillamäe	36	63	43	59
6	Narva Trans	36	50	46	49
7	Paide	36	50	73	33
8	Vaprus	36	38	87	26
9	Tammeka	36	39	96	25
10	Tulevik	36	35	75	22

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

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

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	FC Flora	36	104	32	91
2	Levadia	36	100	16	86
3	Narva Trans	36	67	31	74
4	Nomme Kalju	36	59	42	62
5	Sillamäe	35	79	52	59
6	Tammeka	36	50	66	40
7	Tulevik	36	33	62	29
8	Paide	36	30	79	26
9	Kuressaare	35	32	93	21
10	Lootus	36	22	103	20

TEMPORADA 2008/2009

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	121	23	97
2	Narva Trans	36	82	29	76
3	Sillamäe	36	85	40	76
4	FC Flora	36	79	31	72
5	Nomme Kalju	35	65	47	54
6	Tulevik	36	55	49	51
7	Tammeka	36	29	86	24
8	Kuressaare	35	21	99	24
9	Paide	36	21	97	22
10	Tallinna	36	32	89	16

TEMPORADA 2007/2008

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	105	22	93
2	FC Flora	36	113	28	91
3	FC TVMK	36	91	47	66
4	Narva Trans	36	62	54	56
5	Nomme Kalju	36	65	64	55
6	Sillamäe	36	49	79	45
7	Tammeka	36	45	76	31
8	Tulevik	36	31	74	31
9	Tallinna	36	37	70	26
10	Vaprus	36	41	125	17

TEMPORADA 2006/2007

LIGA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	126	20	91
2	FC Flora	36	108	30	83
3	FC TVMK	36	116	36	79
4	Narva Trans	36	89	28	78
5	Tammeka	36	54	40	62
6	Tallinna	36	44	77	43
7	Tulevik	36	43	80	37
8	Vaprus	36	35	96	25
9	Kuressaare	36	25	94	18
10	Ajax	36	14	153	5

Competiciones que juega

Segunda B Estonia

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

	Ascenso : Tammeka II, Kuressaare II
	Playoff Ascenso : Tartu Kalev
	Playoff Descenso : Nõmme Kalju II, Johvi Phoenix
	Descenso : Tulevik Viljandi

RIVALES EN Copa Estonia

RIVALES EN Segunda B Estoni.

USO DE MEMORIA

6,347,520 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1363
Total Execution Time	0.1375

CADENA URL

/historico/Tulevik-Viljandi

GET DATOS

$_GET['/historico/Tulevik-Viljandi']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0042	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 = 'Tulevik-Viljandi' 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=13354 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=13354 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=13354 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=13354 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1605 AND type_rel = 3
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 = '13354' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '13354' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 71963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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.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=13354 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,71963,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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 75178 AND teamId = 13354
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 13354
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 13354
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 = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '13354' 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 = '13354' 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 = '13354' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 13354 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.0027	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 = 13354 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 13354 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 13354 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 = 8 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 = 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.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* `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.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 = 65519 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* `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.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* `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 = 60126 AND t.round = 1 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* `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 = 48712 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* `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 = 42545 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* `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 = 37786 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 = 9471 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* `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.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* `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.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* `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.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 = 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.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 = 1001 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* `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 = 10353 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* `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 = 10352 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 = 10351 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Tulevik Viljandi

Tulevik Viljandi

Selecciona un equipo

Competiciones que juega

Segunda B Estonia

RIVALES EN Copa Estonia

RIVALES EN Segunda B Estoni.