by
·

Fatal error: Wrong SQL: SELECT stat.*,usr.username FROM ( SELECT usr.user_id,usr.artist_id,ar.name as artist_name, "" as release_id, "" as release_name, usr.date,"Followed" as status FROM v2_user_artist as usr LEFT JOIN v2_artist as ar ON ar.artist_id = usr.artist_id UNION ALL SELECT usr.user_id,rls.artist_id,ar.name as artist_name, usr.release_id, rls.title as release_name, usr.timestamp as date, "Listened" as status FROM v2_user_listen as usr LEFT JOIN v2_release_group as rls ON rls.release_id = usr.release_id LEFT JOIN v2_artist as ar ON rls.artist_id = ar.artist_id WHERE read_status = 1 ) as stat LEFT JOIN v2_users as usr ON usr.user_id = stat.user_id WHERE stat.release_id = ORDER BY date DESC LIMIT 10 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY date DESC LIMIT 10' at line 12 in /home/amiaarfz/numutracker/web/release-single.php on line 116