vsnOQ9AhOQ6pBXoJvr5lb0C9oEJIZIcxY1z3tMtTclRnlvuMFFamd9KZruCIY1520xJct2By58iu8dNKy1U0mbPDME/hLoWFBvgsccVZvgAX7FMb8ZkMxN9e7fOhBJo97jMnS4oxbl83CuJaeT1hlt33LyuLSMeBfLH6kIspUxhghNbhSaT4+n7SHawpFd1PoMCVbNGerD8jWwZ9on3CcR4DrzGMhyAvxOUt1RfxDvVP9Foihz2BescbjF+KsviqmxDAYPt45B8gO3dlHm8pxX7A5K2F+C+MWcSu/Hn3cRYsuw10+Oo80oLfWyrTf0mJsqK6qCIdhn67cQRREQPuQCLv7zUrm0tUkltGokGxzX9/ebf9dyt/wIpugLwPsqJhZSLxPTxOIkIN9e4yzLVWLQnCqS1Fm9cb4tf2ha7gR9Ml0ycAVZaKMYN7zFbBnCcCMYqEPSVqqe+09dj0Dv72OItWD8+E3lgV4sCp233gmCT5dJqTk0lIlyygYXfd/n4gCtzPhXIix8lYfEw3NjiseCp9H4M6iDkmHuWLmRFUEZlRhVZUzZiUmMRpcbfLBBGAtN4XZLRGc7Jt1BCwDJuN1an10QeiTOAttsBLXsMJlpSUKplp/cvXKJ+d7fmX1/SM0gpga1YIv0QYdUXOBaF9fr7b+7oQ5GVJmqesyiux8OzUNmVCG9IMKvIcFl75rFCFlrLy/u/2bo8MGR5K6Wv73kYyYZpazLAlsL3cEv7dnotvqXQXBhgH0f8DlPnM3q6ZeW9ZmGtPkwc11qkkV0K/A9XEYg0aJVLhl+wGo1LMjYu2puLLTmiJMsSQ2LMzGPHMGkU67oSmfzYfpkv785mdYmt8mW0k9hdjlwPfp8HJgDdoFd/OQzSY3gAdv9gH9FRU66Y9PeSi8lUzhMOdgMczmFqr/VJHiIzE5+etZJ4MGT2Qz3Ks8rdwBpJnSZBW6X6oJ+7vyIT3VRBcle2+yWeKdYyQ0evivay2FvFAaoQIWy289SvHGhs7GdB60ZqeA3/TGFERg+160W5ggGmgxLp01noUJrp14cMmQ8fJ8fk0yNG78yonoU8uKDuTSUOgCgbrSKZhamPO54l1vsOkUxMKK848PjTiMySABhOH/owMb5egOHUvHdyVYL7pgrsVbqlvy0oL/yq/o464jC/YWzrr//slagpPfr7SVhQM5SKn7gO+/9ox6FiZo0ySLOZkT3VTVRv6rgOBi4IQgDzgrpZHAF13NzkFTC7e9YisppFV6/rf2v9sEWY75oXWw9b6C9CZvl6X1b+IW419i1MnMitxnMcnHTKtiPNtoE1V74BIgd0AU7IxA/CzJs3wyyGvz1/MkH1aGec1+M4HVoFB5R6cPpXeFUFvOXOIHzyDWbA=
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