C62o1FXuH7GkFstYEZX4RILmENUknUqYn/OoMYextLaeLuQTnG1uV2AUizUJrCkx840j0vGzSnxDPcGs8OfWAeolsaT2gLA+cKg9JETHTRHXIW0a2MNxPc/IX/gE6XVuTE8nBSn+f+klDVb74VRwRUy0/DfcRMZYHkO2HY/Htw5Pl2V0ndoUrYZG/4I9PqV4Kki5+wqRx6euCf29M2H4t5Lf4tNURC291terw2uUYCu8gQsu6s9/Ds/g7PH3mrKvCYkgn+l+kN6t9ZiUmG0YxZgs2WXNS9ToSTLoWxsiwhQtZ+SVFw6TF+Qkzr1vnBEXnqhec9aaFsX2kwuXqXWENM20I4+VnEPkNpDhvVj0uZrUZ0HYuN43IUKs79U8+P+DT01HkMJ1l32fyqtFmmeZnQjJzdJ9U1SkCRMBE2d0SN7axWaqprHrNImqgLHLnqe+2khLFZ4i56GgGHLdNaoDqacnpXlHkpZOWz+IcTfwaBk6QdSTOFAOmwYpQ+Mr0FNwsL7nxVDkJiq1ZweF2bVtJXHhsyQ0k/88ZhPEqkheXnPrY0WUabkUw6N1/NvtCCgwku/bU3pSyK+F/+RbELQnPqzGjBcS977qlx8PcYokCmlNh8tLOUs0Q0eay6zq745S5oWke73oTXwX3OluD/gA4dspBFM3fmJhU/8wiA+zxdrVT9Y4CJ//N89UTQRKpbSpXeP00x2xLGFLBSLHHKSEhyPWhMrRK41C3zr+BhvEtjdpPq9svhNxXia075PooY6DXrw3XErcpNBZsaSgoxe2T67EpyNEX5FY9HhFYl53uu4yXTyKs/S/UyxyuuwGg+vilYUieqHxrSgeuhV8uqeWxFRqRkGCjiNyY7b/7zdokJxDpaHE2MAAEETm9ZN4vU0tx6h3
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'
GROUP BY et.id
LIMIT 100