9Bf/sewUonsQqCUw/kTO5nDRi4fiW/B08x0WznFMk5T8HXwfxWIB2vckTI7OfJqL6VxrCwB3Jdv2jKxU6DG8ABDzibyNz/wefBLE1qC4xR+VVt+ztn9KaJhMjMa2djlGASqPElOsTYUht54wg3yTl/Kb22xdOm5qMwM6Eh0jdiseSIGeQfBz2KD7bu20Ucc8nBD61+4OkFzD1yrUlVr7nKreVyO2v+J3LyFcD6KbjVAEs9d1UgdzJhvKStOCoRsEfrJY5Uv9Y8/7FlODEcMZ8FxE3+fNlXXQiLdr95tod+W1L/2yfezqid6fa/9lUuNXrJNOPUHwhmFhxSm1lf+/yuRIxFGikTohtBqeLIZeZ52U9suUVn/EPa4gA6S6h0zy2ZYRfaQMqIxK8dwDZWa5znlKFLk5p+kTVzNilpvKMVE09IYBi7Fx9FGS5aSw6rRQYvu7tTxka/pjks5lcUkTd0q7o0srZ/4nEkZ5soP26rBOQarLCxW9cuhOyl/asRVsXGQ2Bd5mYSIUvTXUiDx6VzP74KChIszpo4bWLsGEqoHxazGqL2e6viSHfe3xhKGfZfADFJMAiQ5p7MDhTLrOapL3rZi0VN2WzF1BzNaOGU5uXsQ4ef6CUXzFOmUbdHLzwJEAvjeIoIiNOR7EOpoUFvaugUw5r5QCcJnTd3VLIUhxo72jIlJ5ZeP2TpaoSQt9smuPH+gi0TWV55GV8ZRfn2LXtic70O1DZ0z29R6e4p0sdgiyVescQz11pfdmBLQ6pyGwxlNkjqW4PixmEU+33PcndJMRSQ/gL6o5WhUHON4tQP2lHS60etN9B/Y/xRjjwbwsajKMo62RcHaVVkJHDF0iC0iVp4X8UmbP60KBsdAbkkc+3oTjpjlTFYYCvyNwTBZs
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