02 May 92	Finalizado	Manchester United	3 - 1	Tottenham Hotspur
25 Abr 92	Finalizado	Tottenham Hotspur	3 - 3	Everton
20 Abr 92	Finalizado	Oldham Athletic AFC	1 - 0	Tottenham Hotspur
18 Abr 92	Finalizado	Tottenham Hotspur	3 - 2	Wimbledon FC
14 Abr 92	Finalizado	Sheffield United	2 - 0	Tottenham Hotspur
11 Abr 92	Finalizado	Queens Park Rangers	1 - 2	Tottenham Hotspur
07 Abr 92	Finalizado	Notts County	0 - 2	Tottenham Hotspur
04 Abr 92	Finalizado	Tottenham Hotspur	2 - 5	Aston Villa
01 Abr 92	Finalizado	Tottenham Hotspur	3 - 0	West Ham
28 Mar 92	Finalizado	Tottenham Hotspur	4 - 3	Coventry City
21 Mar 92	Finalizado	Liverpool	2 - 1	Tottenham Hotspur
14 Mar 92	Finalizado	Tottenham Hotspur	0 - 2	Sheffield Wednesday
11 Mar 92	Finalizado	Luton Town	0 - 0	Tottenham Hotspur
07 Mar 92	Finalizado	Tottenham Hotspur	1 - 3	Leeds United
22 Feb 92	Finalizado	Tottenham Hotspur	1 - 1	Arsenal
16 Feb 92	Finalizado	Tottenham Hotspur	0 - 1	Crystal Palace
01 Feb 92	Finalizado	Manchester City	1 - 0	Tottenham Hotspur
25 Ene 92	Finalizado	Tottenham Hotspur	0 - 0	Oldham Athletic AFC
18 Ene 92	Finalizado	Tottenham Hotspur	1 - 2	Southampton
11 Ene 92	Finalizado	Chelsea	2 - 0	Tottenham Hotspur
01 Ene 92	Finalizado	Coventry City	1 - 2	Tottenham Hotspur
28 Dic 91	Finalizado	Tottenham Hotspur	3 - 0	Norwich City
26 Dic 91	Finalizado	Tottenham Hotspur	1 - 2	Nottingham Forest
22 Dic 91	Finalizado	Crystal Palace	1 - 2	Tottenham Hotspur
18 Dic 91	Finalizado	Tottenham Hotspur	1 - 2	Liverpool
14 Dic 91	Finalizado	Leeds United	1 - 1	Tottenham Hotspur
07 Dic 91	Finalizado	Tottenham Hotspur	2 - 1	Notts County
01 Dic 91	Finalizado	Arsenal	2 - 0	Tottenham Hotspur
23 Nov 91	Finalizado	Tottenham Hotspur	0 - 1	Sheffield United
16 Nov 91	Finalizado	Tottenham Hotspur	4 - 1	Luton Town
02 Nov 91	Finalizado	Sheffield Wednesday	0 - 0	Tottenham Hotspur
26 Oct 91	Finalizado	West Ham	2 - 1	Tottenham Hotspur
19 Oct 91	Finalizado	Tottenham Hotspur	0 - 1	Manchester City
05 Oct 91	Finalizado	Everton	3 - 1	Tottenham Hotspur
28 Sep 91	Finalizado	Tottenham Hotspur	1 - 2	Manchester United
21 Sep 91	Finalizado	Wimbledon FC	3 - 5	Tottenham Hotspur
14 Sep 91	Finalizado	Tottenham Hotspur	2 - 0	Queens Park Rangers
07 Sep 91	Finalizado	Aston Villa	0 - 0	Tottenham Hotspur
31 Ago 91	Finalizado	Norwich City	0 - 1	Tottenham Hotspur
28 Ago 91	Finalizado	Nottingham Forest	1 - 3	Tottenham Hotspur
24 Ago 91	Finalizado	Tottenham Hotspur	1 - 3	Chelsea
17 Ago 91	Finalizado	Southampton	2 - 3	Tottenham Hotspur

FA Cup »

	14 Ene 92	Finalizado	Tottenham Hotspur	0 - 1	Aston Villa			0
	05 Ene 92	Finalizado	Aston Villa	0 - 0	Tottenham Hotspur			0

EFL Cup »

01 Mar 92	Finalizado	Tottenham Hotspur	1 - 2	Nottingham Forest
09 Feb 92	Finalizado	Nottingham Forest	1 - 1	Tottenham Hotspur
08 Ene 92	Finalizado	Tottenham Hotspur	2 - 1	Norwich City
04 Dic 91	Finalizado	Coventry City	1 - 2	Tottenham Hotspur
29 Oct 91	Finalizado	Grimsby Town	0 - 3	Tottenham Hotspur
09 Oct 91	Finalizado	Tottenham Hotspur	5 - 1	Swansea City
25 Sep 91	Finalizado	Swansea City	1 - 0	Tottenham Hotspur

Community Shield »

10 Ago 91

Finalizado

Arsenal

0 - 0

Tottenham Hotspur

Recopa de Europa »

18 Mar 92	Finalizado	Tottenham Hotspur	0 - 0	Feyenoord
04 Mar 92	Finalizado	Feyenoord	1 - 0	Tottenham Hotspur
07 Nov 91	Finalizado	Porto	0 - 0	Tottenham Hotspur
23 Oct 91	Finalizado	Tottenham Hotspur	3 - 1	Porto
02 Oct 91	Finalizado	Tottenham Hotspur	2 - 0	HNK Hajduk Split
17 Sep 91	Finalizado	HNK Hajduk Split	1 - 0	Tottenham Hotspur

Estadísticas

GOLEADORES

Plantilla del Tottenham Hotspur Temporada 1991/1992

		Edad	Altura	Peso
Portero
	E. Thorstvedt	61	-	-	-	-	-
	Ian Walker	52	188	83	-	-	-
Defensa
	Bergsson	58	185	78	1	-	-
	Cundy	54	183	88	1	-	-
	Dave Tuttle	52	188	81	-	-	-
	Gary Mabbutt	62	178	83	2	-	-
	Ian Hendon	52	183	81	-	-	-
	Justin Edinburgh	54	178	77	-	-	-
	T. Fenwick	64	-	-	-	-	-
Centrocampista
	David Howells	56	183	78	1	-	-
	Gray	60	178	80	3	-	-
	Jeff Minton	50	168	74	1	-	-
	John Hendry	54	180	69	1	-	-
	Nayim	57	177	75	1	-	-
	Pat Van Den Hauwe	63	180	-	-	-	-
	Paul Allen	61	-	-	3	-	-
	Samways	55	178	76	1	-	-
	Scott Houghton	52	170	78	2	-	-
	Steve Sedgley	55	186	88	-	-	-
	Stewart	59	180	74	5	-	-
Delantero
	G. Durie	58	-	-	7	-	-
	G. Lineker	63	176	74	28	-	-
	Paul Walsh	61	170	67	3	-	-

Noticias del Tottenham Hotspur

Ver últimas noticias

La gran duda de los aficionados del Tottenham: ¿apoyar al Bayern o al Arsenal?

BeSoccer - Martes, 16 Abril 2024

0 2.359

¿Apoyar a tu máximo rival para ir a la Champions o detestarlo y quedarte sin ella? Es el sinvivir de los aficionados del Tottenham sobre la eliminatoria entre el Bayern de Múnich y el Arsenal.

Tottenham y Wolves, jueces de la Premier

Javier García Márquez - Lunes, 15 Abril 2024

2 1.133

Quedan apenas 6 jornadas para el final de la Premier League y la clasificación ha dado un tumbo en la última fecha. Con el City como líder, 2 puntos por encima de Arsenal y Liverpool, los 3 candidatos al título tendrán que verse con Tottenham y Wolves, jueces de la competición.

Isak apunta y el Newcastle dispara a los 'spurs'

BeSoccer - Sábado, 13 Abril 2024

0 1.402

El Tottenham cayó (y de qué forma) ante el Newcastle. Las 'urracas', lideradas por un gran Alexander Isak, que marcó por partida doble, no tuvieron rival en un encuentro clave. A los 'spurs' les faltó pegada y tampoco estuvieron acertados en la defensa. Mala combinación de la que supo sacar partido el conjunto local.

La Premier aprueba el fuera de juego semiautomático por unanimidad

BeSoccer - Jueves, 11 Abril 2024

8 6.573

Matt Slater y Ed Mackey informan en el diario 'The Athletic' de que los clubes de la Premier League han votado a favor de implantar el fuera de juego semiautomático a partir de la temporada que viene. Lo han hecho por unanimidad. El sistema ya es habitual en la Champions, que lo estrenó el 6 de septiembre de 2022 para marcar una posición antirreglamentaria de Ben Chilwell en un gol de Pierre-Emerick Aubameyang al Dinamo de Zagreb en favor del Chelsea. Era una primera prueba de cara al Mundial de Catar.

El Tottenham se mete en Champions

BeSoccer - Domingo, 07 Abril 2024

0 840

El Tottenham Hotspur ganó al Nottingham Forest por 3-1 en la jornada 32 de la Premier League e irrumpió en posiciones de Champions gracias a los dos encuentros seguidos sin vencer por parte del Aston Villa. Los 'tricky trees' pusieron más en apuros a sus rivales de lo que el marcador sugiere, aunque tan solo vieron puerta con un gol de Chris Wood después de que Murillo se anotara en propia meta.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Leeds United	82
2		Manchester United	78
3		Sheffield Wednesday	75
4		Arsenal	72
5		Manchester City	70
6		Liverpool	64
7		Aston Villa	60
8		Nottingham Forest	59
9		Sheffield United	57
10		Crystal Palace	57
11		Queens Park Rangers	54
12		Everton	53
13		Wimbledon FC	53
14		Chelsea	53
15		Tottenham Hotspur	52
16		Southampton	52
17		Oldham Athletic AFC	51
18		Norwich City	45
19		Coventry City	44
20		Luton Town	42
21		Notts County	40
22		West Ham	38

Pos

Equipos

Pts

	Champions League : Leeds United
	UEFA : Manchester United, Sheffield Wednesday
	Recopa : Liverpool
	Descenso : Luton Town, Notts County, West Ham

Champions League : Leeds United

UEFA : Manchester United, Sheffield Wednesday

Recopa : Liverpool

Descenso : Luton Town, Notts County, West Ham

USO DE MEMORIA

6,728,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.7718
Total Execution Time	0.7736

CADENA URL

/Tottenham-Hotspur-Fc/1992

GET DATOS

$_GET['/Tottenham-Hotspur-Fc/1992']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0154	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 = 'Tottenham-Hotspur-Fc' AND l.year = 1992 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.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=2523 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=2523 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=2523 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=2523 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=2523 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=2523 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 339
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 = 22750
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 = 11027
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2523 AND type_rel = 2
0.0268	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2523 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (1311175,1311046,1310481,1310748,1309856) ORDER BY n.cover_points DESC, update_date DESC
0.0143	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 = '2523' AND l.year = 1992 ORDER BY l.year DESC,cat.coefficient DESC
0.0159	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 = '2523' 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 = 22750 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 = 339 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 11027 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0245	(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 calendars1992 as c ON c.league_id = l.id WHERE (c.datateam1 = 2523 or c.datateam2 = 2523) AND l.year = 1992 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0254	(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 calendars1992 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 = 2523 or c.datateam2 = 2523) AND l.year = 1992 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0423	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1992 as c ON c.league_id = l.id INNER JOIN events1992 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 = 2523 or c.datateam2 = 2523) AND l.year = 1992)
0.0145	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=2523 AND l.year in (1991,1992,1993) 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 (23239,22750,14681,11027,340) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 340 AND teamId = 2523
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 14681 AND teamId = 2523
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 23239 AND teamId = 2523
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 22750 AND teamId = 2523
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 11027 AND teamId = 2523
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 FROM* `tables1992` 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 = 339 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151	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 events1992 e ON e.player_id = p.id AND e.league_id = 339 WHERE rp.league_id = 339 AND rp.teamId = 2523 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.0136	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 events1992 e ON e.player_id = p.id AND e.league_id = 339 WHERE rp.league_id = 339 AND rp.teamId = 2523 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 events1992 e ON e.player_id = p.id AND e.league_id = 339 WHERE rp.league_id = 339 AND rp.teamId = 2523 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 2523 AND rp.league_id = 339 AND l.year= 1992 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0129	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=7631 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=7631
0.0134	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 events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7631 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.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 events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7631 and (e.action = 4 or e.action = 5) 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 events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7631 and (e.action = 3 or e.action = 4) 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 events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7631 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events1992 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=7631 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0127	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 = 339 ORDER BY nameShow LIMIT 100

Tottenham Hotspur

Información sobre Tottenham Hotspur

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Tottenham Hotspur

Estadísticas

Plantilla del Tottenham Hotspur Temporada 1991/1992

Noticias del Tottenham Hotspur

Tottenham Hotspur

Selecciona un equipo

Competiciones que juega

RIVALES EN Community Shield

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League

RIVALES EN Recopa de Europa