Q2Mp3u5vBSRfQCWSB5sxwKBwT2YCcewC9dgn0svQHUALMFF+tfin6WYFu6DrQh/VpQ2Zojfs/mc7ycDkvtycyFhiOuw9gNqmY6WuVepFU/9/c2ohLX3v5TTOan6UgzkdsoX8Hs8jmdxJW54f0WWuzoeJbe1Tx+D8NzLU2S6Hbgjqyqp8vUHjoloHz55/BdQw+L1jFTZoSV51Jx19mRA25pIYbCnAZ+OjX66Pm+qyWb+H71bogHi+FIuQ4pEDzy7+j0dTK4/LqwypV8+qDB6yXvFltzJpo3xzl3pvfTdVlOYivsdOQotvrDuHuxHGmKB2ijOqDvnqAbnSO4VRouScHq/sehqy2CkczJR/K5sCYy6s7pC8QP7075u5EwMMrMoq/6Ym+djAdyddo2vRWHqFHhN3vkWSJi8rpIPsXwHSKve/pjOYylRghrxEZzwONvT8XM1A142dKPwk8pZTVyyT1+4C7XZABx9Y33jVSWOSq8cA+kdVAIovNjLCz7JwTZcXSJtluPEfLj/pMEiyiPF6OWuP8YB/9VfJqIJ0XPB3WzvDgUY6NQISH2xAbQcAU3SzfMmTwZ27/GwoMGqs4zFdukEzA+1+KrgVDW+kP6hm3DoXC1ckhCKG89zriV0EwlykkA7Em4xyZ8IyeBe9ovNmjMgh0F9cXG0KslxziB51Vi9VP9b1KZmE+6LgiffM41mI9QhY+proFqNMPxED5qTsv9b9cRsg7lp72jDHMT8ckn4ZJ7hMoNNuJ/8yD1N8IUKtNtH5NSTu/jMdsLfwiNqcSD8TGYbyrQV4Sk4b5KY3VK6MhzYLNoFsNGzvxNCqovIzVA7kSxq2dZC+EiBAMTCbZ+YtKlE68LwY+zBFehq/WMFFSdl/1dlYRM8oyM4d4avFnJD/vvCjhuXrVjgVNkd73p0o2Lf/RiIAjoo596gKNGBwtwcW/hMQmFgBAOaaGnIsw9IHO3wwHliJTwAHouxoSR9FT/Jq3tmtojVTjaLNngtRyWyheKm9b5vd75DFCvEoEYVZq6wAvyCj4Ji0sGcuSWt+qKczX5z7q9ya/xGP+6ftqr6ujrdz7retgRDmF7tc+3xJ8Be8NiHAkPIdeSLaV1cqihVyGVToEdIsQBFfzgexyaPuQ5sX7ENXWFlSYMc+4EIKFTQN6yNuWGJVcghc5KJ4c3TZ9Cu3i7olXCd8izkkaCcH4EDJ0JfKD/7v5go4O5aixbjyBJJOGIMUopYaJ6/XdTqPL3DB5ieTeIWTswit7G8bh3XbZJpu8gd3uaeg1r3PGTunnGIBp3z6fGUHnSp8qay9W8hmxETcQNrIZtbrz119+KwlPfZk2Brh7oiZBhV58WgQVqBcu7HWXBDjMN8XHVsS1zKYmIr0ny8=
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