Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

Coventry City

Entrenador: Mark Robins

Temporada 2002/2003

Información sobre Coventry City

Enviar Datos

Información

Nombre del equipo Coventry City
Nombre completo Coventry City Football Club
Nombre corto COV
País Inglaterra
Ciudad Coventry
Entrenador Mark Robins
URL del equipo en RF testing.resultados-futbol.com/Coventry-City

Otros Datos

Año de Fundación 1883
Patrocinador BoyleSports
Marca de Ropa Hummel

Internet

Sitio Web www.ccfc.co.uk/page/Welcome
Twitter principal @Coventry_City

Información sobre el estadio

Nombre del estadio City of Coventry Stadium
Capacidad 32609
Dirección Phoenix Way, Rowleys Green
Año de construcción 2005
Tamaño 105 x 68 metros

Histórico de participación

FA Cup

51 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1977, 1973, 1969, 1963, 1948, 1911, 1910)

EFL Cup

48 veces

Championship

34 veces

(2024, 2023, 2022, 2021, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 1967, 1966, 1965, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1938, 1937, 1925, 1924, 1923, 1922, 1921, 1920)

Premier League

34 veces

(2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968)

Partidos Amistosos

12 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2013, 2011)

EFL Trophy

10 veces

(2020, 2020, 2019, 2018, 2017, 2017, 2016, 2015, 2014, 2013)

League One

7 veces

(2020, 2019, 2017, 2016, 2015, 2014, 2013)

Championship - Play Offs Ascenso

1 vez

(2023)

Community Shield

1 vez

(1988)

Copa de Ferias

1 vez

(1971)

League Two - Play Offs Ascenso

1 vez

(2018)

League Two

1 vez

(2018)

Partidos del Coventry City

Ir al LIVESCORE

FA Cup »

25 Ene 03	Finalizado	Rochdale	2 - 0	Coventry City
15 Ene 03	Finalizado	Coventry City	3 - 0	Cardiff City
04 Ene 03	Finalizado	Cardiff City	2 - 2	Coventry City

EFL Cup »

06 Nov 02	Finalizado	Crystal Palace	3 - 0	Coventry City
02 Oct 02	Finalizado	Coventry City	8 - 0	Rushden & Diamonds
11 Sep 02	Finalizado	Coventry City	3 - 0	Colchester United

Championship »

04 May 03	Finalizado	Millwall	2 - 0	Coventry City
26 Abr 03	Finalizado	Coventry City	0 - 0	Gillingham
21 Abr 03	Finalizado	Coventry City	0 - 1	Stoke City
19 Abr 03	Finalizado	Derby County	1 - 0	Coventry City
15 Abr 03	Finalizado	Walsall	0 - 0	Coventry City
12 Abr 03	Finalizado	Coventry City	2 - 4	Ipswich Town
05 Abr 03	Finalizado	Preston North End	2 - 2	Coventry City
22 Mar 03	Finalizado	Coventry City	1 - 2	Leicester
19 Mar 03	Finalizado	Coventry City	0 - 4	Portsmouth
15 Mar 03	Finalizado	Norwich City	2 - 0	Coventry City
08 Mar 03	Finalizado	Coventry City	2 - 2	Wimbledon FC
05 Mar 03	Finalizado	Sheffield Wednesday	5 - 1	Coventry City
01 Mar 03	Finalizado	Grimsby Town	0 - 2	Coventry City
22 Feb 03	Finalizado	Coventry City	0 - 2	Bradford City
15 Feb 03	Finalizado	Rotherham United	1 - 0	Coventry City
08 Feb 03	Finalizado	Coventry City	0 - 1	Burnley
01 Feb 03	Finalizado	Coventry City	0 - 1	Watford
18 Ene 03	Finalizado	Nottingham Forest	1 - 1	Coventry City
11 Ene 03	Finalizado	Coventry City	0 - 0	Brighton & Hove Albion
01 Ene 03	Finalizado	Crystal Palace	1 - 1	Coventry City
28 Dic 02	Finalizado	Sheffield United	0 - 0	Coventry City
26 Dic 02	Finalizado	Coventry City	2 - 0	Reading
21 Dic 02	Finalizado	Coventry City	3 - 0	Derby County
14 Dic 02	Finalizado	Wolves	0 - 2	Coventry City
07 Dic 02	Finalizado	Stoke City	1 - 2	Coventry City
30 Nov 02	Finalizado	Coventry City	1 - 2	Preston North End
23 Nov 02	Finalizado	Ipswich Town	2 - 1	Coventry City
16 Nov 02	Finalizado	Coventry City	0 - 2	Wolves
09 Nov 02	Finalizado	Burnley	3 - 1	Coventry City
02 Nov 02	Finalizado	Coventry City	2 - 1	Rotherham United
29 Oct 02	Finalizado	Leicester	2 - 1	Coventry City
26 Oct 02	Finalizado	Coventry City	0 - 0	Walsall
23 Oct 02	Finalizado	Coventry City	1 - 1	Norwich City
19 Oct 02	Finalizado	Portsmouth	1 - 1	Coventry City
05 Oct 02	Finalizado	Gillingham	0 - 2	Coventry City
28 Sep 02	Finalizado	Coventry City	2 - 3	Millwall
24 Sep 02	Finalizado	Bradford City	1 - 1	Coventry City
21 Sep 02	Finalizado	Wimbledon FC	0 - 1	Coventry City
18 Sep 02	Finalizado	Coventry City	1 - 1	Sheffield Wednesday
14 Sep 02	Finalizado	Coventry City	3 - 2	Grimsby Town
31 Ago 02	Finalizado	Coventry City	0 - 1	Nottingham Forest
26 Ago 02	Finalizado	Watford	5 - 2	Coventry City
24 Ago 02	Finalizado	Coventry City	1 - 0	Crystal Palace
17 Ago 02	Finalizado	Reading	1 - 2	Coventry City
13 Ago 02	Finalizado	Brighton & Hove Albion	0 - 0	Coventry City
10 Ago 02	Finalizado	Coventry City	2 - 1	Sheffield United

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Gordon1

Chippo1

Youssef Safri1

Craig Hignett1

C. Davenport1

Plantilla del Coventry City Temporada 2002/2003

		Edad	Altura	Peso
Portero
	B. Williams	41	188	85	-	-	-
	Fabien Debec	48	-	-	-	-	-
	Gary Montgomery	41	186	85	-	-	-
23	Morten Hyldgaard	46	198	96	-	-	1
	R. Brush	39	186	89	-	-	-
Defensa
2	A. Whing	39	183	76	-	-	1
5	C. Davenport	41	193	88	3	1	4
	D. Pipe	40	175	77	2	-	-
	G. Caldwell	42	180	74	-	1	5
	Gordon	51	183	86	1	1	3
4	M. Konjic	53	190	83	-	-	4
2	Richard Shaw	55	178	80	-	-	6
	Seán Cooney	40	-	-	-	-	-
	Steven Walsh	59	190	93	-	-	-
Centrocampista
	Betts	42	178	70	-	-	-
	Brian Kerr	42	173	70	-	-	-
	Chippo	50	180	76	-	1	7
	Christian Yulu	39	-	-	-	-	-
	Craig Pead	42	175	73	1	-	3
	Craig Strachan	41	173	67	-	-	-
	David Thompson	46	170	63	-	-	1
	Edward Stanford	39	170	66	-	-	1
10	G. Mcallister	59	185	75	7	-	3
	G. Mcsheffrey	41	173	66	4	1	4
16	I. Osbourne	37	178	75	-	-	-
	J. Eustace	44	178	75	4	-	7
	L. Delorge	44	179	77	-	-	-
	L. Fowler	40	170	70	-	-	-
	M. Noon	40	183	76	-	-	-
25	Mcmaster	41	178	75	-	-	-
	Normann	46	180	76	1	-	-
	Quinn	44	183	77	-	-	-
	Ritchie Partridge	43	173	71	4	-	2
	Strachan	45	178	73	-	-	-
	T. Bates	38	-	-	-	-	-
	V. Engonga	58	181	84	-	-	-
6	Youssef Safri	47	188	64	-	1	7
Delantero
	Avun Jephcott	40	188	-	-	-	-
	B. Mackey	37	-	-	-	-	-
	Craig Hignett	54	175	71	2	1	2
	Dean Holdsworth	55	180	71	-	-	1
	J. Bothroyd	41	191	82	8	-	4
	Joachim	49	168	76	2	-	-
	L. Hughes	47	178	72	1	-	1
	M. Jansen	46	180	71	2	-	2
	Mills	53	188	80	4	-	-
	Sara	47	187	79	1	-	-

Noticias del Coventry City

Ver últimas noticias

El Norwich ficha a Maddison, del Coventry

BeSoccer - Martes, 02 Febrero 2016

0 398

James Maddison se ha convertido en nuevo jugador del Norwich City hasta 2019, pero terminará la presente cedido en su antiguo club, el Coventry City.

El Tottenham sigue la pista a un joven centrocampista del Coventry City

BeSoccer - Jueves, 21 Enero 2016

0 503

El Tottenham Hotspur, siempre presente en infinidad de rumores, podría estar siguiendo la pista de James Maddison, centrocampista del Coventry City.

Hunt convence al Coventry y firma hasta final de temporada

BeSoccer - Viernes, 08 Enero 2016

0 110

A sus 35 años, Stephen Hunt se convierte en el último refuerzo del Coventry para esta segunda vuelta.

El Conventry firma a Ramage y da continuidad a Joe Cole

BeSoccer - Jueves, 07 Enero 2016

0 243

El central de 32 años, que la pasada temporada realizaó una pequeña aventura por el fútbol indio, se compromete con el conjunto inglés, que firma a Joe Cole hasta junio.

El Aston Villa cede a Joe Cole al modesto Coventry City

BeSoccer - Sábado, 17 Octubre 2015

0 471

El veterano futbolista añade otra muesca a su lista de equipos. La cesión será por tan solo un mes. A sus 33 años jugará en el tercer nivel del fútbol inglés.

Ver más noticias del equipo»

Competiciones que juega

Championship

Pos	Equipos		Pts
1		Portsmouth	98
2		Leicester	92
3		Sheffield United	80
4		Reading	79
5		Wolves	76
6		Nottingham Forest	74
7		Ipswich Town	70
8		Norwich City	67
9		Millwall	66
10		Wimbledon FC	65
11		Preston North End	62
12		Gillingham	62
13		Watford	60
14		Crystal Palace	59
15		Rotherham United	59
16		Burnley	55
17		Walsall	54
18		Derby County	52
19		Bradford City	52
20		Coventry City	50
21		Stoke City	50
22		Sheffield Wednesday	46
23		Brighton & Hove Albion	45
24		Grimsby Town	39

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup

USO DE MEMORIA

6,506,472 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.6984
Total Execution Time	0.7002

CADENA URL

/Coventry-City/2003

GET DATOS

$_GET['/Coventry-City/2003']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0258	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 = 'Coventry-City' AND l.year = 2003 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.0152	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=9189 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152	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=9189 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=9189 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=9189 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9189 AND type_rel = 2
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9189 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0161	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 (17533,32532,32811,35815,38991) ORDER BY n.cover_points DESC, update_date DESC
0.0211	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 = '9189' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0219	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 = '9189' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0171	(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 calendars2003 as c ON c.league_id = l.id WHERE (c.datateam1 = 9189 or c.datateam2 = 9189) AND l.year = 2003 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0218	(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 calendars2003 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 = 9189 or c.datateam2 = 9189) AND l.year = 2003 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0162	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN events2003 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 = 9189 or c.datateam2 = 9189) AND l.year = 2003)
0.0170	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=9189 AND l.year in (2002,2003,2004) 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 (23226,14435,466) 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.0174	SELECT count(id) as num_players from rel_players WHERE league_id = 466 AND teamId = 9189
0.0193	SELECT count(id) as num_players from rel_players WHERE league_id = 14435 AND teamId = 9189
0.0206	SELECT count(id) as num_players from rel_players WHERE league_id = 23226 AND teamId = 9189
0.0149	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 = '9189' 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 = '9189' and rp.type = 4
0.0146	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 = '9189' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0167	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 events2003 e ON e.player_id = p.id AND e.league_id = 465 WHERE rp.league_id = 465 AND rp.teamId = 9189 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.0163	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 events2003 e ON e.player_id = p.id AND e.league_id = 465 WHERE rp.league_id = 465 AND rp.teamId = 9189 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162	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 events2003 e ON e.player_id = p.id AND e.league_id = 465 WHERE rp.league_id = 465 AND rp.teamId = 9189 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 9189 AND rp.league_id = 465 AND l.year= 2003 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0153	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=12427 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=12427
0.0153	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12427 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.0157	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12427 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0158	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12427 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0151	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12427 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0151	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=12427 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Resultados de Fútbol

Coventry City

Información sobre Coventry City

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

FA Cup

EFL Cup

Championship

Premier League

Partidos Amistosos

EFL Trophy

League One

Championship - Play Offs Ascenso

Community Shield

Copa de Ferias

League Two - Play Offs Ascenso

League Two

Partidos del Coventry City

Estadísticas

Plantilla del Coventry City Temporada 2002/2003

Noticias del Coventry City

El Norwich ficha a Maddison, del Coventry

El Tottenham sigue la pista a un joven centrocampista del Coventry City

Hunt convence al Coventry y firma hasta final de temporada

El Conventry firma a Ramage y da continuidad a Joe Cole

El Aston Villa cede a Joe Cole al modesto Coventry City

Coventry City

Selecciona un equipo

Competiciones que juega

Championship

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup


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