Sorry, kan database-query niet uitvoeren. 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 parent.lft' at line 1 in select distinct parent.menuID, parent.menutitle, parent.lft, parent.rgt, parent.pageID from menu as item, menu as parent, menu as type, menu as site where site.menutitle = 'IDGP' and type.lft > site.lft and type.lft < site.rgt and parent.lft > type.lft and parent.lft < type.rgt and item.lft between parent.lft and parent.rgt and item.menuID =  order by parent.lft