0ZUM/wzkP5lHvZxZN+raTcX8/HynBxTbqqfqAWDsel3asdHtws7QI7vjNA/InBYJABv82yIzs5YA2WNrsL7A0l9c11llyR0H9GBDNl/5LsWz2a837+ewMXoqTmdG6FQWokeHa90A+VGlRqJMT2sfF58kWcZnucapV6Cw5/HyTslc3AWGNWHlwJqzzsX0mTa9IhBXqKxznic/Q709tNzuX/Qxe8lBH1BfiHk8A926Xs/wIrH825sbwsXDH5iJ/X1PTdOlln0kEYSOKQCpum82a9lKLpKjkRhRi4aUURzuwrujz3ReQ4/iFYX6nQ5hdsyzcjUi2XJi330IBokF824BEfzACA7weIIOp/3/n0603dNGe9VOFQXTymuMeFNzMj76dMJXK8mQ5OrQRUslKfQcBFIqwGNVrH/I0WaQ/B6e9JQ9B+3IIJjuzsugRMHtq1g6x4bxWRzTxDxMbtBP9DnhYsA/WHiFC3yODHxV07zOI8Vww5jVnp3Ja0m2pXWGDhzyojyQjhd3Lodv7aJ5Tpq2i5OCxp+8RlfAhuCqlstyj8Z7qsLA1yJXGsvgloQltkN//DzwyfjOg7KB3GDvKyCRsnSDoYW8aHOayUPsewEXDwQAKNbj6d9+uT8yrkA1vt+TlgfdZXkRJ8VQWS/PdGqpfxvN1A8quwDLuT4Z7JSQ/j1nFQcwbRx/YWA98lXLvX9iKBSzaISPWLG2uX+BliCZtLW76wEJUlnjuZwhld5wmtyO7Oe1S8MlA9kiUVgWv8p1l7/Ox97QCvigAkC+8QRQmUDT/fPLle6xX6yXaaMCoqmtU/ZRtYv29JUTShn2eROb4hSGAYfsz+KsbCrRrNtDaqdFs5ZZg2hoosURVKOWT8w6YRQg6LFgcIljpqOmqwdhBhEwi+xWfpEHkqZ1dSP1sdo12wvf1y51vAAJRM12LijnTqtih+gQFQo8JlC8+8sVi7wLCio2KwHt+aX5HOik8vRQUKGmIR3hgsLEAybz++YsCNem/uXW/rF7ELq1BgC5s+v3AQ==
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 approuve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1' 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