4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1999
Temporada Siguiente »
Publicidad 600x120.gif
Clausura Paraguay 1999
1998/1999

Clausura Paraguay 1999

Información Histórica 
						


Clausura

Table:

 1.Cerro Porteño          10  7  1  2 25- 8 22
 2.Sportivo Luqueño       10  5  3  2 22-14 18
 3.Olimpia                10  4  5  1 13- 9 17
 4.San Lorenzo            10  3  7  0 11- 8 16
 5.12 de Octubre          10  3  7  0 16-10 16  [Itaugua]
 6.Guaraní                10  2  6  2 13-15 12
 7.Presidente Hayes       10  2  6  2  6- 8 12  [-]
 8.Atlético Colegiales    10  2  3  5  9-12  9
 9.Cerro Corá             10  2  3  5 10-16  9
 - - - - - - - - - - - - - - - - - - - - - - -
10.Sol de América         10  1  3  6  5-13  6
11.Resistencia            10  1  2  7  4-21  5

NB: 4th/5th place and 8th/9th place decided by draw.
 
[-] not eligible for Liguilla due to relegation

Round 1 (Jul 25)
Guarani     1-1 Olimpia  
Colegiales  1-1 San Lorenzo  
Sol         0-1 P. Hayes 
Sp. Luqueño 3-0 Resistencia  
12 Octubre  0-0 Cerro Porteño  
bye: Cerro Cora

Round 2 (Aug 1)
P. Hayes    0-0 Guarani  
Resistencia 0-0 Sol de America  
Cerro Cora  1-0 Colegiales
Olimpia     1-1 12 de Octubre  
Sp. Luqueño 3-3 San Lorenzo  
bye: Cerro Porteño
 
Round 3 (Aug 8)
Olimpia     2-1 Colegiales  
12 Octubre  1-1 Sol de America  
Resistencia 0-0 San Lorenzo
P. Hayes    1-1 Cerro Cora  
Sp. Luqueño 3-1 Cerro Porteño
bye: Guarani

Round 4 (Aug 15)
P. Hayes    0-2 Cerro Porteño  
Resistencia 0-2 12 Octubre 
Cerro Cora  1-2 Sol    
San Lorenzo 1-1 Guarani   
Colegiales  2-1 Sp. Luqueño 
bye: Olimpia

Round 5 (Aug 22)
Guarani     2-2 Cerro Cora  
Olimpia     1-1 P.Hayes  
Sol         0-0 Colegiales
12 Octubre  1-1 San Lorenzo  
C. Porteño  8-1 Resistencia  
bye: Sp.Luqueño

Round 6 (Aug 29)
Cerro Cora  1-1 12 de Octubre 
Colegiales  2-2 Guaraní  
Sp.Luqueño  3-1 Sol de America 
San Lorenzo 1-0 Cerro Porteño  
Olimpia     2-0 Resistencia  
bye: Presidente Hayes

Round 7 (Sep 5)
C. Porteño  4-1 Cerro Cora 
12 Octubre  2-0 Colegiales  
P. Hayes    2-0 Resistencia 
Guaraní     0-3 Sp.Luqueño  
San Lorenzo 1-1 Olimpia  
bye: Sol de America

Round 8 (Sep 12)
Olimpia     3-0 Cerro Cora  
San Lorenzo 0-0 P.Hayes  
Sp.Luqueño  3-5 12 de Octubre 
Sol         0-1 Guarani  
Colegiales  0-1 Cerro Porteño  
bye: Resistencia

Round 9 (Sep 19)
Resistencia 1-2 Guarani 
San Lorenzo 2-1 Sol    
P.Hayes     1-1 12 de Octubre
Sp.Luqueño  2-1 Cerro Cora
Olimpia     0-3 Cerro Porteño
bye: Colegiales

Round 10 (Sep 26)
Sol         0-3 Cerro Porteño
Sp.Luqueño  1-1 Olimpia
Cerro Cora  2-0 Resistencia
Colegiales  3-0 P.Hayes
Guarani     2-2 12 de Octubre
bye: San Lorenzo

Round 11 
(Oct 1)
Sol         0-1 Olimpia     
(Oct 3)
C. Porteño  3-2 Guarani
P.Hayes     0-0 Sp.Luqueño
San Lorenzo 1-0 Cerro Cora
Resistencia 2-0 Colegiales
bye: 12 de Octubre

Table:

 1.Cerro Porteño          10  7  1  2 25- 8 22 
 2.Sportivo Luqueño       10  5  3  2 22-14 18  
 3.Olimpia                10  4  5  1 13- 9 17
 4.San Lorenzo            10  3  7  0 11- 8 16
 5.12 de Octubre          10  3  7  0 16-10 16  [Itaugua]
 6.Guaraní                10  2  6  2 13-15 12
 7.Presidente Hayes       10  2  6  2  6- 8 12  [-]
 8.Atlético Colegiales    10  2  3  5  9-12  9
 9.Cerro Corá             10  2  3  5 10-16  9
 - - - - - - - - - - - - - - - - - - - - - - -
10.Sol de América         10  1  3  6  5-13  6
11.Resistencia            10  1  2  7  4-21  5
 
NB: 4th/5th place and 8th/9th place decided by draw.

[-] not eligible for Liguilla due to relegation

Liguilla

Tables:

Group A

 1.Cerro Porteño           2  1  1  0  5- 2  7   [3,0]
 2.San Lorenzo             2  1  0  1  3- 5  4,5 [1,5]
 3.Cerro Corá              2  1  1  0  4- 2  4   [0,0]
 4.Guaraní                 2  0  0  2  2- 5  0,5 [0,5]

Group B:

 1.Sportivo Luqueño        2  1  1  0  4- 2  6,5 [2,5]
 2.Olimpia                 2  1  0  1  4- 3  5   [2,0]
 3.12 de Octubre           2  1  1  0  2- 1  5   [1,0]  [Itaugua]
 4.Atlético Colegiales     2  0  0  2  0- 4  0   [0,0]

Round 1
[Oct 8]
Cerro C     2-0 Guarani
Cerro P     3-0 S Lorenzo
[Oct 9]
12 Octubre  1-0 Colegiales
Luqueno     3-1 Olimpia

Round 2
[Oct 23]
Sp.Luqueño  1-1 12 de Octubre  
Olimpia     3-0 Colegiales
[Oct 24]
C. Porteño  2-2 Cerro Corá  
San Lorenzo 3-2 Guaraní

Round 3 [Oct 31]
C. Porteño  1-0 Guarani  
Cerro Cora  2-1 San Lorenzo   [appeal by San Lorenzo on claim of ineligible
Olimpia     1-0 12 de Octubre       player Cerro Cora; apparently rejected]
Sp. Luqueño 1-2 Colegiales

Tables:

Group A

 1.Cerro Porteño           3  2  1  0  6- 2 10   [3,0]
 2.Cerro Corá              3  2  1  0  6- 3  7   [0,0]
 3.San Lorenzo             3  1  0  2  4- 7  4,5 [1,5]
 4.Guaraní                 3  0  0  3  2- 6  0,5 [0,5]

Group B:

 1.Olimpia                 3  2  0  1  5- 3  8   [2,0]
 2.Sportivo Luqueño        3  1  1  1  5- 4  6,5 [2,5]
 3.12 de Octubre           3  1  1  1  2- 2  5   [1,0]  [Itaugua]
 4.Atlético Colegiales     3  1  0  2  2- 5  3   [0,0]

Semifinals [Nov 7]
C. Porteño  1-1 Sp.Luqueño  [4-3 pen]
Olimpia     0-1 Cerro Corá

Clausura Final

First Leg [Nov 14]
Cerro Corá  0-3 Cerro Porteño
  [Campos, Alvarenga, Cohener]

Second Leg [Nov 21]
C. Porteño  2-1 Cerro Corá
  [Cohener, Román; Pérez (pk)]

Cerro Porteño wins Clausura 1999.


Playoff for Third Libertadores Place [Nov 26]
Cerro Corá  1-2 Colegiales


Championship Final

First Leg [Nov 28]
Olimpia     1-0 Cerro Porteño
  [Valdez]

Second Leg [Dec 5]
C. Porteño  2-3 Olimpia
  [Osvaldo Peralta 15, Juan Manuel Sara 30; Carlos Paredes 40,
   Virginio Cáceres 60, Walter Avalos (pen) 90]

Olimpia champions of Paraguay 1999.


Overall Table:
 
 1.Olimpia                20 12  7  1 39-17 43
 2.Cerro Porteño          20 12  5  3 46-20 41 
 3.Sportivo Luqueño       20 11  6  3 44-27 39
 4.San Lorenzo            20  6 11  3 26-22 29
 5.Guaraní                20  6 10  4 29-27 28
 6.12 de Octubre          20  5 12  3 27-22 27  [Itaugua]
 7.Atlético Colegiales    20  6  4 10 25-31 22
 8.Sol de América         20  5  6  9 18-22 21
 9.Cerro Corá             20  4  6 10 27-39 18
 - - - - - - - - - - - - - - - - - - - - - - -
10.Presidente Hayes       20  2 10  8 16-30 16
11.Resistencia            20  1  3 16 10-50  6

NB: Presidente Hayes and Resistencia are relegated.


División Intermedia 1999

Liguilla Final

Round 5 (August 22)
Sport Colombia 2-4 Universal Encarnación  
Sportivo Iteño 1-2 Nacional Asunción

Table:

 1.Universal Encarnación      5  4  1  0     13  Promoted
 2.Nacional Asunción          5  3  0  2      9
 3.Sport Colombia             5  2  0  3      6
 4.Sportivo Iteño             5  0  1  4      1



NB: in a regional league, two teams tied on points tried to improve their
    goal difference in the last round:

    24 de Julio 35-0 Boqueirón
    30 de Abril 73-0 Oriental

    The local FA intends to investigate the case (and 24 de Julio and
    30 de Abril are to play off for the local championship).


Authors: Roberto Lahsen
(rlahsen@entelchile.net),
José Batalha
and Tony Mariani
(pito_loco54@hotmail.com)

Last updated: 7 Mar 2000

(C) Copyright Roberto Lahsen, José Batalha,
Tony Mariani and RSSSF 1999/2000

INFORMACIÓN

Campeonato clausura 2009.


El Torneo Clausura 2009 (Copa Tigo, por motivos comerciales), denominado "Campeones de América - 1953",1 fue el centésimo primer campeonato oficial de Primera División organizado por la Asociación Paraguaya de Fútbol (APF). Se inició el sábado, 25 de julio, y finalizó el domingo, 13 de diciembre.2
Se consagró campeón, por haber sumado la mayor cantidad de puntos al cabo de las 22 fechas, el club Nacional, por séptima vez en su historia

  USO DE MEMORIA  
4,286,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5774
Total Execution Time  0.5793
  CADENA URL  
/clausura_paraguay1999
  GET DATOS  
$_GET['/clausura_paraguay1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'clausura_paraguay1999'
0.0255  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_paraguay' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=51 AND type_rel = 3
0.0133  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 51 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1266545,1250089,1246437,1243405,1241269) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=1244
0.0126  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 = 29524 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=44 ORDER BY l.group_code ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 09:13:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 09:13:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 09:13:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 09:13:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0142  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_paraguay' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0133  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29524) 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.0131  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 (29524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29524) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (29524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29524) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (29524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29524) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0126  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 (29524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 29524 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0126  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 = 29524 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0130  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=29524 AND rel.round=10
0.0131  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 = 29524 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0134  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 = 29524 AND esl.points > 0
0.0128  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` = 29524 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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` = 29524
0.0126  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 `calendars1999` 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` = 29524 AND c.`round` = 10 ORDER BY shedule ASC LIMIT 200
0.0125  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 `events1999` e INNER JOIN calendars1999 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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 29524 ORDER BY total DESC LIMIT 40
0.0129  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 `events1999` e INNER JOIN calendars1999 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 = 29524 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
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,team.teamId FROM `tables1999` 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 = 29524 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 29524 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 29524 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0131  SELECT data1, data2 FROM services_tags WHERE categoryId=51
0.0131  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 51 AND l.year = 1999 ORDER BY l.group_code ASC
0.0131  SELECT group_code, extraName from `leagues` WHERE categoryId=51 AND year=1999