lamlnhIaIm9fFQoLizp8VrQoeJwOCSTqZ5vC8weorQ135VKXILHi487iuh2OKaIrvpWE94V3S4vVPXmnXckeGjtcpY791UfaogJks+gKf3URGCfXPsWvQ/mWACUe6ybLAmyRPIB6wH0jjcpWxjslZzHPN6uBr2qiMOykijpGzJDYR9EIioRMy1nbwJO+VozF7CM++zWjRgK9D+Xs7x7E+WB+DS8anz7JyV2Ds+BjIpKD0ABzwxbxGO99fXbZOw+v6iByKAZ/mv18nm+sKcqYBYw8ZxsZPVLQIabUxGlZRzbNny1A/9Q+xfNaiRogsbEWZKYv92VoUOry4C1P6JKIOTRiL2sacEG0bH3++t/0r4GWzPoJSqIajj5d5ISpiDrdr+rk/Ss50yifCEE6UCFJd7zIBa9fGEkKjMvifvMiaIH5Hy4AGVjsbnoNJDhqZcGokePFp5lapGhLTnT2bx7utNUydJsYkLa/yOnaINpPIGANsYu5RlTOBghUb1YTeOpkIbF3cKH++9s5l/tjwxTanxCduwMpmM9E7hJxvtLbytvGuKbe+8xhu8bsmKoZWMG5I5cQDhVOScz91JSmeHRt2szYkdfSDB4pcaQMrd+tppg0DznSo/nnOoqeqwax4yzM3z7tgwhrUP8SYpDD9z5FjqYrza1dj4n+2gpdhUzH4JyXMGr5QcHCvQvfSFWhHHLT6Do3lNki36UdJwa92Uf9AOtAG0eGxX5c6+/GvNCI5nfXlde+42lb16OOOgAGBfggLg07wp6xtOCC4vXLBE+VLlEOUO8mDH78DDNbGd+qR/pVU7xm8A4N4+YUEV4C3I2EPTxgn6dNv2UqNeI63E8xMKG2XEfbCt3AGJRM87DQXcx/v+XhRXR7+z8AwvhQyTodle8qDWS/xk6ZYHuMVJB/v/kRvR49Jp1z7RHqVWgCSAmCWpWh5765v70kUXcofDqoFcn0m7OM8n12p8Gk8zhpEm9ACSc8LD1NzFhmRlkb2+QRj0aKxERgkc2+aNPX2kgcQZJImhLbGhdANpZgRsU0Nm4EhEoAag9GrWlyQW/H2a6Fg0CG0nBZsasga6eG2AfTOQNwkF6ncqQB8D91NjFqWAAwVYfWdpAy8Dg2TWghXzZx+i+JLR7sYxxwSi9I8iuG3v7Vo7u3Vawki97cVFlLYaaoScUL/fsHsdQfjZc5DbIYwrObx6R73Ca6wZGJL0ASJR96L66nsESC8Ep/xJh0vz0jwWgs2EHOkSBie/cCEmJU9JaGxzeRUEJTHljE4G7a15JD72fbMX8NPZkrVLQ1luY4ma7YQFZ2j3r/tGKYdtQF1u4OxMPw4fkP1iS2NTA+XbOWLS+0z2ojjs4lv+5KUSJj5zh63cXQl7RzKNE=
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