Error::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 'AS Name, tooltiplocstring. AS Tooltip, NULL AS Childs FROM locstring RIGHT OUTE' at line 1
SELECT menu.ParentId, menu.Id, menu.ParentUrlName, menu.UrlName, menu.Include, locstring. AS Name, tooltiplocstring. AS Tooltip, NULL AS Childs FROM locstring RIGHT OUTER JOIN (SELECT menu.Id, menu.ParentId, parentmenu.SortOrder AS ParentSortOrder, parentmenu.UrlName AS ParentUrlName, menu.SortOrder, menu.UrlName, menu.LocString, menu.TooltipLocString, menu.Include, menu.AdminOnly FROM menu INNER JOIN menu AS parentmenu ON menu.ParentId = parentmenu.Id WHERE menu.AdminOnly = False UNION SELECT menu.Id, NULL, menu.SortOrder AS ParentSortOrder, 0, NULL, menu.UrlName, menu.LocString, menu.TooltipLocString, menu.Include, menu.AdminOnly FROM menu WHERE menu.ParentId IS NULL AND menu.AdminOnly = False) as menu LEFT OUTER JOIN locstring AS tooltiplocstring ON menu.TooltipLocString = tooltiplocstring.LocString ON locstring.LocString = menu.LocString ORDER By menu.ParentSortOrder ASC, menu.SortOrder ASC