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