select distinct attrValue from cms_categories a inner join cms_Store_TemplateSchemas b on a.catTemplateId = b.tSchemaAttrId inner join cms_Store_ProductAttributes c on b.tSchemaAttrId = c.attrId inner join cms_Store_ProductsAttributes d on b.tSchemaAttrId = d.attrId where attrTitle = rtrim(ltrim(' Ίντσες TV')) and len(attrValue)>0 AND itmID in ( SELECT distinct a.itmID from cms_ITems a LEFT JOIN cms_Store_ProductsAttributes b ON a.itmID=b.itmID where itmActiveFlag=1 and itmCategoryID=238 ) order by 1