sdjfs4qU5UekLdUSalqHDZvZRnbJZ27JFGyX9dv+tw4f2VcRVJ4RAxQCTF/9cXaCnbNwVaX6IN1RcGUgkPLwgNPwCI39kTZLekvT6cqqZ2TqRuqrnKBQLbdYQ+MmCoWFH3Ek6saoBB91b/zRdkdmyrQiaGQ5HxVSaz+Ru32ZQAtxqBE3hTMS5pNyU3DwW0C4auUbMHqYIZq8FWR0GWTzweV/ZVb90019HnXLuMg8pxbbdUgGnfvCtdrEpv5g6j6fulHGCx2Jt2hyKJllJ3q5Sa8qSGF4+9E7nxfv7xDtDJBkKLnHTsv22/mwy4OPwCSc+KRSveRRqCQnel/8gvFqCOdrsIDIGBy4dILfIRGSOr7MvMbunuF2RQ6sffRgXkHIZMfwZ4yQULAMcfG2qM6B3PgkXafcTcZ13waBd/n2etSJfi5bmghxO56uPLAW3AkaKcnNG29m4GOUbKYYfT54He/VYf8R6M0F9LilnXQOAVXrv2+cJt8+/T3PrPe4LH/ijZaqPOxNKbDrAojzeRgKxgwDO7RGpyHZ6PaDzZlVaiCcd46GDMm1FXlemsSkpzBq3QYxwleXIelGRt6RTHDpQG6UyKm1JQ6YP5sDPLag3qlcvTQDktVYGvSUZY7rHsZttIwyoyiegaPJmDxRvJxk62XWfVXhrkSHkOZJ+h+Xatoz7QUw2cuF5oND2wpuyTipoikAa4fh7KjdZWdcDuRThS7ZQnt+IMAA853t7UMr0o3gwPgN035a2Ps2OAjYu9rPFjNrjq5cXvFIxQDFPM+E8k8YuGACwzW5yLa0JrC4h8KRu/yJPMoEWYh/CGp0nD/Ce0ht25KLof7Zc8Yvr/cr43TqKi0OuburNpWVkRd8CMkUL7Ur22bkcJYQ06DbDuBy9h58JMfonsIu8hxqt5NlTy5PCPdt9YeeEVqDiiQCd1ZQZB0VV5IihQj8TZlZls7FEj6Ng9w0dkemi/p/tBTQHcJxVHcMqC7kOUsz8stKIcl11au9kMVWCVoE8Jf8jV1eRhwFtFN0qPU5QgzcHucCcvQDEArafB6vlY0V9xz/Y/DWVZ14KedMJL+sjGum/91HrYJDSI1H3WKQPzx9sfJlndsqDqpfwi6yR8pNfd6LmrpMILrdRqwr4e2sFBqvIbfuT3hhZLIr9UvUTLU2dn9YfqXPu/JulLPPnfLdqfIP2JdbaMC/t+jYVIvzVgqxANO5bB0UEExWniyiO1rGNDPSxp2stwn1W/k5dxDYO3R02GfixMzM5e+8TPiofnuV4EXBgXhqyGxv/6qsgluC9hROabDI0WgGbO6j6h+5lF49MmtxQB1C/K6VJ361xY+7O2MFEvAfl4PsnNYyd6G+D3wbiUCoeMuZEeA4Tii3mpQ=
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