zR56HWN4odekaVaYLTj6Ivm+jWUOM40JgQtyoIwHn2bQQGOfmXHwxj0vb9YP6q1qIBxVL/rp8PsP0VbwAA+F5WlzM4Bldszwxq79mUC7ltHDZOH7a7R5/mnX9/vI/E7pALS21On0Y1ucmc44P9sqeThQ+kU9tSWhOJ1JuynA89CzB97znq8QVVnqNftYL8mMepYW6ZvE6RFCLjj7UcTWGiMTfjyA95hhqXrFpvhvgc7uuVMnCxGfeLxEqZG0G4hjGcbdbhzqVwk8gH13eydG3rtULrqgWlvRaBElJ7O7abBrdnvbbh4piCta5ofJloEzFHnv5YMUSJcc93u2Dt6k1ltxdaLbg5Cj0bNDm2l6qJqe9PBnfT46hWn+SY/nEsROoINemTeduAkSeDJPsE0oOv1MzTmPf23vFb66QmJhgiJ+SUlBTzN6zLjKomTGWfThCqmWhy3205YjkZtS17pFI6IWRUbtQd6md7Yr6lI1tp54xEgEzMoKnGmeGc2anh534Qj/ylNjausEqurCSzavYwKaOKI3s7lz5nELLk0tU9IotvISDMKt6t3D3hzY6AFiSzyxz+5r6AQncAVCGTwpEXKJ6z729pSIzM46Hobt9kQoLacGqsFaLhgGAV5oGmTP4TW5PSroZ14a+u4+/jNI+arF+gl1PZWxaUTzW8XrPVpvcZboNrWMX4NRQDRe5hscGLO12+d0vCX/28XI8C9TChwSvGOqUls3o4dRnf3pshQ6BJ78utHLLk8ulf2yB0E8VzJcVSsa9KTYvPXaKoVuUM1NIqXhXBYdn6CH8E5cxb4U43I9jO8VHBJYik2eNSBG0Qy0cjX2VH89q7K+BphLVJG88EnduI1nBQDWNau3EGF2FRsfyqgVkD191C91JLVsDPt6vkjsqT1yVy5QHuJrPKzD0lnCWG3vgnBdn+hgYCjXYBKcHy0usr2DJ1d91ZIlsqy2J3ecvIsanTZxoLiJwI0Fi2p6smDkxaQYHwxShpI8ZGDqhnD7a7QyUoN3KfjVXwbqZbRMFwllh/i2Lc7qgK8QiL8pvelX4bs1qGuPuxYA42Q/7+pEAdREP7PoMxRE4/llTWKnrWwrisFnn4No3ajtVONjTUn+yRh0dM+G2+Gqqjhiu4DOtvJfV2tyYiZp/7bJAJ+SmOTr1Qd8nRmE1leHqo9o0ctaGfxk0qY/aOvqQVQ9+xKhx8U2ElNg51gcqclvR+vpHxrxSWT9si+shxiMS2FZ87bZBCn/peuPYhs0T/L3mq4uEBtWH8D6sUcymW5m98gb1bVWs4jf/k933IWAlkup7ZjxzdTbf5bjLt8teCY62a9JJqmvtroR5ePrnNrRgFp9CM41BHvv3y0vqR22ldePBjlMCpd2ZPw=
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