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 1988/89


1st principal round

[Aug 13-14]
Stade Payerne		1-1 FC Moudon			[aet; 5-4 pen]
FC Versoix		0-3 FC Fribourg
FC Aïre-le-Lignon	3-4 Folgore Lausanne
CS La Tour-de-Peilz	2-5 FC Aigle
FC Agarn		2-4 FC Leytron
FC Morat		1-4 FC Colombier
FC Prangins		0-4 Stade Lausanne
Superga NE		3-0 Cortaillod
FC Fully		3-1 Vevey-Sports
FC Bramois		0-3 FC Raron
WEF Bern		3-5 FC Thun
FC Allschwil		0-6 FC Suhr
FC Oftringen		2-3 FC Oensingen
FC Brugg		2-1 FC Frick
FC Bremgarten		1-0 FC Pratteln
FC Saignelégier		0-6 FC Moutier		
FC Courtemaîche		0-4 Le Locle-Sports
FC Gerlafingen		3-2 FC Köniz
Morobbia		3-0 FC Tresa			[aet]
FC Brunnen		0-1 FC Morbio
FC Effretikon		6-0 FC Küsnacht
FC Wädenswil		1-1 Embrach			[aet; 4-3 pen]
Root			1-4 FC Zug
FC Gunzwil		1-5 SC Buochs
FC Hergiswil		1-3 FC Muri AG
FC Au			1-1 FC Bad Ragaz		[aet; 3-4 pen]
FC Buttikon		2-13 FC Tuggen
Altbüron		0-2 SC Kriens
FC Corcelles		0-2 FC Boudry
FC Marly		1-2 FC Monthey
Signal Bernex		2-1 FC Vernier
Lancy-Sports		2-4 US Meinier GE
US Collombey-Muraz	6-0 FC Puidoux-Chêbres
FC Farvagny		3-10 FC Châtel-St-Denis
FC Brig			3-4 FC Savièse
FC Pully		0-2 FC Grand Lancy
FC Bottens		1-3 FC Echichens
FC Donneloye		1-4 Central Fribourg
FC Portalban		2-1 FC Domdidier
FC Bex			2-1 FC Conthey
FC Saint-Blaise		2-1 FC Echallens		[aet]
Sissach			0-1 Rapid Ostermundingen
FC Oberwil		4-2 FC Therwil
Härkingen		1-2 FC Olten
Bettlach		0-1 SV Lyss
FC Bassecourt		4-3 Azzurri Bienne		[aet]
FC Aarberg		2-3 FC Breitenbach
Dornach			0-3 FC Klus/Balstahl
Grünstern Ipsach	2-1 TT Bern
Italia Bern		0-3 Beauregard Fribourg
FC Langenthal		3-1 Baudepartement Basel
Bözingen 34		0-4 SR Delémont
FC Mett			2-7 SC Burgdorf
Zollbrück		1-2 FC Dürrenast
FC Sarmenstorf		2-2 FC Wohlen			[aet; 5-4 pen]
FC Spiez		1-9 FC Solothurn
FC Lerchenfeld		4-0 FC Bern
FC Rheinfelden		0-4 FC Laufen
Sementina		2-3 FC Ascona
Losone Sportiva		0-2 FC Altdorf
GC Biasca		1-1 Mendrisio			[aet; 4-5 pen]
Rebstein		1-3 FC Alstätten SG
Young Fellows ZH	0-2 FC Dübendorf
Tägerwilen		2-4 FC Töss
FC Arbon		0-2 FC Herisau
FC Rüti ZH		0-3 FC Bülach
FC Schwamendingen	2-0 FC Stäfa ZH
FC Flawil		3_4 FC Frauenfeld 
FC Balzers		1-0 FC Landquart
Schwarz-Weiss Zürich	1-2 Red Star ZH
Rotkruez		3-4 FC Sursee
FC Witikon ZH		FC Kilchberg
SV Schaffhausen		0-3 FC Beringen
Luzerner SC		1-5 FC Einsielden
Münchwilen		1-4 FC Rorschach
FC Wülflingen		2-6 FC Vaduz
FC Wetzikon		3-1 FC Brüttisellen
FC Hochdorf		2-0 Goldau
Interclub ZH		1-0 FC Seefeld ZH
Heiden			0-5 FC Amriswil


2nd principal round

[Aug 20-21]
FC Monthey		0-4 FC Renens
FC Raron		1-0 Martigny-Sports		[aet]
US Collombey-Muraz	0-5 Montreux-Sports
FC Oberwil		0-5 FC Basel
FC Sursee		0-4 SC Zug
FC Echichens		2-5 Etoile Carouge
Stade Payerne		0-2 Yverdon-Sport
FC Moutier		2-3 FC Biel-Bienne
FC Leytron		1-2 ES Malley
FC Sarmenstorf		0-2 Old Boys Basel
FC Kilchberg		0-4 FC Winterthur
FC Beringen		2-3 FC Chur
SC Buochs		1-1 FC Chiasso	      		[aet; 4-2 pen]
SR Delémont		4-3 La Chaux-de-Fonds		[aet]
FC Dübendorf		0-2 FC Schaffausen
FC Boudry		0-7 FC Bulle
FC Bad Ragaz		1-3 FC Glarus
SC Kriens		2-2 FC Emmenbrücke       	[aet; 4-5 pen]
FC Savièse		5-1 Urania-Genève-Sport
Folgore Lausanne	0-1 CS Chênois
FC Saint-Blaise		0-3 FC Grenchen
FC Einsielden		1-6 FC Locarno
FC Rorschach		0-8 FC Zürich
FC Bremgarten		2-3 FC Baden
FC Grand Lancy		3-2 FC Aigle
FC Fully		2-3 FC Châtel-St-Denis
FC Klus/Balstahl	1-2 FC Laufen
SC Burgdorf		1-1 FC Suhr	      		[aet; 5-4 pen]
FC Altdorf		3-1 FC Ascona
Mendrisio		2-0 FC Zug
Signal Bernex		2-3 Stade Lausanne
FC Bassecourt		0-4 FC Colombier
FC Fribourg		3-2 Central Fribourg
FC Brugg		2-0 Rapid Ostermundingen
FC Langenthal		4-2 FC Muri AG
FC Oensingen		1-2 FC Olten
FC Morbio		2-2 FC Tuggen	      		[aet; 3-4 pen]
Beauregard Fribourg	2-1 Le Locle-Sports
FC Gerlafingen		1-2 FC Solothurn
FC Dürrenast		0-3 SV Lyss
FC Lerchenfeld		1-0 FC Breitenbach
FC Grünstern Ipsach	0-9 FC Thun
FC Balzers		1-2 FC Vaduz
FC Wädenswil		1-2 Red Star ZH
FC Wetzikon		1-1 FC Alstätten SG		[aet; 1-4 pen]
FC Töss			1-0 FC Herisau
FC Bex			4-2 US Meinier GE
FC Hochdorf		1-1 Morobbia	      		[aet; 5-4 pen]
FC Bülach		1-0 FC Schwamendingen
Interclub ZH		2-3 FC Frauenfeld
FC Portalban		3-3 Superga NE			[aet; 4-3 pen]
FC Effretikon		0-1 FC Amriswil


1/32 finals

[Sep 3-4]
Red Star ZH		0-6 Grasshopper-Club
FC Tuggen		1-2 FC Luzern
FC Renens		1-5 Neuchâtel Xamax
Old Boys Basel		1-2 FC Aarau			[aet]
FC Locarno		0-2 FC Lugano
SC Buochs		0-1 AC Bellinzona		[aet]
FC Fribourg		0-6 Servette Genève
FC Raron		0-2 Lausanne-Sports
FC Zürich		1-2 FC St Gallen
FC Basel		4-1 BSC Young Boys Bern
SV Lyss			1-2 FC Wettingen
FC Savièse		2-4 Yverdon-Sport
SR Delémont		2-1 Montreux-Sports
FC Biel-Bienne		0-1 Etoile Carouge
ES Malley		2-0 CS Chênois
FC Châtel-St-Denis	0-2 FC Bulle
FC Portalban		0-6 FC Grenchen
FC Frauenfeld		1-2 FC Schaffausen
FC Vaduz		1-3 FC Glarus
SC Zug			4-1 FC Emmenbrücke
FC Töss			1-0 FC Chur
FC Lerchenfeld		1-4 FC Baden
FC Alstätten SG		1-4 FC Winterthur
FC Bex			2-5 Beauregard Fribourg
FC Colombier		2-4 Stade Lausanne
FC Brugg		3-2 FC Langenthal		[aet]
Morobbia		2-3 Mendrisio
FC Laufen		1-4 FC Solothurn
FC Thun			3-1 FC Suhr
FC Altdorf		1-3 FC Olten
FC Bülach		1-1 FC Amriswil			[aet; 2-4 pen]


1/16 finals

[Nov 12-13]
Yverdon-Sport		2-4 FC Aarau			[aet]
SC Zug			0-2 FC Luzern
FC Amriswil		0-4 AC Bellinzona
Beauregard Fribourg	0-9 FC Sion
Stade Lausanne		0-5 Lausanne-Sports
FC Lugano		2-1 FC Wettingen
Servette Genève		0-2 Neuchâtel Xamax
Grasshopper-Club     	2-1 FC St Gallen
ES Malley		2-1 FC Bulle			[aet]
FC Glarus		0-2 FC Schaffausen
SR Delémont		1-0 Etoile Carouge
FC Solothurn		0-1 FC Grenchen
Mendrisio		0-2 FC Winterthur		[aet]
FC Thun			2-6 FC Baden
FC Töss			0-1 FC Basel
FC Brugg		0-4 FC Olten


1/8 finals

[March 11-12]
FC Aarau		1-1 FC Grenchen			[aet; 4-3 pen]
FC Luzern		2-3 Grasshopper-Club
FC Baden		2-3 FC Lugano	
AC Bellinzona		2-0 Neuchâtel Xamax
FC Sion			2-1 FC Winterthur
Lausanne-Sports		3-0 ES Malley
SR Delémont		0-3 FC Schaffausen
FC Olten		1-2 FC Basel

1/4 finals

[April 12]
FC Lugano		2-0 AC Bellinzona
Lausanne-Sports		1-2 Grasshopper-Club		[aet]
FC Basel		0-2 FC Aarau
FC Schaffausen		0-1 FC Sion


Semifinals

April 18 at Stade de Tourbillon in Sion
FC Sion			0-0 Grasshopper-Club Zürich	[aet; 3-4 pen]

April 18 at Brügglifeld Stadion in Aarau
FC Aarau		3-2 FC Lugano
 [2 Sforza, 64 86 Knup; 69og (Böckli), 80pen Gorter]


Final

May 15 at Wankdorf Stadion in Bern
Grasshopper-Club ZH	2-1 FC Aarau
 [8 51 Halter; 54 Van der Gijp]



Author:
Erik Garin
(garinerik@hispeed.ch)

Last updated: 10 Oct 2006

(C) Copyright Erik Garin and RSSSF 2001/06


  USO DE MEMORIA  
4,314,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1188
Total Execution Time  0.1208
  CADENA URL  
/copa_suiza1989
  GET DATOS  
$_GET['/copa_suiza1989']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_suiza1989'
0.0040  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 = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=1493
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 = 29764 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='1989' 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 11:06:17' 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 11:06:17' 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 11:06:17' 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 11:06:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1989
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (29764) 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.0023  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 (29764) 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 = 1989
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (29764) AND (e.action IN (4,5) ) 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 (29764) 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 = 1989
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (29764) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0133  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 (29764) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0096  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 643 AND l.year = 1989
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (29764) 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 (29764) 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 = 1989 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0017  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 = 1989 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=29764 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 = 29764 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 = 29764 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` = 29764 ORDER BY creation_date DESC LIMIT 0, 10
0.0028  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` = 29764
0.0019  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 `calendars1989` 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` = 29764 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 `events1989` e INNER JOIN calendars1989 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 = 29764 ORDER BY total DESC LIMIT 40
0.0025  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 `events1989` e INNER JOIN calendars1989 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 = 29764 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 `tables1989` 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 = 29764 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 `tables1989` 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 = 29764 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 = 29764 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 = 1989 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=643 AND year=1989