INSERT INTO inputcosts (InputID, Cost, ValidFromDate)         
SELECT inputs.InputID, Cost, CURDATE() 
FROM inputs   
LEFT JOIN inputtypes ON inputs.InputTypeID=inputtypes.InputTypeID 
 WHERE ifnull(inputtypes.IsCoffee,0)<>0 
        
UPDATE recipes SET SellPriceGP=60

