A Database Error Occurred

Error Number: 1054

Unknown column 'ASC' in 'order clause'

SELECT videos.*, categories.class, categories.name as cat_name FROM (`videos`) JOIN `categories` ON videos.category_id=categories.id WHERE categories.class = 'date' ORDER BY `ASC` desc LIMIT 30