SELECT cmp.competitorId, cmp.CompanyName, cmp.InternalContactId FROM tbl_CMP_Companies cmp WHERE cmp.ownerid = AND cmp.ownerType = and cmp.competitorId = ORDER by cmp.companyname ASC