MySQL error!

Unknown column 'comment_date' in 'order clause'(Errno=1054)

Your query:
SELECT DISTINCT evo_comments.* FROM ((evo_comments INNER JOIN evo_posts ON comment_post_ID = ID) ) WHERE comment_type IN ('comment') AND ( post_status IN ('published') ) ORDER BY comment_date DESC LIMIT 20