f4OgGR7sLAxKGcZc+Mhmo99TRW3cIyt709C8SzNk3FIOEmTKoNPq94ixvXwNrYAgkF0YmBNtm+5WQOAPNQyqOqDbPE8PW1tLBhoZtzqNIp/aLRhIDUFYX+P8qwW/8A3AmFP5lorl/rwIG32UzJeAQHogzgjpRROt9JjuvlCHwy+bJnmhPJRwO9E6yL5TMt8xVXcN+82UXwuiRBf95rTodz1YLgaHw00ldWEbQltWv3UYv7jqKhrn71gDoikMDc+Y84UdGKtZ26OFm17I8bf6B3dCuJIV3Lowr/+WQY92FgGpv3lS353OqAjma0HaCk2fZ8J3CwHRNC4yfdeeA0cWjdkmmt1TDfF67lv+CyedseF0qqgEQZZd2OiSAIzqly6wyIjLcUPNrTLXnxiOU4L2E3cgeqkXncZw6S1AnKTAhk+FgoqmZQ8RzvrFIzABu8cAwYqgeVrvZZ1jp685Ma9VOEuAn2A7TIYvZDSbZFxvSGfEyso7Om3bYDVgle+INL5PB6Ug9F6yKcUlnWgLXwuaU01+HyAdtb24c3IPOZPwoX0tM1mr+g80OTGtk334EmxvLXl5wU3QiO8WluItGv5pb5z79qpJIA0frRpj4D42928wui/4GvSXGAgIF5tliXjmOxXvsjTZ+/YWdXMUsz/LZBn9XmvCVAG0penYSUHStUXTOl/h/xBhqUOHs9NlJcca7EtIz+rzC8x293dcYTcH+d7Pi8Easjx8WKq/UxzvWvsZlsMWKZnATF3YPdiJZG8oTBelDkMsiit0qjrnIUVFmhgQVnyoRklDdapL1mRcBK3m2d+Oww//VgUUAXEG0VtUx9qOvaTHkt2fk+6FerX2Uknli5ukZowPAvdbo1R12N5T28zh+9td2fDC1ZmXf5g/VUj8Iu+sa7jWxeW61tTP3LAj5bq9pu50kxrbjeXbhqiPUM5ptD2vsTx+xUYs6e1qLKb/Pr7p56WNodzXSaW78WQEbGsfuXVav1aS2hcHzIHEV00pQmzXjf+2YJNSAdUhS+3KVRJMQSBunLIBRDgFuL6SHf/TOw78ebfBhg9Jy/JT1vQREv1vdq6uVXVwJbxZkqEKoChJcbLOFCtvYZOaXe+HvrVAe6mIePBzH/PSIBP49svAOPLtTm+Qm2O3Vp+HUgTVFhfnHuBT1C6a4KQw8mwngliwj8hDqXvyMJI083DKcAVAa2yaDiqNu/au498er0RtP24WR447yLPltkXFEH0ZhP4eEEWeWXg/Pqy05dCO80cT1Pk1uTZi4Vb5hMP4lghEaA++Axt6ZZsI/6Y8axrSqjpaVOyiQDe+kSttgBOsoaLetuz4EW3wlWlSZ9kJ0+pI5m10pACTrEljYNJCsNiooQmoNIgyqbArpYc=
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