delete from csDel
	--select csDel.*
	from tbl_PRD_CustomerSkus csDel
		inner join 
	(
	select distinct cs.customerid, cs.customerType, cs.skuid
	from tbl_PRD_CustomerSkus cs
		left outer join tbl_CDR_Distributors cdr on cdr.cdr_recordid = cs.customerid and customerType IN ('dst','pdst')
		left outer join tbl_PRD_Skus s on s.skuid = cs.skuid and cs.ownerid = s.ownerid and cs.fsl_tableCode = cs.fsl_tableCode
		left outer join tblManufacturers m on s.mfrid = m.mfr_id
	where cs.ownerid = 14
	and cs.fsl_tableCode = 'BRO'
	group by cs.customerid, cs.customerType, cs.skuid
	having count(*) > 1
	) as x on csDel.customerid = x.customerid
	and csDel.customerType = x.customerType
	and csDel.skuid = x.skuid
	where csDel.ownerid = 14
	and csDel.fsl_tableCode = 'BRO'