SELECT DISTINCT p.id, p.name, p.group FROM `Parameter` p
JOIN `ProductParameter` pp ON p.id = pp.parameterId WHERE `productId` IN
  (SELECT DISTINCT `productId` FROM `ProductHasCategory` WHERE `categoryId` IN
    (SELECT id FROM Category WHERE id = 11208 OR hierarchyString LIKE "%0011208%")
  )
ORDER BY `name`;