Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

CA Estudiantes

Entrenador: Walter Otta

Temporada 2019/2020

TEMPORADA 2019/2020

PRIMERA NACIONAL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estudiantes	7	11	5	13
2	Platense	7	10	6	13
3	Estudiantes	7	13	10	12
4	Argentino	7	7	11	10
5	Atlanta	7	12	12	8
6	Deportivo	7	6	8	6
7	Temperley	7	3	5	6
8	Ferro Carril	7	7	12	6
9	Sarmiento	7	8	4	15
10	Atletico	7	13	8	14
11	Def.	7	6	3	13
12	Tigre	7	9	9	8
13	Gimnasia	7	10	10	7
14	Dep. Riestra	7	8	11	6
15	Villa	7	5	9	6
16	Martín	7	3	8	5

TEMPORADA 2018/2019

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Barracas	38	59	15	81
2	Atlanta	38	64	27	72
3	Estudiantes	38	59	32	72
4	Dep. Riestra	38	50	34	68
5	Acassuso	38	38	23	59
6	San Telmo	38	45	33	57
7	Colegiales	38	34	32	54
8	All Boys	38	43	48	54
9	Almirante	38	37	42	52
10	UAI Urquiza	38	26	33	51
11	Flandria	38	36	32	50
12	Fénix	38	31	35	45
13	Def. Unidos	38	34	41	44
14	Tristán	38	33	43	42
15	JJ Urquiza	38	34	46	41
16	Miguel	38	21	28	40
17	Sacachispas	38	28	46	37
18	Comunicacion	38	22	48	31
19	Dep.	38	23	56	31
20	Talleres	38	23	46	30

TEMPORADA 2017/2018

PRIMERA B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Platense	34	45	21	64
2	Estudiantes	34	42	25	64
3	Acassuso	34	38	21	54
4	Atlanta	34	42	32	52
5	Def.	34	38	29	52
6	Barracas	34	45	38	51
7	Tristán	34	48	38	50
8	UAI Urquiza	34	28	29	49
9	Talleres	34	32	36	49
10	Miguel	34	32	40	43
11	San Telmo	34	28	36	43
12	Sacachispas	34	35	47	42
13	Comunicacion	34	38	41	41
14	Fénix	34	38	43	39
15	Colegiales	34	34	44	39
16	Villa Carlos	34	35	48	38
17	Dep.	34	27	40	31
18	Almirante	34	27	44	29

TEMPORADA 2016/2017

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Deportivo	36	47	22	66
2	Dep. Riestra	36	53	37	58
3	Atlanta	36	45	33	57
4	Comunicacion	36	45	33	55
5	Def.	36	32	28	54
6	Estudiantes	36	42	38	52
7	Barracas	36	50	40	51
8	Dep.	36	38	33	51
9	Platense	36	32	30	51
10	Almirante	36	30	38	51
11	San Telmo	36	42	38	49
12	UAI Urquiza	36	33	39	48
13	Fénix	36	40	37	46
14	Tristán	36	31	47	41
15	Acassuso	36	36	35	40
16	Talleres	36	43	52	40
17	Colegiales	36	32	48	37
18	Villa Carlos	36	26	41	36
19	Excursionist	36	32	60	31

TEMPORADA 2015/2016

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Flandria	19	15	9	37
2	Atlanta	19	28	17	35
3	Colegiales	19	26	17	32
4	Deportivo	19	26	19	32
5	Fénix	19	21	14	32
6	Talleres	19	24	22	28
7	Tristán	19	24	27	27
8	Barracas	19	20	17	26
9	San Telmo	19	20	18	26
10	Comunicacion	19	19	18	26
11	Def.	19	16	16	23
12	Villa Carlos	19	22	24	23
13	UAI Urquiza	19	22	23	22
14	Platense	19	19	21	22
15	Almirante	19	17	20	22
16	Dep. Riestra	19	16	21	22
17	Dep.	19	15	20	22
18	Acassuso	19	13	22	20
19	Estudiantes	19	14	22	18
20	Dep. Armenio	19	12	22	16

TEMPORADA 2014/2015

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Brown	42	60	30	81
2	Estudiantes	42	56	32	80
3	Def.	42	44	24	79
4	Atlanta	42	67	41	73
5	Barracas	42	50	43	64
6	Deportivo	42	46	41	62
7	Almagro	42	38	32	60
8	Tristán	42	47	45	58
9	Platense	42	41	43	57
10	Colegiales	42	48	46	56
11	Flandria	42	31	33	54
12	Fénix	42	35	33	53
13	Comunicacion	42	39	43	51
14	Dep. Riestra	42	52	63	51
15	Acassuso	42	22	34	47
16	Dep. Armenio	42	27	40	46
17	UAI Urquiza	42	32	40	45
18	Dep.	42	36	47	44
19	Sportivo	42	38	52	44
20	Almirante	42	47	63	43
21	Villa Carlos	42	34	45	42
22	Deportivo	42	36	56	37

TEMPORADA 2013/2014

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Nueva	40	42	23	73
2	Temperley	40	52	41	66
3	Atlanta	40	40	25	65
4	Platense	40	53	38	64
5	Def.	40	33	24	61
6	Fénix	40	53	47	60
7	Los Andes	40	40	33	58
8	Barracas	40	39	34	58
9	Deportivo	40	43	38	56
10	Chacarita	40	41	43	54
11	Deportivo	40	40	35	53
12	Almagro	40	31	36	53
13	Tristán	40	36	40	51
14	Estudiantes	40	34	34	48
15	Dep. Armenio	40	38	39	47
16	Acassuso	40	36	39	47
17	UAI Urquiza	40	37	52	47
18	Comunicacion	40	31	38	44
19	Villa	40	34	42	44
20	Flandria	40	31	55	35
21	Colegiales	40	22	50	30

TEMPORADA 2012/2013

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Villa Carlos	40	41	26	72
2	Platense	40	39	30	70
3	Atlanta	40	48	39	65
4	Almagro	40	49	36	64
5	Brown	40	56	37	63
6	Estudiantes	40	46	31	63
7	Chacarita	40	47	39	60
8	Dep. Armenio	40	52	41	58
9	Barracas	40	45	44	56
10	Temperley	40	38	35	55
11	Comunicacion	40	41	41	54
12	Tristán	40	40	44	50
13	Los Andes	40	31	39	48
14	Villa	40	41	51	48
15	Flandria	40	40	54	48
16	Acassuso	40	32	51	48
17	Deportivo	40	46	52	47
18	Colegiales	40	38	35	44
19	San Telmo	40	35	51	37
20	Def.	40	33	47	35
21	Central	40	35	50	34

TEMPORADA 2011/2012

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Sarmiento	40	52	24	80
2	Colegiales	40	54	33	73
3	Estudiantes	40	49	29	72
4	Nueva	40	56	36	70
5	Brown	40	64	34	69
6	Platense	40	44	32	61
7	Los Andes	40	44	38	61
8	Comunicacion	40	42	38	60
9	Acassuso	40	43	47	55
10	Almagro	40	43	39	54
11	Villa Carlos	40	32	41	54
12	Dep. Armenio	40	45	50	50
13	Flandria	40	36	44	50
14	San Telmo	40	29	37	47
15	Temperley	40	40	45	46
16	Sportivo	40	33	42	46
17	Tristán	40	48	57	45
18	Def.	40	31	43	41
19	Barracas	40	36	51	40
20	Deportivo	40	39	60	35
21	General	40	27	67	31

TEMPORADA 2010/2011

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Atlanta	42	68	37	86
2	Estudiantes	42	54	43	73
3	Def.	42	48	28	71
4	Nueva	42	43	35	71
5	Brown	42	54	36	70
6	Dep. Armenio	42	43	31	65
7	Barracas	42	50	29	64
8	Deportivo	42	44	37	61
9	Villa Carlos	42	45	43	60
10	Comunicacion	42	41	41	60
11	Almagro	42	52	51	58
12	Acassuso	42	46	43	56
13	Flandria	42	37	31	54
14	Colegiales	42	34	36	53
15	Platense	42	31	34	53
16	Sportivo	42	27	40	47
17	Tristán	42	40	54	46
18	Temperley	42	38	57	44
19	San Telmo	42	35	52	42
20	Sarmiento	42	27	51	37
21	Dep.	42	26	55	35
22	Los Andes	42	40	59	34

TEMPORADA 2009/2010

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Almirante	40	49	30	77
2	Sarmiento	40	56	26	75
3	Tristán	40	40	32	62
4	Estudiantes	40	52	40	61
5	Colegiales	40	44	40	61
6	Los Andes	40	41	35	60
7	Atlanta	40	38	27	58
8	Temperley	40	36	31	56
9	Acassuso	40	44	37	55
10	Def.	40	41	35	55
11	San Telmo	40	32	25	54
12	Brown	40	45	46	54
13	Nueva	40	34	35	51
14	Villa Carlos	40	43	49	48
15	Deportivo	40	36	34	47
16	Flandria	40	48	55	47
17	Dep.	40	36	48	44
18	Almagro	40	29	42	44
19	Dep. Armenio	40	29	44	38
20	Comunicacion	40	34	54	35
21	Central	40	22	64	30

TEMPORADA 2008/2009

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	Sportivo	40	48	30	74
2	Nueva	40	57	38	67
3	Sarmiento	40	59	51	64
4	Deportivo	40	47	36	63
5	Deportivo	40	39	30	63
6	Colegiales	40	50	38	62
7	Estudiantes	40	48	37	60
8	Temperley	40	43	38	59
9	Def.	40	47	45	59
10	Atlanta	40	42	40	57
11	Almirante	40	45	38	55
12	Acassuso	40	37	34	53
13	Talleres	40	41	44	49
14	Brown	40	43	42	47
15	Dep.	40	38	44	47
16	Comunicacion	40	44	56	47
17	San Telmo	40	31	44	44
18	Tristán	40	43	51	43
19	Flandria	40	32	51	40
20	Dep. Armenio	40	44	59	38
21	Central	40	27	59	28

TEMPORADA 2007/2008

PRIMERA B
Equipo		PJ	GF	GC	Puntos
1	All Boys	40	69	29	85
2	Deportivo	40	55	38	70
3	Sportivo	40	46	32	69
4	Atlanta	40	56	36	67
5	Los Andes	40	52	53	64
6	Comunicacion	40	53	35	63
7	Dep. Armenio	40	53	35	61
8	Brown	40	58	48	60
9	Sarmiento	40	58	52	57
10	Estudiantes	40	59	52	54
11	Tristán	40	53	53	54
12	Temperley	40	38	35	52
13	Central	40	39	45	50
14	Flandria	40	41	45	49
15	Dep.	40	41	59	46
16	Acassuso	40	48	50	44
17	Def.	40	45	61	43
18	Talleres	40	30	46	43
19	Deportivo	40	38	55	36
20	San Telmo	40	43	72	35
21	Defensores	40	36	80	26

TEMPORADA 2006/2007

PRIMERA B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Almirante	2	1	0	4
2	Estudiantes	2	0	1	1

TEMPORADA 2005/2006

PRIMERA B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Platense	34	57	35	59
2	Sarmiento	34	60	42	58
3	Temperley	34	41	30	58
4	Deportivo	34	51	36	56
5	Def.	34	45	35	55
6	Central	34	54	44	52
7	Dep. Armenio	34	34	30	52
8	Estudiantes	34	31	25	51
9	Talleres	33	42	43	51
10	Dep.	34	45	40	49
11	Almirante	34	49	51	48
12	All Boys	34	46	48	48
13	Atlanta	34	42	43	46
14	Tristán	34	33	38	44
15	Flandria	34	29	31	43
16	Sportivo	34	38	42	36
17	Los Andes	34	36	40	35
18	Comunicacion	34	35	40	35
19	Defensores	34	33	47	32
20	Laferrere	34	27	38	31
21	San Telmo	33	25	44	30
22	Brown	34	33	64	25

TEMPORADA 2003/2004

PRIMERA B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atlanta	21	34	12	42
2	Deportivo	21	41	20	39
3	Tristán	21	30	16	38
4	Flandria	21	23	17	36
5	Almirante	21	25	22	35
6	All Boys	21	25	19	34
7	Sarmiento	21	25	25	33
8	Estudiantes	21	27	23	31
9	Colegiales	21	26	24	29
10	Temperley	21	25	22	27
11	Sportivo	21	20	19	27
12	Central	21	25	30	27
13	Tigre	21	20	26	27
14	San Telmo	21	26	26	26
15	Platense	21	27	28	26
16	Laferrere	21	30	33	26
17	Dep. Armenio	21	23	27	25
18	Defensores	21	26	32	24
19	Dep.	21	24	31	20
20	Arg. Quilmes	21	15	32	19
21	Talleres	21	16	38	16
22	Brown	21	20	31	15

Competiciones que juega

Primera Nacional Grupo 1

Pos	Equipos		Pts
1		San Martín Tucumán	44
2		Def. Belgrano	41
3		Atlanta	38
4		Estudiantes Río Cuarto	37
5		CA Estudiantes	36
6		Sarmiento	34
7		Dep. Riestra	33
8		Temperley	32
9		Deportivo Morón	32
10		Ferro Carril Oeste	31
11		Platense	30
12		Argentino Agropecuario	29
13		Tigre	28
14		Atletico Rafaela	28
15		San Martín San Juan	28
16		Belgrano	27
17		Gimnasia Mendoza	27
18		Villa Dálmine	26
19		Alvarado	26
20		Instituto	25
21		Guillermo Brown	25
22		Indep. Rivadavia	24
23		Brown Adrogue	24
24		Quilmes	24
25		Chacarita Juniors	24
26		Almagro	23
27		All Boys	22
28		Barracas Central	21
29		Dep. Santamarina	20
30		Gimnasia Jujuy	19
31		Atlético Mitre SdE	17
32		Nueva Chicago	17

	Playoff Título : San Martín Tucumán
	Playoff Ascenso : Def. Belgrano, Atlanta, Estudiantes Río Cuarto
	Descenso : Belgrano

RIVALES EN Copa Argentina

RIVALES EN Primera Nacional

USO DE MEMORIA

8,091,008 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1960
Total Execution Time	0.1971

CADENA URL

/historico/Estudiantes-Ca/2020

GET DATOS

$_GET['/historico/Estudiantes-Ca/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0055	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-Ca' AND l.year = 2020 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.0020	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=11817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=11817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=11817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=11817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=11817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=11817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027	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 = 50509
0.0025	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 = 66511
0.0025	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 = 66512
0.0025	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 = 53563
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11817 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11817 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (48965,49226,106444,182233,229380) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '11817' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '11817' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 53563 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 50509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038	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=11817 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (66512,53563,49506,44805) 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 = 66512 AND teamId = 11817
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 44805 AND teamId = 11817
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 53563 AND teamId = 11817
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 11817
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* `tables2020` 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 = 50509 AND t.round = 21 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025	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 = '11817' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11817' and rp.type = 4
0.0020	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 = '11817' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046	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 events2020 e ON e.player_id = p.id AND e.league_id = 50509 WHERE rp.league_id = 50509 AND rp.teamId = 11817 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 events2020 e ON e.player_id = p.id AND e.league_id = 50509 WHERE rp.league_id = 50509 AND rp.teamId = 11817 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 events2020 e ON e.player_id = p.id AND e.league_id = 50509 WHERE rp.league_id = 50509 AND rp.teamId = 11817 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 11817 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId FROM* `tables2020` 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 = 50509 AND t.round = 21 ORDER BY team.conference ASC,t.position 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* `tables2020` 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 = 66511 AND t.round = 7 ORDER BY team.conference ASC,t.position 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* `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 = 44805 AND t.round = 38 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* `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 = 39648 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 33795 AND t.round = 38 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* `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 = 20211 AND t.round = 19 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* `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 = 3900 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* `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 = 2515 AND t.round = 42 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* `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 = 2000 AND t.round = 42 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 = 1657 AND t.round = 42 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* `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 = 13429 AND t.round = 42 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* `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 = 13428 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* `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 = 13427 AND t.round = 42 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* `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 = 13426 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 27677 AND t.round = 21 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* `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 = 27678 AND t.round = 21 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* `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 = 27679 AND t.round = 1 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* `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 = 27684 AND t.round = 34 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* `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 = 27691 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 50509 ORDER BY nameShow LIMIT 100

CA Estudiantes

CA Estudiantes

Selecciona un equipo

Competiciones que juega

Primera Nacional Grupo 1

RIVALES EN Copa Argentina

RIVALES EN Primera Nacional