WyKSJw6NR/yvPJajuDT7BWYWw7EIdys42JJ1Y5q4fDWQAqaoT8TJjhVKQi+Qo+Y+CFY6B+mCHYtjtUkuwHa5h/TVMZwY/8KfWK3uuHOdHKmmNhittimLuOQb0CDrUxLcspagEzdyf4xKj2W47xtANwdnagJotng0hfW4qScoCJkf/kvjzM+CaKTRC8M3mdxyx8upcO5qhDtxMCJY4XqQ05XuSAfotZHz6fs0cdgFi6vEEigi2oT1JDF4Cz0q574rhZ6bBZqzQzQ8oRDfAlf55H/Rf+ruALfEmVUWKE9R6dJ/fmebmzbgNrGVZUHFfMW+IQ0XkUcsjFo19pylW5kf1owEyFZuS3qJhvIuDcvsy6WLfwPiv21izn+8gKLF7zW44n54ym7I3M7ekOtdfGJ08iCdnsz+WJfcv0aHm1vM/gyZN5+RXjDnas4A3MhPUJ981rSNDyiOkDQ5TYa2g1Q1+i0Kgm4UQak7z+AES3+ghytDC185NY3mY3GijVK9Vi2pb+WQ/yKedh3IM47HdgGr9HR0YQhXLzcWxA/PZJTDlgRqDUFoJ/c1ty46kavx629V8PTmtxzubFigqwA0OHLNA9pSts24AdU9a4AsHgTuToA4Vpx/tjCH0LS6ZZf7LPdxX3Kb3+RDe0Mrj/piD59gODoBAUs6/XODbzb+g1QsU1rQzkghRXLq+t+lCYCP6YMsffD3tLkWpLjbK/S8XbIWK6BX4bwRvdlr8Qi6WevwPOi9XncjkEKcsu4Fd8pylbIkwr1dHTke/tzs5l7bFIyTkkghJPKeISleGIQfd0mzI4SBewp99nKZFfsglnnXg2Q1qJnFa17fOSJuEmGS3VjGU2g17jw9ho1Ody1tM0M0RIILXqAfiFGlrLk5N12PrjWt4U/M3iBVqw9qu99I06ap227vFqMvSOAHq/UsgdG/CK5Za6RLFNX1CYltuvRbvlAyaGgx+xq5GACiQk0HLoYwQNl52MzID8z8y5FWyHxhV7G5FdRulAViRYbi6M7lJyJV4lMsEGu+zUdg1GdHMeuGHTWOVbODdlLitbTzMyDSf/1jiBeL/ziJW0Hi8JghelnFfDzfvBKtv/FYd8AqutyzG8mNlO1VydZ3bj9jUHtp8LPJwM6OfbkuEwaSIbrMGSYv8L8iy0qRvejZCKj9OWVjIbm6BfhPUKNqQSpnT8P1tyIznh6Qm7IjB5hHuYxCWtI/YEEwpnDyrPnWbrSSFEDyIYvz6JYhtKVuMAJKxAqTXGlcpI5W+N/4+O5ifAp/6oRQTlwQWBy1lp3RaZeOA2yfxBcm0mtAO/FbWxZU98V2tj0wFYulsvtqiusfvQn3iXKdId29Hvq/243llL6ioYc+9e8oWZYwnOxXY6jQSd4=
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