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