4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2009
Temporada Siguiente »
Publicidad 600x120.gif
Liga Islas Caimán 2009
2008/2009

Liga Islas Caimán 2009

Información Histórica 
						

CIFA Premier League 2008/09

Final Table:

 1.Elite SC                    21 12  5  4 39-34 41  Champions
 2.George Town SC              21 10  7  4 36-24 37
 3.Scholars International FC   21  8  8  5 36-25 32
 4.Sunset FC                   21  8  6  7 43-39 30
 5.Latinos FC                  21  6  8  7 31-34 26
 6.Future SC                   21  6  5 10 28-32 23
- - - - - - - - - - - - - - - - - - - - - - - - - -
 7.Tigers FC                   21  5  5 11 39-51 20  Relegation Playoff
---------------------------------------------------
 8.Roma FC                     21  5  4 12 24-37 19  Relegated

Round 1 [Oct 19]
Elite            1-0 Latinos
  [Gabriel Godet 53]
Tigers           1-0 Roma
  [Carlos Garcia 87]
Sunset           1-0 Future
  [Tom Elliot 70]
George Town      0-0 Scholars

Round 2 [Oct 26]
Scholars         3-2 Tigers 
Latinos          2-2 George Town   
Roma             0-2 Sunset  
Elite            0-0 Future 

Round 3 
[Nov 2]
Sunset           3-2 George Town
  [Declan Cassidy 39, Gareth Thacker 44, Eric Brown 48;
   Jermaine Seymour 1, 52]
Roma             1-2 Elite
  [Dunk Marlon 26; Arden Rivers 3, 65]
Scholars         0-1 Latinos
  [Victor Chicas 3]
[Nov 9?]
Future           3-1 Tigers

Round 4 [Nov 23]
Roma             0-0 Scholars
George Town      2-3 Elite 
  [Justin Pierre 40, Donald Solomon Jr 74; Dave Mclaughlin 43,
   Calvin Jefford 81, Arden Rivers 90]
Tigers           1-1 Sunset
  [Carlos Garcia 27; Declan Cassidy 42]
Latinos          0-2 Future
  [Mark Ebanks 48, 84]

Round 5 [Nov 30]
Roma             1-3 George Town
  [Dwayne Smith 87; Justin Pierre 15, 67, Garth Anderson 20]
Tigers           2-3 Elite
  [Carlos Powery 7pen, 63; Gabriel Godet 14, Arden Rivers 18,
   Jason Ebanks 21]
Scholars         2-1 Future
Latinos          1-3 Sunset
  [Allean Grant 7; Eric Brown 18, 73, Chris Brown 44]

Round 6 [Dec 14]
Future           2-1 Roma
  [? 1-0, ? 2-0; Gary Blake 68]
Elite            2-2 Scholars
  [Hank Parchment 15, Arden Rivers 65; Nahun Rodriquez 4,
   Fabian Malcolm 17]
George Town      3-2 Sunset 
  [Tex Whitelocke 27, Lee Ramoon 36, Garth Anderson 88;
   Eric Brown 29, 77]
Latinos          2-0 Tigers
  [Armando Mejia 67, Victor Chicas 88]

Round 7 [Jan 4]
Tigers           0-4 Scholars
  [Mario Watler 31, Fabian Malcolm 53, Lennox Bryan 82,
   O'Neil Taylor 87]
George Town      2-1 Future
  [Mitchie Williams 7, Lee Ramoon 54; Dion Brandon 77]
Roma             1-1 Latinos
  [Wayne Smith 62; Victor Chicas 43]
Sunset           3-3 Elite
  [Chris Brown 40pen, Carlton Black 73, ? 75;
   Calvin Jefford 4pen, 30, Arden Rivers 87]

Round 8 [Jan 11]
Roma             1-0 Future
  [Philbert Ross 27]
Tigers           1-3 George Town
  [Gabre Dickens; Garth Anderson 13, 35, Justin Pierre 50]
Latinos          3-5 Elite
  [Allean Grant 26, Luis Jose Bush 32, Alfredo Challenger 90;
   Rene Carter 18, Donavan Godet 33, 65, Jairo Sanchez 49, 
   Calvin Jefford 76]
Scholars         1-0 Sunset
  [David Harding]

Round 9 [Jan 25]
Elite            2-2 Tigers
  [Hank Parchment 45, ? 80; Everton Parker 19, ? 61]
Future           0-2 Sunset        
  [Roy Forbes 33, Gareth Thacker 72]
George Town      0-0 Roma
Latinos          2-4 Scholars  
  [Jose Bush 37, Victor Chicas 48; Nahun Rodriquez 25, 
   Fabian Malcolm 69, 90, O'Neil Taylor 89]

Round 10 [Feb 1]
Sunset           5-4 Tigers
  [Chris Brown 18, 36, 51, Gareth Thacker 85, Roy Forbes 87;
   Carlos Powery 39, 88, Tony Carter ~45, Everton Parker 53]
Future           1-1 Scholars
  [Ormond Moore 1-1; David Harding 52]
Elite            3-1 Roma
  [Derrin Ebanks 40, 88, Jairo Sanchez 53; Wayne Smith 87]
George Town      2-2 Latinos           
  [own goal 64, Justin Pierre 77; Allean Grant 79, Victor Chicas 85]

Round 11 [Feb 8]
Latinos          4-2 Roma     
  [Alfredo Challenger 26pen, Victor Chicas 33, Marlon Moore 54,
   Allean Grant 90pen; Wayne Smith 16, Damalay Howelle 79]    
Tigers           4-3 Future  
  [Carlos Powery 9, 27, 60, Kirk Rowe 87; ?, ?, ?]    
Scholars         0-1 Elite     
  [Rene Carter 84]        
George Town      2-1 Sunset  
  [Justin Pierre 24, Bryan Sheldon 33; Chris Brown 34]          

Round 12 [Feb 15]
Sunset           1-1 Roma
  [Thomas Elliott 51; Damaley Howelle 38]
Future           1-2 Elite  
  [James Ebanks 84; Gabriel Godet 16, Donavan Godet 78]
Tigers           0-1 Latinos
  [Luis Bust 43]
Scholars         1-1 George Town      
  [Chris Douglas 28; Lee Ramoon 61]

Round 13 [Feb 22]
Roma             2-6 Tigers
  [Wayne Smith 33, Desmond Wright 85; Norman Montoya 62,
   Carlos Powery 65, 72, Kirk Rowe 78, Everton Parker 80,
   Rolly Bodden 83]
Future           2-1 Latinos
  [Mark Ebanks 4, 15; f Alfredo Challenger 90+3]
Sunset           2-2 Scholars
  [Eric Brown 68, Roy Forbes  85; David Harding 15,
   Fabian Malcolm 72]
Elite            2-1 George Town
  [Donavan Godet 62, Arden Rivers 85; Lee Ramoon 40]

Round 14 [Mar 1]
Tigers           1-3 Elite
  [? 77; Gabriel Godet 39, Calvin Jefford 68, ? 89]
Sunset           2-2 Latinos
  [Eric Brown 67, 81; ? 0-1, ? 84]
George Town      3-0 Future
  [Lee Ramoon 21, 51, Ormond Moore 27]
Scholars         3-0 Roma 
  [Nikolai Hill 24, Lorenzo Brown 74, Lennox Bryan 82]

Round 15 [Mar 15]
George Town      3-0 Tigers  
  [Donald Solomon 16, Jessus Ebanks 29, Lee Ramoon 77]  
Elite            1-2 Sunset  
  [Calvin Jefford 56; Eric Brown 5, 40pen]
Future           3-0 Roma            
  [Demion Williams 28, Otis Miles 30, Paul Brown 72]
Scholars         1-1 Latinos 
  [Nahun Rodriquez 31; Victor Chicas 64]        

Round 20 
[Mar 25]
Elite            2-2 Latinos 
Tigers           0-3 Roma    
[Mar 26]
Future           4-3 Sunset  
George Town      1-0 Scholars   

Round 16 [Mar 29]
Roma             0-1 Elite         
  [Donavan Godet 85]  
Scholars         1-1 Future    
  [O'Neil Taylor 65; ? 47]      
George Town      0-0 Latinos         
Tigers           3-3 Sunset 
  [Lende Carter 30, 33, Kirk Rowe 59; Gareth Thacker 45,
   Chris Ordolis 72, Chris Day 75]    

Round 17 [Apr 5]
Latinos          0-3 Tigers         
  [Montoya 14, Carlos Powery 48pen, 80]
Roma             3-1 George Town 
  [Philbert Ross 1-0, 39, 90; Garth Anderson 78]    
Elite            2-1 Future          
Scholars         2-1 Sunset 
  [Leon Whittaker 32, 87; Chris Ordolis 47]         

Round 18 [Apr 19]
Scholars         4-5 Tigers    
  [Nikolai Hill 48, Daina Heaven 56, 77, Mario Watler 82;
   Everton Parker 3, 69, Carlos Powery 5, 60, Kirk Rowe 61]
Latinos          2-0 Roma      
  [lfredo Challenger (pen), Victor Chicas (pen)] 
Sunset           3-0 Elite   
  [Eric Brown 32, Chris Ordolis 54, 62]   
Future           0-2 George Town  
  [Charles Rowe 63, Garth Anderson 80]

Round 21 
[Apr 16?]
Sunset           2-4 Roma   
Latinos          1-1 Future     
[Apr 21?]
Elite            0-5 Scholars 
[Apr 22]        
Tigers           1-1 George Town     

Round 19
[Apr 26]
Latinos          3-1 Sunset          
Future           2-2 Tigers          
Roma             3-0 Scholars   
[Apr 28]     
George Town      2-1 Elite           

Final Table:

 1.Elite SC                    21 12  5  4 39-34 41  Champions
 2.George Town SC              21 10  7  4 36-24 37
 3.Scholars International FC   21  8  8  5 36-25 32
 4.Sunset FC                   21  8  6  7 43-39 30
 5.Latinos FC                  21  6  8  7 31-34 26
 6.Future SC                   21  6  5 10 28-32 23
- - - - - - - - - - - - - - - - - - - - - - - - - -
 7.Tigers FC                   21  5  5 11 39-51 20  Relegation Playoff
---------------------------------------------------
 8.Roma FC                     21  5  4 12 24-37 19  Relegated

Promotion/Relegation Playoff [Apr 30?]
Tigers           3-1 Academy

NB: Tigers remain at 1st level


Author: Hans Schöggl

Last updated: 2 Oct 2009

(C) Copyright Hans Schöggl and RSSSF 2008/09

INFORMACIÓN

La Liga de las Islas Caimán oficialmente Cayman Islands League es la primera división del fútbol de las Islas Caimán siendo la liga más importante de ese país, esta organizada bajo la Federación de Fútbol de las Islas Caimán. Se fundó en 1980 y se afilió a los torneos de la Concacaf desde 1992.

  USO DE MEMORIA  
4,246,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5918
Total Execution Time  0.5937
  CADENA URL  
/liga_islas_caiman2009
  GET DATOS  
$_GET['/liga_islas_caiman2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_islas_caiman2009'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_islas_caiman' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 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=308 AND type_rel = 3
0.0129  SELECT text_es as historical_text FROM leagues_text WHERE id=263
0.0127  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 = 28580 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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='2009' WHERE c.parentId=308 GROUP BY c.id ORDER BY c.order_id ASC
0.0127  SELECT type,rule FROM rules WHERE categoryId = 308 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 20:22:26' 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-05-02 20:22:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 20:22:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 20:22:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_islas_caiman' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28580) 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.0129  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 (28580) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28580) AND (e.action IN (4,5) ) 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 (28580) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28580) AND (e.action IN (3,4) ) 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 (28580) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (28580) 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 (28580) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  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 = 28580 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0127  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 = 28580 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0131  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 308 GROUP BY l.categoryId
0.0131  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=308 GROUP BY l.year ORDER BY l.year DESC
0.0127  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=28580 AND rel.round=21
0.0127  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 = 28580 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0127  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 = 28580 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-04-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28580 ORDER BY creation_date DESC LIMIT 0, 10
0.0141  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-04-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28580
0.0131  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 `calendars2009` 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` = 28580 AND c.`round` = 21 ORDER BY shedule ASC LIMIT 200
0.0127  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 `events2009` e INNER JOIN calendars2009 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 = 21 AND e.real_date IS NOT NULL AND e.league_id = 28580 ORDER BY total DESC LIMIT 40
0.0132  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 `events2009` e INNER JOIN calendars2009 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 = 28580 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0128  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 `tables2009` 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 = 28580 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 28580 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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-05-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 28580 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0128  SELECT data1, data2 FROM services_tags WHERE categoryId=308
0.0128  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 308 AND l.year = 2009 ORDER BY l.group_code ASC
0.0128  SELECT group_code, extraName from `leagues` WHERE categoryId=308 AND year=2009