w+Eb8OjOYclrmMdKUzuf8Ssdvdn2MS8AR+8sI/YRTG7dqqgtFkPlsU5Vd3TFsTQzcEwsL/NXjnfihUupnuz5Su5n7ZaL5AX1xTVRRoUvIHHXV0aTYosh+tnRrTXnz8536c0woPsYvfaAse8Jpg243IunzyOK7gy4RchNfpt+7WKxeQGPiYAHAO4w0wpn9tm5RtooU7NTUpo2ZC6emJzOHDXZCwIufUGzfhhhHUQChHDSCvYO8Bh+FfilIv48orOVcld1igbrwtvCjlhpeiLXCLRMsggbj2aORnEnXroz/R8No5yVcCQUlh/wxZzzyrqI6rkwF82jK5LE0s0IceqeD1h1eTtdhK6YIe6Co6V6g6rvLlTThv7frjiNVOwcJGojqvjX1hiUi6FoCaVch16kLMjFhWbAx+C+pNHUSB5/XW8RO/ijUwBzSG43VoOA5/x3vaguWyR92EHdsZFfi9KtPp1VM5D4qL2Jsjq6tv9D+uuUK+30rm/a73zMQDtM25hUx4pXZxkR8eWFuY3K29+pfKJeEaB0OcszQDy+Kj+nuDTUqo9LFLoF6SmJohCfRrXzCDnXz0W24wsY+V/58n29vePEzl7GD6+mgKdwc7dmc/ko+xTF7g8qk5zXKtPZm4q6E5/FWsIAtPLAPoVRLda4MW7jkuatHoKFz1DwsO9iG6K8aI+S4AVJJPRQJpCzwDrZDyBiY4grFzTihI8eeEJ2vsTki6ja50KHNKf7t3qxMDDfpeJtvnTZFy1pxZ3TRbXpDa1vLhGZPdcQCefhy+Tr/vSV7aCzCu8mSzdSjxMqNBNn1XjYZYcC1sThwup2bUCdOQ+yArvQQOqKLlzWAmFnVYRX4JVUxm/URCHfN41GpChbrY/u5vJgje8LDtV5uffw+ZvFbqGGZb/PUE4HRjdZ25doaaDQJRA3968HuAmLlPmhNmNENt3utYJYZ0Sjx6FPrAir5Rf8DA7msNJnog1ugggkvhh77FDeWC1TeHxNURkwvVP1O3LiP5HYPXNCuSajw5vg11QyO31d3O1ukEWaM0KYdpfVewTFgG3Z65FJptTnGzEJjKAeecQ1K7Csw7lI065eqEZP4pDwReYnqO2p23cZO/hpQTPAsgN9jDZpRBi8946QK20XVH4Z5QKyLMpXHGd4XQQgp/h0rHtt4tfJtyFrX2mJ/1/w5P6smsn6AK0GqeKgpWZCmGr/3Lq8qjvJAJjd3rk5OINHRAPMz41BkSwBskx2/cMgHxh9yB0g4q+wWXpgSWsW9CGIDUWhwpTqWony/tdJI3OL61EewuR2LAoSAx6UAAVMNxo3w43GZN2R7tJPXzPnp+cR9musPXdI9kd1Ebop9nJWUV4ea2kPK/DGynwmLxqHMDKgMnM=
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