rOqTIrv1d34teyCIFLSSCSN6A0Ygwo8XYgsw785YnHgNfq4CTDseJls7NUoVeaGBwMGJNSYw9zG/C6MGkMBRBouGMbt9Ur7JoM2v/q5xxbJAilNWV1YhvDdxqZI0JLUWfiCCEEvIQkpi/9zxKuP6j+F8gyoynmOcfYDMqWTEa0oIZg9KC6NbGd3iMJf/HYFxZTKofXS/iZhYsAwZRbb6c0gyr96H4DQuBF+LXYsI5DWAGvKc6qBuyNeJ9FGKp1Qf5C8zSj5tPJXSHiC8lecrGipKWkVmR71ATTj0c9d4D2U1lD976HWIR7eS15c9zfL0VH+hxQMhpz8uWxIRz7rkzV/inb9jF2X6Ilyf7SuyHzNDgZeBVkPmw6XRJwmTNBbh0Ygt0OXAoR2/lmdaUMq1Wb5qO1qKotcWPQ9HY352jLVWl6pDcgeTI4ZJ0YQecQrTwLOCyj81JV5HdXL0WPxbXi6QjQe9xzyG79qr0lm8aVRV7e/FZutXD1CzIsLMnbAhI9k/RzAPNwDuxzC5KA4SpPlGodw3Jv7v4T9x29JyoZswSkNYxYYSTdSy4b7XPTXzHtFKV6RKSciUdnNPPNuX6Gq6U4XXHcGlN64XYcHoypUY7KYbse5r9S5LZlBog09KC8NJzBd921SMtBdGXriDfouvHVQsNKjc6kWQ7KUDpitcoDCGigJz3rhMKfibq6AHDkCAtlpAyacfNK3+F+8XOkmNlQp9x3xvOWAiACeQY68QJzkhHNzerP1tsWluQ5ePrhFW7Gf8hq3q3PUJ+FUbjoJFeB9jE/Z/Gq32tvh7BAzJYTaDMbta1wvB5muNGmP96mGHoYqyKzZpDbufqM825C/BvLUzjoI6YAgNL6D/mtpRBnf9JUA3HzUzh2AcEq+EAB6LbscdZd0UQ93TXK2YNkkpuB0uCP8YDqwIPvZ1xSwIva7Gx8a/nuLBE9/Zt8VoREyeRIGG6e0dMuN8UGyH1gatr1Ijr104q33VilFc9WscWdsrGyskzLeJpF3p/1otX1DEQpvuu6hXtVjFn+xcbAm5AbOzQBo8ND2kBj1X3wN4h3qSLNKCdMeCc35ApTNreB8fmJKNTefyOO/mdO5lB77hCGCX3hFRpnmuXSgXMpVE3KXGP5Rz9zgAdHHzAryepfldOkJn/jZBnnY4DrSBWMtvNf3VlJ5gIEJmKsulFhDX0uTo1IDoVkXwO4hOMtWklWCjlxukL+HHIqfH1PaC2DnbhGhH3uS/Eq3ERh77xhXCyGt9HioFtRenl2CEYMNEFPf33yaZE1/t97a2q4nE7sPkbY4tX/UjzN4xxiFNIlJTd4b6IzvLkqSiH22vpP5NtQ1/ExUuy6iLYT2UNpGJtkqisWbM+G2ASoYYxkE=
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