XMSrDh71qJCsTK50HnRBd/chAs2MQXT0JvMhUrG/rWAkVdJPZlfTdn21JfFqeI8GP1IeGX6i5OL8vw694OC8sC5uamPSTB1pE9XaWXSfk1ZD11xc2q//BxV83bMZUEJUL+QKQ6q5hj+IqTd0ExogYK1lbl69GZ83X0QHYq4Rl6m9luoNxKhcHlwzeS2PpSn01fLgtSYn9fXIfOXj0wRBNlks/dBjvXb1UsZquwIwUXk7OZ3H3nN8ckW9Zd/6W84mWoTiShuNyWiVAEx43AdvmA1xiU8XL+eYnYsOBJHz2y9nzAe+nNpCjg4BaJk+0ea14OzDN4y6QSaz1Yw0UFWt4jyW+75+kP6uMqwNxLHP3u1FY9IDfz0SZCOkV9/PrGH6qMeBoJjpTcsx2lfwNu89J89u+WJeNIiTTbB26F3mQWE4Vo8xx38QmL9p9chWQVXhoaiZHY6I3PFn1gPQ4PMLmdYpaelhnrMss9OLvBXhKupVihljkxVGmOdymHDvPaRXUBwSmccLJsYgu2gh/1eLmTnuEKZzR+/SYFWg9afQDVqFZpowzGJrUj13rbwXt0gC6TQo4xhJHF2zHrXM/LSvDFzT9nQ92c+gsTK+52SnAfnHUnhXp8MfWqUp08BFnvAAzlnExXtE5YiJnxR7KgQi6cbL9HGymsnkXal7sZ7eb72dBFcVwJGr//yfXzSTdcR3li2A2ru2qeC52UHVbNZtvcT0RxkzNzvrBpqmf/t+YgHufE0x/XI3+oViG6giW6z8PUu6OjPnyucuDfVwVVrZ6lMLqLY7LCNLW6X9cKIWnK4zChcPtCPEsxjfk8uF9bNs2CwxMz4+XX0gBAGYu3bLnWM/XDJJV62zIU0KTFjScjzKpkQncko1CrwPRxcLSomaKcz5NcJH864UmDP5jOoHu0TVQZ+WpLJiBtedI9fsRslhA0yMLDaay9uqD3Ecb3k+LK7nRIASgYC4+H1pcdDnSJYZYGik5rD9zZhKD5CFnzf/eiTDdUFIo6qhX2kq49QCJljtFZKEaSJbzQ4ofFPET19eK1Hk7ltuTE0D+fqwAhBhsyJWlVrksRDx4E0pty5XzSJoVOgPhqVivPrQTD+SXhCJGLz7lC0TkW46Z5WbtvVh32e8OGJI8XsfzaB9E/9zKhd0b9FsP5isWzs3S2BxcVIsUdbm5h67S5zXeBwD5za4IEBA/RWX08k2jggwEIlZT0lW9r7Jj+i6qZzCGiW3OVIfzcdSoslZcxgAyMJJfY5auwHLy2xIUMDRY0K6/P/y1b84vg2nW4J5q7FQtyPMaTD4557Ee6+FydLswKJOYENzvY4iGkQJlyb8u7gpr1h+XRz/Od+C1UIS9O7PvXaujjGp4P20WKGUY4mVtnbQAsUsRt+7j7WC6O4cdo3KKeQHE89n6bqzrnbQBrDpqPIEF+YQeZzBzVP8t04xgW+srbnZu6rBgAulLVLR4Kb4gTwfzv4PK553rX4jVpJBsEIuDnndQXzBDCH3n57d/8hotD+WjKlbokrx7/dRjMUm4s8AjDqhSt5MvSXAcZ6WssK1zRydlYpNmWLGXL7edneFKgHo6pNZv8gnd+RSJQk3PJAitViftyPtlOF0o9RSpGO5u0CbTnMFJDTcnmF7BMHmNJLBZh150aZNFolr6dPyqb8C4OenUQ9YNSpVRwFLYXHSNvWyRDmirQ990xSvJZonNaogDVe0pqoqGgbjs+M=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100