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

Resultados de Fútbol

Rangers FC

Entrenador: Philippe Clement

Temporada 2012/2013

TEMPORADA 2012/2013

LEAGUE TWO ESCOCIA
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	36	87	29	83
2	Peterhead	36	52	28	59
3	Queen's Park	36	60	54	56
4	Berwick	36	59	55	49
5	Elgin City	36	67	69	49
6	Montrose	36	60	68	47
7	Stirling	36	59	58	45
8	Annan	36	54	65	43
9	Clyde	36	42	66	40
10	East	36	49	97	29

TEMPORADA 2011/2012

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celtic	33	72	20	81
2	Rangers FC	33	65	25	73
3	Motherwell	33	43	38	55
4	Johnstone	33	42	36	50
5	Dundee	33	55	43	49
6	Heart	33	41	32	48
7	Kilmarnock	33	36	54	37
8	Aberdeen	33	32	38	36
9	St. Mirren	33	32	46	35
10	Inverness	33	36	54	32
11	Hibernian	33	34	62	27
12	Dunfermline	33	32	72	20

TEMPORADA 2010/2011

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	33	72	28	80
2	Celtic	33	72	21	79
3	Heart	33	47	31	61
4	Dundee	33	44	41	52
5	Kilmarnock	33	47	41	47
6	Motherwell	33	36	43	44
7	Inverness	33	44	42	41
8	Hibernian	33	36	52	36
9	Johnstone	33	18	39	34
10	Aberdeen	33	34	54	31
11	St. Mirren	33	31	54	28
12	Hamilton	33	20	55	19

TEMPORADA 2009/2010

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	33	73	22	77
2	Celtic	33	62	35	66
3	Dundee	33	51	39	59
4	Hibernian	33	47	43	50
5	Motherwell	33	39	38	48
6	Heart	33	32	39	44
7	Johnstone	33	50	54	41
8	Hamilton	33	29	43	36
9	Aberdeen	33	31	46	34
10	Kilmarnock	33	26	44	29
11	St. Mirren	33	32	45	28
12	Falkirk	33	30	54	28

TEMPORADA 2008/2009

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celtic	33	75	30	74
2	Rangers FC	33	68	26	73
3	Heart	33	37	34	54
4	Dundee	33	43	40	49
5	Aberdeen	33	36	33	48
6	Hibernian	33	38	41	42
7	Motherwell	33	36	44	41
8	Kilmarnock	33	31	43	34
9	St. Mirren	33	28	44	34
10	Hamilton	33	26	47	34
11	Inverness	33	32	52	32
12	Falkirk	33	32	48	28

TEMPORADA 2007/2008

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	33	78	27	79
2	Celtic	33	75	23	74
3	Motherwell	33	43	40	53
4	Dundee	33	48	38	50
5	Hibernian	33	47	38	50
6	Aberdeen	33	43	53	44
7	Falkirk	33	40	44	42
8	Heart	33	42	48	42
9	Inverness	33	41	58	36
10	Kilmarnock	33	34	46	33
11	St. Mirren	33	22	51	33
12	Gretna	33	29	76	17

TEMPORADA 2006/2007

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celtic	33	59	25	78
2	Rangers FC	33	54	25	65
3	Aberdeen	33	46	33	57
4	Heart	33	40	30	54
5	Kilmarnock	33	43	49	46
6	Hibernian	33	49	37	44
7	Falkirk	33	40	42	40
8	Dundee	33	39	53	40
9	Inverness	33	36	45	36
10	Motherwell	33	35	49	36
11	St. Mirren	33	24	47	27
12	Dunfermline	33	19	49	23

TEMPORADA 2005/2006

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celtic	33	88	31	85
2	Heart	33	64	27	65
3	Rangers FC	33	59	34	62
4	Hibernian	33	56	45	52
5	Kilmarnock	33	59	56	51
6	Aberdeen	33	39	36	48
7	Motherwell	33	50	55	44
8	Inverness	33	45	38	43
9	Dundee	33	39	58	32
10	Falkirk	33	31	61	25
11	Dunfermline	33	26	63	23
12	Livingston	33	20	72	15

TEMPORADA 2004/2005

LIGA ESCOCIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	5	11	5	93
2	Celtic	5	8	7	92
3	Hibernian	5	8	8	61
4	Aberdeen	5	6	6	61
5	Heart	5	4	8	50
6	Motherwell	5	5	8	48

TEMPORADA 2003/2004

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celtic	33	99	20	90
2	Rangers FC	33	66	26	74
3	Heart	33	47	36	55
4	Dunfermline	33	35	43	47
5	Motherwell	33	39	37	45
6	Dundee	33	39	51	42
7	Hibernian	33	37	52	38
8	Livingston	33	38	48	36
9	Dundee	33	41	55	34
10	Aberdeen	33	38	52	34
11	Kilmarnock	33	39	68	32
12	Partick	33	31	61	18

TEMPORADA 2002/2003

LIGA ESCOCIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rangers FC	33	86	23	87
2	Celtic	33	81	22	82
3	Heart	33	55	47	57
4	Kilmarnock	33	43	46	50
5	Dunfermline	33	48	56	44
6	Dundee	33	44	48	42
7	Hibernian	33	46	58	39
8	Aberdeen	33	32	48	37
9	Livingston	33	41	50	32
10	Partick	33	29	50	29
11	Dundee	33	29	61	25
12	Motherwell	33	35	60	24

Competiciones que juega

League Two Escocia

Pos	Equipos		Pts
1		Rangers FC	83
2		Peterhead	59
3		Queen's Park	56
4		Berwick Rangers	49
5		Elgin City	49
6		Montrose	47
7		Stirling Albion	45
8		Annan Athletic	43
9		Clyde	40
10		East Stirlingshire	29

RIVALES EN Challenge Cup Es.

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN League Two Escoc.

USO DE MEMORIA

6,917,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8451
Total Execution Time	0.8464

CADENA URL

/historico/Glasgow-Rangers-Fc/2013

GET DATOS

$_GET['/historico/Glasgow-Rangers-Fc/2013']

POST DATOS

No hay datos POST existentes

CONSULTAS (53)

0.0288	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 = 2013 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.0132	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.0136	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.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.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 = 2027
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 = 22546
0.0147	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 = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0146	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.0127	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 = 22546 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 = 2027 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154	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 (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0129	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 (42902,42843,22546,20915,20898,10312,2457,2399,2027) 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.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 10312 AND teamId = 1241
0.0169	SELECT count(id) as num_players from rel_players WHERE league_id = 2457 AND teamId = 1241
0.0175	SELECT count(id) as num_players from rel_players WHERE league_id = 2027 AND teamId = 1241
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 42843 AND teamId = 1241
0.0171	SELECT count(id) as num_players from rel_players WHERE league_id = 42902 AND teamId = 1241
0.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 20898 AND teamId = 1241
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 20915 AND teamId = 1241
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 22546 AND teamId = 1241
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 2399 AND teamId = 1241
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2013` 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 = 2027 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141	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 events2013 e ON e.player_id = p.id AND e.league_id = 2027 WHERE rp.league_id = 2027 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.0146	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 events2013 e ON e.player_id = p.id AND e.league_id = 2027 WHERE rp.league_id = 2027 AND rp.teamId = 1241 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144	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 events2013 e ON e.player_id = p.id AND e.league_id = 2027 WHERE rp.league_id = 2027 AND rp.teamId = 1241 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0183	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1241 AND l.year <= 2013 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` 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 = 2027 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2012` 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 = 10312 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2012` 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 = 1430 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 10311 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 1086 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 10310 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 935 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2009` 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 = 10309 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2009` 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 = 281 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2008` 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 = 10308 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2008` 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 = 74 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 10307 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 380 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2006` 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 = 10306 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` 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 = 381 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` 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 = 382 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` 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 = 10305 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2004` 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 = 10304 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2004` 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 = 383 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2003` 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 = 384 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 2027 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

Resultados de Fútbol

Rangers FC

Rangers FC

Selecciona un equipo

Competiciones que juega

League Two Escocia

RIVALES EN Challenge Cup Es.

RIVALES EN Copa de la Liga.

RIVALES EN Copa Escocia

RIVALES EN League Two Escoc.