select o.order_id, to_char(o.confirmed_date, 'YYYY-MM-DD') as confirmed_date, o.order_state, o.shipping_method, u.first_names, u.last_name, u.user_id from ec_orders_shippable o, cc_users u where o.user_id=u.user_id order by o.shipping_method, o.order_state, o.order_id