XkDiqKoI4YRFS0M0Djbv+OIoMt51PyvOohJ4RVBRKcyatNUVOZQfISiYWdmZf63lU4XAEiZ3yjnFRbxFxbBwziinqyi6rQ2WtpfM3ylZvMxV99bldStTDy5NVpnZvkfW3fR/9BRAEkwLXYxrKOkgs/fxBbfcdo+BEb2jt+dvuEq8Ac5jqZwszhNbpkFbhS4GUF12hGfRf0p30ivXHXo0M8nythMx42w0U+wZbkUAEiCDdgBeIfffrFEtkC/J4Fec18Wt1jkEYSfDxtOnV/f87hzn0g9SJR0YPtPO/+Yu5pnoYIwcmaSG9fWOPEjO42UCjyGcqDaAN5RfOO9NP7By8GWBqE59oaqxeLEkTDCwheiFK4mvu3epjgJrxdR9OuhJHH3AOPnSCKspl4UReOJAkAS9Dlm2sd2Cr3ENkC5pbXm6iZh728ZkcxDTCDoGf+satLvtHIQHspVp0wZXxgHX4trSKvssvJwmxqBOKB0M6YoPUwznmqNAw4HsHrArZCKU7RoHXwHc/GyPpDuqQ/saIRO2JJsM2LHC8RtU5tDvxC7i/OIIOOyRqITqKzMdPoVf4dIygNcSfqYL3QXU1gDGFsAaxPTY+9/PL1WVt3PSZqeWUSRztynoXuh/vkK50MujZwnqDyM8A1T/vUFnlqysKKEPeeP9xs8hnIfM5jSy7nGuEAGH5FTWJ6IKouZSXKu6ORyPpZyRw8LO4Cv0pqWBfKZAXJntzhPt4zI4HHn0kvSp5ZtvbgFgv+B1Eff2ybA+mbJ35kBu8zZ6lqbGUJLD5zJ0iniJsiy79ikusNpuvBfAEWLDYl0x2JPW/yySJy/PlHaXOEHWDRHDgI1LzkbKyxMfeHu/adv9LgV1uoXjSwego2GVwUcOZ5CnE8AW87oLU3QWRewEPHc+QU2l9A3bUvcjrtlkQZ+nF27pKwjqJgCHJVbIUkVoAh15vy4pMdV72xF26Iv5HwTdpc6YejqIprQegFx8PoXSsXYmdQTVrmURhVF6ltBjrS0JnKMmh8x4OWD0+28XNU3tO4CC4m96KyVG+tJyHatdNrxpi8nlrxDzcfMoc0fsCs4kDDdSCA68E+DqZlmhjHq9Yh/xhX+o2ooTiWGQcE378RKTaQFxkIKPHb2lBZXXKgsZB8j0sCaeu1DOw8snJftUesl0PS+RSknaNIsXaPES+S85BY1tvVo/32ntuhBi1IbtPxKuJvv5cOWw4b0mGftBBlASAmLLaDZGu0fmbjKa8sEqDl+JMz9rT0lUkeKIkdxYfU2V9MsUYUAgsdYrbzQjW0nHRNopO2+9NSZv2u+3vJv4L+PNWio/EcZhgig0DE9aICr3Lk2Za/IhDyyIknry0WRm77KxNx0YKnaByz9qSBXBKbk=
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