select subsubcategory_id from ec_subsubcategories where subcategory_id=:subcategory_id delete from ec_subsubcategory_product_map where subsubcategory_id in (select subsubcategory_id from ec_subsubcategories where subcategory_id=:subcategory_id) delete from ec_subsubcategories where subcategory_id=:subcategory_id delete from ec_subcategory_product_map where subcategory_id=:subcategory_id delete from ec_subcategories where subcategory_id=:subcategory_id