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

Celta

Entrenador: Claudio Giráldez

Presidente: Carlos Mouriño

Temporada 1999/2000

Información sobre Celta

Enviar Datos

Información

Nombre del equipo Celta
Nombre completo Real Club Celta de Vigo SAD
Nombre corto CEL
País España
Ciudad Vigo
Presidente Carlos Mouriño
Entrenador Claudio Giráldez
URL del equipo en RF //m.resultados-futbol.com/Celta

Otros Datos

Año de Fundación 1923
Patrocinador Estrella Galicia
Equipo Filial Celta B
Marca de Ropa Adidas
Lugar de entrenamiento Ciudad Deportiva Afouteza
Socios 24000

Internet

Sitio Web www.rccelta.es/
Twitter principal @RCCelta

Información sobre el estadio

Nombre del estadio Abanca Balaídos
Capacidad 28700
Dirección Avenida de Balaídos
Teléfono 986 11 09 00
Fax 986 29 20 40
Año de construcción 1928
Tamaño 105 x 69 metros

Histórico de participación

Copa del Rey

101 veces

(2025, 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, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1928, 1927, 1927, 1926, 1926, 1925, 1925, 1924)

Primera División

58 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2007, 2006, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1990, 1989, 1988, 1986, 1983, 1979, 1977, 1975, 1974, 1973, 1972, 1971, 1970, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1944, 1943, 1942, 1941, 1940)

Segunda División

32 veces

(2012, 2011, 2010, 2009, 2008, 2005, 1992, 1991, 1987, 1985, 1984, 1982, 1980, 1978, 1976, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1945, 1936, 1935, 1934, 1933, 1932, 1929)

Partidos Amistosos

30 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)

Europa League Grupo 0

10 veces

(2017, 2017, 2007, 2007, 2003, 2002, 2001, 2000, 1999, 1972)

Segunda - Play Offs Ascenso

9 veces

(2011, 1966, 1961, 1960, 1953, 1945, 1940, 1936, 1935)

Copa de la Liga de Segunda División

2 veces

(1985, 1984)

Fase Previa Champions League Grupo 3

1 vez

(2004)

Partidos del Celta

Ir al LIVESCORE

Primera División »

19 May 00	Finalizado	Barcelona	2 - 2	Celta	0
14 May 00	Finalizado	Celta	0 - 0	Valencia	0
07 May 00	Finalizado	Málaga	0 - 1	Celta	0
30 Abr 00	Finalizado	Celta	2 - 1	RC Deportivo	0
22 Abr 00	Finalizado	Athletic	1 - 0	Celta	0
16 Abr 00	Finalizado	Celta	0 - 0	Numancia	0
09 Abr 00	Finalizado	Real Madrid	1 - 0	Celta	0
02 Abr 00	Finalizado	Celta	1 - 1	Real Valladolid	0
26 Mar 00	Finalizado	Real Betis	0 - 0	Celta	0
19 Mar 00	Finalizado	Celta	1 - 1	Deportivo Alavés	0
12 Mar 00	Finalizado	Espanyol	3 - 0	Celta	0
05 Mar 00	Finalizado	Celta	2 - 0	Racing	0
27 Feb 00	Finalizado	Real Zaragoza	2 - 1	Celta	0
20 Feb 00	Finalizado	Mallorca	1 - 0	Celta	1
13 Feb 00	Finalizado	Celta	4 - 1	Real Sociedad	0
06 Feb 00	Finalizado	Rayo Vallecano	1 - 0	Celta	0
29 Ene 00	Finalizado	Celta	0 - 1	Atlético	2
23 Ene 00	Finalizado	Sevilla	0 - 1	Celta	0
16 Ene 00	Finalizado	Celta	5 - 3	Real Oviedo	0
09 Ene 00	Finalizado	Celta	0 - 2	Barcelona	0
04 Ene 00	Finalizado	Valencia	1 - 1	Celta	1
22 Dic 99	Finalizado	Celta	2 - 4	Málaga	2
18 Dic 99	Finalizado	RC Deportivo	1 - 0	Celta	0
12 Dic 99	Finalizado	Celta	1 - 1	Athletic	0
05 Dic 99	Finalizado	Numancia	3 - 1	Celta	0
28 Nov 99	Finalizado	Celta	1 - 0	Real Madrid	1
21 Nov 99	Finalizado	Real Valladolid	1 - 3	Celta	0
07 Nov 99	Finalizado	Celta	5 - 1	Real Betis	0
31 Oct 99	Finalizado	Deportivo Alavés	1 - 0	Celta	0
24 Oct 99	Finalizado	Celta	2 - 1	Espanyol	0
17 Oct 99	Finalizado	Racing	3 - 0	Celta	0
13 Oct 99	Finalizado	Celta	2 - 1	Real Zaragoza	0
03 Oct 99	Finalizado	Celta	1 - 0	Mallorca	0
25 Sep 99	Finalizado	Real Sociedad	0 - 2	Celta	0
19 Sep 99	Finalizado	Celta	0 - 1	Rayo Vallecano	0
12 Sep 99	Finalizado	Atlético	1 - 2	Celta	0
29 Ago 99	Finalizado	Celta	2 - 1	Sevilla	0
22 Ago 99	Finalizado	Real Oviedo	1 - 0	Celta	0

Europa League »

23 Mar 00	Finalizado	Lens	2 - 1	Celta	1
16 Mar 00	Finalizado	Celta	0 - 0	Lens	0
09 Mar 00	Finalizado	Celta	4 - 0	Juventus	5
02 Mar 00	Finalizado	Juventus	1 - 0	Celta	2
09 Dic 99	Finalizado	Benfica	1 - 1	Celta	8
25 Nov 99	Finalizado	Celta	7 - 0	Benfica	8
04 Nov 99	Finalizado	Celta	2 - 0	Aris Thessaloniki	1
19 Oct 99	Finalizado	Aris Thessaloniki	2 - 2	Celta	0
30 Sep 99	Finalizado	Celta	4 - 0	Lausanne Sports	0
16 Sep 99	Finalizado	Lausanne Sports	3 - 2	Celta	0

Copa del Rey »

01 Feb 00	Finalizado	Celta	0 - 1	Espanyol
19 Ene 00	Finalizado	Espanyol	2 - 1	Celta
12 Ene 00	Finalizado	Celta	4 - 2	Real Sporting
15 Dic 99	Finalizado	Real Sporting	0 - 3	Celta

Partidos Amistosos »

11 Ago 00

Finalizado

Celta

1 - 1

Roma

Trofeo Teresa Herrera »

	15 Ago 99	Finalizado	Celta	1 - 0	Boca Juniors			0
	13 Ago 99	Finalizado	RC Deportivo	1 - 3	Celta			0

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Coira1

Plantilla del Celta Temporada 1999/2000

		Edad	Altura	Peso
Portero
13	José Manuel Pinto	48	185	82	-	-	1
1	Richard Dutruel	51	192	86	-	-	-
Defensa
15	Adriano	51	182	80	-	-	-
18	Coira	44	175	69	-	1	3
4	F. Cáceres	55	180	75	1	1	10
19	Goran Djorovic	52	185	79	1	1	8
29	Iago Bouzón	40	180	74	-	-	-
2	J. Velasco	46	179	75	1	1	8
14	Juanfran	47	183	78	2	2	11
20	Nelson Vivas	54	166	66	-	1	4
21	Sergio	46	191	81	1	-	7
Centrocampista
10	A. Mostovoi	55	177	75	6	1	11
24	Bruno Caires	48	182	80	-	-	-
23	C. Makélélé	51	170	64	1	1	8
16	Celades	48	175	71	1	-	6
24	Djamel Belmadi	48	-	-	-	-	-
5	E. Giovanella	53	178	70	-	1	15
11	Gustavo López	51	175	71	6	-	7
6	Mazinho	58	176	74	-	-	-
7	Tomás	53	184	80	1	-	2
8	V. Karpin	55	185	76	6	-	14
Delantero
17	Benni Mccarthy	46	182	76	8	1	2
9	H. Revivo	52	177	65	2	-	2
12	I. Kaviedes	46	182	71	-	-	2
28	Mena	45	178	73	-	-	-
12	R. Hoogendorp	49	179	80	-	-	-
22	Turdó	45	183	75	7	-	1

Noticias del Celta

Ver últimas noticias

Posibles alineaciones del Celta vs Villarreal

BeSoccer - Viernes, 03 Mayo 2024

0 249

Estos son los onces posibles del Celta-Villarreal, juego de la 34ª jornada de Primera División 2023-24 que se disputará en el Estadio Abanca Balaídos de la ciudad gallega.

LaLiga EA Sports: lesionados, sancionados y apercibidos de la jornada 34

BeSoccer - Viernes, 03 Mayo 2024

11 47.351

La actualidad de los jugadores lesionados, sancionados y apercibidos en los equipos de LaLiga EA Sports para la jornada 34 de la Primera División Española.

Lío entre Celta y Levante por Giráldez

BeSoccer - Jueves, 02 Mayo 2024

1 11.507

Según informó 'Marca', el Levante había llegado a un acuerdo con Giráldez para que dirigiera al conjunto 'granota' para la 2024-25. Sin embargo, el Celta tocó a su puerta y terminó marchándose a Balaídos, motivo por el cual se especula ahora con la posibilidad de que el conjunto vigués tenga que pagar una indemnización al cuadro levantino. Sobre ello habló Felipe en la previa del choque ante el Villarreal B.

¿Quién lleva más penaltis a favor en LaLiga EA Sports 2023-24?

BeSoccer - Jueves, 02 Mayo 2024

40 33.944

El favoritismo arbitral de LaLiga es un tema recurrente, así que desde BeSoccer intentaremos responder con estadísticas a todas estas dudas que se generan. Por ejemplo: ¿a qué equipo le pitan más penaltis a favor en Primera 2023-24?

Horarios y partidos de la jornada 34 de LaLiga EA Sports 2023-24

BeSoccer - Miércoles, 01 Mayo 2024

6 40.911

Con la temporada 2023-24 ya iniciada, ahora los conjuntos que conforman la Primera División Española se cruzan en una nueva jornada para seguir la senda de un campeonato prometedor. Encuentra todos los horarios y fechas de la trigésimo cuarta jornada en LaLiga EA Sports.

Ver más noticias del equipo»

Competiciones que juega

Primera División

Pos	Equipos		Pts
1		RC Deportivo	69
2		Barcelona	64
3		Valencia	64
4		Real Zaragoza	63
5		Real Madrid	62
6		Deportivo Alavés	61
7		Celta	53
8		Real Valladolid	53
9		Rayo Vallecano	52
10		Mallorca	51
11		Athletic	50
12		Málaga	48
13		Real Sociedad	47
14		Espanyol	47
15		Racing	46
16		Real Oviedo	45
17		Numancia	45
18		Real Betis	42
19		Atlético	38
20		Sevilla	28

	Champions League : RC Deportivo, Barcelona, Real Madrid
	Previa de Champions : Valencia
	UEFA : Real Zaragoza, Deportivo Alavés, Rayo Vallecano, Espanyol
	Intertoto : Celta, Mallorca
	Descenso : Real Betis, Atlético, Sevilla

RIVALES EN Copa del Rey

RIVALES EN Europa League

RIVALES EN Primera División

USO DE MEMORIA

6,760,904 bytes

BENCHMARKS

Loading Time Base Classes	0.0029
Controller Execution Time ( Home / Category )	0.7573
Total Execution Time	0.7602

CADENA URL

/Celta/2000

GET DATOS

$_GET['/Celta/2000']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0170	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 = 'Celta' 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.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=712 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=712 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=712 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=712 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=712 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=712 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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 = 160
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 = 10974
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 = 21648
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 = 44817
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 = 72702
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=712 AND type_rel = 2
0.0153	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 712 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 (1313766,1188739,1313617,1278031,1257644) ORDER BY n.cover_points DESC, update_date DESC
0.0139	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 = '712' AND l.year = 2000 ORDER BY l.year DESC,cat.coefficient DESC
0.0143	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 = '712' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 21648 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 = 10974 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 160 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153	(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 = 712 or c.datateam2 = 712) AND l.year = 2000 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0178	(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 = 712 or c.datateam2 = 712) AND l.year = 2000 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0175	(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 = 712 or c.datateam2 = 712) AND l.year = 2000)
0.0202	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=712 AND l.year in (1999,2000,2001) ORDER BY l.id DESC, l.year DESC ;
0.0137	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 (72702,44818,21682,12020,10975,161) 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.0169	SELECT count(id) as num_players from rel_players WHERE league_id = 161 AND teamId = 712
0.0182	SELECT count(id) as num_players from rel_players WHERE league_id = 10975 AND teamId = 712
0.0198	SELECT count(id) as num_players from rel_players WHERE league_id = 21682 AND teamId = 712
0.0168	SELECT count(id) as num_players from rel_players WHERE league_id = 12020 AND teamId = 712
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 44818 AND teamId = 712
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 72702 AND teamId = 712
0.0145	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 = 160 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0145	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 = 160 WHERE rp.league_id = 160 AND rp.teamId = 712 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.0137	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 = 160 WHERE rp.league_id = 160 AND rp.teamId = 712 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 160 WHERE rp.league_id = 160 AND rp.teamId = 712 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 = 712 AND rp.league_id = 160 AND l.year= 2000 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0129	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=4648 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=4648
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=4648 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.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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=4648 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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=4648 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=4648 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=4648 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Celta

Información sobre Celta

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Celta

Estadísticas

Plantilla del Celta Temporada 1999/2000

Noticias del Celta

Celta

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Europa League

RIVALES EN Primera División