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 'ORDER BY bf.weight_volume' at line 1:<br>SELECT bf.box_id, bf.weight_volume, bl.box_name FROM box_by_farm bf LEFT JOIN box_lang bl USING (box_id) WHERE bf.farm_id = 103 AND bl.language_id = 1 AND bf.weight_volume >=  ORDER BY bf.weight_volume