T82ydanptb+6r1lxG3Tbem9kshS4JQwYIqQhbafpX/GKOuGD+3E7uRDmL0GVJ6cojj9i9GJ4qpPLEBTxfBH+QajhrLOobCBBRxn5MSZQ3VzjGM9zEgbgjnyECQ8vZm5uw1Z0Qx02a01YQeQdmloKlk4ZiCOXqMk0KIAawSNg7UFDgCR3HXKHUFuwEBxGTUEVgRQe3yoCn6SDNe793DU5cmCN7dKvFVEfGZXfUK8sqha3nXCP/LiXARiE4Xwqib3IZBTwrR8umHJ6heghzFSG8XPyCGnlr6yoj9vW6KQeSpNzxefKpeUaWjDiO3UayrnZTWqCnXDyrAu4n6HMwQoOpO7Hjj66QWN+jiEtpwj21iBHoPT5JLScgKyZEwzDm7qS85NKfLRUogqHT8QDqo0VvVujZ+8qiAVmCWCeicrsT8kFmAa0ERGcNTLD7Z/l4Y23w7/VCbwP9EFfPhcW3skr9x7sjPWomS3/chjVHiyVIU8t6zUQa+5Wz3u3+eU79rQLvSd9yJyfaYt6CBra+xXrW3H6QxRIGrUhiXut23JDN4befPcQtgtSEiIgFPfFcfgQQIl+77TgA2kVaTJ4VghrfzmtbxrgUwsI+a4Tu97G/sf2Xz8ZHVwHty+4oxJKO0uOFEIESNoi4p0D6w3M2g5o3rwh6kTPsLVourmFifOk8Nh6ydvY60zvjL9JuyWKIMX80rArcGl6vlGdivRV5VWPgZB6wJrrjkDU1cPLr0MEWcVtE3bFUSkPuERuUBhSj7hhQsCAVJDsS6g4kn8LsDtT9LlNkyOOPIZQOxhHqJJnk9JCa/OmtFaLrNapNj218MerLnsnWCuKMCD63RWvsTl1hRL/PMx9KVeb9PjemcMHgaXclnwKgTx5ZPiJTxHXojhpmBo3v4ScAOStGq+TvpvWCLLrL+ecT8V/8nLfVYeY0poFdmwIpgwbo+3ORs4m4spJwoH0jHTorBN9acuOPAy5POEuWwTmaiQ+fOScKnvo/OGwLJ/1nPvV3X2wfTgpxgpGqPfw8hbA6ml0g9Tii7uvu4jXGBqhaeUIx8zTSHHKcr4C7wdedL20dp7Yn3G1wi8PuvbbLxKvnQuMJiDIHzYMF4VJGdN2WICgG5QnGL9C0nTBHHlKEqBwrKQkcxnAY3ZaWc0WGPlgaXTQxjWSumHgoUoEZKhBaYesZAf2X2hHiWxBLxkxfsupYiR23kfwuPXa2K7+he9nwtwBAb1E48NLWCQ98MmWtONfX6bZVrwxshHh2/C4DBQPKOs717UOArtqGEfcfuMFbatd8uOzDctyEukQAJ6X7VnJ+8TnCaNjfouQLGzRjT+894VbBZAMt6pN50YA8czhI40sgUG6T6qNxAiVwiwXD3s+tbuKoFA=
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