MySQL ERROR

1064

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 dateadded desc, a.album_id DESC LIMIT 6' at line 5

Query: SELECT a.*, m.username, m.picture, m.picture_active, m.picture_adult, m.joindate FROM vld_albums AS a, vld_members AS m WHERE m.member_id=a.member_id AND a.active='1' AND m.group_id NOT IN (4,6) AND m.member_id= ORDER BY dateadded desc, a.album_id DESC LIMIT 6