4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Jamaica 2006
2005/2006

Liga Jamaica 2006

Información Histórica
						
Final Table:

 1.Waterhouse (Kingston)              33  20  9  4  57-34  69  Champions
 2.Harbour View (Kingston)            33  19  7  7  49-26  64
 3.Tivoli Gardens (Kingston)          33  17  6 10  64-39  57
 4.Portmore United (Portmore)         33  13 16  4  41-26  55
 5.Boys' Town (Kingston)              33  12 13  8  42-31  49
 6.Village United (Falmouth)          33  13  9 11  54-48  48
 7.Arnett Gardens (Kingston)          33  10 10 13  42-49  40
 8.Seba United (Montego Bay)          33  10  8 15  46-51  38
 9.Reno (Savannah del Mar)            33   8 10 15  30-39  34
10.Wadadah FC (Montego Bay)           33   7 11 15  39-62  32
-------------------------------------------------------------
11.Constant Spring (Constant Spring)  33   3 15 15  28-56  24  Relegated
12.Rivoli United (Spanish Town)       33   2 14 17  27-58  20  Relegated

NB: this year there are no bonus points connected to the end of the
    round finals, nor a post-season championship playoff

Round 1 [Sep 11] 
Tivoli Gardens     2-1 Boys' Town
  [Roland Dean 6, Oraine Simpson 37; Fitzroy Anglin 66pen]
Reno               0-0 Village U.
Constant Spring    1-1 Rivoli U.
  [Denzil Mitchell 48; Garfield Reid 15]
Portmore U.        4-2 Seba U.
  [Omar Daley 12, Craig Morrison 35, Dave Clarke 40, 
   Ashaine Murray 66; Carlton Aikens 20, Wilfred Smith 62]
Wadadah            1-5 Harbour View        
  [Rohan Reid 55; Lovel Palmer 4, 80, Marcelino Blackburn 28,
   Luton Shelton 33, 76]
Arnett Gardens     2-0 Waterhouse
  [Kwame Richardson 18, Everton Bunsie 70]

Round 2 [Sep 14]
Waterhouse         1-0 Tivoli Gardens 
  [Kevin Lamey 61]
Boys' Town         2-0 Wadadah 
  [Fitzroy Anglin 64, Marvin Morgan 85]
Harbour View       1-0 Constant Spring 
  [Lovel Palmer 37]
Rivoli United      0-2 Reno 
  [Nicholy Findlayson 30pen, Omar Evans 87]
Village United     0-0 Portmore United
Seba United        1-0 Arnett Gardens
  [Kemar James 23]

Round 3 [Sep 18]
Constant Spring    0-0 Boys' Town 
Wadadah            3-1 Tivoli Gardens 
  [Jermaine Anderson 8, 86, Daniel Ricketts 12; Denroy Gordon 12]
Arnett Gardens     1-0 Village United 
  [Greg Taylor 69]
Portmore United    1-1 Rivoli United 
  [Anthony Modeste 20pen; Garfield Reid 4pen]
Reno               1-2 Harbour View 
  [Omar Dallas 9; Lovel Palmer 16, Loxley Thomas 44]
Seba United        0-1 Waterhouse
  [Vincent Earle 49]

Round 4 
[Sep 25]
Waterhouse         3-1 Wadadah
  [Shane Edwards 8, 56, Kevin Lamey 90; Rohan Reid 93]
Tivoli Gardens     2-0 Constant Spring
  [Daevian Laing 14, 83]
Harbour View       0-1 Portmore United 
  [Sheldon Palmer 75]
Rivoli United      0-1 Arnett Gardens 
  [Gregg Taylor]
Village United     2-2 Seba United 
  [Fabian Dawkins 31, 90+; Kemar James 42, Damion Nelson 47]
[Oct 26]
Boys' Town         1-2 Reno

Round 5 
[Sep 28]
Portmore United    0-0 Boys' Town 
Reno               0-1 Tivoli Gardens 
  [Oraine Simpson 42]
Constant Spring    1-1 Wadadah 
  [Alberto Fray 72; Jermaine Anderson 25]
Seba United        1-2 Rivoli United 
  [Norman Foster 28pen; Kemar Mills 17, 73]
Arnett Gardens     1-3 Harbour View 
  [Gregg Taylor 79; Luton Shelton 44pen, Kevin King 77
  Marcelino Blackburn 90+]
[date?]
Village United     4-1 Waterhouse

Round 6 
[Oct 2]
Waterhouse         1-0 Constant Spring
  [Kevin Lamey 8]
Tivoli Gardens     0-0 Portmore United
Boys' Town         1-1 Arnett Gardens
  [Garfield Gillespie 69; Conry Hall 59]
Harbour View       2-1 Seba United
  [Loxley Thomas 16, Richard West 29; Kemar James 65]
Rivoli United      2-2 Village United
  [Devon Hodgess 10, Kemar Mills 43; Fabian Dawkins 89, 90+]
[Oct 12]
Wadadah            0-0 Reno

Round 7 
[Oct 5]
Arnett Gardens     4-1 Tivoli Gardens
  [Kevin Wilsom 3, 62pen, Gregg Taylor 29, Kwame Richardson 47;
   Christopher Nicholas 79pen]
Reno               3-1 Constant Spring
  [Fabian Blake 17, Kevon Grant 52, Ricardo Scott 67; ?]
Village United     1-0 Harbour View 
  [Fabian Dawkins 74]
Rivoli United      1-1 Waterhouse 
  [Devon Hodges 43; Kevin Lamey 80]
[Oct 12]
Seba United        1-2 Boys' Town
  [Wilfred Smith 63; Fitzroy Anglin 44pen, Marvin Morgan 68]
[Oct 25]
Portmore United    3-0 Wadadah 

Round 8 
[Oct 9]
Waterhouse         0-0 Reno 
Constant Spring    3-3 Portmore United
  [Jermaine Richards 29, 55, Collin Brown 87; Kevin Deerr 25,
   Sheldon Palmer 76, 83]
Tivoli Gardens     4-0 Seba United 
  [Christopher Nicholas 32, 61, 85, Horace Howell 44]
Boys' Town         2-2 Village United 
  [Michael Campbell 10, Oneil Thompson 18; Omar Allen 33,
   Henrique Green 88]
Harbour View       2-0 Rivoli United
  [Gregory Simpson, Lovel Palmer]
[Oct 27]
Wadadah            2-0 Arnett Gardens

Round 10 [Oct 23]
Boys' Town         0-1 Harbour View
  [Kevin King 14]
Reno               0-1 Arnett Gardens
  [Patrick Graham 86]
Constant Spring    0-2 Seba United
  [Kemar James 12, Sean Bucknor 29]
Wadadah            1-0 Village United
  [Rohan Reid 4]
Tivoli Gardens     5-1 Rivoli United 
  [Horace Howell 1, Christopher Nicholas 47, 78, Jermaine Johnson 80,
   Roland Dean 90; Kemar Mills 49]
Portmore United    1-1 Waterhouse

Round 11 [Oct 30]
Waterhouse         0-0 Boys' Town 
Harbour View       1-0 Tivoli Gardens 
  [Kemar Petrekin 56]
Rivoli United      2-1 Wadadah 
  [Devon Hodges 2, Kemar Mills 47; Oliver Trail 27]
Village United     2-1 Constant Spring 
  [Fabian Dawkins 11, 36; Carl Brown 23]
Seba United        1-1 Reno
  [Wilfred Smith 86; Fabian Blake 19]
Arnett Gardens     2-2 Portmore United

Round 9 [postponed from Oct 16]
[Nov 2]
Village United     3-2 Tivoli Gardens
  [Newton Sterling 12, Ian McAnuff 44, own goal 66;
   Jermaine Taylor 8, Oraine Simpson 90]
Portmore United    1-0 Reno 
  [Jason Morrison 10]
Arnett Gardens     2-1 Constant Spring 
Harbour View       3-1 Waterhouse 
  [Marcelino Blackburn 49, Oneil Smith 80, Loxley Thomas 90;
   Jomo Gordon 26]
[Nov 9]
Rivoli United      1-1 Boys' Town
  [Ray Graham 87; Andre Wheeler 60]
[date?]
Seba United        0-0 Wadadah             [inferred]

Round 1 Table:

 1.Harbour View (Kingston)            11   9  0  2  20- 7  27  End of Round Final
 2.Arnett Gardens (Kingston)          11   6  2  3  15-11  20  End of Round Final
 3.Portmore United (Portmore)         11   4  7  0  16- 9  19
 4.Village United (Falmouth)          11   4  5  2  16-12  17
 5.Tivoli Gardens (Kingston)          11   5  1  5  18-14  16
 6.Waterhouse (Kingston)              11   4  4  3  10-12  16
 7.Reno (Savannah del Mar)            11   3  4  4   9- 8  13
 8.Boys' Town (Kingston)              11   2  6  3  10-10  12
 9.Wadadah FC (Montego Bay)           11   3  3  5  10-17  12
10.Rivoli United (Spanish Town)       11   2  5  4  11-18  11
11.Seba United (Montego Bay)          11   2  3  6  11-18   9
12.Constant Spring (Constant Spring)  11   0  4  7   8-18   4

End of Round 1 Final [Nov 6]
Harbour View       1-2 Arnett Gardens 
  [Marcelino Blackburn 28; Kevin Wilson 48pen, Gregg Taylor 58]

Round 12 [Nov 13]
Seba United        0-1 Portmore United
  [Ashaine Murray 46]
Harbour View       1-0 Wadadah 
  [Luton Shelton 15]
Boys' Town         0-2 Tivoli Gardens
  [Oraine Simpson 45, Christopher Nicholas 49]
Rivoli United      0-0 Constant Spring
Village United     1-0 Reno 
  [Sheldon Bryan 89]
Waterhouse         2-0 Arnett Gardens
  [Damion Williams 4, Noradon Jenkinson 87]

Round 13 [Nov 20]
Tivoli Gardens     1-2 Waterhouse 
  [?; Weston Forrest 35, Irvino English 47]
Wadadah            0-1 Boys' Town 
  [Garfield Rennicks 91]
Constant Spring    0-3 Harbour View 
  [Marcelino Blackburn 7, 80, Oniel Smith 16]
Reno               3-0 Rivoli United 
  [Fabian Blake 41, Ricardo Scott 44, 77]
Portmore United    0-0 Village United 
Arnett Gardens     1-1 Seba United 
  [Kwame Richardson 11: Norman Foster 22pen]

Round 14 
[Nov 27]
Boys' Town         1-1 Constant Spring 
  [Garfield Rennicks 21; Carl Brown 89]
Village United     3-0 Arnett Gardens 
  [Teafore Bennett 19, Troy Smith 28, Ian McAnuff 38]
Harbour View       1-0 Reno 
  [Kevin King 41]
Waterhouse         4-0 Seba United
  [Irvino English 35, 68, Kevin Lamey 81, Demar Phillips 86]
Tivoli Gardens     4-0 Wadadah 
[Nov 28]
Rivoli United      0-2 Portmore United 
  [Anthony Modeste 62, Omar Daley 73]

Round 15 
[Nov 22]
Portmore United    0-1 Harbour View 
  [Lovel Palmer 79]
[Dec 4]
Wadadah            1-3 Waterhouse 
  [Daniel Ricketts 29; Vincent Earle 14, Jomo Gordon 66, Kevin Lamey 71]
Constant Spring    1-1 Tivoli Gardens 
  [Carl Brown 48; Horace Howell 84]
Reno               0-0 Boys' Town 
Rivoli United      1-1 Arnett Gardens 
  [Omondo McLeod 60; Kwame Richardson 89]
Seba United        4-3 Village United 
  [Wilfred Smith 2, 24, Kemar James 8, Norman Foster 18;
   Teafore Bennett 14, Fabian Dawkins 32, 61]

Round 16 
[Dec 11]
Tivoli Gardens     2-0 Reno 
  [Roland Dean 73, Nicholas McCreath 88]
Wadadah            1-1 Constant Spring 
  [Jermaine Anderson 27; Carl Brown 24]
Rivoli United      1-3 Seba United 
  [Derrick Planter 8; Ricardo Geddes 49, 90+, Wilfred Smith 57]
Harbour View       3-0 Arnett Gardens 
  [Luton Shelton, Donald Stewart, Richard West]
Waterhouse         4-1 Village United 
  [Damion Williams 4, Kevin Lamey 66, 78, Newton Sterling 73;
   Jomo Gordon 45]
[date?]
Boys' Town         2-1 Portmore United     [inferred]

Round 17 [Dec 18]
Constant Spring    2-2 Waterhouse 
  [Jermaine Richards 57, Christopher Currie 71; Irvino English 84,
   Kevin Lamey 89]
Reno               1-0 Wadadah 
  [Fabian Blake 16]
Portmore United    2-2 Tivoli Gardens 
  [Kevin Deerr 12, Steven Morrissey 63; Horace Howell 28, Craig Stewart 34]
Arnett Gardens     3-2 Boys' Town 
  [Kwame Richardson 5, Gregg Taylor 16, Jonathan Williams 82;
   Michael Campbell 37, 45]
Seba United        0-1 Harbour View 
  [Loxley Thomas 48]
Village United     4-0 Rivoli United 
  [Newton Sterling 34, 48, Fabian Dawkins 55, Omar Allen 72]

Round 18 [Dec 21]
Boys' Town         2-1 Seba United 
  [George Vernal 41, 44; Delroy Ellis 67]
Tivoli Gardens     1-1 Arnett Gardens 
  [Nicholas McCreath; Cornel Chin-Sue]
Wadadah            2-1 Portmore United 
  [Rohan Reid 65, 75; Kevin Deerr 16]
Constant Spring    1-0 Reno 
  [Jermaine Benjamin 90+]
Harbour View       2-1 Village United 
  [Nicholas Dodd 16, Richard West 78; Newton Sterling 4]
Waterhouse         1-0 Rivoli United 
  [Desmond Breakenridge]

Round 19 [Dec 28]
Reno               1-2 Waterhouse 
  [Kevon Grant; Demar Phillips 38, Jomo Gordon 62]
Portmore United    3-0 Constant Spring 
  [Kevin Deerr 24, 65, Anthony Bennett 89]
Arnett Gardens     2-2 Wadadah 
  [Kwame Richardson 61, 90+; Rohan Reid 84, Jermaine Anderson 89]
Seba United        3-0 Tivoli Gardens 
  [Wilfred Smith 61, 73, Delroy Ellis 16]
Village United     1-0 Boys' Town 
  [Omar Allen 75]
Rivoli United      1-1 Harbour View

Round 20 
[Jan 1]
Tivoli Gardens     2-3 Village United
Wadadah            0-1 Seba United
Constant Spring    1-1 Arnett Gardens
Reno               1-1 Portmore United
Waterhouse         2-2 Harbour View
[Jan 2]
Boys' Town         1-0 Rivoli United

Round 21 [Jan 8]
Arnett Gardens     5-1 Reno 
Seba United        2-0 Constant Spring  
Village United     2-2 Wadadah  
Rivoli United      1-1 Tivoli Gardens  
Harbour View       2-2 Boys' Town  
Waterhouse         3-1 Portmore United
 
Round 22
[Jan 11] 
Wadadah            3-1 Rivoli United 
Constant Spring    2-1 Village United
Portmore United    2-0 Arnett Gardens
[Jan 12]
Boys' Town         2-2 Waterhouse
Reno               awd Seba United         [awarded 0-3; abandoned at 0-0 in 
Tivoli Gardens     3-2 Harbour View         45' due to insufficient security]

Round 2 Table:

 1.Waterhouse (Kingston)              11   8  3  0  27-11  27  End of Round Final
 2.Harbour View (Kingston)            11   7  3  1  19- 9  24  End of Round Final
 3.Seba United (Montego Bay)          11   6  1  4  18-13  19
 4.Village United (Falmouth)          11   5  2  4  20-16  17
 5.Tivoli Gardens (Kingston)          11   4  4  3  19-15  16
 6.Boys' Town (Kingston)              11   4  4  3  13-13  16
 7.Portmore United (Portmore)         11   4  3  4  14-11  15
 8.Constant Spring (Constant Spring)  11   2  6  3   9-15  12
 9.Arnett Gardens (Kingston)          11   2  5  4  14-19  11
10.Wadadah FC (Montego Bay)           11   2  3  6  11-18   9
11.Reno (Savannah del Mar)            11   2  2  7   7-16   8
12.Rivoli United (Spanish Town)       11   0  4  7   5-20   4

End of Round 2 Final [Jan 22]
Waterhouse         4-4 Harbour View        [aet, 4-1 pen]

Round 23
[Jan 29]
Seba United        1-1 Rivoli United
Wadadah            3-2 Village United
Reno               0-0 Portmore United
[Feb 1]
Constant Spring    0-3 Tivoli Gardens
Harbour View       1-0 Arnett Gardens
Waterhouse         2-0 Boys' Town

Round 24 [Feb 5]
Arnett Gardens     2-3 Waterhouse
Harbour View       1-2 Tivoli Gardens
Portmore United    4-3 Wadadah
Boys' Town         1-0 Seba United
Rivoli United      1-1 Reno
Village United     1-1 Constant Spring 

Round 25
[Feb 12]
Reno               1-3 Seba United
[Feb 12?; inferred; home/away unclear]
Village United     1-0 Harbour View
Wadadah            0-0 Rivoli United
[Feb 22]
Arnett Gardens     0-2 Boys' Town
Waterhouse         0-1 Tivoli Gardens
[played later]
Constant Spring    0-0 Portmore United

Round 26 
[Feb 19]
Boys' Town         2-0 Reno 
Seba United        1-2 Wadadah
Rivoli United      2-3 Constant Spring  
Village United     1-2 Waterhouse 
Tivoli Gardens     1-1 Arnett Gardens 
[Mar 29]
Harbour View       0-0 Portmore United

Round 27 [Feb 26] 
Harbour View       2-0 Rivoli United
Constant Spring    1-1 Seba United
Wadadah            0-2 Reno 
Arnett Gardens     0-1 Village United
Waterhouse         1-1 Portmore United
Tivoli Gardens     1-0 Boys' Town  
 
Round 28 [Mar 5]
Boys' Town         2-2 Wadadah  
Reno               0-0 Constant Spring  
Seba United        1-1 Harbour View  
Rivoli United      1-2 Waterhouse  
Portmore United    1-0 Arnett Gardens 
Village United     3-1 Tivoli Gardens
 
Round 29 [Mar 12]
Arnett Gardens     2-1 Rivoli United
Waterhouse         2-1 Seba United
Harbour View       1-2 Reno
Constant Spring    2-2 Wadadah
Tivoli Gardens     0-1 Portmore United 
Village United     0-3 Boys' Town  

Round 30 
[Apr 2] 
Reno               2-3 Waterhouse  
Rivoli United      1-3 Tivoli Gardens 
Portmore United    1-0 Village United
Seba Ubited        4-0 Arnett Gardens  
Wadadah            2-2 Harbour View  
[Apr 12]
Boys' Town         8-3 Constant Spring  

Round 31 [Apr 5]
Village United     5-3 Rivoli United
Portmore United    0-0 Boys' Town
Tivoli Gardens     7-2 Seba United
Arnett Gardens     1-1 Reno    
Waterhouse         3-1 Wadadah
Harbour View       1-0 Constant Spring

Round 32
[date?; played earlier]
Seba United        2-2 Village United
[Apr 9]
Constant Spring    0-1 Waterhouse
Reno               1-2 Tivoli Gardens
Rivoli United      1-1 Portmore United
Harbour View       0-1 Boys' Town
Wadadah            3-3 Arnett Gardens

Round 33
[Apr 13]
Portmore           2-1 Seba United
[Apr 16]
Waterhouse         1-1 Harbour View 
Boys' Town         0-0 Rivoli United
Village United     2-4 Reno
Tivoli Gardens     6-0 Wadadah
Arnett Gardens     4-1 Constant Spring

Round 3 Table:

 1.Waterhouse (Kingston)              11   8  2  1  20-10  26
 2.Tivoli Gardens (Kingston)          11   8  1  2  27-10  25
 3.Boys' Town (Kingston)              11   6  3  2  19- 8  21
 4.Portmore United (Portmore)         11   5  6  0  11- 6  21
 5.Village United (Falmouth)          11   4  2  5  18-20  14
 6.Harbour View (Kingston)            11   3  4  4  10-10  13
 7.Reno (Savannah del Mar)            11   3  4  4  14-15  13
 8.Wadadah FC (Montego Bay)           11   2  5  4  18-27  11
 9.Seba United (Montego Bay)          11   2  4  5  17-20  10
10.Arnett Gardens (Kingston)          11   2  3  6  13-19   9
11.Constant Spring (Constant Spring)  11   1  5  5  10-23   8
12.Rivoli United (Spanish Town)       11   0  5  6  11-20   5

Final Table:

 1.Waterhouse (Kingston)              33  20  9  4  57-34  69  Champions
 2.Harbour View (Kingston)            33  19  7  7  49-26  64
 3.Tivoli Gardens (Kingston)          33  17  6 10  64-39  57
 4.Portmore United (Portmore)         33  13 16  4  41-26  55
 5.Boys' Town (Kingston)              33  12 13  8  42-31  49
 6.Village United (Falmouth)          33  13  9 11  54-48  48
 7.Arnett Gardens (Kingston)          33  10 10 13  42-49  40
 8.Seba United (Montego Bay)          33  10  8 15  46-51  38
 9.Reno (Savannah del Mar)            33   8 10 15  30-39  34
10.Wadadah FC (Montego Bay)           33   7 11 15  39-62  32
-------------------------------------------------------------
11.Constant Spring (Constant Spring)  33   3 15 15  28-56  24  Relegated
12.Rivoli United (Spanish Town)       33   2 14 17  27-58  20  Relegated

NB: this year there are no bonus points connected to the end of the
    round finals, nor a post-season championship playoff



Cup Tournaments 2005/06
Authors: Hans Schöggl
(hans.schoeggl@sbg.ac.at)
and Paul Burrowes
(stpaulb2001@yahoo.com)

Last updated: 19 Jan 2007

(C) Copyright Hans Schöggl,
Paul Burrowes and RSSSF 2005/07
						


  USO DE MEMORIA  
4,247,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6185
Total Execution Time  0.6205
  CADENA URL  
/liga_jamaica2006
  GET DATOS  
$_GET['/liga_jamaica2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0145  SELECT type FROM routes WHERE alias = 'liga_jamaica2006'
0.0297  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_jamaica' 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.0152  SELECT text_es as historical_text FROM leagues_text WHERE id=1004
0.0148  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 = 29326 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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='2006' WHERE c.parentId=160 GROUP BY c.id ORDER BY c.order_id ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:38:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:38:59' 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-27 13:38:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:38:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_jamaica' 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.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29326) 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.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 (29326) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29326) 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 (29326) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29326) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  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 (29326) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29326) 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 (29326) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  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 = 29326 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 = 29326 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=29326 AND rel.round=33
0.0146  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 = 29326 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 29326 AND esl.points > 0
0.0146  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` = 29326 ORDER BY creation_date DESC LIMIT 0, 10
0.0149  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` = 29326
0.0146  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` = 29326 AND c.`round` = 33 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 `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 = 33 AND e.real_date IS NOT NULL AND e.league_id = 29326 ORDER BY total DESC LIMIT 40
0.0150  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 = 29326 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0151  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 = 29326 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 29326 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 29326 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0151  SELECT data1, data2 FROM services_tags WHERE categoryId=160
0.0151  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 160 AND l.year = 2006 ORDER BY l.group_code ASC
0.0151  SELECT group_code, extraName from `leagues` WHERE categoryId=160 AND year=2006