dPcc0pxGbqT0zYiyYVst9CpbzMbuLMyLzYhaLgAygu10A0EO1EhRFtwViEt7d/6totom1oUZ28gHgmtf79Oc0vWoHlIs0DtkAmcVtsFh0zA+Zpnyip3opiTsQc6cwszWxXVf5kUG5YiDOHC53x7ecN0MYKWr/bBVkQ522VaIeKnprFlxxtID9qHyt24BLTbmpvxNxKW7WshCjqoFpYQAvLiwyAZWJCsceT5TNaRTTdow0ahPzrPnBIRinxmN3QFj/HzpEgYtX4bhsYxg3tmZqNuMqy6HBvmpaQpc7KpEcq2ZKNjLn1LWiKRu9xp2L12XAtYybl4nJ9tnn42yf6wp9HsM1ux5z2DkceK4HSLUy46xAd+BhKx3nSTsrcoeouAkXzSn7JavjlyN8z6j/oZBssVxG1Mo7Sr7sBPxWeb1TF5JY0Zu5+ejrkjd3vldo/R6RvGAVhSYHOJ6aPfXcK/C82q+qyf380ZmelagHupn4YCILHmV64KUqFft3CRN24u2TIzLMeztt5t/Gist7PmNR9aOhu8dkvEr4ei/hQMMO8C6veSfd3AR/zB6tt2yeGcWWmDjyAXfI5G8AOHluhLqCMRY9jUzEgKznirsX37Y8R3q5CrxT/ZJJ3LYnRZn2c8LDbPyhqBLXRotwTSWjnHUt6d3aOORGreoGFr4lLaFjOWTAsIIyOUfEcqOd3xio8uyd3gKfBWHsG7LI+4LnGcsb/dafnOb4sBnnVnV7Z2vhv8CdTqtUDwEbM6ZnXKCJjA4KOHRqTLTXubnayVULcu20fgmsOA1EAxZUB6qYbKQ0eEuvUqEvFvwlQxviZZusgD3WJICx/NIr1Cs/AT/4fdKFKuIlUYGA0VKa2P+k4VdYBMZ6+lK+wezqGXImyGxD+DHuY10Z35/l1ayNBV3k76NXmJxzzuIPSmNTS2ElcvTwCzLJi3MAvmHLIR6nI9nLpBcFHEfr3imCwh/kJAzCf0rvmZNXGXtXqiXy8i5CudpffY9TIJ7snOygAEngXcUIWO+3wg4SQsXN+PZoFJg8ZPrDJKoat+t8NG51x7MqEGVKJHntmDoyZ0+qo4Ovi1mg0rSv2JUxTStUfQpfl2wWbDqc15gnXJIKIbzrp2IBRkExfH55UwqGMmvtZPmLqkbfuCUScAnT0jeoMQgaA/VOh8UtZ/t1/bbKl7bqS/xNqch01jdF0tgoArEdN/0PpDINYU2IC4rCM0N2NbJwP1v7c63inffY+vP7bLccBg3EvnCOxxtIW+7LHFwdD3dQdC8pOPjhTDy9l1jJI3R2ke7WiCnu+tncSBn8H+gpHYnIK5iwdn0zoxXGDY74mzdWudHFCtNKFy8IeKIM+FOU/CTHwoAzoUn0cAPy/zIuoVR0EA=
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