cqONGo5ct40ob2Klh7G0n4k6ziS/HoVdgrZqYQYsov02mNwJk/QY6L/Eu4R9bysvWBVJsP3mmW0ZkHCnMkLVk7TB+V+olS1/8Jkn3ivZbZ+D9Rg7W5bOd7QcgMYjdnoXK3ZQL5edBXTa6xjC1IwS3jQqtlUgCF5bc4e/1Aj1oUi9ob6siVvypaPHBJxjIr4C9jAfVyVZ6tB+U22LtI6aBK2rPZ8MmVz3CT855CuBl+u7qSJ4RvXjWo5rVeW5qFaZjpEOrkDCxbj6ydEnhDW8Ur1WOkLcpv5p0jw+HFrZV91p6qmTSstLs1qW4Ztt8RYqNiY3M2m9QwHPqkQEaasonw8xzhNTSzf1VZ/iQKnrv/1VTHHJvbBCHknwntRyfWlIt670K/2PAbZg88tYyCJ730Aub8N5WID6Kar1znVcvS9+dJoj1gy9i/HqQ09NIdpxd3AgRfnsL1+ExmKAV++OGoB9juYL5FNx1sLI7k9mlaQr0QYMCUepitx2C6KaQyQse+BkDe/02CQu8iBdm03o8czWPE+NuVlJXA2TzK9z4hrXLVBn20eZhZBqOsszbWkFrlsgf3qCO2QQmlvY6braXPn+J3OVW3t5J43DpR/uSyhvz8mbKNpV4RgYqaXts+JwAa3EQsTJfyuqRLOvC79z/mBJpIO8tP8e/C5l4kBTRswNNx3f/wb4tjcI8z1vemlGqEObfh9crgSwWAj2JCsOg0rEFd5Fxa69XBk38zGZL3FKIZO2FWc/ArrpgxdGI6XMMpOtCLEKUmvO/8A/NpY1NJO0PXwWoIC6cpSPjMP3992JhW6Wr5GDPbodm/Jteh9TweXMSMMJlrJMTm7IzixThSNoayJKdtLBrWL0ABmGjoef0nhEDKpCXs7uAah6dA+gKZjyYU+9XZX8v6HAoa0HAC7xf2Ab3EwjJRbmbcu2tfe8TA8iUNYMCzPgQFjr54rgimHW5DUpzGbXIaCyi1wm5Ib3VUf03acdEr+krG+UGYtYiGLW6AmhAcqog9chBbPhFYb67nEYipRpoymijqUkcDyQNopTo1OyisKIZcwbJlVQfIF+1GkrC5sqyNNv/hgqXhqy0Ksuw/swv+iNTHlPtyRGpzK27ai528uLlShKqN7xQERqFggfiPgqmwOog3ejoIflKCa5FlptvMMbDrze7IzdaaAslTrxvli2mhhb+g7jkMm/TS4806KZm7xODOaPjlZMxUd5up3ppYmsp2rCL+6FBB4ooQA/wCtB6g/wvISbeEiKoX49h7P/R1n/Uv5XDjrfpqPyCZ95QUBwswZVAlP7vZzlCQFRo/wvqwhefOQsz8FePsmQUDKlaI2bw0fblJMqOQRPDg0ItU+gNVltIMAi0L3fOwqIrrQtnDM=
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