select companyid from trncompanyprod_forsearch where companyprodid = '31267'189162