4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2006
Temporada Siguiente »
Publicidad 600x120.gif
LPF Panamá - Clausura 2006
2005/2006

LPF Panamá - Clausura 2006

  • Liga Panamá
Información Histórica 
						

Torneo Clausura

Regular Stage

Final Table:

 1.Tauro FC              18 10  7  1  31-17  37  Qualified
 2.San Francisco FC      18 11  2  5  40-25  35  Qualified
 5.CD Árabe Unido        18 10  3  5  30-20  33  Qualified
 3.Atlético Veragüense   18  9  6  3  22-16  33  Qualified
- - - - - - - - - - - - - - - - - - - - - - - -
 4.CD Plaza Amador       18  9  4  5  25-17  31
 6.Alianza FC            18  8  2  8  29-31  26
 7.Municipal Chorrillo   18  6  6  6  24-23  24
 8.Sporting '89 	 18  4  1 13  17-31  13
 9.Atlético Chiriquí     18  2  4 12  14-30  10
10.CD Policía Nacional 	 18  3  1 14  17-39  10

NB: remaining match apparently not played due to irrelevance

Round 1
[Jul 28]
Atl. Veragüense  1-0 Árabe Unido 
[Jul 29]
Policía Nacional 1-5 San Francisco   
Atl. Chiriquí    1-0 Sporting 89 
Mun. Chorrillo   0-0 Plaza Amador     
[Jul 30]
Tauro            1-1 Alianza

Round 2
[Aug 4]
San Francisco    1-0 Mun. Chorrillo 
[Aug 5]
Árabe Unido      2-3 Tauro
Plaza Amador     0-0 Atl. Veragüense 
Sporting 89      0-0 Policía Nacional
[Aug 6]
Alianza          3-1 Atl. Chiriquí 
     
Round 3
[Aug 11-13]
Atl. Chiriquí    0-2 San Francisco
Árabe Unido      0-0 Mun. Chorrillo
Policía Nacional 1-2 Plaza Amador    
[Aug 13]
Tauro            0-1 Atl. Veragüense
[date?]
Alianza          1-2 Sporting 89

Round 4 
[Aug 18-19]
Plaza Amador     4-1 San Francisco
Atl. Veragüense  0-0 Alianza   
[Aug 19]
Árabe Unido      3-1 Sporting '89
[Aug 20]
Tauro            2-0 Policía Nacional
Mun. Chorrillo   3-2 Atl. Chiriquí

Round 5
[Aug 16?]
Atl. Veragüense  1-2 Sporting '89
[Aug 23?]
Alianza          4-3 Mun. Chorrillo
[Sep 20]
San Francisco    2-1 Árabe Unido
[Sep 27]
Tauro            0-0 Plaza Amador
Atl. Chiriquí    1-3 Policía Nacional

Round 6 [Aug 25-27]
San Francisco    4-5 Tauro   
Alianza          1-2 Árabe Unido
Sporting '89     1-2 Plaza Amador   
Policía Nacional 2-3 Mun. Chorrillo
Atl. Chiriquí    1-1 Atl. Veragüense 

Round 7
[Sep 1]
Árabe Unido      1-0 Atl. Chiriquí
[Sep 2]
Mun. Chorrillo   2-2 Tauro       
Sporting '89     0-1 San Francisco
Atl. Veragüense  1-0 Policía Nacional 
[Sep 3]
Plaza Amador     4-1 Alianza

Round 8
[Aug 9?]
Árabe Unido      3-1 Policía Nacional 
[Sep 13]
Mun. Chorrillo   0-0 Atl. Veragüense
Atl. Chiriquí    0-0 Plaza Amador
[Oct 18]
Sporting '89     0-2 Tauro   
San Francisco    4-0 Alianza 

Round 9
[Sep 9]
Plaza Amador     2-1 Árabe Unido    
Tauro            3-1 Atl. Chiriquí
Mun. Chorrillo   1-0 Sporting '89   
[Sep 10]
Alianza          2-0 Policía Nacional
Atl. Veragüense  2-2 San Francisco   

Round 10 
[sep 15]
San Francisco    3-1 Policía Nacional 
[Sep 16]
Árabe Unido      0-1 Atl. Veragüense 
Sporting '89     4-2 Atl. Chiriquí 
Plaza Amador     2-0 Mun. Chorrillo 
[Sep 17]
Alianza          0-1 Tauro   

Round 11 
[Sep 23]
Atl. Veragüense  2-1 Plaza Amador
Mun. Chorrillo   1-2 San Francisco
Policía Nacional 2-1 Sporting '89
[Sep 24]
Tauro            1-1 Árabe Unido
Atl. Chiriquí    1-2 Alianza   

Round 12 [Sep 30]
Mun. Chorrillo   1-1 Árabe Unido
Plaza Amador     2-0 Policía Nacional
Sporting '89     3-2 Alianza    
Atl. Veragüense  0-1 Tauro   
San Francisco    2-0 Atl. Chiriquí

Round 13 
[Oct 14]
Policía Nacional 1-2 Tauro    
Sporting '89     0-1 Árabe Unido
Atl. Chiriquí    1-2 Mun. Chorrillo
San Francisco    3-1 Plaza Amador
[Oct 15]
Alianza          2-1 Atl. Veragüense

Round 14 
[Aug 2]
Plaza Amador     1-2 Tauro 
[Oct 4]
Árabe Unido      3-1 San Francisco
Sporting '89     2-3 Atl. Veragüense
[Oct 11]
Mun. Chorrillo   1-2 Alianza 
[Oct 18]
Policía Nacional 1-0 Atl. Chiriquí 

Round 15 
[Oct 20]
Plaza Amador     2-1 Sporting '89 
Atl. Veragüense  0-0 Atl. Chiriquí
[Oct 21]
Mun. Chorrillo   3-0 Policía Nacional
Árabe Unido      3-2 Alianza   
Tauro            1-1 San Francisco

Round 16 [Oct 25]
San Francisco    3-0 Sporting '89
Atl. Chiriquí    1-2 Árabe Unido
Tauro            1-1 Mun. Chorrillo
Policía Nacional 2-3 Atl. Veragüense
Alianza          0-2 Plaza Amador 

Round 17 
[Nov 1]
Policía Nacional 2-3 Árabe Unido  
Tauro            3-0 Sporting '89
Plaza Amador     0-1 Atl. Chiriquí 
Atl. Veragüense  3-2 Mun. Chorrillo 
[Nov 2]
Alianza          3-2 San Francisco

Round 18
[Nov 5]
Sporting '89     0-1 Mun. Chorrillo
[Nov 6]
Atl. Chiriquí    1-1 Tauro
[Nov 8]
San Francisco    1-2 Atl. Veragüense
Policía Nacional 0-3 Alianza
[Nov 9]
Árabe Unido      3-0 Plaza Amador  

Final Table:

 1.Tauro FC              18 10  7  1  31-17  37  Qualified
 2.San Francisco FC      18 11  2  5  40-25  35  Qualified
 5.CD Árabe Unido        18 10  3  5  30-20  33  Qualified
 3.Atlético Veragüense   18  9  6  3  22-16  33  Qualified
- - - - - - - - - - - - - - - - - - - - - - - -
 4.CD Plaza Amador       18  9  4  5  25-17  31
 6.Alianza FC            18  8  2  8  29-31  26
 7.Municipal Chorrillo   18  6  6  6  24-23  24
 8.Sporting '89 	 18  4  1 13  17-31  13
 9.Atlético Chiriquí     18  2  4 12  14-30  10
10.CD Policía Nacional 	 18  3  1 14  17-39  10


Semifinals

First Legs [Nov 12]
Árabe Unido      1-2 San Francisco
  [Alberto Cerezo 20; Gabriel Torres 47, Rubén Gamboa 59]
Atl. Veragüense  1-1 Tauro 
  [Erick Quiroz 19; Alberto Skinner 22]

Second Legs [Nov 17]
San Francisco    1-3 Àrabe Unido            [aet]
  [Carlos Rivera; Edgar Tem, Jair Medina, Roberto Goodman 120]
Tauro            2-0 Atl. Veragüense 
  [Héctor Nazarit 89, Rolando Escobar 93]

Final [Nov 25, Estadio Rommel Fernández, Ciudad de Panamá]
Tauro            2-0 Árabe Unido
  [Héctor Nazarith 22, Rolando Escobar 30]
  [Tauro: Oscar McFarlane; Luis Moreno, Rolando Palma, Ubaldo Guardia,
     Luis Henríquez; Dorian López, Juan De Dios Pérez, Rolando Escobar
     (Williams Aguilar 65), Reggie Arosemena; Alberto Skinner (Richard
     Dixon, 72), Héctor Nazarith (Edwin Aguilar 22); coach: Rubén Guevara;
   Árabe Unido: Johan Cerón; Reynaldo Anderson (Roberto Goodman 70),
     Nahir Miranda, Edgar Tem, Nahil Carroll; Amílkar Henríquez, Víctor
     Castillo (Antony Basile 46), Julio Medina III, René Mendieta Jr.;
     Alberto Cerezo (Armando Cooper 46), Orlando Rodríguez; coach: Winston
     Cifuentes]

Championship Final [Dec 3, Estadio Rommel Fernández, Ciudad de Panamá]
Tauro            0-1 San Francisco
  [Alberto Zapata 73]
  [Tauro: Oscar McFarlane; Rolando Palma, Ubaldo Guardia, Luis Moreno, 
     Víctor Suárez, Juan de Dios Pérez, Dorian López, Rolando Escobar
     (Brunet Hay 78), Reggie Arosemena, William Aguilar (Joan Melo 74),
     Alberto Skinner (Edwin Aguilar 67); coach: Rubén Guevara;
   San Francisco: William Negrete; Eduardo Jiménez, Santiago De Alba, 
     Raúl Loo, Carlos Rivera, Rubén Gamboa (Víctor Herrera 61),
     Juan Ramón Solís, Manuel Torres, Gabriel Torres, Ricardo Phillips,
     Alberto Zapata (West Torres 84); coach: Gary Stempel;
   ref: Rolando Vidal]


Aggregate Table:

 1.Tauro FC              36 20 12  4  56-31  72
 2.San Francisco FC      36 18 10  8  60-36  64
 3.CD Plaza Amador       36 18  8 10  55-35  62
 4.Atlético Veragüense   36 15 12  9  47-43  57
 5.CD Árabe Unido        36 13 13 10  45-38  52
 6.Alianza FC            36 15  5 16  51-53  50
 7.Municipal Chorrillo   36 11 15 10  44-40  48
 8.Sporting '89          36 12  7 17  36-44  43
 9.Atlético Chiriquí     36  6 10 20  32-59  28
-----------------------------------------------
10.CD Policía Nacional   36  3  6 27  27-74  15  Relegated



Author: Adán De Gracia
(adandg@hotmail.com)

Last updated: 2 Mar 2007

(C) Copyright Adán De Gracia and RSSSF 2006/07


  USO DE MEMORIA  
4,248,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.6002
Total Execution Time  0.6026
  CADENA URL  
/clausura_panama2006
  GET DATOS  
$_GET['/clausura_panama2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0126  SELECT type FROM routes WHERE alias = 'clausura_panama2006'
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_panama' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 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=151 AND type_rel = 3
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 151 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 (1261468,1215925,1201997,1201704,1194763) ORDER BY n.cover_points DESC, update_date DESC
0.0129  SELECT text_es as historical_text FROM leagues_text WHERE id=1095
0.0125  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 = 29409 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=150 ORDER BY l.group_code ASC
0.0128  SELECT type,rule FROM rules WHERE categoryId = 151 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:02:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:02:07' 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=4 AND last_update > '2024-04-27 17:02:07' 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=3 AND last_update > '2024-04-27 17:02:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0143  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_panama' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29409) 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.0158  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 (29409) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29409) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (29409) 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 events2006 e WHERE e.league_id IN (29409) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (29409) 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 events2006 e WHERE e.league_id IN (29409) AND (e.action IN (22) ) 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 (29409) 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 = 29409 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 29409 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0129  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=29409 AND rel.round=18
0.0139  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 = 29409 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0133  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 = 29409 AND esl.points > 0
0.0130  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` = 29409 ORDER BY creation_date DESC LIMIT 0, 10
0.0138  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` = 29409
0.0128  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 `calendars2006` 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` = 29409 AND c.`round` = 18 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 `events2006` e INNER JOIN calendars2006 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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 29409 ORDER BY total DESC LIMIT 40
0.0133  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 `events2006` e INNER JOIN calendars2006 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 = 29409 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0129  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 `tables2006` 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 = 29409 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 29409 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 29409 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0129  SELECT data1, data2 FROM services_tags WHERE categoryId=151
0.0129  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 151 AND l.year = 2006 ORDER BY l.group_code ASC
0.0129  SELECT group_code, extraName from `leagues` WHERE categoryId=151 AND year=2006