w2VxYtoXlJ4B8ToNx3NOeXF6t1BV5Grdaes9ai4dbmjh3HjYU9lb/T6Da7LTIHx040F7OasH9Qo2VRcsgq1GpxOspnCySE1QqwvwzjwLPTv9FFfJsgkl+jJzFpyNVJNsJXVgAAvihwYUdnwS2Y/nQk9zFrc+7FlDcK+0HkrE+YMhR7N5FK8WyXWVnAEAt2LmRsazYLRnRaLPwC4U5lWQZ86hHXvnuhLVbpJSc4TnPrjhXHv72CImCkFzT7UE3k97e6r6UvN6KD8TyDasCk1laDrQNRy0o2vJ+bQQ6FHUoQbzqBtpePgaVhK4asVRg4h1E8Kqs6f4gMzrwPPvp7BpB6JUDXDUZhZ1+AndOwlgY7pEg4sAw+TqqXZCNrt++3THgSa/xNE482HGlaHukwqAryqDTmR8c6zp2h+hGogk4E/ka2nXkUM7GthvC4G9LGxfsoBCWF8f+nTebMopFxJDWLXJRcGpblYtbL6rxeuWiZ5qO1NBqblNOuplYLi1qxeujaRjE1eX15/J2G0Mo5WWV8UvP8KyQYWG8/+yuIiBl5HeAz8r786oVM9v93YuaPxbh8PWs0SPf3sUlWG1KhK/QVTCdZVAtOoL8sAa3ZqHQSG2oHb5ETot3R7oaLJIkbj57TmQ6IWmc7p2fV81wWU/6CwF3KuYVxnPoFy/TeSdL7yrJylolv+8S+uC55FHj50g9Yf0FHlsmY71N3VdmHQN4ECpPAkPN4YkfVnavaULcDCh1knrJrPvlxxHRcktrAWj9V9JaSPPvtgMb5JVJDsGDLI3mUjla+zeffULdmzXtC2fW3nqmRjbYiZ7VVYLjD9bzmeTmzHEySd36U99cN3rCfKUfSerCVzRyDRSePNv4oZqDhIMtaRJ/lTqDEShOlkviYJi3OXsLuzNcidxr6+TewmKKPaizr3BYlrzXvP404ip4y6XxG3aamcTtF8MXvS4JCo3y7rdacSdYg/vj4FbTGT3+/9ZNDK1etEtvVEYkRw68v9GwXFKzSss4FObF3UWvE0XPvZ/FbkcExxD2asp5ASlFjPak21SaXF5up4wg23GCoDdClHG0FFk3SbRIxJ8OLDZH4BqUTbwzvl39vtjGD0tu8ixEeBOi+FhkZx6MhL8ytPa0NmI3XrhVe+6lDqfl0qpSjbCLZCL+5ZHdCz8nVVh9WmXbloFkErvXmKMFv+1kkp91c6QhR/vWX1Se2OLl0F+rMpELbzmqZmDrY0h8ZBxZMeITOvn3E9zOBSlTLvjJbl0XO0+Df6WXQEzzRoPQXTnvhB8nSxHClSVaAhH8r9yEsTgQGGRPqo3Bqkd4oXTDvUyoiCtgSDdOVDQ9orKxBYf2AK1ImrEB9Ph0kx0/o3ERPf8VUetVFHX38I=
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