roiJ6SZxgfoqkWnycU4cqaml8QEjSlVkWnBH8Q0ZyIU4IwEcjTp6O5yU4dx6kuAHtFKUVK7ZdUXvTPl0wWI0NX26faT7/yu6bAZC91XUk0Zq4aHNGlvjfDb4BYsPM6RQ77b2pLhuHA9HbZpZLKgOAo5kKUgjIpq9/382I074QxoRK6Ss7u7isk9u2hOm3HZuBpu+GVVLe+tYDnOEXFgVnR1vX2mMwhaCcBVGG7nG9hrUPa4RDy9qjVCt716pjdsG2QisZrA+Me+6pR8gqsZdZzLLrAoZ4ZjwuXBqhJzw4CKntp6f1vzbbhxbrBkG8X+noipUA6w3TReA5xgRGJXDRN0pPlzW0oNxVy0BxJ1J8IZ4lel5pufJRKqp6OrJX4oI+h2hsOTYl5V/KcERhybLW2RxSCO6Nku5Zn8MlDf9VEaIoBVdaAvUaJYyykZzwqTBMKB+ln9K7u9yhS3Pn5I/CRkENWFSbhgpl4XKAKZHNTzu+zhT2I7NQIbuwsYmxvDskNzFBOZ8jvK+Wlwzwc8Sjce7Zjkpy+6BCWavy6XLzYYN4Ll1icFh/IvBzHbnTEPNrwer6sW5UkqPMfQ3mrIuSYhGKWCVtv+rtQZQZcjjUwKCdEpAT1ap5h7pHFxA0MpuX+c73EP2tEy7IYw8Xq7UQbewi9+m+G1LQkPwiAYfW5a6f9ZqMXvKpPs8KRU7nsE5CykN+Uot3cNASSKXU9g3s9xjNnlajufWuUcpzQdYFFL2JqP0xnS0sUu456fEFYvJ818SbnDlMvzdGwAG6fNz100VYhsLgnuqp6Cjr+I8nDUpApOeqANy+/m+rw6Y7BIC+3I37SvEUF2d2fOC5LOePLe8bI/6glD47BvhipDXGw9jLa8O69SJkmFKuQAY8FsuyFePZ0rylinuoQF3lfCvZpMju6jpYim7QAFu8jHRTo2EJPRKuOHKTsct6DV+J53ETmlFxmFM20ErP8d5/ZIdxE0yJNBBweuy38i5p7Wa3G7IS8NXOAWhM6g+CgvulwXG6IKPxfFnNolhS2e9MI6NgCKRHKuJb04kQrFbn6DH4bCAGauh2hWp4VcFWARUFdd6jNwYYQJcbpLbjg1cwNLphh2/YqYQ2rRXhN/jagX4ut1Ko+q4OsHzYe2FG5g/vZoPT9YqfHJsul6n59qMXIwy+0B00ygEs/gBskhi5Nb/reMY4O7tnTnWiomSrJy0eCWjLQvqeBgS+cTs0yDPgO1FhMsXUJXK09EjcvAHa7IpOx/byr4IAU71l89Md3R0xlVl66VTbX0ibOUJEw6mNxasoPVUablwCJoPTcau8TQu2qhMrznd4MR8oo9CJ8uDmpReIWJ95YD5LjJ1luykLnbl7hdw60S5Q6awG/q1Qdw=
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