WITH RECURSIVE BlockedBrands AS ( SELECT c.category_id FROM #__hikashop_category c WHERE CONCAT(",",c.restrict_by_country,",") LIKE "%,56,%" AND c.category_id NOT IN () UNION ALL SELECT c.category_id FROM BlockedBrands JOIN #__hikashop_category c ON BlockedBrands.category_id = c.category_parent_id ) SELECT * FROM BlockedBrands