P49XSMoYA2x7xN4kWLm3072xV3UzUG3eNq4ytv+TRzjR9zINHpx/V6N6vb3vADbpS/0AZIF+aeE7lkppBM+LP5YU0P+jfBWBOjU2NNdWAjgbJjV/qlZXs1QBYuvee0jN9jmGI/hQ3Dly6fubSDhaZWgeTb6mqJKp5m5qU9nSnVDj1GjfdCsHg9+AsXIsj1fKgH/f3wVjwr9eP/I6UlOK//xpMkciN+QBPTGLFxBDpu4AF2bJ1oyM3RDwDvwLzEa7EAuBKzbNuNnAgTmicDBZgAWey7wySyjl3KDb4lKgF2yKLi6UTX8gEShJVbr9uCS0UboUnTLy4xit5+Q3w6AYnO6zUQq2hFIRN60T+FOx3img2zTvkP3C299RH9hLHwQHmHc7WJ/ZfU0yvSoAPeAKnAmgAcgXMba+tct2+ybZJ0UN4XuMJ4O1SS2rmi7D23N386D3HP8vfQgs3k6ZkfQ9fA0IPHmC5zADTz8RcfXQqOVFQ7lYokgOcXHemWkhuZQoJ8S1Hzc3wlwR8H8WhwdVW1Sd4hSHnXENC/y3E2IBHvY3C28cOPj0vbPAyTyNQs0MEFEZ5+8nOBE4IP6X8M6ezTxbslUlqVZ8cNNOHymI6pi3rGJrwoLo/pq2R9fA6U0Uv07/4LZA6f7pzAKXLtPkUPt4G2RqnARXvUC+EI7WpKj/ExB+LJoY9/mgAMBFZ9pof5LxM9gJLvLYtZsBeNhxgL6k7/7FPKpX3EZJEE0nvAcvaw/mlPIiyUqZmAllgnoniwB//M/aYHlyOipEkXEe+c6zn15AZCX0FzkLYdQvrfjnl/QZL5hcultl/O2KNRmrL+knHI7EvnvVcduf4GH9F72RtpUn2JiwyrFAGsUdADo+DMQQzuYuyCVpGx7JT04Ve2osRviHDwlv6tQRvUMg87XkKdrK5jHK/EdPWxb+408eiQ9CsgfFlxkgjZitnbcDBrHWBtIIl5/NHu674YsxMOtaJyQS50hWzq/ax4lcceLQh2xOH72BFE1lWMBSZ3vv0/dRWCvLdDQ0/n8ZT92vlqqEdsCod9pdUFbYCfzPpC7qODDaHVH4Rw/69/cSP3rOAVrwwQBueZ4/9AM6oKTF+t1m08V2HdwuMaJ6i1G30tOO2qtn3+NOwVB7BmVEAcQEsX/cVHN7/d2ljvsqm4gcP0QwNriSsvsjtf8Gr3p9+9tonWjkiLb5FWJmRsB0oJ6GWdR0zcxmOOUmaufjFIyM2lo/GslRGgnZTtMWNJDOjLgHZyW8p3itg9Aq1zwXTN56cvTF+V0KEi5eToW+wyFf0OF45I6fqa6l5JuCTMrPp3/9yYbmRu4fiZcDW6F9QffaJKgjFMdqksPuPgfyzZXJ3j6mrkyFaUlMoIEXZKY=
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