select * from assign_customer where delete_status !='1' and company_id =''