![]() |
![]() ![]() |
GOODS-H: a guaranteed time key programme with HerschelThe Herschel space observatory is a scientific mission of the European
Space Agency (ESA). The space telescope is dedicated to the study of
the cold universe by performing astronomical observations in the far
infrared and submillimetre parts of the electromagnetic spectrum. |
Media
News
get_all SELECT a.*, b.`theme` as theme, c.`theme` as theme2, d.`theme` as theme3, DATE_FORMAT(a.`date_debut`,'%d/%m/%Y %H:%i') as date_debut_fr, DATE_FORMAT(a.`date_debut`,'%Y-%m-%d') as date_debut_Ymd, DATE_FORMAT(a.`date_debut`,'%a, %b. %D, %Y %H:%i') as date_debut_en, DATE_FORMAT(a.`date_debut`,'%H:%i') as date_debut_Hi, UNIX_TIMESTAMP(a.`date_debut`) as dts_debut, DATE_FORMAT(a.`expiration`,'%d/%m/%Y %H:%i') as date_fin_fr, DATE_FORMAT(a.`expiration`,'%Y-%m-%d') as date_fin_Ymd, DATE_FORMAT(a.`expiration`,'%a, %b. %D, %Y %H:%i') as date_fin_en, DATE_FORMAT(a.`expiration`,'%H:%i') as date_fin_Hi, UNIX_TIMESTAMP(a.`expiration`) as dts_expir, DATE_FORMAT(a.`pub_date`,'%d/%m/%Y') as date_emission, UNIX_TIMESTAMP(a.`pub_date`) as dts, UNIX_TIMESTAMP(NOW()) as ndts FROM tbl_news a JOIN tbl_news_description b ON a.`id_theme` = b.`id_theme` JOIN tbl_news_description c ON a.`id_theme2` = c.`id_theme` JOIN tbl_news_description d ON a.`id_theme3` = d.`id_theme` WHERE a.news=1 AND (a.`id_unit` LIKE '3' OR a.`id_unit` LIKE '3,%' OR a.`id_unit` LIKE '%,3,%' OR a.`id_unit` LIKE '%,3' OR 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 '%2%' AND DATE_FORMAT(a.date,"%Y")="2023" ORDER By a.`pub_date` desc,`id_news` desc SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.date' in 'where clause' |