ByUfxJTN9QHXuNwLCIN/nQt3bjnBcPFReMtK/kVbc1YfemRwNLvAvjpSyAz3i21E9FnWRfyfVPQc7ebsEMuJ+5Pf/YGM715a4puihZXXV/zO6/Rm0AogZM9ocuNbhPew2zQgyRkrT8kuxz6llxuwEtaJCBBQ6MxZ5c6DYU3/IqOsOQskzO2TkW1B9VyIZ4rfGUxZDGBeTkfyTfDYRcHZFJY07feotsOvPd/xjLJagvQrDaynW92JOHaII2CQV0AuON8Yn4fTzy5SS24Me8vLMWxSUXPg+Y+YghFoW3AAqXUvSKSMVl+x4sdteTz2HQoSd3DrRUv0s2sKofNXh7flY2WQTg5xWLtcfSTUPq/ESJ3VVyRYp+He39OFVIhf5l7b4QHl6yiac/zVcUAGyLA7UylKOQlRKzBqV7X7IttDhNk7Ff7TF3dAnheYnvNiU9KwWpCgDB2H0dLRgC4JimYpj+UU/74qTTWo7qNeFhG96qG64Cj/WHiBSD/yEL3cNTbCaKgUO0S0z0yU1uMfiaFd8miJx6g6tUCf4Shp9/Cci7mWGt3zCt1hZu/EasTvoxTU0fcGlXFx1WhJFQ7kj8EFHMtrJjol/DSGpIUpezGxYWxK1P25BYFCj8OsAoOROs+brP/66YYkIA9983hiZuWDLtAKSH5PiU1j3LJVCSoUhhUbuGvTkwa+ES7McexU7pohTInqApXgRKbAaOL0fQwnfxb4V1lIXjyszFCk+GvyZs/pNTZlyk5sR9ZSvwQ4ia9llQEYsKcxQgP4LBN5Y9yDe7JTetrpOOjBJiT+lxVmOuvmP+ohByNPFAXebXwFxdbmvCdHOaT4vHXwGeM/8x9JXlPfRJpqcBVFwGssK//Rim4cTq0tFlUE5cuGwzO9d5ac6CphgUg9z/bbga3yKZiL1bvATg8sDUZFx9ktzK3sSfQJfnBzZ2oxQbGPshAQLiWoRD14wvlWVGHG9vhDnFLbO7f+wOHgZ0TrYI1dVw/3gNNLYERcab5I6xE9cQo+skwycQFDgw9EaR3/ajB4rxvZMzfML6Gr9gCen2CUEmGh0CvCXnljMSa1EzJ61QA2jDmWJNRnC7imAOWSWg9RKSDIp+f0zo/6zapj71ltmG/OOMlz0gPNga9kmJxY2vaGs5keEh0VsC3ifNcgpcKh8cSjxnLVcEO7wmNvxQRPokYwG74inTUi+8f9tI9/sY7RmmnEbQ+kYeFJhO56rR/tpFN5CxUlDEhABFSzOU8SqTUZaxDmzq5OFjPK9LQy5A1T0Rw7WKheWGFbGgN1xDyy/tbAoaDbf5tCxub1ZQreG24zdEuBkNHptIX8zTRQv/Vre7LROA+kP4DG+hOc0mgsOvWQR1CznplCH+z0eXFG3X4=
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