oracle8.1.6
and sysdate-o.confirmed_date <= 1
and sysdate-o.confirmed_date <= 7
and months_between(sysdate,o.confirmed_date) <= 1
and 1=1
select o.order_id, o.confirmed_date, o.order_state, ec_total_price(o.order_id) as price_to_display, o.user_id, u.first_names, u.last_name, count(*) as n_items
from ec_orders o, ec_items i, cc_users u
where o.order_id=i.order_id
and o.user_id(+)=u.user_id
$confirmed_query_bit
$order_state_query_bit
group by o.order_id, o.confirmed_date, o.order_state, ec_total_price(o.order_id), o.user_id, u.first_names, u.last_name
order by $order_by_clause