HP+7Oh5mpQ7qeYIMOtSO5cRiDW78q4Or39RCBglsj9SlMgcCeQRXeKUlw9KlsJBIxs4+8nBfVQnUdt6J/ZAhgyPAuAfG4oB13IzKDFy/EdWaG5JocDBILTsYTfj31aN7BgLsS3vBaGUglA+Vu6cj+b2uM0zpysn3yU6oRgR1SPCaVmciWS60ISKq9ZXGUw6Sj/UvRuoiR8aGigdJ4rhmavHxEvTLgW9dLQ/cpiU4VOZs4k2p0olEI4E8je38Yb9A6GI8EV9GHSthKtSDodJk04eZCGOimw3+YJpUQJ7aeOzY0lpLOWPS/rv6z4X/ncw79fWp6RUp1Ok4gmcl3YzkQB44EOXh3K0asOKmm7M50yK44dGy+0V+KU7w0do+OZmgCCLcnsqF4oxkQcpVpdXPXLgsa2N8Ms61f7Db8+DmCiSxHVbHLNbxsQdnR3fh5qBUImXFcG4XgBMvKDZv+Z3rEkcH7NT39Zzu6KCy2Kvu1BYR6k09P6NDX/MRbC9v/wPkePcAoTKrCrhBpqRa/0EFgYn9u9DEAeWLO8yDEv8rUtCh54qfn87++0LMxS83ucccbTWvxP5kXDVtIyDwqDNmLvdmuZUadMylYjFFvW4KfhchRVrJnqA6QCPRhdowkShhQqpzQM2aWPOa4uggvH4RcsDaEzJDG9vK7j+L+4JcUD4WZkqIjhncWIs6H2paS87dxwP09xPM1u1+Dot284OV674t3F6FAhkyyKigJyV3V1UR4+7g2tNDjd8dn9rAGH1kaPm+/MCVd6mkqWspycfms5RBhn6rXydgvQ2TyQtrLODNuEZ7AePdK3dqzZTdqL3D3tSRZ8j2k7ZqzZu2/B1UL3c3g0M6Gu7vsDnbhbHMviWH9r2ZIxTGxIfbZXkC6IN1fI2Po5dlqbPC6f/icGEZ4oWz+iw7VCJZCut9XBH3xwzwTw3TK+2wMRdYkSgIdSx5aVm2lo/rf5y93QohzCFYecOmnfIHn9MtApQVINFIwWCemqTaB+9ldx1KzIbktYkjX9zDP7IZtjjb++Dtioy+4jgWB8ZlkDgQZuFWntwfY8CrWeo4HRpekWCEwMXxHGc7v711wzCJa+W2sCI33pk7tBQelqYEW4d3LjQSzpvr+IWfk/LirZyulSO9WlnrdXIw8jL1L3xo0q7SFAmgKchGXc1dFyRMfrLYcJN2KZoOO7rOqE7F+J1ESeN9Pv9J7lFNLT1ko1mmMKBEfkqKFblkqDf4h0FokV7bDujg9YgBUhWvt/KRUhJkznfqFluUJEafwDoLP/HL07t3A+V5Lh++7PfXpo4mhoF2HcG1/CdEnS3FCHgUXe1O75Jp8RVxsya3WxCe4dX7mUwcqEd1LWzQPvEBwZqIkHTF38g6ix8=
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