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

Resultados de Fútbol

Estudiantes La Plata

Entrenador: Eduardo Domínguez

Temporada 2016/2017

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

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

TEMPORADA 2013/2014

TORNEO DE TRANSICIÓN
Equipo		PJ	GF	GC	Puntos
1	Racing Club	19	30	16	41
2	River Plate	19	34	13	39
3	Lanús	19	28	23	35
4	Independient	19	31	29	33
5	Boca Juniors	19	25	23	31
6	Estudiantes	19	23	23	31
7	Tigre	19	30	26	26
8	San Lorenzo	19	26	22	26
9	Arsenal	19	27	25	26
10	Belgrano	19	26	26	25
11	Vélez	19	21	22	25
12	Newell's	19	21	24	25
13	Atletico	19	25	29	25
14	Gimnasia	19	16	15	24
15	Rosario	19	21	28	21
16	Godoy Cruz	19	31	39	21
17	Banfield	19	25	25	20
18	Defensa	19	19	30	20
19	Olimpo	19	15	22	19
20	Quilmes	19	17	31	12

TEMPORADA 2012/2013

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Newell's	19	40	21	38
2	River Plate	19	28	22	35
3	Lanús	19	26	14	33
4	San Lorenzo	19	26	16	32
5	Quilmes	19	28	22	31
6	Racing Club	19	24	17	29
7	Godoy Cruz	19	23	16	29
8	Arsenal	19	25	22	29
9	Martín Juan	19	31	28	26
10	Belgrano	19	14	13	23
11	Atletico	19	21	23	23
12	Independient	19	16	17	22
13	Tigre	19	22	30	21
14	Vélez	19	18	20	20
15	Estudiantes	19	15	19	20
16	All Boys	19	15	24	20
17	Colón	19	20	30	20
18	Argentinos	19	13	21	18
19	Boca Juniors	19	13	29	18
20	Unión Santa	19	17	31	17

TEMPORADA 2011/2012

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Arsenal	19	30	15	38
2	Tigre	19	29	15	36
3	Vélez	19	26	15	33
4	Boca Juniors	19	30	20	33
5	All Boys	19	21	13	33
6	Newell's	19	26	19	32
7	Colón	19	24	18	29
8	Argentinos	19	17	15	27
9	Estudiantes	19	23	24	27
10	Lanús	19	19	18	26
11	Unión Santa	19	21	20	25
12	San Lorenzo	19	22	23	25
13	Atletico	19	26	24	24
14	Belgrano	19	17	20	24
15	Martín Juan	19	21	29	22
16	Independient	19	22	28	20
17	Racing Club	19	19	27	19
18	Godoy Cruz	19	11	25	14
19	Olimpo	19	20	34	13
20	Banfield	19	15	37	11

TEMPORADA 2010/2011

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

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

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

TEMPORADA 2007/2008

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

TEMPORADA 2006/2007

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	San Lorenzo	19	34	17	45
2	Boca Juniors	19	38	20	39
3	Estudiantes	19	28	17	37
4	River Plate	19	26	17	33
5	Arsenal	19	31	24	30
6	Lanús	19	24	19	28
7	Colón	19	28	24	28
8	Argentinos	19	21	17	26
9	Vélez	19	22	26	26
10	Godoy Cruz	19	24	22	25
11	Independient	19	23	24	25
12	Rosario	19	17	21	24
13	Racing Club	19	28	30	23
14	Newell's	19	22	30	22
15	Nueva	19	19	28	21
16	Banfield	19	22	30	19
17	Belgrano	19	24	27	18
18	Gimnasia	19	19	28	17
19	Gimnasia	19	11	22	17
20	Quilmes	19	18	36	12

TEMPORADA 2005/2006

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Boca Juniors	19	37	14	43
2	Lanús	19	26	15	35
3	River Plate	19	39	24	34
4	Gimnasia	19	26	16	33
5	Gimnasia	19	31	22	32
6	Newell's	19	27	18	31
7	Banfield	19	28	22	31
8	San Lorenzo	19	15	14	28
9	Olimpo	19	22	22	26
10	Vélez	19	21	18	25
11	Estudiantes	19	25	31	24
12	Independient	19	18	18	23
13	Rosario	19	15	17	23
14	Argentinos	19	26	28	22
15	Arsenal	19	17	20	22
16	Colón	19	19	26	20
17	Quilmes	19	16	28	20
18	Racing Club	19	14	24	19
19	Instituto	19	16	37	13
20	Tiro Federal	19	15	39	12

TEMPORADA 2004/2005

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Vélez	19	32	14	39
2	Banfield	19	25	16	33
3	Racing Club	19	25	17	32
4	Estudiantes	19	28	23	31
5	Rosario	19	27	24	31
6	Arsenal	19	27	22	30
7	Gimnasia	19	25	25	29
8	Lanús	19	36	27	28
9	Instituto	19	32	30	28
10	River Plate	19	31	29	27
11	Colón	19	30	23	26
12	Independient	19	29	26	26
13	Olimpo	19	18	22	26
14	Newell's	19	22	21	24
15	Boca Juniors	19	26	30	22
16	San Lorenzo	19	23	29	22
17	Argentinos	19	28	30	21
18	Quilmes	19	16	23	20
19	Almagro	19	25	44	16
20	Huracán	19	12	42	5

TEMPORADA 2003/2004

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	River Plate	19	41	21	40
2	Boca Juniors	19	34	17	36
3	Talleres	19	30	19	35
4	Banfield	19	27	17	32
5	Vélez	19	31	21	31
6	Quilmes	19	21	16	29
7	Arsenal	19	21	22	29
8	Racing Club	19	29	29	28
9	San Lorenzo	19	18	16	26
10	Atletico	19	25	24	26
11	Colón	19	20	26	25
12	Newell's	19	28	25	22
13	Independient	19	21	27	22
14	Estudiantes	19	19	29	21
15	Lanús	19	21	27	20
16	Olimpo	19	18	28	19
17	Gimnasia	19	21	26	17
18	Nueva	19	18	27	17
19	Chacarita	19	21	34	17
20	Rosario	19	16	29	13

TEMPORADA 2002/2003

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	River Plate	19	43	18	43
2	Boca Juniors	19	36	23	39
3	Vélez	19	27	12	38
4	Rosario	19	40	18	37
5	Nueva	21	32	33	32
6	Olimpo	19	22	17	31
7	Colón	19	19	14	29
8	San Lorenzo	19	27	28	29
9	Estudiantes	19	24	18	28
10	Talleres	21	25	26	27
11	Gimnasia	19	21	26	26
12	Racing Club	19	26	24	25
13	Lanús	19	27	29	25
14	Banfield	19	18	20	23
15	Arsenal	19	12	13	22
16	Newell's	19	21	26	22
17	Independient	19	13	25	18
18	Unión Santa	19	18	29	17
19	Chacarita	19	11	24	11
20	CA Huracán	19	12	46	6

TEMPORADA 2001/2002

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

TEMPORADA 2000/2001

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	San Lorenzo	19	43	17	47
2	River Plate	19	48	27	41
3	Boca Juniors	19	29	26	30
4	Argentinos	19	27	22	29
5	Racing Club	19	21	20	29
6	Chacarita	19	21	25	29
7	CA Huracán	19	28	28	28
8	Vélez	19	25	24	27
9	Estudiantes	19	23	24	27
10	Almagro	19	27	27	26
11	Talleres	19	23	23	25
12	Newell's	19	27	28	24
13	Colón	19	21	27	23
14	Lanús	19	28	30	22
15	Los Andes	19	24	32	21
16	Unión Santa	19	32	36	20
17	Belgrano	19	18	26	20
18	Independient	19	18	21	19
19	Gimnasia	19	22	28	18
20	Rosario	19	24	38	17

TEMPORADA 1999/2000

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	River Plate	19	44	17	42
2	Boca Juniors	19	38	17	36
3	Independient	19	42	25	36
4	Colón	19	38	26	36
5	San Lorenzo	19	27	15	36
6	Newell's	19	32	21	34
7	Vélez	19	28	18	34
8	Unión Santa	19	28	40	29
9	Lanús	19	32	22	28
10	Gimnasia	19	28	33	28
11	Talleres	19	21	22	27
12	Instituto	19	28	29	25
13	Rosario	19	25	26	23
14	Belgrano	19	28	31	22
15	Chacarita	19	20	30	20
16	Argentinos	19	21	36	18
17	Estudiantes	19	21	30	16
18	Racing Club	19	22	29	15
19	Gimnasia	19	15	34	10
20	Ferro Carril	19	9	46	8

TEMPORADA 1998/1999

CLAUSURA ARGENTINA
Equipo		PJ	GF	GC	Puntos
1	Boca Juniors	19	35	11	44
2	River Plate	19	37	19	37
3	San Lorenzo	19	33	19	36
4	Rosario	19	24	20	32
5	Independient	19	32	26	29
6	Unión Santa	19	29	27	29
7	Newell's	19	30	22	27
8	Colón	19	28	21	27
9	Gimnasia	19	28	32	26
10	Belgrano	19	20	20	25
11	Gimnasia	19	28	37	25
12	Argentinos	19	20	23	24
13	Vélez	19	21	24	22
14	Racing Club	19	20	32	22
15	Estudiantes	19	18	18	21
16	Talleres	19	23	26	20
17	Lanús	19	23	28	20
18	Platense	19	16	30	17
19	Ferro Carril	19	8	18	15
20	CA Huracán	19	15	35	12

Competiciones que juega

Liga Profesional Argentina

Pos	Equipos		Pts
1		Boca Juniors	63
2		River Plate	56
3		Estudiantes La Plata	56
4		Racing Club	55
5		Banfield	54
6		Independiente	53
7		San Lorenzo	53
8		Lanús	50
9		Newell's Old Boys	49
10		Defensa y Justicia	49
11		Colón	49
12		Rosario Central	44
13		Gimnasia La Plata	43
14		Godoy Cruz	43
15		Talleres Córdoba	42
16		Olimpo	38
17		Atletico Rafaela	37
18		Temperley	37
19		Vélez Sarsfield	37
20		Patronato	34
21		Atl. Tucumán	33
22		San Martín San Juan	33
23		Unión Santa Fe	32
24		Tigre	31
25		CA Huracán	29
26		Sarmiento	28
27		Arsenal de Sarandí	27
28		Belgrano	26
29		Quilmes	25
30		Aldosivi	25

	Copa Libertadores : Boca Juniors, River Plate, Estudiantes La Plata, Racing Club, Banfield
	Liguilla Sudamericana : Independiente, San Lorenzo, Lanús, Newell's Old Boys, Defensa y Justicia, Colón

RIVALES EN Conmebol Sudamer.

RIVALES EN Copa Libertadore.

RIVALES EN Copa Argentina

RIVALES EN Liga Profesional.

USO DE MEMORIA

9,439,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.9655
Total Execution Time	0.9667

CADENA URL

/historico/Estudiantes-Plata/2017

GET DATOS

$_GET['/historico/Estudiantes-Plata/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0187	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 = 'Estudiantes-Plata' AND l.year = 2017 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=1010 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=1010 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=1010 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=1010 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=1010 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=1010 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=1010 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 33424
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 = 37645
0.0150	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 = 37546
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1010 AND type_rel = 2
0.0154	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1010 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 (940,6833,8041,9693,10211) ORDER BY n.cover_points DESC, update_date DESC
0.0162	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 = '1010' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0183	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 = '1010' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 37645 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0171	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=1010 AND l.year in (2016,2017,2018) 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 (42027,42018,41956,38943,38427,37834,29074) 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 = 38943 AND teamId = 1010
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 41956 AND teamId = 1010
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 37834 AND teamId = 1010
0.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 42027 AND teamId = 1010
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 42018 AND teamId = 1010
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 29074 AND teamId = 1010
0.0231	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 1010
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148	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 = '1010' 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 = '1010' and rp.type = 4
0.0149	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 = '1010' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1010' and rp.type = 4
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 events2017 e ON e.player_id = p.id AND e.league_id = 33424 WHERE rp.league_id = 33424 AND rp.teamId = 1010 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.0166	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 events2017 e ON e.player_id = p.id AND e.league_id = 33424 WHERE rp.league_id = 33424 AND rp.teamId = 1010 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161	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 events2017 e ON e.player_id = p.id AND e.league_id = 33424 WHERE rp.league_id = 33424 AND rp.teamId = 1010 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167	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 = 1010 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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.0150	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.0153	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 = 8714 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 3841 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 8376 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 8380 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 8382 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 8386 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 8388 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 8391 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables2006` 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 = 8393 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2005` 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 = 8395 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables2004` 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 = 8397 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2003` 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 = 8400 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 8402 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables2001` 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 = 8405 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables2000` 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 = 8407 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables1999` 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 = 8408 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


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

Resultados de Fútbol

Estudiantes La Plata

Estudiantes La Plata

Selecciona un equipo

Competiciones que juega

Liga Profesional Argentina

RIVALES EN Conmebol Sudamer.

RIVALES EN Copa Libertadore.

RIVALES EN Copa Argentina

RIVALES EN Liga Profesional.