4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2005
Temporada Siguiente »
Publicidad 600x120.gif
Liga Antigua y Barbuda 2005
2004/2005

Liga Antigua y Barbuda 2005

Información Histórica 
						
Premier Division

Final Table:
 
 1.Bassa FC (All Saint's)    21  12  7  2 47-24  43  Champions
 2.Hoppers FC (Green Bay)    21  13  4  4 45-22  43
 3.Empire FC (Gray's Farm)   21  11  6  4 53-32  39 
 4.Villa Lions (St. John's)  21   8  4  9 42-45  28
 5.Sap FC (Bolans)           21   8  2 11 42-49  26
 6.Parham FC                 21   6 10  5 33-28  25  [-3]
 7.Wadadli (St. John's)      21   3  4 14 16-47  13
---------------------------------------------------
 8.English Harbour FC        21   3  3 15 28-59   9  [-3]  Relegated

NB: Parham and English Harbour both had 3 points deducted for failing
    to present at least 12 players at the 'march pass and opening 
    ceremony' on Aug 29 (sic!).

Opening Match (from Round 5) [Aug 29]
Empire          0-3 Hoppers
  [Tamarley Thomas 37, Kelly Frederick 41, Daniel 44]

Round 4 (Midweek Match 1) [Sep 1]
Sap             5-0 Wadadli
  [Peter Byers 45, 57, 84, 90, Orlando Peters 62]

Round 1
[Sep 4]
Parham          0-0 English Harbour
Bassa           4-0 Wadadli
[Sep 5]
Empire          2-3 Villa
Hoppers         3-3 Sap

Round 4 (Midweek Match 2) [Sep 8]
Empire          3-3 Parham
  [Errol Barnes 33, Casambi Christopher 74, Andrea Henry 77;
   Tarick Prince 42, Venston Lewis 44, Schyan Jeffers 90]

Round 2
[Sep 11]
Bassa           1-0 Hoppers
  [Dennis Romeo 20]
Empire          3-1 English Harbour
  [Kenny Morgain 31, Justin Perrieira 34, Morgan Wright 37; 
   Omawali Lewis 65]
[Sep 12]
Villa           2-0 Wadadli
  [Garfield Gonsalves 30, Rowan Isaac 42]
Sap             1-0 Parham
  [Peter Byers 39]

Round 4 (Midweek Match 3) [Sep 15]
Villa           0-1 Hoppers
  [Dave Carr 58]

Round 3
[Sep 18]
Villa           5-3 English Harbour
  [Gary Gonsalves 1-0 (pen), Vancito Warner 54, Scotland 62,
   Arnold James 4-3 (pen), Everton Gonsalves 5-3; Stevie Smith 30, 34,
   Quentin Clarke 37]
Hoppers         3-1 Wadadli
  [Ralston Phoenix 5pen, 27, Tamarly Thomas 81; Theo Browne 60]
[Sep 19]
Empire          4-1 Sap
  [Albert Barthley 43, 54, Kenny Morgan 45pen, Errol Barnes 90;
   Peter Byers 31pen]
Bassa           1-3 Parham
  [Randolph Burton 13; Tarick Prince 22, 69, 76]

Round 4 (Midweek Match 4) [Sep 22]
Bassa           5-1 English Harbour  
  [Kevin Watts 37, Lennox Julian 64, 86, Bevis Romeo 68, Dwayne Phillip 88;
   Rodge Phillip 57]

Round 5
[Aug 29]
Empire          0-3 Hoppers
  [Tamarley Thomas 37, Kelly Frederick 41, Daniel 44]
[Sep 25]
Villa           2-2 Bassa
[Sep 26]
English Harbour 1-5 Sap
  [Omwalie Lewis 34; Tiyo Simon 5, 79, Derrick Edwards 63, 77,
   Peter Byers 68]
Wadadli         2-1 Parham
  [Theo Browne 39, 78; Tariq Prince 28]

Round 6
[Oct 2]
English Harbour 1-4 Hoppers
  [Lushington Francis 1-4; Rolston Phoenix 0-1, 75, Kelly Frederick 61, 80]
Villa           2-2 Parham 
  [Rohan Isaac 13, Vanceto Warner 48; Allister Lewis 51, Adam Buyner 78pen]
[Oct 3]
Bassa           2-1 Sap
  [Lennox Julian 15, Kevin Watts 83; Tyo Simon 48]
Empire          3-2 Wadadli
  [Errol Barner 1-1, Andre Roberts (og) 2-1, Shane Brooks 70;
   Theo Browne 21, Cahijah Simon 73; half-time 2-1]

Round 7 
(Midweek Match 5) [Sep 29]
Sap             2-5 Villa
  [Tyo Simon 20, Peter Byers 72; Michael Roberts 11, Garfield Gonsalves 45, 90,
   Vancito Scotland 51, Arnold James 71]
(Midweek Match 6) [Oct 6]
Wadadli         2-1 English Harbour
  [Theo Browne 38, Vivian Richards 50; Abraham Lewis 6]
[Oct 9]
Hoppers         2-1 Parham
  [Kenyata Christopher 80, Tamarly Thomas 85; Michael Jackson 82]
Empire          1-3 Bassa
  [Albert Barthley 83; Lennox Julian 45, Ranja Christian 69, 80]

Round 8
[Oct 10]
English Harbour 3-1 Wadadli
  [Vernil West 24pen, Jason Simon 54, Lawrence Franklyn; William Lewis 31]
Villa           1-6 Sap
  [Rohan Isaac; Tyo Simon 34, 69, 90, Peter Byers 51, 54, ?]
[Dec 1]
Bassa           1-1 Empire
  [Edlorn Garro 51pen; Kenny Morgan 18]
[Dec 7]
Parham          1-0 Hoppers
  [Adam Byrne 76]

Round 9
(Midweek Match 7) [Oct 13]
Sap             2-4 Hoppers
  [Tyo Simon 1-2, Peter Byers 2-2; Tamarley Thomas 1, Kelly Frederick 0-2, 90,
   Kenyatta Christopher 92; half-time 2-2]
(Midweek Match 8) [Nov 9]
Wadadli         0-1 Bassa
  [Deshorn Martin 55]
(Midweek Match 9) [Nov 25]
Villa           2-3 Empire     
  [Rowan Isaac 52, Arnold James 76pen; Kenny Morgan 38, 48,
   Errol Barnes 40]
(Midweek Match 10) [Nov 30]
English Harbour 1-1 Parham
  [Omarlie Samuel; Winston Roberts]

Round 10
[Oct 19]
Sap             4-1 English Harbour
  [Peter Byers 26, 62, Dalmayn Dunn 67, Mickey Josiah 76; Quentin Clarke 64]
[Oct 20]
Parham          5-2 Wadadli
  [Tariq Prince 2, 21, 92, Schyan Jeffers 28, Winston Roberts 68;  
   Michael Murray 85, Kishawn Marsh 93]
[Oct 21]
Bassa           2-0 Villa
  [Kevin Watts 55, Ranjae Christian 59]
[Oct 22]
Hoppers         3-3 Empire
  [Neil Mackenzie 6, Rolston Phoenix 19, Craig Parker 87;
   Shane Brooks 3, 16, Alex Abraham 15]

Round 11
[Nov 13]
Hoppers         5-1 Villa
  [Kelly Frederick (3), Lawson Robinson, Shawn Daniel; ?]
Sap             1-2 Wadadli
[Nov 14]
English Harbour 1-1 Bassa 
  [Quentin Clarke 80pen; Kevin Watts 64]
Parham          1-1 Empire
  [Alister Lewis 15; Kenny Morgan (pen); half-time 1-1]

Round 12 
[Nov 16]
English Harbour 1-2 Villa 
  [Abraham Lewis 88; Omega Jeffery 56, Arnold James 80]
[Nov 17]
Wadadli         0-1 Hoppers
  [Kelly Fredericks 33]
[Nov 18]
Sap             0-3 Empire   
  [Kenny Morgan 28, 55, Albert Barthley 32]
[Nov 23]
Parham          1-1 Bassa
  [Adam Byrne 59pen; Angis Anthony 62]

Round 13 [postponed from Nov 20/21 due to rain]
[Dec 4]
Hoppers         0-2 Bassa
  [own goal 54, Ranje Christian 64]
Wadadli         1-1 Villa
  [Veron Edwards; Everton Gonsalves]
[Dec 5]
English Harbour 1-3 Empire
  [own goal 66; Kenny Morgan 40pen, Albert Barthley 48,
   Errol Barnes 88]
Parham          1-2 Sap
  [Michael Jackson 76; Peter Byers 73, 80]

Round 14 
[Nov 27]
Wadadli         0-5 Empire
Sap             3-1 Bassa 
[Nov 28]
Hoppers         3-0 English Harbour
Parham          3-0 Villa

Round 15 (Midweek Matches)
[Dec 9]
Bassa           3-2 English Harbour
  [Bevis Romeo 27, Jamie Thomas 52, Lennox Julian 63;
   St. Clare Harrigan 2, Quentin Clarke 87pen]
[Dec 14]
Villa           3-1 Sap
  [Bonnis Anthony 22, 80, ? 65; Orlando Peters 79]
[Dec 21]
Empire          1-1 Wadadli 
  [Kenny Morgan 54pen; Theo Browne 79]
[Dec 29]
Parham          0-2 Hoppers
  [Tamarley Thomas 40, Kelly Fredericks 42]

Round 16 (Midweek Matches)
[Dec 9]
Sap             1-0 Wadadli
  [Peter Byers 90+]
[Dec 23]
English Harbour awd Hoppers           [awarded 0-3; English Harbour did not
[date unknown]                         show up in uniforms]
Villa           2-5 Bassa             [inferred]
[Jan 6]       
Parham          2-2 Empire
  [Alister Lewis 13, Adam Byrne 54; Troy Mellanson 56, Kerry Skepple 58]

Round 17
[Dec 11]
Bassa           2-2 Hoppers
  [Jamie Thomas, Ashan Martin; Tamarley Thomas, Kelly Frederick]
Villa           3-0 Wadadli
  [Everton Gonsalves (2), own goal]
[Dec 12]
Empire          3-1 English Harbour
  [Casambe Christopher 29, Justin Pereira 41pen, 47; Steve Andrew 89]
[date unknown]
Sap             2-3 Parham            [inferred]

Round 18
[Dec 17]
Villa           5-1 English Harbour 
  [Robert Peters 1, Rowan Isaac 45, 49, Omega Jeffrey  76, 87;
   St. Clair Harrigan]
[Dec 18]
Hoppers         4-1 Wadadli
  [Larson Robinson 3, Rolston Pheonix 12, Tamarley Thomas 29, Kemon Peters 79;
   Veron Edwards 51] 
[Dec 19]
Bassa           2-2 Parham
  [Ranje Christian 1, Kevin Watts 23; Roberts 42, 45]
Empire          5-0 Sap
  [Pereira 2, 22, 83, Brookes 45, 70]
 
Round 19
[Dec 26]
Empire          2-0 Hoppers
  [Shane Brookes 53, 62]
Bassa           6-1 Sap
  [Kevin Watts 6, Janie Thomas 28, 46, 48, Ranje Christian 44,
   Randolph Burton 6-0; Teran Williams 88]
[Dec 27]
Villa           0-0 Parham
English Harbour 2-1 Wadadli
  [Rodge Phillip 75, Steve Andrew 90; Cliff Browning 36]

Round 20
[Jan 3]
Wadadli         0-0 Parham
English Harbour 4-2 Sap
  [Ashden Isaac 31, 69, 78, 90; Okeem Challenger 19, Pete Byers 26]
[Jan 16]
Villa           1-2 Hoppers 
  [Omega Jeffery 68pen; Terry Roberts 30, Kemo Peters 66]
Bassa           2-1 Empire
  [Edlorn O'Garro 63pen, 90pen; Justin Perierra 45]

Round 21 
[Jan 8]
Bassa           0-0 Wadadli
Parham          3-2 English Harbour 
  [Michael Jackson 26, 38, Adam Byrne 44; Quentin Clarke 79, Raj Phillip 80]
[Jan 11]
Hoppers         0-0 Sap
[Jan 14]
Empire          4-2 Villa             [inferred]

Final Table:
 

 1.Bassa FC (All Saint's)    21  12  7  2 47-24  43  Champions
 2.Hoppers FC (Green Bay)    21  13  4  4 45-22  43
 3.Empire FC (Gray's Farm)   21  11  6  4 53-32  39 
 4.Villa Lions (St. John's)  21   8  4  9 42-45  28
 5.Sap FC (Bolans)           21   8  2 11 42-49  26
 6.Parham FC                 21   6 10  5 33-28  25  [-3]
 7.Wadadli (St. John's)      21   3  4 14 16-47  13
---------------------------------------------------
 8.English Harbour FC        21   3  3 15 28-59   9  [-3]  Relegated

NB: Parham and English Harbour both had 3 points deducted for failing
    to present at least 12 players at the 'march pass and opening 
    ceremony' on Aug 29 (sic!).

Topscorer 
Peter Byers (Sap) 18



Author:
Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 17 Oct 2006

(C) Copyright Hans Schöggl and RSSSF 2004/06


  USO DE MEMORIA  
4,246,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.6812
Total Execution Time  0.6844
  CADENA URL  
/liga_antigua_y_barbuda2005
  GET DATOS  
$_GET['/liga_antigua_y_barbuda2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0145  SELECT type FROM routes WHERE alias = 'liga_antigua_y_barbuda2005'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_antigua_y_barbuda' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=519 AND type_rel = 3
0.0150  SELECT text_es as historical_text FROM leagues_text WHERE id=2462
0.0145  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 = 30715 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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='2005' WHERE c.parentId=519 GROUP BY c.id ORDER BY c.order_id ASC
0.0144  SELECT type,rule FROM rules WHERE categoryId = 519 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0206  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:23:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0175  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:23:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:23:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 11:23:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_antigua_y_barbuda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30715) 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.0146  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 (30715) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30715) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30715) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30715) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0170  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 (30715) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (30715) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30715) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 30715 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0145  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 = 30715 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0149  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=30715 AND rel.round=21
0.0148  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 = 30715 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0149  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 = 30715 AND esl.points > 0
0.0147  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30715 ORDER BY creation_date DESC LIMIT 0, 10
0.0151  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30715
0.0148  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 `calendars2005` 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` = 30715 AND c.`round` = 21 ORDER BY shedule ASC LIMIT 200
0.0145  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 `events2005` e INNER JOIN calendars2005 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 = 30715 ORDER BY total DESC LIMIT 40
0.0151  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 `events2005` e INNER JOIN calendars2005 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 = 30715 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0156  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 `tables2005` 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 = 30715 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 30715 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30715 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0156  SELECT data1, data2 FROM services_tags WHERE categoryId=519
0.0156  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 519 AND l.year = 2005 ORDER BY l.group_code ASC
0.0156  SELECT group_code, extraName from `leagues` WHERE categoryId=519 AND year=2005