Welcome to the Gould Belt survey 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 Gould Belt guaranteed time key programmes for the study of star formation with the PACS and SPIRE instruments focus on imaging star-forming regions in the Gould Belt. Regions such Taurus, rho-Ophiuchi will be studied. 460 hours are devoted to this programme.



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

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