select subsubcategory_id from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=:category_id) select subcategory_id from ec_subcategories where category_id=:category_id delete from ec_subsubcategory_product_map where subsubcategory_id in (select subsubcategory_id from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=:category_id)) delete from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=:category_id) delete from ec_subcategory_product_map where subcategory_id in (select subcategory_id from ec_subcategories where category_id=:category_id) delete from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=:category_id) delete from ec_category_product_map where category_id=:category_id delete from ec_category_template_map where category_id=:category_id delete from ec_user_session_info where category_id=:category_id delete from ec_categories where category_id=:category_id