SELECT _VPW.MFG_SKU,
 _VPW.Location,
 cm.ProductCode,
 _VPW.TX,
 _VPW.OH,
 _VPW.Stock,
 p.CombinedStock AS Comb_DiscountedRecurringPrice_Level3,
 p.Name,
 p.Manufacturer,
 p.VendorCodes,
 p.Cost,
 p.SalePrice,
 -- EAN,
 -- UPC_code,
 p.Popularity,
 p.PricingType,
 p.Vertical,
 p.HasPhoto,
 p.DaysToShip

FROM _VPW
JOIN pins p
	ON _VPW.MFG_SKU = p.PIN
JOIN client_map cm
	ON _VPW.MFG_SKU = cm.PIN AND cm.Client = 'Volusion'

WHERE cm.Parent = 'FNLA'
AND _VPW.Stock > 0 -- In our stock
ORDER BY _VPW.MFG_SKU;