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

Real Sporting

Entrenador: Miguel Ángel Ramírez

Temporada 2020/2021

Información sobre Real Sporting

Enviar Datos

Información

Nombre del equipo Real Sporting
Nombre completo Real Sporting de Gijón SAD
Nombre corto SPO
País España
Entrenador Miguel Ángel Ramírez
URL del equipo en RF //m.resultados-futbol.com/Sporting-Gijon

Otros Datos

Año de Fundación 1905
Patrocinador Integra Energía
Equipo Filial Sporting B
Marca de Ropa Puma
Lugar de entrenamiento Escuela de fútbol de Mareo
Socios 22906

Internet

Sitio Web www.realsporting.com/
Twitter principal @RealSporting

Información sobre el estadio

Nombre del estadio El Molinón-Enrique Castro Quini
Capacidad 30000
Dirección Parque de Isabel la Católica s/n
Teléfono 985 360 064
Fax 985 167 632
Año de construcción 1908
Tamaño 105 x 68 metros

Histórico de participación

Copa del Rey

101 veces

(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1953, 1951, 1950, 1949, 1948, 1947, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1936, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1927, 1927, 1926, 1926, 1924, 1923, 1922, 1921, 1920, 1919, 1918, 1917)

Segunda División

51 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2015, 2014, 2013, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1977, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1957, 1956, 1955, 1951, 1950, 1949, 1944, 1943, 1942, 1941, 1940, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929)

Primera División

42 veces

(2017, 2016, 2012, 2011, 2010, 2009, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1976, 1975, 1974, 1973, 1972, 1971, 1959, 1958, 1954, 1953, 1952, 1948, 1947, 1946, 1945)

Partidos Amistosos

14 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Segunda - Play Offs Ascenso

9 veces

(2018, 2014, 1995, 1967, 1964, 1952, 1943, 1943, 1942)

Europa League

6 veces

(1992, 1988, 1986, 1981, 1980, 1979)

Partidos del Real Sporting

Ir al LIVESCORE

Segunda División »

30 May 21	Finalizado	Real Sporting	0 - 2	Almería	668
24 May 21	Finalizado	Fuenlabrada	0 - 0	Real Sporting	566
20 May 21	Finalizado	Real Sporting	1 - 0	Las Palmas	404
17 May 21	Finalizado	Girona	1 - 0	Real Sporting	422
10 May 21	Finalizado	Real Sporting	1 - 0	CD Lugo	374
02 May 21	Finalizado	Leganés	0 - 0	Real Sporting	189
23 Abr 21	Finalizado	Real Zaragoza	0 - 0	Real Sporting	278
17 Abr 21	Finalizado	Real Sporting	0 - 1	Real Oviedo	864
09 Abr 21	Finalizado	Tenerife	1 - 0	Real Sporting	228
04 Abr 21	Finalizado	Real Sporting	1 - 2	Mirandés	451
30 Mar 21	Finalizado	Rayo Vallecano	0 - 1	Real Sporting	280
26 Mar 21	Finalizado	Real Sporting	0 - 0	Alcorcón	359
20 Mar 21	Finalizado	CE Sabadell	1 - 1	Real Sporting	502
14 Mar 21	Finalizado	Real Sporting	2 - 0	Mallorca	435
07 Mar 21	Finalizado	Ponferradina	2 - 2	Real Sporting	416
28 Feb 21	Finalizado	Real Sporting	1 - 1	Espanyol	631
20 Feb 21	Finalizado	Albacete	0 - 1	Real Sporting	146
14 Feb 21	Finalizado	Real Sporting	1 - 0	Málaga	166
06 Feb 21	Finalizado	UD Logroñés	0 - 4	Real Sporting	238
31 Ene 21	Finalizado	Real Sporting	0 - 0	FC Cartagena	254
24 Ene 21	Finalizado	CD Castellón	2 - 0	Real Sporting	577
11 Ene 21	Finalizado	Real Sporting	2 - 1	Fuenlabrada	367
04 Ene 21	Finalizado	CD Lugo	0 - 0	Real Sporting	495
21 Dic 20	Finalizado	Real Sporting	1 - 1	Leganés	351
13 Dic 20	Finalizado	Real Sporting	1 - 0	Real Zaragoza	551
06 Dic 20	Finalizado	Espanyol	2 - 0	Real Sporting	522
03 Dic 20	Finalizado	Real Sporting	0 - 0	Albacete	328
29 Nov 20	Finalizado	Las Palmas	3 - 2	Real Sporting	339
25 Nov 20	Finalizado	Real Sporting	3 - 1	CE Sabadell	199
22 Nov 20	Finalizado	Mallorca	0 - 0	Real Sporting	298
16 Nov 20	Finalizado	Real Sporting	1 - 1	Rayo Vallecano	583
07 Nov 20	Finalizado	Mirandés	1 - 0	Real Sporting	312
02 Nov 20	Finalizado	Real Sporting	1 - 0	CD Castellón	468
29 Oct 20	Finalizado	Alcorcón	1 - 2	Real Sporting	343
25 Oct 20	Finalizado	Real Sporting	2 - 1	Ponferradina	355
22 Oct 20	Finalizado	Málaga	1 - 0	Real Sporting	295
18 Oct 20	Finalizado	Real Sporting	1 - 1	Tenerife	244
11 Oct 20	Finalizado	Real Oviedo	1 - 0	Real Sporting	749
04 Oct 20	Finalizado	Almería	0 - 1	Real Sporting	323
26 Sep 20	Finalizado	Real Sporting	2 - 0	Girona	352
20 Sep 20	Finalizado	FC Cartagena	0 - 1	Real Sporting	533
12 Sep 20	Finalizado	Real Sporting	1 - 0	UD Logroñés	374

Copa del Rey »

17 Ene 21	Finalizado	Real Sporting	0 - 2	Real Betis	488
07 Ene 21	Finalizado	SD Amorebieta	0 - 1	Real Sporting	172
16 Dic 20	Finalizado	CD Quintanar del Rey	1 - 2	Real Sporting	251

Partidos Amistosos »

05 Sep 20	Finalizado	Celta	1 - 1	Real Sporting	42
~~04 Sep 20~~	Aplazado	Real Sporting	-	Ponferradina	4
03 Sep 20	Finalizado	Real Sporting	0 - 0	UD Logroñés	68
30 Ago 20	Finalizado	Real Sporting	1 - 2	CD Lugo	37
~~28 Ago 20~~	Aplazado	Real Sporting	-	CD Lugo	8
28 Ago 20	Finalizado	Real Sporting	1 - 0	Ponferradina	28
~~28 Ago 20~~	Aplazado	Real Sporting	-	Racing	14
23 Ago 20	Finalizado	Real Sporting	2 - 2	Sporting Atlético	50

Estadísticas

GOLEADORES

Djuka22

AMARILLAS

ROJAS

Plantilla del Real Sporting Temporada 2020/2021

		Edad	Altura	Peso
Portero
41	Ardura	22	180	64	-	-	-
30	Christian Joel	24	193	88	-	-	-
13	Diego Mariño	33	185	75	-	-	1
33	Joel Jiménez	24	188	79	-	-	-
40	Pablo Díez	22	187	79	-	-	-
Defensa
36	Álex Zalaya	26	184	75	-	-	-
32	B. Milovanov	26	178	75	-	-	4
5	Borja López	30	191	79	-	-	4
38	D. Argüelles	22	175	68	-	-	-
2	Guille Rosas	23	175	67	-	-	5
6	J. Babin	37	181	84	1	-	7
4	Marc Valiente	37	187	71	-	-	3
26	Pablo García	23	178	68	-	-	1
34	Pelayo Suárez	25	183	84	-	-	-
3	Saúl García	29	182	71	-	-	4
39	Trabanco	23	177	64	-	-	-
Centrocampista
10	C. Carmona	36	177	72	-	1	2
20	C. Salvador	29	184	78	-	-	2
43	J. Mecerreyes	23	183	70	-	-	-
18	Javi Fuego	40	181	74	-	-	6
16	José Gragera	23	186	78	1	-	4
29	M. Arellano	26	183	71	-	-	-
19	Manu García	26	169	65	1	-	7
14	Nacho Méndez	26	178	73	-	-	-
22	Pablo Pérez	30	187	71	1	-	3
8	Pedro Díaz	25	180	75	3	-	5
Delantero
7	Aitor García	30	173	70	2	1	3
28	Berto González	26	173	64	-	-	-
35	César García	24	178	74	-	-	-
23	Djuka	30	181	82	22	-	6
27	Gaspar Campos	24	175	72	3	1	3
17	Nikola Čumić	25	176	66	1	-	4
31	P. Morilla	22	182	74	-	-	-
11	V. Campuzano	26	174	72	-	-	-

Noticias del Real Sporting

Ver últimas noticias

La vida al revés

BeSoccer - Domingo, 28 Abril 2024

0 7.328

El Villarreal B goleó al Real Sporting por 0-3 en la jornada 37 de Segunda División. El doblete de Álex Forés y el tanto de Javi Ontiveros dejan al filial 'groguet' a 1 punto de la permanencia con 1 partido más. Jarro de agua congelada en El Molinón, que se queda fuera del 'play off'.

¡Tres horas duraron las entradas del Oviedo para El Molinón!

BeSoccer - Jueves, 21 Marzo 2019

1 424

Desde que ambos equipos finalizaron sus últimos compromisos de Segunda, tanto Sporting como Oviedo comenzaron a pensar en el derbi. En Asturias se empieza a calentar ya el partido y la afición oviedista lo demostró en unas horas, agotando todas las entradas disponibles para los seguidores visitantes en El Molinón.

El Sporting conmemora los 40 años de su debut europeo

BeSoccer - Miércoles, 05 Septiembre 2018

0 492

El Sporting conmemorará el próximo día 14 de septiembre el 40 aniversario de su debut en la hoy desaparecida Copa de la UEFA, en el que se impuso por un claro 3-0 al Torino, y llevará a cabo una serie de actos abiertos a todos los aficionados.

Del gol mal anulado al Sporting al 1-0 de Osasuna

Carlos Torregrosa - Sábado, 22 Abril 2017

0 514

Estas cosas tiene el fútbol. Estas cosas tiene LaLiga, una competición que aspira a ser la mejor del mundo, pero en la que los errores de bulto siguen siendo igual de desequilibrantes que Messi o Cristiano.

Un esguince de rodilla deja a Cuellar entre algodones

BeSoccer - Lunes, 01 Febrero 2016

0 700

El entrenador del Sporting, Abelardo Fernández, deberá esperar la evolución del esguince leve de rodilla que sufrió ayer en Valencia el guardameta Cuellar para poder saber si podrá contar con su portero titular para el partido que su equipo disputará el sábado contra el Deportivo de la Coruña.

Ver más noticias del equipo»

Competiciones que juega

Segunda División

Pos	Equipos		Pts
1		Espanyol	82
2		Mallorca	82
3		Leganés	73
4		Almería	73
5		Girona	71
6		Rayo Vallecano	67
7		Real Sporting	65
8		Ponferradina	57
9		Las Palmas	56
10		Mirandés	54
11		Fuenlabrada	54
12		Málaga	53
13		Real Oviedo	52
14		Tenerife	52
15		Real Zaragoza	50
16		FC Cartagena	49
17		Alcorcón	48
18		CD Lugo	47
19		CE Sabadell	46
20		UD Logroñés	44
21		CD Castellón	41
22		Albacete	38

	Ascenso : Espanyol, Mallorca
	Playoff Ascenso : Leganés, Almería, Girona, Rayo Vallecano
	Descenso : CE Sabadell, UD Logroñés, CD Castellón, Albacete

RIVALES EN Copa del Rey

RIVALES EN Segunda División

USO DE MEMORIA

6,405,704 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.7300
Total Execution Time	0.7319

CADENA URL

/sporting-gijon/2021

GET DATOS

$_GET['/sporting-gijon/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0213	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 = 'sporting-gijon' AND l.year = 2021 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.0148	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=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152	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=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0177	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 = 57314
0.0150	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2125 AND type_rel = 2
0.0339	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2125 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (1312958,38760,212526,497020,602673) ORDER BY n.cover_points DESC, update_date DESC
0.0163	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 = '2125' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0164	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 = '2125' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156	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 = 59872 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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 = 57314 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0162	(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 calendars2021 as c ON c.league_id = l.id WHERE (c.datateam1 = 2125 or c.datateam2 = 2125) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0205	(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 calendars2021 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 = 2125 or c.datateam2 = 2125) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0182	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2021 as c ON c.league_id = l.id INNER JOIN events2021 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 = 2125 or c.datateam2 = 2125) AND l.year = 2021)
0.0163	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=2125 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (65506,62832,62807) 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.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 62832 AND teamId = 2125
0.0160	SELECT count(id) as num_players from rel_players WHERE league_id = 65506 AND teamId = 2125
0.0318	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 2125
0.0154	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2021` 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 = 57314 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0226	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 events2021 e ON e.player_id = p.id AND e.league_id = 57314 WHERE rp.league_id = 57314 AND rp.teamId = 2125 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.0233	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 events2021 e ON e.player_id = p.id AND e.league_id = 57314 WHERE rp.league_id = 57314 AND rp.teamId = 2125 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160	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 events2021 e ON e.player_id = p.id AND e.league_id = 57314 WHERE rp.league_id = 57314 AND rp.teamId = 2125 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 2125 AND rp.league_id = 57314 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0151	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=6382800 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6382800
0.0158	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382800 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.0157	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382800 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0153	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382800 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0154	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382800 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0157	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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6382800 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Real Sporting

Información sobre Real Sporting

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Copa del Rey

Segunda División

Primera División

Partidos Amistosos

Segunda - Play Offs Ascenso

Europa League

Trofeo Teresa Herrera

Copa de la Liga de España

Trofeo Ciutat de Palma

Trofeo Ramón de Carranza

Trofeo Colombino

Partidos del Real Sporting

Estadísticas

Plantilla del Real Sporting Temporada 2020/2021

Noticias del Real Sporting

La vida al revés

¡Tres horas duraron las entradas del Oviedo para El Molinón!

El Sporting conmemora los 40 años de su debut europeo

Del gol mal anulado al Sporting al 1-0 de Osasuna

Un esguince de rodilla deja a Cuellar entre algodones

Real Sporting

Selecciona un equipo

Competiciones que juega

Segunda División

RIVALES EN Copa del Rey

RIVALES EN Segunda División