You can eventually add ID in $sql, then it will be easier to use get_permalink function in the foreach :
<?php
global $wpdb;
$sql = "SELECT ID, post_title, meta_value
FROM $wpdb->posts a
JOIN $wpdb->postmeta b ON a.ID = b.post_id
WHERE a.post_type="page"
AND a.post_status="publish"
AND b.meta_key = '_wp_page_template'
ORDER BY a.post_title ASC
";
$results = $wpdb->get_results( $sql );
if( !empty( $results ) ) {
echo '<ul>';
foreach ( $results as $result ) {
echo '<li><a href="'.get_permalink($result->ID).'">'. $result->post_title . ': ' . $result->meta_value. '</a></li>';}
echo '</ul>';
}
?>
Related Posts:
- Stop WordPress appending `-2` to the end of my url after i change it
- WordPress Permalinks not working in Apache2 Ubuntu 14.04
- Get current URL (permalink) without /page/{pagenum}/
- Removing Parent Page(s) from Permalink
- Removing the redirect after changing a page’s slug
- How to display a public profile page for registered users with custom slug?
- How does wordpress keep track of post id when post id is not used in permalinks?
- Permalink Issues by Installing WordPress in Subdirectory / Subfolder
- How to add query parameters to all internal links?
- How to make draft posts or posts in review accessible via full url / slug?
- nginx – permalinks with .php in url not working
- Social Media Links on homepage – within posts/post loop
- Nice RSS Feed URLs for each custom post type
- Custom rewrite rules for feeds of custom queries (query_var query strings in URL)?
- removed index.php now all pages 404
- Gutenberg Editor: dynamicaly change slug field with an ACF field
- Permalinks all messed up, I am helpless [closed]
- WordPress | Convert #038; to &
- Can’t get rewrite rules working
- permalink changed, now getting 404 for every pages
- How to write correct add_rewrite_rule in WordPress for more than one taxonomy in one rule?
- How to add category to the permalink and breadcrumb?
- Get permalink to page?
- Permalinks not working Apache + CentOS 7
- How can I link a file in admin with a button?
- Remove Dash/Hyphen From WordPress CustomPosttype Permalink
- Auto-create a pretty permalink for a bunch of posts
- How to show the homepage on a different url, like site.com/blog instead of site.com?
- Post incorrectly displaying as page
- wp_logout_url redirects to incorrect page because of pagination
- why does my url not update after migration?
- Dynamically create Permalinks for uploaded files?
- Get new WordPress slug from old wordpress slug
- Moved page (new parent) loads properly using obsolete URI. Why?
- Only default permalink is working mod_rewrite enabled
- Rewrite rule for a query string
- Custom Permalinks for Posts only
- How to add a variable as a tag base?
- Is it possible for a custom post type and sub pages of a page with the same slug as the custom post type to share a slug?
- Why is page/2/ not working?
- Removing leading zeros from custom permalink structure
- Integrating wordpress into existing site and setting up htaccess?
- Permalinks stopped working – NO update, mod_rewrite enabled, .htaccess not touched
- Add more structure tag to permalink?
- wp_publish_post to saved draft, permalinks broken
- display dynamic content based on url slug on custom page
- How to generate a list of all urls
- Default permalink changes
- Slugs Disappeared Leaving 404s – Quick way to repopulate?
- Path to Pages Resolves to Archive instead of Actual Content
- permalink %year% of pre-written posts to be published next year, in the mysterious future (*)
- Changing permalink name redirects to another template?
- Permalink slug no longer editable when using post_type_link filter
- add_query_vars and canonical links
- Changing the permlink and SEO
- whats the mistake → href=”get_permalink() [closed]
- Retrieve default permalink while using seo friendly URLs in WordPress
- How do I change the permalink structure without getting 404s?
- WordPress Permalinks problem
- How to get rid of an extra middle part my permalink
- optional parameter in permalink structure
- Get a link to paged() part?
- How Can I Use a Custom AccessFileName?
- xammp server permalink by postname not working
- Blogger To WordPress Permalink Redirection
- get_permalink() gives a certain page link only. how to solve this.?
- replacing post ID by custom post name in url
- Change type of permalinks on TinyMCE link dialogue
- What is the simplest way to create a redirect
- Problem with special character WordPress
- How to make different urls for some tags pages
- Change pemalink for one single post without redirect
- Strip subcategory base from URL
- How to change specific permalink in wordpress site?
- assets aren’t loading on a page but loads on others? slug permalink conflict?
- remove SLASH on single_post but KEEP on categories and parent pages
- Fire a code when permalinks updated
- Change Project permalink to custom URL
- Edit Post Permalink option removed, looking for possible causes
- Site Tagline ended up in permalink
- Got 404 error when changed siteurl via DB in WordPress
- Extra url paths as variable
- Permalinks don’t update nor link properly
- Prevent 301 when a trailing slash added
- Why I had to re-save permalink setting after moving my WordPress site to another hosting provider?
- Permalinks custom base to redirect to archive.php
- How to change URL of my pages?
- get_permalink to an anchor
- Add URL to selected post in meta box
- Converting WP Page to use full explicit paths?
- Add Custom Pagination Permalink
- Prevent guessing slug
- Pretty permalinks to work for lighttpd webserver?
- Pages included in another page and duplicate content issues for SEO
- WordPress archive posts returns user to homepage
- URL to an image in a post is changing when permalink is set to custom. Can I avoid this?
- How can i edit all posts slug in bulk keeping WP native redirect?
- Post/page without slug
- permalinks url with woocommerce
- Blog url disappears