q2.sql

; Wordpress : list wp_post entiries tagged with "thrudb"
;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* 
FROM wp_posts  
INNER JOIN wp_term_relationships 
    ON (wp_posts.ID = wp_term_relationships.object_id) 
INNER JOIN wp_term_taxonomy 
    ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) 
INNER JOIN wp_terms 
    ON (wp_term_taxonomy.term_id = wp_terms.term_id)  
WHERE 1=1  
    AND wp_term_taxonomy.taxonomy = 'post_tag'  
    AND wp_terms.slug IN ('thrudb')  
    AND wp_posts.post_type = 'post' 
    AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10