#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'prod.liquorCategoryID = 9 GROUP BY prod.category1ID, prod.liquorBrandID LIMIT 0' at line 5

SELECT brand.name, ROUND( (prod.pricePerSku / ( prod.litresPerBottle * prod.bottlePerSku)) , 2) AS pricePerLitre
FROM WireDen_liquorProduct AS prod, WireDen_liquorBrand AS brand
WHERE prod.liquorBrandID = brand.liquorBrandID
AND (prod.pricePerSku / ( prod.litresPerBottle * prod.bottlePerSku)) = MAX((prod.pricePerSku / ( prod.litresPerBottle * prod.bottlePerSku)) )
prod.liquorCategoryID = 9
GROUP BY prod.category1ID, prod.liquorBrandID;