7WAGIKYXwU3QfD5xUoyVbzgAiOgc+6F6CRXEor+aw8wg+cFat0Sg/DiPw1p0yVb8Ai4BHI56vF+q+HEIbFNERhjldXxskJfaRP+OHnAhKEsokSafr7IIS7KrO+FOPjOW2MMe5aNYwbprJoTJlYvhhfPT6UvbmcRUJ4wC2ZkIoxbmLEY9QTfsD+a8Qj44b8UwqK62XdS0jxNTAsPpnYxh9qScRa3ZXSMzsXusOuZzDItrS09x10p+pQzDbXxIKt5VxAK1ACYxa1nQwz45tvXlLcNnaQLBwozwh1Kg7XER+YjYwE5sgcwdR8s4YsmZup5dqwvt3WJ1b5uYtYA6nTHuYlEh1BH9WBaVIn+Mp73xreNHDx+z/oC7UZdAaeWaa3UtTVd9XvQNm8aOnKN6TXNtdkqnCux8XjZV6GuJSFkkLi+stBiRteI+XQEA83nZ+dMbRlTHBVfHrRvIfUolGZOykY+hpEkux7+DNpHENa3okOJrTnj3QDPXknV82/RFsJGwLs/7NuZRdH4U1Q13Y9TJMNh9V8NJjzF0U14VC5UsSF4o9rfnJDrOb0LBUMHvtFEhHbb/5NZP4aAU8TdtmhCsUX+ixXzGXVsb6jpk25vZnI92jrgnMzqKOzihV4bZPkJ/GF0HEplvnYndh3R9dHXD4NiUq81rdrUoHo1l+oL0W9MGsvp+mLOQ3dLHWf6BAotJbooH+q5OfoKKNcGEAR6AvC5oOsh1K0uK9v0yLx10MvIAPhnrpJyphi8HuNo+DZ4K/rxJ3iGUve6L+xZ4x3c/QYPvBMdp4b8ipY/dnMMzfDGFO3/BBpsWeOQGpCAfFlRaZ1SdcM+i9k7wnArL3oVJs0nlIm8SscXZibKu7N1RNU2txGJta2xQNQVI2ffiSPcr4RwxdZqszkUKnei2WIT/HG5MKZOhAafa16fu5WufOEbxCHAO/CC20JPyqx0g7F4FEyH3b3DMB4W/YdwVij94Ltx20EYKtJTxvvLHKr0p5r+sB8lMJd2Sv8pm4PJAI+YKW1cs1d3BmjDQ0kstSd6WXHJmIS6bFIPClKijiV5K3I3wc5du7QFkQGu0Ao4rSlxZFeJfPWXLWygZmaw/lmY+H43fjRsTuW/KSG10oxB5EXj0eSqoP11WG+J4HIV6NY4ZizI5VrsOQJdn6j1ib2Q/z3fnTi8dW7jZfiEfnuqTDGwrFnPZgWhf3eFM9FmjpLGh/aDCnQ6S2Eile/S6dxJEi4PHZbPvHfVYdtJts7AbSnxTbFuCIluq/sMZm+zcnW7IL0fXF6fO8zkEAHQ/PDwqxte5fkJ19OMe1ffQbiDCTbiOgfbd4kTa/nc9S5ggjjV+2hjy4ylNqowKihy5EwEkfkFgCPUMWc12RvxG/PM=
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'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100