12 Mar 14	Finalizado	PSG	2 - 1	B. Leverkusen	111
18 Feb 14	Finalizado	B. Leverkusen	0 - 4	PSG	204
10 Dic 13	Finalizado	Real Sociedad	0 - 1	B. Leverkusen	78
27 Nov 13	Finalizado	B. Leverkusen	0 - 5	Manchester United	43
05 Nov 13	Finalizado	Shakhtar Donetsk	0 - 0	B. Leverkusen	21
23 Oct 13	Finalizado	B. Leverkusen	4 - 0	Shakhtar Donetsk	42
02 Oct 13	Finalizado	B. Leverkusen	2 - 1	Real Sociedad	117
17 Sep 13	Finalizado	Manchester United	4 - 2	B. Leverkusen	25

Bundesliga »

10 May 14	Finalizado	B. Leverkusen	2 - 1	Werder Bremen	12
03 May 14	Finalizado	Eintracht Frankfurt	0 - 2	B. Leverkusen	10
26 Abr 14	Finalizado	B. Leverkusen	2 - 2	B. Dortmund	146
20 Abr 14	Finalizado	Nürnberg	1 - 4	B. Leverkusen	19
13 Abr 14	Finalizado	B. Leverkusen	2 - 1	Hertha BSC	15
04 Abr 14	Finalizado	Hamburger SV	2 - 1	B. Leverkusen	61
29 Mar 14	Finalizado	B. Leverkusen	1 - 1	Eintracht Braunschweig	66
26 Mar 14	Finalizado	FC Augsburg	1 - 3	B. Leverkusen	17
23 Mar 14	Finalizado	B. Leverkusen	2 - 3	Hoffenheim	179
15 Mar 14	Finalizado	Bayern München	2 - 1	B. Leverkusen	68
08 Mar 14	Finalizado	Hannover 96	1 - 1	B. Leverkusen	11
01 Mar 14	Finalizado	B. Leverkusen	0 - 1	Mainz 05	45
22 Feb 14	Finalizado	Wolfsburg	3 - 1	B. Leverkusen	24
15 Feb 14	Finalizado	B. Leverkusen	1 - 2	Schalke 04	29
07 Feb 14	Finalizado	B. Mönchengladbach	0 - 1	B. Leverkusen	57
01 Feb 14	Finalizado	B. Leverkusen	2 - 1	Stuttgart	38
25 Ene 14	Finalizado	SC Freiburg	3 - 2	B. Leverkusen	32
21 Dic 13	Finalizado	Werder Bremen	1 - 0	B. Leverkusen	9
15 Dic 13	Finalizado	B. Leverkusen	0 - 1	Eintracht Frankfurt	20
07 Dic 13	Finalizado	B. Dortmund	0 - 1	B. Leverkusen	145
30 Nov 13	Finalizado	B. Leverkusen	3 - 0	Nürnberg	8
23 Nov 13	Finalizado	Hertha BSC	0 - 1	B. Leverkusen	8
09 Nov 13	Finalizado	B. Leverkusen	5 - 3	Hamburger SV	15
02 Nov 13	Finalizado	Eintracht Braunschweig	1 - 0	B. Leverkusen	11
26 Oct 13	Finalizado	B. Leverkusen	2 - 1	FC Augsburg	4
18 Oct 13	Finalizado	Hoffenheim	1 - 2	B. Leverkusen	20
05 Oct 13	Finalizado	B. Leverkusen	1 - 1	Bayern München	30
28 Sep 13	Finalizado	B. Leverkusen	2 - 0	Hannover 96	3
21 Sep 13	Finalizado	Mainz 05	1 - 4	B. Leverkusen	9
14 Sep 13	Finalizado	B. Leverkusen	3 - 1	Wolfsburg	14
31 Ago 13	Finalizado	Schalke 04	2 - 0	B. Leverkusen	10
24 Ago 13	Finalizado	B. Leverkusen	4 - 2	B. Mönchengladbach	5
17 Ago 13	Finalizado	Stuttgart	0 - 1	B. Leverkusen	2
10 Ago 13	Finalizado	B. Leverkusen	3 - 1	SC Freiburg	8

DFB Pokal »

12 Feb 14	Finalizado	B. Leverkusen	0 - 1	Kaiserslautern	28
04 Dic 13	Finalizado	SC Freiburg	1 - 2	B. Leverkusen	3
24 Sep 13	Finalizado	Arminia Bielefeld	0 - 2	B. Leverkusen	2
03 Ago 13	Finalizado	Lippstadt 08	1 - 6	B. Leverkusen	1

Partidos Amistosos »

14 May 14	Finalizado	Koblenz	1 - 6	B. Leverkusen	0
27 Jul 13	Finalizado	Vitesse	0 - 4	B. Leverkusen	1
17 Jul 13	Finalizado	B. Leverkusen	3 - 0	Udinese	0
10 Jul 13	Finalizado	B. Leverkusen	2 - 0	KV Mechelen	0

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del B. Leverkusen Temporada 2013/2014

		Edad	Altura	Peso
Portero
25	Andrés Palop	50	185	80	-	-	-
1	B. Leno	32	190	83	-	-	1
22	D. Yelldell	42	194	88	-	-	-
Defensa
5	E. Spahić	43	183	77	2	1	9
26	G. Donati	34	178	80	-	-	4
2	K. Stafylidis	30	178	74	-	-	-
8	L. Bender	34	183	75	3	1	4
21	O. Toprak	34	187	81	1	-	5
4	P. Wollscheid	35	194	84	-	-	6
14	R. Hilbert	39	182	80	1	-	2
17	S. Boenisch	37	191	85	1	-	2
Centrocampista
20	A. Guardado	37	167	60	-	-	2
10	Emre Can	30	186	86	3	-	9
27	G. Castro	36	171	72	5	-	7
13	J. Hegeler	36	193	85	-	-	3
19	Julian Brandt	27	185	83	2	-	1
37	M. Wagener	29	181	74	-	-	-
3	S. Reinartz	35	189	84	-	-	5
24	Seung-Woo Ryu	30	171	67	-	-	-
6	Simon Rolfes	42	191	83	4	-	1
Delantero
9	E. Derdiyok	35	191	90	1	-	2
7	Heung-Min Son	31	184	76	10	-	1
15	Levin Öztunali	28	184	74	-	-	-
23	R. Kruse	35	179	70	2	-	1
11	S. Kießling	40	191	78	15	-	3
18	S. Sam	36	174	70	8	-	2

Noticias del B. Leverkusen

Ver últimas noticias

Bayer, Inter... y ahora PSG

Javier García Márquez - Martes, 23 Abril 2024

13 42.805

El Paris Saint-Germain puede convertirse en el tercer campeón de las grandes ligas esta temporada. Tras los triunfos del Bayer Leverkusen e Inter de Milán, los de Luis Enrique pueden conseguir su corona este mismo miércoles.

Internacional medita la nueva oferta de Bayer por Aránguiz

BeSoccer - Martes, 04 Agosto 2015

0 271

Bayer Leverkusen parece decidido a hacerse con los servicios del internacional chileno Charles Aránguiz, algo que el propio jugador desea, tal y como hizo saber a su club el pasado fin de semana.

El Leverkusen golea a un Levante en inferioridad numérica

BeSoccer - Jueves, 30 Julio 2015

0 283

El Bayer Leverkusen goleó hoy cómodamente al Levante, en el segundo amistoso de la concentración en Holanda, en un partido en el que el equipo valenciano mostró un discreto rendimiento defensivo y jugó con diez futbolistas durante una hora tras la expulsión de Juanfran García en el minuto 28.

A Charles Aránguiz se lo rifan

BeSoccer - Miércoles, 29 Julio 2015

0 350

Leicester, Olympique de Marsella y Bayer son los equipos que están tratando de hacerse con el fichaje de Aránguiz.

La alternativa a De Gea es Leno

BeSoccer - Viernes, 26 Junio 2015

0 296

El fichaje de David de Gea por parte del Real Madrid aún no está cerrado, por lo que Bend Leno será la segunda opción de cara a la portería merengue.

Ver más noticias del equipo»

Competiciones que juega

Grupo 8

Bundesliga

Pos	Equipos		Pts
1		Bayern München	90
2		B. Dortmund	71
3		Schalke 04	64
4		B. Leverkusen	61
5		Wolfsburg	60
6		B. Mönchengladbach	55
7		Mainz 05	53
8		FC Augsburg	52
9		Hoffenheim	44
10		Hannover 96	42
11		Hertha BSC	41
12		Werder Bremen	39
13		Eintracht Frankfurt	36
14		SC Freiburg	36
15		Stuttgart	32
16		Hamburger SV	27
17		Nürnberg	26
18		Eintracht Braunschweig	25

	Champions League : Bayern München, B. Dortmund, Schalke 04
	Previa de Champions : B. Leverkusen
	Europa League : Wolfsburg, B. Mönchengladbach, Mainz 05
	Playoff Descenso : Hamburger SV
	Descenso : Nürnberg, Eintracht Braunschweig

RIVALES EN Bundesliga

RIVALES EN Champions League

RIVALES EN DFB Pokal

USO DE MEMORIA

6,524,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.7633
Total Execution Time	0.7651

CADENA URL

/Bayer-Leverkusen/2014

GET DATOS

$_GET['/Bayer-Leverkusen/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0147	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 = 'Bayer-Leverkusen' AND l.year = 2014 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=3668 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=3668 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=3668 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=3668 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=3668 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=3668 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136	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 = 2440
0.0141	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 = 2470
0.0156	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 = 2822
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3668 AND type_rel = 2
0.0150	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3668 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (1312172,706,4219,4231,4873) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '3668' ORDER BY l.year DESC,cat.coefficient DESC
0.0145	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 = '3668' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0173	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 = '3668' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138	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 = 2440 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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 = 2470 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147	(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 calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 3668 or c.datateam2 = 3668) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0195	(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 calendars2014 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 = 3668 or c.datateam2 = 3668) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0178	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 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 = 3668 or c.datateam2 = 3668) AND l.year = 2014)
0.0137	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=3668 AND l.year in (2013,2014,2015) 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 (4232,4016,3977,3804,3772,2257) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 3772 AND teamId = 3668
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 4232 AND teamId = 3668
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 2257 AND teamId = 3668
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 3977 AND teamId = 3668
0.0165	SELECT count(id) as num_players from rel_players WHERE league_id = 4016 AND teamId = 3668
0.0359	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 3668
0.0165	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2014` 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 = 2440 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0160	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 events2014 e ON e.player_id = p.id AND e.league_id = 2440 WHERE rp.league_id = 2440 AND rp.teamId = 3668 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.0151	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 events2014 e ON e.player_id = p.id AND e.league_id = 2440 WHERE rp.league_id = 2440 AND rp.teamId = 3668 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 events2014 e ON e.player_id = p.id AND e.league_id = 2440 WHERE rp.league_id = 2440 AND rp.teamId = 3668 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 3668 AND rp.league_id = 2440 AND l.year= 2014 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=51321 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=51321
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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51321 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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51321 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0134	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51321 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0140	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51321 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0142	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51321 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 2440 ORDER BY nameShow LIMIT 100


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

B. Leverkusen

Información sobre B. Leverkusen

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del B. Leverkusen