SELECT `sub_cat`.* FROM `ntl_product_categories` AS `sub_cat` LEFT JOIN `ntl_product_categories` AS `parent` ON `sub_cat`.`parent` = `parent`.`id` WHERE `sub_cat`.`active` = 1 AND `parent`.`slug` = 'snares' AND `sub_cat`.`us` = 1 Natal Drums

Products.