0AzG5HX2yICoyjwmVvPmOkfpqefX7fTD0syxruBWuY9fHiQh488Rd0XkPKSx8VI7cKe/+D2s7LMTFKrP4dOWu1l2e9WQ2WSyjx0Cd012GMAliEnwTuswqhQOQ1esICNl/K0oW66uZiuqel4cpm6JcByUjT97y+YXkhG7SF79vOlHWvzheH3HTAzR5fY3gHyLTicVgp7dt/I7fhRDvCO4/IhzW0XI9+hvbS1RveM9iRoMR3V8OhYbKiIwHB4aZaFjJ861OwFFYi4BtFYFQJtCAcHt2WSuRsvHo2XdeZDFbivcYApC6GUfH4Nl2y7n2A9SqW52Ef5oliDPX86MeK/7xG6KINuZgFvLW/ovUt1qxhXjvb084W0gDs4krw377/+t5jezhX7xUkraQBSlOYyBdxsLfigYoKHVubQvKPKTpDtyyN45L1FbNizMOYGjgDE2TzpRdSK4NhqDpaXnxBu0elGAIbeleV3DS/nJjINVEaHg0g/DoFHDXYNPhaHBAM5VroQK43VPz8CA1MjSgHfw7RqcJsWFR5lY8zg7Xh57HuSFTRMcr+lZ+nsGRCQDYwIL6BwXl7x+ltge/KeUjc6p9Ac3qv+BOtMOfhSuliYLLRfYpqQBqJgWuHpUt0IlGgusR7G/Ldz6VGkLWwOL8wWIDGVRU6kvaXW9y+WEH5Ttbc4n3jasDG0BLDL3ORTwcxyhYCJhj57EMOUx6ubpc0N59Kz59bI+HnXitPG3YXkSgcMLsNBNXPKS/S1gkdHqaHydofaNMf2fvYSL7J6W1pp/3JezWf9E7po52/aRN85/hVCJo/y1C1BhToVlWxqMdqzlrxlMv/OEya1H966ePKSfdXaj6/r88OvsztSrJmQbtPxyE51t+JBRxDK6oUT+JdyoqqoXJ4VN8sXkiMtyOQe6dssdkWRzXUxXiIIkwkVSzoCm6mp2DtsGlyzRyPbRVTs0bUbJtgWgTqkv3/wnTVjTTC3QG1obMpIPwjDYnymd4Y8x5FH3DJUPN3yXtlWRJJ35CNs3Vqclj48lLA1uNgX1pxsfPBTzZqHXVqiZaAsdLZ0ucGilgIrA9ftiTwEtss9OQu2qtht326lOVeSUs6JJ8mM3iQ+P/3qu0nP7/jslLB/QXD9j14aTjm+qqQad0GgZM/ZOHZuCV9BCj6VPYSMumXroccsdsGxdeBnpHffEowXDZmi6AmK8dzAhjtJ44SlQ9d3fvT/tGNjGMPpvbxlRiK0k6GPU6iYJJI5dMhy7voX0nW3abIQpMD6PDo9SlvBth2OOwCca2nv9zNnTTUpj0BCpsOpzB/WsVtZttbJDVh41bMJFufvWQqSfkjBAcKM1wXba4zTqiPtC89+GjWyaFkpz9uOiPywrrLqZBR4=
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