select revoked from tbl_PRD_DataProviders with (nolock) where ownerId = and ownerType = and dataownerID = and dataOwnerType = 'MFR' select Alias from tbl_IMPORT_Aliases with (nolock) where ownerId = and ownerType = and objectId = and objectType = 'MFRID' select gs1_syncEnabled from tblManufacturers with (nolock) where mfr_id =