get_all

SELECT a.*,b.theme,UNIX_TIMESTAMP(a.date) as dts, UNIX_TIMESTAMP(NOW()) as ndts FROM tbl_news a, tbl_news_description b WHERE a.id_theme = b.id_theme AND a.id_theme <> 10 AND (a.`id_unit` LIKE '1' OR a.`id_unit` LIKE '1,%' OR a.`id_unit` LIKE '%,1,%' OR a.`id_unit` LIKE '%,1') AND a.publiable LIKE 'oui' AND a.moderateur<>'' AND serveur LIKE '%1%' ORDER By a.date desc,id_news desc

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.date' in 'field list'