select mfrid from tbl_prd_skus where ownerid = and fsl_tablecode = and skuid = select planningMethod, unitOfMeasurePlural from tblManufacturers where mfr_id =