select skuId, privateLabelType, opr_id, dst_id, prodId from tbl_PRD_SKus s where ownerId = #_mfrId# and fsl_tablecode = 'MFR' and exists(select * from tbl_OPR_CLientOperators opr where opr.operatorid = s.opr_ID and opr.territoryid IN (6303,6305,6304,6394,6395,6312,6313,6306,6310,6307,6315,6309,6311,6308,6512,6658,6808,6473,6783,6344,6372,6322,6339,6361,6319,6318,6347,6326,6328,6335,6357,6345,6373,6381,6320,6332,6351,6331,6337,6355,6350,6340,6382,6342,6359,6352,6330,6341,6338,6323,6343,6329,6321,6364,6334,6529,6314,6380,6353,6336,6317,6354,6363,6358,6383,6356,6325,6349,6316,6333,6324)) and s.privateLabelType = 'OPR' select operatorName, distributorName, privateLabelType, count(*) skuCount from qmd_skus group by operatorName, distributorName, privateLabelType select skuId, privateLabelType, opr_id, dst_id, prodId from tbl_PRD_SKus s left outer join tbl_OPR_CLientOperators opr ON (opr.operatorid = s.opr_ID) where s.ownerId = #_mfrId# and s.fsl_tablecode = 'MFR' and s.privateLabelType = 'OPR' and opr.territoryid IN (6303,6305,6304,6394,6395,6312,6313,6306,6310,6307,6315,6309,6311,6308,6512,6658,6808,6473,6783,6344,6372,6322,6339,6361,6319,6318,6347,6326,6328,6335,6357,6345,6373,6381,6320,6332,6351,6331,6337,6355,6350,6340,6382,6342,6359,6352,6330,6341,6338,6323,6343,6329,6321,6364,6334,6529,6314,6380,6353,6336,6317,6354,6363,6358,6383,6356,6325,6349,6316,6333,6324)