DAq9SjCWMARMgZd4FU0meKoSXvFCydKxXBwneEg39y3Z6Mh/WPXaSjcqINFImQjyaMTTkOJaX+oIM5fx53/xzc9qQh+wz37aR4m4/hugLfHZuIGwgToDfFTKvTm94MeGdqvtIEaafa01jFqWIPZ+yoU/sEAeq+GxXsT3HrqX3j0bqd+24/tOm0r6JQaK3GJ4/zyLbtI7f65icfAMgKXf6A6vp+Wvd3SqgTiae2j54bKbv5o7UZG+TcHmqfEZumnWgA3qPEgklZoy7lc4poZEQCar5OqKlRLe/pUO5ccTduftMmiv/C/jfdvLf7Jd5IqjvVcjz1wSA4vj1Rrs+VC6voCm8wzSb8rtTn7Tl2/j0AhjKTxIRvAzVTTEmKYtpQu325p+vEdFgIIqOdnA9Rt+3hGJ5kimYlpDDJObycbGIqiRro7rxM7xx5J8b6PWZy9Lk8zGJuKYosKUod7WJxjGFDkMGHGAUErScC3SJbDCaKOA7VD4lVkCGBk1ahT2L2ElU7VLbvNKv2ma6QnGH4TkR2gOYg0jq4YxLpPUifFxMFMlFs09Hywx5LAdDhQ/Fj2xZzYcdrgOJm8x9oPkXW6zAQvp30vF8lkztWyG1l32eQkdeHslSDX2pDIitN4Py7wY1jbhMUvV1LhCix/8xCj2GwoRUtQGC01pK3ijnssoCQfMLh9KxoZvMWbOVG5tluuD0dXmM7GFI03dqqhIMtaTfEPvYiqPQjLZlSZQ3skmOzepk/btgusZwIb9XbR55f946AXRBs+MX/sFatdP6akNVci1JTR1N+GBfJCYxb7tctsicF5jMy0PIDL2pA7+fL6j6GQwCox48ReE8Yy4/tDL1pEWUyk88Azh8Zg5g1RZhthqvI8yFEufGeDVx6IfH9AMt3Vv103kyTmD/j4z0rv1yzwmePLnKwUdhqFejcKVPMOmMkeMD7K3nH+zuBp3FvkIS514MZFPDk/EnsLapCuTcDsMifdMFaLAUT+BJqeddkx8FrSlmvyMh3L+5ybjgZhbDSIywwycZReFHK+6QnMtuUJtn1yMTdV/uyoQ9DjK+jLKv/EZs6mOYnMX7eEXXFWRK7WfYh0XlLaVLNRoZrbxQ/kydI0WzddnDGtiifVvimKVpLnXjRpx312iwJj9p8aSHmT0yOckcjoKtGveY7ymxmfPJHvmj08uOkKZHtwLLecg37/wcJ2OkvWZcIbjhdYYWEOuMd55nD6QgOOTVXNZDZhMRkLjuP6zaT8ieEgPW1j0kN7jPsH3T65Lh75Gsq26yB78WgxAD3X3MrmMTyxj21k2ARs3NAj6hWKqfwhjT11sFmjayzO5Oz+DaxWX7Q9ouSbCvLXkAP5gs0ugK2NpwxxV5EWJyK/Ag0u+yTQ=
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