drop view if exists combined_orders_views;