SELECT et.id, r2.nom AS nom_residence, r2.adressePage, r2.ville, e2.titre AS emploi, et.residence, e2.disponible, e2.datePublication, e2.possibilite, e2.pasDeResidence, te.nom AS categorie FROM emplois_temp et LEFT JOIN residences r2 ON r2.id = et.residence LEFT JOIN emplois e2 ON e2.id = et.emploi LEFT JOIN types_emplois te ON te.id = e2.type WHERE (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') =  AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) 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' ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC, e2.titre ASC LIMIT 15