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

Manchester City

Entrenador: Pep Guardiola

Temporada 1999/2000

Información sobre Manchester City

Enviar Datos

Información

Nombre del equipo Manchester City
Nombre completo Manchester City Football Club
Nombre corto MAC
País Inglaterra
Ciudad Mánchester
Entrenador Pep Guardiola
URL del equipo en RF testing.resultados-futbol.com/Manchester-City-Fc

Otros Datos

Año de Fundación 1880
Patrocinador Etihad Airways
Marca de Ropa Puma
Lugar de entrenamiento Etihad Campus
Socios 19500

Internet

Sitio Web www.mcfc.co.uk/
Twitter principal @ManCity

Información sobre el estadio

Nombre del estadio Etihad Stadium
Capacidad 55097
Dirección Rowsley Street
Teléfono 0870 062 1894
Fax 0161 438 7999
Año de construcción 2003
Tamaño 105x68

Histórico de participación

Premier League

95 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2001, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1987, 1986, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1950, 1949, 1948, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1915, 1914, 1913, 1912, 1911, 1909, 1908, 1907, 1906, 1905, 1904, 1902, 1901, 1900)

FA Cup

71 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, 1981, 1979, 1977, 1973, 1970, 1969, 1966, 1964, 1963, 1956, 1955, 1953, 1948, 1938, 1936, 1934, 1933, 1932, 1928, 1926, 1924, 1914, 1911, 1910, 1908, 1905, 1904, 1903, 1902)

EFL 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, 1982, 1981, 1979, 1978, 1976, 1974, 1970, 1968, 1966, 1964, 1963)

Championship

26 veces

(2002, 2000, 1998, 1997, 1989, 1988, 1985, 1984, 1966, 1965, 1964, 1951, 1947, 1940, 1939, 1928, 1927, 1910, 1903, 1899, 1898, 1897, 1896, 1895, 1894, 1893)

Champions League Grupo 0

25 veces

(2024, 2024, 2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2012, 1969)

Community Shield

15 veces

(2024, 2023, 2022, 2020, 2019, 2015, 2013, 2012, 1974, 1973, 1970, 1969, 1957, 1938, 1935)

Partidos Amistosos

14 veces

(2025, 2024, 2023, 2022, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Europa League Grupo 0

10 veces

(2012, 2011, 2011, 2009, 2009, 2004, 1979, 1978, 1977, 1973)

Fase Previa Europa League Grupo 4

4 veces

(2011, 2009, 2009, 2004)

Amistosos Selecciones No Oficiales

1 vez

(2016)

Fase Previa Champions League Grupo 4

1 vez

(2017)

Partidos del Manchester City

Ir al LIVESCORE

FA Cup »

	09 Ene 00	Finalizado	Manchester City	2 - 5	Leeds United			0
	12 Dic 99	Finalizado	Chester	1 - 4	Manchester City			0

EFL Cup »

21 Sep 99	Finalizado	Southampton	4 - 3	Manchester City	1
15 Sep 99	Finalizado	Manchester City	0 - 0	Southampton	0
24 Ago 99	Finalizado	Burnley	0 - 1	Manchester City	0
11 Ago 99	Finalizado	Manchester City	5 - 0	Burnley	0

Championship »

07 May 00	Finalizado	Blackburn Rovers	1 - 4	Manchester City
28 Abr 00	Finalizado	Manchester City	1 - 0	Birmingham City
24 Abr 00	Finalizado	Portsmouth	2 - 2	Manchester City
22 Abr 00	Finalizado	Manchester City	2 - 0	Tranmere Rovers
15 Abr 00	Finalizado	Grimsby Town	1 - 1	Manchester City
08 Abr 00	Finalizado	Manchester City	4 - 0	Crewe Alexandra
05 Abr 00	Finalizado	Manchester City	2 - 0	Bolton Wanderers
01 Abr 00	Finalizado	Swindon Town	0 - 2	Manchester City
25 Mar 00	Finalizado	Manchester City	2 - 1	West Bromwich Albion
21 Mar 00	Finalizado	Stockport County	2 - 2	Manchester City
19 Mar 00	Finalizado	Manchester City	1 - 1	Charlton Athletic
11 Mar 00	Finalizado	Barnsley	2 - 1	Manchester City
08 Mar 00	Finalizado	Manchester City	1 - 3	Queens Park Rangers
04 Mar 00	Finalizado	Crystal Palace	1 - 1	Manchester City
26 Feb 00	Finalizado	Manchester City	1 - 1	Walsall
18 Feb 00	Finalizado	Huddersfield Town	1 - 1	Manchester City
12 Feb 00	Finalizado	Manchester City	3 - 1	Norwich City
05 Feb 00	Finalizado	Nottingham Forest	1 - 3	Manchester City
22 Ene 00	Finalizado	Sheffield United	1 - 0	Manchester City
16 Ene 00	Finalizado	Manchester City	4 - 0	Fulham
03 Ene 00	Finalizado	Crewe Alexandra	1 - 1	Manchester City
28 Dic 99	Finalizado	Manchester City	2 - 1	Grimsby Town
26 Dic 99	Finalizado	West Bromwich Albion	0 - 2	Manchester City
18 Dic 99	Finalizado	Manchester City	3 - 0	Swindon Town
08 Dic 99	Finalizado	Manchester City	1 - 2	Stockport County
03 Dic 99	Finalizado	Wolves	4 - 1	Manchester City
27 Nov 99	Finalizado	Manchester City	0 - 1	Huddersfield Town
24 Nov 99	Finalizado	Manchester City	3 - 1	Barnsley
20 Nov 99	Finalizado	Charlton Athletic	0 - 1	Manchester City
06 Nov 99	Finalizado	Queens Park Rangers	1 - 1	Manchester City
03 Nov 99	Finalizado	Manchester City	4 - 2	Portsmouth
30 Oct 99	Finalizado	Port Vale	1 - 2	Manchester City
27 Oct 99	Finalizado	Manchester City	1 - 0	Ipswich Town
23 Oct 99	Finalizado	Manchester City	2 - 0	Blackburn Rovers
19 Oct 99	Finalizado	Birmingham City	0 - 1	Manchester City
16 Oct 99	Finalizado	Tranmere Rovers	1 - 1	Manchester City
02 Oct 99	Finalizado	Manchester City	2 - 1	Port Vale
28 Sep 99	Finalizado	Norwich City	1 - 0	Manchester City
26 Sep 99	Finalizado	Ipswich Town	2 - 1	Manchester City
18 Sep 99	Finalizado	Walsall	0 - 1	Manchester City
11 Sep 99	Finalizado	Manchester City	2 - 1	Crystal Palace
30 Ago 99	Finalizado	Manchester City	1 - 0	Nottingham Forest
28 Ago 99	Finalizado	Bolton Wanderers	0 - 1	Manchester City
21 Ago 99	Finalizado	Manchester City	6 - 0	Sheffield United
14 Ago 99	Finalizado	Fulham	0 - 0	Manchester City
08 Ago 99	Finalizado	Manchester City	0 - 1	Wolves

Estadísticas

GOLEADORES

Goater23

AMARILLAS

ROJAS

Plantilla del Manchester City Temporada 1999/2000

		Edad	Altura	Peso
Portero
1	N. Weaver	45	191	83	-	-	1
13	Tommy Wright	60	186	85	-	-	-
Defensa
5	Andy Morrison	53	180	82	-	1	4
36	Danny Granville	49	185	77	2	-	3
19	Danny Tiatto	50	173	70	-	-	6
3	Edghill	49	175	70	1	-	6
4	G. Wiekens	51	183	77	1	-	5
25	Jobson	60	185	85	3	-	4
7	Prior	53	185	83	3	-	-
21	Tony Vaughan	48	186	71	-	1	2
Centrocampista
2	Crooks	46	185	80	1	-	2
8	Ian Bishop	58	178	76	2	-	1
16	Jamie Pollock	50	178	89	3	-	3
18	Jeff Whitley	49	175	64	4	-	3
17	Jim Whitley	49	-	-	-	-	-
6	Kevin Horlock	51	183	76	10	1	5
34	M. Kennedy	47	180	74	8	-	3
11	Terry Cooke	47	170	61	-	-	-
28	Tony Grant	49	178	64	-	-	1
Delantero
12	Danny Allsopp	45	-	-	-	-	-
14	G. Taylor	51	-	-	6	-	2
10	Goater	54	183	81	23	-	-
24	L. Peacock	47	183	80	-	-	-
35	Mills	53	188	80	-	-	-
9	Paul Dickov	51	165	70	5	-	4
37	Robert Taylor	53	185	86	5	-	3
29	S. Wright-Phillips	42	169	64	-	-	-

Noticias del Manchester City

Ver últimas noticias

"Sois un equipo lleno de gordos"

BeSoccer - Miércoles, 01 Mayo 2024

0 7.574

Gael Clichy desveló unas palabras de Pep Guardiola nada más llegar al Manchester City sobre el peso de la plantilla 'citizen', a la que dijo que era un equipo "lleno de jugadores gordos".

Horarios y partidos de la jornada 36 de Premier League 2023-24

BeSoccer - Miércoles, 01 Mayo 2024

4 44.507

La Premier League sigue su transcurso de partidos y con la trigésimo sexta jornada de encuentros se esperan una cantidad importante de duelos emocionantes, cosa a la que ya nos acostumbra este torneo. Encuentra aquí los días y horarios de Premier League.

Un Haaland de videojuego

BeSoccer - Martes, 30 Abril 2024

5 1.228

Erling Haaland se convertirá durante el mes de mayo en un personaje del popular videojuego 'Clash of Clans', del que es muy aficionado.

El City mantiene la Premier en su mano

BeSoccer - Domingo, 28 Abril 2024

0 1.031

El Manchester City respondió al triunfo del Arsenal con una victoria por 0-2 ante el Nottingham Forest. Con cuatro partidos por delante, los de Pep Guardiola, segundos a un punto del líder, dependen de sí mismos, pues cuentan con un partido jugado menos que su rival londinense. Gvardiol y Haaland fueron los autores de los tantos 'sky blues'.

Walker, el titán de las 250 victorias en la Premier

BeSoccer Pro - Domingo, 28 Abril 2024

2 10.662

Kyle Walker cumplió una cifra redonda ante el Nottingham Forest. La biblia estadística de BeSoccer Pro constata que el defensa del Manchester City alcanzó sus 250 victorias en la Premier League. 102 de ellas con el Tottenham, club con que dio el salto a la élite. No obstante, registró 5 triunfos con la elástica del Aston Villa en 2011. El resto, defendiendo los colores de los 'sky blues', que continúan en la pelea por el título esta temporada.

Ver más noticias del equipo»

Competiciones que juega

Grupo 7

Championship

Pos	Equipos		Pts
1		Charlton Athletic	91
2		Manchester City	89
3		Ipswich Town	87
4		Barnsley	82
5		Birmingham City	77
6		Bolton Wanderers	76
7		Wolves	74
8		Huddersfield Town	74
9		Fulham	67
10		Queens Park Rangers	66
11		Blackburn Rovers	62
12		Norwich City	57
13		Tranmere Rovers	57
14		Nottingham Forest	56
15		Crystal Palace	54
16		Sheffield United	54
17		Stockport County	54
18		Portsmouth	51
19		Crewe Alexandra	51
20		Grimsby Town	51
21		West Bromwich Albion	49
22		Walsall	46
23		Port Vale	36
24		Swindon Town	36

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup

USO DE MEMORIA

6,641,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.6950
Total Execution Time	0.6970

CADENA URL

/Manchester-City-Fc/2000

GET DATOS

$_GET['/Manchester-City-Fc/2000']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0198	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 = 'Manchester-City-Fc' AND l.year = 2000 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.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=1633 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=1633 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=1633 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=1633 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 = 468
0.0140	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 = 14442
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 = 23230
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1633 AND type_rel = 2
0.0190	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1633 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0133	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 (1313514,1254444,1313262,1313010,1312744) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '1633' AND l.year = 2000 ORDER BY l.year DESC,cat.coefficient DESC
0.0166	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 = '1633' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = 468 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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 = 23230 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 = 14442 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 calendars2000 as c ON c.league_id = l.id WHERE (c.datateam1 = 1633 or c.datateam2 = 1633) AND l.year = 2000 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0139	(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 calendars2000 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 = 1633 or c.datateam2 = 1633) AND l.year = 2000 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0140	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2000 as c ON c.league_id = l.id INNER JOIN events2000 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 = 1633 or c.datateam2 = 1633) AND l.year = 2000)
0.0187	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=1633 AND l.year in (1999,2000,2001) ORDER BY l.id DESC, l.year DESC ;
0.0134	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 (23233,14534,485,468,330) 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.0175	SELECT count(id) as num_players from rel_players WHERE league_id = 330 AND teamId = 1633
0.0166	SELECT count(id) as num_players from rel_players WHERE league_id = 468 AND teamId = 1633
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 485 AND teamId = 1633
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 14534 AND teamId = 1633
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 23233 AND teamId = 1633
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* `tables2000` 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 = 468 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0140	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 events2000 e ON e.player_id = p.id AND e.league_id = 468 WHERE rp.league_id = 468 AND rp.teamId = 1633 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.0139	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 events2000 e ON e.player_id = p.id AND e.league_id = 468 WHERE rp.league_id = 468 AND rp.teamId = 1633 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143	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 events2000 e ON e.player_id = p.id AND e.league_id = 468 WHERE rp.league_id = 468 AND rp.teamId = 1633 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 = 1633 AND rp.league_id = 468 AND l.year= 2000 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0139	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=14324 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0129	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=14324
0.0165	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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14324 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.0166	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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14324 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0160	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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14324 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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14324 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0132	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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14324 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


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

Manchester City

Información sobre Manchester City

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Manchester City

Estadísticas

Plantilla del Manchester City Temporada 1999/2000

Noticias del Manchester City

Manchester City

Selecciona un equipo

Competiciones que juega

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup