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 1982/1983

TEMPORADA 1982/1983

LIGA PROFESIONAL ARGENTINA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	River Plate	6	5	2	11
2	Platense	6	8	13	9
3	Ferro Carril	6	7	6	8
4	CA Huracán	6	6	8	7
5	Unión Santa	6	7	4	6
6	San Lorenzo	6	2	2	6

TEMPORADA 1981/1982

LIGA PROFESIONAL ARGENTINA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Quilmes	16	32	27	28
2	Indep.	16	28	30	28
3	Instituto	16	28	22	25
4	Newell's	16	29	17	23
5	Sarmiento	16	27	27	19
6	River Plate	16	20	27	18
7	Gimnasia	16	23	26	17
8	Nueva	16	18	28	13
9	Estudiantes	16	22	10	31
10	Talleres	16	36	22	30
11	Rosario	16	35	16	27
12	Boca Juniors	16	26	18	25
13	Gimnasia	16	25	20	25
14	Central	16	17	28	17
15	CA Huracán	16	16	22	15
16	Mariano	16	11	53	2

TEMPORADA 1980/1981

LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Boca Juniors	34	60	27	50
2	Ferro Carril	34	50	20	49
3	Newell's	34	58	44	39
4	River Plate	34	62	50	39
5	Racing Club	33	46	29	38
6	Independient	34	43	35	37
7	Rosario	34	36	39	34
8	CA Huracán	34	41	50	33
9	Instituto	34	56	54	32
10	Unión Santa	34	39	37	32
11	Vélez	34	39	48	31
12	Platense	34	39	49	31
13	Sarmiento	34	46	52	30
14	Talleres	33	36	44	29
15	Argentinos	34	44	57	29
16	Estudiantes	33	34	43	28
17	San Lorenzo	33	30	48	26
18	Colón	34	26	59	21

TEMPORADA 1979/1980

LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	River Plate	36	64	33	51
2	Argentinos	36	57	48	42
3	Platense	36	36	30	41
4	Talleres	35	55	43	39
5	Unión Santa	36	49	44	39
6	Newell's	36	54	35	38
7	Boca Juniors	36	43	47	38
8	CA Huracán	36	58	50	37
9	Rosario	36	43	41	37
10	Racing Club	36	35	34	36
11	Estudiantes	35	34	40	36
12	Colón	36	41	49	36
13	Ferro Carril	36	55	50	35
14	Independient	36	45	49	35
15	Vélez	36	35	42	35
16	San Lorenzo	36	39	43	33
17	Quilmes	36	37	44	30
18	All Boys	36	29	56	23
19	Tigre	36	38	69	21

TEMPORADA 1978/1979

LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Vélez	19	31	20	36
2	River Plate	18	28	19	33
3	Argentinos	19	34	30	33
4	Newell's	18	27	14	30
5	Racing Club	18	31	20	30
6	Unión Santa	18	23	20	25
7	Quilmes	18	23	20	23
8	CA Huracán	18	24	31	22
9	Gimnasia	18	11	28	11
10	Platense	18	15	45	8

TEMPORADA 1977/1978

LIGA PROFESIONAL ARGENTINA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Quilmes	40	53	41	76
2	Boca Juniors	40	58	45	73
3	Unión Santa	40	58	36	72
4	San Lorenzo	40	47	41	64
5	Argentinos	40	66	52	63
6	River Plate	40	59	47	61
7	Newell's	40	52	36	58
8	Independient	40	69	54	58
9	Racing Club	40	58	46	57
10	Rosario	40	43	32	55
11	Colón	40	60	59	53
12	Gimnasia	40	41	44	51
13	Estudiantes	40	59	51	49
14	Atlanta	40	49	56	47
15	CA Huracán	40	47	46	46
16	Vélez	40	35	39	45
17	Chacarita	40	39	69	42
18	All Boys	40	34	58	41
19	Platense	40	41	63	38
20	Estudiantes	40	43	73	37
21	Banfield	40	43	66	36

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 5
Equipo		PJ	GF	GC	Puntos
1	River Plate	7	13	8	17
2	Estudiantes	7	8	2	16
3	San Lorenzo	7	18	11	12
4	Gimnasia	7	10	13	8
5	Rosario	7	8	9	6
6	Talleres	7	9	11	6
7	Atl.	7	7	13	6
8	Temperley	7	9	15	4

Competiciones que juega

Liga Profesional Argentina Grupo 7

Pos	Equipos		Pts
1		Loma Negra	11
2		Nueva Chicago	11
3		River Plate	8
4		Andino	3

RIVALES EN Liga Profesional.

USO DE MEMORIA

6,318,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1636
Total Execution Time	0.1648

CADENA URL

/historico/Ca-River-Plate/1983

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0060	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 = 1983 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=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.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.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 = 26534
0.0022	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 = 26537
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 = 26616
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 = 26683
0.0065	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 = 1983 ORDER BY l.year DESC,cat.coefficient DESC
0.0062	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 = 26534 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0055	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 (1982,1983,1984) 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 (56521,26683,11537) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 26683 AND teamId = 593
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 11537 AND teamId = 593
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 56521 AND teamId = 593
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 FROM* `tables1983` 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 = 26534 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events1983 e ON e.player_id = p.id AND e.league_id = 26534 WHERE rp.league_id = 26534 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.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 events1983 e ON e.player_id = p.id AND e.league_id = 26534 WHERE rp.league_id = 26534 AND rp.teamId = 593 AND (e.action = 4 or e.action = 5) 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 events1983 e ON e.player_id = p.id AND e.league_id = 26534 WHERE rp.league_id = 26534 AND rp.teamId = 593 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053	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 <= 1983 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables1983` 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 = 26683 AND t.round = 38 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* `tables1983` 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 = 26534 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* `tables1983` 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 = 26537 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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* `tables1982` 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 = 26673 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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* `tables1982` 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 = 26545 AND t.round = 16 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* `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.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* `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 = 26554 AND t.round = 34 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* `tables1980` 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 = 26565 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `tables1980` 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 = 26566 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* `tables1979` 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 = 26569 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* `tables1979` 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 = 26593 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* `tables1978` 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 = 26575 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* `tables1978` 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 = 26576 AND t.round = 42 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* `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.0041	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.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* `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.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* `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.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* `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.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* `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.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* `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.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 = 26534 ORDER BY nameShow LIMIT 100
0.0023	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 675 AND l.group_code = 7 ORDER BY l.year DESC


	¿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 7

RIVALES EN Liga Profesional.