This query will bring back all data associated with the custom post type “products”:
1 2 3 4 5 | 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 = 'products' and P.post_status = 'publish' ORDER BY post_title, meta_key |
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.