mpHhlYgjwdHCyVNzVa4TjXmm3kCmyL7tcj/b/dAh91SekA6uNUh00atLkG9ODddj4tuYiAFJPYOHf7nJCy6374ZjsK9BfxdMCCnzKRQsnPcENwBLQBuDgFGCHfJXoIFVUdvyp7HiMcRtjeQz37bGVqz02gdZW/udI6YVKbhSFF6xnvWmn5LASrMCSXsNZUuDCRK8l87aJ4lWUEJQr5WJHQvz6da1vCrZuQgwrAm3+A995gr1hKSgoiYno/cCvd6jJGPjHlZ9D7q7UeEs/tbTud5nHes8Ddfxzrw4KVCKfFmnF5UX3TLIg7zRt2rRu6m/2DIb+cFTZgK49UgFo7K2CC3FOwyGdiE9+LXchXMkJeexKvDAjMZEkvdcI1wz6Q4f6e+zqo9/fmksaZoUX1YRd98KkiLP5t7UHj2mzHEPIGY8fnOahs2MkCZMofRwd9xJBTD9CbffTpB/qGuFOyNFxc+61vFsZKJlz8me3D39tG3MqqcW7EGVLXIfGmmeCSyPE9xOjnR8I/c6b8dvTtRkobTp6sD3WbNxZIilLF28kOBZkjme1lHA7k19LHGFbA5F7tqcbt28ZGCe31o3sXXcM2D0Z1Jdere+TC5RQ2tdHyMKhl8SlGCjzswUlRwJgslvUi4QllF3hL52XZgZqhCnNgtDenZPvpN6dSJ7xz5VWwaNoTSWk2ixvuKPk2WAlrZhbTQiYJ/H7HPMvDwKZQh6JplFtpEPvs8HMbzU9Y9KcUZaq/NoRett8p4t2JGxiyW9RiXPxrnr2jya251QmJXuKe34X+vw5W2EVQ2uVUN2N9RVqR5vmgoQ6bq0hTYY8SoHPhNQnizFRAaVMCnnBcf1f7DibxxGTLa7rXllOVHnhULBeZzPmMK5Y1Qp5rEPBUQDTFkiH5bKiEbelORZQivNTgf8GLJrE/Ua3UVCrfD0g4wWrOlIcc/JIclHJE++9o0bdRqaq++ITLPkKcARUQmry/AdgoHny1O+jTmbrAG/jP4s58U3SCJe43ozzwdPeSv/mCMMaLQRyG4cJp7+QwbhjTtwDbmXm/f3gF2fUhJDJc2Mrn62cekKaI7ogbduvFmhXEEpcRVzM1JOK/TxblbjD5f0dxrsHVkhVozZNYnMuv/+MnqQ0UTXCBnbld8C8IHBjwAwxlkftYrWvCEA03EODNgSVkqbrkna4mTxNOS+xbMXEJXBWJPuQQtsaEeLtYNYyB7gJCTSxUBHTfHbz2TMhTh8yJUJCItqaLTf7MqBbe44pcjV9Bbc6DQql3J9EV/Sg3TVI4kB4bl+qrIOKXltyPFc4kYZu5hVaCXcLJ1jdgEE7yXQcOLAqrEMlPkAHNx4MqRZTBAX49jVInm5rpG6BRIKumBDs9v1LM5UocQ=
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