oLbyJqM+c7kDb+W61bWwMzhKDyYNBUhREKVf4L0VsqyNcF/7LfQNTTPRdaKRrbweFkiE8R+nHwfEgkPadEuQV0JfdsbjE9DOvlm5PWOUiU/VJoZMSQxdpk0rQMhhJti8OEIEyHveqDdXVZpD12I7+zEgd0c5cu9THNSYD/n7DWADPdv3j0yZ1LiHEygRGu8oAJmibXe6GwgZMNanBDNvDmuxcCHPrX3yCVVuQKZQ2gYI9HHT2AulqVxzTEZqlxhoOpIEyXj66st3yDCN6hnImVYWn3iENsWTCJ+lxr7tj1PWT7dlf9lrxtlV3ubHSFZEeCL1gzW3aG3vAn6LaRRVpFIPcSeibbWSuLJXhc6K1pdx7iD8EkbLmu/rpUE8yX+c8x3x8PRtbbs6dkt0w3XWasOUxTuhvjCFvKrogEI+gtQL875XbvZtgt5fdjd9u2cfQZojh4X38ZYBIB2NUTbqPkZ7PFFdqysWk8fq7P8rpKW8KBgdaP3l14piAqRcneKLKGXVtLbp5MXHBz4MswhJimf3VnbQw5gF0tiTd3Xu++gQXsP2a/o9jtVp/4ZI0+RVmJ47Pjg7OEnIcKpIcnMlTGFWiy7YuVtoZSLJf/IEdER4q2eXjfGAqO9hTi+fhZsKol9dz7CMBOXjm240kUZ1k4VX/M+K8EeF1morGdBJNzB0fM7LVHCQEKZJxDueGjvQSgpfaBteTlFfNHtbc5DRx78prBgY82XQ4q/1NzqAaHgwlb5zN+r/FfwboqXGFiESBGHNTPEJFYmH+NyMwk5e3T36usg+7oKZiYj/0M3Lvw0HvYAnNtmZj4is/GkzioAuaGiywB3Umq3HQT9jDt32YCXhhf2CMEhft4tWQWo8nn5hyADn037PbrhzqY6okjkdFwjyHzEDAEaAluiVOOB7rMSzP3vWViZruFI8k4rN6gP8/RNMpxgzuQDwif1DcCoZ+uL47CPWBpndx1r7ty01pDz2VgoHPph1QLc8g0m5TuOI3lTiT/kJf1IyWgoq2RMOPjHqz88M1Ilt2J/Ofkulmk8G5cKHZJjQrlfsD7VkaCDJI+4Q/zo1Dlvh2oU3jT4copGgT47UcaJqHCkc+SDGtXHfouoJsxbrV9Gy3sLAwq5nuqS6AjOLEPhyLsODlWrAOAZM66OGo3yXVxcoDCURlEe/8Usfoi1pVm9CJ7vLaOVAwYjQFhhy4dwXcTc5Br8SAAUTia9aLBj9cvId4dwJdkYNSVZFytVpP/TJ19D1/lzQYrEC+vh3+Nsr8rrxa5sTg/c85f3TN0xi5dJGTbwQe/I7ztvZh4pxtqrCw8m1E0ErRaZ7nnk/hnENPRUVePBN2Vqh9MTtHE3RfR3zlnhkieulUGR83EIkGuNYfUw=
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