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

América

Entrenador: André Jardine

Temporada 2015/2016

Información sobre América

Enviar Datos

Información

Nombre del equipo América
Nombre completo Club de Fútbol América S. A. de C. V.
Nombre corto AME
País México
Ciudad Coyoacán, Ciudad de México (D.F.)
Entrenador André Jardine
URL del equipo en RF //m.resultados-futbol.com/America

Otros Datos

Año de Fundación 1916
Patrocinador Huawei
Patrocinador Secundario Coca Cola
Marca de Ropa Nike

Internet

Sitio Web www.clubamerica.com.mx/
Twitter principal @ClubAmerica

Información sobre el estadio

Nombre del estadio Estadio Azteca
Capacidad 81070
Dirección Calzada de Tlalpan, 3465
Teléfono +52 (55) 5487 3100
Año de construcción 1966
Tamaño 105x68 metros

Histórico de participación

Liga MX - Apertura

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

Liga MX - Clausura

24 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2002)

Etapas Finales Apertura MX

18 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2011, 2010, 2008, 2007, 2006, 2003)

CONCACAF Champions Cup

17 veces

(2024, 2021, 2020, 2018, 2016, 2016, 2015, 2015, 2014, 2006, 2003, 2002, 1992, 1990, 1987, 1985, 1977)

Etapas Finales Clausura MX

16 veces

(2023, 2022, 2021, 2019, 2018, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2007, 2005, 2004, 2002)

Campeón de campeones México

14 veces

(2024, 2019, 2015, 2005, 1989, 1988, 1976, 1974, 1971, 1966, 1965, 1964, 1955, 1954)

Copa Libertadores Grupo 3

14 veces

(2011, 2011, 2008, 2008, 2007, 2007, 2004, 2004, 2002, 2002, 2000, 2000, 1998, 1998)

Partidos Amistosos

12 veces

(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2015, 2011, 1982)

Copa México - Apertura Grupo 0

7 veces

(2019, 2019, 2018, 2018, 2017, 2017, 2013)

Copa México - Clausura Grupo 0

6 veces

(2019, 2019, 2017, 2017, 2013, 2013)

International Champions Cup Grupo 1

1 vez

(2016)

Partidos del América

Ir al LIVESCORE

Mundial de Clubes »

	16 Dic 15	Finalizado	América	2 - 1	TP Mazembe			112
	13 Dic 15	Finalizado	América	1 - 2	Guangzhou FC			478

Liga MX - Clausura »

08 May 16	Finalizado	Pumas UNAM	1 - 1	América	258
01 May 16	Finalizado	América	3 - 3	Monterrey	195
24 Abr 16	Finalizado	América	0 - 1	Toluca	131
16 Abr 16	Finalizado	Querétaro	1 - 0	América	115
10 Abr 16	Finalizado	América	6 - 1	Tijuana	150
03 Abr 16	Finalizado	Chiapas	0 - 2	América	66
20 Mar 16	Finalizado	América	2 - 1	León	121
14 Mar 16	Finalizado	Chivas Guadalajara	1 - 2	América	507
06 Mar 16	Finalizado	América	4 - 1	CA Morelia	82
28 Feb 16	Finalizado	Tigres UANL	4 - 1	América	99
21 Feb 16	Finalizado	América	3 - 3	Cruz Azul	265
13 Feb 16	Finalizado	Veracruz	1 - 1	América	43
07 Feb 16	Finalizado	América	2 - 0	Santos Laguna	84
31 Ene 16	Finalizado	Dorados	0 - 3	América	154
24 Ene 16	Finalizado	América	1 - 4	Pachuca	297
17 Ene 16	Finalizado	Atlas Guadalajara	0 - 3	América	92
10 Ene 16	Finalizado	América	0 - 0	Puebla	171

Etapas Finales Apertura MX »

06 Dic 15	Finalizado	Pumas UNAM	1 - 3	América	508
04 Dic 15	Finalizado	América	0 - 3	Pumas UNAM	476
29 Nov 15	Finalizado	León	2 - 1	América	249
26 Nov 15	Finalizado	América	4 - 1	León	194

Etapas Finales Clausura MX »

22 May 16	Finalizado	Monterrey	4 - 2	América	328
19 May 16	Finalizado	América	1 - 0	Monterrey	235
16 May 16	Finalizado	América	2 - 1	Chivas Guadalajara	298
13 May 16	Finalizado	Chivas Guadalajara	0 - 0	América	345

Liga MX - Apertura »

22 Nov 15	Finalizado	América	1 - 1	Pumas UNAM	574
08 Nov 15	Finalizado	Monterrey	2 - 1	América	272
01 Nov 15	Finalizado	Toluca	2 - 3	América	469
25 Oct 15	Finalizado	América	0 - 1	Querétaro	196
17 Oct 15	Finalizado	Tijuana	0 - 2	América	133
04 Oct 15	Finalizado	América	2 - 1	Chiapas	157
30 Sep 15	Finalizado	León	3 - 0	América	191
27 Sep 15	Finalizado	América	1 - 2	Chivas Guadalajara	755
20 Sep 15	Finalizado	CA Morelia	0 - 3	América	145
13 Sep 15	Finalizado	América	0 - 1	Tigres UANL	324
30 Ago 15	Finalizado	Cruz Azul	0 - 2	América	324
23 Ago 15	Finalizado	América	3 - 1	Veracruz	307
15 Ago 15	Finalizado	Santos Laguna	0 - 2	América	177
12 Ago 15	Finalizado	América	4 - 0	Dorados	198
09 Ago 15	Finalizado	Pachuca	0 - 3	América	156
02 Ago 15	Finalizado	América	1 - 3	Atlas Guadalajara	152
27 Jul 15	Finalizado	Puebla	4 - 2	América	176

International Champions Cup »

29 Jul 15	Finalizado	América	0 - 0	Benfica	221
18 Jul 15	Finalizado	América	0 - 1	Manchester United	255
15 Jul 15	Finalizado	San Jose Earthquakes	1 - 2	América	111
12 Jul 15	Finalizado	LA Galaxy	2 - 1	América	96

CONCACAF Champions Cup »

28 Abr 16	Finalizado	América	2 - 1	Tigres UANL	286
21 Abr 16	Finalizado	Tigres UANL	0 - 2	América	177
06 Abr 16	Finalizado	América	1 - 0	Santos Laguna	329
17 Mar 16	Finalizado	Santos Laguna	0 - 0	América	80
03 Mar 16	Finalizado	América	3 - 1	Seattle Sounders	152
24 Feb 16	Finalizado	Seattle Sounders	2 - 2	América	138
21 Oct 15	Finalizado	FC Motagua	1 - 1	América	218
17 Sep 15	Finalizado	Walter Ferretti	1 - 3	América	58
20 Ago 15	Finalizado	América	1 - 0	Walter Ferretti	134
06 Ago 15	Finalizado	América	4 - 0	FC Motagua	111

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del América Temporada 2015/2016

		Edad	Altura	Peso
Portero
1	H. González	33	184	82	-	-	-
255	J. Leon	28	184	76	-	-	-
13	L. Pineda	31	186	81	-	-	-
23	M. Muñoz	44	185	82	-	-	1
Defensa
	B. Colula	28	176	68	-	-	-
4	E. Pimentel	33	177	74	-	-	2
3	G. Buron	29	165	57	-	-	1
6	M. Samudio	37	172	79	-	1	-
15	O. Mares	36	170	78	-	-	3
12	P. Aguilar	37	180	77	4	1	8
12	P. Aguilar	38	180	80	-	-	-
2	P. Goltz	38	184	80	1	1	4
17	V. Alvarado	31	182	76	-	-	1
Centrocampista
8	A. Andrade	35	184	73	2	-	4
	A. Sánchez	29	185	72	-	-	-
100	C. Blanco	51	177	70	-	-	-
31	C. Quintero	36	166	64	6	1	2
99	D. Vázquez	28	171	66	-	-	-
26	F. Rivera	29	170	63	-	-	-
	J. Gonzalez	27	179	73	-	-	-
	J. Güemez	32	172	77	-	-	-
21	J. Guerrero	36	175	69	1	-	2
10	O. Martínez	38	166	71	3	-	-
7	William Da Silva	37	175	72	1	1	4
Delantero
	A. Marín	29	168	70	-	-	1
	Alberto García	30	171	68	-	-	-
18	B. Lozano	30	169	65	-	-	-
	C. Camacho	29	177	75	-	-	-
	C. Rosel	28	165	68	-	-	-
9	D. Benedetto	33	175	72	1	-	2
16	D. Pineda	29	177	77	-	-	-
27	J. Moreno	33	179	77	1	-	-
	Luis Rey	44	184	82	2	-	-
11	M. Arroyo	37	177	72	1	1	3
24	O. Peralta	40	180	72	9	1	2
14	Rubens Sambueza	40	177	74	3	-	5

Noticias del América

Ver últimas noticias

¿Cuáles son los equipos favoritos de los pilotos de F1?

Isabel Ruiz - Miércoles, 04 Noviembre 2015

0 3.470

Las estrellas de la Fórmula 1 también son amantes del fútbol. ¿Sabes de qué equipos son?

América, blanco de burlas tras su derrota ante el Atlas

Cristina Serrano de la Cruz - Lunes, 03 Agosto 2015

0 784

Tras caer derrotado ante el Atlas en la segunda jornada del Torneo de Apertura 2015 de la Liga MX, las Águilas se convirtieron en el blanco perfecto de los internautas. Decenas de memes han inundado las redes mofándose del mal arranque del equipo.

Chivas y América no remontan vuelo

Cristina Serrano de la Cruz - Lunes, 03 Agosto 2015

0 428

Los dos equipos no han podido empezar peor la Liga Mexicana. Actualmente, ocupan los dos últimos puestos de la tabla. Chivas, además, se encuentra al fondo de la tabla de descenso.

El Benfica sufre para ganar al América

BeSoccer - Miércoles, 29 Julio 2015

0 521

El Benfica se impuso en los penaltis por 4-3 al América de México en partido de la International Champions Cup que se disputó en el estadio Azteca, de la Ciudad de México, sede mundialista en 1970 y 1986.

Santos Laguna y Puebla, triunfadores de la temporada en México

BeSoccer - Martes, 21 Julio 2015

0 959

El Santos Laguna se proclamó campeón absoluto de la Liga MX, en tanto que Puebla se impuso a Morelia en la Supercopa MX, que enfrentaba a los ganadores de las dos copas.

Ver más noticias del equipo»

Competiciones que juega

Liga MX - Clausura

Pos	Equipos		Pts
1		Monterrey	37
2		Pachuca	30
3		León	30
4		América	29
5		Chivas Guadalajara	28
6		CA Morelia	28
7		Santos Laguna	27
8		Tigres UANL	24
9		Cruz Azul	22
10		Pumas UNAM	22
11		Toluca	22
12		Puebla	22
13		Querétaro	19
14		Tijuana	18
15		Atlas Guadalajara	14
16		Dorados	14
17		Veracruz	14
18		Chiapas	12

RIVALES EN CONCACAF Champio.

RIVALES EN Mundial de Clube.

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

RIVALES EN Etapas Finales A.

RIVALES EN Etapas Finales C.

USO DE MEMORIA

6,961,576 bytes

BENCHMARKS

Loading Time Base Classes	0.0031
Controller Execution Time ( Home / Category )	1.0315
Total Execution Time	1.0346

CADENA URL

/america/2016

GET DATOS

$_GET['/america/2016']

POST DATOS

No hay datos POST existentes

CONSULTAS (60)

0.0124	SELECT type FROM routes WHERE alias = 'america'
0.0148	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 = 'america' AND l.year = 2016 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=10276 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=10276 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=10276 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=10276 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=10276 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=10276 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=10276 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=10276 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=10276 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0139	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 = 20080
0.0138	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 = 15261
0.0153	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 = 17928
0.0157	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 = 19802
0.0155	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 = 27102
0.0155	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 = 16420
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 = 19456
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 = 15028
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10276 AND type_rel = 2
0.0170	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10276 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 (20793,3244,4153,4661,4663) ORDER BY n.cover_points DESC, update_date DESC
0.0159	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 = '10276' ORDER BY l.year DESC,cat.coefficient DESC
0.0191	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 = '10276' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0207	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 = '10276' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 16420 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 17928 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 = 20080 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 = 15261 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 19802 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 = 27102 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 calendars2016 as c ON c.league_id = l.id WHERE (c.datateam1 = 10276 or c.datateam2 = 10276) AND l.year = 2016 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0205	(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 calendars2016 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 = 10276 or c.datateam2 = 10276) AND l.year = 2016 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0169	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2016 as c ON c.league_id = l.id INNER JOIN events2016 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 = 10276 or c.datateam2 = 10276) AND l.year = 2016)
0.0146	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=10276 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (38594,38027,37583,37345,35499,34075,33338,30386,27102,19456,15028) 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 = 37583 AND teamId = 10276
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 33338 AND teamId = 10276
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 34075 AND teamId = 10276
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 37345 AND teamId = 10276
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 27102 AND teamId = 10276
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 35499 AND teamId = 10276
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 38027 AND teamId = 10276
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 38594 AND teamId = 10276
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 19456 AND teamId = 10276
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 15028 AND teamId = 10276
0.0231	SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 10276
0.0133	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2016` 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 = 20080 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0197	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 events2016 e ON e.player_id = p.id AND e.league_id = 20080 WHERE rp.league_id = 20080 AND rp.teamId = 10276 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.0193	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 events2016 e ON e.player_id = p.id AND e.league_id = 20080 WHERE rp.league_id = 20080 AND rp.teamId = 10276 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0181	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 events2016 e ON e.player_id = p.id AND e.league_id = 20080 WHERE rp.league_id = 20080 AND rp.teamId = 10276 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168	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 = 10276 AND rp.league_id = 20080 AND l.year= 2016 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0173	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=580181 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0132	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=580181
0.0147	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=580181 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.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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=580181 and (e.action = 4 or e.action = 5) 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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=580181 and (e.action = 3 or e.action = 4) 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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=580181 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0135	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=580181 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0129	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 = 20080 ORDER BY nameShow LIMIT 100

América

Información sobre América

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del América

Estadísticas

Plantilla del América Temporada 2015/2016

Noticias del América

América

Selecciona un equipo

Competiciones que juega

RIVALES EN CONCACAF Champio.

RIVALES EN Mundial de Clube.

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

RIVALES EN Etapas Finales A.

RIVALES EN Etapas Finales C.