ojDU/Xg1fMgPq73tU9lmp3lmdzRvtwD94FfOhtLJzZMZ8RHgP5qlVxMasN3jcYOLV2BNsLnSJDO1UK5I4TYAITrcPBxkEvLKbmaFd6ikczG3NsyNQtsKe6wWW8NYHkK5+1yiAZWWi0ZRjRgyzuIBiaK8kmXu5J/2FWtpQLVMjdrZEUzfz/28v8MAYv9CyrWAVJeUGWST3H+jp+r7DsLf9qfz2cHa61LHkcuaKJWl82Lzl+hyk3ifvEpoaSWIxotU5K6E6nYPg2WV4XZYUOdIJDC6MgSmt658tIMPa+s24NwP4e3SbqXakGE8QFJvOmuRIUHiCkhBRDF5p1gTf7XmLXUhpnm/OtwYs9ysyBG9e59ASq4YBChIOGAQ/2XRJTMImDgXMC5Sv5/lIHZAc4j0lgSOwCpgSY8YEHspk5oZT51B3XOVFRd5Kh8ahGKMh91ke7F5ei/7EFAJIvrcl0oGWox8MEWYNujqokArla7NXPDiqmrA9Ne4WlucUbf26YeslFK9b4MX4+5GjppiYrGyoTD21+NKGf7ji7aa1Rb90VDT88yTCorPMyGKTsgPYButhFdNx9DememnVE/ZH4A1aU3nQp7yW9Tx4PPb+I/NI8UO75+FY1MGygP4HIMI/2XnR84fqVFOg6oBB4usxnp5X10Lb+kFYgPww+HgFHevLdZZn0ry8f37LmWrRty3M0it93LTuFJoDXS3jUUmIXmiASnrwlrXQyyRvkgTKmIprGyx+JznbX+V4w1dBC0QXwqdKf6byITuPrB7J588UB6BlA0b3PRjJpd+PJ/q0x5Mks3janQMJSO14pwCh+/6CYNjVrgeCgKMBWbEXdTFW/Uq8/XXQ+tc5BwHZor+0nEsbjhace8irDVMpKCwUxwLcp44lJ3Y34NakA1tCYQAHS9JOzJEeZVQsO5KKPK68vJWKeVNVMPfCl+pd99/UTA4dUZu1KXjtEAhCNowh2kAVLoSUgihipJaeEEaqF5DPXfTTZ4PwaJeE48vv+14nNWXdqZ52mI/mgxa58kd6v7xMtAjmR0Wx6Zi9TMj5KqJ/hMbI3wJ5/pbUrFm6Rboe/wsMuLR+/mlDtOtZ/HQS0Z254sxZAI5aqNS8eHCxSfSaRlr4KvxtMQqqF2VNaqVT5PVZtnmIA2cbecqk6E+kyzGsFkpnSX2ax9spDBZMbZyyxrvJkoXucl2tJqp5QsBkMAvJQl6BaO+KR+JG8VAxgEGMgDESr2uDpMR4xbgblQeYr7gmUC0phA8NvxIhPz6wZRS3RDlR8GJGaHIlcA1y7S+AOb8oqY89VynbULHu/oyQNU9d7eZiF6BFO38gnGKhW54x5FHAd+d3x9IjdGj/WV5xybxIQMDmz9mh+yWwvHK9JQ=
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