/mWQrZkkk5sJgrfGF7B8jqe+agTZ37PIWKnP3o1K0JauaO5C2f+esdphM24fknxTIwfhQkzymvkqT7Woi0mf59NRz9m2FFbPrttFD4vemZJDhRNaRtLB6R4H49DvqpzQIzU0YgLZKtN8brcn6C0lmQY5nnvVJsTi8mAphTLNYMT1O9JlpLTCMhFj97NcrQREc3GLZNkVUgo8eY7kqeSu4OWSmNBZKFBureiQZ6sWJg/joKFg8058c4beDaOfcCuCGPBnfcpeeEqody++wSq4BlgGG0Cy8J4iyO0UovdXh88yyaUgKxWhpWqAtDwuO5s9Qo0h2hrXHe1tSx6tGxaOidxz+3dq9Q0WbTuk1L9/XlGDar8XGSTADBm4ON7eUqvmPKcxdxxzI7PiARtrLHXOpFlbxDOyaEHII2p8obd8F8NYfl0PEyZ2PwzP5qpyQk3vtY4/Q/iBQ6IxGFpT571cLUMn9/hfxk3kytkbiy9ZdQDSsccJh8AzLYzaV12I4nw0iS1/z5wqYFeHig7l3AiHDGd2kiVvfm2fSwU9143YY6elJjE/RnTmfLWi5S9JXP3iaS0C2r52c87ZROJcEuyOP7q/MMd9KKYGIFdUdQkhKLtQc3NCP0TelDDQ9Sdp5dQWDeiM5MVBJM5OktunkH19GzTWt6AeNinmGyZt292V7qxAUyeIq2ORQz0Abdqg5X30wy/1FAJh7YdPOTHCwaPz9e0Dmlo+AJNXozeqtjnTEgP7cyC1JMwf/SNHLqrf1sGnnDLGTGCftJc5blOg/AckF6c5fxfN2zshqOM7HbCQL69eSAqERIoxmxfX5dz4RJYI5rFvtFqwU4UOESUeZu4BJ7uR9REwfh5SPW2BI7LbzjmZp3FltOgcQ4LkTr129r/s/XvIR0sLtrPHy4LPu9sT+DBz8OwUyN3mt0Pj6et2qS05nZLJyJO7DAI2KrlgHVpezN4oieAJ+CNPnWmtDYg1kFdGvHZsyr0xnAH+d1czcqAQx+raOta3kwBBPMBTpgAK3vgV/Yn6411Nbvhihr/Gn+rhfTV3BMZWpRnQLOt6chNQ4ObjWzvMAfZgr9fI3FqJtRNabrhb/KDIE+EYB778/qMJDe/asbevAHiAymGqlCqzifFth0rp21tPaRESGDP5ywYdXcDokEfhwq0LJZ3cEl7r2uzcu+LVPoXckA6zzJsMZe2RPHHkVcM9/u3n4izX8tIKMdm2lrRBHOmzmZfH3ISy6id/pKDdOtUeHDw9MCwe5xpvSDwgGJOjHIU0RMN0EUNcKKLR2NodgoK44aWOXQ2G5AB+TzjZ+KXhJvO07B75m7NVlNpSbnSnpZY7Ch1/JV+Z9KVlHUpg43fnNH83zhFW1aZCfyGWQzZUWOM=
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