Query error:
SELECT * FROM `media` LEFT JOIN `group` ON (`media`.`groupid` = `group`.`group_id`) WHERE `status` ='true' AND (`suspended`!=1 OR `suspended` IS NULL) ORDER BY lastviewed DESC LIMIT 0,12

Unknown column 'lastviewed' in 'order clause'