14 Jun 08	Finalizado	San Martín Tucumán	1 - 1	Atletico Rafaela
10 Jun 08	Finalizado	Godoy Cruz	2 - 0	San Martín Tucumán
03 Jun 08	Finalizado	San Martín Tucumán	2 - 0	Belgrano
27 May 08	Finalizado	Chacarita Juniors	2 - 2	San Martín Tucumán
20 May 08	Finalizado	San Martín Tucumán	1 - 1	Almirante Brown
10 May 08	Finalizado	Defensa y Justicia	3 - 1	San Martín Tucumán
06 May 08	Finalizado	San Martín Tucumán	1 - 1	Nueva Chicago
29 Abr 08	Finalizado	Instituto	0 - 1	San Martín Tucumán
19 Abr 08	Finalizado	Quilmes	0 - 0	San Martín Tucumán
15 Abr 08	Finalizado	San Martín Tucumán	2 - 0	Ben Hur
05 Abr 08	Finalizado	Indep. Rivadavia	1 - 0	San Martín Tucumán
28 Mar 08	Finalizado	San Martín Tucumán	3 - 0	Talleres Córdoba
22 Mar 08	Finalizado	Aldosivi	1 - 1	San Martín Tucumán
18 Mar 08	Finalizado	San Martín Tucumán	2 - 0	Almagro
07 Mar 08	Finalizado	Platense	0 - 3	San Martín Tucumán
02 Mar 08	Finalizado	San Martín Tucumán	0 - 0	Tiro Federal Rosario
26 Feb 08	Finalizado	Ferro Carril Oeste	0 - 1	San Martín Tucumán
17 Feb 08	Finalizado	San Martín Tucumán	4 - 0	CAI
08 Feb 08	Finalizado	Unión Santa Fe	2 - 0	San Martín Tucumán
10 Dic 07	Finalizado	Atletico Rafaela	1 - 0	San Martín Tucumán
04 Dic 07	Finalizado	San Martín Tucumán	2 - 1	Godoy Cruz
28 Nov 07	Finalizado	Belgrano	2 - 3	San Martín Tucumán
23 Nov 07	Finalizado	San Martín Tucumán	1 - 1	Chacarita Juniors
18 Nov 07	Finalizado	Almirante Brown	2 - 0	San Martín Tucumán
09 Nov 07	Finalizado	San Martín Tucumán	1 - 0	Defensa y Justicia
02 Nov 07	Finalizado	Nueva Chicago	1 - 0	San Martín Tucumán
27 Oct 07	Finalizado	San Martín Tucumán	2 - 0	Instituto
19 Oct 07	Finalizado	San Martín Tucumán	1 - 0	Quilmes
13 Oct 07	Finalizado	Ben Hur	0 - 1	San Martín Tucumán
07 Oct 07	Finalizado	San Martín Tucumán	1 - 0	Indep. Rivadavia
30 Sep 07	Finalizado	Talleres Córdoba	1 - 1	San Martín Tucumán
23 Sep 07	Finalizado	San Martín Tucumán	1 - 0	Aldosivi
15 Sep 07	Finalizado	Almagro	1 - 4	San Martín Tucumán
11 Sep 07	Finalizado	San Martín Tucumán	2 - 2	Platense
01 Sep 07	Finalizado	Tiro Federal Rosario	1 - 0	San Martín Tucumán
25 Ago 07	Finalizado	San Martín Tucumán	1 - 1	Ferro Carril Oeste
19 Ago 07	Finalizado	CAI	0 - 0	San Martín Tucumán
12 Ago 07	Finalizado	San Martín Tucumán	1 - 0	Unión Santa Fe

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del San Martín Tucumán Temporada 2007/2008

		Edad	Altura	Peso
Portero
12	E. Salvatore	42	-	-	-	-	-
	G. Caffa	43	187	84	-	-	2
28	Hugo Orellana	37	184	82	-	-	-
	Javier Lavallén	50	184	80	-	-	-
Defensa
27	C. Iarossi	42	-	-	-	-	-
	Fernando Cravero	43	173	67	1	-	1
	Germán Noce	47	173	73	-	-	7
	H. De Camilo	35	-	-	-	-	-
13	J. Serrano	40	191	89	-	1	10
	M. Vera	42	-	-	-	-	3
Centrocampista
	Antonio Ibáñez	38	168	-	-	-	-
	D. Romano	44	165	60	4	1	7
	David Robles	40	-	-	-	-	-
	E. Perea	39	182	80	-	-	5
	Esteban Gil	47	168	70	-	-	4
15	Juan Monge	52	181	-	1	-	2
	L. Oviedo	39	175	76	-	-	2
	L. Vega	37	-	-	-	-	-
	Luciano Krikorian	48	184	77	5	-	10
29	M. Nievas	40	180	76	-	-	1
	Manuel Acosta	45	-	-	-	-	-
	P. Cantero	46	-	-	1	-	5
	P. López	41	166	70	1	-	1
11	R. Leone	46	172	74	3	-	5
	Ricardo Aparicio	47	169	69	-	-	3
	W. Brandán	39	178	77	-	-	4
Delantero
7	G. Ibañez	44	164	69	11	-	1
	J. Morales	42	180	77	6	-	2
	Juan Acosta	39	182	75	2	-	-
	L. Ojeda	38	180	80	-	-	1
	M. Campodónico	49	185	84	11	1	5
22	M. Fernández	36	186	79	-	-	-

Noticias del San Martín Tucumán

Ver últimas noticias

San Martín de Tucumán se hace con los servicios de Gracián

BeSoccer - Lunes, 09 Enero 2017

0 587

El volante ofensivo Leandro Gracián se convierte en un refuerzo para San Martín de Tucumán.

Galeano ficha por San Martín de Tucumán

BeSoccer - Miércoles, 04 Enero 2017

0 299

El centrocampista Juan Daniel Galeano firma hasta el final del curso por San Martín de Tucumán, de la B Nacional de Argentina.

Independiente negocia con San Martín de Tucumán por Moreira

BeSoccer - Viernes, 05 Agosto 2016

0 736

El defensor Rodrigo Moreira, de 20 años, no entra en los planes de Gabriel Milito en Independiente.

Diego Cagna, nuevo entrenador de San Martín de Tucumán

Jaime González Pons - Sábado, 09 Abril 2016

0 228

El ex futbolista argentino será el entrenador del equipo que juega en el Federal A, en Argentina.

Omar Asad podría entrenar a San Martín de Tucumán

Jaime González Pons - Jueves, 07 Abril 2016

0 217

Así lo afirma 'MundoAscenso.com', que sostiene que el único impedimento podría ser una oferta del fútbol mexicano.

Ver más noticias del equipo»

Competiciones que juega

Primera Nacional

Pos	Equipos		Pts
1		San Martín Tucumán	66
2		Godoy Cruz	65
3		Unión Santa Fe	56
4		Belgrano	56
5		Chacarita Juniors	56
6		Quilmes	55
7		Tiro Federal Rosario	54
8		Atletico Rafaela	53
9		CAI	51
10		Ferro Carril Oeste	51
11		Aldosivi	48
12		Indep. Rivadavia	47
13		Talleres Córdoba	46
14		Almagro	43
15		Instituto	43
16		Defensa y Justicia	43
17		Platense	42
18		Almirante Brown	41
19		Ben Hur	38
20		Nueva Chicago	34

RIVALES EN Primera Nacional

USO DE MEMORIA

5,660,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.7808
Total Execution Time	0.7827

CADENA URL

/San-Martin-Tucuman-Ar/2008

GET DATOS

$_GET['/San-Martin-Tucuman-Ar/2008']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0144	SELECT type FROM routes WHERE alias = 'san-martin-tucuman-ar'
0.0158	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 = 'San-Martin-Tucuman-Ar' AND l.year = 2008 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=11960 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=11960 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294	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 = 12931
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11960 AND type_rel = 2
0.0147	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11960 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (58339,58950,97354,156379,159119) ORDER BY n.cover_points DESC, update_date DESC
0.0155	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 = '11960' ORDER BY l.year DESC,cat.coefficient 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 = '11960' AND l.year = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0151	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 = '11960' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 12931 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	(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 calendars2008 as c ON c.league_id = l.id WHERE (c.datateam1 = 11960 or c.datateam2 = 11960) AND l.year = 2008 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0152	(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 calendars2008 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 = 11960 or c.datateam2 = 11960) AND l.year = 2008 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0152	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2008 as c ON c.league_id = l.id INNER JOIN events2008 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 = 11960 or c.datateam2 = 11960) AND l.year = 2008)
0.0150	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=11960 AND l.year in (2007,2008,2009) 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 (33494,12943,12942,8386,8385) 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.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 33494 AND teamId = 11960
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 12942 AND teamId = 11960
0.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 12943 AND teamId = 11960
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 8386 AND teamId = 11960
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 8385 AND teamId = 11960
0.0151	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2008` 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 = 12931 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '11960' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11960' and rp.type = 4
0.0146	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 = '11960' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155	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 events2008 e ON e.player_id = p.id AND e.league_id = 12931 WHERE rp.league_id = 12931 AND rp.teamId = 11960 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.0153	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 events2008 e ON e.player_id = p.id AND e.league_id = 12931 WHERE rp.league_id = 12931 AND rp.teamId = 11960 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 events2008 e ON e.player_id = p.id AND e.league_id = 12931 WHERE rp.league_id = 12931 AND rp.teamId = 11960 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 = 11960 AND rp.league_id = 12931 AND l.year= 2008 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0149	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=185916 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=185916
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 events2008 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=185916 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.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 events2008 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=185916 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 events2008 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=185916 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0149	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 events2008 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=185916 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
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 events2008 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=185916 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0146	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 = 12931 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

San Martín Tucumán

Información sobre San Martín Tucumán

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Liga Profesional Argentina

Primera Nacional

Copa Argentina

Torneo Federal A Grupo 0

Argentino A

Apertura Argentina

Clausura Argentina

Torneos de Verano Argentina

Torneo Federal A Transición Grupo 3

Partidos Amistosos

Torneo Federal A - PlayOffs

Copa Diego Armando Maradona

Primera B Nacional - Clausura

Primera B Nacional - Apertura

Partidos del San Martín Tucumán

Estadísticas

Plantilla del San Martín Tucumán Temporada 2007/2008

Noticias del San Martín Tucumán

San Martín de Tucumán se hace con los servicios de Gracián

Galeano ficha por San Martín de Tucumán

Independiente negocia con San Martín de Tucumán por Moreira

Diego Cagna, nuevo entrenador de San Martín de Tucumán

Omar Asad podría entrenar a San Martín de Tucumán

San Martín Tucumán

Selecciona un equipo

Competiciones que juega

Primera Nacional

RIVALES EN Primera Nacional


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