01 Nov 22	Finalizado	Rangers FC	1 - 3	Ajax	217
26 Oct 22	Finalizado	Napoli	3 - 0	Rangers FC	360
12 Oct 22	Finalizado	Rangers FC	1 - 7	Liverpool	401
04 Oct 22	Finalizado	Liverpool	2 - 0	Rangers FC	332
14 Sep 22	Finalizado	Rangers FC	0 - 3	Napoli	349
07 Sep 22	Finalizado	Ajax	4 - 0	Rangers FC	781

Fase Previa Champions League »

24 Ago 22	Finalizado	PSV	0 - 1	Rangers FC	860
16 Ago 22	Finalizado	Rangers FC	2 - 2	PSV	481
09 Ago 22	Finalizado	Rangers FC	3 - 0	Union Saint-Gilloise	401
02 Ago 22	Finalizado	Union Saint-Gilloise	2 - 0	Rangers FC	640

Partidos Amistosos »

10 Dic 22	Finalizado	B. Leverkusen	0 - 3	Rangers FC	54
23 Jul 22	Finalizado	Rangers FC	1 - 2	Tottenham Hotspur	114
19 Jul 22	Finalizado	Rangers FC	3 - 1	West Ham	75
16 Jul 22	Finalizado	Blackpool	1 - 2	Rangers FC	12
~~09 Jul 22~~	Aplazado	Sunderland	-	Rangers FC	22

Liga Escocia »

27 May 23	Finalizado	St. Mirren	0 - 3	Rangers FC	24
24 May 23	Finalizado	Rangers FC	2 - 2	Heart of Midlothian	54
21 May 23	Finalizado	Hibernian FC	1 - 3	Rangers FC	7
13 May 23	Finalizado	Rangers FC	3 - 0	Celtic	76
07 May 23	Finalizado	Rangers FC	1 - 0	Aberdeen	81
23 Abr 23	Finalizado	Aberdeen	2 - 0	Rangers FC	55
15 Abr 23	Finalizado	Rangers FC	5 - 2	St. Mirren	34
08 Abr 23	Finalizado	Celtic	3 - 2	Rangers FC	70
01 Abr 23	Finalizado	Rangers FC	2 - 0	Dundee United	14
18 Mar 23	Finalizado	Motherwell	2 - 4	Rangers FC	41
08 Mar 23	Finalizado	Hibernian FC	1 - 4	Rangers FC	48
04 Mar 23	Finalizado	Rangers FC	3 - 1	Kilmarnock	4
18 Feb 23	Finalizado	Livingston	0 - 3	Rangers FC	22
04 Feb 23	Finalizado	Rangers FC	2 - 1	Ross County FC	82
01 Feb 23	Finalizado	Heart of Midlothian	0 - 3	Rangers FC	54
28 Ene 23	Finalizado	Rangers FC	2 - 0	St. Johnstone	30
18 Ene 23	Finalizado	Kilmarnock	2 - 3	Rangers FC	182
08 Ene 23	Finalizado	Dundee United	0 - 2	Rangers FC	106
02 Ene 23	Finalizado	Rangers FC	2 - 2	Celtic	405
28 Dic 22	Finalizado	Rangers FC	3 - 0	Motherwell	121
23 Dic 22	Finalizado	Ross County FC	0 - 1	Rangers FC	267
20 Dic 22	Finalizado	Aberdeen	2 - 3	Rangers FC	113
15 Dic 22	Finalizado	Rangers FC	3 - 2	Hibernian FC	329
12 Nov 22	Finalizado	St. Mirren	1 - 1	Rangers FC	165
09 Nov 22	Finalizado	Rangers FC	1 - 0	Heart of Midlothian	72
06 Nov 22	Finalizado	St. Johnstone	2 - 1	Rangers FC	169
29 Oct 22	Finalizado	Rangers FC	4 - 1	Aberdeen	25
22 Oct 22	Finalizado	Rangers FC	1 - 1	Livingston	233
16 Oct 22	Finalizado	Motherwell	1 - 2	Rangers FC	99
08 Oct 22	Finalizado	Rangers FC	4 - 0	St. Mirren	10
01 Oct 22	Finalizado	Heart of Midlothian	0 - 4	Rangers FC	17
17 Sep 22	Finalizado	Rangers FC	2 - 1	Dundee United	12
03 Sep 22	Finalizado	Celtic	4 - 0	Rangers FC	135
27 Ago 22	Finalizado	Rangers FC	4 - 0	Ross County FC	22
20 Ago 22	Finalizado	Hibernian FC	2 - 2	Rangers FC	115
13 Ago 22	Finalizado	Rangers FC	4 - 0	St. Johnstone	16
06 Ago 22	Finalizado	Rangers FC	2 - 0	Kilmarnock	73
30 Jul 22	Finalizado	Livingston	1 - 2	Rangers FC	74

Copa Escocia »

30 Abr 23	Finalizado	Rangers FC	0 - 1	Celtic	48
12 Mar 23	Finalizado	Rangers FC	3 - 0	Raith Rovers	31
12 Feb 23	Finalizado	Rangers FC	3 - 2	Partick Thistle	160
21 Ene 23	Finalizado	St. Johnstone	0 - 1	Rangers FC	71

Copa de la Liga de Escocia »

26 Feb 23	Finalizado	Rangers FC	1 - 2	Celtic	69
15 Ene 23	Finalizado	Rangers FC	2 - 1	Aberdeen	107
19 Oct 22	Finalizado	Rangers FC	1 - 0	Dundee	58
30 Ago 22	Finalizado	Rangers FC	3 - 1	Queen of the South	38

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Rangers FC Temporada 2022/2023

		Edad	Altura	Peso
Portero
1	Allan Mcgregor	42	183	74	-	-	-
33	J. Mclaughlin	36	191	83	-	-	-
48	L. Budinauckas	21	-	-	-	-	-
28	R. Mccrorie	26	188	80	-	-	-
Defensa
44	Adam Devine	21	190	-	-	-	-
31	B. Barišić	31	186	79	-	-	1
26	Ben Davies	28	185	74	-	-	1
6	C. Goldson	31	191	85	-	-	-
60	Connor Allan	20	-	-	-	-	-
16	J. Souttar	27	186	80	-	-	-
2	J. Tavernier	32	182	76	1	-	1
38	Leon King	20	183	75	-	-	-
49	R. Fraser	21	182	-	-	-	-
3	R. Yilmaz	22	174	60	-	-	-
Centrocampista
51	Alex Lowry	20	181	-	-	-	-
18	Glen Kamara	28	183	78	-	-	-
19	James Sands	23	186	73	-	1	2
4	John Lundstram	30	181	74	-	-	3
71	Malik Tillman	21	187	79	-	-	-
8	Ryan Jack	32	182	66	-	-	1
37	S. Arfield	35	178	64	1	-	-
10	Steven Davis	39	172	70	-	-	-
Delantero
9	A. Čolak	30	188	80	-	-	-
20	A. Morelos	27	177	79	-	-	1
30	F. Sakala	27	178	72	-	-	-
14	R. Kent	27	176	65	-	-	-
17	Rabbi Matondo	23	175	66	-	-	-
23	S. Wright	26	176	65	-	-	-
11	Thomas Lawrence	30	175	69	-	-	-

Noticias del Rangers FC

Ver últimas noticias

Oduwa regresa al Tottenham

BeSoccer - Lunes, 18 Enero 2016

0 646

El Tottenham ha hecho oficial la vuelta de Nathan Oduwa. El volante ofensivo regresa a los Spurs tras media temporada cedido en el Rangers.

El Rangers firma a Gostomski hasta junio

BeSoccer - Lunes, 04 Enero 2016

0 410

El guardameta polaco sólo ha disputado dos partidos con el Lech Poznán esta temporada y jugará en Glasgow hasta verano.

El Rangers busca una nueva resurrección

BeSoccer - Martes, 03 Noviembre 2015

3 1.222

El Glasgow Rangers perdió frente al Warbuton doce jornadas después. Ahora, el equipo quiere demostrar que una nueva resurrección es posible.

Le compararon con Messi y ahora jugará en la Segunda de Escocia

Ángela M. Romero - Sábado, 17 Octubre 2015

14 24.788

Brillaba en el conjunto catalán y muchos lo comparaban con Messi, pero ahora, Gai Assulin probará suerte en Glasgow Rangers escocés, tras no haber ofrecido todo lo que sus inicios prometieron.

El Arsenal cede a Gedion Zelalem al Rangers

BeSoccer - Martes, 25 Agosto 2015

0 483

El canterano jugador 'Gunner', de 18 años, se va cedido hasta enero al equipo de Glasgow.

Ver más noticias del equipo»

Competiciones que juega

Champions League Grupo 1

Pos	Equipos		Pts
1		Napoli	15
2		Liverpool	15
3		Ajax	6
4		Rangers FC	0

	Siguiente Ronda : Napoli, Liverpool
	: Ajax
	Eliminado : Rangers FC

RIVALES EN Fase Previa Cham.

RIVALES EN Champions League

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN Liga Escocia

USO DE MEMORIA

7,451,768 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.9441
Total Execution Time	0.9461

CADENA URL

/Glasgow-Rangers-Fc/2023

GET DATOS

$_GET['/Glasgow-Rangers-Fc/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (59)

0.0125	SELECT type FROM routes WHERE alias = 'glasgow-rangers-fc'
0.0291	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 = 'Glasgow-Rangers-Fc' AND l.year = 2023 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.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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 = 68812
0.0132	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 = 67765
0.0132	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 = 71550
0.0132	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 = 67751
0.0132	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 = 67752
0.0130	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 = 68547
0.0132	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 = 68392
0.0157	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 = '1241' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0155	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 = '1241' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 67752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125	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 = 68812 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	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 = 68392 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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 = 68547 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 71550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	(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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 1241 or c.datateam2 = 1241) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0138	(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 calendars2023 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 = 1241 or c.datateam2 = 1241) AND l.year = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0134	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 = 1241 or c.datateam2 = 1241) AND l.year = 2023)
0.0148	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=1241 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75868,74791,73407,73404,72097,71432,68812,63059) 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.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 75868 AND teamId = 1241
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 68812 AND teamId = 1241
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 74791 AND teamId = 1241
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 72097 AND teamId = 1241
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 63059 AND teamId = 1241
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 73404 AND teamId = 1241
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 73407 AND teamId = 1241
0.0215	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1241
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2023` 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 = 68812 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131	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 events2023 e ON e.player_id = p.id AND e.league_id = 68812 WHERE rp.league_id = 68812 AND rp.teamId = 1241 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.0130	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 events2023 e ON e.player_id = p.id AND e.league_id = 68812 WHERE rp.league_id = 68812 AND rp.teamId = 1241 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 events2023 e ON e.player_id = p.id AND e.league_id = 68812 WHERE rp.league_id = 68812 AND rp.teamId = 1241 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 = 1241 AND rp.league_id = 68812 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0130	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=6537246 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0126	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6537246
0.0130	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537246 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.0128	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537246 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0127	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537246 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0129	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537246 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0133	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537246 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0126	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 = 68812 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Rangers FC

Información sobre Rangers FC

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Rangers FC