5Sbj0qY9fBlCrl61ZZgtsc8nM13K9Bx3uyl7HQfrLYJWK1pWEWpwi04+J1Jg9eqFQrThMvXiyLdAhcbjYOyjqCF5GzDIWUnTB/BtM5J+6n01dIYGHF6Jxb/8nVAVVCsyA/0hK6sKSe3Ryuys9hFowQfhd2kTFPNfcUdhalhX66j5Yx++k1XyMydr56eYaIllYRISXCYYhnULzY6C7yc8pU7YGQibNNxaPDy2L1TPmqFhiZO4AB7b7FpO73WUoBedJwzvElLX+vtIY6qNnkblW1/81Za7JfVE/j+mHNPR+rBye7LqSdYKOzV6JaBo0AKH7RbNbl4/9uMPi+gqYKUc4c6B4kp/5strBOY8cdOEwoZkf7KYqSJvudrZwi5sAVXzb6OTY/9es5TdORysdqtNMNphRPLaIh9a2amYJRQdoiZV/8FVtITlC2XlObf6ePFODzbfcNmt6MzNbttVajrOiMzMkI5S9LSbCxU+eEXWHjhGkuVKzNMoxx7Z/JOGumWRWAgXSiSra9PuT8z1GibI09hBzvr2aedbNM1KMCJ8UtZJVSIvi3l2abZQaGRKCD2xghzEjWuhU8Pg0duikc/QzGM9566Vi7hDX6H+Dmae41bioIQJWpUdgxZTr17Q8cVDWoJBOcxGi5aDPFHCNje4pDngCzjp6wqDFEsqMcRA06mzVMGhudDjw52mPP3FpySBiTNYa7QZBW2rnWZ8hZJj4znWCWWKxozN4ZNwpstNHQkkVyLXn3VmoR9M+Ww+xragh611kIUhGmZ6/gzIhOxQAZpEq8sXf3HRmTuRpgZ0DBg5Jh+QqKdABNUZJw88bnjgbQY6hk8+umM8JJ2knmwB+ZgZ6N6ePrr94sl7OP5Q9U2uw/ZgybCdk3xVfxcUsQHDStAGeJe2zdAMyfFmdxiWZR5RP5WQfWwFVAJzxbQVMuWmc9DxwGU6+KL5fWmoxGdV2N+XnabljJN+L89G/BEP+zRnn/Y1C6D3F3fA0B7uJjnuEE4k4Vncg249fEf+vxa2mAOlK1XOcZZCe0izK9F3MVnzYODjht9JsCXYCl6OH29bJ7jNeNTXhcW81kqH/iLDD4/bob9IoGIrDz/1P4hd/8X8R3rM9n74XvnveDBb1PeGSdLSf2sUloJTt2DgPTN96T/1lNndxY40akdGa9UBHDDpb38ZQUn9fOLIFI2szXTqFOvaw3eH/Wq/stX7331zEjjf0Xcc7rCSpgefPNLxrEENDjrJiuJ1iBM4F4Z0EKXgX23cFcOuf3fnYtuwWrE1FUJoneky1eteXz2Sz/4l36Zw+/FOkN+sjHzmjaywvajl+wX8o1Do5+53v5fXEI3slehs3wPqHgBzEfJPHIcDIgIOWOcMeyR+aAHuXYc=
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