Unable to run query: SELECT 0 AS ID, var.Message AS Name FROM variants var WHERE var.ID = '12' UNION SELECT vvs.ID, CASE WHEN (vvs.Inc_Price = 0) THEN vvs.Name ELSE CONCAT(vvs.Name,' +(', TRUNCATE(FLOOR((((vvs.Inc_Price / 1.175) * (1 + (v.VAT / 100))) * 100) + 0.05) / 100, 2), ')') END AS Name FROM variant_values_simple vvs, vat v WHERE vvs.VARIANT_ID = '12' AND vvs.PRODUCT_ID = '58446' AND vvs.DELETED = 0 AND vvs.ACTIVE = 1 ORDER BY vvs.ID ASC Unknown column 'vvs.ID' in 'order clause'