OaNEWeaCNuIH/m4Awu9qgE0QX8LDgjhku2iswUEvZ7ypjl+w/jdmk5F8kiY6yqPpHkfx5OsB5zxaiepQS5VVWx+KUTmTze46zMQaUfDLw2WHgisndwgqQ7f/Uqu7QIaJ3Q8lzYMizKJkjD7t67N0OkZSMN5AEQY0E9umCLE7LD/ZoWM3X2z5FrOWn9mBGEFuYS7dwIfRr1fy69B9SIFDzjmZtsehjgYHVP1iMfJzsTlcZmmxxW3E3UO+1444twXDaXd99FophI08JVsDgkX+RgMa4F8NyD+5IhcklvqW5YbBTallUngC6L3SrMjt5UoC3AXM1wGa85Vm1xfMk/flgk2+Og0TqeC9ocvYzP3WMmtMWfJFTVWsuNqCs/ZGa6w9qBTiAQdnnDunveoK33/HzBZt7KqbvBYOprYPW5AF2apzZXu9hrBLO4IAYkBmgVoBXEUSeAVfJg+1v67Y8znrbbsi+mtEJmHwcakcDgtddpF7hn7mJccvsZFcCd10LVLIpF9l2GHgw/ISwrsS+XF5gKkgcukdg00ovOT4lEUR6sBo/E6Nqe+3rBZ+78kgBQ3jgWSLPWjoF+n0x2OvzTLP+BhzlhORDmrc85ipNIRV2aFMk3e/foZu8uvlO2vsDmjguIRlj+tG1uAsfq6ZazeuZrK9gX5qFe+NvV8YUsGAejFx2L0iq0NNLRO9NPH4NTruWIdI9YgLOsM1aU+qiwqDEQZob1QR7y02BpzVF9a8InGxzAcxWqLYJd9bkyFDB8LmOxpdAzCp6bZU9sAFFdeybLqRajr42mEdHthDGkmHF/DWlmAGYkFdxOT/MxZ7LIduf5RBTqwzisTcPb9191pCA9tVVJ0UOXAwECvOKKTng+zDFR3Bej5MZiJoSMAc4Z4usSCQi1IuxvT72k8mbEIUVjneRaWnQC2VnnNbEceAfAcc0Q3jaSlg1Y606JkNx2N4sO0XjPamvapRCkU+zHh0r77o8GHMoVSw/n/HFuuuwlmvogU1RrC+pCkm5TNzBTuR+hoLoSPMdzWyG5zIAcB7rue9xqHlyTjaeLEu4bdN/DXugEHu/vZesuonMl92JqAqA52VySh7qDxnY15mRSZ8el2F3+AyUMFkFbAbRdXQuKEMSgzCAqBPCMBOwI8nORWA/uqZWcD62rjyL3nDCtVUVOEzWsd1yBDLma4s0W0xeZvF5HYZysokm7gMrVwIcXzHJcXvNodDUzea19XKdzBXu6jSHRMWOVdr7va7bNfgqr3Qtl+fOvIQUrOGceooaxQ+IjhoJlnRQexM4HtzB1oXbJopZHXVWauAUjiz9IqtW6ES9DmxpRfWGLDkDnQ/Jq1bEShBEsxcjQCvtWMlk29OIZ4aQzPjeuhpM7PPMtY=
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