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
BeatBiz Free
MP3 Downloads And Streaming Music
Music
Charts
Albums
Musicians
Events
Members
Members
Images
Blogs
Reviews
Sign Up
Register New Account
Log In
Login
Retrieve Your Password
United Kingdom
Portugal
United States of America
Netherlands
Greece
Pakistan
Bulgaria
Germany
France
Belgium
Sweden
Canada
India
Finland
Spain
Italy
Australia
Russia
Denmark
Switzerland
Featured Music
Macedonia
Argentina
