MHlxU15/d/ajmR0OtpCZ0PS35v187hg3yijXC9rcnJ8KHNs9W24Z6fZDaZnGgIw9/WEEjPEv4SFYTpVAtbkI9c3nVOTS1LpckMGaE9MO3qEb3SppZdBEPfcJeqCJzt/6iryajGTHhDx9j7pDEnSy8gUgu039pTxuwBod4SANuT3HABPfJt4uOArNr7D4yiHIzAEr+HBPe4ykuXsuKLHlEbZUmPWg9XmTG28VAGlaej1ERqog3Kuf6p/JyCre7ERajMLbUiUn8yEYQCiKSujG8Fu+xgAyOLRZ68WRTRpcXC4ZbVkxHvhbugv8BhRyyiz4VlUAmqS0GUl0HtrRHKoPgsVQYqeh0+b/PKRuMGV4p+Uoh7g2yJaFDgN8Y8raWaHAw9B0YmCJsy0IMYlaOUaWyMQew4RDxQI2QRlAJoDYy+FedIL5yxXbTDitLnEAELKsZMtmfvWNB42zeIOiuK4xziJeT61NZfJzGlSM3uLCbWTUw6kJF3rUoh7nf1CzLQrdtuZjSkpQUbhVJtpIMWSROEDFC1P0n1W4ExsBYwHDjXOFjUbLfoQHvNj9f+7RdAAywB6xMEpAAWH2pbyPWw3ee5y4v5/yDJWcDHenpKjsTQl3Sr2pAYlXfe46B0d85M53TNfU4Oa7f1UE8TrrKFTjNmJuy9Cyi3Psge3tWDVIjSwsv6VAs/P3ot9X/DjW+vM0oi8nXVemLHICpaQrLEgQpVVcYF2R9o7BaJkT1dZQhzyGRKks1Tg/brMcZsemo7+pRB/wU05OsWk1Rt4cA0eaxUKrnb+unE/iIhedDedjJ3AiUkqfLUn+VcEbuYuGxj8go6mX8dASwalKw/yphsLTl3azhtW0jeWOhYPoBNElMHZByK0MvuF3J5zc0/nSz4n7pMh2fHouC6S97lamUFPsvtxubvFsGyICpblIUzfpuUMnWiJ0MWIP19Bv/c5x2wKkLSIdLuloOtVwZIgzPldj/pgOIvaZq8wOPAW+9pkDQriwa2lbyH2i+QKXlv88C0XQwOSnvk/ZL3CsYdkUWy1vIdGM8jsUNuk6MgeLTu9+Wf6CuDrYG48Yy++VaJy1sn1z8bXJh7wh3DEAQyS64g+VTwp7sq+mpPA0b9cH2UiVmlbPciMKFQMqgXhYhZivXRbIyigZEobUniKSvfyqrZLkIVufjdUVPFOSuE1xjrw6O3tOSL3ejrGD3gJ221vFjHwZRfjCAWj8Tj3WnFT2vug0+2eQwsXx3PgM2QeZL81jTQipkq/1Gz1tBaNojgq6CzWxveax3i6wS3MRunMib31ryfyA7kPewjLErqYl2vBgLFmg2E8S+Aek1NLNVyCBdtp4qJ3ch8DOItmEgE0Sdz8dXEWSq2Zdoef6QQPw/wQ=
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