hLcPu1dJ5VWBlfjbpu52OgWpzeG+751LNTWIpnLu24yliUy1VnuC+5eFxbkAVkyWziTESwXb85oaTUSGAiRqk4uhnX97Qj6mjwbIxXDf/9p5EVJXT3/3H26LzvQzXO4UqzLvs8muzFWaynOlpeP3gFCEIXPCTXowVaWCuQlXbxD8nj5M4NlL71N+Vsevb4w3bZNHOVqAFiaPd62tdPhyZobS51G5RgL6/gtVIi9bA1sYDydlKSGq6Yv4Q3XhYEa2nh8hAIXSfev7E/i7KGRBS54ffpjaV9stGMEVhZg4FSIhAJrwYP2xjNVo+WUxhpFHKncYJojZXkaad7vL49SfdnvhSKJs+2Ss+bZjar2zztSGDwkGUMKK+S/eT13sAmwARkWdp2J2PxqQHx7iSPrt4sOSBwT2A7mMyhsuoV1ItWz1T0QnO71CwKtIHrX1aKsFSdpgCvxkhRLjyfkTbjRQKTjqJ11KYA4E/tPuByQl5hthi51nUC9WgDUd31vLiZ+RiHoDQixtjEFFzpBQb177QxiHgM5p0p9SrLzXjHGKJ9L4JdHJ+j5u8tffeV2YzHmqDNsVmaf7XMan+RufzLO4lPsRTyRs0aNaCEjRtjuAs35C/zJmDkmJh8eiIlH0ZYaRD7vkhmEkvA0SBZuIEjFBXFFDGYBP6A282MOJiVfKJZXlADJqng7iGb/E3/eIlZq6iSK8LV2NcI/FwazIpGkRsZrP6GQ6wANAyCDIxQPqwuJaDTYMCjdaW0nu8flTC3DVf182bsv+LrFgC8gHX9iB6k2xFKL6tUyp8U2Koq9KEuZc0l/Nka7ZfvHfkhpeToXQImtg/5XicYzcX6kAu/1JBSf8jMpbTZJ7uJS4cAWQw2JIX5+o95DnW0dK3MHyKgY+QYdwtFA7GR180QpOgKJ23IOoQozut63rzM5FmMLt3Z8CfJAUyAZ4A5JNOs5teKRQZ3MmJy7jRMndYm5FnnRwLh95irWma2/PRuOYLN9vCvnMEFPsEi+E/OvgrYZNIpjnCE9EA1yFruUiDq73wChhf+gd5AH+JrTgCKYVLFFktvKdyl4Su3ynxuWwmL11ezMY2AivheLToZfCgWsznlpPnvBvZsqBr3Oothe0GeTU0CYiYoQqlbamvxSixEJDNcAIlp6SfOWeh+xu/d/WDHQa/yO7A0GxFnX0c0QMjupCWNW3ApaLeyP9sIFf5wyFj1ilyjUECeByOsDOFWksaqlTxPtVmaiv9Fq0pFbmUTbudNA1PmH2+cfo92aQ0lcxNYWcPAisGRH6fTVm7rJhKhQe5MzqKREOJQjTIVamR3DXCu8phVFXsK2m4SZ32R376nwKHsbAW6ofDEeOgaYhkNavRDqQUDOUn7fwBZjs1Kc=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100