select package_id from apm_packages where package_key = 'ecommerce' select subcategory_id from ec_subcategories where category_id = :category_id and subcategory_id in ([join $subcategory_list ", "]) order by subcategory_name select category_name from ec_categories where category_id = :category_id select category_name from ec_categories where category_id = :category_id select subcategory_name from ec_subcategories where subcategory_id = :subcategory_id select subsubcategory_name from ec_subsubcategories where subcategory_id = :subcategory_id and subsubcategory_id in ([join $subsubcategory_list ","]) order by subsubcategory_name select product_name from ec_products where product_id = :product_id select subcategory_id from ec_subsubcategories where subsubcategory_id = :subsubcategory_id select category_id from ec_subcategories where subcategory_id = :subcategory_id select category_name from ec_categories where category_id = :category_id select subcategory_name from ec_subcategories where subcategory_id = :subcategory_id select subsubcategory_name from ec_subsubcategories where subsubcategory_id = :subsubcategory_id select category_id from ec_subcategories where subcategory_id = :subcategory_id select category_name from ec_categories where category_id = :category_id select subcategory_name from ec_subcategories where subcategory_id = :subcategory_id select category_name from ec_categories where category_id = :category_id select category_id from ec_category_product_map where product_id = :product_id select s.subcategory_id from ec_subcategory_product_map m, ec_subcategories s where m.subcategory_id = s.subcategory_id and s.category_id = :category_id and m.product_id = :product_id select ss.subsubcategory_id from ec_subsubcategory_product_map m, ec_subsubcategories ss where m.subsubcategory_id = ss.subsubcategory_id and ss.subcategory_id = :subcategory_id and m.product_id = :product_id select p.product_id, p.product_name from ec_products_displayable p, ec_product_links l where l.product_a = :product_id and l.product_b = p.product_id select publication, author_name, review_date, review from ec_product_reviews where product_id = :product_id and display_p = 't' select avg(rating) from ec_product_comments where product_id = :product_id and approved_p = 't' select count(*) from ec_product_comments where product_id = :product_id and (approved_p='t' [ec_decode [util_memoize {ad_parameter -package_id [ec_id] ProductCommentsNeedApprovalP ecommerce} [ec_cache_refresh]] "0" "or approved_p is null" ""]) select category_id, category_name from ec_categories order by sort_key select user_id as correct_user_id from ec_orders where order_id = :order_id select eco.confirmed_date, eco.creditcard_id, eco.shipping_method, u.email, eca.line1, eca.line2, eca.city, eca.usps_abbrev, eca.zip_code, eca.country_code, eca.full_state_name, eca.attn, eca.phone, eca.phone_time from ec_orders eco LEFT JOIN cc_users u on (eco.user_id = u.user_id) LEFT JOIN ec_addresses eca on (eco.shipping_address = eca.address_id) where eco.order_id = :order_id select i.price_name, i.price_charged, i.color_choice, i.size_choice, i.style_choice, p.product_name, p.one_line_description, p.product_id, count(*) as quantity from ec_items i, ec_products p where i.order_id = :order_id and i.product_id = p.product_id group by p.product_name, p.one_line_description, p.product_id, i.price_name, i.price_charged, i.color_choice, i.size_choice, i.style_choice select i.price_charged, i.price_name, i.color_choice, i.size_choice, i.style_choice, p.product_name, p.one_line_description, p.product_id, count(*) as quantity from ec_items i, ec_products p where i.order_id = :order_id and i.product_id = p.product_id group by p.product_name, p.one_line_description, p.product_id, i.price_charged, i.price_name, i.color_choice, i.size_choice, i.style_choice select i.price_charged, i.price_name, i.color_choice, i.size_choice, i.style_choice, p.product_name, p.one_line_description, p.product_id, count(*) as quantity from ec_items i, ec_products p where i.order_id = :order_id and i.product_id = p.product_id group by p.product_name, p.one_line_description, p.product_id, i.price_charged, i.price_name, i.color_choice, i.size_choice, i.style_choice select count(*) from $item_view where order_id = :order_id select o.order_id, o.confirmed_date, o.order_state from ec_orders o where o.user_id = :user_id order by o.order_id select * from ec_product_purchase_comb where product_id = :product_id select product_name from ec_products where product_id = :product_id select product_name from ec_products where product_id = :product_id select s.shipment_date, s.carrier, s.tracking_number, s.shipment_id, s.shippable_p, count(*) as n_items from ec_items i, ec_shipments s where i.order_id = :order_id and i.shipment_id = s.shipment_id and i.product_id = :product_id and i.color_choice [ec_decode $color_choice "" "is null" "= :color_choice"] and i.size_choice [ec_decode $size_choice "" "is null" "= :size_choice"] and i.style_choice [ec_decode $style_choice "" "is null" "= :style_choice"] and i.price_charged [ec_decode $price_charged "" "is null" "= :price_charged"] and i.price_name [ec_decode $price_name "" "is null" "= :price_name"] group by s.shipment_date, s.carrier, s.tracking_number, s.shipment_id, s.shippable_p select response_id, one_line, response_text from ec_canned_responses order by one_line select c.user_class_name, m.user_class_approved_p, c.user_class_id from ec_user_classes c, ec_user_class_user_map m where m.user_id = :user_id and m.user_class_id = c.user_class_id order by c.user_class_id update ec_user_sessions set user_id = :user_id where user_session_id = :user_session_id select state_name from us_states where abbrev =:usps_abbrev select name from country_names where iso=:country_code