oracle 8.1.6 select site_node.url(s.node_id) from site_nodes s, apm_packages a where s.object_id = a.package_id and a.package_key = 'ecommerce' select site_node.url(s.node_id) from site_nodes s, apm_packages a where s.object_id = a.package_id and a.package_key = '$package_key' select c.one_line_summary, c.rating, c.user_comment, to_char(c.last_modified,'Day Month DD, YYYY') as last_modified_pretty, u.email, u.user_id from ec_product_comments c, cc_users u where c.user_id = u.user_id and c.product_id = :product_id $end_of_comment_query select category_id, subcategory_id, subsubcategory_id, product_id from ($common_sql) as dummy where rownum < 2 select decode(sign(sysdate-available_date),1,1,null,1,0) as available_p, color_list, size_list, style_list, no_shipping_avail_p from ec_products where product_id = :product_id select to_char(available_date,'Month DD, YYYY') available_date from ec_products where product_id = :product_id select eco.confirmed_date, eco.creditcard_id, eco.shipping_method, u.email, eco.shipping_address as shipping_address_id, ecc.billing_address as billing_address_id from ec_orders eco, cc_users u, ec_creditcards ecc where eco.order_id = :order_id and eco.user_id = u.user_id(+) and eco.creditcard_id = ecc.creditcard_id(+) insert into ec_user_sessions (user_session_id, ip_address, start_time, http_user_agent) values (:user_session_id, :ip_address, sysdate, :http_user_agent) select min(decode(ucp.price,null,p.price, decode(sign(ucp.price-p.price),1,p.price,ucp.price))) as regular_price, ucp.user_class_name from ec_products p, (select * from (select uc.product_id, uc.price, c.user_class_name from ec_product_user_class_prices uc, ec_user_classes c, ec_user_class_user_map m where uc.user_class_id = c.user_class_id and uc.product_id = :product_id and uc.user_class_id = m.user_class_id and m.user_id = :user_id and m.user_class_approved_p = 't' order by uc.price) where rownum=1) ucp where p.product_id = :product_id and ucp.product_id(+)=p.product_id group by p.product_id, p.price, ucp.user_class_name, ucp.price select min(decode(ucp.price,null,p.price, decode(sign(ucp.price-p.price),1,p.price,ucp.price))) as regular_price, ucp.user_class_name from ec_products p, (select * from (select uc.product_id, uc.price, c.user_class_name from ec_product_user_class_prices uc, ec_user_classes c, ec_user_class_user_map m where uc.user_class_id = c.user_class_id and uc.product_id = :product_id and uc.user_class_id = m.user_class_id and m.user_id = :user_id and (m.user_class_approved_p is null or m.user_class_approved_p = 't') order by uc.price) where rownum=1) ucp where p.product_id = :product_id and ucp.product_id(+)=p.product_id group by p.product_id, p.price, ucp.user_class_name, ucp.price