fAVsStbqcANmCpZ9HUG8OQLKTQvkB0Ey6SJ2oTr2j0XbvqjdBWBOVtI7KjqwM/ZPOM9FdUwlifVZAM5ibdgfJroSSO5lRC4IMKgdjGJ+DMa/RkUuGGm8OCDJo0FWRRz0ASHsb6KkEHqKuQ1fmAe3E2+er4AebO7PHSAmnQ6vevllfB5CS9M7YMyLPApB0UgYegRUQ9U5AqmSFFwrvut8i8Vgwp5MsUgZeDdFDYdgbv9sxl1pG+nt4hbr9gHdPW5VGuzP3wzRlZmOThEN04AKohygSRqSPFXuyxUFot02y+LNxw5Xp4mNUxhKFgV6MigDy7uPhyKiHCeEhZApxSI8yxofboEtFnHDihBsUUwkwGoLi5eB3xf+kMwuLRU7x9ojOrQXbu+RRV5kjUXAmyB+QuaXddIDe6EZ0Thtpn4OiAxRv9E8UuZdgVc62uBirN0BmY3dQt4dcbQFdoVHC5gesNUWjQt/E1DDZp2cFaxiuWQYwimdn0C+A3IWWkOi9YXuuAiWmKu98A6ZwSiE3m135XSQUSTBz6YsAMg2oxL6dGckVc7C0mAMi8TWEtnwiVP1hQYRJ6/E1uzGiLrsxqBK5DICb2wsSlt6CrPzfn6t43D42W8u8kHspvJLIUhdmhho5veuL6r8J8IKHaHaN+u8w9LZiMmJQmyiZkXxBH7ezw9Ocvo0ui9/73mpXdK9ZgvqXvBjb1KivorQcPY9vIMcqHvqn3nSt1z6qeqeKr3YQ1bNPjXmY8511MrUKxOqBKi4JJM88IQcOeo/EaOvGWfD6qqaIgNdUibgGonSm0zJnjrsPb+JbghKwfz0xup4rx/CxN1y9oO6AoYe4+bKX0EFpBEUUxorG/PpprNcAsVITm7VkAx7UVeD8rdf51yTq+BIcfb4JaI+UWbetKVoqdxumhscd/aQ3OA6BLahrxkyjBKKWfQb8WtC7N8vKHHIrVGefO/o4PhzJPFAntD8lBqhEo3z0okjoMrbr0x5Pkyy5KFDqM/MjWrCXMi1zgQtt1wumGP7Zgul6FNui09i5iOyGYLG04XF0djDx69uF427c4maDInz4BSpr4nQvRya2fJ0BNk01R9LtoavRmk7eHO2BXHYaMbA/rB13HiiPbZK3bjI3Z12FYLfu2gxbBggo60bEONtPxkuo4sxaujzdibt17LIFj1PsCD7aRWSIyCKtEPxgK0MH0dxV/uJndmHMvFH9WKOSg5y3qewnfSpZmkDbl2reF1ebH/B/soyPsSruNzmnPlnsGoewO/b6Hd6RTpYAAUr6+AXR5MID2qNosN08sRbpl9PDUDwR2hByD5JYKVKxu+XkJN/XGrkpMwKWYNdCPWOU8d0rtRR6TUjmsDlvuiYLu0BgoCyMB0MKBY=
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