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 Elva

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Harju Laagri	8	20	6	18
2	Tartu Welco	8	17	5	16
3	Flora Tallin	8	15	11	15
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	8	11	20	6
9	Tabasalu	8	8	18	5
10	Paide II	8	4	20	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 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 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 2014/2015

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Maardu FC	36	92	38	81
2	Alliance FC	36	65	29	70
3	Sillamäe	36	73	57	63
4	Joker	36	66	57	53
5	FC Elva	36	62	45	52
6	Tallinna	36	60	55	50
7	Emmaste	36	56	64	46
8	FC Puuma	36	60	89	45
9	Ararat	36	51	113	26
10	Flora Tallin	36	43	81	18

TEMPORADA 2013/2014

SEGUNDA B ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Tallinna	36	124	34	97
2	Tartu Santos	36	161	27	96
3	Emmaste	36	71	81	59
4	Sillamäe	36	74	64	55
5	Maardu FC	36	74	85	53
6	FC Elva	36	45	79	41
7	Alliance FC	36	53	77	37
8	Ararat	36	55	80	32
9	TJK Legion	36	53	111	27
10	Flora Tallin	36	44	116	24

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

TEMPORADA 2005/2006

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Levadia	36	132	24	88
2	Kuressaare	36	64	44	71
3	Tallinna	36	84	63	66
4	Flora Tallin	36	81	56	60
5	Nomme Kalju	36	76	80	59
6	TVMK Tallinn	36	66	63	56
7	Tulevik II	36	53	52	38
8	Lootus	36	46	99	33
9	Tallinna	36	44	85	27
10	FC Elva	36	20	100	15

TEMPORADA 2004/2005

SEGUNDA ESTONIA
Equipo		PJ	GF	GC	Puntos
1	Vaprus	36	92	39	84
2	Levadia	36	104	31	82
3	Ajax	36	111	30	77
4	Tallinna	36	85	71	63
5	Tervis	36	73	56	50
6	TVMK Tallinn	36	51	80	41
7	FC Elva	36	42	71	36
8	Lelle	36	49	100	34
9	Tallinna JK	36	41	100	31
10	Merkuur-Juun	36	30	100	14

Competiciones que juega

Segunda Estonia

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

	Ascenso : Harju JK Laagri
	Playoff Ascenso : Tartu Welco
	Playoff Descenso : Tallinna Kalev II
	Descenso : Tabasalu Charma, Paide II

RIVALES EN Copa Estonia

RIVALES EN Segunda Estonia

USO DE MEMORIA

6,356,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7001
Total Execution Time	0.7014

CADENA URL

/historico/Fc-Elva

GET DATOS

$_GET['/historico/Fc-Elva']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0182	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 = 'Fc-Elva' 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=61363 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=61363 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=61363 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=61363 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257	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.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61363 AND type_rel = 2
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0149	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 = '61363' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0136	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 = '61363' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137	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.0131	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 = 75170 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137	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=61363 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130	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,74589,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.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 75170 AND teamId = 61363
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 61363
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 74589 AND teamId = 61363
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61363
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 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 = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '61363' 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 = '61363' 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 = '61363' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134	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 = 61363 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.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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 61363 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 61363 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 = 61363 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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 = 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.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* `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.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 = 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.0132	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.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* `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.0132	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.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* `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.0141	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 = 9472 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 9434 AND t.round = 36 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* `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.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* `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.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* `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.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* `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
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* `tables2006` 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 = 14950 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* `tables2005` 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 = 14951 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

FC Elva

FC Elva

Selecciona un equipo

Competiciones que juega

Segunda Estonia

RIVALES EN Copa Estonia

RIVALES EN Segunda Estonia