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

Atl. Tucumán

Entrenador: Facundo Sava

Temporada 2018/2019

TEMPORADA 2018/2019

LIGA PROFESIONAL ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Racing Club	25	43	16	57
2	Defensa	25	33	18	53
3	Boca Juniors	25	42	18	51
4	River Plate	25	42	21	45
5	Atl.	25	36	29	42
6	Vélez	25	34	25	40
7	Independient	25	35	28	38
8	Unión Santa	25	29	24	36
9	Tigre	25	39	42	36
10	CA Huracán	25	28	28	35
11	Lanús	25	27	32	34
12	Talleres	25	25	24	33
13	Aldosivi	25	21	24	33
14	Godoy Cruz	25	23	30	32
15	Newell's	25	26	23	29
16	Banfield	25	27	31	29
17	Estudiantes	25	21	25	29
18	Gimnasia	25	21	32	29
19	Patronato	25	29	37	26
20	Rosario	25	16	26	26
21	Martín Juan	25	24	34	25
22	Belgrano	25	16	23	24
23	San Lorenzo	25	21	30	23
24	Colón	25	21	33	23
25	Martín	25	25	38	23
26	Argentinos	25	15	28	22

TEMPORADA 2017/2018

LIGA PROFESIONAL ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Boca Juniors	27	50	22	58
2	Godoy Cruz	27	45	24	56
3	San Lorenzo	27	31	20	50
4	CA Huracán	27	35	24	48
5	Talleres	27	33	20	46
6	Independient	27	29	19	46
7	Racing Club	27	46	32	45
8	River Plate	27	39	26	45
9	Defensa	27	41	34	44
10	Unión Santa	27	33	23	43
11	Colón	27	32	22	41
12	Argentinos	27	36	30	41
13	Belgrano	27	29	28	40
14	Vélez	27	31	32	38
15	Atl.	27	29	26	36
16	Estudiantes	27	25	26	36
17	Banfield	27	27	24	35
18	Martín Juan	27	30	36	33
19	Patronato	27	26	32	33
20	Rosario	27	30	41	32
21	Lanús	27	20	37	29
22	Newell's	27	23	28	27
23	Gimnasia	27	28	43	27
24	Tigre	27	26	33	24
25	Temperley	27	22	46	23
26	Chacarita	27	23	40	18
27	Arsenal	27	19	36	17
28	Olimpo	27	16	50	15

TEMPORADA 2016/2017

LIGA PROFESIONAL ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Boca Juniors	30	62	25	63
2	River Plate	30	51	28	56
3	Estudiantes	30	46	26	56
4	Racing Club	30	51	40	55
5	Banfield	30	42	35	54
6	Independient	30	39	23	53
7	San Lorenzo	30	46	35	53
8	Lanús	30	36	25	50
9	Newell's	30	40	30	49
10	Defensa	30	31	23	49
11	Colón	30	32	25	49
12	Rosario	30	40	31	44
13	Gimnasia	30	26	24	43
14	Godoy Cruz	30	34	34	43
15	Talleres	30	35	30	42
16	Olimpo	30	37	32	38
17	Atletico	30	31	30	37
18	Temperley	30	30	38	37
19	Vélez	30	31	40	37
20	Patronato	30	30	40	34
21	Atl.	30	34	40	33
22	Martín Juan	30	27	40	33
23	Unión Santa	30	25	39	32
24	Tigre	30	33	43	31
25	CA Huracán	30	23	30	29
26	Sarmiento	30	31	51	28
27	Arsenal	30	27	50	27
28	Belgrano	30	21	34	26
29	Quilmes	30	18	43	25
30	Aldosivi	30	15	40	25

TEMPORADA 2015/2016

LIGA PROFESIONAL ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	San Lorenzo	16	23	16	34
2	Godoy Cruz	16	27	14	33
3	Independient	16	22	12	27
4	Arsenal	16	21	15	27
5	Gimnasia	16	19	19	25
6	Vélez	16	20	19	24
7	Rosario	16	19	16	20
8	Patronato	16	19	23	20
9	River Plate	16	21	22	18
10	Sarmiento	16	10	18	17
11	Colón	16	21	31	17
12	Belgrano	16	21	24	16
13	Banfield	16	15	20	15
14	Quilmes	16	21	32	15
15	Olimpo	16	11	20	13
16	Lanús	16	28	10	38
17	Estudiantes	16	25	11	32
18	Atl.	16	26	19	30
19	Defensa	16	25	16	25
20	CA Huracán	16	21	15	25
21	Racing Club	16	29	26	24
22	Martín Juan	16	23	20	23
23	Unión Santa	16	24	22	22
24	Tigre	16	21	17	20
25	Boca Juniors	16	15	13	20
26	Aldosivi	16	19	28	17
27	Newell's	16	16	21	16
28	Temperley	16	14	21	16
29	Argentinos	16	11	29	12
30	Atletico	16	14	32	9

TEMPORADA 2014/2015

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Atl.	42	69	31	85
2	Patronato	42	60	24	82
3	Ferro Carril	42	44	37	67
4	Dep.	42	54	40	66
5	Instituto	42	48	38	62
6	Villa	42	44	42	60
7	Atlético	42	50	46	58
8	Douglas Haig	42	45	46	58
9	Sportivo	42	47	44	56
10	Gimnasia	42	35	43	55
11	Los Andes	42	46	49	54
12	Gualeguaychu	42	43	47	54
13	Boca Unidos	42	37	42	54
14	All Boys	42	38	37	53
15	Central	42	37	44	51
16	Indep.	42	38	46	51
17	Guaraní	42	38	43	50
18	Chacarita	42	49	62	50
19	Guillermo	42	43	50	48
20	Gimnasia	42	37	53	48
21	Sportivo	42	36	50	40
22	Unión Plata	42	36	60	37

TEMPORADA 2013/2014

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Banfield	42	71	40	78
2	Defensa	42	67	45	75
3	Independient	42	49	37	67
4	CA Huracán	42	43	30	67
5	Atl.	42	44	36	64
6	Instituto	42	54	46	62
7	Gimnasia	42	41	35	61
8	Crucero	42	45	42	59
9	Martín Juan	42	49	52	57
10	Unión Santa	42	48	48	55
11	Indep.	42	50	51	55
12	Sarmiento	42	45	47	55
13	Ferro Carril	42	35	39	55
14	Boca Unidos	42	43	46	54
15	Sportivo	42	39	40	53
16	Aldosivi	42	42	47	51
17	Douglas Haig	42	35	44	51
18	Brown	42	45	50	50
19	Patronato	42	30	34	49
20	Talleres	42	48	58	45
21	Almirante	42	30	48	42
22	Villa Carlos	42	31	69	24

TEMPORADA 2012/2013

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Rosario	38	51	29	74
2	Gimnasia	38	53	25	73
3	Olimpo	38	43	22	66
4	Banfield	38	45	39	58
5	Sarmiento	38	40	34	58
6	Defensa	38	45	46	57
7	Patronato	38	42	40	56
8	CA Huracán	38	44	41	54
9	Atl.	38	44	40	51
10	Gimnasia	38	25	29	50
11	Douglas Haig	38	43	44	49
12	Indep.	38	33	36	48
13	Almirante	38	43	45	46
14	Boca Unidos	38	32	37	45
15	Crucero	38	31	40	45
16	Aldosivi	38	37	45	44
17	Ferro Carril	38	29	32	43
18	Instituto	38	33	41	39
19	Deportivo	38	30	57	37
20	Nueva	38	33	54	31

TEMPORADA 2011/2012

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	River Plate	38	66	28	73
2	Quilmes	38	62	21	72
3	Instituto	38	56	28	70
4	Rosario	38	49	33	69
5	Boca Unidos	38	55	48	57
6	Patronato	38	41	38	56
7	Ferro Carril	38	29	28	56
8	Almirante	38	36	30	55
9	Gimnasia	38	38	33	54
10	Defensa	38	50	50	54
11	Aldosivi	38	50	47	53
12	CA Huracán	38	43	50	46
13	Indep.	38	35	50	45
14	Deportivo	38	28	38	43
15	Atl.	38	33	49	42
16	Guillermo	38	46	63	38
17	Sportivo	38	34	55	37
18	Gimnasia	38	32	50	34
19	Atlanta	38	28	50	34
20	Chacarita	38	24	46	32

TEMPORADA 2010/2011

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Atletico	38	65	26	77
2	Unión Santa	38	49	38	69
3	Martín Juan	38	46	32	64
4	Belgrano	38	53	37	59
5	Gimnasia	38	40	41	54
6	Almirante	38	32	28	52
7	Aldosivi	38	45	47	52
8	Boca Unidos	38	43	46	52
9	Atl.	38	44	41	51
10	Instituto	38	38	35	51
11	Deportivo	38	32	37	51
12	Rosario	38	44	44	50
13	Patronato	38	41	43	50
14	Ferro Carril	38	38	47	47
15	Martín	38	33	41	45
16	Chacarita	38	24	36	44
17	Defensa	38	37	42	43
18	Indep.	38	44	49	40
19	Tiro Federal	38	37	56	37
20	CAI	38	38	57	34

TEMPORADA 2009/2010

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Argentinos	19	35	23	41
2	Estudiantes	19	33	14	40
3	Godoy Cruz	19	28	14	37
4	Independient	19	25	18	34
5	Banfield	19	24	16	32
6	Newell's	19	32	18	30
7	Lanús	19	25	23	29
8	Racing Club	19	21	22	29
9	Vélez	19	25	20	27
10	CA Huracán	19	21	22	26
11	Tigre	19	28	26	24
12	Gimnasia	19	21	29	24
13	River Plate	19	16	21	22
14	Colón	19	20	32	21
15	San Lorenzo	19	16	21	20
16	Boca Juniors	19	28	35	20
17	Rosario	19	12	19	19
18	Arsenal	19	19	33	19
19	Chacarita	19	22	33	13
20	Atl.	19	14	26	13

TEMPORADA 2008/2009

PRIMERA NACIONAL
Equipo		PJ	GF	GC	Puntos
1	Atl.	38	59	30	74
2	Chacarita	38	58	30	72
3	Atletico	38	47	39	62
4	Belgrano	38	36	29	62
5	Instituto	38	50	43	59
6	Aldosivi	38	32	33	57
7	Ferro Carril	38	52	48	52
8	Quilmes	38	39	41	51
9	All Boys	38	46	46	50
10	Tiro Federal	38	45	46	50
11	Indep.	38	46	48	50
12	Talleres	38	50	54	50
13	Martín Juan	38	46	41	49
14	Defensa	38	47	47	49
15	Unión Santa	38	48	52	49
16	Los Andes	38	51	57	45
17	Olimpo	38	39	59	40
18	Platense	38	37	51	37
19	CAI	38	35	45	36
20	Almagro	38	36	60	32

TEMPORADA 2007/2008

ARGENTINO A GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Racing	6	7	0	14
2	Sportivo	6	4	6	9
3	Libertad	6	6	8	5
4	Dep.	6	5	8	5
5	Atl.	6	11	5	15
6	Cipolletti	6	12	9	12
7	Talleres	6	6	9	6
8	Unión	6	11	17	3

TEMPORADA 2006/2007

ARGENTINO A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Guillermo	14	31	20	28
2	Gimnasia	14	22	23	23
3	Dep.	14	14	9	22
4	Rivadavia	14	22	16	21
5	Real Arroyo	14	19	17	20
6	Douglas Haig	14	14	16	17
7	Juventud	14	16	21	16
8	La Plata FC	14	8	24	9
9	Indep.	14	16	11	28
10	Sportivo	14	19	13	24
11	Martín	14	13	11	22
12	Alumni Villa	14	15	16	22
13	Luján Cuyo	14	14	14	15
14	Juventud	14	15	19	15
15	Gimnasia	14	17	17	13
16	Racing	14	14	22	10
17	Sportivo	14	19	14	29
18	Atl.	14	20	17	21
19	Juventud	14	17	14	21
20	Unión	14	16	17	20
21	Florida	14	14	18	19
22	Julio	14	15	16	18
23	Talleres	14	15	19	17
24	Central	14	17	18	14

TEMPORADA 2001/2002

PRIMERA B NACIONAL - CLAUSURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gimnasia	14	25	16	25
2	Platense	14	24	16	25
3	Atletico	14	28	23	24
4	Defensa	14	24	19	24
5	Racing	14	29	25	24
6	El Porvenir	14	25	23	21
7	Martín	14	14	30	6
8	Atl.	14	8	25	4

TEMPORADA 1983/1984

LIGA PROFESIONAL ARGENTINA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Independient	6	10	3	13
2	Chacarita	6	14	6	12
3	Atl.	6	7	7	7
4	Kimberley	6	3	18	2

TEMPORADA 1980/1981

LIGA PROFESIONAL ARGENTINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ferro Carril	14	24	11	22
2	Boca Juniors	14	28	12	19
3	River Plate	14	26	12	19
4	Loma Negra	14	15	10	19
5	Instituto	14	18	14	16
6	Estudiantes	14	16	13	16
7	San Lorenzo	14	14	15	14
8	Atl.	14	14	17	14
9	Unión Santa	14	13	15	10
10	Talleres	14	9	16	10
11	Guaraní	14	16	24	10
12	Martín	14	17	24	9
13	Sarmiento	14	10	20	9
14	Lorenzo	14	13	30	9

Competiciones que juega

Grupo 1

Liga Profesional Argentina

Pos	Equipos		Pts
1		Racing Club	57
2		Defensa y Justicia	53
3		Boca Juniors	51
4		River Plate	45
5		Atl. Tucumán	42
6		Vélez Sarsfield	40
7		Independiente	38
8		Unión Santa Fe	36
9		Tigre	36
10		CA Huracán	35
11		Lanús	34
12		Talleres Córdoba	33
13		Aldosivi	33
14		Godoy Cruz	32
15		Newell's Old Boys	29
16		Banfield	29
17		Estudiantes La Plata	29
18		Gimnasia La Plata	29
19		Patronato	26
20		Rosario Central	26
21		San Martín San Juan	25
22		Belgrano	24
23		San Lorenzo	23
24		Colón	23
25		San Martín Tucumán	23
26		Argentinos Juniors	22

	Copa Libertadores : Racing Club, Defensa y Justicia, Boca Juniors
	Liguilla Libertadores : River Plate
	Liguilla Sudamericana : Atl. Tucumán, Vélez Sarsfield, Independiente, Unión Santa Fe, CA Huracán
	Descenso : Tigre, San Martín San Juan, Belgrano, San Martín Tucumán

RIVALES EN Copa Diego Arman.

RIVALES EN Copa Argentina

RIVALES EN Liga Profesional.

USO DE MEMORIA

8,069,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2341
Total Execution Time	0.2354

CADENA URL

/historico/Atletico-Tucuman/2019

GET DATOS

$_GET['/historico/Atletico-Tucuman/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.0036	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 = 'Atletico-Tucuman' AND l.year = 2019 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.0018	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=4343 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=4343 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=4343 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=4343 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=4343 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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 = 43555
0.0023	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 = 48466
0.0024	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 = 49304
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4343 AND type_rel = 2
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4343 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	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 (21708,40703,41115,42558,45110) ORDER BY n.cover_points DESC, update_date DESC
0.0039	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 = '4343' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '4343' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 49304 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 48466 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 43555 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034	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=4343 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (55450,53563,53492,53476,49952,43475,42018,41953) 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.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 49952 AND teamId = 4343
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 41953 AND teamId = 4343
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 55450 AND teamId = 4343
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 53476 AND teamId = 4343
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 53563 AND teamId = 4343
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 53492 AND teamId = 4343
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 42018 AND teamId = 4343
0.0395	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 4343
0.0030	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2019` 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 = 43555 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '4343' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4343' and rp.type = 4
0.0022	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 = '4343' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4343' and rp.type = 4
0.0035	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 events2019 e ON e.player_id = p.id AND e.league_id = 43555 WHERE rp.league_id = 43555 AND rp.teamId = 4343 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.0035	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 events2019 e ON e.player_id = p.id AND e.league_id = 43555 WHERE rp.league_id = 43555 AND rp.teamId = 4343 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 events2019 e ON e.player_id = p.id AND e.league_id = 43555 WHERE rp.league_id = 43555 AND rp.teamId = 4343 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 4343 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026	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* `tables2019` 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 = 43555 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2018` 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 = 38943 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2017` 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 = 33424 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `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 = 20176 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2015` 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 = 3855 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables2015` 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 = 9170 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `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 = 2501 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2013` 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 = 1999 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables2012` 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 = 1387 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables2011` 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 = 12934 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2009` 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 = 12932 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `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 = 16568 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `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 = 16570 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2007` 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 = 16574 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2007` 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 = 16572 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2002` 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 = 27498 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2002` 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 = 27507 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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* `tables1984` 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 = 26450 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables1981` 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 = 26553 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 43555 ORDER BY nameShow LIMIT 100

Atl. Tucumán

Atl. Tucumán

Selecciona un equipo

Competiciones que juega

Liga Profesional Argentina

RIVALES EN Copa Diego Arman.

RIVALES EN Copa Argentina

RIVALES EN Liga Profesional.