GOODS-H: a guaranteed time key programme 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 Great Observatories Origins Deep Survey : far-infrared imaging with Herschel" (GOODS-Herschel) is an open time key programme of 362.6 hours of observation with the Herschel instruments PACS and SPIRE from 100 to 500 microns whose main objectives are:

- to resolve most of the cosmic star-formation rate density up to a redshift of z~4, by detecting ~2000 galaxies in the unexplored regimes of normal galaxies up to z~1, luminous IR galaxies up to z~2 and ultra-luminous IR galaxies to z~4.

- to bridge IR and ultraviolet selected galaxies down to the level where both agree up to z~1.5 and potentially up to z~4.

- to identify and study the buried Compton Thick active galactic nuclei responsible for the still unresolved 30% fraction of the cosmic X-ray background, which peaks at 30 keV.





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")="2024" ORDER By a.`pub_date` desc,`id_news` desc

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