Unknown column 'DATE' in 'order clause'
SELECT * FROM biens WHERE ((VENDU='N') OR (VENDU='O' AND DATEVENTE>DATE_SUB(NOW(), INTERVAL 30 DAY))) AND AFFICHER=1 ORDER BY DATE