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

FC Flora Tallin II

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Harju Laagri	8	20	6	18
2	Flora Tallin	7	15	9	15
3	Tartu Welco	7	14	5	13
4	Viimsi JK	8	16	10	13
5	Levadia	8	17	12	13
6	FC Tallinn	8	16	15	11
7	FC Elva	8	9	16	9
8	Tallinna	7	11	17	6
9	Paide II	8	4	20	4
10	Tabasalu	7	6	18	2

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 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 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 ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Maardu FC	36	92	44	78
2	Tallinna	36	95	44	74
3	Flora Tallin	36	79	42	70
4	Rakvere	36	66	61	62
5	Kuressaare	36	70	63	55
6	Levadia	36	56	60	45
7	Tartu Santos	36	75	74	43
8	Tallinna	36	60	85	43
9	FC Elva	36	40	90	29
10	Tartu Welco	36	30	100	19

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

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

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 Estonia

Pos	Equipos		Pts
1		Harju JK Laagri	18
2		FC Flora Tallin II	15
3		Tartu Welco	13
4		Viimsi JK	13
5		Levadia Tallinn II	13
6		FC Tallinn	11
7		FC Elva	9
8		Tallinna Kalev II	6
9		Paide II	4
10		Tabasalu Charma	2

	Ascenso : Harju JK Laagri
	Playoff Ascenso : FC Flora Tallin II
	Playoff Descenso : Tallinna Kalev II
	Descenso : Paide II, Tabasalu Charma

RIVALES EN Copa Estonia

RIVALES EN Segunda Estonia

USO DE MEMORIA

6,338,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1385
Total Execution Time	0.1400

CADENA URL

/historico/Flora-Tallinn-Ii

GET DATOS

$_GET['/historico/Flora-Tallinn-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0030	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 = 'Flora-Tallinn-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.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=13362 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=13362 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=13362 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=13362 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=13362 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0028	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 = '13362' ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '13362' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '13362' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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.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=13362 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (75170,71963,71432) 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.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 75170 AND teamId = 13362
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 13362
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13362
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 = '13362' 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 = '13362' 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 = '13362' 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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 13362 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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 13362 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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 13362 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 = 13362 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 = 75170 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.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* `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.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* `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.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* `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.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* `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.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 = 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.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 = 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.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* `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.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.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 = 37788 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* `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.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* `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.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* `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 = 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.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 = 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.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 = 14946 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 = 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

FC Flora Tallin II

FC Flora Tallin II

Selecciona un equipo

Competiciones que juega

Segunda Estonia

RIVALES EN Copa Estonia

RIVALES EN Segunda Estonia