kYOwC0CSWOzCh0v9vXm6I9s5YpPnew+9ZoiuvDO2bx8aOxyfqJAeOOUbLRXN1xcXENLdx9paUzGDbs9vF39fDtVaOBHW+FeqCPeRhlW0+h3TC5LRHugX19W4oWUgVJjum6C/FUnYrYKo18H0mis5Ua5NW9qJLgWGdyP5CMxnmzj7OnKT7sfAaazhTD6WELN+L+HfMJPEiXMU6vIGRuNjHLl2gcvM0M2HtM/vTI1petiSlOWzVFs5UQKVimstk/lkxPT8s80Uz3U6Eu4Cgh3d89R8H1dPtiAxbHfqBdVyxTqjnPrLm00zJUgL6FE7M2TBGZBFpkiOwtEyoaRNp9CKe2471yR9ZzsSBJLqWzNDBohBgbXvvteiymE0PHv9lZH+y1y7rvw9eiQuhaXZVFHZJaMaF+L0PLu3owEBAWTwlRGqUUCkGEDidHDhDsjSZ725gFqVzmraNvHckxsYISi4JXn6xX9ixZRjoJsFA2j8GXxcpIPN6MqcJmLK2IUklfg4QqgXAr1Hx3zFMv+mckRkfOdUItWUqbWE4CaFA+IbS/CYfH21nTwIoO4qpJlJGoitTMCoRTzW+CPYuUf1fu7gM7WbGVhKtZ+hic59KZCWhG3GfU15J7d2mUAYB/nGnOh8mwRvXeE1yte/R9G5apX4eNuWvoC+Fz7n2BR7lCuLpv1vazfjkM6H/YhHq36ZWC2GKeDHWjACUhK83Pn/5DCX7JT5THaXcTHkF+bB7Cbv7fc3o8k/kvAhPmXfveKixEJB26EKwT5coPiz/lzxBOcAWT/hVHTIadJpEJvSpo06qTBV316AW8d5nUhPkPDGorUvbJFfQabqbWCszmdV+3lc8TnyfBbpjNAU+Bet1xcevoKa4eY8LbDYx1Z4ZMIa1vEcMgr6sPKO/JYbMmZSvZbBk1+UHVA3Wd+tzsCB3LCYOHa3yLGG2QR8CxgCkJ/JMDdKQ7ni3g38G3mrypNMooqWsoXsILUqDrPXtUqcQm9y+S2W/qJWvc6m1ND6BorpVVqnf0h6QRlPkELwnUUBQ5QUXfAnL9drAUo3i3ofX8BHB791STTs934TaUbsdhUpol+Zekqjrc8XWpzTOFEqU8A+Z5EsU8mizs/dtfTyOnI7UyHa5WGyKb4Nc0sgsSraw3Vje1mckkxu0G+MpeSa5KFJUCoNLLIbJskITut4qX9BqozCqNBOA0XvtAPkful59s7VoAJu56fkNGU9sISVg4ARxO7g9ufitr0fMzSbg8b8PO7//Wx1Cn4bSkG9EH5QXt4+WQvwFppRvWs3T4c1WwA7xdBS6aAKjWoMXTtKvRI2uib8OTX7LM5P7Ud7R+V+jPmjWRjdztjklKILYd6JeFWEEszXnVkdEig5sCBhDqc=
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