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

Levante

Entrenador: Felipe Miñambres

Temporada 1980/1981

Información sobre Levante

Enviar Datos

Información

Nombre del equipo Levante
Nombre completo Levante Unión Deportiva
Nombre corto LEV
País España
Ciudad Valencia
Entrenador Felipe Miñambres
URL del equipo en RF testing.resultados-futbol.com/Levante

Otros Datos

Año de Fundación 1909
Equipo Filial At. Levante
Marca de Ropa Macron
Socios 15000

Internet

Sitio Web www.levanteud.com/
Twitter principal @LevanteUD

Información sobre el estadio

Nombre del estadio Ciutat de València
Capacidad 25354
Dirección Calle San Vicente de Paúl 44
Teléfono 902 22 03 04
Fax 96 337 95 31
Año de construcción 1969
Tamaño 107 x 69 metros

Histórico de participación

Copa del Rey

72 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, 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, 1950, 1949, 1948, 1947, 1943, 1942, 1941, 1940)

Segunda División

40 veces

(2024, 2023, 2017, 2010, 2009, 2006, 2004, 2003, 2002, 2001, 2000, 1998, 1997, 1991, 1990, 1982, 1981, 1980, 1977, 1974, 1968, 1967, 1966, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1955, 1952, 1951, 1950, 1949, 1948, 1947, 1942, 1941, 1940)

Primera División

16 veces

(2022, 2021, 2020, 2019, 2018, 2016, 2015, 2014, 2013, 2012, 2011, 2008, 2007, 2005, 1965, 1964)

Tercera División Grupo 6

16 veces

(1987, 1984, 1983, 1976, 1975, 1973, 1972, 1971, 1970, 1969, 1956, 1954, 1953, 1946, 1945, 1944)

Partidos Amistosos

14 veces

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

Segunda División B Grupo 3

12 veces

(1999, 1996, 1995, 1994, 1993, 1992, 1989, 1988, 1986, 1985, 1979, 1978)

Segunda División - Play Offs Permanencia

3 veces

(1975, 1943, 1942)

Fase Previa Europa League Grupo 4

1 vez

(2013)

Partidos del Levante

Ir al LIVESCORE

Segunda División »

24 May 81	Finalizado	Racing	1 - 0	Levante	0
17 May 81	Finalizado	Levante	0 - 2	Recreativo	0
10 May 81	Finalizado	Linares CF	3 - 1	Levante	0
03 May 81	Finalizado	Levante	1 - 0	CD Castellón	0
26 Abr 81	Finalizado	Atlético B	2 - 3	Levante	0
19 Abr 81	Finalizado	Rayo Vallecano	0 - 0	Levante	0
12 Abr 81	Finalizado	Levante	2 - 2	Real Oviedo	3
05 Abr 81	Finalizado	Cádiz	2 - 0	Levante	0
29 Mar 81	Finalizado	Levante	2 - 4	CD Málaga	0
22 Mar 81	Finalizado	Deportivo Alavés	1 - 0	Levante	0
15 Mar 81	Finalizado	Levante	1 - 0	Barakaldo	0
08 Mar 81	Finalizado	Granada	1 - 0	Levante	0
01 Mar 81	Finalizado	Levante	1 - 0	Palencia	0
22 Feb 81	Finalizado	RM Castilla	1 - 2	Levante	0
15 Feb 81	Finalizado	Levante	2 - 2	Getafe Deportivo	0
08 Feb 81	Finalizado	AgD Ceuta	1 - 0	Levante	0
01 Feb 81	Finalizado	Levante	0 - 1	CE Sabadell	0
25 Ene 81	Finalizado	Elche	2 - 0	Levante	0
18 Ene 81	Finalizado	Levante	2 - 0	Burgos	0
11 Ene 81	Finalizado	Levante	2 - 0	Racing	0
04 Ene 81	Finalizado	Recreativo	3 - 1	Levante	0
28 Dic 80	Finalizado	Levante	1 - 0	Linares CF	0
21 Dic 80	Finalizado	CD Castellón	0 - 1	Levante	0
14 Dic 80	Finalizado	Levante	3 - 1	Atlético B	0
07 Dic 80	Finalizado	Levante	0 - 0	Rayo Vallecano	0
30 Nov 80	Finalizado	Real Oviedo	1 - 0	Levante	0
23 Nov 80	Finalizado	Levante	1 - 0	Cádiz	0
16 Nov 80	Finalizado	CD Málaga	0 - 3	Levante	0
09 Nov 80	Finalizado	Levante	2 - 0	Deportivo Alavés	0
02 Nov 80	Finalizado	Barakaldo	1 - 0	Levante	0
26 Oct 80	Finalizado	Levante	0 - 0	Granada	0
19 Oct 80	Finalizado	Palencia	1 - 0	Levante	0
12 Oct 80	Finalizado	Levante	0 - 0	RM Castilla	0
05 Oct 80	Finalizado	Getafe Deportivo	2 - 0	Levante	0
28 Sep 80	Finalizado	Levante	2 - 1	AgD Ceuta	0
21 Sep 80	Finalizado	CE Sabadell	0 - 0	Levante	0
14 Sep 80	Finalizado	Levante	2 - 1	Elche	0
07 Sep 80	Finalizado	Burgos	1 - 1	Levante	0

Copa del Rey »

06 May 81	Finalizado	Real Sporting	3 - 0	Levante
29 Abr 81	Finalizado	Levante	0 - 2	Real Sporting
21 Ene 81	Finalizado	Levante	3 - 0	AD Almería
07 Ene 81	Finalizado	AD Almería	2 - 1	Levante
03 Dic 80	Finalizado	Levante	2 - 0	Vinaròs
19 Nov 80	Finalizado	Vinaròs	2 - 4	Levante
01 Oct 80	Finalizado	Carcaixent	1 - 1	Levante
18 Sep 80	Finalizado	Levante	1 - 0	Carcaixent

Estadísticas

GOLEADORES

Lorant10

AMARILLAS

ROJAS

Víctor1

Ferreira1

Eulate1

Agustín1

Plantilla del Levante Temporada 1980/1981

		Edad	Altura	Peso
Portero
	Barrie	73	-	-	-	-	2
	Bebic	71	-	-	-	-	1
Defensa
	Ferreira	67	177	73	-	1	2
	Gómez	62	172	67	-	-	2
	Lavado	69	-	-	-	-	-
	Oscar	62	167	68	-	-	2
	Palmer	70	-	-	-	-	-
	Sabater	67	-	-	-	-	1
	Sierra	74	-	-	-	-	-
	Varo	72	179	74	-	-	3
Centrocampista
	Agustín	66	-	-	2	1	3
	Floro Garrido	71	170	70	3	-	-
	García Granero	66	-	-	-	-	-
	Herencia	71	-	-	2	-	2
	José	72	-	-	-	-	3
	Latorre	63	183	75	1	-	-
	Lorant	71	-	-	10	-	7
Delantero
	Campuzano	67	-	-	7	-	5
	Cazaurang	62	-	-	-	-	-
	Cid	63	-	-	-	-	-
	Claudio	60	177	75	-	-	-
	Eulate	68	-	-	1	1	8
	J. Cruyff	77	179	69	2	-	2
	Luis	63	172	67	-	-	-
	Peregrín	62	-	-	-	-	-
	Ponce	68	-	-	3	-	2
	Pousada	70	180	73	3	-	1
	Saran	74	-	-	-	-	1
	Víctor	-	-	-	-	1	2

Noticias del Levante

Ver últimas noticias

El 'play off' da miedo

BeSoccer - Domingo, 28 Abril 2024

0 4.272

Jornada de infarto en la pelea por el 'play off' porque Real Oviedo y Levante dieron un paso hacia atrás cediendo en casa ante Tenerife y Cartagena por sendos 0-1. Además, el Real Valladolid asaltó el ascenso directo después de vencer al Huesca por 1-0.

El VAR desquicia al Levante: "Nos mata; cada vez que entra, perdemos"

BeSoccer - Domingo, 28 Abril 2024

1 1.619

El Levante perdió por la mínima ante el Cartagena con un gol de Ortuño. El partido tuvo polémica porque Bouldini marcó en el 96', pero el tanto fue anulado por una mano previa. El VAR revisó la jugada y canceló el tanto que habría supuesto el empate, una decisión que no sentó nada bien a Felipe Miñambres, que terminó expulsado.

Ni tirando las líneas: el Levante, furioso con el gol anulado en el 86'

BeSoccer - Sábado, 20 Abril 2024

4 13.357

Racing y Levante se repartieron los puntos en El Sardinero, pero el conjunto granota acabó muy enfadado con la actuación del árbitro González Francés. El colegiado anuló el tanto de la victoria a los visitantes en el minuto 86 y la imagen del VAR no terminó de aclarar la posición del futbolista, dejando aún más dudas sobre la acción.

Ni esto es un 0-0 ni es de Segunda

BeSoccer - Sábado, 20 Abril 2024

0 3.470

Pocas explicaciones se encuentran para el 0-0 que se dio entre el Racing y el Levante. Hubo llegadas y ocasiones como para que el marcador se hubiera estropeado de tanto trabajo, pero los porteros, sobre todo Andrés Fernández, y la falta de acierto de los atacantes conformaron el resultado 'gafas' en un partido de un ritmo impropio de esta categoría.

"De éxito no vamos a morir, la euforia es buena"

BeSoccer - Viernes, 12 Abril 2024

1 10.154

El técnico Felipe Miñambres anima a la hinchada del Levante a seguir con el ánimo alto. "La euforia contenida es buena y tenemos que disfrutar. No vamos a morir de éxito aunque ganemos otra vez", comentó antes del choque contra el Amorebieta.

Ver más noticias del equipo»

Competiciones que juega

Segunda División

Pos	Equipos		Pts
1		CD Castellón	45
2		Cádiz	45
3		Racing	45
4		Elche	45
5		Rayo Vallecano	45
6		CD Málaga	42
7		CE Sabadell	42
8		Deportivo Alavés	39
9		Levante	38
10		Real Oviedo	37
11		RM Castilla	36
12		Linares CF	36
13		Getafe Deportivo	35
14		Atlético B	35
15		Burgos	35
16		Recreativo	35
17		Granada	33
18		Palencia	32
19		Barakaldo	31
20		AgD Ceuta	29

	Ascenso : CD Castellón, Cádiz, Racing
	Descenso : Granada, Palencia, Barakaldo, AgD Ceuta

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,200,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.7687
Total Execution Time	0.7706

CADENA URL

/Levante/1981

GET DATOS

$_GET['/Levante/1981']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0144	SELECT type FROM routes WHERE alias = 'levante'
0.0167	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 = 'Levante' AND l.year = 1981 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.0146	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=1547 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=1547 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=1547 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293	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 = 5477
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1547 AND type_rel = 2
0.0243	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1547 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (1313032,1313029,1311781,1311775,1310668) ORDER BY n.cover_points DESC, update_date DESC
0.0157	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 = '1547' AND l.year = 1981 ORDER BY l.year DESC,cat.coefficient DESC
0.0159	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 = '1547' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 5477 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0212	(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 calendars1981 as c ON c.league_id = l.id WHERE (c.datateam1 = 1547 or c.datateam2 = 1547) AND l.year = 1981 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0219	(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 calendars1981 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 = 1547 or c.datateam2 = 1547) AND l.year = 1981 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0299	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1981 as c ON c.league_id = l.id INNER JOIN events1981 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 = 1547 or c.datateam2 = 1547) AND l.year = 1981)
0.0161	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=1547 AND l.year in (1980,1981,1982) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (21960,5478) 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.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 5478 AND teamId = 1547
0.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 21960 AND teamId = 1547
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1981` 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 = 5477 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0158	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 = '1547' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1547' and rp.type = 4
0.0162	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 = '1547' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1547' and rp.type = 4
0.0203	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 events1981 e ON e.player_id = p.id AND e.league_id = 5477 WHERE rp.league_id = 5477 AND rp.teamId = 1547 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.0221	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 events1981 e ON e.player_id = p.id AND e.league_id = 5477 WHERE rp.league_id = 5477 AND rp.teamId = 1547 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0211	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 events1981 e ON e.player_id = p.id AND e.league_id = 5477 WHERE rp.league_id = 5477 AND rp.teamId = 1547 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0191	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 = 1547 AND rp.league_id = 5477 AND l.year= 1981 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0170	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=95595 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0150	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=95595
0.0174	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95595 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.0173	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95595 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0172	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95595 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0167	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95595 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0172	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 events1981 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=95595 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

Levante

Información sobre Levante

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Levante

Estadísticas

Plantilla del Levante Temporada 1980/1981

Noticias del Levante

Levante

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División