30 Jun 18	Finalizado	NK Osijek	3 - 0	St. Johnstone	3
22 Jul 17	Finalizado	St. Johnstone	1 - 0	Hartlepool United	0
15 Jul 17	Finalizado	St. Johnstone	3 - 0	Sunderland	15
01 Jul 17	Finalizado	St. Johnstone	0 - 3	Aberdeen	2

Fase Previa Europa League »

	06 Jul 17	Finalizado	FK Riteriai	1 - 0	St. Johnstone			25
	29 Jun 17	Finalizado	St. Johnstone	1 - 2	FK Riteriai			24

Liga Escocia »

12 May 18	Finalizado	St. Johnstone	1 - 1	Ross County FC	16
08 May 18	Finalizado	Hamilton Academical	1 - 2	St. Johnstone	14
05 May 18	Finalizado	Motherwell	1 - 5	St. Johnstone	1
28 Abr 18	Finalizado	St. Johnstone	1 - 1	Partick Thistle	0
21 Abr 18	Finalizado	Dundee	2 - 1	St. Johnstone	3
07 Abr 18	Finalizado	St. Johnstone	0 - 0	Motherwell	1
31 Mar 18	Finalizado	Aberdeen	4 - 1	St. Johnstone	1
28 Mar 18	Finalizado	St. Johnstone	1 - 0	Hamilton Academical	23
16 Mar 18	Finalizado	St. Johnstone	1 - 1	Hibernian FC	49
10 Mar 18	Finalizado	Dundee	0 - 4	St. Johnstone	5
07 Mar 18	Finalizado	Kilmarnock	2 - 0	St. Johnstone	24
27 Feb 18	Finalizado	St. Johnstone	1 - 4	Rangers FC	37
24 Feb 18	Finalizado	St. Johnstone	2 - 0	Ross County FC	0
18 Feb 18	Finalizado	Celtic	0 - 0	St. Johnstone	44
06 Feb 18	Finalizado	Motherwell	2 - 0	St. Johnstone	21
03 Feb 18	Finalizado	Heart of Midlothian	1 - 0	St. Johnstone	1
27 Ene 18	Finalizado	St. Johnstone	1 - 3	Partick Thistle	0
30 Dic 17	Finalizado	St. Johnstone	0 - 2	Dundee	7
27 Dic 17	Finalizado	Ross County FC	1 - 1	St. Johnstone	16
23 Dic 17	Finalizado	St. Johnstone	0 - 0	Heart of Midlothian	2
16 Dic 17	Finalizado	Rangers FC	1 - 3	St. Johnstone	12
13 Dic 17	Finalizado	St. Johnstone	0 - 3	Aberdeen	9
09 Dic 17	Finalizado	Hamilton Academical	0 - 1	St. Johnstone	0
02 Dic 17	Finalizado	St. Johnstone	1 - 2	Kilmarnock	0
18 Nov 17	Finalizado	Hibernian FC	1 - 2	St. Johnstone	1
04 Nov 17	Finalizado	St. Johnstone	0 - 4	Celtic	7
28 Oct 17	Finalizado	Partick Thistle	1 - 0	St. Johnstone	0
24 Oct 17	Finalizado	St. Johnstone	0 - 0	Ross County FC	1
21 Oct 17	Finalizado	Heart of Midlothian	1 - 0	St. Johnstone	0
13 Oct 17	Finalizado	St. Johnstone	0 - 3	Rangers FC	38
30 Sep 17	Finalizado	Aberdeen	3 - 0	St. Johnstone	1
23 Sep 17	Finalizado	St. Johnstone	2 - 1	Hamilton Academical	0
16 Sep 17	Finalizado	Dundee	3 - 2	St. Johnstone	0
09 Sep 17	Finalizado	St. Johnstone	1 - 1	Hibernian FC	1
26 Ago 17	Finalizado	Celtic	1 - 1	St. Johnstone	81
19 Ago 17	Finalizado	St. Johnstone	1 - 0	Partick Thistle	0
12 Ago 17	Finalizado	St. Johnstone	4 - 1	Motherwell	2
05 Ago 17	Finalizado	Kilmarnock	1 - 2	St. Johnstone	0

Copa Escocia »

	10 Feb 18	Finalizado	Heart of Midlothian	3 - 0	St. Johnstone			0
	29 Ene 18	Finalizado	Albion Rovers	0 - 4	St. Johnstone			4

Copa de la Liga de Escocia »

08 Ago 17

Finalizado

St. Johnstone

0 - 3

Partick Thistle

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

J. Kerr1

S. Anderson1

R. Foster1

D. Wotherspoon1

Plantilla del St. Johnstone Temporada 2017/2018

		Edad	Altura	Peso
Portero
1	A. Mannus	41	188	94	-	-	1
30	M. Hurst	28	185	78	-	-	-
12	Z. Clark	31	191	77	-	-	-
Defensa
14	A. Comrie	27	176	65	-	-	1
28	Ally Gilchrist	29	175	70	-	-	-
24	B. Easton	36	183	76	-	-	1
15	J. Kerr	27	180	70	1	1	1
5	J. Shaughnessy	31	183	70	-	-	1
15	John Kerr	27	180	75	-	-	1
22	K. Watson	34	185	73	-	-	-
23	L. Gordon	28	183	77	-	-	1
19	R. Foster	38	178	73	-	1	4
6	S. Anderson	38	181	72	-	1	5
3	S. Tanser	29	182	65	-	-	2
Centrocampista
37	A. McCann	24	176	64	-	-	-
4	B. Alston	32	181	78	2	-	2
7	C. Millar	41	175	68	-	-	3
10	D. Wotherspoon	34	181	76	1	1	8
20	Kyle Mcclean	25	184	69	1	-	1
26	L. Craig	37	183	82	3	-	7
8	M. Davidson	36	180	63	5	-	11
28	Matthew Willock	27	172	65	1	-	-
21	S. Scougall	31	170	69	1	-	3
Delantero
50	C. Hendry	26	176	70	-	-	-
25	Chris Kane	29	174	76	3	-	2
17	D. Johnstone	29	188	83	2	-	2
16	D. Mcmillan	35	180	74	-	-	-
29	G. Cummins	36	178	75	1	-	-
11	G. Williams	28	172	73	-	-	-
11	M. O'halloran	33	188	79	5	-	3
9	S. Maclean	41	180	79	5	-	4

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

Pos	Equipos		Pts
1		Celtic	75
2		Rangers FC	62
3		Aberdeen	62
4		Hibernian FC	59
5		Kilmarnock	55
6		Heart of Midlothian	46
7		Motherwell	38
8		St. Johnstone	38
9		Hamilton Academical	30
10		Dundee	30
11		Ross County FC	26
12		Partick Thistle	25

	Playoff Título : Celtic, Rangers FC, Aberdeen, Hibernian FC, Kilmarnock, Heart of Midlothian
	Playoff Descenso : Motherwell, St. Johnstone, Hamilton Academical, Dundee, Ross County FC, Partick Thistle

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Escocia

USO DE MEMORIA

7,049,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0036
Controller Execution Time ( Home / Category )	0.8444
Total Execution Time	0.8480

CADENA URL

/St-Johnstone-Fc/2018

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0125	SELECT type FROM routes WHERE alias = 'st-johnstone-fc'
0.0153	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 = 'St-Johnstone-Fc' AND l.year = 2018 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=2415 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=2415 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=2415 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=2415 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=2415 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=2415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=2415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=2415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=2415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=2415 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=2415 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=2415 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=2415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	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 = 38977
0.0132	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 = 39272
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2415 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2415 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	SELECT /35 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 (2327,42943,44810,44955,128454) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '2415' ORDER BY l.year DESC,cat.coefficient DESC
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 = '2415' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0156	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.0128	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 = 39272 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 38977 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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 = 43281 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	(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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 2415 or c.datateam2 = 2415) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0187	(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 calendars2018 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 = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0159	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 2018)
0.0147	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 (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (49541,44600,44453,43475,38742) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 49541 AND teamId = 2415
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 38742 AND teamId = 2415
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 44453 AND teamId = 2415
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 44600 AND teamId = 2415
0.0224	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 2415
0.0136	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 = '2415' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2415' and rp.type = 4
0.0136	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 = '2415' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0202	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 events2018 e ON e.player_id = p.id AND e.league_id = 38641 WHERE rp.league_id = 38641 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.0178	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 events2018 e ON e.player_id = p.id AND e.league_id = 38641 WHERE rp.league_id = 38641 AND rp.teamId = 2415 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142	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 events2018 e ON e.player_id = p.id AND e.league_id = 38641 WHERE rp.league_id = 38641 AND rp.teamId = 2415 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 38641 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0132	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=782990 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0126	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=782990
0.0133	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782990 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0137	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782990 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782990 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0130	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782990 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782990 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

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

Estadísticas

Plantilla del St. Johnstone Temporada 2017/2018

Noticias del St. Johnstone

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

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

Krachunov firma con el St. Johnstone escocés

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

La Real empata ante el St. Johnstone

St. Johnstone

Selecciona un equipo

Competiciones que juega

Liga Escocia Grupo 1

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN Fase Previa Euro.

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