9uAobCCWc6WbAAtIszvjhVMSLNNM+Zg5aigiCO7/xrb3Y+mVcLHaepeOwEvHPK14Z7uSaT/jsWLz3OJPn79SnNrcDJHU17gK6+HDzNSuJHMxRog042a1vpXwVl2jnNrSTpYuf2FCOEJNdOzFoUInSRDhSNMBnhPuLUWImLZjtAQrykwnI6f17zxMuG+xlCcv5GS/w+OdKyPpRP0j/nWlr4BL7aRe1NuCjoEKmfmqtk3NKo2+sPdcVkPzJOg3tSdizHzBAq1NUdJc4LuRmqsKPVfA+TjqGwzpgGh4v19L43h9amWZT3ftmD+MyFChWasehBkoym8PdTkUY4U7obqT2oHsZcJ74KIIoUBgOU65hUmovOnzbA72n5aDMsVctLo8BI8BV6aA3pkWB5ArvxC+NeGVd9BjhfFsiNZCwXEEqtGtGCeA8dm89GMKpmtKf9JFx3dOnS8VulFowyiLksh19cs2Cd6Zv+6JeRoKtiJHibesshWc6rV2bK/BjwmXRA55vPjG4CJS2n2Nqqc1/jrjndkcl+ajspzAJX3YDdyzdap+D6J6ssxtNUk8asfOuubpwYAbpAbxRSSfomF7eNt2bgqNGwSSm4+9pOE6zO8ULlnyFZXlTcDijVgVtL6q2tqwWemNoF9hiFZcwDoQdUx4rsPuR1tEFt1i93g7XuOlYABy+eMHHuX+ezkTtRTK/qNr7uymqXWBSz6Dgfx4gVJZIRCCVa1+Z5gEICo+0JrXahayqWwJdZU1NwxB4xZ2vBXt1pTNnpAVIkrHTCQF2pSKfxNN1k5+xZWg/IQXxA6K076Mr6PNBk+xQKKmj1vQiIzr60SA1ty9yWP8CXg7RfiG0fuR8FGbYIAs4T/2XBaIGQIRc4r2UWUaVRQpfhfGO6pWxtgXUY9kK5yBloHvZ/+fMnEnFReibzCRKD1DjBSozYjq95wDb/AlEOSQTLNiBaR2HgTBPiFZvYopqMMp7OMDm7qst67t//Z2ig6Uqq1Ev/M2xQapQMk8vucCUPLZK5kju/EbM7vlj5ceJ958am/AbTDrvpQJrnQ+/eExO1h3G37B9c3IfGejLFvgrsIXKUQSSHBaRPK9iXcHs/xqoHaN2qwy1sJNd6JwfOvFfuAuL4QVylULyRL/AIHox3XrMGie2vzLhBB9FMG2/w5oSzIZ3Fqb/tcFzmkgqXW31mBO+8i9twAK1EUZ9htXz1LDc+Mk7b5YLHzmVnUAQrJ7mumAahO2Ee3nKsAbGPOjmMS3fLtk20dbX83dgoJ9JKRGufKyAgBlBleWEQhPvvl91zIZ+Q8tYLZ9N8IIc4pLyUAyqe7KN07rq2+3kZZrKFbIj0ss6bu2mGvHmgsmXLGkR96Se+73MNQ5DLqQ2E2LV90=
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