4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2001
Temporada Siguiente »
Publicidad 600x120.gif
Liga Jamaica 2001
2000/2001

Liga Jamaica 2001

Información Histórica 
						

Craven 'A' National Premier League

'Regular Season' 

Overall Table:

 1.Harbour View (Kingston)            28 15  9  4 39-19 58 [4] [*28]   
 2.Tivoli Gardens (Kingston)          28 12  9  7 27-20 45
 3.Waterhouse (Kingston)              28 11 10  7 28-23 44 [1]
 4.Constant Spring (Constant Spring)  28 11  8  9 32-33 41
 5.Arnett Gardens (Kingston)          28  9 10  9 33-27 40 [3]
 6.Hazard United (May Pen)            28  7 12  9 13-16 33  [*4,*18,*20] 
 7.Reno (Savannah del Mar)            28  7 11 10 31-37 32  [*25,*28] 
 8.Wadadah (Montego Bay)              28  6 13  9 38-38 31
 9.Seba United (Montego Bay)          28  5 11 12 18-28 26  [*18,*20]
10.Olympic Gardens (Kingston)         28  5 11 12 26-44 26  [*4,*25]       

 [*4] w/o goals rd 4
[*18] w/o goals rd 18
[*20] w/o goals rd 20
[*25] w/o goals rd 25
[*28] w/o goals rd 28

NB: Waterhouse, Tivoli Gardens, Harbour View and Arnett Gardens 
    qualified for semifinals

First Stage 

Final Table:

 1.Harbour View (Kingston)             9  6  1  2 15- 5 19
 2.Waterhouse (Kingston)               9  5  2  2  7- 6 17
 3.Reno (Savannah del Mar)             9  4  2  3 13-11 14 
 4.Constant Spring (Constant Spring)   9  3  4  2 15-10 13
 5.Tivoli Gardens (Kingston)           9  3  4  2  9- 5 13
 6.Wadadah (Montego Bay)               9  2  4  3  9- 8 10
 7.Hazard United (May Pen)             9  2  4  3  2- 4 10  [*4]
 8.Arnett Gardens (Kingston)           9  2  3  4  9-14  9
 9.Seba United (Montego Bay)           9  2  3  4  7-12  9  
10.Olympic Gardens (Kingston)          9  2  1  6  7-18  7  [*4]

[*4] w/o goals rd 4

Round 1 [Sep 17]
Harbour View    2-0     Hazard United
Arnett Gardens  1-2     Constant Spring
Waterhouse      1-0     Tivoli Gardens
Reno            1-2     Seba United
Wadadah         1-1     Olympic Gardens

Round 2 [Sep 24]
Tivoli Gardens  2-1     Arnett Gardens
Olympic Gardens 0-4     Harbour View
Constant Spring 2-2     Wadadah
Hazard United   0-1     Reno
Seba United     1-1     Waterhouse

Round 3 [Oct 11] 
Harbour View    0-1     Seba 
Waterhouse      2-1     Constant Spring 
Arnett G        1-0     Hazard            
Olympic G       0-2     Tivoli G 
Wadadah         1-3     Reno

Round 4 [Oct 15]
Reno            3-1     Constant Spring
Waterhouse      1-0     Wadadah
Hazard          bt      Olympic G       [inferred]
Harbour View    0-0     Tivoli G
Arnett G        2-1     Seba

Round 5 [Oct 18,19]
Reno            5-3     Olympic Gardens 
Tivoli Gardens  3-0     Seba United 
Hazard          0-0     Wadadah 
Constant Spring 3-1     Harbour View 
Waterhouse      0-0     Arnett Gardens 

Round 6 [Oct 22] 
Tivoli Gardens  2-2     Reno 
Waterhouse      0-2     Hazard U. 
Arnett Gardens  1-4     Harbour View 
Constant Spring 5-0     Olympic Gardens 
Wadadah         3-1     Seba U. 

Round 7 [Oct 29?]
Olympic Gardens 2-0     Arnett G        [inferred]
Tivoli Gardens  0-0     Hazard U. 
Reno            0-1     Waterhouse 
Harbour View    1-0     Wadadah 
Seba U.         1-1     Constant Spring 

Round 8 [Nov 5]
Arnett Gardens  2-2     Wadadah
Constant Spring 0-0     Tivoli Gardens
Waterhouse      1-0     Olympic Gardens
Harbour View    1-0     Reno
Seba United     0-0     Hazard United
  
Round 9 [Nov 19]
Harbour View    2-0     Waterhouse
Hazard United   0-0     Constant Spring
Arnett Gardens  1-1     Reno
Olympic Gardens 1-0     Seba United
Wadadah         1-0     Tivoli Gardens

First Stage Final Table:

 1.Harbour View (Kingston)             9  6  1  2 15- 5 19
 2.Waterhouse (Kingston)               9  5  2  2  7- 6 17
 3.Reno (Savannah del Mar)             9  4  2  3 13-11 14 
 4.Constant Spring (Constant Spring)   9  3  4  2 15-10 13
 5.Tivoli Gardens (Kingston)           9  3  4  2  9- 5 13
 6.Wadadah (Montego Bay)               9  2  4  3  9- 8 10
 7.Hazard United (May Pen)             9  2  4  3  2- 4 10  [*4]
 8.Arnett Gardens (Kingston)           9  2  3  4  9-14  9
 9.Seba United (Montego Bay)           9  2  3  4  7-12  9  
10.Olympic Gardens (Kingston)          9  2  1  6  7-18  7  [*4]

[*4] w/o goals rd 4

End of Round Final [Nov 26]
Harbour View    1-0     Waterhouse

Harbour View obtain 3, Waterhouse 1 bonus point in the overall table.

Second Stage 

Final Table:

 1.Harbour View (Kingston)             9  6  2  1 16- 8 20 
 2.Arnett Gardens (Kingston)           9  5  3  1 18- 5 18
 3.Tivoli Gardens (Kingston)           9  5  2  2 10- 9 17  
 4.Olympic Gardens (Kingston)          9  3  4  2 14-12 13  
 5.Constant Spring (Constant Spring)   9  3  2  4  8-15 11
 6.Seba United (Montego Bay)           9  2  4  3  8- 8 10  [*18]
 7.Hazard United (May Pen)             9  2  3  4  7- 8  9  [*18]
 8.Reno (Savannah del Mar)             9  1  5  3  8-12  8
 9.Waterhouse (Kingston)               9  1  4  4  7-14  7
10.Wadadah (Montego Bay)               9  1  3  5 10-15  6

[*18] w/o goals rd 18

Round 10 [Nov 29] 
Constant Spring 2-6     Arnett G. 
Seba U.         0-0     Reno 
Olympic G.      3-3     Wadadah 
Tivoli G.       2-1     Waterhouse 
Harbour View    2-1     Hazard U.       [Dec 7] 

Round 11
[Dec 3]
Waterhouse      2-1     Seba U.
Arnett G.       1-1     Tivoli G.
Reno            0-0     Hazard U.
Constant Spring 2-1     Wadadah         [inferred]
Olympic G.      0-0     Harbour View    [inferred]

Round 12 [Dec 10] 
Arnett G.       3-0     Waterhouse 
Constant Spring 0-1     Harbour View 
Wadadah         0-2     Hazard U.       [inferred]
Olympic G.      1-1     Reno 
Seba U.         2-0     Tivoli G. 

Round 13 [Dec 17]
Harbour View    3-2     Seba U.
Waterhouse      1-1     Constant Spring
Tivoli G.       1-0     Olympic G.
Reno            1-3     Wadadah
Hazard U.       0-0     Arnett G.

Round 14 [Dec 20]
Tivoli G.       1-1     Harbour View
Constant Spring 2-1     Reno
Olympic G.      3-2     Hazard U.       
Seba U.         1-0     Arnett G.
Wadadah         1-1     Waterhouse

Round 15 [Dec 27]
Harbour View    0-3     Arnett G.
Hazard U.       1-0     Waterhouse
Olympic G.      4-0     Constant Spring
Reno            2-0     Tivoli G.
Wadadah         1-1     Seba U.

Round 16 [Dec 31] 
Waterhouse      1-1     Reno 
Arnett G.       3-0     Olympic G. 
Constant Spring 0-0     Seba U. 
Hazard U.       1-2     Tivoli G. 
Harbour View    2-0     Wadadah 

Round 17 [Jan 4]
Constant Spring 1-0     Hazard U.
Waterhouse      0-3     Harbour View
Reno            1-1     Arnett G.
Tivoli G.       2-1     Wadadah
Seba U.         1-2     Olympic G.

Round 18 [Jan 7]
Arnett G        1-0     Wadadah
Harbour View    4-1     Reno
Tivoli G        1-0     Constant Spring
Olympic G       1-1     Waterhouse
Hazard U.       1-1     Seba U.               [inferred]

Second Stage Final Table:

 1.Harbour View (Kingston)             9  6  2  1 16- 8 20 
 2.Arnett Gardens (Kingston)           9  5  3  1 18- 5 18
 3.Tivoli Gardens (Kingston)           9  5  2  2 10- 9 17  
 4.Olympic Gardens (Kingston)          9  3  4  2 14-12 13  
 5.Constant Spring (Constant Spring)   9  3  2  4  8-15 11
 6.Seba United (Montego Bay)           9  2  4  3  8- 8 10  [*18]
 7.Hazard United (May Pen)             9  2  3  4  7- 8  9  [*18]
 8.Reno (Savannah del Mar)             9  1  5  3  8-12  8
 9.Waterhouse (Kingston)               9  1  4  4  7-14  7
10.Wadadah (Montego Bay)               9  1  3  5 10-15  6

[*18] w/o goals rd 18

End of Round Final [Jan 14]
Harbour View    1-2     Arnett Gardens

Arnett Gardens obtain 3, Harbour View 1 bonus point in the overall table.

Overall Table:

 1.Harbour View (Kingston)            18 12  3  3 31-13 43 [4]   
 2.Tivoli Gardens (Kingston)          18  8  6  4 19-14 30        ok
 3.Arnett Gardens (Kingston)          18  7  6  5 27-19 29 [3] 
 4.Waterhouse (Kingston)              18  6  6  6 14-20 25 [1]          
 5.Constant Spring (Constant Spring)  18  6  6  6 23-25 24        ok
 6.Reno (Savannah del Mar)            18  5  7  6 21-23 22           
 7.Olympic Gardens (Kingston)         18  5  5  8 21-30 20  [*4]       
 8.Hazard United (May Pen)            18  4  7  7  9-12 19  [*4,*18] 
 9.Seba United (Montego Bay)          18  4  7  7 15-20 19  [*18]
10.Wadadah (Montego Bay)              18  3  7  8 19-23 16            

 [*4] w/o goals rd 4
[*18] w/o goals rd 18

NB: http://www.homeviewjamaica.com/jamfootballfed/Leagues_NatandPremier.html
    gave the following differing goal totals:
    Harbour View    31-14
    Arnett Gardens  27-19
    Waterhouse      16-20
    Reno            24-24
    Olympic Gardens 19-31
    Hazard United   12-14
    Seba United     16-19
    Wadadah         20-27

Third Stage

The 10 teams are divided into two zones but they will play in a cross zone format. 

Zone A

 1.Waterhouse (Kingston)              10  5  4  1 14- 3 19
 2.Wadadah (Montego Bay)              10  3  6  1 19-15 15
 3.Harbour View (Kingston)            10  3  6  1  8- 6 15  [*28] 
 4.Reno (Savannah del Mar)            10  2  4  4 10-14 10  [*25,*28]
 5.Olympic Gardens (Kingston)         10  0  6  4  5-14  6  [*25]

[*25] w/o goals rd 25 (7) 
[*28] w/o goals rd 28 10) 

Zone B

 1.Constant Spring (Constant Spring)  10  5  2  3  9- 8 17
 2.Tivoli Gardens (Kingston)          10  4  3  3  8- 6 15
 3.Hazard United (May Pen)            10  3  5  2  4- 4 14  [*20]
 4.Arnett Gardens (Kingston)          10  2  4  4  6- 8 10   
 5.Seba United (Montego Bay)          10  1  4  5  3- 8  7  [*20]

[*20] w/o goals rd 20 (2)

Round 1 (19 overall)
[Jan 31]
Harbour View            0-0     Wadadah
Waterhouse              0-1     Reno
Arnett G.               1-1     Constant Spring
Tivoli G.               1-1     Hazard U.
[Feb 7]
Olympic G.              1-1     Seba U.         [crosszone]

Round 2 (20 overall) [Feb 4]
Reno                    0-0     Olympic G.
Wadadah                 0-0     Waterhouse
Constant Spring         0-1     Tivoli G.
Harbour View            1-1     Arnett G.       [crosszone]
Hazard U.               n/p     Seba U.         [Seba failed to show after the
  tyres of the team bus had been slashed by irate 'fans']
Hazard U.               bt      Seba U.         [inferred (awarded 0-0 win?)]

Round 3 (21 overall) [Feb 11]
Waterhouse              1-0     Harbour View
Wadadah                 3-1     Olympic G.
Tivoli G.               1-0     Arnett G.
Constant Spring         1-0     Seba U.
Reno                    1-1     Hazard U.       [crosszone]

Round 4 (22 overall) [Feb 18] 
Waterhouse              1-0     Tivoli G.       [crosszone]
Arnett G.               1-0     Seba U. 
Constant Spring         1-0     Hazard U. 
Reno                    1-1     Wadadah 
Harbour View            1-0     Olympic G.      [inferred]

Round 5 (23 overall) 
[Mar 7] 
Reno                    2-2     Harbour View 
Olympic G               1-1     Waterhouse 
Tivoli G                3-0     Seba U. 
Wadadah                 2-2     Constant Spring [crosszone]
[Apr 25]
Arnett G                0-0     Hazard U.   

Round 6 (24 overall) [Mar 18] 
Hazard U.               1-0     Tivoli G. 
Constant Spring         1-0     Arnett G. 
Wadadah                 1-1     Harbour View 
Olympic G.              0-0     Seba U.         [crosszone]
Reno                    0-1     Waterhouse   

Round 7 (25 overall)
[Apr 5] 
Olympic G.              lt      Reno            [1-2?] 
Waterhouse              4-1     Wadadah 
Hazard U.               0-0     Seba U. 
Tivoli G.               1-0     Constant Spring 
[Apr 18] 
Arnett G.               0-2     Harbour View    [crosszone]

Round 8 (26 overall) [Apr 8]
Olympic G.              1-1     Wadadah
Constant Spring         2-1     Seba U.
Waterhouse              0-0     Harbour View
Arnett G.               3-1     Tivoli G.
Hazard U.               1-0     Reno            [crosszone]

Round 9 (27 overall) 
[Apr 12]
Wadadah                 8-5     Reno
Olympic G.              1-1     Harbour View
Constant Spring         1-0     Hazard U.
Tivoli G.               0-0     Waterhouse      [crosszone]
[Apr 22]
Seba U.                 1-0     Arnett G.

Round 10 (28 overall) 
[Apr 14]
Waterhouse              6-0     Olympic G.
Seba U.                 0-0     Tivoli G.
Constant Spring         0-2     Wadadah         [crosszone]
Reno                    lt      Harbour View
[Apr 20]
Arnett G.               0-0     Hazard U.

Zone A

 1.Waterhouse (Kingston)              10  5  4  1 14- 3 19
 2.Wadadah (Montego Bay)              10  3  6  1 19-15 15
 3.Harbour View (Kingston)            10  3  6  1  8- 6 15  [*28] 
 4.Reno (Savannah del Mar)            10  2  4  4 10-14 10  [*25,*28]
 5.Olympic Gardens (Kingston)         10  0  6  4  5-14  6  [*25]

[*25] w/o goals rd 25 (7) 
[*28] w/o goals rd 28 10) 

Zone B

 1.Constant Spring (Constant Spring)  10  5  2  3  9- 8 17
 2.Tivoli Gardens (Kingston)          10  4  3  3  8- 6 15
 3.Hazard United (May Pen)            10  3  5  2  4- 4 14  [*20]
 4.Arnett Gardens (Kingston)          10  2  4  4  6- 8 10   
 5.Seba United (Montego Bay)          10  1  4  5  3- 8  7  [*20]

[*20] w/o goals rd 20 (2)

Overall Table:

 1.Harbour View (Kingston)            28 15  9  4 39-19 58 [4] [*28]   
 2.Tivoli Gardens (Kingston)          28 12  9  7 27-20 45
 3.Waterhouse (Kingston)              28 11 10  7 28-23 44 [1]
 4.Constant Spring (Constant Spring)  28 11  8  9 32-33 41
 5.Arnett Gardens (Kingston)          28  9 10  9 33-27 40 [3]
 6.Hazard United (May Pen)            28  7 12  9 13-16 33  [*4,*18,*20] 
 7.Reno (Savannah del Mar)            28  7 11 10 31-37 32  [*25,*28] 
 8.Wadadah (Montego Bay)              28  6 13  9 38-38 31
----------------------------------------------------------
 9.Seba United (Montego Bay)          28  5 11 12 18-28 26  [*18,*20]
10.Olympic Gardens (Kingston)         28  5 11 12 26-44 26  [*4,*25]       

 [*4] w/o goals rd 4
[*18] w/o goals rd 18
[*20] w/o goals rd 20
[*25] w/o goals rd 25
[*28] w/o goals rd 28

NB: Waterhouse, Tivoli Gardens, Harbour View and Arnett Gardens 
    qualified for semifinals

Relegated: Seba United, Olympic Gardens

NB: sources give the following differing goal totals:
    Waterhouse      30-23
    Constant Spring 31-33
    Reno            36-39
    Wadadah         39-43
    Hazard United   18-18
    Olympic Gardens 25-47
    Seba United     19-29


Semifinals

First Legs [Apr 29]
Arnett Gardens          2-0     Harbour View
Waterhouse              0-0     Tivoli Gardens

Second Legs [May 6]
Harbour View            3-2     Arnett Gardens
Tivoli Gardens          0-1     Waterhouse

Final

First Leg [May 9]
Arnett Gardens          2-1     Waterhouse

Second Leg [May 13] 
Waterhouse              1-2     Arnett Gardens 

Arnett Gardens (Kingston) Champions 2000/01.




Authors: Hans Schöggl
and James Goloboy

Last updated: 2 May 2007

(C) Copyright Hans Schöggl, James Goloboy and RSSSF 2000/07


  USO DE MEMORIA  
4,237,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5816
Total Execution Time  0.5836
  CADENA URL  
/liga_jamaica2001
  GET DATOS  
$_GET['/liga_jamaica2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_jamaica2001'
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_jamaica' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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=160 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 160 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (814373,703127,530767) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=1030
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 = 29351 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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='2001' WHERE c.parentId=160 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:31:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:31:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 18:31:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 18:31:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  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 = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29351) 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.0125  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 (29351) 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 events2001 e WHERE e.league_id IN (29351) 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 (29351) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0134  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29351) 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 (29351) 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 events2001 e WHERE e.league_id IN (29351) 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 (29351) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 29351 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 = 29351 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=29351 AND rel.round=28
0.0128  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 = 29351 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 = 29351 AND esl.points > 0
0.0126  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` = 29351 ORDER BY creation_date DESC LIMIT 0, 10
0.0131  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` = 29351
0.0127  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 `calendars2001` 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` = 29351 AND c.`round` = 28 ORDER BY shedule ASC LIMIT 200
0.0126  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 `events2001` e INNER JOIN calendars2001 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 29351 ORDER BY total DESC LIMIT 40
0.0128  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 `events2001` e INNER JOIN calendars2001 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 = 29351 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0143  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 `tables2001` 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 = 29351 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 29351 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 29351 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0143  SELECT data1, data2 FROM services_tags WHERE categoryId=160
0.0143  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 160 AND l.year = 2001 ORDER BY l.group_code ASC
0.0143  SELECT group_code, extraName from `leagues` WHERE categoryId=160 AND year=2001