jmixenECOaP+18VqLyQ8s2UuTaQwX6lRubhhnrteMJe227JfkY4wmsMwYJ4beSKTReWFxlJ6CUJnBs8nAAlSrKbd3j0nSdV4jPEOOkb5caRIS8xkbZQ7s9DPC1ATrg1G2I4c9OXv1uXllCtkPk68G/6I2KfCHwty1nkAMxQQzGES5GgK6UqgJJdc4dWL54o1OH2rThMiJLLXEti72FKSWaUJhVkGXSZgdNmbivwvunrMS7g82ucIwo1IlDLHnRsH/78TTcBe+1rTVqVdPyrHnXPvXJN9Vp1p/Ih5dEF4U4C0Ojkh6Q1NbedGI15Dxw5bbWR0DDfFG6IGEfQh4/zWOY3l4leChhq0BUoflYuw0z6LBmhno+JPbMTxFMzESdlKglj+VJjmnyTEE01dm7NMTNtL8ArOoEnveeFp1uQmLTVjbb7aV/YAsYOZy37D641djmRwurgwMrJ3MHmCVeCI7it5UcadIA+fUtZKlJEg7pREr7b/lJ0ftgUUlQaLCqtZgJSiHuvNwyWP0YlCBzsZVSUMBILgU2G4pkMuCpH1/EsLJMx9Vl3Cc24aYPmHS5PTudCCmT1v4ZTVwUrnkDKWyDwYE3Wzz2YfoWbGWGwtd3zBYQ5ggHR9UVvaCEyf+K65OiS9GiJFQRv5TETMC3UlK/7mhAJ9u1ggjyEVLaFUEhsSKyNeBn6jFG6L33vMEYvfcEw8XJ8ckqkgT/h0h7j3Ntw0lv92jv17ChVSupJMutbRIlh9NzIud2QWHLR+V6WTtJjPRcAIpwjpKVuJkqQ9xY6P2K0wDt4TrdXK5KIyjJvMUGNqYAkTaFucD9TT6vVvx0mj/g7344Hy0Ry3NLudGVvIWNsXiEGzi2/mC7sU4lVN0fWM3mxNr6pD3w9VQKyDqNBZ/QNodtzAK3d9VC69mz9iqD0BR6Wk8gkk/9YJ/uyb0iu/p2WBAPJGSsGj/Z3BYRsl0i5pwKCIBaU9aQFNym78zM0J3XWkeYvzrubR6zCoH62fg1/AEc8a52ZhUwyxP93zPCL4+xEphsclu+RzwJV2GlRo+v8jdL65yPEvuJWhRkLoZSRr+zCwrW1PZfcKVipZ9k2EUaK4GMUiPDqXM6C+dal78nUZMo7IshFqqsZNHYfw7skFpRKw3tTlgD0uQyx4ZH402IYITY782EAL0npvqQunGhXwLI9nSZt8ssh/wew/ZsuNcZ7fU9meVMwB+tczIuZkY4wAu04hIpJV391NL85axAAb0N+xObrStOXhChOJ3xtFznZfy1aC9lszXSxF/xnrMFgVttZ531ObJCQU85lLcd/HLIZ93wbmpLihOXyshl5AkzLA/DXT73f1Sw6tuB0tUHiN8mi6GjjOMp9mE3yT3IvXUhSq7b0=
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