Welcome to the HOBYS/Herschel key programme Web page

The 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. The HOBYS guaranteed time key programme for the study of star formation with the PACS and SPIRE instruments focuses on imaging star-forming regions in giant molecular clouds across the Milky Way. Regions such Orion, Vela and Cygnus X will be studied. 120 hours are devoted to these programmes.



HOBYS Key Programme




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 '5' OR a.`id_unit` LIKE '5,%' OR a.`id_unit` LIKE '%,5,%' OR a.`id_unit` LIKE '%,5') AND a.publiable LIKE 'oui' AND a.moderateur<>'' AND serveur LIKE '%2%' AND DATE_FORMAT(a.date,"%Y")="2019" ORDER By a.`pub_date` desc,`id_news` desc

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