select distinct prodline_id, productLineCode + ' - ' + productLine as line, categoryId, catnum + ' - ' + category as category, prodId, product + ' - ' + shortDesc as product, skuId, sku + ' - ' + skuDesc as sku from tbl_DW_OperatorAnalyzer with (nolock) where ownerId = 1 and ownerType = 'MFR' order by line, category, product, sku