OImdiU3K/JpMrIoZHjL3WO2tRm63DIw0Z1rN8WL6+UbVcJy1lW7pHA21MU8Kugz20EufERaKj9UvRjdhuA+Je3CcsFf875/NcDA2dQRAbUHp5CY/bW2EAWZUGD9GkRnLc/pwjXRftIk5V430+1DK7IgVYZt0FJiS83xpMlOxJ8EQ4qLZMpGC0OF79rc8wUcHsb0PjmyiF4gv9lXxDSbaKT01up94Yt+2jOOQ7Jmeat3Ad/PnutYeUyy6MGh3sg2cdlNp5DAv9DA5TbwA0ZFYUChPHCA20KtgFFZW0j0VTlHHHXPJdGVEKNpww2v+635wVnrICwrAXzPzbdMNzFykoORjnAnd6XBF7DYfxuW8bdPYFuAVuKZzG+jtCGlvExSABR7Jn1D0UkWQiJyDmxsOg7aKaEQlO/4n7eAZMIpHscmyFzSMobPSOZvR727VbXPZ58nnXg8Z3BrgMpkrH37IGUvNPx6pn1+Kt/+lZXHHOK82adQUQjz6pNHzoO3zs2ozKUkjmLk6qZbouSZuu8gMnqxRwAaMSRAIVQPNenDLsgv1vwB/EEt22STIZlxEu2BdxA+rYrSR/jlgQqY+o5DgYDAEv2jSurzJQSesxGNUg2SrgT/hmKV7irVKxn0mHcf9C8qrM35fn5lMX9Vy4rKckFQAhBnfQzpf1HSg+9n8ND8knL+1gMMDSbp2SqHH6HAvAH/pQS7pCwuDAhX/98gdWTBHRJtPVOqjK/ZDUmnctJIIP/pK617gCNkBPN5QZqYzxF4+EaePXim3iZZtV6avGC3WvxAV0xUSHfpMC5QY0FCCkegZ1Ld5RdT0a/wxAPLKREMd7OgpPLwos+PVbB/3TxDROrD1Hj/VERCUiWGEwH7jeCMtcf8SHDXmJggGM2CO80eXvj9BU1LSAbd8tiPH3dPW1Vcs8SRJI/hSkQhKL7n9WQZrtfyioyrDdpiwoZWswmE8jI1QdIcJZBXScE/yNLw25Fs8lH197kq1E/MCapCGDe/QyheE2hA1fGhE8DWiZbSuT/3vC2br2HnOxgFPVRO37VdDzI9wbF+Pj0gJf481P/CfFq4gptcHXofnG5xGL77H9Wzi3bqYJdPLrSCcPuBys49CSyWiiC+oNAGsW2bXCGHzbwH3DVAxc+NLDeUUQPbc+lgQG3+DUGg328OevVIY17fWvRvfExxnNRnj0CgUuH/td1Fc6Pw+iALznXpYX9jUgr+bGwS3aPncijC2NKo+0n6E0b/c+BMwc5O5pzJz6MQujWXsa6Tz/CQoJarXWzCORY/Pvbi3hUsUwzQNFK1wmsUpMyMxv0bRr5fFxnZTiGmPDmuJrnEUjVjqvQl+hfKpKR4nZeIFkefnT12WbUrTzoZFPEZKB+8UKsk=
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