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

« Temporada Anterior

Temporada 2010

Temporada Siguiente »

2009/2010

Clausura Argentina 2010

Apertura Argentina

Clausura Argentina

Primera División Argentina

Clausura Argentina 2010

La temporada finalizó el Domingo, 16 Mayo 2010.

26 Feb 10 23:00 Finalizado	Arsenal de Sarandí	Arsenal de Sarandí - Chacarita Juniors 2010-02-26T23:00:00 Julio Humberto Grondona (Nuevo Viaducto) 0-3	Chacarita Juniors	más información Jugadas destacadas ...
		0-1	31' D. Morales
		0-2	50' D. Morales
		0-3	82' Facundo Parra
27 Feb 10 01:10 Finalizado	Boca Juniors	Boca Juniors - Estudiantes La Plata 2010-02-27T01:10:00 Alberto José Armando 1-1	Estudiantes La Plata	más información Jugadas destacadas ...
	25' M. Palermo	1-0
		1-1	90' L. González
27 Feb 10 21:00 Finalizado	CA Huracán	CA Huracán - Vélez Sarsfield 2010-02-27T21:00:00 Tomás Adolfo Ducó 3-2	Vélez Sarsfield	más información Jugadas destacadas ...
		0-1	42' R. Zárate
	49' G. Balvorín	1-1
			60' L. Velázquez
	79' P. Toranzo	2-1
	80' F. Laurito	3-1
		3-2	87' S. Silva
			90' M. Moralez
27 Feb 10 21:00 Finalizado	Independiente	Independiente - Racing Club 2010-02-27T21:00:00 Libertadores de América 1-0	Racing Club	más información Jugadas destacadas ...
	41' D. Gandín	1-0
			59' G. Hauche
	90' P. Rodríguez
27 Feb 10 23:10 Finalizado	Colón	Colón - Rosario Central 2010-02-27T23:10:00 Brigadier General Estanislao López 1-1	Rosario Central	más información Jugadas destacadas ...
	36' G. Rivarola	1-0
		1-1	58' L. Figueroa
			65' Jonathan Gómez
			87' G. Burdisso
	87' M. Goux
28 Feb 10 21:00 Finalizado	Lanús	Lanús - Atl. Tucumán 2010-02-28T21:00:00 Ciudad de Lanús - Néstor Díaz Pérez 3-0	Atl. Tucumán	más información Jugadas destacadas ...
	39' S. Blanco	1-0
	52' D. Lagos	2-0
	67' S. Salcedo	3-0
28 Feb 10 21:00 Finalizado	San Lorenzo	San Lorenzo - Tigre 2010-02-28T21:00:00 Pedro Bidegain 1-0	Tigre	más información Jugadas destacadas ...
	83' E. Alfaro	1-0
	88' N. Benítez
			88' B. Rodriguez
28 Feb 10 23:10 Finalizado	Newell's Old Boys	Newell's Old Boys - Banfield 2010-02-28T23:10:00 Marcelo Alberto Bielsa (Coloso del Parque) 2-1	Banfield	más información Jugadas destacadas ...
	65' C. Nuñez	1-0
	75' J. Boghossian	2-0
		2-1	77' R. Ramírez
28 Feb 10 23:10 Finalizado	Argentinos Juniors	Argentinos Juniors - Godoy Cruz 2010-02-28T23:10:00 Estadio Diego Armando Maradona 1-2	Godoy Cruz	más información Jugadas destacadas ...
		0-1	6' F. Higuaín
		0-2	20' C. Sánchez
	32' S. Gentiletti	1-2
01 Mar 10 01:15 Finalizado	Gimnasia La Plata	Gimnasia La Plata - River Plate 2010-03-01T01:15:00 Juan Carmelo Zerillo 1-1	River Plate	más información Jugadas destacadas ...
	8' M. Pérez	1-0
		1-1	90' G. Canales

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Colón	12	6	3	3	0	9	6	VICTORIA Colón 2 Racing Club 1 EMPATE Tigre 2 Colón 2 VICTORIA Colón 1 River Plate 0 VICTORIA Chacarita Juniors 1 Colón 2 EMPATE Colón 1 Rosario Central 1
2	Godoy Cruz	12	6	3	3	0	5	2	VICTORIA San Lorenzo 0 Godoy Cruz 1 EMPATE Godoy Cruz 0 Independiente 0 EMPATE CA Huracán 0 Godoy Cruz 0 EMPATE Godoy Cruz 1 Boca Juniors 1 VICTORIA Argentinos Juniors 1 Godoy Cruz 2
3	Vélez Sarsfield	11	6	3	2	1	11	5	VICTORIA Arsenal de Sarandí 0 Vélez Sarsfield 3 VICTORIA Vélez Sarsfield 2 Gimnasia La Plata 1 EMPATE San Lorenzo 0 Vélez Sarsfield 0 VICTORIA Vélez Sarsfield 3 Independiente 0 DERROTA CA Huracán 3 Vélez Sarsfield 2
4	Independiente	11	6	3	2	1	7	6	VICTORIA Independiente 3 Atl. Tucumán 1 EMPATE Godoy Cruz 0 Independiente 0 VICTORIA Independiente 3 Estudiantes La Pla. 2 DERROTA Vélez Sarsfield 3 Independiente 0 VICTORIA Independiente 1 Racing Club 0
5	Chacarita	10	6	3	1	2	11	7	DERROTA Chacarita Juniors 2 River Plate 3 VICTORIA Chacarita Juniors 2 Banfield 1 EMPATE Rosario Central 1 Chacarita Juniors 1 DERROTA Chacarita Juniors 1 Colón 2 VICTORIA Arsenal de Sarandí 0 Chacarita Juniors 3
6	Estudiantes	10	6	3	1	2	11	7	DERROTA Gimnasia La Plata 3 Estudiantes La Pla. 1 VICTORIA Estudiantes La Pla. 2 San Lorenzo 0 DERROTA Independiente 3 Estudiantes La Pla. 2 VICTORIA Estudiantes La Pla. 2 CA Huracán 0 EMPATE Boca Juniors 1 Estudiantes La Pla. 1
7	Banfield	10	6	3	1	2	8	4	VICTORIA Banfield 3 Argentinos Juniors 0 DERROTA Chacarita Juniors 2 Banfield 1 VICTORIA Banfield 2 Lanús 0 EMPATE Banfield 0 Rosario Central 0 DERROTA Newell's Old Boys 2 Banfield 1
8	Newell's Boys	9	6	2	3	1	9	7	DERROTA CA Huracán 2 Newell's Old Boys 1 VICTORIA Newell's Old Boys 4 Boca Juniors 2 EMPATE Argentinos Juniors 1 Newell's Old Boys 1 EMPATE Newell's Old Boys 1 Lanús 1 VICTORIA Newell's Old Boys 2 Banfield 1
9	Gimnasia Plata	8	6	2	2	2	7	6	VICTORIA Gimnasia La Plata 3 Estudiantes La Pla. 1 DERROTA Vélez Sarsfield 2 Gimnasia La Plata 1 VICTORIA Gimnasia La Plata 1 Racing Club 0 EMPATE Tigre 1 Gimnasia La Plata 1 EMPATE Gimnasia La Plata 1 River Plate 1
10	Tigre	8	6	2	2	2	6	6	VICTORIA Rosario Central 0 Tigre 1 EMPATE Tigre 2 Colón 2 VICTORIA Arsenal de Sarandí 0 Tigre 2 EMPATE Tigre 1 Gimnasia La Plata 1 DERROTA San Lorenzo 1 Tigre 0
11	CA Huracán	8	6	2	2	2	7	8	VICTORIA CA Huracán 2 Newell's Old Boys 1 EMPATE Atl. Tucumán 0 CA Huracán 0 EMPATE CA Huracán 0 Godoy Cruz 0 DERROTA Estudiantes La Pla. 2 CA Huracán 0 VICTORIA CA Huracán 3 Vélez Sarsfield 2
12	Boca Juniors	7	6	1	4	1	9	9	VICTORIA Boca Juniors 3 Lanús 1 DERROTA Newell's Old Boys 4 Boca Juniors 2 EMPATE Boca Juniors 0 Atl. Tucumán 0 EMPATE Godoy Cruz 1 Boca Juniors 1 EMPATE Boca Juniors 1 Estudiantes La Pla. 1
13	San Lorenzo	7	6	2	1	3	2	4	DERROTA San Lorenzo 0 Godoy Cruz 1 DERROTA Estudiantes La Pla. 2 San Lorenzo 0 EMPATE San Lorenzo 0 Vélez Sarsfield 0 DERROTA Racing Club 1 San Lorenzo 0 VICTORIA San Lorenzo 1 Tigre 0
14	Lanús	7	6	2	1	3	11	14	DERROTA Boca Juniors 3 Lanús 1 DERROTA Lanús 3 Argentinos Juniors 6 DERROTA Banfield 2 Lanús 0 EMPATE Newell's Old Boys 1 Lanús 1 VICTORIA Lanús 3 Atl. Tucumán 0
15	Argentinos	6	6	1	3	2	11	12	DERROTA Banfield 3 Argentinos Juniors 0 VICTORIA Lanús 3 Argentinos Juniors 6 EMPATE Argentinos Juniors 1 Newell's Old Boys 1 EMPATE Atl. Tucumán 1 Argentinos Juniors 1 DERROTA Argentinos Juniors 1 Godoy Cruz 2
16	Racing Club	6	6	2	0	4	7	8	DERROTA Colón 2 Racing Club 1 DERROTA Racing Club 2 Arsenal de Sarandí 4 DERROTA Gimnasia La Plata 1 Racing Club 0 VICTORIA Racing Club 1 San Lorenzo 0 DERROTA Independiente 1 Racing Club 0
17	River Plate	6	6	1	3	2	5	6	VICTORIA Chacarita Juniors 2 River Plate 3 EMPATE River Plate 0 Rosario Central 0 DERROTA Colón 1 River Plate 0 EMPATE River Plate 1 Arsenal de Sarandí 1 EMPATE Gimnasia La Plata 1 River Plate 1
18	Rosario Central	4	6	0	4	2	2	6	DERROTA Rosario Central 0 Tigre 1 EMPATE River Plate 0 Rosario Central 0 EMPATE Rosario Central 1 Chacarita Juniors 1 EMPATE Banfield 0 Rosario Central 0 EMPATE Colón 1 Rosario Central 1
19	Arsenal Sarandí	4	6	1	1	4	5	14	DERROTA Arsenal de Sarandí 0 Vélez Sarsfield 3 VICTORIA Racing Club 2 Arsenal de Sarandí 4 DERROTA Arsenal de Sarandí 0 Tigre 2 EMPATE River Plate 1 Arsenal de Sarandí 1 DERROTA Arsenal de Sarandí 0 Chacarita Juniors 3
20	Atl. Tucumán	3	6	0	3	3	2	8	DERROTA Independiente 3 Atl. Tucumán 1 EMPATE Atl. Tucumán 0 CA Huracán 0 EMPATE Boca Juniors 0 Atl. Tucumán 0 EMPATE Atl. Tucumán 1 Argentinos Juniors 1 DERROTA Lanús 3 Atl. Tucumán 0

JUGADORES DESTACADOS

RK	Nombre	Goles	Posición	Equipo
1	M. Boselli	13	DEL	Estudiantes La Plata
2	M. Palermo	10	DEL	Boca Juniors
3	R. Ramírez	10	DEL	Banfield
4	V. Sosa	9	DEL	Argentinos Juniors
5	C. Luna	9	DEL	Tigre
6	M. Pérez	8	DEL	Gimnasia La Plata
7	Facundo Parra	8	DEL	Chacarita Juniors
8	L. Núñez	7	DEL	Independiente
9	F. Higuaín	7	MED	Godoy Cruz
10	N. Silvera	7	DEL	Independiente
11	S. Salcedo	6	DEL	Lanús
12	J. Boghossian	6	DEL	Newell's Old Boys
13	G. Castillejos	6	DEL	Lanús
14	M. Óbolo	6	DEL	Arsenal de Sarandí
15	E. Fuertes	6	DEL	Colón
16	R. Lopez	6	DEL	Vélez Sarsfield
17	C. Bieler	6	DEL	Racing Club
18	N. Pavlovich	6	DEL	Argentinos Juniors
19	J. Achucarro	5	DEL	Newell's Old Boys
20	L. Leguizamón	5	DEL	Arsenal de Sarandí

Busca la liga de tu equipo

Introduce el nombre de tu equipo y busca rápidamente su competición

NOTICIAS RELACIONADAS

Ver más noticias de la competicion»

Equipos de esta competición

INFORMACIÓN

La Asociación del Fútbol Argentino (AFA) se creó en 1893. Es la octava más antigua del mundo. El torneo de liga, jugado desde ese año, es el tercero más antiguo del mundo, detrás de las ligas británicas y holandesa. Argentina es uno de los ocho países que obtuvieron la Copa Mundial de Fútbol, habiéndola ganado en Argentina 78 y México 86, además de haber alcanzado el subcampeonato en Uruguay 1930 e Italia 90. Obtuvo también dos medallas de oro olímpicas, Atenas 2004 y Beijing 2008, y dos de plata (Ámsterdam 1928 y Atlanta 1996). Obtuvo catorce veces la Copa América, en la que salió muchas veces subcampeón; ganó una vez la Copa Confederaciones, de la cual obtuvo dos veces el subcampeonato; ganó el Sudamericano Sub-20 en cuatro oportunidades y fue seis veces subcampeón; y consiguió seis veces la Copa Mundial de Fútbol Sub-20, en la que salió subcampeón en una ocasión.

USO DE MEMORIA

6,379,056 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.6365
Total Execution Time	0.6385

CADENA URL

/torneo_final2010/grupo1/jornada6

GET DATOS

$_GET['/torneo_final2010/grupo1/jornada6']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0144	SELECT type FROM routes WHERE alias = 'torneo_final2010'
0.0290	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_final' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 8384 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=26 ORDER BY l.group_code ASC
0.0144	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 13:56:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 13:56:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 13:56:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 13:56:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_final' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0153	SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (8384) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0151	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8384) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (54654,71732,75109,54362,54968,67427,72577,17022,71868,72578,16966,54608,54846,71691,71874,71890,72024,360519,54607,71692) ORDER BY rp.in_squad = 1 DESC
0.0156	SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (8384) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0185	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8384) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258648,53336,71697,72036,893,71728,72118,72546,257923,17105,54491,54536,71736,71763,71775,71868,71875,71888,71895,71958) ORDER BY rp.in_squad = 1 DESC
0.0146	SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (8384) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0150	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8384) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (54342,54521,71697,71731,71892,71999,75804,258648,213,893,1961,7183,11619,16568,16648,16719,16724,16806,16851,16899) ORDER BY rp.in_squad = 1 DESC
0.0145	SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (8384) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0148	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8384) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0148	SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8384 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0146	SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8384 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0145	SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=8384 AND rel.round=6
0.0146	SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 8384 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0145	SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 8384 AND esl.points > 0
0.0151	SELECT fau.user_name, c., NOW() as difference_time,creation_date FROM* (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-09" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 8384 ORDER BY creation_date DESC LIMIT 0, 10
0.0193	SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-09" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 8384
0.0178	SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2010` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 8384 AND c.`round` = 6 ORDER BY shedule ASC LIMIT 200
0.0154	SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2010 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2010 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 8384 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (104157,104158,104159,104160,104161,104162,104163,104164,104165,104166) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0160	SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2010` e INNER JOIN calendars2010 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 6 AND e.real_date IS NOT NULL AND e.league_id = 8384 ORDER BY total DESC LIMIT 40
0.0149	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 8384 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 8384 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	SELECT distinct(shedule), round FROM `calendars2010` as c WHERE c.`league_id` = 8384 AND shedule >= '2010/02/01' AND shedule < '2010/03/01' ORDER BY shedule ASC
0.0146	SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-09 00:00:00' AND c.`shedule` < '2024-05-13 23:59:59' AND l.id = 8384 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0146	SELECT data1, data2 FROM services_tags WHERE categoryId=118
0.0146	SELECT group_code, extraName from `leagues` WHERE categoryId=118 AND year=2010

Partido televisado en... x

Clausura Argentina 2010

Clausura Argentina 2010

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:

RK	Nombre	Amarillas	Posición	Equipo
1	M. Almeyda	9	MED	River Plate
2	P. Pintos	8	DEF	San Lorenzo
3	Gastón Esmerado	8	MED	CA Huracán
4	C. Pérez	8	DEF	Tigre
5	Ruben Maldonado	7	DEF	Gimnasia La Plata
6	J. Méndez	7	MED	Boca Juniors
7	J. Curbelo	7	DEF	Godoy Cruz
8	G. Núñez	7	MED	Rosario Central
9	Kily González	7	MED	San Lorenzo
10	P. Goltz	6	DEF	CA Huracán
11	N. Valentini	6	DEF	Rosario Central
12	F. Vismara	6	MED	Chacarita Juniors
13	C. Erbes	6	MED	Boca Juniors
14	M. Estigarribia	6	MED	Newell's Old Boys
15	L. Vangioni	6	DEF	Newell's Old Boys
16	F. Higuaín	6	MED	Godoy Cruz
17	G. Rivarola	6	DEF	Colón
18	Enzo Pérez	6	MED	Estudiantes La Plata
19	G. Mercado	6	DEF	Racing Club
20	A. Frezzotti	6	DEF	Chacarita Juniors

RK	Nombre	Rojas	Posición	Equipo
1	J. Sabia	2	DEF	Argentinos Juniors
2	Lisandro López	2	DEF	Chacarita Juniors
3	Gastón Esmerado	2	MED	CA Huracán
4	P. Mouche	2	DEL	Boca Juniors
5	Juan Sebastián Verón	2	MED	Estudiantes La Plata
6	J. Bottinelli	2	DEF	San Lorenzo
7	M. Goux	2	DEF	Colón
8	M. Almeyda	2	MED	River Plate
9	G. Paletta	1	DEF	Boca Juniors
10	Ruben Maldonado	1	DEF	Gimnasia La Plata
11	F. Quiroga	1	DEF	River Plate
12	R. Arruabarrena	1	DEF	Tigre
13	S. Romero	1	MED	Gimnasia La Plata
14	C. Campestrini	1	POR	Arsenal de Sarandí
15	J. Yacuzzi	1	MED	Arsenal de Sarandí
16	D. Braghieri	1	DEF	Rosario Central
17	M. Paglialunga	1	MED	Rosario Central
18	D. Gandín	1	DEL	Independiente
19	G. Aguirre	1	DEF	San Lorenzo
20	G. García	1	DEF	CA Huracán

Partido televisado en... x

Clausura Argentina 2010

Clausura Argentina 2010

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

Boca, con los juveniles ante Banfield como hizo frente a Rosario en 2003

"Ruggeri todavía dice que me quiso fracturar, ya veremos cuando lo vea en la calle"

VÍDEO: jugadón de Defederico y definición de Pastore

23 años de la mayor locura de Chilavert

Histórico Gallardo: ¡Vivió el último 8-0 de River como jugador!

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN