SEnUdaWdFFzY64Au7Avw0jaXLEQ6LXedNcVoD1yO8w5jJ31jHiMR7MyW3spLidiC7r81bXdNpoz5FSEilfCnOUe2V8BFz2dcqgBe+8OCsC+0m6/eqw0lpxDSblIpyW5nMzYlNC+BAKbmskvQxD6Yw0ImaKh4uTNrqmpWHzYhuHWUpat89y+X6C+WNJY1YI79N27TPsIh+ecJYNMJi0mkzsotU8h5wW+eNBiQBwuP16ZcAQQxyhXBKBahb0uQ5Vf/Aw2mmBwPJxXKBZO+9rHy6hujHW+JGrY5EM5UvqdO1xVfvLFoVzZMpUOyxJBXMoihS6wgPzsH9rTVC/uT/Dcr8978XgkOjBppr5iPTcO3IhWKtTLsr3X7m07OmZI6pQP38bdvjKIdy+K7KxAlfzJVMmGCIdg9+UvNY4oJepd0EN4ry+PsfzUeYidNviGt92USwn1Y0IvxMOex77VvkShUc6owELaGZXB9kPai4jvSMIABlLmxfTm/HgQoEm77+/Gy8nzkPCMHoB7eTQ1Tmj0pkHAkSMUhZhGjSIdNGclk1hx3zlfPvbJb/5Epm4OOF5K/6XT7cexInmlKsX7e1NEaJv6uQSZ9cTPjyNR7NsLTH8ui1O7PYLRQxvqLsPw2+2RKKxLnfryb7RfKZUw6g+iKTHD3gB0QSbWj7v2zlVigPvR6GFtQyOusb3ElATFcppl4PajmSLDLL4Ny1aXOtXXbVlDTA+a1bVs/YABQLxvwFFZH1jKvBThnlk+TYVsCiKphCnQE1dORTl+wAE3I+DfnULk3rhnVqAEFkrccHdiaTVPygYEm/vwFJyVMbJDj8H0OrVK++eq1EdZymftous7/DjhUV7Hqenhg/+nlqkX9KycQFqFL0GiuTLW0sG97nLGsF0I/HoAE8+BwyJ2BMyX6Vs17IQJOiAu6YU7HCrj1LxTNcwIhl+VU7Vc9Ojm7kOuo8rj3cBwUunfwr/llQLlqL9SDI7xGiU2G/3s3iGVkHeS6zqJOg7KrK6BCFFaUnGEpk8mKS5CBbGzjnpIfLOPLvqIZVrvDW7EC9wgGgjUIMvqK4rWgbmb9nJ7sjXh1TWV87WtyALRwxmyUAEKZUmT1Y4K2R2it5Oz1ppPH5AcQ5d15DJ3JRWsdOE+CtcdTTpTbQKFE2URKwMOhtHdlKifALMeqt3RvpBKmBdF6WGtEcx11bENCKHAwid74xeeeTcFFT8WrYLlV5A40xe7unxTy3iXAmaU0+yZaQK0Ca/oWRBHyOUaDrNWx0GSpxy9LiPFooIzSvbGC4hgHVZJNxzu9r7s7L+wmwT+7132jAm7RteGg4zAVzJCKSOYudOxWm6vIVgbbZZbv+0aYpjqNubi4A9t75gDNZhThwbusrC8=
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