January 2009
1 post
3 tags
Wordpress: getting all posts from a specific...
I wanted to grab all posts from a certain category with a single non-wp-php script and I wrote the following mysql statement to accomplish this task:
SELECT wp_posts.post_title, wp_posts.post_date, wp_posts.post_content, wp_posts.guid
FROM wp_posts WHERE wp_posts.post_type='post'
AND wp_posts.post_status='publish'
AND (
SELECT wp_term_relationships.object_id
FROM wp_term_relationships
...