uK4s6zUcFjRUboGsrkxWHkverYWaqiBBoGtAreOKtkuj5zHb8ifb0Ix6gvAaCV8Jg55h94MDmQz28fjGQMdoK/eWCOoEh/2a5VmlJgrFSZhS9Ex0/G5n9bTEelf2tvLk+UmcGdGyq2lmfBDfIUUrweGtJ2+nN7kGNddyuRWagxdIDWa5J/42YBWjoA3UOzA6Y7cgJ3yWUNPtrQt2PZAdYBY8c7LoLUZjpdWlmkmCXTKvHBJai/2huxFI7LmS0gu5HDPJ9FSICxGQAA0igI0t4C3govuoWMJBVV4aBf4/3JYEnH/oE2cKfx/VNd2TMgS/xqZNEiH/U2NkgnCea0CK2+KK2knSnZZUIvgFu1OWq89opQEtZkwQYeMbhFV7k+JYw6ac/jzv+V8fuXZTI4IxXuMipKXIZyi3ZyGx4TMHcdOfUk0UNqg3ezrx3+MZLuojN6pDEPUPNn9eAOQBZpuSzcdRQaoHQ4DWAO7SSVnhlRCq5XBeOyghqQEhhcZ9nNB+18n4ykc3E+aLsoi8gAHcCUphb26dFSXpNu6d1+7RxhPgRDlacZRf7/rWEBaTROzYGn8Wa863zPvY5TzhC1O+88euIO7Q73zbqOCX1U9FOF1PT47QleL5dyQAaujI46na/Ied9iyyduvDvHoqMmtbdMvrThLCer8w/R/0bBySb1AiFoJde1A2zloglDA0Ni/75zawavzXJ9B4Mw6g0HOqTarOQzOOom9JINNZD0SrJqSllkjCe2TagG6Oj3FwZGEMqWR17CN7aljgi2wAgjucrfGSIqI3IR9bE3urkbnNw3ryrbnEGU7XGzsm3KixkZycbZc3gG9Z1Drh/sWyvOpk0eoihpewJy/C6Hya16Lclw5rmT6dcttC46YCXmBBG0cTvDVtIlsW0yDWt/8nMocETu7n3SwflllFaYUsobQ0d5XpIuVkaBGuU/H1i+acOW1FI7peYdQxVyZ1dW9tPcoZcyKkAeDSe1sz3f8JWtYjTBEvEJH9DkEeSmAI4PNGRWRZBWxfmOuuQIb8k2eX7W/09QwbL6BnoCDe8FBIgkIq9oOGYVzhbrCohmdSAkREuH+yYNbwNvE+5DWXNnijYh/+7AaQP2B/TmNXob06EaQCe6I4Ket5TTE6ekNTlu6F4ptiQGoY5vyQsa/H2zVxDVsqEtZ+b21x6AeLjhd7Ep71yZ7tq2o/hW2L07+e1XcEjXcNnu39EyisR5F+sfK83nUqxUVkHiOy8TsddIZ44BUE2ywvNUn1dGMg2NCxaWzSMcFA5v6g+Zars2zC9+vHkCaIVnPeiDzT56XseRCzE1MQMMMy1XS/NH99Kfp5aK9qARXG17YKU+QlMT2Ve8aMQMfvP5aEaivjrLwCoM9WVCI=
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