EBeqSH1dPKtYkmzbUpjzB7Kyv9b+L1n31uoAZkzkw0BD9w0ul3vZ0vip8wHKfSpiv13BhR1wa8CE/STOk7bJaT1Vgo+lX1300JYvyjSLYCIP/EKzFbQrfgxwfI/DYEszePNkyVFIhVTVZXpOeQLikBpJnFwGXb27RVWOXNch0Brb0DiwwArduoGGE2OXVBq0Nr7sr8Q8VFW3/3jV7ek7+S8m/i/U3rC5/seebjclKEOODA+lIcqIXBc2xodtYG+4ZPb9BmvmwxtvFVXXaTx0dVTnQHVUgAnYn3yvE/NRiWon+rNo+IIHGAbHXFF7LX5IDK2HYmbzxw1BNLcaJ+GpzhI4zeuLxHLXjiNNvJ9lXbOn30fcsN6dQZh0/265aHEmxvJV8bhJnPIf0wGr0YC/urAt3VsfbPWf6CPhCdRanlqH7DlVT+KE3mkBuAf7IV1+kt7yq/NIvNXSVLUEPVuSOyRpHoPNKq0twyrHM+X/rtZXIdeaky7452xnofPj5JjKy8RUQM/0mfLSgifTEeZQASRXZBFop/cfZqr61Cr/3n6BSBBwMBpotXWl3j6q4eb6AMlLXtXXPQgXCHXfdg+gH7fYPjelkOOFQKdnV45Pcl96IQL8NWaaOZqH6hRRHbkGfmd19v6LMj2xuHTFsGHoKsD3AAr3I2GeRFWzJFsTi9qXL9ejnQc5GiHioE0Go02SZjuFKADJ416exouviC1U08iTaLCSXgQ1oRbiJ+PhiRzniKkU1y0SmrblN7XTVBEl/5VzOoRH47HxeQBhQF1kjsjsG8oI64Trs49uudUxOnRzGotJ5zZrhoXSWF+8QjLdZYlSw8xSq5ZaANJEs0ONsdcyJ3xdoGvt9Hk+LW1S6qhTH8ZQr3BILvTtv3RkceUh0z49e9hK6CHXriVtrN86BXapPkla/XbPqUUbfBs+1abtGwq+ViYUhb4SjM5duDlUqnl3n7A+bStnzw7G0ebaYJIQ1hhAIpkXELsFYXhLm4XYH7zGcOer1vgBW6yKh05jOLIupQvhGKKhkIrqTfrmR4qPnLb2/3bgrXOoMxMu/jePGEqh9DZvKDcUJDmsNWX3Uyl2AhPgz+QZeoZrtzDp0UDoPkz0rZJJ8G3lyQ0IK9zesB/7pybsO9KLx0JXvvpjVBZhiofkS6G1EWosxknHb9MTeSJ1IVIm7ewr2M2zCJaoUuDOvZuLNfKk8Hc2gua/cvgo29sCWPZ5Yh2cHPuM15JZbfQ7/FUypAK+TsLdbx8blmZw0YB4mOpy+e4bx55yV3q7csy+Z/spiyaKEVqPc0p7yGpIrMKk4A8RgpnYNhLHwQyPEpOBiclZ8yeAP4MCSPllzY8JtmGVGcLQasDmuqKgLiAm8Hf8YJjnuN4=
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