CEA

Guaranteed time key programmes with Herschel

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 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 and in giant molecular clouds across the Milky Way. The guaranteed programmes are the Gould Belt survey and the HOBYS survey. Regions such Taurus, rho-Ophiuchi, Orion, Vela and Cygnus X will be studied. 600 hours are devoted to these programmes.

More

 

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 '2' OR a.`id_unit` LIKE '2,%' OR a.`id_unit` LIKE '%,2,%' OR a.`id_unit` LIKE '%,2' OR a.`id_unit` LIKE '5' OR a.`id_unit` LIKE '5,%' OR a.`id_unit` LIKE '%,5,%' OR a.`id_unit` LIKE '%,5' OR 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")="2024" ORDER By a.`pub_date` desc,`id_news` desc

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