SQL queries for WordPress

README.md

Just a collection of SQL queries I find useful in WordPress management

custom_field_per_post_type.sql

SELECT P.ID, P.post_title, M.meta_key, M.meta_value
FROM wp_posts AS P
JOIN wp_postmeta AS M ON P.ID = M.post_id
AND M.meta_key = 'CUSTOM_FIELD'
WHERE P.post_type = 'products'
order by P.ID asc

pages_using_template.sql

SELECT P.ID, P.post_title, M.meta_key, M.meta_value
FROM wp_posts AS P
INNER JOIN wp_postmeta AS M ON M.post_id = P.ID
WHERE P.post_type = 'page' and P.post_status = 'publish' and M.meta_value = 'TEMPLATE_PATH/FILENAME.php'
ORDER BY post_title, meta_key

posts_using_post_type.sql

SELECT P.ID, P.post_title
FROM wp_posts AS P
WHERE P.post_type = 'products' and P.post_status = 'publish'
ORDER BY post_title