WordPress カテゴリ以下の投稿を取得

カテゴリ以下の投稿取得時に実行されるSQL
cat=7 の場合
SELECT term_taxonomy_id
FROM wp_term_taxonomy
WHERE taxonomy = ‘category’
AND term_id IN (7)
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = ‘category’ AND t.term_id = 7 LIMIT 1
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (7) ) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10

Thank you for reading this post, don't forget to subscribe!