FUDOQa3Ml521z0jijM2lbQIxyGc/3odAag3XaBAIZwf1gcqKVt2bUScf6LaQ6Ub+DuLBb9MHiltlTrY62jrCS23c1taYnnkYTl3fLQt52WD4iScH3t8hnTeZs/fkWA9Jb8hsAcq1BJKyrvdIdKVavPzPQdLCdUtZC3LvYhjOUvZUAW5VLDOw+u/aJJKBri9QQXumC1XYB4RYKR8dianPNaHkBjJDuFOb+OatEDlskUsd/un4ZOs+JmPy1jL0zs/iEctUvRyIAEuo6FrnNKPV5wz4fod0vCC0rDoW1C+i8X3nud6R5jA6Q+ChWLH9jiCKhYgNcfwT3QZCgX05xNnjIk93SKuYpm+3jQ/tdl+B1YepksjeucSAdnPFDSJ9sYm5MYEk5C/b3DnSGfxhgqWhcoAOIf+eCt0hpBopRhnrbX+6dNQwSMlZNZT78l/HR0k79C65UTIQxaX0msv+83o3lmCt3gQSrVzGXKaYGr97U4e6KOKSUWk0DNL8tvllZVobEJAaaTXIbp7qJ6oO7FcFdjlfFXUSqDc1YHzXdCMkD0wGEQWDi5AIMe8g5+Oyg5gyQ2URMeo7l4ZrJSPQnrZFZmyZ+/juLV8UjVVucywqdHwYxeBslL4ZsQnlzD2j7mlFuMNOmTMxCogCLUyV7BXkTyRSVH6oN59y6h35YMydY5BLPZ3sPTdlo5YFArSpREVOixb++osbT4jhDVSkVGelZYh1Y50o8zsY4megTOM4CNysdBSSLOreQB1B9EAlNHs1mQdsXS+Fui5mcG6tRUEd4MUngESL25vHMJb/qVkL0k8BITu60Qm8NanN9H40ThXNWj960BpJgYYd49N85aVONKT/a0YC9YJjt5yyRwbxtXVNEa69LAAuwBgEUWFY7+G+nXLV92htRBaBDci1dINwlZ7VlPCSaIsg2Gugf0cPdtYUeLgBWgUX2MnZyBKlbOTajxEVKHCKkQOUKvuyE2lr/9Na5sQkotno8UBq1xCrYDEqWPTPbfwDWEN910AvdgTvskQpndouCMq20QYlNjuOYXReCXGHyWWNsYjzUlYTKtgRqyuLpf3BHAycvs2JJbOD7+0ND+e91kmWG9+HFgyYO7yCHp1LgqPPFs5YXA84chOW5hp94uQiOgbMelyRTpVWpxszQP1Qkv8PT7zxwac4/b99HNWbUnJXZvbVIqlncB2hpM0Iz/zBlJJRU3IKNPydbOjfGuSz8IEmkQ5gmWqpvXw6dlWDXKaIZnGZeFSUU/Wg5WyOoTnbkoWZy70VeVWwf5/L9YH5wzx487SWo4gv2ZtC9vwGeyoQdQZPP02Iuu0l7Y3Hnx30mDHiWO03jXYzPu3Htrv2dAHAK5yG2H/Xwih4ydsXY/5H9NL+JUM=
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