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

River Plate

Entrenador: Martín Demichelis

Temporada 1976/1977

TEMPORADA 1976/1977

LIGA PROFESIONAL ARGENTINA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	River Plate	44	83	46	88
2	Independient	44	82	47	84
3	Boca Juniors	44	67	45	75
4	Vélez	44	65	48	75
5	Colón	44	74	57	73
6	Rosario	44	60	35	71
7	Newell's	44	69	58	63
8	CA Huracán	44	56	59	58
9	Argentinos	44	61	61	57
10	Gimnasia	44	75	76	55
11	Estudiantes	44	60	61	55
12	San Lorenzo	44	46	56	55
13	Atlanta	44	52	65	55
14	Unión Santa	44	57	55	54
15	Banfield	44	48	50	54
16	Racing Club	44	43	47	54
17	Chacarita	44	53	62	52
18	Quilmes	44	51	64	52
19	Lanús	45	43	54	50
20	All Boys	44	50	67	50
21	Platense	45	48	66	49
22	Temperley	44	56	75	49
23	Ferro Carril	44	50	95	28

TEMPORADA 1975/1976

LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	River Plate	1	4	1	3
2	CA Huracán	1	1	4	0

TEMPORADA 1974/1975

LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	River Plate	38	72	38	78
2	Boca Juniors	38	80	40	72
3	CA Huracán	38	73	46	72
4	Unión Santa	38	65	42	69
5	Estudiantes	38	68	51	65
6	Colón	38	60	48	63
7	Rosario	38	75	51	56
8	Ferro Carril	38	61	58	54
9	Vélez	38	50	47	52
10	Newell's	38	47	43	49
11	Atlanta	38	62	69	46
12	Independient	38	49	55	45
13	San Lorenzo	38	56	63	45
14	Gimnasia	38	55	71	45
15	Chacarita	38	47	72	43
16	Racing Club	38	60	91	38
17	All Boys	38	43	65	37
18	Banfield	38	57	73	35
19	Argentinos	38	46	70	33
20	Temperley	38	44	77	32

TEMPORADA 1973/1974

LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Boca Juniors	18	46	10	47
2	Rosario	18	36	8	43
3	Banfield	18	42	25	31
4	Estudiantes	18	25	20	28
5	Belgrano	18	30	21	27
6	Sportivo	18	32	35	20
7	Central	18	22	31	19
8	All Boys	18	20	36	11
9	Puerto	18	14	75	6
10	Talleres	18	25	12	35
11	Gimnasia	18	29	22	30
12	Newell's	18	27	20	29
13	Altos Hornos	18	30	27	28
14	River Plate	18	33	20	26
15	Argentinos	18	29	31	24
16	Colón	18	20	22	18
17	Jorge	18	9	18	15
18	Huracán	18	12	48	7

TEMPORADA 1972/1973

LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rosario	3	6	3	7
2	River Plate	3	6	7	4
3	Atlanta	3	3	4	2
4	San Lorenzo	3	3	4	2

TEMPORADA 1971/1972

LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	San Lorenzo	13	29	6	33
2	River Plate	13	50	23	32
3	Martín	26	37	46	32
4	Vélez	13	31	19	26
5	Atlanta	13	31	15	22
6	Rosario	13	28	18	19
7	Independient	13	24	20	17
8	Lorenzo	13	24	28	17
9	Lanús	13	17	23	14
10	Gimnasia	14	15	26	13
11	Club	13	11	36	5
12	Independient	13	10	46	3
13	Boca Juniors	13	31	15	32
14	Colón	13	21	16	26
15	Argentinos	13	26	16	24
16	CA Huracán	12	24	19	19
17	Racing Club	13	20	18	19
18	Banfield	12	23	24	18
19	Belgrano	13	19	18	17
20	Ferro Carril	13	20	20	16
21	Sportivo	13	15	25	16
22	Chacarita	12	16	18	11
23	Gimnasia	12	16	21	11
24	Estudiantes	13	12	25	10
25	Newell's	12	17	26	7

TEMPORADA 1970/1971

LIGA PROFESIONAL ARGENTINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Independient	14	31	13	34
2	Newell's	14	37	10	32
3	Belgrano	14	28	13	30
4	River Plate	14	26	13	29
5	Argentinos	14	22	22	22
6	Ferro Carril	14	22	20	18
7	Banfield	14	23	22	17
8	Kimberley	14	22	21	17
9	Martín	14	20	20	15
10	Gimnasia	14	22	30	12
11	CA Huracán	14	19	27	12
12	Don Orione	14	16	34	12
13	Juventud	14	23	30	11
14	Huracán	14	11	55	4
15	Rosario	14	27	13	30
16	San Lorenzo	14	37	19	28
17	Gimnasia	14	28	21	26
18	Boca Juniors	13	33	17	25
19	Atlanta	14	25	17	22
20	Vélez	14	21	20	21
21	Chacarita	14	16	20	17
22	Estudiantes	14	22	19	16
23	Racing Club	14	20	21	16
24	Martín	14	22	30	16
25	Colón	14	21	26	15
26	Guaraní	14	18	26	13
27	Central	14	17	33	12
28	Huracán	13	7	24	10

TEMPORADA 1969/1970

LIGA PROFESIONAL ARGENTINA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Martín Juan	20	27	47	13
2	Gimnasia	20	46	31	27
3	Chacarita	19	24	19	27
4	River Plate	20	30	20	26
5	San Lorenzo	20	45	26	24
6	Gimnasia	20	33	32	23
7	Racing Club	20	35	30	17
8	Newell's	20	29	36	15
9	Talleres	20	27	42	15
10	Martín	19	19	36	14
11	Platense	20	21	46	10
12	Rosario	20	42	26	29
13	Boca Juniors	20	36	20	29
14	Vélez	20	39	24	25
15	Independient	20	37	35	21
16	Estudiantes	20	31	22	20
17	Banfield	19	23	28	16
18	Atlanta	20	17	22	16
19	Kimberley	19	32	35	15
20	Gimnasia	20	27	43	14

TEMPORADA 1968/1969

LIGA PROFESIONAL ARGENTINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chacarita	22	33	26	43
2	Boca Juniors	22	34	11	42
3	Vélez	22	36	24	35
4	Independient	22	28	25	35
5	San Lorenzo	22	37	27	33
6	Gimnasia	22	28	27	33
7	Lanús	22	37	34	31
8	Rosario	22	18	24	27
9	Banfield	22	24	36	26
10	Colón	22	22	46	18
11	Atlanta	22	18	37	11
12	Racing Club	22	45	16	49
13	River Plate	22	35	21	43
14	Estudiantes	22	33	24	38
15	CA Huracán	22	38	29	32
16	Platense	22	33	32	31
17	Quilmes	22	28	34	30
18	Unión Santa	22	25	26	26
19	Newell's	22	24	28	26
20	Deportivo	22	16	38	18
21	Argentinos	22	17	29	15
22	Los Andes	22	24	39	13

Competiciones que juega

Liga Profesional Argentina Grupo 3

Pos	Equipos		Pts
1		Talleres Córdoba	29
2		Racing Club	23
3		River Plate	22
4		Vélez Sarsfield	21
5		Platense	19
6		Sarmiento	16
7		Colón	15
8		Gimnasia Jujuy	11

RIVALES EN Copa Libertadore.

RIVALES EN Liga Profesional.

USO DE MEMORIA

6,585,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1941
Total Execution Time	0.1953

CADENA URL

/historico/Ca-River-Plate/1977

GET DATOS

$_GET['/historico/Ca-River-Plate/1977']

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0041	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 = 'Ca-River-Plate' AND l.year = 1977 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.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=593 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=593 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=593 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=593 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 26580
0.0026	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 = 26582
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 = 11442
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=593 AND type_rel = 2
0.0074	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 593 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0036	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 (1312626,1312473,1312204,1311981,1311966) ORDER BY n.cover_points DESC, update_date DESC
0.0128	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 = '593' ORDER BY l.year DESC,cat.coefficient DESC
0.0055	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 = '593' AND l.year = 1977 ORDER BY l.year DESC,cat.coefficient DESC
0.0044	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 = '593' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 11442 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 = 26582 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0049	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=593 AND l.year in (1976,1977,1978) 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 (73114,26587,11569) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 26587 AND teamId = 593
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 11569 AND teamId = 593
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 73114 AND teamId = 593
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 FROM* `tables1977` 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 = 26580 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026	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 = '593' 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 = '593' and rp.type = 4
0.0026	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 = '593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '593' and rp.type = 4
0.0020	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 events1977 e ON e.player_id = p.id AND e.league_id = 26580 WHERE rp.league_id = 26580 AND rp.teamId = 593 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.0020	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 events1977 e ON e.player_id = p.id AND e.league_id = 26580 WHERE rp.league_id = 26580 AND rp.teamId = 593 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 events1977 e ON e.player_id = p.id AND e.league_id = 26580 WHERE rp.league_id = 26580 AND rp.teamId = 593 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0048	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 = 593 AND l.year <= 1977 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables1977` 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 = 26580 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* `tables1977` 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 = 26582 AND t.round = 47 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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* `tables1976` 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 = 26584 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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* `tables1976` 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 = 26586 AND t.round = 1 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* `tables1975` 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 = 26592 AND t.round = 7 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* `tables1975` 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 = 26588 AND t.round = 16 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* `tables1975` 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 = 26591 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* `tables1974` 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 = 26598 AND t.round = 19 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* `tables1974` 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 = 26600 AND t.round = 18 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* `tables1973` 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 = 26613 AND t.round = 34 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* `tables1973` 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 = 26615 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1973` 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 = 26621 AND t.round = 3 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* `tables1972` 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 = 26627 AND t.round = 34 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* `tables1972` 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 = 26633 AND t.round = 13 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* `tables1971` 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 = 26672 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* `tables1971` 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 = 26676 AND t.round = 14 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* `tables1970` 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 = 26704 AND t.round = 21 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* `tables1970` 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 = 26713 AND t.round = 20 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* `tables1969` 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 = 26751 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* `tables1969` 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 = 26756 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 26580 ORDER BY nameShow LIMIT 100


	¿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

River Plate

River Plate

Selecciona un equipo

Competiciones que juega

Liga Profesional Argentina Grupo 3

RIVALES EN Copa Libertadore.

RIVALES EN Liga Profesional.