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

CA Huracán

Entrenador: Frank Kudelka

Temporada 2022/2023

Información sobre CA Huracán

Enviar Datos

Información

Nombre del equipo CA Huracán
Nombre completo Club Atlético Huracán
Nombre corto HUR
País Argentina
Ciudad Capital Federal, Ciudad de Buenos Aires
Entrenador Frank Kudelka
URL del equipo en RF testing.resultados-futbol.com/Ca-Huracan

Otros Datos

Año de Fundación 1908
Socios 18000

Internet

Sitio Web www.cahuracan.com
Correo electrónico prensa@clubahuracan.com.ar
Twitter principal @CAHuracan

Información sobre el estadio

Nombre del estadio Tomás Adolfo Ducó
Capacidad 48314
Dirección Avenida Amancio Alcorta 2570, Parque Patricios, Ciudad de Buenos Aires
Teléfono +54 (11) 4942 1965
Fax +54 (11) 4911 0757
Año de construcción 1949
Tamaño 105 x 70

Histórico de participación

Liga Profesional Argentina

106 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 1986, 1985, 1985, 1985, 1985, 1984, 1984, 1984, 1983, 1983, 1983, 1982, 1982, 1981, 1981, 1980, 1980, 1979, 1979, 1978, 1978, 1978, 1977, 1977, 1976, 1976, 1976, 1975, 1975, 1975, 1974, 1974, 1974, 1973, 1973, 1972, 1972, 1971, 1971, 1970, 1970, 1970, 1969, 1969, 1968, 1968, 1967, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1939, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1922, 1921, 1919, 1918, 1917, 1916, 1915)

Clausura Argentina

17 veces

(2011, 2011, 2010, 2009, 2008, 2003, 2002, 2001, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991)

Apertura Argentina

16 veces

(2011, 2010, 2009, 2008, 2003, 2002, 2001, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991)

Copa Argentina

12 veces

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

Copa Libertadores Grupo 2

7 veces

(2019, 2016, 2016, 2015, 1974, 1974, 1974)

Primera Nacional

7 veces

(2014, 2013, 2012, 2007, 2006, 2005, 2004)

Copa Liga Profesional Argentina

5 veces

(2024, 2023, 2023, 2022, 2021)

Copa Diego Armando Maradona Grupo 3

4 veces

(2021, 2021, 2020, 2019)

Fase Previa Copa Libertadores Grupo 2

4 veces

(2023, 2023, 2016, 2015)

Primera B Nacional - Transición Grupo 2

1 vez

(2015)

Partidos del CA Huracán

Ir al LIVESCORE

Copa Liga Profesional Argentina »

02 Dic 23	Finalizado	CA Huracán	1 - 1	Platense	95
26 Nov 23	Finalizado	Atl. Tucumán	0 - 2	CA Huracán	36
12 Nov 23	Finalizado	CA Huracán	1 - 0	Arsenal de Sarandí	59
04 Nov 23	Finalizado	River Plate	1 - 2	CA Huracán	742
31 Oct 23	Finalizado	CA Huracán	0 - 0	Barracas Central	470
25 Oct 23	Finalizado	Argentinos Juniors	1 - 2	CA Huracán	292
21 Oct 23	Finalizado	CA Huracán	1 - 3	Instituto	208
07 Oct 23	Finalizado	Rosario Central	1 - 0	CA Huracán	236
30 Sep 23	Finalizado	San Lorenzo	1 - 1	CA Huracán	113
24 Sep 23	Finalizado	CA Huracán	3 - 0	Vélez Sarsfield	128
20 Sep 23	Finalizado	CA Huracán	2 - 0	Gimnasia La Plata	509
15 Sep 23	Finalizado	Independiente	1 - 0	CA Huracán	384
03 Sep 23	Finalizado	CA Huracán	2 - 1	Colón	126
27 Ago 23	Finalizado	Talleres Córdoba	2 - 1	CA Huracán	108
21 Ago 23	Finalizado	CA Huracán	2 - 0	Banfield	259

Fase Previa Copa Libertadores »

17 Mar 23	Finalizado	Sporting Cristal	1 - 0	CA Huracán	790
10 Mar 23	Finalizado	CA Huracán	0 - 0	Sporting Cristal	497
01 Mar 23	Finalizado	CA Huracán	1 - 0	Boston River	233
23 Feb 23	Finalizado	Boston River	0 - 0	CA Huracán	281

Conmebol Sudamericana »

29 Jun 23	Finalizado	Guaraní	2 - 0	CA Huracán	323
09 Jun 23	Finalizado	Danubio	1 - 0	CA Huracán	217
26 May 23	Finalizado	CA Huracán	2 - 2	CS Emelec	230
03 May 23	Finalizado	CA Huracán	1 - 1	Danubio	429
21 Abr 23	Finalizado	CS Emelec	1 - 0	CA Huracán	284
07 Abr 23	Finalizado	CA Huracán	4 - 1	Guaraní	144

Liga Profesional Argentina »

30 Jul 23	Finalizado	CA Huracán	1 - 0	Vélez Sarsfield	143
23 Jul 23	Finalizado	Platense	0 - 1	CA Huracán	248
15 Jul 23	Finalizado	CA Huracán	0 - 1	Talleres Córdoba	428
11 Jul 23	Finalizado	Boca Juniors	1 - 0	CA Huracán	534
07 Jul 23	Finalizado	CA Huracán	0 - 1	Atl. Tucumán	210
02 Jul 23	Finalizado	Independiente	1 - 0	CA Huracán	159
24 Jun 23	Finalizado	CA Huracán	1 - 1	Newell's Old Boys	451
14 Jun 23	Finalizado	Gimnasia La Plata	1 - 0	CA Huracán	244
04 Jun 23	Finalizado	Central Córdoba	2 - 0	CA Huracán	29
30 May 23	Finalizado	CA Huracán	0 - 1	Unión Santa Fe	158
21 May 23	Finalizado	Sarmiento	0 - 0	CA Huracán	64
13 May 23	Finalizado	CA Huracán	0 - 0	Godoy Cruz	211
06 May 23	Finalizado	Lanús	1 - 0	CA Huracán	69
29 Abr 23	Finalizado	CA Huracán	2 - 1	Arsenal de Sarandí	66
26 Abr 23	Finalizado	Tigre	1 - 0	CA Huracán	247
16 Abr 23	Finalizado	CA Huracán	0 - 0	Argentinos Juniors	77
13 Abr 23	Finalizado	Belgrano	2 - 0	CA Huracán	141
10 Abr 23	Finalizado	CA Huracán	0 - 3	River Plate	198
02 Abr 23	Finalizado	Racing Club	2 - 1	CA Huracán	196
21 Mar 23	Finalizado	CA Huracán	0 - 2	Rosario Central	538
12 Mar 23	Finalizado	Estudiantes La Plata	2 - 1	CA Huracán	167
05 Mar 23	Finalizado	CA Huracán	1 - 1	San Lorenzo	158
26 Feb 23	Finalizado	Colón	1 - 1	CA Huracán	141
18 Feb 23	Finalizado	CA Huracán	2 - 0	Barracas Central	180
13 Feb 23	Finalizado	Instituto	0 - 0	CA Huracán	362
07 Feb 23	Finalizado	CA Huracán	3 - 2	Banfield	112
28 Ene 23	Finalizado	Defensa y Justicia	2 - 4	CA Huracán	271

Copa Argentina »

13 Oct 23	Finalizado	CA Huracán	0 - 2	Estudiantes La Plata	121
10 Sep 23	Finalizado	Racing Club	3 - 5	CA Huracán	385
09 Ago 23	Finalizado	Instituto	0 - 2	CA Huracán	70
02 Feb 23	Finalizado	CA Huracán	4 - 1	Yupanqui	71

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del CA Huracán Temporada 2022/2023

		Edad	Altura	Peso
Portero
1	Lucas Chaves	28	182	72	-	-	2
32	S. Meza	24	180	82	-	-	-
Defensa
14	A. Benítez	30	170	69	-	-	2
25	C. Ibáñez	24	170	72	-	-	-
6	F. Pereyra	34	185	83	1	-	3
4	F. Torrent	32	173	70	-	-	-
3	L. Carrizo	26	180	70	-	1	3
33	L. Souto	25	180	75	-	-	2
46	Mauro Villar	23	192	86	-	-	-
2	O. Tobio	34	186	85	1	1	3
35	Patricio Pizarro	23	183	77	-	-	2
Centrocampista
15	A. Spina	22	175	71	-	-	-
28	Alan Soñora	25	171	65	1	-	-
10	Andrés Roa	30	175	67	-	-	-
24	F. Fattori	31	178	76	-	1	2
11	F. Godoy	33	172	70	-	-	-
22	Joel Soñora	27	173	64	-	-	-
37	Leandro Figueredo	20	193	72	-	-	-
23	Matías Gómez	20	170	64	-	-	-
20	R. Echeverría	29	181	73	1	-	2
5	W. Alarcón	23	182	69	-	-	1
Delantero
26	Enzo Luna	21	180	76	-	-	-
16	Franco Alfonso	21	165	60	2	-	2
8	Héctor Fertoli	29	175	66	-	-	1
7	I. Pussetto	28	180	70	3	1	2
13	M. Cóccaro	26	178	73	6	-	5
19	Marcelo Pérez	23	183	75	-	-	-
45	Matías Pólvera	23	-	-	-	-	-
21	W. Mazzantti	27	173	68	3	-	2

Noticias del CA Huracán

Ver últimas noticias

El emotivo apoyo de la hija de Alfaro

BeSoccer - Domingo, 23 Diciembre 2018

0 264

Josefina, hija del próximo entrenador de Boca Juniors, publicó unas palabras en sus redes sociales dirigidas a su padre, que se desvinculó de Huracán a la espera de oficializarse su llegada al cuadro 'xeneize'.

Huracán azotó a Tigre y se aproxima a los octavos de final

BeSoccer - Jueves, 27 Agosto 2015

0 81

Huracán sorprendió hoy a Tigre con una goleada a domicilio por 2-5 en el primer partido de la serie que libran en la segunda fase de la Copa Sudamericana.

Tigre y Huracán lucharán por los octavos de final de la Sudamericana

BeSoccer - Miércoles, 26 Agosto 2015

0 263

El Tigre recibirá este miércoles al Huracán a las 20:15 hora local (23:15 GMT) por el partido de ida de uno de los choques entre equipos argentinos de la segunda fase de la Copa Sudamericana.

El Villarreal espera firmar a Espinoza para cederlo al Málaga

BeSoccer - Jueves, 09 Julio 2015

0 313

Espinoza está levantando el interés de muchos clubes. Entre ellos, el Villarreal y el Málaga. El club amarillo está a punto de fichar al extremo argentino, mientras que el Málaga estaría muy interesado en contar con el futbolista a corto plazo.

Los tres jugadores que el Málaga quiere como cedidos

BeSoccer - Lunes, 29 Junio 2015

1 857

Marco Asensio, Cristian Espinoza y Nahil Ghilas están en el punto de mira del Málaga para conseguir que lleguen a La Rosaleda cedidos.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Copa Liga Profesional Argentina

Pos	Equipos		Pts
1		CA Huracán	26
2		River Plate	24
3		Racing Club	24
4		Banfield	23
5		Rosario Central	23
6		Independiente	23
7		Godoy Cruz	22
8		Vélez Sarsfield	22
9		Belgrano	21
10		Instituto	20
11		Colón	20
12		Platense	20
13		Central Córdoba	19
14		Newell's Old Boys	18
15		Boca Juniors	18
16		San Lorenzo	18
17		Talleres Córdoba	17
18		Estudiantes La Plata	17
19		Atl. Tucumán	17
20		Sarmiento	16
21		Unión Santa Fe	16
22		Gimnasia La Plata	15
23		Argentinos Juniors	14
24		Defensa y Justicia	14
25		Barracas Central	14
26		Arsenal de Sarandí	13
27		Tigre	13
28		Lanús	12

	Siguiente Ronda : CA Huracán, River Plate, Racing Club, Banfield

RIVALES EN Copa Liga Profes.

RIVALES EN Conmebol Sudamer.

RIVALES EN Fase Previa Copa.

RIVALES EN Copa Argentina

RIVALES EN Liga Profesional.

USO DE MEMORIA

6,848,088 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.8124
Total Execution Time	0.8145

CADENA URL

/Ca-Huracan/2023

GET DATOS

$_GET['/Ca-Huracan/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

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 = 'Ca-Huracan' AND l.year = 2023 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.0145	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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152	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 = 74708
0.0152	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 = 71367
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 = 71148
0.0151	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 = 70412
0.0163	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 = '585' AND l.year = 2023 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 = '585' 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 = 70413 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145	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 = 71367 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 71148 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	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 = 70412 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	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 = 70411 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	(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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 585 or c.datateam2 = 585) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0157	(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 calendars2023 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 = 585 or c.datateam2 = 585) AND l.year = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0154	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 = 585 or c.datateam2 = 585) AND l.year = 2023)
0.0164	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=585 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (75100,75056,74909,74880,71432,71367,71148) 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.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 74880 AND teamId = 585
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 75056 AND teamId = 585
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71148 AND teamId = 585
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71367 AND teamId = 585
0.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 74909 AND teamId = 585
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 585
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 75100 AND teamId = 585
0.0162	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 events2023 e ON e.player_id = p.id AND e.league_id = 70413 WHERE rp.league_id = 70413 AND rp.teamId = 585 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.0163	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 events2023 e ON e.player_id = p.id AND e.league_id = 70413 WHERE rp.league_id = 70413 AND rp.teamId = 585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159	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 events2023 e ON e.player_id = p.id AND e.league_id = 70413 WHERE rp.league_id = 70413 AND rp.teamId = 585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160	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 = 585 AND rp.league_id = 70413 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0160	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=6559181 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0147	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6559181
0.0154	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6559181 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.0153	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6559181 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0151	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6559181 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0148	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6559181 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0150	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6559181 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

CA Huracán

Información sobre CA Huracán

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del CA Huracán

Estadísticas

Plantilla del CA Huracán Temporada 2022/2023

Noticias del CA Huracán

CA Huracán

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Liga Profes.

RIVALES EN Conmebol Sudamer.

RIVALES EN Fase Previa Copa.

RIVALES EN Copa Argentina

RIVALES EN Liga Profesional.