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

East Fife

Entrenador: Greig McDonald

Temporada 2023/2024

TEMPORADA 2023/2024

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Stenhousemui	35	50	29	68
2	Peterhead	35	56	38	57
3	Dumbarton	35	55	42	57
4	Spartans	35	51	42	55
5	East Fife	35	45	45	44
6	Forfar	35	38	41	42
7	Elgin City	35	35	56	40
8	Bonnyrigg	35	43	48	36
9	Clyde	35	43	58	35
10	Stranraer	35	36	53	33

TEMPORADA 2022/2023

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Stirling	36	67	37	73
2	Dumbarton	36	49	39	62
3	Annan	36	61	51	51
4	East Fife	36	54	50	50
5	Forfar	36	37	43	48
6	Stenhousemui	36	51	55	47
7	Stranraer	36	43	57	45
8	Bonnyrigg	36	36	47	42
9	Elgin City	36	44	62	40
10	Albion	36	47	48	39

TEMPORADA 2021/2022

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Cove Rangers	36	73	32	79
2	Airdrieonian	36	68	37	72
3	Montrose	36	53	36	59
4	Queen's Park	36	51	36	51
5	Alloa	36	49	57	45
6	Falkirk	36	49	55	44
7	Peterhead	36	46	51	42
8	Clyde	36	39	62	39
9	Dumbarton	36	48	71	34
10	East Fife	36	31	70	23

TEMPORADA 2020/2021

LEAGUE ONE ESCOCIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Peterhead	4	9	6	6
2	Forfar	4	6	6	6
3	East Fife	4	7	8	6
4	Clyde	4	5	6	6
5	Dumbarton	4	5	6	6

TEMPORADA 2019/2020

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Raith Rovers	28	49	33	53
2	Falkirk	28	54	18	52
3	Airdrieonian	28	38	27	48
4	Montrose	28	48	38	47
5	East Fife	28	44	36	45
6	Dumbarton	28	35	44	38
7	Clyde	28	35	43	34
8	Peterhead	27	30	44	26
9	Forfar	28	26	47	24
10	Stranraer	27	28	57	16

TEMPORADA 2018/2019

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Arbroath	36	63	38	70
2	Forfar	36	54	47	63
3	Raith Rovers	36	75	49	60
4	Airdrieonian	36	51	44	48
5	Montrose	35	46	50	48
6	Dumbarton	36	60	60	46
7	East Fife	36	49	56	46
8	Stranraer	36	45	57	42
9	Stenhousemui	36	35	61	37
10	Brechin City	35	42	58	36

TEMPORADA 2017/2018

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Ayr United	36	92	42	76
2	Raith Rovers	36	68	32	75
3	Alloa	36	56	43	60
4	Arbroath	36	70	51	59
5	Stranraer	36	58	66	53
6	East Fife	36	49	67	42
7	Airdrieonian	36	46	60	41
8	Forfar	36	40	65	38
9	Queen's Park	36	42	72	31
10	Albion	36	57	80	30

TEMPORADA 2016/2017

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Livingston	36	80	32	81
2	Alloa	36	69	44	62
3	Airdrieonian	36	61	66	52
4	Brechin City	36	43	49	50
5	East Fife	36	41	44	46
6	Queen's Park	36	37	51	46
7	Stranraer	36	46	50	44
8	Albion	36	41	48	42
9	Peterhead	36	44	59	40
10	Stenhousemui	36	45	64	39

TEMPORADA 2015/2016

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	East Fife	36	62	41	62
2	Elgin City	36	59	46	59
3	Clyde	36	56	45	57
4	Queen's Park	36	46	32	56
5	Annan	36	69	57	56
6	Berwick	36	45	50	49
7	Stirling	36	47	46	48
8	Montrose	36	50	70	43
9	Arbroath	36	42	51	39
10	East	36	41	79	32

TEMPORADA 2014/2015

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Albion	36	61	33	71
2	Queen's Park	36	51	34	61
3	Arbroath	36	65	46	56
4	East Fife	36	56	48	53
5	Annan	36	56	56	50
6	Clyde	36	40	50	47
7	Elgin City	36	55	58	45
8	Berwick	36	60	57	43
9	East	36	40	66	43
10	Montrose	36	42	78	33

TEMPORADA 2013/2014

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	36	106	18	102
2	Dunfermline	36	68	54	63
3	Stranraer	36	57	57	51
4	Ayr United	36	65	66	49
5	Stenhousemui	36	57	66	48
6	Airdrieonian	36	47	57	45
7	Forfar	36	55	62	43
8	Brechin City	36	57	71	42
9	East Fife	36	31	69	32
10	Arbroath	36	52	75	31

TEMPORADA 2012/2013

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Queen South	36	92	23	92
2	Alloa	36	62	35	67
3	Brechin City	36	72	59	61
4	Forfar	36	67	74	54
5	Arbroath	36	47	57	52
6	Stenhousemui	36	59	59	49
7	Ayr United	36	53	65	41
8	Stranraer	36	43	71	37
9	East Fife	36	50	65	32
10	Albion	36	45	82	24

TEMPORADA 2011/2012

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Cowdenbeath	36	68	29	71
2	Arbroath	36	76	51	63
3	Dumbarton	36	61	61	58
4	Airdrieonian	36	68	60	52
5	Stenhousemui	36	54	49	51
6	East Fife	36	55	57	48
7	Forfar	36	59	72	42
8	Brechin City	36	47	62	41
9	Albion	36	43	66	37
10	Stirling	36	46	70	34

TEMPORADA 2010/2011

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Livingston	36	78	33	80
2	Ayr United	36	62	55	59
3	Forfar	36	50	48	59
4	Brechin City	36	63	45	57
5	East Fife	36	77	60	52
6	Airdrieonian	36	52	60	48
7	Dumbarton	36	52	69	41
8	Stenhousemui	36	46	59	38
9	Alloa	36	49	71	36
10	Peterhead	36	47	76	26

TEMPORADA 2009/2010

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Stirling	36	68	48	65
2	Alloa	36	49	35	65
3	Cowdenbeath	36	60	41	59
4	Brechin City	36	50	45	54
5	Peterhead	36	45	49	51
6	Dumbarton	36	49	58	48
7	East Fife	36	46	53	41
8	Stenhousemui	36	38	42	40
9	Arbroath	36	41	55	40
10	Clyde	36	37	57	31

TEMPORADA 2008/2009

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Raith Rovers	36	60	27	76
2	Ayr United	36	71	38	74
3	Brechin City	36	51	45	62
4	Peterhead	36	54	39	56
5	Stirling	36	59	49	53
6	East Fife	36	39	44	44
7	Arbroath	36	44	46	41
8	Alloa	36	47	59	41
9	Queen's Park	36	35	54	33
10	Stranraer	36	31	90	16

TEMPORADA 2007/2008

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	East Fife	36	77	24	88
2	Stranraer	36	65	43	65
3	Montrose	36	59	36	59
4	Arbroath	36	54	47	52
5	Stenhousemui	36	50	59	48
6	Elgin City	36	56	68	47
7	Albion	36	51	68	37
8	Dumbarton	36	31	48	37
9	East	36	48	71	34
10	Forfar	36	35	62	33

TEMPORADA 2006/2007

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Berwick	36	51	29	75
2	Arbroath	36	61	33	70
3	Queen's Park	36	57	28	68
4	East Fife	36	59	37	67
5	Dumbarton	36	52	37	59
6	Albion	36	56	61	48
7	Stenhousemui	36	53	63	44
8	Montrose	36	42	62	37
9	Elgin City	36	39	69	29
10	East	36	27	78	21

TEMPORADA 2005/2006

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Cowdenbeath	36	81	34	76
2	Berwick	36	54	27	76
3	Stenhousemui	36	78	38	73
4	Arbroath	36	57	47	55
5	Elgin City	36	55	58	52
6	Queen's Park	36	47	42	51
7	East Fife	36	48	64	43
8	Albion	36	39	60	29
9	Montrose	36	31	59	28
10	East	36	28	89	23

Competiciones que juega

League Two Escocia

Pos	Equipos		Pts
1		Stenhousemuir	68
2		Peterhead	57
3		Dumbarton	57
4		Spartans	55
5		East Fife	44
6		Forfar Athletic	42
7		Elgin City	40
8		Bonnyrigg Rose	36
9		Clyde	35
10		Stranraer	33

	Ascenso : Stenhousemuir
	Playoff Ascenso : Peterhead, Dumbarton, Spartans
	Playoff Descenso : Stranraer

RIVALES EN Challenge Cup Es.

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN League Two Escoc.

USO DE MEMORIA

7,425,952 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.1733
Total Execution Time	0.1755

CADENA URL

/historico/East-Fife

GET DATOS

$_GET['/historico/East-Fife']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0049	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 = 72458
0.0026	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 = 72126
0.0026	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 = 72523
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3006 AND type_rel = 2
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=105 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 105 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (993054,986341,823337,822097,808283) ORDER BY n.cover_points DESC, update_date DESC
0.0046	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 = '3006' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 72523 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72126 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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 = 73404 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 = 72458 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0087	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=3006 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 (73404,72523,72458,72126,71643,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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72458 AND teamId = 3006
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 3006
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72523 AND teamId = 3006
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 72126 AND teamId = 3006
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71643 AND teamId = 3006
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3006
0.0039	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 = 72458 WHERE rp.league_id = 72458 AND rp.teamId = 3006 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.0035	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 = 72458 WHERE rp.league_id = 72458 AND rp.teamId = 3006 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042	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 = 72458 WHERE rp.league_id = 72458 AND rp.teamId = 3006 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0058	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 = 3006 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72458 AND t.round = 35 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* `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 = 67943 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* `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 = 63084 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* `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 = 57747 AND t.round = 18 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* `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 = 62236 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.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* `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 = 50156 AND t.round = 28 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 = 43926 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 33317 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 = 15718 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* `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 = 4153 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 = 2457 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 = 2026 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 1626 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* `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 = 1088 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 2602 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* `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 = 2601 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* `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 = 643 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* `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 = 644 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* `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 = 645 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

East Fife

East Fife

Selecciona un equipo

Competiciones que juega

League Two Escocia

RIVALES EN Challenge Cup Es.

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN League Two Escoc.