4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Regular Season

Final Table:

 1.Aguila                 36 18 13  5  67- 33 67
 2.Alianza                36 18 10  8  61- 40 64
 3.Deportivo FAS          36 16 12  8  66- 45 60
 4.Luis Angel Firpo       36 14 11 11  54- 52 53
 5.Atlético Arabe Marte   36 14 10 12  64- 65 52
 6.AD El Tránsito         36 13  9 14  54- 63 48
------------------------------------------------
 7.Dragón                 36 11 12 13  49- 52 45
 8.El Roble               36 11 12 13  57- 61 45
 9.Municipal Limeño       36 10 11 15  49- 55 41
------------------------------------------------
10.Once Lobos             36  1  8 27  46-101 11  Relegated

First six teams qualified for second stage (knock out).

Round 1 [Sep 1]
Dragon     5-1 El Roble
FAS        3-1 Marte
Alianza    3-1 LA Firpo
Mun Limeno 1-0 Aguila
ADET       4-2 Once Lobos   

Round 2 [Sep 8,11]
LA Firpo   1-1 FAS
El Roble   3-1 Mun Limeno
Once Lobos 2-3 Dragon
Marte      2-1 ADET
Aguila     0-0 Alianza

Round 3 [Sep 14,15]
LA Firpo   0-1 Aguila 
FAS        3-2 ADET
Dragon     2-2 Marte 
Alianza    2-0 El Roble 
Mun Limeno 2-2 Once Lobos 

Round 4 [Sep 21,22]
Aguila     2-1 FAS
ADET       1-1 Dragon
El Roble   0-0 LA Firpo
Marte      2-1 Mun Limeno  
Once Lobos 1-2 Alianza

Round 5 [Sep 28,29]
FAS        1-1 Dragon
LA Firpo   5-4 Once Lobos
Alianza    2-2 Marte 
Aguila     3-1 El Roble
Mun Limeno 2-2 ADET 

Round 6 [Oct 5,6]
Marte      1-5 LA Firpo
Once Lobos 1-1 Aguila
El Roble   0-0 FAS
Alianza    0-4 ADET
Dragon     1-1 Mun Limeno

Round 7 [Oct 19,20]
Aguila     1-0 Marte
LA Firpo   2-2 ADET
Alianza    4-0 Dragon
El Roble   0-0 Once Lobos
FAS        2-1 Mun Limeno

Round 8 [Oct 26,27]
FAS        2-1 Once Lobos
Dragon     2-0 LA Firpo
Aguila     7-0 ADET
Marte      1-2 El Roble
Mun Limeno 0-1 Alianza

Round 9 [Nov 2,3]
Alianza    2-1 FAS
LA Firpo   1-1 Mun Limeno
Aguila     2-0 Dragon
El Roble   4-2 ADET
Once Lobos 1-2 Marte

Round 10 [Nov 16,17]
Marte      2-2 FAS
El Roble   2-2 Dragon
Once Lobos 0-2 ADET
Aguila     2-0 Municipal   
LA Firpo   1-0 Alianza

Round 11 [Nov 23,24]
FAS        6-0 LA Firpo
Alianza    1-1 Aguila
Mun Limeno 0-3 El Roble
Dragon     2-1 Once Lobos
ADET       0-1 Marte

Round 12 
[Dec 1]
Aguila     4-1 LA Firpo
FAS        2-0 ADET
Mun Limeno 2-2 Once Lobos
[Dec 4]
Marte      0-3 Dragon      
[Dec 5]
Alianza    1-1 El Roble    

Round 13 
[Dec 8]
Once Lobos 0-3 Alianza
Mun Limeno 4-1 Marte
LA Firpo   3-0 El Roble
Dragon     0-1 ADET  
[Dec 11]
FAS        2-0 Aguila      

Round 14 [Dec 15]
Dragon     1-1 FAS
Once Lobos 1-1 LA Firpo
ADET       1-1 Municipal
El Roble   0-3 Aguila  
Marte      1-2 Alianza 

Round 15 [Dec 21,22,23]
Aguila     4-1 Once Lobos
LA Firpo   1-1 Marte
FAS        1-1 El Roble
Alianza    1-2 ADET 
Mun Limeno 3-0 Dragon 

Round 16 [Dec 29,31]
ADET       1-0 LA Firpo
Marte      6-4 Aguila 
Dragon     1-2 Alianza 
Once Lobos 1-1 El Roble
Mun Limeno 2-2 FAS

Round 17 [Jan 4,5,8]
Marte      2-2 El Roble 
Alianza    2-3 Mun Limeno 
FAS        5-3 Once Lobos
LA Firpo   1-0 Dragon 
Aguila     7-2 ADET 

Round 18 [Jan 11,12]
FAS        1-1 Alianza 
Mun Limeno 4-1 LA Firpo 
Marte      5-0 Once Lobos 
ADET       2-1 El Roble 
Dragon     0-1 Aguila 

Round 19 [Jan 19]
Mun Limeno 1-1 Aguila 
ADET       2-1 Once Lobos
FAS        0-0 Marte
Alianza    0-1 LA Firpo
Dragon     0-1 El Roble

Round 20 [Jan 26]
Marte      3-3 ADET
Aguila     1-0 Alianza 
El Roble   2-1 Mun Limeno
LA Firpo   1-1 FAS
Dragon     2-1 Once Lobos

Round 21 [Feb 2]
FAS        1-3 ADET 
LA Firpo   1-1 Aguila
Alianza    3-2 El Roble
Mun Limeno 2-1 Once Lobos
Dragon     1-1 Marte

Roudn 22 [Feb 9]
Aguila     0-3 FAS
El Roble   2-1 LA Firpo
ADET       2-0 Dragon 
Alianza    3-3 Once Lobos
Mun Limeno 2-1 Marte

Round 23 [Feb 16]
Aguila     1-1 El Roble
FAS        1-1 Dragon
Alianza    2-0 Marte
LA Firpo   3-1 Once Lobos
Mun Limeno 1-0 ADET

Round 24 [Feb 23]
ADET       0-1 Alianza
Aguila     2-1 Once Lobos
Marte      4-1 LA Firpo
El Roble   2-1 FAS
Dragon     1-1 Mun Limeno

Round 25 
[Mar 2]
El Roble   2-0 Once Lobos
Alianza    3-4 Dragon         
FAS        2-1 Mun Limeno
LA Firpo   3-1 ADET
[Mar 5]
Marte      0-2 Aguila         

Round 26 [Mar 8,9]
Dragon     0-1 LA Firpo
FAS        0-1 Once Lobos
Mun Limeno 0-2 Alianza
Marte      2-1 El Roble
Aguila     2-0 ADET

Round 27 
[Mar 16]
LA Firpo   0-1 Mun Limeno     
[Mar 23]
Alianza    0-1 FAS
Aguila     2-2 Dragon
El Roble   2-2 ADET
Once Lobos 1-2 Marte

Round 28 [Apr 6]
Aguila     3-0 Mun Limeno
LA Firpo   0-0 Alianza
Once Lobos 3-8 ADET
El Roble   1-3 Dragon
Marte      5-3 FAS

Round 29 [Apr 13]
Alianza    1-1 Aguila
Dragon     2-1 Once Lobos
Mun Limeno 1-4 El Roble
ADET       0-0 Marte
FAS        1-2 LA Firpo

Round 30 [Apr 20]
Aguila     1-1 LA Firpo
ADET       0-4 FAS
El Roble   1-1 Alianza
Marte      1-0 Dragon
Once Lobos 0-5 Mun Limeno

Round 31 [Apr 26,30]
Marte      2-2 Mun Limeno
LA Firpo   3-1 El Roble
Dragon     1-0 ADET
FAS        1-0 Aguila
Alianza    4-2 Once Lobos  

Round 32 [May 3,4]
Dragon     4-0 FAS
LA Firpo   2-1 Once Lobos
El Roble   2-2 Aguila       
Marte      1-2 Alianza      
ADET       1-0 Mun Limeno    

Round 33 [May 10,11]
FAS        3-2 El Roble
Aguila     2-2 Once Lobos
Mun Limeno 1-1 Dragon
Alianza    3-0 ADET
LA Firpo   1-2 Marte

Round 34 [May 18,21]
Aguila     3-0 Marte
ADET       0-0 LA Firpo
Dragon     1-3 Alianza
Once Lobos 1-5 El Roble
Mun Limeno 0-1 FAS

Round 35 [May 25]
Aguila     0-0 ADET
Alianza    2-0 Mun Limeno
LA Firpo   6-2 Dragon
Once Lobos 0-5 FAS
El Roble   2-4 Marte

Round 36
LA Firpo   3-1 Mun Limeno
FAS        2-2 Alianza
Dragon     0-0 Aguila
ADET       3-2 El Roble
Marte      4-3 Once Lobos

Final Table:

 1.Aguila                 36 18 13  5  67- 33 67
 2.Alianza                36 18 10  8  61- 40 64
 3.Deportivo FAS          36 16 12  8  66- 45 60
 4.Luis Angel Firpo       36 14 11 11  54- 52 53
 5.Atlético Arabe Marte   36 14 10 12  64- 65 52
 6.AD El Tránsito         36 13  9 14  54- 63 48
------------------------------------------------
 7.Dragón                 36 11 12 13  49- 52 45
 8.El Roble               36 11 12 13  57- 61 45
 9.Municipal Limeño       36 10 11 15  49- 55 41
------------------------------------------------
10.Once Lobos             36  1  8 27  46-101 11  Relegated

Promoted: Atlético Arabe Marte [from Soyapango]

Repechaje [best of 3]: 

First Leg [Jun 22]
Municipal Limeno   0-1 Real Independiente [annulled]

Limeño protested because of the fact that Germán Pérez
played for Independiente but was signed illegally.  The 
federation complied with the protest.  A new series of 
two matches was decided upon:

First Leg [Aug 1]
Real Independiente 0-0 Municipal Limeno   [in Cuscatlán]

Second Leg [Aug 5]
Municipal Limeno   5-0 Real Independiente [in San Miguel]

Municipal Limeño remain in first division.


First six teams qualified for second stage (knock out).

Aguila crowned as winners of ''Copa de El Salvador'' (by virtue
of winning this first stage).


Semifinals

First Legs
[Jun 22]
Alianza    2-0 Aguila
[Jul 2]
LA Firpo   1-0 Marte

Final

First leg [Jul 20]
LA Firpo   0-0 Alianza


Author: Mikael Jönsson

Last updated: 28 Mar 2008

(C) Copyright Mikael Jönsson and RSSSF 1999/2008


  USO DE MEMORIA  
4,293,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1071
Total Execution Time  0.1092
  CADENA URL  
/apertura_primera_division_el_salvador1997
  GET DATOS  
$_GET['/apertura_primera_division_el_salvador1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_primera_division_el_salvador1997'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_division_el_salvador' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=159 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 159 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1256670,1256493,1255700,1202287,1197144) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=648
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 = 28971 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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='1997' WHERE c.parentId=159 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 19:13:52' 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 19:13:52' 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 19:13:52' 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 19:13:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_division_el_salvador' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28971) 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.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 (28971) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28971) 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 (28971) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28971) AND (e.action IN (3,4) ) 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 (28971) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (28971) 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 (28971) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT 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.league_id = 28971 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0021  SELECT 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.league_id = 28971 AND rp.events > 0 ORDER BY rp.events 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=28971 AND rel.round=36
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 = 28971 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 = 28971 AND esl.points > 0
0.0037  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` = 28971 ORDER BY creation_date DESC LIMIT 0, 10
0.0026  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` = 28971
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 `calendars1997` 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` = 28971 AND c.`round` = 36 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 `events1997` e INNER JOIN calendars1997 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 = 36 AND e.real_date IS NOT NULL AND e.league_id = 28971 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 `events1997` e INNER JOIN calendars1997 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 = 28971 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 `tables1997` 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 = 28971 AND t.round = 34 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 `tables1997` 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 = 28971 AND t.round = 36 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 = 28971 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=159
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 159 AND l.year = 1997 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=159 AND year=1997