XvsvuejNN7TDHs/73CbwdSWQFr0Opq693+rN05ee5KrioRyG7uItmTOeZEKojcMLJ3im/STbN6v4qHd/6HDoA5RnGZkfXyTEkfHzOp1ZefZ0TCSnGCdX43Gkg7UbMHsllpisPoYBI1ulDxkcvHUqU6NCpEIKbKowjHmuznJUuyjCjGlNallDBV+Ri3oryzViCbNQivQcnM4tkmoa9LjAdUcIn2wSpRKmfQUQbtMe/wwcgosknu0TAJRy1dlEl9rUJuTBPfzaWnW2CrC5ShFGeUawAFEeK/QkX7QOks3v5h8c17Vv5/lWbsx9N25xeeWSczgIsmregswXEPysUmLLQQpHGqFewMHKT/ePkIbFP83gXKJXt1tw45pxbgYp13VBACKRg7YAO6zcVyXjePoZDgkOrRX27IlENZ51y1/4qItkS6jZT4tLJ8FeuT3eFX1e1rhClVPeR9o6HxHyRDIp21Y/Gfdd0lYhT5wbgofBBzbEeJy8RHjS/ClXPwJwpmG4kKmOI9lbmj/7kPWF18AI2AIojTRaZULI9FHUQYVgtbKLL3rEmte1B/bSLuj4ojKt1Hnpu+X/qCWQwrZl06tm0mYQLoOpwtRxKdPqYtZVxEBPeCGu1qPoDmiUOXXhmZa8SiQzQdQlpktLSSgpVUrTmZw9ene30FDtifOcHxVp0BIPe2cRp4bACYl7iHsOeG5BfAlipxDdeQ2RYpcuhFu2fMFAmgnGHsFpTVUeMZOrVPWu9LcmAlzp9YFrf4zyJqhfc/StHon4JBWUGiFSFudbPGiDifJ6bGyHD87M4gVhxfWxWdqhufgVDqqlsMpq3AZTd3KOpCLt83rzB3C97pp878J4vuJTADkjzdIGrRfRxNZ9o0M82OiJPyuqx7gDE4ka+KXCFVUk5H+Gt8u7/uDynyUQjfS4ty5bRcbyTSysd9s8+Up+UxnUozn3ze9R332G+HwJytoHEyDcurKFUnO45zD7kVFYCKnrxtg/pJb2ucevMAna+OkbGkpJOcrfJJGpcm+HKQgmw8Vm0LPee6wBvLaOMm+flm/uXkdyNIYqmWiNQgXPogOL1a3NtpJq9qrvze/2UpKhttffkmxpOPM3rjMlXm2veryjcnLEHw0/+ubTE1psXQWVvwOl3bVrkr8W+qg0ZY06mG6Ip6FrGoGoBR+DpEoAfl16KKLUML++knoN0at07YyWEgRAY/uxxR3L28RWtPs9ZAFTMFASwcKo4JC/
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100