UitkGLR3AICeGD8zK1SRxdAFruR7SIDgfrtwGmmJoY2k1fGiYJ5GZRVoWXw1Y4YTn8e9mS/kQpeg4G8QOW3FgB0vvJCKjpoMs5g8G22QnlRwPPHYnTsWQPewVpD8t70Rkgs0f4k//ZlDe9862zC1DdzzHro3CJaj+fYda6DX93c05yk4w7Yv9hT3i0vq9+WcJyVm86ZWmY08194D0RrjBjF0Qo5Nf1hvbbl94qHFbzrvFK403AmeSgeTkEqUdwEvFFDeG+Bcnhg65Eqw13vSicCz4nO5Wh7RYNjjyt3+cFsf1yQraUUXQ5x0v4km4S9umd/AyglHv0v0ldsBoU9eiBS7cs8vHfjNZPL66YVspIg2+VExieRyIxRpV5OS0n7d5xVU9ga8As40JQMmu/TGfhZcLtgHhehAucF3tO062l1sQ7BOHhoVsPS1v1LZ/kit7vbIZsh+jSMFMYj+8Y9RLHUH55FzFsDhdZMWey03UKUpKoq1NTruAP2WK1kGLpLOJHnYynGXZQzlKAVmWNmXm19U1i5WavWGpV9x/MSgfzk0FPf0QflZTgb729+LxjTrCSXr0T8pWlleOMPvskfgIiJ3+h/ZFx4o1uBCuJSg/ORRBBxMk/vbrUacW5txvM0g0va0RDPZlcCLS6WIIZ1GqlmP/h+HgxrqRDID48IoZj+Y/mVXqU4XtMXroV1PUSF37E9XxbISNpcJ5eyPQgFPZOqBwASVPYVaG5vWSxr/u0xCw+IA3qwHtm2GgvuhA21mE5UnOYYrvRmGGt7rLhifcN6pm1hJhCLoOBA9jptSSHp7aWnE00MYgFHaFkc+Pr5kio6hzVPY4zwuciVZehR48vFSCZaQqEfxfXvGgSnmLg9ErtVumuBMkVjB8xfwXbaTmh8R6mA9Vf/Jsi7q9ro1n/ZABIvK19AX/wikTEuaSdl1LWtl3QxJZCkAHfXgKzNSdgyiLF3M+Qf1GtykcfhyfTMk1qi7NrM/2Wc5+rL1aOpwunAGAm090/28y4ZDapGAdYf1B55vkua3FoKaFa6SEGegWhtWawVLTyQjXTUxsSpS6Gfu0uuHucQhYxCI60t3y11jWJwJlCK2Ush3zFSHDHoJuDe5b+8qYDGFjuS5VSAqgd11WpW31OdQ8QZrpWqYSTGASFhprfBxgsbTV3MyeBjiiVA+IVdzw/j35tmktyg+uk3dbmFV0YH0ulE3hStMDkhdog+qkxKAm54lbrgJXvJfFO52+9Dl221lXMLwvdTwu1ZYX5eRThoyJS+SAyiPfAC7Lowa02alSUz92rekAazvJ2tzBP5Dof3Z0y28XiSUBX7/2JXED9HzLQZB5eH08rh05jbuBOqd3XKFs058BxpwxqYRQt5iQ4A97r4=
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