select product_id from ec_products where sku = :sku select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name from ec_subsubcategories ss, ec_subcategories s, ec_categories c where c.category_id = s.category_id and s.subcategory_id = ss.subcategory_id and :subsubcategory = subsubcategory_id select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name from ec_subcategories s, ec_categories c where c.category_id = s.category_id and :subcategory = subcategory_id select category_id, category_name from ec_categories where :category = category_id