a6pNBtxzt0PTUAt4pnd9SdKMtA0GWEb11jZ0V7icGKKWMeArsc4mdAhd7IlINBZWqXJXzOKthdR0JuRJpOKFa6xCBFU0qmySgvjf5Fu4OxaDdNF6iQ9mm/vBM+pzNotAkwdsBljarz29UUvKN3Q1+wZrGWk12kv+dHO2+kAo3hZdlHbVvQpU45EHJmofbsEn3Lt8zmtBML/FI0o8DSyygwEuLiVHblqVqimxEIBazVrcj3cku51+7GjtNUWYZtm9WngM2eFlfpd8XGfeOeGW4rEDj0ACgI074SAb1Pyo8EjuAFN813647K0k7l5VHm20ATM6elXQf5I4cXfNYH4/GB+GZfn08l9V8qEk45HZAjq4ynb8a7dfh43bDXm4jTbcsGu21XXMb//N/S6CUP1cvWClBaju4yaU3xx5hFMK+INMJumNwQ3wLt1af+cM99Tdb5P3aTOY5nKK8U8OMvm4InrSLQCVzXdDtiRK/A/0HF+V0HzWKfVYDusdXy3vjg7/8qmOzrLLG0NnTgiSdiQGiQXfBEhChRiFhpeXal2gXHKNCfK3fkk0q/6PrMKrdMiDRmtbe0MWBMQmAx0nFyIHGuMNxyag28+p9JeOp9JVnBGgw5pBteacZCSgAGSORF056KdOR6KFFbzzRhnlGiB9bb+sVRzXsT63YkkoFgVUy7CdTFa5Qrqtdx8N81shv00123vYagLa1FyZORyRIA0x7OvdCkVFFIBKT+TglvFDRDj5pBi3qtp2PDuKy77YkR6cUVvffXsHHm5qEFO2p+THn3GbPvomB+icWzHHKGYmN9o6sSCkIa5V6OMExhndaOKYrIT2cLFVb/uX5xJ8EFK4hltW/IcvOKa19TU6+bzVv6bQsB8fmJFkkCrI+gv7e5X27YQMYqnkjTNzq03CBby4BSFZDVgcRzcXv7iwagsr3MeBkJOkke/E+GooOQTutY7uRTd85HKFrYiVnLauN2P3wwiaUqZp2z/QKZUoEKrew1y4fzbEA/9laQsE6WduimjGNF7kcuD7LXfJo1/FUImRycO9Y6WNUu4LP6x8v0fWxpPeqX+P9K+s/QVuF4vIThV29PMnlGSEIboiXQH3tkGR7HYwQCWE0OScPpz+c5Q8h4Hnin8NI+tCP6z0hJ8FllsrA1TzyfdaJhUJV33/xe2GWTwP9TwTrNjconNFsa2OG1TX6oUHsnkDoenBbwOkUh0QqO3qrWjZFcPL0aFtIyc2LEYawYNlwP+rumaVdv0pZ7o39X7Iw70EirdKfW0lndZifON6AXvLv+dE0CwAMjZ9uH5cxVEHp8Xbtek9MdBQ09XX1Yt7W1O6PNBkNNLNe9QOGtRbFCOJpTETqH+fkQQc1nOnJN38rpEM18BD1L0=
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