SELECT od.orderdetailid, o.orderid, od.Productnote, od.qtyonhold, cm.Productcode, cm.Parent, p.Cost AS 'Parent Cost'
FROM custopayted.orderdetails od
JOIN custopayted.orders o ON o.orderid = od.orderid
JOIN products.client_map cm ON cm.Productcode = od.Productcode AND cm.Client = 'Volusion'
JOIN products.pins p ON p.PIN = cm.PIN
WHERE (cm.Parent != '' AND cm.Parent != 'FNLA')
AND (o.orderstatus <> 'Cancelled')
AND od.qtyonhold > 0
AND (p.Manufacturer REGEXP 'dewalt|briggs_stratton' OR p.Vendorcodes LIKE '%PWD%' OR p.Vendorcodes LIKE '%DWB%')
AND od.Productnote LIKE 'NOO%'