Skip to main content
5 events
when toggle format what by license comment
Apr 13, 2017 at 12:37 history edited CommunityBot
replaced http://wordpress.stackexchange.com/ with https://wordpress.stackexchange.com/
May 18, 2015 at 12:03 comment added Nicolai Grossherr My pleasure! Sure SQL is a way too. Just as a general tip, when available and suitable use WordPress API functions, it makes WP development easier in the long run. I said my piece :) @EvilDr
May 18, 2015 at 11:54 vote accept EvilDr
May 18, 2015 at 11:53 comment added EvilDr Great, thanks. As my strengths lie in database land rather than PHP, I used the following SQL code to provide a similar output, which can be tweaked later with counts, etc SELECT p.post_title as PostTitle, m.meta_value as Template FROM `wp_postmeta` as m join `wp_posts` as p ON p.ID = m.post_id where ((p.post_type = 'page') OR (p.post_type = 'post')) AND (m.meta_key = '_wp_page_template');. Your input was invaluable to pointing out where the correct database fields were.
May 18, 2015 at 10:38 history answered Nicolai Grossherr CC BY-SA 3.0