DB was unable to successfully run a query.
Unknown column 'date' in 'order clause'

SELECT c.*,a.cat_id,a.title,a.desc FROM (SELECT * FROM yn_comments WHERE status=1 AND source_id=154 AND parent_id=0 ORDER BY `date` ASC) AS c LEFT JOIN yn_articles AS a ON a.id=c.source_id ORDER BY c.`date` ASC