SELECT PAGE.*, count(ID_ACTUALITE) as NBACTU FROM PAGE LEFT JOIN ACTUALITE ON (ACTUALITE.ID_PAGEAPPEL = PAGE.ID_PAGE AND ACTUALITE.ACT_DATEPUBLICATION <= '1337896800' AND ACTUALITE.ACT_DATEEXPIRATION >= '1337896800' ) WHERE PAGE.ID_PAGE=www.rhone-alpes.cci.fr GROUP BY ID_ACTUALITE