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

Stranraer

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 TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Kelty Hearts	36	68	28	81
2	Forfar	36	57	36	60
3	Annan	36	64	51	59
4	Edinburgh	36	43	49	52
5	Stenhousemui	36	47	46	49
6	Stranraer	36	50	54	47
7	Stirling	36	41	46	42
8	Albion	36	37	58	39
9	Elgin City	36	33	51	37
10	Cowdenbeath	36	28	49	29

TEMPORADA 2020/2021

LEAGUE TWO ESCOCIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Elgin City	4	10	6	9
2	Stranraer	4	6	7	7
3	Queen's Park	4	6	5	6
4	Stirling	4	5	7	4
5	Edinburgh	4	3	5	3

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 ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Dunfermline	36	83	30	79
2	Ayr United	36	65	47	61
3	Peterhead	36	72	47	59
4	Stranraer	36	43	49	51
5	Airdrieonian	36	48	50	49
6	Albion	36	40	44	49
7	Brechin City	36	47	59	42
8	Stenhousemui	36	46	80	40
9	Cowdenbeath	36	46	72	39
10	Forfar	36	48	60	34

TEMPORADA 2014/2015

LEAGUE ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Greenock	36	65	40	69
2	Stranraer	36	59	38	67
3	Forfar	36	59	41	66
4	Brechin City	36	58	46	59
5	Airdrieonian	36	53	39	58
6	Peterhead	36	51	54	51
7	Dunfermline	36	46	48	48
8	Ayr United	36	45	60	34
9	Stenhousemui	36	42	63	29
10	Stirling	36	35	84	20

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 TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Alloa	36	70	39	77
2	Queen's Park	36	70	48	63
3	Stranraer	36	77	57	58
4	Elgin City	36	68	60	57
5	Peterhead	36	51	53	51
6	Annan	36	53	53	49
7	Berwick	36	61	58	48
8	Montrose	36	58	75	38
9	Clyde	36	35	50	35
10	East	36	38	88	24

TEMPORADA 2010/2011

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Arbroath	36	80	61	66
2	Albion	36	56	40	61
3	Queen's Park	36	57	43	59
4	Annan	36	58	45	59
5	Stranraer	36	72	57	57
6	Berwick	36	62	56	49
7	Elgin City	36	53	63	45
8	Montrose	36	47	61	37
9	East	36	33	62	34
10	Clyde	36	37	67	32

TEMPORADA 2009/2010

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Livingston	36	63	25	78
2	Forfar	36	59	44	63
3	East	36	50	46	61
4	Queen's Park	36	42	42	51
5	Albion	36	35	35	50
6	Berwick	36	46	50	50
7	Stranraer	36	48	54	47
8	Annan	36	41	42	43
9	Elgin City	36	46	59	34
10	Montrose	36	30	63	24

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 ONE ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Greenock	36	76	32	77
2	Stirling	36	67	39	69
3	Raith Rovers	36	50	33	62
4	Brechin City	36	61	45	60
5	Ayr United	36	46	47	50
6	Cowdenbeath	36	59	56	45
7	Alloa	36	47	70	42
8	Peterhead	36	60	62	41
9	Stranraer	36	45	74	39
10	Forfar	36	37	90	19

TEMPORADA 2005/2006

CHAMPIONSHIP ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	St. Mirren	36	52	28	76
2	Johnstone	36	59	34	66
3	Hamilton	36	53	39	59
4	Ross County	36	47	40	56
5	Clyde	36	54	42	55
6	Airdrieonian	36	57	43	45
7	Dundee	36	43	50	43
8	Queen South	36	31	54	33
9	Stranraer	36	33	53	29
10	Brechin City	36	28	74	17

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,386,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1850
Total Execution Time	0.1863

CADENA URL

/historico/Stranraer

GET DATOS

$_GET['/historico/Stranraer']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0044	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 = 'Stranraer' 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=3000 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=3000 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=3000 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=3000 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=3000 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=3000 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=3000 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=3000 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=3000 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=3000 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=3000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3000 AND type_rel = 2
0.0052	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3000 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0035	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 = '3000' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '3000' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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.0034	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=3000 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 (73404,72523,72458,72126,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72458 AND teamId = 3000
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 3000
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72523 AND teamId = 3000
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72126 AND teamId = 3000
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3000
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 = 72458 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '3000' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0025	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3000' and rp.type = 4
0.0023	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 = '3000' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 3000 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.0049	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 = 3000 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 3000 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 = 3000 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* `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.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 = 63086 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 = 57748 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 = 62239 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* `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.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* `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.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 = 38777 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 = 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 = 15716 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* `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 = 4139 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.0051	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 = 1630 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 = 1629 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* `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 = 1628 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* `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.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* `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.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* `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 = 634 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* `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 = 622 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72458 ORDER BY nameShow LIMIT 100

Stranraer

Stranraer

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.