[cvele]

nvm.... reseno

SELECT orderid
 FROM `coustumers_products`
group by orderid
having count(distinct status)=1
and max(status)='COMPLETED'