Tranmere Rovers

Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

	Edad	Origen	Peso
Portero
	Bradley Watkins	29	192	82	-	-	-
13	L. Pilling	26	190	75	-	-	-
1	O. Williams	37	193	77	-	-	3
26	P. Brezovan	44	198	94	-	-	-
20	S. Ramsbottom	28	196	70	-	-	-
Defensa
18	A. Dugdale	36	191	77	1	-	5
	Andrai Jones	32	180	75	-	-	-
28	Ben Davies	28	185	74	-	-	-
2	D. Holmes	35	175	76	2	-	5
17	D. Woodards	40	180	80	-	-	-
24	E. Gumbs	26	177	76	-	-	-
	Evan Horwood	38	183	66	-	-	6
28	Harrison Mcgahey	28	187	85	-	-	-
	Ian Goodison	51	190	86	-	-	-
12	J. Donacien	30	183	75	-	-	3
	Jon Otsemobor	41	178	78	-	-	-
32	Josh Thompson	33	193	86	-	-	-
3	L. Ridehalgh	33	178	72	-	1	1
27	M. Dugan	27	-	-	-	-	-
6	M. Holness	35	183	77	-	-	-
5	M. Ihiekwe	31	185	80	1	-	6
25	Matt Hill	43	170	79	-	-	-
	R. Edwards	30	195	82	-	1	7
	S. Foster	43	180	78	-	-	-
29	W. Aimson	29	179	70	-	-	1
Centrocampista
11	A. Bell-Baggie	32	168	64	3	-	2
	A. Boland	29	186	78	-	-	-
30	B. Jago	27	173	-	-	-	-
	B. Maher	28	170	70	-	-	-
30	C. Jahraldo-Martin	31	175	70	-	-	-
	C. Morris	31	187	80	-	-	-
23	C. Shuker	41	165	58	-	-	-
11	D. Gardner	34	185	80	2	-	1
10	G. Green	28	183	79	1	-	1
15	J. Kirby	29	175	70	1	-	-
8	J. Koumas	44	180	69	-	-	1
12	J. Rowe	32	180	65	2	-	-
32	Joe Thompson	35	183	64	-	-	1
21	L. Davies	27	185	76	-	-	-
19	Lee Molyneux	35	186	81	1	-	5
23	M. Gill	33	180	74	-	-	-
23	M. Gill	43	180	74	-	-	2
14	M. Laird	38	183	69	1	-	5
4	M. Power	30	181	77	7	-	7
	T. Hateley	34	181	68	-	-	-
Delantero
	Akpo Sodje	43	188	80	-	-	-
	B. Greenwood	-	186	83	-	-	-
16	C. Stockton	30	186	75	4	-	2
7	G. Donnelly	35	175	84	-	-	-
33	Guy Madjo	39	183	72	-	-	-
34	I. Hume	40	170	72	-	-	1
10	J. Hugill	31	183	64	4	-	3
31	J. Myrie-Williams	35	180	76	3	-	4
9	Kayode Odejayi	39	188	77	6	-	6
22	Matthias Fanimo	30	175	73	-	-	-
17	R. J. Taylor	39	183	72	-	1	-
	R. Lowe	45	180	72	9	-	4
29	Rory Donnelly	32	188	81	5	-	6
28	S. Fenelon	29	186	80	2	-	1
37	T. Omotola	26	-	-	-	-	-

Jugador

Edad

Origen

Altura

Peso

Portero

Bradley Watkins

192

L. Pilling

190

O. Williams

193

P. Brezovan

198

S. Ramsbottom

196

Defensa

A. Dugdale

191

Andrai Jones

180

Ben Davies

185

D. Holmes

175

D. Woodards

180

E. Gumbs

177

Evan Horwood

183

Harrison Mcgahey

187

Ian Goodison

190

J. Donacien

183

Jon Otsemobor

178

Josh Thompson

193

L. Ridehalgh

178

M. Dugan

M. Holness

183

M. Ihiekwe

185

Matt Hill

170

R. Edwards

195

S. Foster

180

W. Aimson

179

Centrocampista

A. Bell-Baggie

168

A. Boland

186

B. Jago

173

B. Maher

170

C. Jahraldo-Martin

175

C. Morris

187

C. Shuker

165

D. Gardner

185

G. Green

183

J. Kirby

175

J. Koumas

180

J. Rowe

180

Joe Thompson

183

L. Davies

185

Lee Molyneux

186

M. Gill

180

M. Gill

180

M. Laird

183

M. Power

181

T. Hateley

181

Delantero

Akpo Sodje

188

B. Greenwood

186

C. Stockton

186

G. Donnelly

175

Guy Madjo

183

I. Hume

170

J. Hugill

183

J. Myrie-Williams

180

Kayode Odejayi

188

Matthias Fanimo

175

R. J. Taylor

183

R. Lowe

180

Rory Donnelly

188

S. Fenelon

186

T. Omotola

'Hat trick' de Llorente y goleada histórica del Tottenham

El Tottenham se dio un homenaje ante el Tranmere, en la tercera ronda de la Copa de Inglaterra, y ganó 0-7 con un festival anotador de Fernando Llorente, que marcó tres de los goles y volvió a recuperar la sonrisa después de 15 partidos oficiales sin ver portería.

El chico que huyó de una de las 10 ciudades más peligrosas del mundo

Ryan Williams ahora sabe apreciar lo que puede dar el fútbol en el Viejo Continente. El futbolista inglés pasó la temporada anterior en el Paysandu de Belém, una de las ciudades más peligrosas de Brasil y del mundo. El protagonista contó su historia hace unos meses, pero ahora tiene la oportunidad de medirse a un equipo de primera escena como el Tottenham Hotspur.

La odisea de Ryan Williams en Brasil

El que fuera jugador del Liverpool en los 90 relata su tremenda historia tras firmar por el Paysandú, ubicado en Belén, una de las diez ciudades más peligrosas del mundo. "Es difícil describir una ciudad que no puedes comparar con nada", resume.

Un rival llamó "pu** mier**" a Karius tras su última cantada

Los errores ante el Real Madrid en la última final de Champions le pasaron factura. Karius no ha comenzado la pretemporada de la mejor manera posible y lo ha dejado ver con dos errores. El último de ellos le llevó hasta a recibir el insulto de un rival llamado Ben Tollitt, jugador del Tranmere Rovers.

Roja, gol y botellazo a un jugador... ¡en 10 minutos!

De locos lo que se vivió en Wembley entre el Tranmere Rovers y el Boreham Wood. En apenas 48 segundos, un jugador de Tranmere fue expulsado. A los seis minutos ya se había marcado un gol y, entre medias, el juego tuvo que ser detenido porque alguien dio un botellazo a un futbolista.

Pos	Equipos	Pts
1		Burton Albion	94
2		Shrewsbury Town	89
3		Bury	85
4		Wycombe Wanderers	84
5		Southend United	84
6		Stevenage	72
7		Plymouth Argyle	71
8		Luton Town	68
9		Newport County	65
10		Exeter City	64
11		Morecambe	63
12		Northampton	61
13		Oxford United	61
14		Dagenham & Redbridge	59
15		AFC Wimbledon	58
16		Portsmouth	57
17		Accrington Stanley	56
18		York City	52
19		Cambridge United	51
20		Carlisle United	50
21		Mansfield Town	48
22		Hartlepool United	45
23		Cheltenham Town	41
24		Tranmere Rovers	39

Pos

Equipos

Pts

USO DE MEMORIA

6,960,976 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.7880
Total Execution Time	0.7899

CADENA URL

/tranmere-rovers/2015

GET DATOS

$_GET['/tranmere-rovers/2015']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0124	SELECT type FROM routes WHERE alias = 'tranmere-rovers'
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 = 'tranmere-rovers' AND l.year = 2015 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=9176 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=9176 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=9176 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=9176 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=9176 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=9176 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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 = 3889
0.0130	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 = 4393
0.0130	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 = 24404
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9176 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9176 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127	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 (426943,465721,508512,561878,562187) ORDER BY n.cover_points DESC, update_date DESC
0.0140	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 = '9176' ORDER BY l.year DESC,cat.coefficient DESC
0.0135	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 = '9176' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0135	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 = '9176' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 3889 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 24404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	(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 calendars2015 as c ON c.league_id = l.id WHERE (c.datateam1 = 9176 or c.datateam2 = 9176) AND l.year = 2015 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0135	(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 calendars2015 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 = 9176 or c.datateam2 = 9176) AND l.year = 2015 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0133	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN events2015 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 = 9176 or c.datateam2 = 9176) AND l.year = 2015)
0.0134	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=9176 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (48708,24412,16427,16245,15152,4028,3889,2438) 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 = 2438 AND teamId = 9176
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 3889 AND teamId = 9176
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 15152 AND teamId = 9176
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 16427 AND teamId = 9176
0.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 4028 AND teamId = 9176
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 48708 AND teamId = 9176
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 24412 AND teamId = 9176
0.0178	SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 9176
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 3889 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '9176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9176' 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 = '9176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2015 e ON e.player_id = p.id AND e.league_id = 3889 WHERE rp.league_id = 3889 AND rp.teamId = 9176 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 events2015 e ON e.player_id = p.id AND e.league_id = 3889 WHERE rp.league_id = 3889 AND rp.teamId = 9176 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 events2015 e ON e.player_id = p.id AND e.league_id = 3889 WHERE rp.league_id = 3889 AND rp.teamId = 9176 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 = 9176 AND rp.league_id = 3889 AND l.year= 2015 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0134	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=71614 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=71614
0.0139	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=71614 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=71614 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0183	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=71614 and (e.action = 3 or e.action = 4) 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=71614 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0138	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=71614 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

03 Ene 15	Finalizado	Tranmere Rovers	2 - 6	Swansea City	6
16 Dic 14	Finalizado	Tranmere Rovers	2 - 1	Oxford United	0
06 Dic 14	Finalizado	Oxford United	2 - 2	Tranmere Rovers	0
08 Nov 14	Finalizado	Tranmere Rovers	1 - 0	Bristol Rovers	0

	25 Jul 14	Finalizado	Tranmere Rovers	1 - 1	Bolton Wanderers			3
	25 Jul 14	Finalizado	Tranmere Rovers	2 - 2	Everton			3

02 May 15	Finalizado	Tranmere Rovers	0 - 1	Bury	2
25 Abr 15	Finalizado	Plymouth Argyle	3 - 2	Tranmere Rovers	0
18 Abr 15	Finalizado	Tranmere Rovers	0 - 3	Oxford United	0
14 Abr 15	Finalizado	Mansfield Town	1 - 0	Tranmere Rovers	0
11 Abr 15	Finalizado	Southend United	1 - 0	Tranmere Rovers	0
06 Abr 15	Finalizado	Tranmere Rovers	0 - 1	Luton Town	0
03 Abr 15	Finalizado	Stevenage	2 - 2	Tranmere Rovers	0
28 Mar 15	Finalizado	Tranmere Rovers	1 - 1	AFC Wimbledon	0
21 Mar 15	Finalizado	Tranmere Rovers	1 - 4	Burton Albion	0
17 Mar 15	Finalizado	Cambridge United	1 - 2	Tranmere Rovers	1
14 Mar 15	Finalizado	Northampton	1 - 0	Tranmere Rovers	0
07 Mar 15	Finalizado	Tranmere Rovers	2 - 3	Dagenham & Redbridge	0
03 Mar 15	Finalizado	Tranmere Rovers	1 - 2	Wycombe Wanderers	0
28 Feb 15	Finalizado	Cheltenham Town	2 - 0	Tranmere Rovers	0
24 Feb 15	Finalizado	Portsmouth	3 - 2	Tranmere Rovers	2
21 Feb 15	Finalizado	Tranmere Rovers	2 - 1	Shrewsbury Town	0
14 Feb 15	Finalizado	York City	2 - 0	Tranmere Rovers	0
10 Feb 15	Finalizado	Newport County	1 - 1	Tranmere Rovers	0
07 Feb 15	Finalizado	Tranmere Rovers	0 - 2	Carlisle United	0
31 Ene 15	Finalizado	Exeter City	1 - 2	Tranmere Rovers	0
24 Ene 15	Finalizado	Tranmere Rovers	1 - 1	Hartlepool United	0
17 Ene 15	Finalizado	Tranmere Rovers	3 - 0	Accrington Stanley	0
10 Ene 15	Finalizado	Morecambe	0 - 0	Tranmere Rovers	0
28 Dic 14	Finalizado	Tranmere Rovers	2 - 1	Northampton	1
26 Dic 14	Finalizado	Burton Albion	2 - 0	Tranmere Rovers	0
19 Dic 14	Finalizado	Tranmere Rovers	1 - 1	Cambridge United	0
13 Dic 14	Finalizado	Dagenham & Redbridge	0 - 1	Tranmere Rovers	0
29 Nov 14	Finalizado	Tranmere Rovers	3 - 1	Portsmouth	0
22 Nov 14	Finalizado	Tranmere Rovers	1 - 2	Southend United	0
15 Nov 14	Finalizado	Luton Town	1 - 0	Tranmere Rovers	0
01 Nov 14	Finalizado	Tranmere Rovers	2 - 2	Stevenage	0
25 Oct 14	Finalizado	AFC Wimbledon	2 - 2	Tranmere Rovers	0
21 Oct 14	Finalizado	Tranmere Rovers	0 - 0	Mansfield Town	0
18 Oct 14	Finalizado	Oxford United	2 - 0	Tranmere Rovers	0
11 Oct 14	Finalizado	Tranmere Rovers	0 - 1	Plymouth Argyle	0
04 Oct 14	Finalizado	Bury	2 - 0	Tranmere Rovers	0
27 Sep 14	Finalizado	Carlisle United	1 - 0	Tranmere Rovers	0
20 Sep 14	Finalizado	Tranmere Rovers	1 - 2	Exeter City	1
16 Sep 14	Finalizado	Tranmere Rovers	0 - 0	Newport County	0
13 Sep 14	Finalizado	Hartlepool United	0 - 0	Tranmere Rovers	0
06 Sep 14	Finalizado	Accrington Stanley	3 - 2	Tranmere Rovers	0
30 Ago 14	Finalizado	Tranmere Rovers	2 - 1	Morecambe	0
23 Ago 14	Finalizado	Tranmere Rovers	2 - 3	Cheltenham Town	1
19 Ago 14	Finalizado	Wycombe Wanderers	0 - 2	Tranmere Rovers	3
16 Ago 14	Finalizado	Shrewsbury Town	2 - 1	Tranmere Rovers	0
09 Ago 14	Finalizado	Tranmere Rovers	1 - 1	York City	3

09 Dic 14	Finalizado	Tranmere Rovers	2 - 2	Walsall
11 Nov 14	Finalizado	Bury	1 - 2	Tranmere Rovers
07 Oct 14	Finalizado	Tranmere Rovers	1 - 1	Carlisle United

Información sobre Tranmere Rovers

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

EFL Cup

FA Cup

EFL Trophy

League One

Partidos Amistosos

Championship

League Two

National League

FA Trophy

National League - Play Offs Ascenso

League Two - Play Offs Ascenso

Partidos del Tranmere Rovers

Estadísticas

Plantilla del Tranmere Rovers Temporada 2014/2015

Noticias del Tranmere Rovers

'Hat trick' de Llorente y goleada histórica del Tottenham

El chico que huyó de una de las 10 ciudades más peligrosas del mundo

La odisea de Ryan Williams en Brasil

Un rival llamó "pu mier" a Karius tras su última cantada

Roja, gol y botellazo a un jugador... ¡en 10 minutos!

Tranmere Rovers

Selecciona un equipo

Competiciones que juega

League Two

RIVALES EN EFL Cup

RIVALES EN League Two

RIVALES EN EFL Trophy

RIVALES EN FA Cup