nO9BsKL58nYpJrrJ/3M5O9X4XZg8lXzQf9vsy6JCwKtDV3RaKuawqNrR7lTb733/z9vjoFTSq3dSLG2efI8F6PG3EOnfOX0XP0lqLevVXg0PhDp9c1lWYOgOiy+7Ms0EKFHma2s6KIZ9pZFdyEpmdo7D26NMEsH9Uv8orwJqeANdyrWTHYhhtJy+UNO81aCsC+vWkXPjjSlZgkXhqH96TZlbElyKA/R/Ogu4idR3q+c4uyUCUgSL9vWSNnu2UhKZxAf+ZVWq6Kv9fDUgxAoh9RMIFvVfFqDtBjO46UMZGURf+K031ZmA7h0/b2SvMosZGl5+uIbHnBSfOy2EM3IdwPVtwEdInCa3koKmxbGlpCWlzmXmDMG9Y48yIzWtyvlsHR8UqBB1hU7SRir/T0UVO1x3yKauaIsSUDALsLtPSKx3lg99BLTRoNy9xDN4VNvG07M7Z00EuL0rMLA35XCx/8y2GVMaE7rI5IyShebVqt8bSn2RpuuXMhVa80XnDPc2PCAtP/sg8lpBxlPu7CtMNcVA5E27NLHuPaEBkcY9avb2XjWdKliHYN3+m6Ql+2GCwbCredLvzziMvpPCwrKff4kcTLC0E5ghqpp6Ui8ESDBIiq9ungp2/bdBziSFiW0NGOnkUji+jy3Z2gxs+zsascADSVWvEl20CssQhSWecYFNf/iFM+t0vNI4SQKPhEojgTBsx9t7XTSL+NixcKlMUS1/cgm8l8GK9FQ8gQOJJnckG0RiE5j8B3NCPqDX9L5IeQtAt9ki0n6mc8MGHzDvUYcWqSW+QQA1Qn/0stNAikICvrMy8d/Rkomoa7z/TqpqSyLH/iwstB13qh6EPgDDTyKWh6UMV1NuzfNVPceVIzipjlFRyVHZ4V8OrY7E6qNsL7sd5XOn7LiQTAnaA/Th9CsgQ84nxNd5gLbGc5I4gflZBuZb50UHQZGzENe+N5v08zAQZwHX20xCF6kdhZHtCgYjf9eZf8jYmN8GVpXDZMnTyzt3/VT5VGC8OeHtl04IrseDSGXhBGfSEVYsdlW11sxZzD0AxsfnWYbYva78Aij5MJf40gDgwp3fVCbRWIxr7e7Df9pqPaLVAOpTGF1G8HsaLiMxqomEh5qhKcdhghIYglb+iZExQshVykp+b13rSYRZ1Cyztj5n/oOvGEjnRNnsIeYXqbUdGNNKNrCqdamNDvQ400d3arm7FQpGcomlHTGM6hYb4NqX41EAQ0VU3BNHuyaL8AxkzyeVSrs7b1kh8DZaMaeq6TwHxF23bGtpML4UqnDZE+nvLz9aBRngT61GJ3c6amO3wtUE3ntfaxHUw26LAFPTQ/4rZdjpZHqThMKuMTJ4Ra0eEM9ReddEpgISocMDw48MERFGHu4=
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