4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica
						
Premier Football League 

Tables:

Zone A
 1.Asante Kotoko (Kumasi)            14  9  2  3 24-10 29  Qualified
 2.King Faisal Babies (Kumasi)       14  8  3  3 19- 8 27  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Real Tamale United (Tamale)       14  7  2  5 13-13 23
 4.Arsenal (Berekum)                 14  6  3  5 13-16 21
 5.AshantiGold (Obuasi)              14  5  5  4 18-15 20  [*]
 6.Tano Bafoakwa (Sunyani)           14  4  2  8  9-18 14
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 7.Okwahu United (Nkawkaw)           14  2  5  7  8-16 11  Relegation PlayOff
---------------------------------------------------------
 8.Brong Ahofu United (Sunyani)      14  3  2  9 11-19 11  Relegated

[*] Obuasi Goldfields Sporting Club Ltd. were renamed AshantiGold Sporting
    Club Ltd. on April 16 due to new owners Anglogold Ashanti.

Zone B
 1.Hearts of Oak (Accra)             14  9  2  3 29-17 29  Qualified
 2.Heart of Lions (Kpando)           14  6  5  3 15-13 23  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Liberty Professionals (Accra)     14  6  2  6 23-17 20
 4.Power FC (Koforidua)              14  5  3  6 19-19 18
 5.Real Sportive (Tema)              14  4  5  5 12-15 17
 6.Feyenoord Academy (Goma Fetteh)   14  5  2  7 11-16 17
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 7.Hasaacas (Sekondi)                14  4  4  6 11-17 16  Relegation Playoff
---------------------------------------------------------
 8.Great Olympics (Accra)            14  4  3  7 13-19 15  Relegated

Round 1
Zone A
[May 23]
Kotoko		4-1 BA United
  [Frank Osei (2), Yusif Chibsah, ?; ?]
Arsenal		1-0 Okwawu
RTU		0-2 King Faisal
  [Abubakari Yahuza (2)]
[May 30]
Bofoakwa	0-0 AshantiGold
Zone B
[May 23]
Hearts of Oak	3-0 Liberty
  [Emmanuel Osei Kuffour (2), Abladey Morgan]
Real Sportive	1-1 Olympics
Hasaacas	0-0 Power
[May 30]
Feyenoord	0-1 Heart of Lions
  [Solomon Awuku 85]

Round 2 
Zone A [Jun 9]
Okwawu          1-0 Bofoakwa
  [Obed Owusu 11]
AshantiGold     4-1 Kotoko
  [Valentine Atem 43pen, ?, Ofosu Amoah 62, Awudu Ronaldo 66;
   Aziz Ansah 23pen]
King Faisal     2-1 Arsenal
  [Godwin Ablordey 27pen, Ishaak Debrah; Alex Asamoah 80]
BA United       2-3 RTU
   [?; Peter Yakubu (2), ?]
Zone B
[Jun 9]
Heart of Lions  1-0 Hasaacas
  [Samuel Yeboah 23]
Power           2-3 Hearts of Oak
  [Samuel Ocran 14, Mohammed Bello 60; Emmanuel Osei-Kuffour 7,
   Amankwah Mireku 52, Acquah Harrison 82]
Olympics        0-1 Feyenoord
  [Isaac Borketey Bortey 90]
[Jun 10]
Liberty         4-0 Sportive
  [Kwame Darko 6, 10, Jonathan Quartey 46, Eric Bekoe 90]

Round 3 [Jun 13]
Zone A
Kotoko          3-1 Okwawu
  [Charles Taylor 38, Shilla Alhassan 50, Mbola Sandjie 85; Nasiru Gani 60]
Bofoakwa        1-0 King Faisal 
  [Eric Ansah 75] 
AshantiGold     3-2 BA United  
  [Lamine Nasir 15, Opoku Ware 62, Awudu Ronaldo 72;
   Kwasi Boateng, Daniel Bomfa]
Arsenal         2-0 RTU
Zone B
Hasaacas        1-1 Olympics  
Hearts of Oak   4-2 Heart of Lions 
  [Prince Tagoe 3, 51, Lawrence Adjei 45, 54; Samuel Yeboah 26, 58]
Power           1-1 Liberty
  [Alan Shearer 86; Obeng Darko 65]
Feyenoord       0-0 Sportive 

Round 4
Zone A
[Sep 18]
King Faisal	0-1 Kotoko
  [Shillah Alhassan 86]
[Sep 19]
BA United	1-2 Arsenal
Okwawu		abd AshantiGold	[abandoned at 1-0 in 18' due to rain]
[Sep 26]
Okwawu		0-0 AshantiGold	[replay]
[Nov 5]
RTU		1-0 Bofoakwa
Zone B
[Sep 18]
Heart of Lions	2-1 Power
  [Taju Bini 36, Siba Ali Tahiru 80pen; 'Alan Shearer' 48]
[Sep 19]
Liberty		4-0 Feyenoord
Sportive	4-0 Hasaacas
Olympics	0-3 Hearts of Oak
  [Prince Tagoe 23, 51, Eric Nyarko]

Round 5 
Zone A
[Sep 22]
Okwawu		1-0 BA United
  [Thomas Avegbordor 57pen]
[Sep 23]
Bofoakwa	3-1 Arsenal
  [Osei Boateng 19, Eric Ansah 29, 45; ?]
AshantiGold     1-1 King Faisal
  [Eric Gawu; Valentine Atem 40]
[Sep 29]
Kotoko          1-0 RTU	
Zone B [Sep 22]
Hasaacas	2-0 Feyenoord
Power		3-1 Olympics
Heart of Lions	2-2 Liberty
  [Samuel Yeboah 18, 76; Tanko Adams 7, Michael Helegbe 9]
Hearts of Oak	1-2 Sportive
  [Wisdom Abbey 90; Hamza Abdulai, Sam Nlineaba 45]

Round 6
Zone A
[Oct 3]
King Faisal	abd Okwawu	[abandoned at 1-0 at half-time due to rain]
Arsenal		0-0 Kotoko
BA United	0-1 Bofoakwa
RTU		2-1 AshantiGold
[Oct 4]
King Faisal	2-0 Okwawu	[replay]
Zone B
[Oct 2]
Liberty		1-2 Hasaacas
[Oct 3]
Feyenoord	0-1 Hearts of Oak
Olympics	0-1 Heart of Lions
Sportive	0-0 Power

Round 7
Zone A [Oct 13]
BA United	0-0 King Faisal
Okwawu		1-1 RTU		[also reported 1-0]
Kotoko		2-0 Bofoakwa
AshantiGold	0-0 Arsenal
Zone B
[Oct 13]
Power		3-2 Feyenoord
Hearts of Oak	1-1 Hasaacas
Heart of Lions	0-0 Sportive
[Oct 14]
Liberty		3-0 Olympics

Round 8 [Oct 20]
Zone A
King Faisal	1-0 BA United
RTU		1-0 Okwawu
Bofoakwa	0-1 Kotoko
Arsenal		0-0 AshantiGold
Zone B
Olympics	1-0 Liberty
Feyenoord	2-1 Power
Hasaacas	0-2 Hearts of Oak
Sportive	0-2 Heart of Lions

Round 9 [Oct 24]
Zone A
Okwawu		2-2 King Faisal
Kotoko		4-0 Arsenal
Bofoakwa	0-2 BA United
AshantiGold	2-0 RTU
Zone B
Hearts of Oak	3-0 Feyenoord
Heart of Lions	1-0 Olympics
Power		2-1 Sportive
Hasaacas	2-0 Liberty

Round 10
Zone A [Nov 3]
RTU		1-0 Kotoko
Arsenal		2-1 Bofoakwa
King Faisal	2-0 AshantiGold
BA United	0-0 Okwawu
Zone B
[Nov 3]
Feyenoord	3-0 Hasaacas
Olympics	2-0 Power
[Nov 4]
Liberty		3-2 Heart of Lions
Sportive	1-2 Hearts of Oak


Round 11 [Nov 7]
Zone A
Arsenal		1-0 BA United
AshantiGold	2-0 Okwawu
Bofoakwa	0-0 RTU
Kotoko		1-0 King Faisal
Zone B
Hasaacas	2-0 Sportive
Feyenoord	2-0 Liberty
Hearts of Oak	2-3 Olympics
Power		2-0 Heart of Lions

Round 12
Zone A [Nov 10]
Okwawu		1-1 Kotoko
King Faisal	3-0 Bofoakwa
BA United	1-0 AshantiGold
RTU		2-0 Arsenal
Zone B
[Nov 10]
Olympics	3-1 Hasaacas
Heart of Lions	1-1 Hearts of Oak
Sportive	1-0 Feyenoord
[Nov 11]
Liberty		2-1 Power

Round 13 [Nov 17]
Zone A
Bofoakwa	1-0 Okwawu
Kotoko		4-0 AshantiGold
Arsenal		1-2 King Faisal
RTU		2-0 BA United
Zone B
Hasaacas	0-0 Heart of Lions
Hearts of Oak	3-2 Power
Feyenoord	1-0 Olympics
Sportive	1-0 Liberty

Round 14
Zone A
[Nov 20]
King Faisal	2-0 RTU
[Nov 21]
BA United	2-1 Kotoko
Okwawu		1-2 Arsenal
AshantiGold	5-2 Bofoakwa
Zone B
[Nov 20]
Liberty		3-0 Hearts of Oak
[Nov 21]
Olympics	1-1 Real Sportive
Power		1-0 Hasaacas
Heart of Lions	0-0 Feyenoord

Tables:

Zone A
 1.Asante Kotoko (Kumasi)            14  9  2  3 24-10 29  Qualified
 2.King Faisal Babies (Kumasi)       14  8  3  3 19- 8 27  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Real Tamale United (Tamale)       14  7  2  5 13-13 23
 4.Arsenal (Berekum)                 14  6  3  5 13-16 21
 5.AshantiGold (Obuasi)              14  5  5  4 18-15 20  [*]
 6.Tano Bafoakwa (Sunyani)           14  4  2  8  9-18 14
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 7.Okwahu United (Nkawkaw)           14  2  5  7  8-16 11  Relegation PlayOff
---------------------------------------------------------
 8.Brong Ahofu United (Sunyani)      14  3  2  9 11-19 11  Relegated

[*] Obuasi Goldfields Sporting Club Ltd. were renamed AshantiGold Sporting
    Club Ltd. on April 16 due to new owners Anglogold Ashanti.

Zone B
 1.Hearts of Oak (Accra)             14  9  2  3 29-17 29  Qualified
 2.Heart of Lions (Kpando)           14  6  5  3 15-13 23  Qualified
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 3.Liberty Professionals (Accra)     14  6  2  6 23-17 20
 4.Power FC (Koforidua)              14  5  3  6 19-19 18
 5.Real Sportive (Tema)              14  4  5  5 12-15 17
 6.Feyenoord Academy (Goma Fetteh)   14  5  2  7 11-16 17
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 7.Hasaacas (Sekondi)                14  4  4  6 11-17 16  Relegation Playoff
---------------------------------------------------------
 8.Great Olympics (Accra)            14  4  3  7 13-19 15  Relegated

NB: first ever relegation for Great Olympics

NB: although originally the top-2 of both groups were to take part in
    the championship play-off, on Feb 2, GFA decided to have the title 
    settled in a one-match play-off between Hearts of Oak and Asante 
    Kotoko.

Third Place Match [Mar 13, 2005; Kumasi Sports Stadium, Kumasi]
King Faisal	3-2 Heart of Lions
  [Sumaila Yahaya 15, Ben Wilson 38, Eric Gawu 61; Jonathan Quartey 42,
   Obed Asamoah 63]

Championship Playoff [Apr 3, 2005, Ohene Djan Sports Stadium, Accra;
                      att: 40,000]
Hearts of Oak   1-0 Asante Kotoko 
  [Prince Tagoe 76]
  [Hearts: Eben Dida Armah, Micheal Donkor (Dan Oppong), Hassan Mohammed,
           Kwabena Boafo, Dan Coleman, James Boateng (Francis Bossman),
           Bernard Don Bortey, Adjah Tetteh, Eric Nyarko (Adnan Ali),
           Prince Tagoe, Alfred Nii Larbi;
           coach: Sir Cecil Jones Attuquayefio; 
   Kotoko: Eric Nii Baah, Micheal Ofosu Appiah, Godfred Yeboah, Michael
           Asante, William Thompson, Yusif Chibsah (Kweku Essien),
           Michael Osei, Edmund Owusu Ansah (Kojo Poku), Elvis Opoku
           (George Yamoah), Issa Ahmed;
   ref: Kokou Djaoupe (Togo);
   red card: Dan Oppong (H) 90]



Relegation Playoff [Dec 19, Ohene Djan Sports Stadium, Accra]
Okwahu United	1-0 Sekondi Hasaacas
   [Thomas Avorgbedor 11pen]

NB: Okwahu United retains its place in the premiership;
    Hasaacas play off against the third-placed team in the national
    middle league.


Promotion/Relegation Playoff [Mar 18, Ohene Djan Stadium, Accra]
Hasaacas        5-1 Prestea Mine Stars


NB: Qualified for the GHALCA Top Four are Asante Kotoko (Kumasi),
    King Faisal Babies (Kumasi), Hearts of Oak (Accra) and 
    Heart of Lions (Kpando).



Author: José Batalha
(jose.batalha@netvisao.pt)

Last updated: 23 Nov 2006

(C) Copyright José Batalha and RSSSF 2004/06
						


  USO DE MEMORIA  
4,273,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1060
Total Execution Time  0.1079
  CADENA URL  
/ghana2004
  GET DATOS  
$_GET['/ghana2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'ghana2004'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ghana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=2667
0.0020  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 = 30924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='2004' WHERE c.parentId=162 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 02:27:40' 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-05-02 02:27:40' 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=4 AND last_update > '2024-05-02 02:27:40' 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=3 AND last_update > '2024-05-02 02:27:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ghana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30924) 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.0019  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 (30924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30924) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  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 (30924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30924) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  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 (30924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30924) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0024  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 (30924) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  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 = 30924 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0021  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 = 30924 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0031  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=30924 AND rel.round=30
0.0028  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 = 30924 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0028  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 = 30924 AND esl.points > 0
0.0029  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30924 ORDER BY creation_date DESC LIMIT 0, 10
0.0044  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30924
0.0028  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 `calendars2004` 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` = 30924 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0020  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 `events2004` e INNER JOIN calendars2004 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 30924 ORDER BY total DESC LIMIT 40
0.0034  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 `events2004` e INNER JOIN calendars2004 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 = 30924 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0034  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 `tables2004` 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 = 30924 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 30924 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 30924 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0034  SELECT data1, data2 FROM services_tags WHERE categoryId=162
0.0034  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 162 AND l.year = 2004 ORDER BY l.group_code ASC
0.0034  SELECT group_code, extraName from `leagues` WHERE categoryId=162 AND year=2004