23 May 09	Finalizado	Inverness CT	0 - 1	Falkirk
16 May 09	Finalizado	Falkirk	0 - 2	St. Mirren
13 May 09	Finalizado	Hamilton Academical	0 - 1	Falkirk
09 May 09	Finalizado	Kilmarnock	1 - 1	Falkirk
02 May 09	Finalizado	Falkirk	2 - 1	Motherwell
18 Abr 09	Finalizado	Falkirk	0 - 0	Heart of Midlothian
11 Abr 09	Finalizado	Kilmarnock	3 - 0	Falkirk
08 Abr 09	Finalizado	Celtic	4 - 0	Falkirk
05 Abr 09	Finalizado	Falkirk	0 - 1	Rangers FC
21 Mar 09	Finalizado	Falkirk	4 - 0	Inverness CT
03 Mar 09	Finalizado	Falkirk	0 - 1	Dundee United
28 Feb 09	Finalizado	Hibernian FC	0 - 0	Falkirk
21 Feb 09	Finalizado	Falkirk	1 - 2	Hamilton Academical
14 Feb 09	Finalizado	St. Mirren	2 - 2	Falkirk
31 Ene 09	Finalizado	Falkirk	1 - 0	Aberdeen
24 Ene 09	Finalizado	Motherwell	1 - 1	Falkirk
17 Ene 09	Finalizado	Rangers FC	3 - 1	Falkirk
03 Ene 09	Finalizado	Falkirk	1 - 1	Kilmarnock
27 Dic 08	Finalizado	Dundee United	1 - 0	Falkirk
21 Dic 08	Finalizado	Falkirk	0 - 3	Celtic
13 Dic 08	Finalizado	Aberdeen	2 - 1	Falkirk
06 Dic 08	Finalizado	Falkirk	1 - 2	St. Mirren
29 Nov 08	Finalizado	Falkirk	1 - 1	Hibernian FC
22 Nov 08	Finalizado	Heart of Midlothian	2 - 1	Falkirk
15 Nov 08	Finalizado	Falkirk	1 - 0	Motherwell
12 Nov 08	Finalizado	Inverness CT	1 - 1	Falkirk
08 Nov 08	Finalizado	Hamilton Academical	1 - 1	Falkirk
01 Nov 08	Finalizado	Falkirk	0 - 0	Dundee United
25 Oct 08	Finalizado	Kilmarnock	1 - 2	Falkirk
18 Oct 08	Finalizado	Falkirk	0 - 1	Aberdeen
05 Oct 08	Finalizado	Motherwell	3 - 2	Falkirk
27 Sep 08	Finalizado	Falkirk	4 - 1	Hamilton Academical
20 Sep 08	Finalizado	St. Mirren	1 - 1	Falkirk
13 Sep 08	Finalizado	Falkirk	2 - 1	Heart of Midlothian
30 Ago 08	Finalizado	Falkirk	1 - 2	Inverness CT
23 Ago 08	Finalizado	Celtic	3 - 0	Falkirk
16 Ago 08	Finalizado	Hibernian FC	3 - 2	Falkirk
09 Ago 08	Finalizado	Falkirk	0 - 1	Rangers FC

Copa Escocia »

30 May 09	Finalizado	Falkirk	0 - 1	Rangers FC
26 Abr 09	Finalizado	Falkirk	2 - 0	Dunfermline Athletic FC
07 Mar 09	Finalizado	Inverness CT	0 - 1	Falkirk
07 Feb 09	Finalizado	Heart of Midlothian	0 - 1	Falkirk
10 Ene 09	Finalizado	Falkirk	4 - 2	Queen of the South

Copa de la Liga de Escocia »

27 Ene 09	Finalizado	Rangers FC	3 - 0	Falkirk
28 Oct 08	Finalizado	Falkirk	1 - 0	Inverness CT
23 Sep 08	Finalizado	Falkirk	2 - 1	Queen of the South

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

D. Barr1

Plantilla del Falkirk Temporada 2008/2009

		Edad	Altura	Peso
Portero
1	Dani Mallo	45	185	83	-	-	-
17	R. Olejnik	37	187	82	-	-	-
40	S. Flinders	37	193	87	-	-	-
Defensa
22	C. Mitchell	35	-	-	-	-	3
20	D. Barr	39	180	65	1	1	6
3	D. Holden	44	186	78	1	-	5
31	D. Mccaffrey	38	180	69	-	-	-
14	G. Aafjes	39	181	79	-	-	1
5	J. Mcnamara	50	178	64	-	1	2
2	Lee Bullen	53	-	-	-	1	5
10	S. Pressley	50	-	-	-	-	3
33	T. Scobbie	36	183	69	-	-	3
Centrocampista
47	Burton Obrien	42	-	-	1	-	2
19	J. Stewart	38	-	-	-	-	-
6	K. McBride	42	178	66	-	-	6
4	P. Cregg	38	175	65	-	1	4
10	Russell Latapy	55	170	-	-	-	-
16	S. Arfield	35	178	64	6	-	3
Delantero
8	Arnau Riera	42	174	73	-	-	3
21	C. Finnigan	37	179	70	3	-	3
27	Dayne Robertson	35	173	68	-	-	-
9	Graham Barrett	42	178	70	2	-	-
23	Kevin Moffat	35	165	-	-	-	-
11	M. Higdon	40	186	80	6	-	6
24	M. Stewart	35	170	67	2	-	1
7	N. Mccann	49	-	-	1	-	3
29	S. Lynch	37	178	70	-	-	-
15	Steve Lovell	43	180	70	8	1	2

Noticias del Falkirk

Ver últimas noticias

La cruel burla que ha indignado al fútbol escocés

Juan Ribón - Viernes, 05 Enero 2018

4 2.303

El nombre de Dean Shiels quizá no diga nada a nadie, pero es un claro ejemplo de superación. Perdió un ojo en 2006, y algunos fans y rivales, en lugar de elogiar su entrega jornada tras jornada, se burlan de él cada vez que se enfrentan al Dunfermline. La de los aficionados del Falkirk el otro día excedió los límites de lo aceptable.

Ejemplar sanción para el futbolista que se rió de un rival tuerto

BeSoccer - Sábado, 11 Noviembre 2017

1 1.386

No hay que burlarse de nadie, es de mal gusto y luego tiene consecuencias. Un jugador escocés ha sido castigado con ocho partidos de sanción por reírse de un rival al que le faltaba un ojo. Ejemplar sanción para Kevin O'Hara, de Falkirk escocés.

La última joven perla en la agenda del Barça

Cristina Serrano de la Cruz - Martes, 24 Enero 2017

0 5.580

Parece que el Barça tiene un nuevo nombre en su lista de deseos, según la prensa británica. Un joven de 17 años se habría colado en la agenda del conjunto azulgrana.

Robbie Thomson ficha por el Falkirk

BeSoccer - Jueves, 05 Enero 2017

0 138

El joven guardameta Robbie Thomson firma hasta final de temporada por el Falkirk. Thomson se convierte así en un importante refuerzo para la portería escocesa.

El Swansea se refuerza con Ryan Blair

BeSoccer - Miércoles, 27 Enero 2016

0 242

Ryan Blair ya es jugador del Swansea hasta junio de 2019.

Ver más noticias del equipo»

Competiciones que juega

Liga Escocia Grupo 1

Pos	Equipos		Pts
1		Celtic	74
2		Rangers FC	73
3		Heart of Midlothian	54
4		Dundee United	49
5		Aberdeen	48
6		Hibernian FC	42
7		Motherwell	41
8		Kilmarnock	34
9		St. Mirren	34
10		Hamilton Academical	34
11		Inverness CT	32
12		Falkirk	28

	Previa de Champions : Celtic
	Previa de Champions (2ª Ronda) : Rangers FC
	Europa League : Heart of Midlothian, Dundee United
	Descenso : Falkirk

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN Liga Escocia

USO DE MEMORIA

6,471,656 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.8267
Total Execution Time	0.8288

CADENA URL

/Falkirk-Fc/2009

GET DATOS

$_GET['/Falkirk-Fc/2009']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0125	SELECT type FROM routes WHERE alias = 'falkirk-fc'
0.0149	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 = 'Falkirk-Fc' AND l.year = 2009 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.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=1028 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=1028 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=1028 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=1028 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=1028 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=1028 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=1028 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=1028 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=1028 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135	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 = 281
0.0136	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 = 10323
0.0135	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 = 20901
0.0134	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 = 20910
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1028 AND type_rel = 2
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1028 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (37468,156951,166724,327935,356375) ORDER BY n.cover_points DESC, update_date DESC
0.0146	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 = '1028' ORDER BY l.year DESC,cat.coefficient DESC
0.0144	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 = '1028' AND l.year = 2009 ORDER BY l.year DESC,cat.coefficient DESC
0.0204	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 = '1028' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138	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 = 20910 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 = 20901 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132	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 = 10323 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	(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 calendars2009 as c ON c.league_id = l.id WHERE (c.datateam1 = 1028 or c.datateam2 = 1028) AND l.year = 2009 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0146	(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 calendars2009 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 = 1028 or c.datateam2 = 1028) AND l.year = 2009 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0142	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2009 as c ON c.league_id = l.id INNER JOIN events2009 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 = 1028 or c.datateam2 = 1028) AND l.year = 2009)
0.0184	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=1028 AND l.year in (2008,2009,2010) ORDER BY l.id DESC, l.year DESC ;
0.0132	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 (42904,20911,20902,10324) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 10324 AND teamId = 1028
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 42904 AND teamId = 1028
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 20902 AND teamId = 1028
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 20911 AND teamId = 1028
0.0132	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 = '1028' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1028' and rp.type = 4
0.0127	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 = '1028' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141	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 events2009 e ON e.player_id = p.id AND e.league_id = 281 WHERE rp.league_id = 281 AND rp.teamId = 1028 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.0135	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 events2009 e ON e.player_id = p.id AND e.league_id = 281 WHERE rp.league_id = 281 AND rp.teamId = 1028 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 events2009 e ON e.player_id = p.id AND e.league_id = 281 WHERE rp.league_id = 281 AND rp.teamId = 1028 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 1028 AND rp.league_id = 281 AND l.year= 2009 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0136	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=18359 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0128	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=18359
0.0159	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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=18359 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.0161	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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=18359 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0161	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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=18359 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0141	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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=18359 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0134	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 events2009 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=18359 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Resultados de Fútbol

Falkirk

Información sobre Falkirk

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

Challenge Cup Escocia

Championship Escocia

Partidos Amistosos

League One Escocia

Liga Escocia - Play Offs Ascenso

Championship Escocia - Play Offs Ascenso

Fase Previa Europa League Grupo 2

Partidos del Falkirk

Estadísticas

Plantilla del Falkirk Temporada 2008/2009

Noticias del Falkirk

La cruel burla que ha indignado al fútbol escocés

Ejemplar sanción para el futbolista que se rió de un rival tuerto

La última joven perla en la agenda del Barça

Robbie Thomson ficha por el Falkirk

El Swansea se refuerza con Ryan Blair

Falkirk

Selecciona un equipo

Competiciones que juega

Liga Escocia Grupo 1

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

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