Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@coderaaron
Created February 20, 2018 20:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save coderaaron/a336c83cecc2df7810b417316bafa40d to your computer and use it in GitHub Desktop.
Save coderaaron/a336c83cecc2df7810b417316bafa40d to your computer and use it in GitHub Desktop.
Get WordPres pages from database in menu order
SELECT
a.post_title title,
a.post_content content
FROM
(SELECT
m.post_title,
m.post_content,
m.ID,
m.post_parent,
m.menu_order as self_order,
p.menu_order as parent_order,
g.menu_order as gp_order,
case
WHEN m.post_parent = 0 THEN m.menu_order * 100
ELSE case
when g.menu_order is null then m.menu_order * 10 + p.menu_order * 100
else m.menu_order + p.menu_order * 10 + g.menu_order* 100
end
END AS parentId
FROM
wp_posts m
LEFT JOIN wp_posts p
ON m.post_parent = p.ID
left join wp_posts g
on p.post_parent = g.ID
where m.post_type = 'page' and m.post_status = 'publish'
ORDER BY parentId) a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment