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

Grêmio

Entrenador: Renato Portaluppi

Temporada 2017/2018

Información sobre Grêmio

Enviar Datos

Información

Nombre del equipo Grêmio
Nombre completo Grêmio Porto Alegre
Nombre corto GRE
País Brasil
Ciudad Porto Alegre, Rio Grande do Sul
Entrenador Renato Portaluppi
URL del equipo en RF //m.resultados-futbol.com/Gremio-Porto-Alegre

Otros Datos

Año de Fundación 1903
Patrocinador Banrisul
Marca de Ropa Umbro

Internet

Sitio Web www.gremio.net
Correo electrónico gremio@gremio.net
Twitter principal @Gremio

Información sobre el estadio

Nombre del estadio Arena do Grêmio
Capacidad 60540
Dirección Rua Largo dos Campeões 1 90880-440 Porto Alegre, Rio Grande do Sul
Teléfono +55 (51) 3217 2244
Fax +55 (51) 3223 2364
Año de construcción 2012

Histórico de participación

Liga Brasileña

93 veces

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

Gaucho 1

49 veces

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

Copa Libertadores Grupo 3

39 veces

(2024, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2016, 2014, 2014, 2013, 2013, 2011, 2011, 2009, 2009, 2007, 2007, 2003, 2003, 2002, 2002, 1998, 1998, 1997, 1997, 1996, 1995, 1995, 1990, 1984, 1984, 1983, 1983, 1983, 1982)

Copa Brasil

31 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2010, 2008, 2006, 2005, 2004, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989)

Supercopa Libertadores Grupo 4

10 veces

(1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988)

Conmebol Sudamericana Grupo 8

7 veces

(2021, 2021, 2012, 2010, 2008, 2004, 2003)

Fase Previa Copa Libertadores Grupo 3

4 veces

(2021, 2021, 2013, 2011)

Partidos del Grêmio

Ir al LIVESCORE

Mundial de Clubes »

	16 Dic 17	Finalizado	Real Madrid	1 - 0	Grêmio			1416
	12 Dic 17	Finalizado	Grêmio	1 - 0	Pachuca			562

Copa Libertadores »

31 Oct 18	Finalizado	Grêmio	1 - 2	River Plate	1327
24 Oct 18	Finalizado	River Plate	0 - 1	Grêmio	820
03 Oct 18	Finalizado	Grêmio	4 - 0	Atl. Tucumán	278
19 Sep 18	Finalizado	Atl. Tucumán	0 - 2	Grêmio	498
29 Ago 18	Finalizado	Grêmio	2 - 1	Estudiantes La Plata	518
08 Ago 18	Finalizado	Estudiantes La Plata	2 - 1	Grêmio	436
24 May 18	Finalizado	Grêmio	1 - 0	Defensor Sporting	176
16 May 18	Finalizado	Monagas	1 - 2	Grêmio	145
02 May 18	Finalizado	Grêmio	5 - 0	Cerro Porteño	276
18 Abr 18	Finalizado	Cerro Porteño	0 - 0	Grêmio	371
05 Abr 18	Finalizado	Grêmio	4 - 0	Monagas	162
27 Feb 18	Finalizado	Defensor Sporting	1 - 1	Grêmio	218

Recopa Sudamericana »

	22 Feb 18	Finalizado	Grêmio	0 - 0	Independiente			399
	15 Feb 18	Finalizado	Independiente	1 - 1	Grêmio			192

Liga Brasileña »

02 Dic 18	Finalizado	Grêmio	1 - 0	Corinthians	35
25 Nov 18	Finalizado	Vitória	0 - 0	Grêmio	48
22 Nov 18	Finalizado	Flamengo	2 - 0	Grêmio	72
18 Nov 18	Finalizado	Grêmio	2 - 0	Chapecoense	14
15 Nov 18	Finalizado	São Paulo	1 - 1	Grêmio	111
11 Nov 18	Finalizado	Grêmio	2 - 1	Vasco da Gama	40
03 Nov 18	Finalizado	Atl. Mineiro	0 - 1	Grêmio	11
27 Oct 18	Finalizado	Grêmio	3 - 4	Sport Recife	136
20 Oct 18	Finalizado	América Mineiro	1 - 1	Grêmio	0
14 Oct 18	Finalizado	Palmeiras	2 - 0	Grêmio	92
07 Oct 18	Finalizado	Grêmio	2 - 2	Bahía	221
29 Sep 18	Finalizado	Fluminense	0 - 1	Grêmio	57
23 Sep 18	Finalizado	Grêmio	3 - 2	Ceará	118
15 Sep 18	Finalizado	Grêmio	2 - 0	Paraná	76
09 Sep 18	Finalizado	Internacional	1 - 0	Grêmio	121
07 Sep 18	Finalizado	Santos FC	0 - 0	Grêmio	259
01 Sep 18	Finalizado	Grêmio	4 - 0	Botafogo	13
26 Ago 18	Finalizado	Athletico Paranaense	2 - 1	Grêmio	75
23 Ago 18	Finalizado	Grêmio	1 - 1	Cruzeiro	197
19 Ago 18	Finalizado	Corinthians	0 - 1	Grêmio	184
13 Ago 18	Finalizado	Grêmio	4 - 0	Vitória	24
05 Ago 18	Finalizado	Grêmio	2 - 0	Flamengo	113
30 Jul 18	Finalizado	Chapecoense	1 - 1	Grêmio	110
27 Jul 18	Finalizado	Grêmio	2 - 1	São Paulo	104
22 Jul 18	Finalizado	Vasco da Gama	1 - 0	Grêmio	135
19 Jul 18	Finalizado	Grêmio	2 - 0	Atl. Mineiro	68
14 Jun 18	Finalizado	Sport Recife	0 - 0	Grêmio	151
10 Jun 18	Finalizado	Grêmio	1 - 0	América Mineiro	0
07 Jun 18	Finalizado	Grêmio	0 - 2	Palmeiras	77
03 Jun 18	Finalizado	Bahía	0 - 2	Grêmio	40
31 May 18	Finalizado	Grêmio	0 - 0	Fluminense	100
28 May 18	Finalizado	Ceará	0 - 1	Grêmio	53
20 May 18	Finalizado	Paraná	0 - 0	Grêmio	166
12 May 18	Finalizado	Grêmio	0 - 0	Internacional	51
07 May 18	Finalizado	Grêmio	5 - 1	Santos FC	32
28 Abr 18	Finalizado	Botafogo	2 - 1	Grêmio	21
23 Abr 18	Finalizado	Grêmio	0 - 0	Athletico Paranaense	68
14 Abr 18	Finalizado	Cruzeiro	0 - 1	Grêmio	38

Copa Brasil »

16 Ago 18	Finalizado	Flamengo	1 - 0	Grêmio	104
02 Ago 18	Finalizado	Grêmio	1 - 1	Flamengo	165
10 May 18	Finalizado	Grêmio	3 - 1	Goiás EC	75
26 Abr 18	Finalizado	Goiás EC	0 - 2	Grêmio	43

Gaucho 1 »

08 Abr 18	Finalizado	Brasil de Pelotas	0 - 3	Grêmio	9
01 Abr 18	Finalizado	Grêmio	4 - 0	Brasil de Pelotas	0
29 Mar 18	Finalizado	Grêmio	1 - 1	EC Avenida	12
25 Mar 18	Finalizado	EC Avenida	0 - 3	Grêmio	0
22 Mar 18	Finalizado	Internacional	2 - 0	Grêmio	21
18 Mar 18	Finalizado	Grêmio	3 - 0	Internacional	4
11 Mar 18	Finalizado	Internacional	1 - 2	Grêmio	0
08 Mar 18	Finalizado	Grêmio	1 - 0	São Paulo RS	11
04 Mar 18	Finalizado	EC Juventude	0 - 2	Grêmio	2
24 Feb 18	Finalizado	Grêmio	3 - 0	Novo Hamburgo	0
18 Feb 18	Finalizado	Veranópolis	2 - 1	Grêmio	6
08 Feb 18	Finalizado	Grêmio	2 - 1	Brasil de Pelotas	20
04 Feb 18	Finalizado	Grêmio	0 - 1	Cruzeiro RS	0
28 Ene 18	Finalizado	EC São José	2 - 0	Grêmio	0
24 Ene 18	Finalizado	EC Avenida	3 - 2	Grêmio	2
20 Ene 18	Finalizado	Grêmio	3 - 5	Caxias do Sul	2
18 Ene 18	Finalizado	São Luiz	1 - 1	Grêmio	2

Estadísticas

GOLEADORES

Everton10

AMARILLAS

Ramiro10

ROJAS

Plantilla del Grêmio Temporada 2017/2018

		Edad	Altura	Peso
Portero
34	Brenno	25	190	75	-	-	-
30	Bruno Grassi	37	192	87	-	-	-
1	M. Grohe	37	188	82	-	-	2
48	Paulo Victor	37	187	76	-	-	2
Defensa
12	B. Cortéz	37	179	74	-	-	3
22	Bressan	31	185	75	1	-	3
38	Denilson	29	187	77	-	-	-
19	Derlan	28	187	80	-	-	-
35	Felipe	24	174	73	-	-	-
36	G. Guedes	24	177	73	-	-	-
3	Geromel	38	190	84	2	-	3
29	Juninho Capixaba	26	176	63	3	-	2
6	Léo Gomes	27	178	70	-	-	2
2	Leo Moura	45	176	65	-	-	-
26	M. Oliveira	37	185	76	-	-	5
28	Paulo Miranda	35	186	77	-	-	2
41	Rodrigues	26	188	77	-	-	-
4	W. Kannemann	33	184	77	-	1	6
Centrocampista
23	Alisson	30	174	73	1	-	2
10	Cícero	39	180	72	2	-	5
10	Douglas	42	176	66	2	-	1
40	Isaque	27	178	75	-	-	-
31	Jean Pyerre	25	187	72	1	-	-
14	Kaio	29	173	62	-	-	1
13	Lima	27	181	73	-	-	-
7	Luan	31	180	71	1	-	3
8	Maicon	38	183	78	3	-	3
32	Matheus Henrique	26	175	71	2	-	3
5	Michel	34	183	76	-	-	1
17	Ramiro	30	169	67	-	-	10
	Romulo	33	185	73	-	-	1
27	T. Anderson	26	184	81	3	-	-
16	Thaciano	28	182	73	1	-	3
Delantero
90	André	33	184	77	4	-	5
11	Everton	28	174	72	10	-	5
9	Jael	35	186	85	6	-	3
39	L. Henrique	26	184	76	-	-	-
31	L. Poletto	29	181	74	-	-	-
70	Marinho	33	169	62	1	-	4
33	Pepê	27	175	68	2	-	1
15	Vico	27	174	68	-	-	-

Noticias del Grêmio

Ver últimas noticias

Tensión en Gremio: el entrenador mandó abandonar el campo al banquillo tras una roja a Diego Costa

BeSoccer - Domingo, 28 Abril 2024

0 973

Gremio no atraviesa un buen momento tras su mal inicio en la Copa Libertadores. La tensión existente en el cuadro de Porto Alegre quedó patente en el último choque ante Bahía. Con 1-0 en contra y en el tiempo añadido, el árbitro expulsó a Diego Costa. Una decisión que hizo perder los papeles al técnico Renato Portaluppi, que ordenó a todo su banquillo que abandonase el campo en señal de protesta.

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.

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»

Competiciones que juega

Grupo 3

Liga Brasileña

Pos	Equipos		Pts
1		Palmeiras	80
2		Flamengo	72
3		Internacional	69
4		Grêmio	66
5		São Paulo	63
6		Atl. Mineiro	59
7		Athletico Paranaense	57
8		Cruzeiro	53
9		Botafogo	51
10		Santos FC	50
11		Bahía	48
12		Fluminense	45
13		Corinthians	44
14		Chapecoense	44
15		Ceará	44
16		Vasco da Gama	43
17		Sport Recife	42
18		América Mineiro	40
19		Vitória	37
20		Paraná	23

	Copa Libertadores : Palmeiras, Flamengo, Internacional, Grêmio, São Paulo, Atl. Mineiro
	Liguilla Sudamericana : Athletico Paranaense, Cruzeiro, Botafogo, Santos FC, Bahía, Fluminense
	Descenso : Sport Recife, América Mineiro, Vitória, Paraná

RIVALES EN Liga Brasileña

RIVALES EN Copa Brasil

RIVALES EN Copa Libertadore.

RIVALES EN Mundial de Clube.

RIVALES EN Gaucho 1

RIVALES EN Recopa Sudameric.

USO DE MEMORIA

7,198,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0053
Controller Execution Time ( Home / Category )	0.2698
Total Execution Time	0.2752

CADENA URL

/gremio-porto-alegre/2018

GET DATOS

$_GET['/gremio-porto-alegre/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0058	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 = 2018 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.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.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.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.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.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.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.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.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 = 42644
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 = 41950
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 = 41951
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 = 40465
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 = 41840
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 = 41904
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 = 41683
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 = 43080
0.0040	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 = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0055	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.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 = 42644 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 = 41904 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 41950 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 40465 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 43080 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 = 41840 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	(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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 1256 or c.datateam2 = 1256) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0040	(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 calendars2018 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 = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0039	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 2018)
0.0037	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 (2017,2018,2019) 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 (49730,49329,48489,48467,43475,41840,40465,38714) 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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 48489 AND teamId = 1256
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 40465 AND teamId = 1256
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 49730 AND teamId = 1256
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 41840 AND teamId = 1256
0.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 48467 AND teamId = 1256
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 49329 AND teamId = 1256
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 38714 AND teamId = 1256
0.0120	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 1256
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 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 = 42644 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2018 e ON e.player_id = p.id AND e.league_id = 42644 WHERE rp.league_id = 42644 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.0041	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 events2018 e ON e.player_id = p.id AND e.league_id = 42644 WHERE rp.league_id = 42644 AND rp.teamId = 1256 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042	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 events2018 e ON e.player_id = p.id AND e.league_id = 42644 WHERE rp.league_id = 42644 AND rp.teamId = 1256 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 42644 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0029	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=863715 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=863715
0.0035	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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=863715 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=863715 and (e.action = 4 or e.action = 5) 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=863715 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=863715 AND (e.action = 22) 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=863715 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 2017/2018

Noticias del Grêmio

Grêmio

Selecciona un equipo

Competiciones que juega

RIVALES EN Liga Brasileña

RIVALES EN Copa Brasil

RIVALES EN Copa Libertadore.

RIVALES EN Mundial de Clube.

RIVALES EN Gaucho 1

RIVALES EN Recopa Sudameric.