How can I get the list of all pages URLs including their shortlink IDs?

You can get this from the guid column in the posts table of your database.

List of guids from database, eg http://wordpress.test/?p=1

Related Posts:

  1. Is it possible to get a page link from its slug?
  2. Need help with add_rewrite_rule
  3. After server migration only the homepage works
  4. remove “index.php” from permalinks
  5. where is permalink info stored in database?
  6. Changing permalinks gives me 404 errors on nginx
  7. How do I add /blog/ as a prefix to permalink structure for blog posts, tag pages, etc.?
  8. Change media item permalink
  9. Get Permalink without domain (i.e. get relative permalink) [duplicate]
  10. How does WordPress create URLs that Apache knows about?
  11. Strange permalink issue: can’t rename /company-2/ to /company/
  12. Passing and retrieving query vars in wordpress
  13. Get the current page URL (including pagination)
  14. Stop WordPress appending `-2` to the end of my url after i change it
  15. Get default permalink structure from pretty URL’s
  16. How to get permalink and title from post ID?
  17. Why is “/page/2/” not working?
  18. WordPress Permalinks not working in Apache2 Ubuntu 14.04
  19. Performance of my permalink structure?
  20. Permalink format: singular or plural
  21. What is the difference between get_post_permalink and get_permalink?
  22. WordPress matching URLs with trailing tildes
  23. Get current URL (permalink) without /page/{pagenum}/
  24. How does WordPress handle permalinks?
  25. Pretty permalinks for search results with extra query var
  26. Get page permalink without wpurl
  27. How can I get the privacy policy page?
  28. Can I use REST-API on plain permalink format?
  29. WordPress slug issue with non-latin characters
  30. Rewrite Rule for Multilingual Website, Like qTranslate?
  31. How to get pretty URLs with add_query_arg in permalinks
  32. What is the best permalink structure for SEO?
  33. Change author permalink
  34. Creating custom permalink structure for languages
  35. Hide permalink and preview button and link on custom post
  36. Custom post type permalink endpoint
  37. How can I make Capital letter ( upper-case ) permalinks?
  38. How can I reverse engineer a Permalink to Find the Page?
  39. Mapping Domains to Permalinks (not multisite)
  40. How to remove dates from existing permalinks?
  41. How do I set a custom base URL for standard posts?
  42. Removing Parent Page(s) from Permalink
  43. Why permalinks work with /index.php/%postname% but not with just %postname%?
  44. Setting up WordPress with Custom Permalinks and no .htaccess File?
  45. Getting the Site URL Including the Front Base
  46. Does WordPress Change the .htaccess File When Updating?
  47. Using $_GET variables in the URL?
  48. Removing the redirect after changing a page’s slug
  49. How to display a public profile page for registered users with custom slug?
  50. Removing leading zeros from custom permalink structure
  51. Must slugs be unique?
  52. Setting 404 page in Nginx
  53. How to get the clean permalink in a draft?
  54. How to use relative links on my pages?
  55. How does wordpress keep track of post id when post id is not used in permalinks?
  56. How to filter to output of the get_permalink() function
  57. Stop WordPress from reserving slugs for media items?
  58. Including category-base in a post permalink results in 404
  59. How to change ‘with_front” key from an existing custom post type?
  60. Change slug on post creation
  61. Does WordPress automatically do 301 redirect if I change permalink
  62. How can I store page ID in a post instead of other selected permalink?
  63. WordPress Permalink changes to question mark (?) in URL
  64. WordPress thinks my custom route is a 404
  65. Prevent WordPress from abbreviating-long-slugs…-in-the-admin
  66. Adding another word in front of post url
  67. Permalink with sub-sub-category and post name
  68. Post type child of another post type
  69. Permalink not working for page without title
  70. Remove index.php in permalink structure on IIS server
  71. What is the difference between get_permalink vs get_the_permalink?
  72. Page begins with number, WordPress adds 2
  73. Move WordPress to subdirectory, keep ALL URLs
  74. How would I create a different permalink structure for pages and posts?
  75. My permalinks are broken! Can I use mod_rewrite to ignore a physical file?
  76. Custom Taxonomy in Permalink of Post
  77. Is the permalink structure /%post_id%/%postname% faster or slower than just /%postname%?
  78. WooCommerce return 404 on category pages
  79. How to prevent apostrophes and quotes from appearing in permalinks?
  80. Minimal custom permalink structure
  81. the_permalink displays post ID URL for future posts
  82. Why does `get_permalink()` produces an add. DB request without $post->filter?
  83. WordPress 4.4+ breaks Walker Extension
  84. permalink independent on the post’s name stored in the database
  85. Date based URLs for custom posts and pagination
  86. Archive permalinks
  87. Regex in add_rewrite_tag not accepting OR operators?
  88. Removing hierarchical pages in the permalink
  89. How to add a custom URL placeholder to author archives?
  90. 301 Redirects for Changed Permalink Structure & Category Base
  91. Is there a user-facing interface to edit an attachment’s permalink?
  92. How to custom change author base without $this->front?
  93. Permalinks to Custom does not work (out of box)
  94. URL rewrite based on a custom field value
  95. Change permalinks structure for specific category
  96. Can WordPress realistically handle a site with 500 ‘pages’?
  97. ‘post_type_link’ filter not working
  98. Post titles not letting me use 2 consecutive dashes in permalink
  99. Why don’t WordPress post slugs allow accents?
  100. Update URL Snippet to Canonical Permalink URL
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)