U6853u5cjg5gPtAhIcR9dBghWuP/NLDMPo1I7PbSVKDVsinaDsE6SV1iR92ZAJ87p0v0nHqGjBJLitGVh0IbN1c3dXcX5nggX4W5d5FckJGNf9+RzlznkjeHN4z1GRmvNZCnQOjU10hzQ6eonE1HlyPiiV0zvhKj55BqMIEV2kYutK2hwW/XhhALJDaxCKzPRa8pzsDBrpqHtJeJuo6vJH1Zs7N9PYA2sGLec9P/2hVyP2Xsp4CH7uZHBlZVYus1smNYoy2ijjmEfAVhpiM76Xz8kDDu2gRIvLUW4WZJjd6Qt1CoTzmgR43o6PRRi/oPpRkCieq2YDNAqQw3MsklkV9VN00OXmooXhSVavv2zC8KdBtm3CHaDb+X5zLU+NnF8wjb9mJySI84n3P4niZwaZhL2rM3v5ilyDbLzSqLsWAm9wp+JrejLL/KJSjzXN02YYdBwEYv+1KI2qFkM2nmvC8YM3rwiT6nBuxFDJ5YSqpSZWjg67OuwWEqloA8QAhKl9O+N7rw8EojcALqxq9bnvH/OrHS63uhbLwifGLnPh4ONqSEezgeS27NU1C1UUXloKsTPa4xWDLsThtSGPgUrtLkuIo03hcpPo9TBRjhpofNcECojDy5lciaA5pnWBarlP3khjPqXA5R2aNiU79qHvlpaT5b1d2fCrSSG/KTULpjyKRUp7GmUz4zqAjPjgLjgQlVxAay/WXhqTm3PSM6HjkjMc4iexsV9YY2IIQl/9otmLHKDUw3/VeFhVTDLCb2T/fFHrfrd2an1fLEv5NqbgGda25SKMaU1+K4pE7UwSFQVIvNVJZjUw3gVlxTNkIcS+B3RpFwfOrBUd3hOV9fi5dN4I2rjkZBMGmQMvarvG44Z4HYAGWTPzEDgP74AUR/dvj2+D6XU4ElE48UXf4rE7W9d+hZzvXEtc/iEp7CbLgkm/MIZaEyHSGjncI84FnjaKr2KBsxbLyezP6gvprkeyeDtCPuA9NvtBZ+ZHVeRHFbYvZW3Dtpr4yVKlfhQqIRUK+306VLJgKTLsKT3MmSJRJux5/Q2xRtbm9caDbyeNofPrsTjbz/cXPCoc9t7MoIgR1uKfydaJfQJ7e16tGqogzCi/NUnRqU+2w+J+QL9LtW0Q8ECvGoE5EbYndYr2EQCgUirSjPhFIcIfrkRh5xhjKLGj7ftlTdjBd3H+PnEs6bRE9ZrKHS48swdog8IRblophuKn/2Yu4IAIk+WaGEo4BYff25L1/taslFWMe18D34Jyezfy9elMsLutiNV9b62up0hfDJK0mFAox2fPuxMQ93Nw9LHt7VOCPrKvDojCMRSrbaFkn48MMQR11uaMK4ND1p3TJZaNdAhBMPJ1g7JeryCRjO8mAG8MPljAg=
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