MySQL Error!
------------------------

The Error returned was:
Unknown column 'rating' in 'order clause'

Error Number:
1054

SELECT id, title, date, alt_name FROM dle_post WHERE approve='1' AND date >= '2012-04-22'AND date < '2012-04-22' + INTERVAL 1 MONTH ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,10