SELECT title, track_name, track_size, track_date, track_type, PLAYS, UID, USERID, ARTIST, TIME, track_info, AID, f.genre, dl, f.location, dir, playtime, bitrate, plays_week, downloads_week, plays_month, downloads_month, total_downloads, paypalmail, sellable, currency, price, band, stars, ratings, Country, GROUP_CONCAT(DISTINCT track_date ORDER BY track_date DESC), DATE_FORMAT(track_date,'%a %D, %b, %Y') AS track_date2 FROM music f,artist WHERE USERID = AID AND f.active = 0 AND streamoption = 0 AND (f.title LIKE '%%' OR f.tags LIKE '%%' OR f.ARTIST LIKE '%%') GROUP BY USERID ORDER BY plays_week + downloads_week DESC
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||