27 Abr 67	Finalizado	St. Mirren	0 - 0	St. Johnstone
26 Abr 67	Finalizado	St. Johnstone	3 - 0	Ayr United
22 Abr 67	Finalizado	St. Johnstone	1 - 2	Hibernian FC
11 Abr 67	Finalizado	Clyde	2 - 0	St. Johnstone
08 Abr 67	Finalizado	Ayr United	1 - 0	St. Johnstone
05 Abr 67	Finalizado	Dunfermline Athletic FC	4 - 1	St. Johnstone
01 Abr 67	Finalizado	St. Johnstone	1 - 0	Airdrieonians
29 Mar 67	Finalizado	Rangers FC	4 - 3	St. Johnstone
25 Mar 67	Finalizado	Kilmarnock	5 - 3	St. Johnstone
18 Mar 67	Finalizado	St. Johnstone	4 - 1	Stirling Albion
04 Mar 67	Finalizado	St. Johnstone	0 - 3	Dundee
25 Feb 67	Finalizado	St. Johnstone	2 - 1	Falkirk
11 Feb 67	Finalizado	Heart of Midlothian	1 - 0	St. Johnstone
04 Feb 67	Finalizado	St. Johnstone	1 - 1	Motherwell
21 Ene 67	Finalizado	Partick Thistle	3 - 0	St. Johnstone
14 Ene 67	Finalizado	St. Johnstone	0 - 4	Celtic
03 Ene 67	Finalizado	St. Johnstone	1 - 0	Aberdeen
02 Ene 67	Finalizado	Dundee United	1 - 0	St. Johnstone
31 Dic 66	Finalizado	St. Johnstone	3 - 0	St. Mirren
24 Dic 66	Finalizado	Hibernian FC	2 - 5	St. Johnstone
17 Dic 66	Finalizado	St. Johnstone	2 - 4	Clyde
03 Dic 66	Finalizado	Airdrieonians	2 - 0	St. Johnstone
26 Nov 66	Finalizado	St. Johnstone	1 - 3	Kilmarnock
19 Nov 66	Finalizado	Stirling Albion	2 - 1	St. Johnstone
12 Nov 66	Finalizado	St. Johnstone	1 - 1	Rangers FC
05 Nov 66	Finalizado	Dundee	4 - 0	St. Johnstone
29 Oct 66	Finalizado	Falkirk	0 - 3	St. Johnstone
22 Oct 66	Finalizado	St. Johnstone	3 - 2	Heart of Midlothian
15 Oct 66	Finalizado	Motherwell	3 - 3	St. Johnstone
08 Oct 66	Finalizado	St. Johnstone	3 - 5	Partick Thistle
01 Oct 66	Finalizado	Celtic	6 - 1	St. Johnstone
24 Sep 66	Finalizado	St. Johnstone	3 - 3	Dunfermline Athletic FC
17 Sep 66	Finalizado	Aberdeen	3 - 2	St. Johnstone
10 Sep 66	Finalizado	St. Johnstone	2 - 0	Dundee United

Copa de la Liga de Escocia »

11 Oct 67	Finalizado	Dundee	3 - 1	St. Johnstone
27 Sep 67	Finalizado	St. Johnstone	3 - 1	Queens Park
13 Sep 67	Finalizado	Queens Park	0 - 5	St. Johnstone
02 Sep 67	Finalizado	Stirling Albion	1 - 0	St. Johnstone
30 Ago 67	Finalizado	Falkirk	0 - 3	St. Johnstone
26 Ago 67	Finalizado	St. Johnstone	3 - 2	Heart of Midlothian
19 Ago 67	Finalizado	St. Johnstone	2 - 1	Stirling Albion
16 Ago 67	Finalizado	St. Johnstone	0 - 0	Falkirk
12 Ago 67	Finalizado	Heart of Midlothian	1 - 2	St. Johnstone

Noticias del St. Johnstone

Ver últimas noticias

El irlandés Gormley cuelga las botas a los 26 años

BeSoccer - Miércoles, 02 Noviembre 2016

0 357

Malas noticias para la Selección de Irlanda del Norte. El futbolista Joe Gormley ha decidido abandonar para siempre la práctica del fútbol debido a la falta de minutos y a sus continuas lesiones.

Faubert sigue probando fortuna en Escocia tras ser rechazado por el St. Johnstone

BeSoccer - Martes, 23 Febrero 2016

0 625

Julien Faubert se encuentra probando con el conjunto escocés, que tendría pensado ofrecerle un contrato hasta final de temporada para intentar salvar la categoría.

Krachunov firma con el St. Johnstone escocés

BeSoccer - Martes, 23 Febrero 2016

0 174

El defensa central búlgaro firma hasta final de temporada con el St. Johnstone, que disputa la primera categoría del fútbol escocés.

El 'mítico' Julien Faubert, a prueba en la Liga Escocesa

BeSoccer - Martes, 16 Febrero 2016

3 1.071

Faubert es historia del Real Madrid. Historia oscura. De las que se recuerda con la mirada hacia abajo. Ahora, después de muchos años de su relación madridista, puede jugar en Escocia tras andar sin equipo durante meses.

La Real empata ante el St. Johnstone

BeSoccer - Domingo, 12 Julio 2015

0 467

La Real Sociedad sigue sin marcar en el inicio de la pretemporada, tras obtener un empate sin goles ante el St. Johnstone escocés, cuarto clasificado en su liga y eliminado de las previas de la Europa League.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Liga Escocia

Pos	Equipos		Pts
1		Celtic	84
2		Rangers FC	79
3		Clyde	66
4		Hibernian FC	61
5		Aberdeen	59
6		Dundee	57
7		Kilmarnock	56
8		Dunfermline Athletic FC	52
9		Dundee United	51
10		Motherwell	41
11		Heart of Midlothian	41
12		Airdrieonians	39
13		Partick Thistle	39
14		Falkirk	37
15		St. Johnstone	35
16		Stirling Albion	24
17		St. Mirren	19
18		Ayr United	10

RIVALES EN Copa de la Liga.

RIVALES EN Liga Escocia

USO DE MEMORIA

5,748,832 bytes

BENCHMARKS

Loading Time Base Classes	0.0023
Controller Execution Time ( Home / Category )	0.4803
Total Execution Time	0.4826

CADENA URL

/St-Johnstone-Fc/1967

GET DATOS

$_GET['/St-Johnstone-Fc/1967']

POST DATOS

No hay datos POST existentes

CONSULTAS (20)

0.0299	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 = 22313
0.0159	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 = 26009
0.0154	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 = 26019
0.0173	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 = '2415' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 26019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147	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 = 22313 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0196	(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 calendars1967 as c ON c.league_id = l.id WHERE (c.datateam1 = 2415 or c.datateam2 = 2415) AND l.year = 1967 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0222	(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 calendars1967 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 = 2415 or c.datateam2 = 2415) AND l.year = 1967 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0208	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1967 as c ON c.league_id = l.id INNER JOIN events1967 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 = 2415 or c.datateam2 = 2415) AND l.year = 1967)
0.0194	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=2415 AND l.year in (1966,1967,1968) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (26019,22317) 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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 22317 AND teamId = 2415
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 26019 AND teamId = 2415
0.0158	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1967` 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 = 22313 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0149	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 events1967 e ON e.player_id = p.id AND e.league_id = 22313 WHERE rp.league_id = 22313 AND rp.teamId = 2415 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.0150	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 events1967 e ON e.player_id = p.id AND e.league_id = 22313 WHERE rp.league_id = 22313 AND rp.teamId = 2415 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 events1967 e ON e.player_id = p.id AND e.league_id = 22313 WHERE rp.league_id = 22313 AND rp.teamId = 2415 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 2415 AND rp.league_id = 22313 AND l.year= 1967 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0148	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 = 2415 AND rp.league_id = 22313 AND l.year= 1967 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0154	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 = 22313 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

St. Johnstone

Información sobre St. Johnstone

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

Liga Escocia Grupo 1

Copa Escocia

Partidos Amistosos

Championship Escocia

Fase Previa Europa League Grupo 1

Challenge Cup Escocia

Europa League

Fase Previa Conference League Grupo 4

Liga Escocia - Play Offs Ascenso

Partidos del St. Johnstone