[Arved Yagami]

I'm getting this error

SELECT media.*, media_service.*, media_category.*, IF(NOT ISNULL(user.userid), user.username, media.username) AS username
			FROM vbmedia AS media
			LEFT JOIN vbmedia_service AS media_service ON(media_service.serviceID = media.serviceID)
			LEFT JOIN vbmedia_category AS media_category ON(media_category.categoryID = media.categoryID)
			LEFT JOIN vbuser AS user ON(user.userid = media.userID)
			WHERE media_category.catOrder != '0'
			ORDER BY media.favorites DESC, media.comments DESC, media.views DESC
			LIMIT 6;

MySQL Error   : Unknown column 'media.favorites' in 'order clause'
Error Number  : 1054