カテゴリとタグで投稿をクエリする方法は？

Question

カテゴリとタグで投稿をクエリする方法は？

- 12
- 113043 2010-11-17
カテゴリXとタグYに関連する投稿のリストを表示しようとしています. 次のコードを試しました:

$args = array( 'posts_per_page' => 4, 'tag_id' => $tag_id, 'cat' => $cat_id, ); query_posts($args);

ただし、正しく機能せず、co \ ategory内のすべての投稿が返されます.

あなたが持っているかもしれない洞察を聞きたいです
I am trying to show a list of posts that are related to category X and tag Y. I've tried the following code:

$args = array( 'posts_per_page' => 4, 'tag_id' => $tag_id, 'cat' => $cat_id, ); query_posts($args);

but it doesn't work correctly and returns all the posts in the co\ategory.

Would love to hear any insight you might have
query-posts tags

- query_posts()では、カテゴリまたはタグしか使用できないと思います.よくわかりませんが、関数の使用は、これが正しく機能していることを意味するものに制限されている可能性がありますが、それはあなたがやりたいことをしません.
  
  I think with query_posts() you can only make use of category or tag. I'm not sure, but maybe the use of the function is limited to that which would mean that this is correctly working but it doesn't do what you want to do it.
  - 0
  - 2010-11-17
  - hakre

5 回答

投票

- 3
- 2010-12-04
これは他の場所でコメントされているWordPressのバグだと思います.IDではなくタグの名前を使用してみてください.そうすれば、機能するはずです:

$args = array( 'posts_per_page' => 3, 'tag' => 'review', 'cat' => 9, ); query_posts($args);

名前に複数の単語が含まれるタグがどうなるかわからないので、どうやって乗り込むか教えてください.
I think this is bug in WordPress that has been commented on elsewhere, try using the name of the tag rather than the ID then it should work:

$args = array( 'posts_per_page' => 3, 'tag' => 'review', 'cat' => 9, ); query_posts($args);

Let us know how you get on, not sure what happens with tags with multiple words in the name.

2

2014-06-08

この同じ問題に遭遇し、MySQLリクエストを行うことで解決しました.

要するに: get_post($ args)は、category=MyCategory またはtag=MyTagを持つ投稿を返します.

必要なのは、 OR を AND に変更することです.

私のロジックは、MySQLクエリを直接使用することでした:

クエリ1=カテゴリMyCatを持つすべての投稿を選択します
クエリ2=タグMyTagを持つすべての投稿を選択します
最後に:クエリ1とクエリ2にあるすべての投稿を選択します.

query_post();

の代わりに wpdb を使用しました

少しのコード (カテゴリMyCatとタグMyTagで公開された投稿を返します):

     $query_byTag="
            SELECT wp_posts.ID
            FROM wp_posts, wp_term_relationships, wp_terms
            WHERE wp_posts.ID = wp_term_relationships.object_id
            AND wp_terms.term_id = wp_term_relationships.term_taxonomy_id
            AND wp_terms.name = 'MyTag'";

    $query_byCat="
            SELECT wp_posts.ID
            FROM wp_posts, wp_term_relationships, wp_terms
            WHERE wp_posts.ID = wp_term_relationships.object_id
            AND wp_terms.term_id = wp_term_relationships.term_taxonomy_id
            AND wp_terms.name = 'MyCat'";

$query ="
            SELECT      wp_posts.post_title AS title , 
                        wp_posts.post_content AS content,
                        wp_posts.post_date AS blogdate 
            FROM wp_posts
            WHERE wp_posts.post_status = 'publish'
            AND wp_posts.ID IN (".$query_byTag.")
            AND wp_posts.ID IN (".$query_byCat.")
            ORDER BY wp_posts.post_date DESC ";

$result= $wpdb->get_results($query);

これは汚い方法ですが、お役に立てば幸いです=)

I stumbled into this same issue and resolved it by making a MySQL request .

in short : get_post($args) will return you posts who have the category=MyCategory OR the tag=MyTag.

what you want is to change your OR to AND .

my logic was to go straight with a MySQL Query:

Query 1 = Select all the posts who has the category MyCat
Query 2 = Select all the posts who has the tag MyTag
FinalLY : Select all the posts who are in Query 1 AND Query 2 .

I used wpdb instead of query_post();

A bit of code (returning published posts with category MyCat and tag MyTag ):

    $query_byTag="
            SELECT wp_posts.ID
            FROM wp_posts, wp_term_relationships, wp_terms
            WHERE wp_posts.ID = wp_term_relationships.object_id
            AND wp_terms.term_id = wp_term_relationships.term_taxonomy_id
            AND wp_terms.name = 'MyTag'";

    $query_byCat="
            SELECT wp_posts.ID
            FROM wp_posts, wp_term_relationships, wp_terms
            WHERE wp_posts.ID = wp_term_relationships.object_id
            AND wp_terms.term_id = wp_term_relationships.term_taxonomy_id
            AND wp_terms.name = 'MyCat'";

$query ="
            SELECT      wp_posts.post_title AS title , 
                        wp_posts.post_content AS content,
                        wp_posts.post_date AS blogdate 
            FROM wp_posts
            WHERE wp_posts.post_status = 'publish'
            AND wp_posts.ID IN (".$query_byTag.")
            AND wp_posts.ID IN (".$query_byCat.")
            ORDER BY wp_posts.post_date DESC ";

$result= $wpdb->get_results($query);

This is a dirty way to do it but I hope it helps =)

これは、[`WP_Query`と`tax_query` AND関係](http://codex.wordpress.org/Class_Reference/WP_Query#Taxonomy_Parameters)を使用すると、はるかに簡単に実行できます.生のSQLは必要ありません.

This is much more easily accomplished with [`WP_Query` and a `tax_query` AND relationship](http://codex.wordpress.org/Class_Reference/WP_Query#Taxonomy_Parameters), no need for raw SQL.
- 7
- 2014-06-08
- Milo
これを実現するためにWordPressで生のクエリを実行する必要はまったくありません.

There is absolutely no need to do raw queries in WordPress to achieve this.
- 0
- 2020-01-30
- Drmzindec

2

2016-03-11

このコードは機能します:

 $args = array(
    'tag' => get_queried_object()->slug, // If permalink like example.com/tag/example-tag, etc.
    'posts_per_page' => -1,
    'tax_query' => array( 
        array(
            'taxonomy' => 'category', // Taxonomy, in my case I need default post categories
            'field'    => 'slug',
            'terms'    => 'interior', // Your category slug (I have a category 'interior')
        ),
        ) 
); // Get all posts
$posts_new = get_posts( $args );

This code works:

$args = array(
    'tag' => get_queried_object()->slug, // If permalink like example.com/tag/example-tag, etc.
    'posts_per_page' => -1,
    'tax_query' => array( 
        array(
            'taxonomy' => 'category', // Taxonomy, in my case I need default post categories
            'field'    => 'slug',
            'terms'    => 'interior', // Your category slug (I have a category 'interior')
        ),
        ) 
); // Get all posts
$posts_new = get_posts( $args );

- -1
- 2016-03-15
SELECT wp_posts.post_name FROM wp_posts, wp_term_relationships, wp_terms, wp_term_taxonomy WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_terms.term_id = wp_term_taxonomy.term_id AND wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id AND wp_terms.name = "MY TAG"
SELECT wp_posts.post_name FROM wp_posts, wp_term_relationships, wp_terms, wp_term_taxonomy WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_terms.term_id = wp_term_taxonomy.term_id AND wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id AND wp_terms.name = "MY TAG"
- コードの回答のみが品質基準を満たすことはめったにありません.あなたの答えを編集し、これが元の問題をどのように解決するか、そしてそれをどのように/どこに実装するかについてのメモ/解説を含めてください.
  
  Code only answers rarely meet quality standards. Please edit your answer and include notes / commentary on how this solves the original issue along with how / where to implement it.
  - 2
  - 2016-03-15
  - Howdy_McGee
- これは、WP_Queryとtax_query AND関係を使用するとはるかに簡単に実行でき、生のSQLは必要ありません.
  
  This is much more easily accomplished with WP_Query and a tax_query AND relationship, no need for raw SQL.
  - 0
  - 2020-01-30
  - Drmzindec

Chris_O · Accepted Answer · 2010-12-03

19

2010-12-03

編集:カテゴリとタグの交差点をクエリする適切な方法については、以下を参照してください.

 global $wp_query;
        $args = array(
        'category__and' => 'category', //must use category id for this field
        'tag__in' => 'post_tag', //must use tag id for this field
        'posts_per_page' => -1); //get all posts

$posts = get_posts($args);
        foreach ($posts as $post) :
  //do stuff 
     endforeach;

Edit: See below for proper way to query category and tag intersections.

global $wp_query;
        $args = array(
        'category__and' => 'category', //must use category id for this field
        'tag__in' => 'post_tag', //must use tag id for this field
        'posts_per_page' => -1); //get all posts

$posts = get_posts($args);
        foreach ($posts as $post) :
  //do stuff 
     endforeach;