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=accueil.php GROUP BY ID_ACTUALITE