4/94lTkhEaF3Jdgsa+qxbu8mLwiMN1YGxaCZwgQeVH6CQbnCjnTvFs4YaZOV0ywHKcVeGwfcr8WW34/oT8D5OabVUeoppWb/U73WVq3twvfF5yTpxS3llnvNfnDGU1pbOFI84Ys3yH2Q3u9jCRVAUV+xsb7L8wevY4xZIpLWvyviWU5xKEexkQumxqOA5Bf2UPgOv8ZNL0Tjkst04sYIly1ZNbJs5zaKagRW9GeGfUMDKBuonuEzmFoRIRzvmtUIEBoHtA0vBvas+f/8SNPcxDLsSJKRQG/Jl/Im3lIfxtLl96OgtcO9zBnqfn+eRUt2DCUcsXN4FWpf3MTVzF/ZgjpN0b6QZBGIaHeGD1Cr6a3/n66HfI97lAWLMjDE2aBl2YHQD7gaH5g7o+ua5kVHktQJLWQe71Jobv9qf0GhGBC6exfWViCuaNHPUjMZo14gUNxR3snfTWPqvTa6JbWUsEPS1xcGjvvP/iNkig6YGcNwiA14agoSkpds8qcPAbLcko8Qrn37/LgDreFe8EKEfsqrR/N3ifkFZhphtW3davtbWKd+G/rJwYjqv+pAx0oX7noAqIXEqMRJ75JHS4hthDZWCFx6rWh+aWCTUS1HD3ROe5wZFh2NKnTahAzXwcIyyOAT9IgAA0OP2bqwVlSsGvVQFxzMFFq0r6bH1iomLgUf1Mc2sdhqxeqcfKr0STCyXE7FPMr0v1BLzsky0jpIs6LiykcKHsWViFARw79v9LDwnIeXME1I4qvbKOcpshuB+iUyiH+2obQqO4Qp3onCJjZMbbhdn7KClj6/Se0sa5E+mXqvNJYkO3LsODBtqQpF/b3oh8vMUqiHNbAha6GCnpHISoMUN79KrfJpbZv9Alty6UHTN7STXpbIeuTiY7hcq79u
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