CDQXKHn+TuN8dW9P4WnUY3RQNH43tX/zrYBZbcBEPxN/+EiZyh2dfMN+qwnXyCpPhsFZAbJdtXf8HD9/xRJFZC/M9QDOPbY3Y+TZZRLEirsfhJvt8GglxixQYX0B4PIW4NhnfGdyyfgL1CDjhUsCmFAvuPUAoE+VBBCIB+KYr2XGWO0jE1IOsQa7CClyW80sMflyJ83BROjxqvtQPpiOA8LGqHx/ChODthVtR9qblBxuWzuNFLtixoB5lykjR9gRjYaSgwNiZsrLIFFHFBno0DI3c5n4iSSfAbHJM4BtISMZcZD8jLA7YEXiRa0/5aulrM+zgzWTPdP18ggohESvkmy9jthzijqboUC0CC8xOkcjMVLdkfHw0oBMZQ+HiiN8HXoe2m4+g7ttNt9UgWES5Dgllw5B+B4emjs9m+atA9uJsSpdEoARfEGOsTqH16nJ5QBT5o3uPvvcSIgzX/bvTSSG73zyAfcdypQIa9jM6b9r3YFQ83vffx3Fr0SqVjmeNcOB1hBH4s91Amiw6HAk4AD2asag5h2KzuqEqmI6hj/qv9T6V5DCoYclD/SZxX9Iq9kq+QnO8nbTM1FaDny6Fw5umzVuNFWo2QkWI/zaekmQB2RuZzxru34inC5J4YGaM3IlZsoz72HYRkRv7szVlsJP0VWZDANPi0nvDAot/XfiRyZwELf7B4SKi2fY3pMUrqG6OaWSsOc4r0kiA7zvVTmm01Bl7wZGehUtMFAZtHHb9LxBdAeIMnEB59Zx9WghPhT1669geTJCvGuUgYuB5c+IBxdfs1C7L85yYmAxD2fUZMKFHTN13TfQzHRIsjUvJm4zUbKeGS0JwvKemHgQ6J6GG2zsFl983j3R7KVIwNUP6jn9YEef//srKeRYtYFn0hz7ejP+KGyHVkIeS/06S9xL0Ir4fEGacpGlSrz52jj37xMtVOET9lr/zru5lA7XdxaTsK4Xsi8mkwQi5DMDU9oBxD52PKpvCwI/kHhF7EOzes5a1TJoCH0IAo28kzhlt8dlROFx39gA1Iw6oX9bd4cxn6a1j8vlG9MEDjB7osQH8PFDZNOvo/NrZoo7UyEby5JT+vAtvSNZIo9Tf25OSljbNZvV6dVq/BY5UmGWAzm5/7eEP9CBzER7R89h4bcuMU5gI3D865qJx6K1l384/JjFwQthsyNkQcs/wpfZcQGzo9rs4n+xZZ8LbZvusZvqRH2v+/LE8ZXEOvo9r+qLzqDb4Ttp6LL5/vZnYqjj5CMohDsO6QN4wMegz9/L4RDPfeYUA8Wmkwv+NqQhsv25FBb5sQnghxAxN479hlaNllDoHGJPZ5SLneK1WqNyVscvEtbIW+YHycugDCCCHtS+Zdgb1tH2DmEnFngUhjY=
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