select mfr_id as ownerId, 'MFR' as ownerType, tpartnerId as operatorId, sum( forecast_qty ) as totalCases from tbl_MFR_TPF_Detail where tpartnerType= 'OPR' and forecast_status = 'C' and mfr_id = 26 group by mfr_id, tpartnerId order by totalCases desc