const search = query.create({ type: query.Type.CUSTOMER });
  const itemPricing = search.autoJoin({ fieldId: 'itempricing' });
  const item = itemPricing.joinTo({ fieldId: 'item', target: 'item' });
  const integrationItem = item.joinFrom({
    fieldId: 'custrecord_mos_wi_item',
    source: 'customrecord_mos_wi_integration_item',
  });

  search.columns = [
    integrationItem.createColumn({ fieldId: 'custrecord_mos_wi_external_id' }),
    itemPricing.createColumn({ fieldId: 'price' }),
  ];

  search.condition = search.and(
    search.createCondition({
      fieldId: 'id',
      operator: query.Operator.EQUAL,
      values: customerId,
    }),
    integrationItem.createCondition({
      fieldId: 'custrecord_mos_wi_integration',
      operator: query.Operator.ANY_OF,
      values: integrationId,
    })
  );
  
  search.run().results.forEach(result => console.log(result.values));