AwVEPNNFRMoDMPW2KrejutHESSYVpeSnrWKpPMuUFIj4+gOhWR4gDXXKg6TeKxZkVtbQ9uBWsENrp4mRJM4+SI6NZRaZr68Aw9Pq5bxVxy5HccwU/AbN7DslsU3XA3g355V2vj26nrYvcAKd1U5V5yErLpAhmBg20m68KwnZBbob4+v2S3JxsYoisFKK2327cIv/zKiha618PE02QaoioTzUiHvn50bjT/gK3d8TkHCn7Jo39tP+fV3U6d5SZQG2uUFin3nWBcdvU3MohJjHU0+yTRkNYUZwk3+aXHISoCTcMFCnzpfVS74A70wC66bDb9/M6/KXtelTc9yTB1S6fGG7utY490I5ZLD/lbq5YUiDYUxEGgjHjxhoHf+BitUEQZ+YnqpcvPKToLlzH5ToUeHlS9dfXWVtguc4I+IPTIhV4c2PP8Es45sRtg/37S8Xz4hgBLQ8bAJepDQFEFHnz5MSLMEw1Z1FO0+kWmcLvZyAyowBhVQ61GgBSDY+3Kv4Qfga034mfryEvJh4K6WspRbK1qnDpVf9rTZ+xz5JRWzslHHvsjBwZ4K1dL78qRp7aSYszIKofNE/JtNeNQ8KDFHxQOtqvS4MLXm2BU9k+/VwcW0JP2/s3izQbTqKzSQ7DLSU37grOwpGZY5DInZCYY59lFC71j2yTW3mi3aKckq08qmuT5c44lHdosdAZ2UzgFHHlCESllI97Ne0dcizbzIbkPScntRdV8xICTgClLDtMs9DBaa+nqb3JfrnlGr3OUNPgp+0I4iQN2mqIvJUjDvcEuYDfE8QHYn2inlWijbyynf5NmpNW0quyqKcBC8yUW/arQ7QARnSQMc2vSxxJZhTvhaxSMyXTYqaTav2xHM2qUXC+OTTZKhlwuauw6DUvPCU4WX+oSrtKPyX+MhUqGG5I78YU1kxgtccpZ0D1PPaggBDkfwkseFLHCLdZ4IYKulx5CPMFt+6Wp8mTZYU/kqHuLqKHbIP5tXF/5Vv8NyPYtfL27l87nOcXxylelYzmRJdDcnWXfwMG8jPaI8E1GodhGjLOoU8j6GIZndKplsFZC0kTO4L3fheeNipZlnPyp78vtrJoH4iVvH/kMMCn6GRjhXmxiwmWYuNuSSrVFTUizCvyuKg6KSv2on5Hp5Zm131GhZ7ff3k9exZuoKaUxd9Rf6ORbk2tYu5fcrdAQDxFZqZE1tHz+e0/kR8P53Wwxt2sRARPUnYdgxlDXfljOuUmEs89zp5vtrDDFny/MlBM32Pxj7CsRB8CKXlnvYHqr5Io4ZeSGu/jOozZmSlASzkKhvoyteB4w3ndlJHnQ9mYza8qJ9FSAbvt3POLNYBexG7pTc8i4sxYVbkIhwNDMbhUdxE1rEIQYEqTGM=
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