A Database Error Occurred

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 'ORDER BY a.sortorder ASC' at line 12

SELECT a.`pages_id` AS `id`, a.`pages_id` AS `page_id`, a.`link`, IF(a.`type`='alias',b.title,a.`title`) AS title FROM `pages` a LEFT JOIN pages b ON a.alias_id=b.pages_id WHERE a.`parent_id`= ORDER BY a.sortorder ASC