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