An Error Was Encountered

Error Number: 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 'group by o.option_name order by o.order_by,po.upcharge ASC' at line 20

SELECT po.*,o.option_name,o.html_name,ov.option_value,ot.option_type_name FROM ProductOptions po INNER JOIN OptionValues ov ON ov.option_value_id = po.option_value_id INNER JOIN Options o ON o.option_id = ov.option_id INNER JOIN OptionTypes ot ON ot.option_type_id = o.option_type_id WHERE po.ItemID = group by o.option_name order by o.order_by,po.upcharge ASC