ElOU10dblEQP4qB132SmlKxyZMjjPFdrDSHF6byL+PNg9Xfb1HjeXqGPDSIZ994I1VvOTJZdy6HyTX3MEBgj8NtyVeN5dRnqfnLAF0fWZ75D2RqBGGynwQeGS3Sqn82GU4MV6mH2VADnLd3sH+g/SCEqT6ogO5oBA/p4zElJj+YI8m2cLUqSDpy0C3S8bABnzV2f7FJIAWdDy6KVm2EbBdy7juw586iQcVA8JrXsBUs0B9G7OTOzWhWYLUcXHoOjGlYsg58zE3OqFcH6ne1SiO9wDVnCpdF3LOAHLPFa1Gh5IKEdcCtHKpvMnqW5Gyp+q9kJ7Pux6tAhgvyJ4yxgyFUzm3QZrga+QcysLHkK3Oa4RTpQLazIZOnKyggherOYu0k5p/+c9YY/sRLH8BoBc3PI1z2AtbZoMjXzysJ8AT7t7nPAZLuuAJnafxg4owwxDJ3AcEKzAAuj/me2gXI7GR4GET+zrzA8AOfHquP3j4C7uBY8JE1B8VSKK8kEEfsVEk3qAuDLqefIuFs+KoeYvnYPlLH93vMZKSQudcjRpb/lHFUbZg2iX0tZH7jtj40RPnsOtxuB0VCZe8fLOe06K1u/Kp1DfPIMJRBRyqMqM8CVbfn4AtEqmQXSD4YSdQl6qRfJuq6PAMxwJnyluQrhDNwzQftmtAGb51lwuLahHZ93X8GgFm1ilVUJm6RD2N9f7xrwfZW7AE7XOWUXL1NjCFnb3TYydqHC54JLUvNA1MTj0lOF6U+1sAlI9YY5IE2j0DRkeLUTpUFwFP3/erBxFBBOGv99Ko+GMlVtRpmzbozewdpExewldTf+BFDgR1UCT1cxt2zJKBB9LZDKl1Bx8htRN8C4JQlOg3OkHSTv/E9gA4+quRnv7QIcghUDZJtt9bjBcOnT/ZfXzhAjFotGhnJMia2MMh2vejnWQhFBgrLPtWIfaefmbySB3Q/6fak9yqg052xfCYDTqRt61iPx6Nuti85QFfVafn4MkJxlygNqYv6hBji4AWYTD/pWWrlzPibK4RA3U441MhdEKKLXIO8Wy40nFv8ROXihHEqcxEivOOmPCvdh5fabYyMKBSpW5KKp4APnfxlVrHbklqJ8npHV3E0JJv6M6zz7XWAAwJxoyLOlrVpZ++Qkc8QBkKnSAY2ydtGUFNBPj2ZeSGtZso56CUZeMT8iGPfmZMOp3MfQhvn+6RkYmkbJcJ9TN8fKev/JP7z8mgmPD4JwrrMe0vqdO/a5Qt+IL8u6nq2UrAwhOWbZY1Krmhk5CtATSljAaJS1N5IoQTExF1034o14q9HoSOrUHmq4EPlHsk2YAVgEsqGhnNvPg7QsgAcn7HF1hU/cefuOmTk6stfi6vMawuI8kzTcUE1DZ4As430=
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