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

Liga Jamaica 2002

Información Histórica 
						

Craven 'A' National Premier League

Aggregate Table:

 1.Hazard United (May Pen)            28 13 11  4 36-22  50  Qualified
 2.Arnett Gardens (Kingston)          28 11 11  6 31-20  47  Qualified  [3] 
 3.Harbour View (Kingston)            28 12  7  9 44-29  46  Qualified  [3]
 4.Tivoli Gardens (Kingston)          28 11 10  7 45-28  44  Qualified  [1]
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Waterhouse (Kingston)              28 11 11  6 26-21  44
 6.Village United (Falmouth)          28 12  6 10 33-25  42
 7.Constant Spring (Constant Spring)  28 10 10  8 35-39  41  [1]
 8.Wadadah (Montego Bay)              28  9  9 10 33-41  36
-----------------------------------------------------------
 9.Reno (Savannah del Mar)            28  6  8 14 27-39  26  Relegated
10.Duhaney Park FC (Duhaney Park)     28  2  3 23 13-59   9  Relegated
 
NB: between brackets bonus points earned by End of Round finals.
    top-4 qualify for championship playoff semifinals

Round 1 [Sep 30]
Arnett G.       1-1     Village U.
Hazard U.       2-1     Duhaney Park
Reno            2-1     Waterhouse
Tivoli G.       1-2     Harbour View
Wadadah         2-2     Constant Spring

Round 2
[Oct 14]
Hazard U.       2-1     Waterhouse
Harbour View    4-1     Reno
Wadadah         3-0     Duhaney Park
Village U.      1-1     Tivoli G.
[Oct 15]
Constant Spring 4-2     Arnett G.        

Round 3 [Oct 20]
Village U.      3-1     Wadadah
Hazard U.       0-1     Reno
Arnett G.       1-0     Duhaney Park
Constant Spring 1-3     Tivoli G.
Harbour View    0-1     Waterhouse

Round 4 [Oct 28]
Arnett G.       2-0     Harbour View
Constant Spring 0-0     Waterhouse
Wadadah         1-1     Tivoli G.
Hazard U.       1-0     Village U.
Duhaney Park    0-1     Reno

Round 5 [Nov 4, ppd to Nov 13,14 due to hurricane Michelle] 
Hazard U.       1-0     Harbour View
Reno            1-1     Wadadah
Arnett G.       2-0     Waterhouse
Village U.      0-1     Constant Spring
Duhaney Park    0-0     Tivoli G.

Round 6
[Nov 17]
Waterhouse      1-0     Tivoli G.
Reno            2-0     Village U.
Duhaney Park    0-1     Constant Spring
[Dec 9]
Harbour View    1-2     Wadadah
Arnett G.       0-0     Hazard U.

Round 7 [Nov 21] 
Tivoli G.       2-2     Reno 
Arnett G.       1-2     Wadadah 
Waterhouse      0-2     Village U.      [abd at 0-2 in 52'; apparently awd 0-2] 
Constant Spring 2-2     Hazard U. 
Duhaney Park    0-1     Harbour View 

Round 8 
[Nov 25]
Constant Spring 2-1     Harbour View
Reno            0-2     Arnett G.
Tivoli G.       2-2     Hazard U.
Wadadah         abd     Waterhouse      [abd at 0-0 in 29']
Village U.      0-1     Duhaney Park
[Dec 4, replay]
Wadadah         0-0     Waterhouse 

Round 9 
[Dec 2]
Waterhouse      0-0     Duhaney Park
Constant Spring 2-1     Reno
Harbour View    2-1     Village U.
Wadadah         1-1     Hazard U.
[Dec 12]
Arnett G.       3-1     Tivoli G.

Table at End of First Round:

 1.Constant Spring (Constant Spring)   9  5  3  1 15-11  18  End of Round Final
 2.Arnett Gardens (Kingston)           9  5  2  2 14- 8  17  End of Round Final
 3.Hazard United (May Pen)             9  4  4  1 11- 8  16
 4.Wadadah (Montego Bay)               9  3  5  1 13-10  14  
 5.Reno (Savannah del Mar)             9  4  2  3 11-12  14
 6.Harbour View (Kingston)             9  4  0  5 11-11  12
 7.Waterhouse (Kingston)               9  2  3  4  4- 8   9
 8.Tivoli Gardens (Kingston)           9  1  5  3 11-13   8  
 9.Village United (Falmouth)           9  2  2  5  8-10   8
10.Duhaney Park FC (Duhaney Park)      9  1  2  6  2- 9   5
 
End of Round Final [Dec 16]
Constant Spring 1-5     Arnett G. 
NB: Arnett receive 3, Constant Spring 1 bonus point.

Round 10
[Dec 30]
Constant Spring	1-1	Wadadah
Waterhouse	0-0	Reno
Village U.	0-1	Arnett G.
Harbour View	1-2	Tivoli G.
[Jan 2]
Duhaney Park	1-2	Hazard U.

Round 11 [Jan 6]
Arnett G.	1-1	Constant Spring
Reno		2-3	Harbour View
Wadadah		4-0	Duhaney Park
Hazard U.	0-1	Waterhouse
Village U.	3-0	Tivoli G.

Round 12 [Jan 13] 
Constant Spring 0-4     Tivoli G. 
Hazard U.       1-0     Reno 
Wadadah         1-2     Village U. 
Harbour View    2-1     Waterhouse 
Duhaney Park    0-1     Arnett G.

Round 13 [Jan 20]
Arnett G.       1-2     Harbour View
Tivoli G.       4-0     Wadadah
Duhaney Park    0-0     Reno
Waterhouse      2-0     Constant Spring 
Village U.      0-1     Hazard U.

Round 14 [Feb 2?]
Harbour View	0-2	Hazard U.
Constant Spring	2-1	Village U.
Arnett G.	0-0	Waterhouse
Tivoli G.	5-0	Duhaney Park
Wadadah		2-1	Reno

Round 15 
[Feb 9,10]
Tivoli G.       3-1     Waterhouse
Village U.      1-0     Reno            [also reported 2-1]
Arnett G.       1-1     Hazard U.
Constant Spring 2-1     Duhaney Park
[Feb 20?]
Harbour View    1-0     Wadadah 

Round 16 [Feb 17]
Hazard U.       1-2     Constant Spring
Reno            0-1     Tivoli G.
Harbour View    4-0     Duhaney Park
Village U.      2-2     Waterhouse
Wadadah         0-3     Arnett G. 

Round 17 [Feb 24]
Hazard U.       2-2     Tivoli G.
Wadadah         1-1     Waterhouse
Reno            1-0     Arnett G.
Harbour View    0-0     Constant Spring
Duhaney Park    0-2     Village U.

Round 18 
[Mar 6]
Village U.      0-0     Harbour View
Hazard U.       2-0     Wadadah
Constant Spring 1-0     Reno
Arnett G.       0-0     Tivoli G.       [without spectators!]
[Mar 7]
Duhaney Park    2-4     Waterhouse

Final Table Second Round:

 1.Tivoli Gardens (Kingston)           9  6  2  1 21- 7  20  End of Round Final
 2.Harbour View (Kingston)             9  5  2  2 13- 8  17  End of Round Final
 3.Hazard United (May Pen)             9  5  2  2 12- 7  17
 4.Constant Spring (Constant Spring)   9  4  3  2  9-11  15 
 5.Village United (Falmouth)           9  4  2  3 11- 7  14
 6.Arnett Gardens (Kingston)           9  3  4  2  8- 5  13
 7.Waterhouse (Kingston)               9  3  4  2 12-10  13
 8.Wadadah (Montego Bay)               9  2  2  5  9-15   8 
 9.Reno (Savannah del Mar)             9  1  2  6  4- 9   5
10.Duhaney Park FC (Duhaney Park)      9  0  1  8  4-24   1

End of Round Final [Mar 10]
Harbour View    1-0     Tivoli G.
NB: Harbour View receive 3, Tivoli 1 bonus point.


Third Round (penultimate stage)

Tables:

Zone A
 1.Waterhouse (Kingston)              10  6  4  0 10- 3  22
 2.Village United (Falmouth)          10  6  2  2 14- 8  20
 3.Harbour View (Kingston)            10  3  5  2 20-10  14
 4.Constant Spring (Constant Spring)  10  1  4  5 11-17   7
 5.Duhaney Park FC (Duhaney Park)     10  1  0  9  7-26   3

Zone B
 1.Hazard United (May Pen)            10  4  5  1 13- 7  17
 2.Tivoli Gardens (Kingston)          10  4  3  3 13- 8  15
 3.Arnett Gardens (Kingston)          10  3  5  2  9- 7  14
 4.Wadadah (Montego Bay)              10  4  2  4 11-16  14
 5.Reno (Savannah del Mar)            10  1  4  5 12-18   7

Round 1 [Mar 13]
Zone A
Constant Spring 1-3     Duhaney Park     [1-2?]
Waterhouse      0-0     Harbour View
Zone B
Reno            2-0     Arnett G.
Wadadah         0-2     Hazard U.
cross-zone
Tivoli G.       3-1     Village U.

Round 2 
[Mar 20]
Zone A
Harbour View    2-2     Village U.
Zone B
Arnett G.       1-1     Hazard U.
Wadadah         1-0     Tivoli G.
cross-zone
Constant Spring 2-2     Reno
[Mar 21]
Zone A
Duhaney Park    0-1     Waterhouse

Round 3 [Mar 24]
Zone A
Village U.      0-0     Waterhouse
Harbour View    2-2     Constant Spring
Zone B
Hazard U.       1-1     Tivoli G.
Reno            0-2     Wadadah
cross-zone
Duhaney Park    1-3     Arnett G.

Round 4 [Mar 27]
Zone A
Waterhouse      1-0     Constant Spring
Village U.      2-0     Duhaney Park
Tone B
Reno            1-4     Hazard U.
Tivoli G.       0-0     Arnett G.
cross-zone
Wadadah         1-0     Harbour View

Round 5 [Mar 31]
Zone A
Harbour View    2-0     Duhaney Park
Village U.      4-1     Constant Spring
Zone B
Arnett G.       0-0     Wadadah
Tivoli G.       3-2     Reno
cross-zone
Waterhouse      1-0     Hazard U.

Round 6 [Apr 3]
Zone A
Harbour View    2-2     Waterhouse
Duhaney Park    2-4     Constant Spring  [1-4?]
Zone B
Hazard U.       2-1     Wadadah
Arnett G.       1-0     Reno           
cross-zone
Village U.      1-0     Tivoli G.

Round 7 [Apr 7]
Zone A
Village U.      1-0     Harbour View
Waterhouse      2-1     Duhaney Park
Zone B
Arnett G.       1-1     Hazard U.       
Tivoli G.       4-0     Wadadah
cross-zone
Reno            1-1     Constant Spring

Round 8 [Apr 10]
Zone A
Constant Spring 0-0     Harbour View
Waterhouse      2-0     Village U.
Zone B
Wadadah         2-2     Reno
Tivoli G.       0-1     Hazard U.
cross-zone
Arnett G.       2-0     Duhaney Park

Round 9 [Apr 14]
Zone A
Constant Spring 0-1     Waterhouse
Duhaney Park    0-2     Village U.
Zone B
Arnett G.       0-0     Tivoli G.
Hazard U.       1-1     Reno
cross-zone
Harbour View    5-2     Wadadah

Round 10 [Apr 17]
Zone A
Duhaney Park    0-7     Harbour View
Constant Spring 0-1     Village U.      
Zone B
Wadadah         2-1     Arnett G.       
Reno            1-2     Tivoli G.     
cross-zone
Hazard U.       0-0     Waterhouse      

Tables:

Zone A
 1.Waterhouse (Kingston)              10  6  4  0 10- 3  22
 2.Village United (Falmouth)          10  6  2  2 14- 8  20
 3.Harbour View (Kingston)            10  3  5  2 20-10  14
 4.Constant Spring (Constant Spring)  10  1  4  5 11-17   7
 5.Duhaney Park FC (Duhaney Park)     10  1  0  9  7-26   3

Zone B
 1.Hazard United (May Pen)            10  4  5  1 13- 7  17
 2.Tivoli Gardens (Kingston)          10  4  3  3 13- 8  15
 3.Arnett Gardens (Kingston)          10  3  5  2  9- 7  14
 4.Wadadah (Montego Bay)              10  4  2  4 11-16  14
 5.Reno (Savannah del Mar)            10  1  4  5 12-18   7

Aggregate Table:

 1.Hazard United (May Pen)            28 13 11  4 36-22  50  Qualified
 2.Arnett Gardens (Kingston)          28 11 11  6 31-20  47  Qualified  [3] 
 3.Harbour View (Kingston)            28 12  7  9 44-29  46  Qualified  [3]
 4.Tivoli Gardens (Kingston)          28 11 10  7 45-28  44  Qualified  [1]
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Waterhouse (Kingston)              28 11 11  6 26-21  44
 6.Village United (Falmouth)          28 12  6 10 33-25  42
 7.Constant Spring (Constant Spring)  28 10 10  8 35-39  41  [1]
 8.Wadadah (Montego Bay)              28  9  9 10 33-41  36
-----------------------------------------------------------
 9.Reno (Savannah del Mar)            28  6  8 14 27-39  26  Relegated
10.Duhaney Park FC (Duhaney Park)     28  2  3 23 13-59   9  Relegated
 
NB: between brackets bonus points earned by End of Round finals.
    top-4 qualify for championship playoff semifinals

NB: due to loss of sponsor of the 2nd level, Reno and Duhaney Park enter
    promotion/relegation playoffs with 13 other clubs (see below).

Semifinals

First Legs [Apr 21, at Harbour View]
Tivoli G.       0-0     Hazard U.
Harbour View    2-1     Arnett G.

Second Legs [Apr 24]
Hazard U.       1-0     Tivoli G.        [asdet]
Arnett G.       4-2     Harbour View

Final

First Leg [Apr 28]
Arnett G.       1-1     Hazard U.
  [Claude Davus 74og; Omar Daley 66]

Second Leg [May 5]
Hazard U.       1-2     Arnett G.
  [Cornel Chin-Sue 1og (credited to Roen Nelson);
   Eugene Barnes 76, Walter Boyd 90+1]
  [sent off: Claude Davis (Hazard) 66]



Authors: Hans Schöggl
(hans.schoeggl@sbg.ac.at)
and James Goloboy
(goloboy@uiuc.edu)

Last updated: 22 Jun 2005

(C) Copyright Hans Schöggl, James Goloboy and RSSSF 2001/05


  USO DE MEMORIA  
4,224,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.7653
Total Execution Time  0.7675
  CADENA URL  
/liga_jamaica2002
  GET DATOS  
$_GET['/liga_jamaica2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0019  SELECT type FROM routes WHERE alias = 'liga_jamaica2002'
0.0453  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=1025
0.0288  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 = 29346 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0090  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='2002' WHERE c.parentId=160 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 160 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0199  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:01:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 14:01:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0064  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:01:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0062  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:01:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0693  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0277  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29346) 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.0080  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 (29346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0101  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29346) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0142  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 (29346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0226  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29346) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0039  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 (29346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0190  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (29346) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0203  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 (29346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0384  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 = 29346 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0017  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 = 29346 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0219  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=29346 AND rel.round=28
0.0062  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 = 29346 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0065  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 = 29346 AND esl.points > 0
0.0415  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` = 29346 ORDER BY creation_date DESC LIMIT 0, 10
0.0422  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` = 29346
0.0274  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 `calendars2002` 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` = 29346 AND c.`round` = 28 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events2002` e INNER JOIN calendars2002 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 = 29346 ORDER BY total DESC LIMIT 40
0.1580  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 `events2002` e INNER JOIN calendars2002 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 = 29346 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0648  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 `tables2002` 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 = 29346 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0648  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 29346 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0648  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 = 29346 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0648  SELECT data1, data2 FROM services_tags WHERE categoryId=160
0.0648  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 160 AND l.year = 2002 ORDER BY l.group_code ASC
0.0648  SELECT group_code, extraName from `leagues` WHERE categoryId=160 AND year=2002