HSDiJKUaMRZSuTSzccQzsrsAOF5re4D60GO0zzdf9dZ/OtnoDzZfVriC/J/MAbjlGf9ADH4M1ZPdQT2ald4LYXBchN6Xq8AjTeJlOEaF/wzEWsNrUl0XMwwaqnDm6IC4F4QCd4hlZYGTCiigdDx+q+t1bfjE4ygAK45AAKhQUvwrBce7CZo7Q2rID2jgE7e4BwFGZdMhwbw4ts6c/GhFkrRLzhNlbKeLy1/eoAC9K6EWibsHmVRWFeYG2exY6waHbMrOYPN3666pL+j44z0pu1OU5mh2iMfl8uTOysSwmknemZ7P6SAXKYNmOxyVKgnHKOfNb8QAL265sN4/Ps0IAANfSQPU3A+eLSt9OvNBU3qsXvlJBFxo2bKKkfyakQ6xaNtlCdsc/JX3HiayJYF3TLfPrf3iMimPlRRwdkZoTkCU64OeicqjfssMBSfRLSQvTHATU0/XrS5LVVUeBrm2ApIYUXNsqrXxmhs8qqerwj2K2HaKkaLcNIYveh5SGbt6C46XWptI+bWT9LC38wNROZzz2X9Pu9rd2curdu2OlQxxTrUV9JAm9d362HUQ9BU7dtQi72RI396h5JExdOizZ1zbma39O5L4eexk88rJSsWKAJcS8cSyCi+lZMF42+L8VN/aIgTGG7it2sQx/EsUDr14SR59W1st4ZBh1MLgLAzXxtuIr3vFR8mOKLp6WK8SVl2+kyQx6GSqoSG96OJyhuwo6bDVW2DRQ/tYfJ1230l28YElkBI2DJu+UlCyDlZPA7HRHdkoOdIyotA6VS9MccptzVi5j2YIbJ1PAJKFP5BmJIcQeD4PuKRD1+dZh/IVV7ZNd837CZik9aRhHASDUX5wbWbMaWK6xYU2S6RworPSGqbPBhq6+Nj4zZlHeGiQK60Mj68JuIR33Q14fInD0vK5sXvk1s2cY5TdVas8tzbrf0HS2ZrJWIUZOCihBldjZeQTjeW0vxbV72rZ9RbwDezaVmVvzlUdOeZOYaVKNOpP0mUqLqvUp9CyGT7AvUcwRylVdfoTEFLLvuekYcyheTyYwQ6kLDeoRklTSY7DCrmgw914yykprACQ5Hy9cSMokynORQuI/z6ayJOXi8sjU9PJY6lMbiHYltAMegxnt3lvYYC2htjx03hbkjRLO0Ms2J8aMj0a6zxy3PIhZnehdv24IGDZ0bWtkNzVI3ZtqdAnjHIjrjRUhceZBNLd8BCIAjs5nDsKWYXmDloKf0guz1OE2iW+2EZcsYexhp/pqLvGvHZduDf6DUx1v3NLiftireGBmTu5qrKhWSbGFzE+7jTDlyFxrCFVmGrpqMnNu1fl4Fruz/ap7FkodivNT9QG1indo979Yz9C8Kx6t95BdFeTzM8e+giNtQKJ/wY=
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