lktJci1uPm4bxsnJF+68CrVsr3+WA2DFIMRMRr7ijLxICyMgJwg1Dc+zZNsslvQBbrmunx96GxmTMNq6xaeKEAplw4rUGX+K+vHWfSfla4y+dgNWUsi97sIuN1OVIEXwKECpKyg892NZFFdpzelCs6XzWcxSeBkRKwRzBz86i6UDqn/1Lr29d31246OGowPCgcX5qbMGWpuMCtrsBe1A4Pm0rTtgWgCIdyK5kix7Ua8rAlTg5Ih/tck2eKifspZAYwSRLY41/Fo9lfTp/xxAb4Naarp1NFGMnY9XWLwFfU2i8E+Me/c75sbbMHJyQQ4keSBr2WIlbSQ8fNjDMOIX7JSZcPrBWsFeLQmUkBFwsLD/MwPciOJ4Um7y1Si39KZePBHRcaO0iPdqMksXpvynt4r6crseIjkjKvz1C3I5f8juobrIKD9NYOOiF/vw+qzS3qk3YMvWgYjcAauvEK4fcQo2q0YZxbiKWrnzYP8oa0gX3cJhCb1sftPciSD+aswS1LrFwpFLVnCHYeIpC8uD9uWlSFoNjn1b2wZ8ct4GxnuUisGeHIgBv6YiN36TeC7To6pxX/ZUP62JjjbNpQDJSIze4D/Wpb8l/H7TQeOiS3+mR3M2FFWK0sVnDHvfcfD9q1NZ5kQJf9DDOuqB6gSVRhOxyNMWY3Eey/0GJjmYBs2StPVgTreHmdFhiMp1qELEgtYbATVvktuGtLvU6Avo/luR8SywI9Uh9Q5tvGLOVKNH5X+vA6HkU9YaaA+L3lYYMRgbqW57vdPfy4Z+2aFXAEFemr5whfxdXFIp46CSMbakbeyTHqI3lE6Yg5a5NAuSPytgNmZGQqBcRKy1knt9jrnGBsitH/oh4xqHH1MiandJqA/CPRr1isf0ZZaUBh5DvRWVe5KXOgJ1AKw7q6LxTN6FGTC2wktgkHLf16TwS7EucnYsRncQFUdb//b8IPm4ueLLwkvsOnTR8sm/xGFssmXYwTb+MllQqmF15Qf+NWPpZQlOnmEf5u5NbjNu6qlgKN1vIawBE56MfLOgkdUk7YX+yEYmXQm9/jhPkyQI+/Uycjv4A5rAmjuNEa5dSTojcLzHZP6eYtYs4HAseOhrY4Suxm+cS8wrEKuyqpXReVvyV0985NxHlFjNIoOeAnCA9LTXS5O/YvNduBzpAVwI8QIMX6TWLm8gnamj29jIPFDadCzMJz3VItMlpnjiQmgZ1mik18mAgTlN2ni2YacKudygnWDX2HfONylEZwiZy7Spy67HOT5UglG2JVYeUoE14S2SegsCm+lzKV/5x78NKfcoccPxgcFhhUp+PrsCRWGDrJSRjmiJmqseM8J/woSxyJ02VObxsahFxktCHmapA7PfHJo+I0kdBm6jMlo=
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