coderaaron · March 11, 2020 13:42
diff --git a/WP-pages_menu_order.sql b/WP-pages_menu_order.sql
 SELECT
 c.post_title,
 c.post_content
 FROM 
 wp_posts a,
 wp_postmeta b
 LEFT JOIN
 wp_posts c
 ON
 c.ID = b.meta_value
 WHERE
 a.post_type = 'nav_menu_item' AND
 b.meta_key = '_menu_item_object_id' AND
 a.ID = b.post_id
 ORDER BY
 a.menu_order
	SELECT
	c.post_title,
	c.post_content
	FROM
	wp_posts a,
	wp_postmeta b
	LEFT JOIN
	wp_posts c
	ON
	c.ID = b.meta_value
	WHERE
	a.post_type = 'nav_menu_item' AND
	b.meta_key = '_menu_item_object_id' AND
	a.ID = b.post_id
	ORDER BY
	a.menu_order