Ac8KRbfLOZq7dr6guTgajQxlzPJz8HalX7JIhvsYKZoK4zDYpnKtXbu7EWog+iTuTkPzO3Ww46AQbmtvTXKFDTWuNa9B25CTjFU4ek6+6035pgnCOWkczE4RgereMc/+KhWz77eAmdAbdsYx+CWbaoeRUPpK8VRBG1yAX81hLuFChuFrE23EAtoCymcFFGUo1uq3dm7umrzs46me4JTHTq7VaNKCTfu1gYNHzubz6xv6jileGKhc/2Epnmvjmr8FXDOmyxzRCGZg0GyiwcGleIG/Bf9kUQuOBKKt2ay8oEUEiCEOPOiK8mU4l795u6U2Kea8UDZCnytjToG4hcNtd2Ef1H9tu5Nge3h0lSh9t6Fs1VEi6YfeswylF2Nfk8uJzHJP20fWG3ipHsYa/lJalv3gBLY9h5xSFhhgDs08poMHvZJs3O1tcwcfKtEFOOiZAdPcBlZfN0ZBbZBt00BVlExZxKsceWlLAUgYZOSgtAgdvnOFl8v+iQflIKT6KgosjOcQy3R9M4mF8yngdGy+q0LmBtgw8bPO4QYdPf7vLNKgGNSFjKpZNPogrFSjnpL9nyeL7fogKAIE1KaZJxIX8LE+tlgIuK4r3zVzXvKSGVEjP7yZ0fykC9U5YZHiqhLHLsNWTdfzwMDqZxpTjNsHaPINWn6qnfwdap8txzkxCQwllG2J+MHLSaVjcqPpB8MpOEIIdK6xw1Udes+u4K1rak6dVgR/eVPykPomXFiF8APZV40lVElOhDFJbYsiEsDzP/TdiHRms93dP47HTX2rLKp8vPyHM3+ufZXe/fPj2nC8ZvoIesDWADhWf+SjczJTxPzm4L94AMJD5ix9RQlQr43SkDCj77xRGB9Yf2mqUynJ9rhb98SoG9CGYQerHjlWRghHy5wxK544nwtKruAKIeIC+3Z7qLin9OEIKw/k+KXDoiohv0rcJ1hzg9vlAjga+HvGP4BlifHvlb0yTO3ztIh2FDQYUyOE0zVCcd7hvY6r1T1zxSsJIzNhUbk4vwAeEISEO/lgC2+tDDl6Q14Kz9ka941rJHuU8VyGNqvBE+OGbYZlx0HtrFgui+jX9g2sQW5u7DSGPc8QN8IEi+6tzzxZfydiIhRxblEY9PdtYVRaHt8PX8EFzL37kMhzJyxcIpiWa0OUivp+HvBeALJ/6EzgOlAl6pE0e1c7CBrp3grNxG/VPZR7qEyLt+5isF/6VOCW/AP0vIdKRI7V5nRoYkrKdg2uIhhJcuGuzUCm0b9JhxOoGJJk8iluArPAJeCOF5c4VddxwYAGHR2PpldYBC944MzZdsXemtj5Ov8axwVULugxn2OtiwX22qrbrQAi7splnohhOQxcEiauYQjelS+mir+P+AvoJy6qgl4=
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