PSrjXWpFbsNkOkBd4tqe/ib9DvqavL56W3KAvCZVROJAcqIMawxn+EONJAl5fRx2P70twyuVROYvguhMpCy54r1gAfSfxKGPezFdi38WwNPap9RSZB7l0aaD0ulPIEtNmamQC3IwdcgQGw7MjUKC1x8ewRJQCoJDiZsAetvzjtlFPseDzZYnpeMFwXswgaw1SZ48JVg7jldtVxbu68kvuRQatBpazcxtfQRJHDYG4xDe+ugU81MPXjOzg+uOTyv3868hujnAn4bMXzT5HyUiaYSCYLtgdZQu0TGP2wVRfP7fNdDdNUwDqBQfg7j2QSanhsfWV92sIdkZV3rdFBgWZ9rCb6Q7NpjUNmJr2xZHLlVR253az4ACyNTjpyoPaMZ1MRZyHy1HBwKdYuHTSYQogCuybYaJJRJkLufgKj5DRq7ibXt3qO899+YiPcjYhX7XsT4XmMiA1jsOuIQ+V1q60iiznMcmF/ZH2EOlHHjbsQ/Ca8yL8XKZ339dCm301P/89KAhe31FLt1EJtd0AHA55bbBVw7juZRXMdQVG8YwRhwVJw3gnTeL5CQCnUGU81eZCF2gbrkeatv6abI+S4A9NBx0XJ2PKCtljqQ3tKKzTHHY5ienkV1qhO/JCpypNMRYu33Ee+cHbzEFZoBnmBIcoQP8XsXm67iY2dLqucqRluCkBO4ZZcWf7h7MAfCbJ+k5Z6xokOEKhLNQVqlmigNcjgCb5u/OZKzjO2R4YAn/pYrtK3qIm8+eLUCkHxbkoTmeIDLw/TC9y4Fz2Okj97pE2ubFmgnrA0hnCvRVbCHfOfNeIK0/3oSemFjpqVtYDmzM3JxCj77glqiUtBPES+LNC7JzDSzrilIVb0EizK2u4OuTqda25puKWmlvQjQUZ2DEAIIkJguE7hu+umUebNAGic1QdRBOnu8B1MyRoOTU3YfDVKgExVlKfjH8u3GD0WXcz7qKoGeb6borj3KQp3LgzCePhO9jG87FAC4gtxucMvivqCSqe/EJ29d4bZp/jjiag6x7A56MIVHGYtqrFTlPZW/KMmP36EWfwDAWORydJj/aXbVMDEewqqO6JqoA8eqhDaW28JhWIWFwX2e8NHMzAFMi/AoysMiTBwHIjNyZ/e34ufkgduVOQKeGMbpsNJJ8Dx2rSW9scGWxfeUxE1oQECndREFzbAZgOdcC9K8HTLinMoU4PUa06nRmCvYHjTsahbYarLxKsbCZZrOK5uhABOzC6EFoiKNo9LyZKX6QPVwxy+HlvHuNmQmCySecU7bnkvBHk6Mo4rS1SwLnhwqLLuTxF0rgynJAQua57vTyhS+PiMeoK/jwYP2WtVV8NqvqNbwAIgfGIs2WXZz2/onCZ6CTG8DG8qyl0AX3rYw=
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