Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

How can I retrieve posts under a category with plain SQL with out using WordPress native api's like get_pages?

My Wordpress table wp_terms contains a term named Restaurants.

I want to list the post comes under this term only.

Is the below query correct?

Am I correct on the JOIN parts?

SELECT p.ID AS postId, 
    p.post_name,
    p.post_title, 
    p.post_content,
    p.post_excerpt,
    p.post_status,
    p.post_type,
    p.post_author,
    p.guid,
    p.post_modified_gmt
FROM `wp_posts` AS p
LEFT JOIN `wp_term_relationships` AS tr ON p.ID = tr.object_id
LEFT JOIN  `wp_term_taxonomy` AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE post_type='place' AND post_status='publish' AND tt.term_id = 11
ORDER BY postId DESC
share|improve this question
    
What's the reason for "with out using WordPress native APIs" ? –  kaiser May 6 '13 at 10:55
    
are you not able to get your desired results from wordpress get_posts?? –  sven May 6 '13 at 16:09
    
Guys. I'm developing an api with .NET which pulls data from a WordPress database. And I don't want to use WordPress API or PHP –  Mithun P May 7 '13 at 6:06
    
Does your query work as expected? If not look over core.trac.wordpress.org/browser/tags/3.5.1/wp-includes/… for exact query construction and joins. –  soulseekah May 8 '13 at 8:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.