4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
 
Cup 1983-84


1st Principal Round

[July 30-31]
Meinier GE		3-1 Saint-Jean GE
Saint-Prex		3-1 Yverdon
Versoix			2-1 Concordia Lausanne
Savièse			2-3 Montreux-Sports
Conthey			1-5 Stade Lausanne
Lutry			1-8 Renens
Düdingen		2-5 Bern
Amriswil		2-0 Frauenfeld
Lachen			1-3 Ibach
Embrach			3-0 Küsnacht
Dietikon		3-1 Widnau
Stäfa ZH		4-3 Vaduz
Bad Ragaz		1-0 Brüttisellen		[in Landquart]
Rümlang			FF  FC Schaffhausen		[Forfeit; awd 0-3]	 
Seebach			0-1 Rüti ZH
Bülach			1-3 Einsielden
Morbio Superga		1-1 Ponte Tresa-Monteggio	[aet; 4-5 pen]
Arbon			4-2 Blue Stars ZH
Berg			0-5 Kreuzlingen
Rapperswil-Jona		3-1 Balzers
Männedorf		1-3 Uzwil
Tuggen			1-6 Altstätten SG
Veltheim		1-4 Turicum ZH
Phönix Winterthur	1-9 FC Zug
Balerna			4-1 Giubiasco
Urania Genève Sport	0-2 Etoile Carouge
Bagnes			3-4 Orbe			[aet]
Brig			3-0 Raron
Collombey-Muraz		2-2 Sierre			[aet; 4-5 pen]
Beauregard Fribourg	0-3 Aurore Bienne
Hauterive		3-6 Fétigny
Châtel-St-Denis		4-2 Bôle
Meyrin			1-3 Stade Nyonnais
Fully			2-4 Malley
Moudon			0-9 Leytron
Estavayer-le-Lac	2-1 Superga La Chaux-de-Fonds
Le Locle		1-2 Boncourt
Travers			2-6 Boudry
Etoile Chaux-de-Fonds	3-2 Delémont
CS International GE	0-3 Stade Payerne
Hergiswil		2-1 Sursee
Kickers Luzern		0-9 Emmen
Rotkreuz		3-5 Kriens
Wolhusen		0-8 Buochs
Interlaken		0-0 Solothurn			[aet; 4-3 pen]
Altdorf			1-6 Emmenbrücke			[in Brunnen]
Pratteln		2-3 Oberentfelden
Baudepartement Basel	3-3 Concordia Basel		[aet; 14-13 pen]
Zurzach			1-3 Breitenbach
Binningen		1-2 Klus-Balsthal
Reiden			3-1 Burgdorf
Bümpliz			0-1 Köniz
Gränichen		2-6 Brugg
Oftringen		3-5 Olten			[aet]
Muri AG			0-2 Suhr
Derendingen		0-0 Old Boys Basel		[aet; 10-9 pen]
Egerkingen		2-4 Birsfelden
Windisch		0-6 Bremgarten
Ouchy Lausanne		0-4 Gland
Schmitten		0-3 Charmey
Jorat-Mézières		3-3 Romont			[aet; 3-2 pen]
Bützberg		1-2 Lerchenfeld			[aet]
Glovelier		1-5 Moutier
Worb BE			3-0 Lyss
Lengnau			7-1 Dürrenast
Orpund			1-3 Bassecourt
Cham			5-0 Buttisholz
Azzurri Bienne		0-6 Rapid Ostermundigen
Stein			0-3 Gerlafingen
Flumenthal		4-3 Zuchwil
Liestal			6-1 Riehen
Kirchberg SG		2-1 Mels
Mönchaltorf		2-4 Wald			[aet]
Wiesendangen		1-0 Seefeld ZH
Schleuis		0-1 Ascona		
Armonia Lugano		1-2 Morobbia Giubiasco
Sissach			1-3 Allschwil
Glarus			1-2 Gossau SG			[aet]
Brühl SG		3-0 Wollishofen
Puidoux-Chêbres		3-2 Saint-Légier		[awd 0-3 forfeit]
 [The player Jean-Marie Dormond of Puidoux was not qualified]


2nd Principal Round

[Aug 6-7]
NLB - 1.L
Leytron			0-2 Chênois
Renens			1-3 Martigny-Sports
Bern			0-4 Fribourg
Breitenbach		1-2 SC Zug
Olten			0-2 Laufen
Emmenbrücke		1-4 Grenchen			[aet]
Reiden			0-5 Baden
FC Schaffhausen		1-4 Winterthur
FC Zug			3-5 Lugano
Einsielden		1-4 Locarno
Rüti ZH			0-3 Red Star ZH
NLB - 2.L
Gland			2-5 Biel-Bienne
Sierre			1-1 Monthey			[aet; 4-5 pen]
Versoix			0-4 Bulle
Ascona			0-1 Mendrisio
NLB - 3.L
Flumenthal		1-2 Nordstern Basel
1.L - 1.L
Aurore Bienne		0-0 Etoile Carouge		[aet; 4-3 pen]
Boncourt		6-3 Boudry			[aet]
Concordia Basel		6-0 Bremgarten
Kriens			2-2 Köniz			[aet; 0-3 pen]
Uzwil			0-4 Kreuzlingen
1.L - 2.L
Stade Payerne		2-3 Montreux-Sports
Malley			2-0 Estavayer-le-Lac
Fétigny			2-1 Meinier GE
Suhr			2-1 Liestal
Derendingen		0-0 Oberentfelden		[aet; 4-3 pen]
Hergiswil		2-4 Allschwil
Rapid Ostermundigen	3-1 Lengnau
Brugg			0-1 Birsfelden
Interlaken		0-5 Buochs
Lerchenfeld		1-2 Klus-Balsthal
Stäfa ZH		0-2 Ibach
Bad Ragaz		0-5 Turicum ZH
1.L - 3.L
Jorat-Mézières		0-2 Stade Nyonnais
Châtel-St-Denis		2-5 Stade Lausanne
Cham			0-3 Emmen
Wiesendangen		0-4 Altstätten SG
2.L - 2.L
Kirchberg SG		1-1 Gossau SG			[aet; 4-5 pen]
Rapperswil-Jona		2-2 Amriswil			[aet; 3-4 pen]
Moutier			6-3 Bassecourt
Brig			1-2 Charmey
Saint-Prex		3-3 Saint-Légier		[aet; 4-5 pen]
Etoile Chaux-de-Fonds	3-1 Orbe
Morobbia Giubiasco	5-2 Balerna
Dietikon		0-3 Embrach	
Brühl SG		1-3 Arbon
2.L - 3.L
Worb BE			0-4 Gerlafingen
Wald			0-2 Ponte Tresa-Monteggio


1/32 finals

[Sep 10-11]
Amriswil		3-0 Gossau
Buochs			3-2 Allschwil
Derendingen		0-1 Aarau
Fétigny			2-4 Aurore Bienne
Moutier			0-2 Grenchen
Montreux-Sports		1-2 Neuchâtel Xamax
Köniz			0-2 Young Boys Bern
Charmey		        1-13 Lausanne-Sports
Biel			7-2 Monthey
Gerlafingen		0-3 Laufen
Bulle			8-1 Saint-Légier
Etoile Chaux-de-Fonds	0-3 Boncourt
Mendrisio		2-0 Bellinzona			[aet]
Suhr			3-1 Klus-Balsthal
Tresa-Monteggio		2-3 Morobbia Giubiasco		[aet]
Embrach			2-3 Chiasso
Turicum ZH		0-5 St.Gallen
Winterthur		3-1 Lugano			[aet]
Altstätten SG		1-3 Red Star ZH
Arbon			0-6 Grasshopper-Club
Stade Nyonnais		0-5 La Chaux-de-Fonds	
Martigny-Sports		1-2 Servette
Fribourg		6-2 Malley
Chênois			3-3 Sion			[aet; 3-4 pen]
Baden			6-2 Concordia Basel		[aet]
Ibach			1-5 Zürich			[aet]
Emmen			1-6 Wettingen
Birsfelden		0-8 Basel
SC Zug			1-2 Luzern 
Stade Lausanne		1-2 Vevey-Sports
Rapid Ostermundigen	0-2 Nordstern Basel
Locarno			3-3 Kreuzlingen			[aet; abandonned]
Locarno			2-3 Kreuzlingen			[Replay]


1/16 finals

[Oct 15-16]
Amriswil		5-0 Buochs
Aarau			6-0 Aurore Bienne
Young Boys Bern		2-4 Lausanne-Sports
Biel			3-3 Laufen			[aet; 3-4 pen]
Bulle			3-0 Boncourt
Mendrisio		3-0 Suhr
Morobbia Giubiasco	0-1 Chiasso
St.Gallen		2-0 Winterthur
Red Star ZH		1-2 Grasshopper-Club
La Chaux-de-Fonds	1-3 Servette
Fribourg		0-3 Sion
Baden			1-3 Zürich
Kreuzlingen		2-5 Wettingen
Basel			0-3 Luzern 
Vevey-Sports		1-0 Nordstern Basel
Grenchen		1-3 Neuchâtel-Xamax		[Protest]
 [Protest of Grenchen : erreur d'arbitrage]
Grenchen		1-0 Neuchâtel-Xamax		[Replay]


1/8 finals

[March 31-April 1st]
FC Amriswil		0-1 FC Aarau
FC Grenchen		0-2 Lausanne-Sports
FC Laufen		2-3 FC Bulle
Mendrisio		1-2 FC Chiasso
FC St.Gallen		2-1 Grasshopper-Club
Servette Genève		4-2 FC Sion
FC Zürich		5-1 FC Wettingen
FC Luzern 		2-1 Vevey-Sports


1/4 finals

[April 23]
Lausanne-Sports		3-2 FC Zürich			[aet]
FC Luzern 		0-3 FC Aarau
FC St.Gallen		2-0 FC Bulle
Servette Genève		5-0 FC Chiasso


Semifinals

May 8 at Brügglifeld Stadion in Aarau
FC Aarau		0-0 Servette FC	Genève		[aet]
May 23 at Stade des Charmilles in Genève
Servette FC Genève	1-0 FC Aarau			[Replay]
 [88 Decastel]

May 8 at Stade de la Pontaise in Lausanne
Lausanne-Sports		1-0 FC St.Gallen
 [27 Dario]


Final

June 11 at Wankdorf Stadion in Bern
Servette FC Genève	1-0 Lausanne-Sports		[aet]
 [94 Geiger]


Author:
Erik Garin
(garinerik@hispeed.ch)

Last updated: 26 Jan 2007

(C) Copyright Erik Garin and RSSSF 2001/07


  USO DE MEMORIA  
4,310,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1150
Total Execution Time  0.1172
  CADENA URL  
/copa_suiza1984
  GET DATOS  
$_GET['/copa_suiza1984']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_suiza1984'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_suiza' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1984 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=1501
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 29772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1984' WHERE c.parentId=643 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:01:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:01:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:01:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:01:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_suiza' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1984 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1984
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1984 e WHERE e.league_id IN (29772) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29772) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1984
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1984 e WHERE e.league_id IN (29772) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29772) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1984
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1984 e WHERE e.league_id IN (29772) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0072  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29772) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0086  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1984
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1984 e WHERE e.league_id IN (29772) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29772) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT SUM(rp.lineup) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 643 AND rp.year = 1984 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0019  SELECT SUM(rp.events) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 643 AND rp.year = 1984 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0022  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29772 AND rel.round=9
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29772 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29772 AND esl.points > 0
0.0019  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29772 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29772
0.0021  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1984` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29772 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0017  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1984` e INNER JOIN calendars1984 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 9 AND e.real_date IS NOT NULL AND e.league_id = 29772 ORDER BY total DESC LIMIT 40
0.0019  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1984` e INNER JOIN calendars1984 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29772 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables1984` 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 = 29772 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1984` 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 = 29772 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29772 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=643
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 643 AND l.year = 1984 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=643 AND year=1984