Osbv3fpdwb0FjrBStDjrcd5X/V3OzFd4I3IrMzte19v8bztWk+7tGxOtI4FXSRyFH9hO5mroIgfjNW66W2kpspjqsdXhZdvf674cDAWbsV0wUJRM6esAnla9zz4IcprHl3Xzz8cdqzJO+ZQJ2iZJ4I+iv4Qa6ogMBRrVyZC74EynSy/QcZsB2363SLZX+gJzJLoHlvDU9qV85nmATd9q546IW65qKgEqpllEZoQ5eo50G+1vcXW6vzjHNLrnBoVoVCna8KZZ1MmN0IbcTA9ql9ni3u3Qa/knjDqDnr9W3ORcTh3AdqegwCb6V5/T5bbd8/dWAf8qMJQYF/6WM/fjRJKnAojY6T+yQucq417DrOuJcCtexeULZ3HJY7Dm2CXEuFmUcT25ULeht5nsvKz2UrWpPbQOFhG4nJDHDEQglUPrL8yXfwmZihtg7EcrLRad6CIDvoBgNpK3wOvIuM1gAz0ikIvsIwhjukfp6OmivVkSWcCR6yMaM1xNloyNMFEQxUsdxclfj2zrDra4w+ioI5VcSDbvXbmwTsukjl9SCzaM1yQYYaYteINYfYPdIfYAzuJotrJAoyBdx8TUX+wl+7pJqGNAF99nbkmJ4vCHVKXWnY0BhoPch+OfyxQp37IMbAbtLwYABxTfSRKPzMV4Wuy0TbXSvbaI37oFMLkaasDH37b8JOoyTxjXSOfdxnOZ26ijlm925jdH5lTG2kc7Pe1Ur6DrbmHTgVBqjWznewDOL+FipDjB0NM1by1frVP/VL1oVDs5SDZ6HagtV2mSV7BjkMPYbfDv1wS0O8KKZEDf3iCzdbzynJ35fWoO3JimulhLZIL3f4T/ZvGkZTNO3J0zXc8sTMdU2woOsm0yMas4M8J+737OCrcQrWbRt+zfX+jH5V6cup3ErgFn5hd1CzH1UjFd6I63CG3qOhRW0lT+ILmwbAJl47o/WZefQ96ZXWNLWbEqAMtbyTleumJXD9dONlSAoTiR9P2+Roqgn+XhJgvZoLv0xkK+mOxs9l0CWNET99puXAGT+XHBpWKsGzLidEp1jXss+caXLwm/ulAV27VIShlZ/RL7Y7V/LZjRwELMpr24Lu1JooWPL46+NTJ+5JDVC7/TfjpfzRqJaC7J3FLwI/TPNRdIlwJAh6TYqpSJGJlmi1yx77iJMNtDa+XtyUWftI8DPBMgLzJLktC60cxDbqLW22DXP2X/C7ueqSZeXUmiOQYfpvyeifNJ39LQQVjv6eL65OMdVZVtx6t41uXfzZQZTv631jPAQ9d7DbYOjAeZIoI3nG2TZ7ePVgeBIgeL51BjKO23kltbEbW68eBfcdQym+ODvd4Qbprjmo4WPHDd9JMdRSmJ359ZXulUdtPKY/CIoznmf60=
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