8CprWQExbW9F6livzysJm/seAU+drqG4yMGits8JbLICEFz3k8wv00i0vXQi5CqLlvUuqgiIUD3MKbrYOXcVdTC5lNnrVGfXl1TU9XuI7T+H8o5a0Bfm2rx6tdmKVQHA3a4YspVB/eGDe2GbmhT0EDRvbKoOcGJMi0CIi5Acbu0R0oM7xbNfePIHSOJTA9IETg2N52ho6nldDeUILQhuhU15r/pfIuQG08DtnpP9uGRp2ylgLZ383Fs6sP9LUIK64h9b87OcYrBq/eLjdxv0dxokq8pRUTMNOfkMdtVnwaFWEztWlpgOuDtwIWHxxbF00dAPxRHkIUnljTdTdkfTPLbmfxl+LG1LPOTeQUrJzVtWIFHN9hhmHqqqqAaIsoFWdPo4yBC4URdWLYBN6nATbfwHS0hRCWpZsKdrEe0b2sYBdkVDuIXFp/rL4RSacIT8tkpSNqwweNw2cnvnC44Jj+VRa8fcwe++mGOIqWbbynppRT7k7lwADBRsV152fArkn3F0tK9rlZ/4NQ226WwyvQKkjTsEc2TZwTa71heoJ8S8ns2vB34Qv/cZ0t7O2ISOp+Z7Je3SSlr+GT9Ki24H48avookMHkDNv75mIJafVQ7/jcjouSzknZETD1gvdj7yHEW8g+iKOzt3/6Ng0cYvhqBTe+HOv/LoWHpsKswNOL3CQYXdSRpKfnd/R44I5CZlCOD7Qonxtuv/xzWfJRU58Bd0cT56eqY3LOarTTzNV1X90iyghe6ysinRmKnsWGq5NPLT9X+INQGPHJH+Q2OQhLxhVIMLcfeg9NzbitHkk2bmqIMokStZDKIHBtlU4CnIHHDWPL3/Zt8P740oV7BqtNZmlgqd5C8aKBxWI/otguZ2VkumbbiVk7VY0q0EoySSASFCopTv6AEA9quiECLEE0sjfs00ASYDzQphTIE2O1C0Hly3QtrhCmJy2JnmrDQgDWvmnB69XCyQEC4HawiH8QDhGkDzFUXkUXosmj7v71IVQQD7fOFiIaJagtAv1uhg/R812SgXSIgSkLIQtxFYQVw7rl4c8zDU4e62WrmIL3kOq5qedH2a4ZOLK3UDGtDJO0rnwKuiyg4HNvc1rSBXYpgNSEoRrQjh9cLLQ7JHCvvDa+Bn+ZSg0NU/QMBQkT751XoOxZoA2VpB9Fvh4MRmuYZKEGvykJszvvbVG05qrsKLUI0ATzLz5EU9Ep0fFUyYRMtIgFn/UVXaLGbMvUACAr8aMSPvUjEahkBSGck9y28FVtVN+HBbJuWdBaSQsAfevvuKszccY4bSNPvlg1mjcrcumwO7eiw/fDLHLJUOgJgBP27Zo/GDl1wyqROGF95l4APgbJEFF+CAGrRq9K48I6X8QpTZ6WTRVfNSGsY=
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