03 Dic 06	Finalizado	Fortaleza EC	1 - 0	Grêmio
26 Nov 06	Finalizado	Grêmio	3 - 0	Flamengo
18 Nov 06	Finalizado	Grêmio	3 - 1	Santa Cruz
12 Nov 06	Finalizado	Athletico Paranaense	2 - 3	Grêmio
08 Nov 06	Finalizado	EC Juventude	1 - 2	Grêmio
05 Nov 06	Finalizado	Grêmio	0 - 1	Internacional
02 Nov 06	Finalizado	Grêmio	1 - 2	Figueirense
27 Oct 06	Finalizado	Fluminense	1 - 2	Grêmio
22 Oct 06	Finalizado	Grêmio	1 - 1	São Paulo
14 Oct 06	Finalizado	São Caetano	0 - 2	Grêmio
08 Oct 06	Finalizado	Santos FC	1 - 0	Grêmio
05 Oct 06	Finalizado	Grêmio	2 - 1	Palmeiras
24 Sep 06	Finalizado	Goiás EC	4 - 0	Grêmio
20 Sep 06	Finalizado	Grêmio	4 - 0	Ponte Preta
17 Sep 06	Finalizado	Grêmio	4 - 0	Botafogo
09 Sep 06	Finalizado	Vasco da Gama	1 - 1	Grêmio
03 Sep 06	Finalizado	Grêmio	2 - 1	Paraná
31 Ago 06	Finalizado	Grêmio	2 - 1	Cruzeiro
27 Ago 06	Finalizado	Corinthians	0 - 2	Grêmio
25 Ago 06	Finalizado	Grêmio	4 - 1	Fortaleza EC
19 Ago 06	Finalizado	Flamengo	1 - 0	Grêmio
17 Ago 06	Finalizado	Santa Cruz	2 - 4	Grêmio
13 Ago 06	Finalizado	Grêmio	2 - 0	Athletico Paranaense
05 Ago 06	Finalizado	Grêmio	1 - 0	EC Juventude
30 Jul 06	Finalizado	Internacional	0 - 0	Grêmio
22 Jul 06	Finalizado	Figueirense	2 - 0	Grêmio
16 Jul 06	Finalizado	Grêmio	4 - 4	Fluminense
13 Jul 06	Finalizado	São Paulo	2 - 1	Grêmio
03 Jun 06	Finalizado	Grêmio	1 - 1	São Caetano
01 Jun 06	Finalizado	Grêmio	1 - 0	Santos FC
28 May 06	Finalizado	Palmeiras	0 - 1	Grêmio
26 May 06	Finalizado	Grêmio	2 - 0	Goiás EC
21 May 06	Finalizado	Ponte Preta	1 - 1	Grêmio
13 May 06	Finalizado	Botafogo	2 - 2	Grêmio
07 May 06	Finalizado	Grêmio	1 - 2	Vasco da Gama
30 Abr 06	Finalizado	Paraná	5 - 2	Grêmio
23 Abr 06	Finalizado	Cruzeiro	3 - 1	Grêmio
16 Abr 06	Finalizado	Grêmio	2 - 0	Corinthians

Copa Brasil »

23 Mar 06	Finalizado	Grêmio	1 - 0	15 Novembro
15 Mar 06	Finalizado	15 Novembro	1 - 0	Grêmio
08 Mar 06	Finalizado	Grêmio	4 - 0	Piauí
22 Feb 06	Finalizado	Piauí	1 - 2	Grêmio

Gaucho 1 »

09 Abr 06		Internacional	-	Grêmio
01 Abr 06	Finalizado	Grêmio	0 - 0	Internacional
26 Mar 06	Finalizado	Grêmio	2 - 0	Veranópolis
19 Mar 06	Finalizado	Santa Cruz RS	1 - 1	Grêmio
11 Mar 06	Finalizado	Grêmio	2 - 2	EC Juventude
05 Mar 06	Finalizado	EC Juventude	1 - 2	Grêmio
02 Mar 06	Finalizado	Grêmio	3 - 0	Santa Cruz RS
25 Feb 06	Finalizado	Veranópolis	2 - 3	Grêmio
19 Feb 06	Finalizado	Grêmio	3 - 1	Veranópolis
12 Feb 06	Finalizado	Grêmio	2 - 1	Santa Cruz RS
08 Feb 06	Finalizado	Grêmio	1 - 0	São Luiz
05 Feb 06	Finalizado	Esportivo BG	2 - 2	Grêmio
01 Feb 06	Finalizado	Grêmio	1 - 2	Farroupilha
29 Ene 06	Finalizado	Farroupilha	0 - 0	Grêmio
22 Ene 06	Finalizado	Grêmio	3 - 1	Esportivo BG
18 Ene 06	Finalizado	São Luiz	1 - 2	Grêmio
15 Ene 06	Finalizado	Santa Cruz RS	2 - 3	Grêmio
11 Ene 06	Finalizado	Veranópolis	1 - 4	Grêmio

Estadísticas

GOLEADORES

Rômulo11

AMARILLAS

ROJAS

Hugo3

Escalona2

Lucas Leiva2

Nunes1

William1

Wellington1

Tcheco1

G. Herrera1

Evaldo1

Plantilla del Grêmio Temporada 2005/2006

		Edad	Altura	Peso
Portero
	Cássio	36	195	92	-	-	-
12	M. Grohe	37	188	82	-	-	-
	R. Galatto	41	193	88	-	-	1
Defensa
	Alessandro	45	179	77	3	-	4
	Bruno Teles	37	183	75	1	-	7
	Escalona	44	183	84	-	2	2
	Evaldo	41	191	84	3	1	8
	Patrício Antônio	49	-	-	2	-	5
	Pereira	44	188	88	-	-	3
	Wellington	38	176	71	-	1	4
	William	47	-	-	1	1	5
Centrocampista
	Hugo	43	181	78	8	3	4
	Jeovânio	46	173	73	-	-	11
	Julián Maidana	52	186	84	1	-	2
	Léo Lima	42	185	83	2	-	2
8	Lucas Leiva	37	179	73	4	2	12
	Marcelo Costa	43	-	-	1	-	4
	Nunes	40	-	-	-	1	3
	Paulo Ramos	38	181	74	-	-	1
	Ramon	35	186	75	7	-	1
	Reinaldo	44	182	81	-	-	-
	Rudnei	39	188	78	-	-	1
	Sandro Goiano	50	-	-	-	-	3
	Tcheco	48	180	77	6	1	4
	Valdeir	47	179	76	-	-	-
27	Willian Magrão	37	190	81	-	-	-
Delantero
	Aloisio	35	170	76	-	-	1
	G. Herrera	40	180	78	9	1	3
	Pedro Júnior	37	180	74	-	-	-
	Rafinha	40	167	67	2	-	1
	Ricardinho	39	-	-	2	-	1
	Rômulo	42	-	-	11	-	2

Noticias del Grêmio

Ver últimas noticias

Los 25 campeones de la Copa Libertadores

Antonio M. García - Martes, 05 Julio 2016

6 31.741

Hacemos un repaso de todos lo equipos que han conseguido levantar el torneo de mayor prestigio continental.

Paolo Guerrero le da la victoria al Flamengo frente al Gremio

BeSoccer - Domingo, 19 Julio 2015

0 228

El Flamengo se impuso hoy por 1-0 al Gremio con un gol de Paolo Guerrero, el primero que el delantero peruano anota en el estadio Maracaná y que llevó al equipo de la camisa roja y negra a la casilla 13 del Campeonato Brasileño.

El Mallorca ya tiene sustituto de Asensio

Jaime Velasco - Viernes, 17 Julio 2015

0 377

El conjunto balear seguirá teniendo una joven promesa en sus filas.

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 Atlético Mineiro es el nuevo líder en Brasil

BeSoccer - Lunes, 06 Julio 2015

0 100

El equipo blanquinegro aprovechó el tropiezo del Sport Recife y le alcanza en la cima de la tabla al ganar 1-3 al Internacional.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		São Paulo	78
2		Internacional	69
3		Grêmio	67
4		Santos FC	64
5		Paraná	60
6		Vasco da Gama	59
7		Figueirense	57
8		Goiás EC	55
9		Corinthians	53
10		Cruzeiro	53
11		Flamengo	52
12		Botafogo	51
13		Athletico Paranaense	48
14		EC Juventude	47
15		Fluminense	45
16		Palmeiras	44
17		Ponte Preta	39
18		Fortaleza EC	38
19		São Caetano	36
20		Santa Cruz	28

Pos

Equipos

Pts

USO DE MEMORIA

6,600,832 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1775
Total Execution Time	0.1794

CADENA URL

/Gremio-Porto-Alegre/2006

GET DATOS

$_GET['/Gremio-Porto-Alegre/2006']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0069	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 = 'Gremio-Porto-Alegre' AND l.year = 2006 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=1256 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=1256 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=1256 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=1256 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=1256 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=1256 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 13642
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 = 13643
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 = 13644
0.0037	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 = '1256' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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 = '1256' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 13642 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	(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 calendars2006 as c ON c.league_id = l.id WHERE (c.datateam1 = 1256 or c.datateam2 = 1256) AND l.year = 2006 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0043	(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 calendars2006 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 = 1256 or c.datateam2 = 1256) AND l.year = 2006 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0037	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2006 as c ON c.league_id = l.id INNER JOIN events2006 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 = 1256 or c.datateam2 = 1256) AND l.year = 2006)
0.0052	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=1256 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (23849,13646,12964,11332,435) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 435 AND teamId = 1256
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 12964 AND teamId = 1256
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 11332 AND teamId = 1256
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 23849 AND teamId = 1256
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 13646 AND teamId = 1256
0.0039	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 events2006 e ON e.player_id = p.id AND e.league_id = 435 WHERE rp.league_id = 435 AND rp.teamId = 1256 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 events2006 e ON e.player_id = p.id AND e.league_id = 435 WHERE rp.league_id = 435 AND rp.teamId = 1256 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 events2006 e ON e.player_id = p.id AND e.league_id = 435 WHERE rp.league_id = 435 AND rp.teamId = 1256 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 1256 AND rp.league_id = 435 AND l.year= 2006 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025	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=8422 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=8422
0.0032	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=8422 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.0028	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=8422 and (e.action = 4 or e.action = 5) 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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=8422 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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=8422 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0027	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=8422 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Grêmio

Información sobre Grêmio

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Grêmio

Estadísticas

Plantilla del Grêmio Temporada 2005/2006

Noticias del Grêmio

Grêmio

Selecciona un equipo

Competiciones que juega

RIVALES EN Liga Brasileña

RIVALES EN Copa Brasil

RIVALES EN Gaucho 1