7IxVMwXVgamzGtTGQGtq+i2zRznoZhW6KDArP6DNLmf22kWpHTtJ2AjQJJTV4mIL0ZObN+sIzWtFdPPn+r0KAwYudlXlaLl+ToYx+JSUPdV6wXP/jnC2eFoezWZE1QX4o4qIN0SNG7W30LsfPRXLPP1h+ldTy+On+gU4Ow6ujHxy61QRmnfOGC7SvKij+5R1xlTzMBdNvXGCNkGc5ZxLBvm+oXKM2idJg5koI42xASp6UW8UsP7sUDAzCMrXmmM4NgbppJAsR9OznVbHqoWnhYA92h/n6sddgJpXDmZSMtqdsArjkZJ8c5BQHETsOdeH0yjDpe0DN7vWVYzFzSKUY4ZPCfpic0obRGy4w9c1ah/MzP8eBwNNsNrzo3pcMy8FTaIVkhJHwE2BrCGe6NJXm4tv+2/RS0/IV4nZ82/kZ3Pu2P/saZ2tAo6bku9eNQCHqeYoJGvinhFp7jJqW+nxjq8i+HGM22HUVvWDtxQ4EWxyjPcbTzTw5zB2GyXltcljP92MDZ9m5qQ8Zpcm3ZR9FMAODBW1FfMW2MTH/BdpZj0PzptSGrlky1fFQJTYbeq3kDm5yKwzLu+clR19mTTBw26viK6hKOP6vHYjtB7K1YdYqr4Hu+m08GBrxceTloMleUeio/14YHlyhLYprQqHu+TjFqoFoxCt+6XI9jVbqL7zPqEdiPJFxQlTA9coZyHarKEyPL4u5HMLcW9XaqG8qKPW3gGFB8NJsgPt98p0zeHpv1NfA3aaDmZX0K2+4flyLjnn+JWRyJJOQiO44HPi6h2bIb9NwEdvgvyDGoJrWMGNzilZu0zaIT/rNwcRvKLJd3Nwk5vQV3umxlSp67woTFLpkmGIGrUxn+0L1K8Ld95ElIO9+4LX0z1MdEcQaynslPOFS48OULHk78X3G6A4Gh3liHdhm3COuGn3H3Al9Vjh1PJbz5hhNHHWyaebT7clpsIBYt9ajv/xoYtVY8QKtF/JTEbPi5PGhCWsP2HgRP8fniauBCXXepdTEok/NHDX0iZ0q7UY9DFkMVnD9bSTEY5/sSnFNS8wsLD7AB4ZBX/iJKMGwDj2sY27UA5d/d0lSqDJpHkPlnFam9Jw48OfMgaBNfrg6ZvvHOoKVMo4xhSIsILemJtBk8VMnXzIytcd4yIbgSPEtv16BQuiNuOCgXns01Py3s/0F0wwnirfrM+q57O8S5bHOLLftQcYjM0d8U8sa+htcOY5U+2aTng6sG0ywQlBAUeAY8sgh/KWbNq7c6HXeIXU35WZhhtGLL8YNI5Iox7WO5M1oA2GR0g9m18JbFsQQQadRcnuVnbRl/0Up3ovGTYW1twSm1f602H8uDTNr/42RGWWO7QytKCGARQbc7Dc8pbcMS7ld3s=
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