Форум пользователей MySQL

Добрый вечер!
Подскажите как исправить

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

The Error returned was:
Unknown column 'date' in 'field list'

Error Number:
1054

SELECT DISTINCT DAYOFMONTH(date) as day FROM
dle_post WHERE date >= '2010-10-01' AND date <
'2010-10-01' + INTERVAL 1 MONTH AND approve AND date
< '2010-10-17 21:41:31'