30 Abr 69	Finalizado	Arbroath	0 - 2	Airdrieonians
19 Abr 69	Finalizado	Arbroath	1 - 1	Clyde
12 Abr 69	Finalizado	Heart of Midlothian	2 - 2	Arbroath
05 Abr 69	Finalizado	Partick Thistle	2 - 1	Arbroath
29 Mar 69	Finalizado	Arbroath	1 - 2	St. Johnstone
22 Mar 69	Finalizado	Arbroath	3 - 0	Falkirk
18 Mar 69	Finalizado	Clyde	3 - 1	Arbroath
15 Mar 69	Finalizado	Hibernian FC	1 - 2	Arbroath
11 Mar 69	Finalizado	Rangers FC	2 - 0	Arbroath
08 Mar 69	Finalizado	Arbroath	2 - 1	Aberdeen
05 Mar 69	Finalizado	Celtic	7 - 1	Arbroath
15 Feb 69	Finalizado	Arbroath	0 - 1	Dunfermline Athletic FC
08 Feb 69	Finalizado	Dundee	3 - 0	Arbroath
01 Feb 69	Finalizado	Arbroath	0 - 1	Raith Rovers
18 Ene 69	Finalizado	Kilmarnock	1 - 0	Arbroath
11 Ene 69	Finalizado	Arbroath	3 - 1	Dundee United
04 Ene 69	Finalizado	Arbroath	3 - 1	Greenock Morton
02 Ene 69	Finalizado	St. Mirren	2 - 1	Arbroath
21 Dic 68	Finalizado	Arbroath	2 - 3	Heart of Midlothian
14 Dic 68	Finalizado	Arbroath	2 - 2	Partick Thistle
07 Dic 68	Finalizado	St. Johnstone	5 - 1	Arbroath
30 Nov 68	Finalizado	Falkirk	2 - 2	Arbroath
23 Nov 68	Finalizado	Arbroath	3 - 4	Hibernian FC
16 Nov 68	Finalizado	Aberdeen	2 - 2	Arbroath
09 Nov 68	Finalizado	Arbroath	0 - 5	Celtic
02 Nov 68	Finalizado	Arbroath	1 - 5	Rangers FC
26 Oct 68	Finalizado	Dunfermline Athletic FC	2 - 0	Arbroath
19 Oct 68	Finalizado	Arbroath	1 - 2	Dundee
12 Oct 68	Finalizado	Raith Rovers	3 - 1	Arbroath
05 Oct 68	Finalizado	Arbroath	1 - 2	Kilmarnock
28 Sep 68	Finalizado	Dundee United	4 - 2	Arbroath
21 Sep 68	Finalizado	Greenock Morton	5 - 1	Arbroath
14 Sep 68	Finalizado	Arbroath	1 - 1	St. Mirren
07 Sep 68	Finalizado	Airdrieonians	2 - 0	Arbroath

Copa de la Liga de Escocia »

27 Ago 69	Finalizado	Arbroath	1 - 3	Falkirk
23 Ago 69	Finalizado	Stirling Albion	4 - 1	Arbroath
20 Ago 69	Finalizado	Arbroath	1 - 0	Forfar Athletic
16 Ago 69	Finalizado	Falkirk	1 - 2	Arbroath
13 Ago 69	Finalizado	Forfar Athletic	2 - 1	Arbroath
09 Ago 69	Finalizado	Arbroath	2 - 3	Stirling Albion

Noticias de Liga Escocia

Ver últimas noticias

30 años del cabezazo que acabó en 3 meses de cárcel

BeSoccer - Miércoles, 17 Abril 2024

3 8.019

Duncan Ferguson propició un cabezazo a Jock McStay en el Rangers 4-0 Raith Rovers del 16 de abril de 1994. Dicha acción significó una pena de 3 meses de prisión para el delantero escocés que también pasó por Everton y Newcastle.

¿Está roto el sistema de cesiones del fútbol?

David Caravaca - Miércoles, 10 Abril 2024

6 7.444

Fábio Silva afronta una recta final de temporada en la que experimenta su tercer destino como cedido por los Wolves desde que llegó a la Premier League por 40 millones de euros procedente del Oporto. Jorge Mendes, el archiconocido superagente, logró venderle por el cuádruple de su cláusula de rescisión en una operación que fue fructífera para todos menos para el joven jugador, que, con 21 años, no ha encontrado aún la continuidad en la élite.

Con faldas y a lo loco

BeSoccer - Domingo, 07 Abril 2024

1 922

El Rangers rescató un punto en el minuto 93 en el 'Old Firm' ante el Celtic. En un duelo dominado por los visitantes en la primera parte, los dos grandes del fútbol escocés dejaron un final de auténtica locura que mantiene el punto de diferencia en el liderato de los católicos sobre los protestantes que, eso sí, tienen un partido menos.

El Celtic rinde homenaje a su origen con una línea de ropa especial

BeSoccer - Miércoles, 13 Marzo 2024

1 5.387

El Celtic de Glasgow celebra sus 135 años de historia con el lanzamiento de una línea de ropa que hace referencia a los orígenes irlandeses del equipo. Se creó en el siglo XIX, cuando el hermano Walfrid, un marista de este país, quiso fundar un club para ayudar a paliar la pobreza al este de Glasgow a través de la institución Poor Children's Dinner Table. Lo que no sabía era que había hecho nacer una entidad legendaria.

Hart colgará los guantes a final de temporada

BeSoccer - Jueves, 22 Febrero 2024

0 2.864

Joe Hart, actual portero del Celtic, anunció que se retirará del fútbol profesional al final de la presente temporada. El guardameta inglés fue un mítico futbolista del Manchester City, donde militó hasta 10 temporadas. También jugó en el Torino, West Ham, Burnley o Tottenham, entre otros.

Ver más noticias del equipo»

Competiciones que juega

Liga Escocia

Pos	Equipos		Pts
1		Celtic	77
2		Rangers FC	70
3		Dunfermline Athletic FC	64
4		Dundee United	60
5		Kilmarnock	59
6		St. Johnstone	53
7		Airdrieonians	50
8		Heart of Midlothian	50
9		Greenock Morton	44
10		Hibernian FC	43
11		St. Mirren	43
12		Dundee	42
13		Clyde	40
14		Partick Thistle	37
15		Aberdeen	35
16		Raith Rovers	29
17		Falkirk	23
18		Arbroath	21

RIVALES EN Copa de la Liga.

RIVALES EN Liga Escocia

USO DE MEMORIA

5,492,472 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.6237
Total Execution Time	0.6258

CADENA URL

/Arbroath/1969

GET DATOS

$_GET['/Arbroath/1969']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0146	SELECT type FROM routes WHERE alias = 'arbroath'
0.0166	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 = 'Arbroath' AND l.year = 1969 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.0145	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=2998 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=2998 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=2998 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=2998 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=2998 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295	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 = 22311
0.0152	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 = 25965
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2998 AND type_rel = 2
0.0157	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 = '2998' AND l.year = 1969 ORDER BY l.year DESC,cat.coefficient DESC
0.0162	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 = '2998' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145	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 = 25965 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 22311 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0193	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1969 as c ON c.league_id = l.id WHERE (c.datateam1 = 2998 or c.datateam2 = 2998) AND l.year = 1969 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0200	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1969 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 2998 or c.datateam2 = 2998) AND l.year = 1969 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0205	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1969 as c ON c.league_id = l.id INNER JOIN events1969 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 2998 or c.datateam2 = 2998) AND l.year = 1969)
0.0166	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=2998 AND l.year in (1968,1969,1970) ORDER BY l.id DESC, l.year DESC ;
0.0149	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 (25992,22311) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 22311 AND teamId = 2998
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 25992 AND teamId = 2998
0.0166	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1969` 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 = 22311 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156	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 = '2998' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2998' and rp.type = 4
0.0156	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 = '2998' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0153	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 events1969 e ON e.player_id = p.id AND e.league_id = 22311 WHERE rp.league_id = 22311 AND rp.teamId = 2998 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.0146	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 events1969 e ON e.player_id = p.id AND e.league_id = 22311 WHERE rp.league_id = 22311 AND rp.teamId = 2998 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 events1969 e ON e.player_id = p.id AND e.league_id = 22311 WHERE rp.league_id = 22311 AND rp.teamId = 2998 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 2998 AND rp.league_id = 22311 AND l.year= 1969 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0147	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 2998 AND rp.league_id = 22311 AND l.year= 1969 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1

Resultados de Fútbol

Arbroath

Información sobre Arbroath

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Copa de la Liga de Escocia

Challenge Cup Escocia

Copa Escocia

League One Escocia

League Two Escocia

Partidos Amistosos

Liga Escocia

Championship Escocia

Championship Escocia - Play Offs Ascenso

Liga Escocia - Play Offs Ascenso

Partidos del Arbroath

Noticias de Liga Escocia

30 años del cabezazo que acabó en 3 meses de cárcel

¿Está roto el sistema de cesiones del fútbol?

Con faldas y a lo loco

El Celtic rinde homenaje a su origen con una línea de ropa especial

Hart colgará los guantes a final de temporada

Arbroath

Selecciona un equipo

Competiciones que juega

Liga Escocia

RIVALES EN Copa de la Liga.

RIVALES EN Liga Escocia


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