r4VwRtSzQ6Nf6lKtJwDukM/f629Q1pT1GQ5EDt3i6sd2ea9CYyrQ1/ZKY6VOvDakVZKqhFXyamu9tSXEe/hN1UugkSBy8IS+3NvXHvj0s+Fn/xwSpI63HbUWkCFHWZW/Kcv794a//pw6uzSXNP6JfvQ2QdZSb3JHE2GplTuzlCaCcKuHfcKCNgcbpp5nPOS65k25OJ5F/EUi+3a5UxjyKjPENxQGnEfxLV5baEGNv2J78anjUzha5mmfvx6RGYBK+GYRjLfb+4TTkXIBiGHa5xTuMH4KbsPoZcyiQjDGX0BsUZK4s5kQaoMvD0Zu/GDpgTR6nMIGR5tbifTfFzX8/pRrimBp99CG8aHW4cl54q1PIi0sdziqZc6m2o4DfzEiY8Oni1hIkuUFWTmsXDGKeHbt5xsm8E6cxchpih5wQeIzgYtJUZjGoAw3iP0Gs/OphuvrovBkf1oEouiQRrkw3vdwgWMkRjrU2c/Eqxuyzp6PqxHLe2oUUwFJuW7NyM0orhclsmYYfoMniI1X76DKsTp+uvGiw8UEtYLPmXT7c+gvQt6Zm7Yn1MxYc8tUk+s6xmAhf2jAtN1EAqMpJq7ulgELQKT+BVZ5Z4H8KF/Is/iTaluUbTmn36p40RXwZddVvQtmcQCENR7O1J35ZUHbkHY399EZ+MBmUl9T7LBpsjh9D8Anv3yUMJcOgy85lN29ExulDoomT1UCaaX0CqQrD7qbSWQZVb9yjqQeA9Ti8be1Hn+wrdRljYcwVwg9ZMPISb32GFWpnRJQ3P9DTWhYeNK7A8SH7OfC3BfnGaONWptRVE2Pi+pZF1btrwvW07Qmj9e6q6VXNUidqmGC8RaNa0q5Rhsicjk5pFOFpkj8IcLn5x0Z2oR5MZ+hgTCEKPVxfcw0H84+vC9SSIQbVGcNyeXDikuwTBU6zeG569tp36jE2CYODFDwNHNPojD3j1qUnrpUZb5XhfiKZSiWjj37JgEtMokIlIIKdT6ODLbnSdOcs4+Zic3A9TPdr7uBMpF0cWZfDjkP5k2jwnovCE4ZSaYpu/yEpcCniFnto2NCFD9Wuc34aRut3nLTtrH3HF5DdEfNNm95+SKssjwZDHU1SQEjpb5qKnYKKaM0bBLVj3Ja6+ayXJqMn6o7InHNIE0vboUAxwachD+7dqP9aW4yrJT7DbrbA+YqR/aR5QVZUs9eSdu/VztdSfkNxhL2zNzEIX/D2ivOlazT67tFZfKJgW0VNoM9yR7Sixpf86bWQ7/JmXQU085pVQ5q//NVgXH/csTqYIQUt46p6QaEKbTQXoUYO32JqoR7dsxKmSER2ZsLYz65K+0B5UFmAQY24aBhD0FfX/CJ1Cw74c4ykU4o3b1S9vcujWOJrMfXukA=
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