1 - SELECT * FROM emplois_temp et WHERE (SELECT groupe FROM residences r WHERE r.id = et.residence) = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' AND (SELECT approuve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1' AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'