REPLACE INTO goods (UID, Name, Firm, Type, Status, Barcode, Quantity, PriceIn, PriceOut, Comments, Provider, Disabled) VALUES (

SELECT UID, Name, Firm, Type, Status, Barcode,

(
  (SELECT SUM(invoice_content.Quantity) FROM invoice_content WHERE Goods = g1.UID AND Invoice IS NOT NULL AND Invoice >  0 )
- (SELECT Count( 1 ) FROM sale_order WHERE Goods = g1.UID AND Receipt IN (SELECT ID FROM receipt where Moneyback IS NULL))
+ (SELECT Count( 1 ) FROM sale_order WHERE Goods = g1.UID AND Receipt IN (SELECT ID FROM receipt where Moneyback =  0 ))
)

, PriceIn, PriceOut, Comments, Provider, Disabled 
 FROM goods as g1 WHERE PriceIn > 0  

)