3SXC3ydK01D6KE5ZdFIXrVUDYlEe3cfgEsZwiROw6Ta90+hfSmAXoVIxzJTg8a/jesz9M921rDMZ0yjnUC5tsexPE9MADd+VlM/aJj7ySuMsfFCdlocNxyZhQls6Dwp6LrwL+xeBKVRdCgnP97t6aZGOnUqjLPxPT6lF7g/zrCn3jtzXnDON38Avf9rNCty75zIBmRIh+ZzJPLrYtRs+tWJwyZuXlS6+2iOUEZhra2J0BqrJowT3LosX14Wggc2sXx6DXAkvz3raRrEuzZwuquim6aQMKyDurre7+0XAqerb05pEyBKA6fYXVqQkdhhGTUA6SFuKomlJb+K1ekXPspsHcL+dgRJirDrrTnxWmaNaXOjoIzomkbE3afyLUb3c/PP3anoqb36Fm057InKPMOykByCcX20iRQ7QO/yi0ixnZASZAGy2KYjLLeZY1Ve62TmBngK1oCUKcdSig6Y1Rppe5vH6QfpfwgQyt569zSYCRnphmr7hVM1rsnLiCmaZN1X9+OolwAo2rJ+SwI+YKmimZO81pc8ht3pdNrDAoK9JHRB1EEGfO1JCZKTPTruzREKGuX3ZQIqcWrCHdeULkRvxq9Hn4d5Vn5/5MgK2SmR2k/downXZZpJjbThh9WhCYblfWK2Vu9odGpTmUKt0yqPHOotySvbd3+jb02lx4wdLJfvnLkvUQ6xxbTXuSMXQIpYxryQOPMAVUE3uemH4C6VIUXloi10PwCtcROD8Z3MzhyPgtA1JXQiaF+viPiaru+x2/1bdEoqDHpL02U1IoOGPZtc+8oiEUgLGpOvDUa4reRQMTaesio2T4fjJZhFL5qKIU5qb4JTWjLcrxkxg4nJXS/jC9K+I9hhMyvZ2flZQXF7rd/noAuEiq9TcDVphSPFpmWwXj26y+Dn4RDRIoqzIiP2v+6Z8yt081ODW6ZfWVfAaAToviwymYK3P/7vkelBtUKBIzzVbCpNu/kKG8JzsRqN4LAuwrRJwoOGNpDlMG/4H1w1tFcx1IdAvtj/8t1RRzaC+/WggGPqc0LcUYul0NE0v8uTr2tu2mAogeJZ+y/QMJqd4bK9Gf7+gVsHuxCNDOOw02ETnNYBOstCQAiCXloTB1+5uWZSkf+WOfvkexef647p7eYcb1lL1Gwrrh62kFyPemgNEb+s3XLFwqG/yGgNAj0u28glbMiN9TU+Nz40fPEyjlsjDk4/HzKhexUlbAMGIgXusLmTiUxfqBR5b+pEKUUh+o4gesrJSAxWiYE4YXjuSz0NuiyJnEufzvPeksyZ6+zqwzP9iqgYj2Km25Jxx6kDjZPVSj65voUE4DD7JwPXxZA+P4L94Jnw2B+FKeWO5PMknYsbyFj94oJZCSchqhCM/Xd4Vl8c=
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