SELECT `e`.*, `at_product_id`.`product_id` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_product` AS `at_product_id` ON (at_product_id.`category_id`=e.entity_id) WHERE (at_product_id.product_id = '7302') AND (`e`.`path` LIKE '1/2/%') ORDER BY `e`.`level` DESC LIMIT 1