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 1948/49


1st principal round

[Sep 26]
CA Genève		2-2 Stade Carouge		[aet]
Stade Carouge		1-5 CA Genève			[Replay Oct 3]
FC Aigle		4-2 FC Lutry
FC Bulle		5-1 FC Chailly/Lausanne
FC Renens		1-0 CS La Tour-de-Peilz
Grandson-Sports		3-2 FC Cossonay
FC Monthey		3-0 FC Visp
Le Locle-Sports		2-1 FC Auvernier
FC Tramelan		1-0 Madretsch Biel
US Bienne-Boujean	3-0 Bözingen 34
FC Selzach		0-1 FC Nidau
SC Bümpliz		0-1 Victoria Bern		[aet]
WEF Bern		1-3 Länggasse Bern
SC Burgdorf		3-0 FC Schönbühl
FC Langenthal		4-2 FC Biberist
SR Delémont		2-5 BSC Old Boys Basel
FC Röschenz		1-5 FC Münchenstein
SV Muttenz		0-4 SC Binningen
SV Sissach		5-0 BCO Basel
FC Suhr			1-0 FC Trimbach
FC Turgi		1-3 FC Baden			[aet]
FC Wettingen		5-0 FC Dietikon
FC Horgen		4-2 Kickers Luzern
SV Höngg ZH		2-1 Ballspielclub Zürich
FC Langnau am Albis	0-1 FC Adliswil
Polizei Zürich		1-0 FC Wädenswil
FC Rüti ZH		0-4 FC Wetzikon
FC Albisrieden		2-5 Phönix Winterthur
FC Wil			2-1 FC Töss
FC St.Margarethen	4-3 FC Gossau SG
SV Ceresio Schaffhausen	7-2 SC Veltheim
FC Thayngen		1-5 SpVgg Schaffhausen
FC Bischofszell		4-2 FC Weinfelden
FC Ems			6-2 FC Chur
FC Wattwil		3-2 Winkeln St.Gallen
Pro Daro Bellinzona	2-2 US Giubiasco		[aet]
US Giubiasco		 -  Pro Daro Bellinzona		[Replay Oct 3]
FC Contone		3-2 SC Balerna


2nd principal round

[Oct 10]
Gardy-Jonction GE	3-0 Stade Carouge
FC Aigle		1-2 Montreux-Sports
Ambrosiana Lausanne	3-2 FC Bulle
Stade Nyonnais		3-0 FC Renens
Yverdon-Sport		5-0 FC Grandson
FC Monthey		3-0 FC Sierre
Racing Lausanne		3-0 Le Locle-Sports
FC Tramelan		1-5 Etoile Sporting La Chaux-de-Fonds	
Central Fribourg	2-3 US Bienne-Boujean
FC Nidau		0-2 Helvetia Bern
Victoria Bern		1-1 Stade Lausanne		[aet]	
Stade Lausanne		4-1 Victoria Bern		[Replay Oct 17]
ES Malley		5-0 Länggasse Bern
SC Burgdorf		1-2 SC Derendingen
FC Lengnau		5-1 FC Langenthal		[aet]
BSC Old Boys Basel	3-2 FC Porrentruy
FC Birsfelden		1-1 FC Münchenstein		[aet]
FC Münchenstein		2-3 FC Birsfelden		[Replay Oct 17]
SC Binningen		0-2 SC Kleinhüningen
Concordia Basel		0-0 SV Sissach			[aet]
SV Sissach		1-5 Concordia Basel		[Replay Oct 17]
FC Moutier		6-2 FC Suhr
FC Baden		2-3 FC Solothurn
FC Olten		0-1 FC Wettingen
FC Horgen		0-2 SC Schöftland
FC Pratteln		1-4 SV Höngg ZH
SC Zofingen		2-1 FC Adliswil
Polizei Zürich		2-4 Blue Stars Zürich
FC Wetzikon		0-2 FC Uster
FC Schaffhausen		4-3 Phönix Winterthur
FC Wil			5-1 FC Arbon
FC Kreuzlingen		1-0 FC St.Margarethen
SV Ceresio Schaffhausen	2-0 Black Stars Basel
FC Allschwil		2-2 SpVgg Schaffhausen		[aet]
SpVgg Schaffhausen	1-2 FC Allschwil		[Replay Oct 17]
FC Bischofszell		2-3 FC Winterthur		[aet]
FC Ems			1-6 Red Star Zürich
FC Wattwil		1-2 FC Altstetten ZH
FC Emmenbrücke		6-1 Pro Daro Bellinzona
FC Contone		1-0 GC Biasca


3th principal round

[Nov 14]
Urania Genève-Sport	3-1 Helvetia Bern
Gardy-Jonction GE	1-1 FC Bern			[aet]
FC Bern			0-1 Gardy-Jonction GE		[Replay Dec 5]
FC Moutier		1-0 Stade Lausanne
FC Thun			1-1 BSC Old Boys Basel		[aet]
BSC Old Boys Basel	1-5 FC Thun			[Replay Dec 5]
FC Allschwil		0-5 FC Chiasso
AC Bellinzona 		2-0 Red Star ZH			[aet]
FC Biel-Bienne		2-0 Stade Nyonnais
FC Monthey		1-3 Servette FC Genève
FC Birsfelden		4-0 SC Brühl St.Gallen
FC Lengnau		2-1 Young Fellows Zürich
Lausanne-Sports		8-0 Ambrosiana Lausanne
Etoile Sp. Chaux-de-F.  0-1 FC La Chaux-de-Fonds
FC Fribourg		3-0 US Bienne-Boujean
Vevey-Sports		5-2 FC Solothurn
FC St.Gallen		2-0 FC Schaffhausen
Nordstern Basel		3-1 SC Kleinhüningen		[aet]
FC Aarau		1-1 FC Altstetten ZH		[aet]
FC Altstetten ZH	0-1 FC Aarau			[Replay Dec 5]
SC Zug			3-1 SV Ceresio Schaffhausen
FC Zürich		6-3 FC Wil
SC Schöftland		4-2 Mendrisiostar
Grasshopper-Club Zürich	8-0 FC Emmenbrücke
FC Lugano		5-1 FC Uster
Concordia Basel		5-3 SC Zofingen
FC Winterthur		1-2 FC Basel
SV Höngg ZH		1-3 FC Contone
Yverdon-Sport		2-1 CS International GE
ES Malley		2-1 FC Grenchen
Cantonal Neuchâtel 	1-0 Racing Lausanne
BSC Young Boys Bern	3-1 Montreux-Sports
FC Locarno		2-1 Blue Stars Zürich
FC Kreuzlingen		4-1 FC Wettingen
[Dec 5]
SC Derendingen		1-1 FC Luzern			[aet]
FC Luzern		1-1 SC Derendingen		[Replay Dec 26]
 SC Derendingen is qualified on coin toss


1/16

[Dec 5]
FC Fribourg		3-2 Vevey-Sports
FC St.Gallen		0-2 Nordstern Basel
[Dec 26]
Urania Genève-Sport	4-0 Jonction-Gardy GE
FC Moutier		0-0 FC Thun			[aet]
FC Thun			3-1 FC Moutier			[aet; Replay Jan 2]
FC Chiasso		2-1 AC Bellinzona 
FC Biel-Bienne          1-2 Servette FC Genève
FC Birsfelden		1-3 FC Lengnau
Lausanne-Sports		4-0 FC La Chaux-de-Fonds
FC Aarau		1-0 SC Zug
FC Zürich		5-1 SC Schöftland
Grasshopper-Club ZH	2-1 FC Lugano
Concordia Basel		0-1 FC Basel
Yverdon-Sport		0-1 ES Malley
Cantonal Neuchâtel	3-1 BSC Young Boys Bern
FC Locarno		3-0 FC Kreuzlingen
[Jan 2]
SC Derendingen		5-1 FC Contone


1/8

[Jan 9]
Urania Genève-Sport	5-0 FC Thun
FC Lengnau		0-5 Lausanne-Sports
FC Fribourg		3-0 Nordstern Basel
FC Aarau		2-2 FC Zürich			[aet]
FC Zürich		4-0 FC Aarau			[Replay Jan 23]
Grasshopper-Club	1-1 FC Basel			[aet]
FC Basel		1-2 Grasshopper-Club		[Replay Jan 23]
Derendingen		0-1 ES Malley
Cantonal Neuchâtel      0-1 FC Locarno
FC Chiasso              ppd Servette Genève
FC Chiasso              1-3 Servette Genève		[Jan 23]


1/4

[Jan 16]
Lausanne-Sports		1-0 FC Fribourg
[Feb 13]
Urania Genève-Sport     0-1 Servette Genève
FC Zürich               0-6 Grasshopper-Club
ES Malley		2-0 FC Locarno


Semifinals

March 27 at Stade des Charmilles in Genève 
Servette FC Genève	5-1 Lausanne-Sports
 [45 75 Facchinetti, 77 87 Tamini, 88 Fatton; 13 Maillard II]
 
March 13 at Hardturm Stadion in Zürich
Grasshopper-Club ZH	3-0 ES Malley
 [3 Berbig, 15 62 wang] 


Final 

April 18 at Wankdorf Stadion in Bern
Servette FC Genève	3-0 Grasshopper-Club Zürich
 [42 45pen Fatton, 70 Tamini] 


Author:
Erik Garin
(garinerik@hispeed.ch)

Last updated: 26 Jan 2007

(C) Copyright Erik Garin and RSSSF 2005/07


  USO DE MEMORIA  
4,308,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1064
Total Execution Time  0.1086
  CADENA URL  
/copa_suiza1949
  GET DATOS  
$_GET['/copa_suiza1949']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0017  SELECT type FROM routes WHERE alias = 'copa_suiza1949'
0.0039  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 = 1949 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=1543
0.0018  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 = 29814 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='1949' WHERE c.parentId=643 GROUP BY c.id ORDER BY c.order_id ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:22:05' 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 06:22:05' 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 06:22:05' 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 06:22:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  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 = 1949 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1949
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (29814) 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 (29814) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0017  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1949
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (29814) 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 (29814) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1949
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (29814) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0051  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 (29814) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0049  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1949
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1949 e WHERE e.league_id IN (29814) AND (e.action IN (22) ) 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 (29814) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 1949 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 = 1949 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0021  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=29814 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 = 29814 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 29814 AND esl.points > 0
0.0020  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` = 29814 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 29814
0.0020  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 `calendars1949` 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` = 29814 AND c.`round` = 9 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1949` e INNER JOIN calendars1949 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 = 29814 ORDER BY total DESC LIMIT 40
0.0022  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 `events1949` e INNER JOIN calendars1949 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 = 29814 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables1949` 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 = 29814 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1949` 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 = 29814 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 29814 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=643
0.0024  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 643 AND l.year = 1949 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=643 AND year=1949