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

Vasco da Gama

Entrenador: Ramón Díaz

Temporada 2013/2014

Información sobre Vasco da Gama

Enviar Datos

Información

Nombre del equipo Vasco da Gama
Nombre completo Club de Regatas Vasco da Gama
Nombre corto VAS
País Brasil
Ciudad Rio de Janeiro, Rio de Janeiro
Entrenador Ramón Díaz
URL del equipo en RF //m.resultados-futbol.com/Vasco-Da-Gama

Otros Datos

Año de Fundación 1898
Patrocinador BMG
Patrocinador Secundario AOC, NetBet
Marca de Ropa Kappa

Internet

Sitio Web https://vasco.com.br/
Correo electrónico contato@crvascodagama.com
Twitter principal @vascodagama

Información sobre el estadio

Nombre del estadio Estádio Vasco da Gama (São Januário)
Capacidad 21880
Dirección Rua Gal Almério de Moura 131, Bairro Vasco da Gama 20921-060 Rio de Janeiro
Teléfono +55 (21) 2176 7373
Fax +55 (21) 2580 0488
Año de construcción 1927
Tamaño 105X65

Histórico de participación

Liga Brasileña

95 veces

(2024, 2023, 2020, 2019, 2018, 2017, 2015, 2013, 2012, 2011, 2010, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 2000, 1999, 1998, 1997, 1997, 1997, 1996, 1995, 1995, 1994, 1994, 1994, 1993, 1992, 1992, 1991, 1990, 1990, 1989, 1989, 1989, 1988, 1988, 1988, 1987, 1987, 1986, 1986, 1986, 1985, 1985, 1985, 1985, 1984, 1984, 1984, 1984, 1983, 1983, 1983, 1983, 1982, 1982, 1982, 1981, 1981, 1981, 1980, 1980, 1980, 1979, 1979, 1979, 1978, 1978, 1978, 1978, 1977, 1977, 1977, 1976, 1976, 1976, 1975, 1975, 1974, 1974, 1974, 1974, 1973, 1973, 1972, 1972, 1971, 1971)

Carioca

63 veces

(2024, 2024, 2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2019, 2019, 2019, 2018, 2018, 2018, 2018, 2017, 2017, 2017, 2017, 2016, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2013, 2013, 2012, 2012, 2012, 2011, 2011, 2011, 2010, 2010, 2010, 2009, 2009, 2009, 2008, 2008, 2008, 2007, 2007, 2007, 2006, 2006, 2005, 2005, 2005, 2004, 2004, 2003, 2003, 2000, 2000, 2000)

Copa Brasil

33 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1989)

Copa Libertadores Grupo 5

13 veces

(2018, 2012, 2012, 2001, 2001, 1999, 1998, 1998, 1990, 1990, 1985, 1980, 1975)

Conmebol Sudamericana

7 veces

(2020, 2018, 2011, 2008, 2007, 2006, 2003)

Trofeo Ramón de Carranza

6 veces

(2000, 1990, 1989, 1988, 1978, 1968)

Partidos Amistosos

6 veces

(2024, 2023, 2020, 2019, 2017, 1994)

Fase Previa Copa Libertadores Grupo 3

2 veces

(2018, 2018)

Torneo Rio - Rio-São Paulo Grupo 0

2 veces

(2000, 2000)

Supercopa Libertadores Grupo 3

2 veces

(1997, 1997)

Partidos del Vasco da Gama

Ir al LIVESCORE

Copa Brasil »

03 Sep 14	Finalizado	ABC	2 - 1	Vasco da Gama	0
27 Ago 14	Finalizado	Vasco da Gama	1 - 1	ABC	2
31 Jul 14	Finalizado	Vasco da Gama	2 - 1	Ponte Preta	0
24 Jul 14	Finalizado	Ponte Preta	0 - 2	Vasco da Gama	0
08 May 14	Finalizado	Vasco da Gama	1 - 1	Treze	0
01 May 14	Finalizado	Treze	1 - 2	Vasco da Gama	0
17 Abr 14	Finalizado	Vasco da Gama	1 - 0	Resende	0
03 Abr 14	Finalizado	Resende	0 - 0	Vasco da Gama	0

Serie B - Brasil »

29 Nov 14	Finalizado	Avaí	1 - 0	Vasco da Gama	0
22 Nov 14	Finalizado	Vasco da Gama	1 - 1	Icasa	0
19 Nov 14	Finalizado	Vasco da Gama	3 - 1	Vila Nova	2
15 Nov 14	Finalizado	Ceará	2 - 0	Vasco da Gama	0
08 Nov 14	Finalizado	Vasco da Gama	1 - 0	ABC	0
01 Nov 14	Finalizado	Paraná	1 - 1	Vasco da Gama	2
25 Oct 14	Finalizado	Vasco da Gama	1 - 1	Ponte Preta	1
21 Oct 14	Finalizado	América RN	2 - 0	Vasco da Gama	2
18 Oct 14	Finalizado	Santa Cruz	1 - 0	Vasco da Gama	0
11 Oct 14	Finalizado	Vasco da Gama	2 - 0	Boa EC	1
08 Oct 14	Finalizado	Portuguesa	0 - 1	Vasco da Gama	2
04 Oct 14	Finalizado	Vasco da Gama	2 - 2	RB Bragantino	2
27 Sep 14	Finalizado	Vasco da Gama	2 - 0	Joinville	0
24 Sep 14	Finalizado	Sampaio Correa	2 - 2	Vasco da Gama	0
20 Sep 14	Finalizado	Vasco da Gama	2 - 1	Náutico	0
17 Sep 14	Finalizado	Oeste	1 - 1	Vasco da Gama	0
13 Sep 14	Finalizado	Atlético GO	1 - 1	Vasco da Gama	0
10 Sep 14	Finalizado	Vasco da Gama	2 - 0	Luverdense	0
06 Sep 14	Finalizado	América Mineiro	2 - 3	Vasco da Gama	0
30 Ago 14	Finalizado	Vasco da Gama	0 - 5	Avaí	0
23 Ago 14	Finalizado	Icasa	1 - 1	Vasco da Gama	0
20 Ago 14	Finalizado	Vila Nova	2 - 1	Vasco da Gama	0
16 Ago 14	Finalizado	Vasco da Gama	2 - 0	Ceará	0
13 Ago 14	Finalizado	Náutico	0 - 1	Vasco da Gama	1
09 Ago 14	Finalizado	ABC	1 - 2	Vasco da Gama	1
02 Ago 14	Finalizado	Vasco da Gama	1 - 0	Paraná	1
26 Jul 14	Finalizado	Ponte Preta	0 - 0	Vasco da Gama	0
19 Jul 14	Finalizado	Vasco da Gama	1 - 1	América RN	0
16 Jul 14	Finalizado	Vasco da Gama	4 - 1	Santa Cruz	0
04 Jun 14	Finalizado	Boa EC	0 - 2	Vasco da Gama	0
31 May 14	Finalizado	Vasco da Gama	1 - 1	Portuguesa	0
28 May 14	Finalizado	RB Bragantino	1 - 1	Vasco da Gama	0
24 May 14	Finalizado	Joinville	0 - 0	Vasco da Gama	0
21 May 14	Finalizado	Vasco da Gama	1 - 1	Sampaio Correa	0
10 May 14	Finalizado	Vasco da Gama	2 - 0	Oeste	1
03 May 14	Finalizado	Vasco da Gama	3 - 0	Atlético GO	0
26 Abr 14	Finalizado	Luverdense	2 - 1	Vasco da Gama	0
19 Abr 14	Finalizado	Vasco da Gama	1 - 1	América Mineiro	0

Carioca »

13 Abr 14	Finalizado	Flamengo	1 - 1	Vasco da Gama
06 Abr 14	Finalizado	Vasco da Gama	1 - 1	Flamengo
30 Mar 14	Finalizado	Fluminense	0 - 1	Vasco da Gama
28 Mar 14	Finalizado	Vasco da Gama	1 - 1	Fluminense
23 Mar 14	Finalizado	Vasco da Gama	4 - 0	Duque de Caxias
16 Mar 14	Finalizado	Fluminense	1 - 1	Vasco da Gama
08 Mar 14	Finalizado	Vasco da Gama	1 - 1	Bonsucesso
05 Mar 14	Finalizado	Vasco da Gama	2 - 0	Resende
27 Feb 14	Finalizado	Madureira RJ	1 - 3	Vasco da Gama
23 Feb 14	Finalizado	Vasco da Gama	1 - 2	Cabofriense
19 Feb 14	Finalizado	Bangu	0 - 2	Vasco da Gama
16 Feb 14	Finalizado	Vasco da Gama	1 - 2	Flamengo
09 Feb 14	Finalizado	Nova Iguaçu	1 - 1	Vasco da Gama
06 Feb 14	Finalizado	Volta Redonda	1 - 2	Vasco da Gama
02 Feb 14	Finalizado	Vasco da Gama	1 - 0	Botafogo
29 Ene 14	Finalizado	Audax Rio	0 - 4	Vasco da Gama
26 Ene 14	Finalizado	Vasco da Gama	6 - 0	Friburguense
22 Ene 14	Finalizado	Macaé Esporte	1 - 1	Vasco da Gama
18 Ene 14	Finalizado	Vasco da Gama	1 - 1	Boavista SC

Estadísticas

GOLEADORES

Douglas10

AMARILLAS

Douglas11

ROJAS

Plantilla del Vasco da Gama Temporada 2013/2014

		Edad	Altura	Peso
Portero
	Diogo Silva	37	192	81	-	-	2
	Jordi	30	192	92	-	-	-
	M. Silva	41	187	82	-	-	4
	Rafel Copetti	33	193	87	-	-	-
Defensa
	Anderson Salles	36	178	73	-	-	1
	André Rocha	39	184	72	-	-	1
	Carlos César	37	174	70	2	-	2
	Cris	46	183	77	-	-	-
	Diego Renan	34	172	73	-	-	6
	Douglas	34	190	84	-	-	-
	Douglas Silva	40	186	80	5	-	4
	Henrique	30	173	71	-	-	1
	Jomar	31	185	74	-	-	-
	Luan Garcia	30	186	79	-	1	2
	Marlon	38	182	78	2	-	5
	Rafael Vaz	35	188	83	-	-	-
	Rodrigo	43	182	77	4	-	7
Centrocampista
	D. Barbosa	28	183	73	-	-	-
	Dakson	36	180	75	4	-	5
	Douglas	42	176	66	10	-	11
	E. Aranda	39	175	72	-	-	6
	Fabrício	41	178	76	2	-	6
	Fellipe Bastos	34	178	76	-	-	-
	Guilherme Biteco	30	173	70	1	-	2
	Jhon Cley	30	183	78	1	-	1
	Lorran	28	170	65	-	-	2
	Lucas Crispim	29	178	72	2	-	1
	M. Rodríguez	33	180	69	2	-	-
	P. Guiñazú	45	172	71	-	-	11
	Yago	30	174	70	1	-	-
Delantero
	Edmilson	41	183	87	3	-	3
	Kléber Gladiador	40	173	75	5	-	5
	Marcos Do Sul	30	167	60	-	-	-
	Pedro Ken	37	181	80	-	-	4
	Rafael Silva	33	176	68	1	-	2
	Reginaldo	40	175	72	1	-	-
	Thalles	28	185	77	3	-	3
	William Barbio	31	176	72	-	-	-

	Fabricio	-	-	-	-	-	-
	Kleber	-	-	-	-	-	-

Noticias del Vasco da Gama

Ver últimas noticias

El Vasco se lleva el partido en la presentación de Ronaldinho

BeSoccer - Lunes, 20 Julio 2015

1 334

El Vasco da Gama, que atraviesa un difícil momento y ocupa las últimas posiciones de la liga brasileña, se impuso hoy por 1-2 al Fluminense, le impidió alcanzar el primer lugar del torneo y aguó la fiesta preparada para Ronaldinho Gaúcho.

Gremio vence a Vasco y asciende provisionalmente al segundo lugar del fútbol en Brasil

BeSoccer - Domingo, 12 Julio 2015

0 208

El Gremio venció hoy por 2-0 al Vasco da Gama en partido anticipado por la decimotercera jornada del Campeonato Brasileño y ascendió provisionalmente al segundo lugar en la clasificación de la Liga.

El Sao Paulo destroza al Vasco da Gama

BeSoccer - Jueves, 09 Julio 2015

0 539

El partido entre el Sao Paulo y el Vasco da Gama acabó con un contundente 4-0 a favor del equipo paulista, que lleva ya 21 puntos y se encuentra en la sexta posición en la Liga Brasileña.

El primo de Messi también la sabe romper

BeSoccer - Jueves, 02 Julio 2015

1 1.265

Emanuel Biancucchi, primo de Leo Messi, demuestra que lleva en la sangre los genes del argentino y clave este golazo con Vasco da Gama.

El Vasco da Gama anuncia novedades y confirma una negociación con Ronaldinho Gaúcho

BeSoccer - Martes, 23 Junio 2015

1 1.403

El presidente del Vasco da Gama, Eurico Miranda, anunció hoy la contratación del técnico Celso Roth, así como de los jugadores Leo Moura y el argentino Germán Herrera, y confirmó que el club carioca está negociando con Ronaldinho Gaucho, quien rescindió el contrato que le unía al Querétaro mexicano.

Ver más noticias del equipo»

Competiciones que juega

Serie B - Brasil

Pos	Equipos		Pts
1		Joinville	70
2		Ponte Preta	69
3		Vasco da Gama	63
4		Avaí	62
5		América Mineiro	61
6		Boa EC	59
7		Atlético GO	59
8		Ceará	57
9		Santa Cruz	55
10		Sampaio Correa	53
11		Paraná	51
12		Luverdense	50
13		Náutico	50
14		ABC	48
15		Oeste	48
16		RB Bragantino	46
17		América RN	43
18		Icasa	43
19		Vila Nova	32
20		Portuguesa	25

RIVALES EN Carioca

RIVALES EN Copa Brasil

RIVALES EN Serie B - Brasil

USO DE MEMORIA

6,637,128 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1685
Total Execution Time	0.1704

CADENA URL

/Vasco-Da-Gama/2014

GET DATOS

$_GET['/Vasco-Da-Gama/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0039	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 = 3613
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 = 3636
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 = 3479
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 = 12912
0.0039	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 = '4514' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 3479 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 3636 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 = 3613 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 4514 or c.datateam2 = 4514) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0046	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 4514 or c.datateam2 = 4514) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0040	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 4514 or c.datateam2 = 4514) AND l.year = 2014)
0.0045	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=4514 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (23371,13700,11071,3613) 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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 11071 AND teamId = 4514
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 3613 AND teamId = 4514
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 23371 AND teamId = 4514
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 13700 AND teamId = 4514
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 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 = 3613 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0036	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 events2014 e ON e.player_id = p.id AND e.league_id = 3613 WHERE rp.league_id = 3613 AND rp.teamId = 4514 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.0034	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 events2014 e ON e.player_id = p.id AND e.league_id = 3613 WHERE rp.league_id = 3613 AND rp.teamId = 4514 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 events2014 e ON e.player_id = p.id AND e.league_id = 3613 WHERE rp.league_id = 3613 AND rp.teamId = 4514 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 4514 AND rp.league_id = 3613 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=67558 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=67558
0.0026	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=67558 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=67558 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=67558 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=67558 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=67558 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Vasco da Gama

Información sobre Vasco da Gama

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Vasco da Gama

Estadísticas

Plantilla del Vasco da Gama Temporada 2013/2014

Noticias del Vasco da Gama

Vasco da Gama

Selecciona un equipo

Competiciones que juega

RIVALES EN Carioca

RIVALES EN Copa Brasil

RIVALES EN Serie B - Brasil