Bu yazıda sizlere WordPress veri tabanında publish ve post tipindeki yazılarınızı (yani yayımlanmış gönderilerinizi) listeleyen SQL sorgusunu paylaşmak istiyorum.
SELECT post_title, post_status, post_date, wp_term_taxonomy.taxonomy
FROM wp_posts
INNER JOIN wp_term_relationships
ON wp_term_relationships.object_id = wp_posts.ID
INNER JOIN wp_term_taxonomy
ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
WHERE 1=1
AND wp_posts.post_status = 'publish'
AND wp_posts.post_type = 'post'
AND wp_posts.post_name NOT LIKE '%revision%'
AND wp_posts.post_name NOT LIKE '%autosave%'
ORDER BY post_title ASC;