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 :category_match = lower(subsubcategory_name) 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 :category_match = lower(subcategory_name) select category_id, category_name from ec_categories where :category_match = lower(category_name)