混合OR AND分类法查询

Question

我创建了一个类似的WP Query参数列表，希望它能选择所有具有第2项的帖子，然后从结果中选择所有其他具有OR关系的帖子。

$similar_properties_args = array(
'post_type' => 'property',
'posts_per_page' => '10',
'post__not_in' => array(get_post_ID() ),
'post_parent__not_in' => array(get_post_ID() ),   

'tax_query' => array(
'relation' => 'AND',
array(
'taxonomy' => 'language',
'terms' => '2'
),
array (
'relation' => 'OR',
array(
array(
'taxonomy' => 'property-feature',
'field' => 'id',
'terms' => array(1954,1958,1966,1970,1972)
),
array(
'taxonomy' => 'property-city',
'field' => 'id',
'terms' => array(145)
),
array(
'taxonomy' => 'property-status',
'field' => 'id',
'terms' => array(38)
),
array(
'taxonomy' => 'property-type',
'field' => 'id',
'terms' => array(21)
)

)
)       
)
);

实际创建的WP-mysql查询如下：

SELECT SQL_CALC_FOUND_ROWS  agn_posts.ID FROM agn_posts  LEFT JOIN agn_term_relationships ON (agn_posts.ID = agn_term_relationships.object_id)  LEFT JOIN agn_term_relationships AS tt1 ON (agn_posts.ID = tt1.object_id)  LEFT JOIN agn_term_relationships AS tt2 ON (agn_posts.ID = tt2.object_id)  LEFT JOIN agn_term_relationships AS tt3 ON (agn_posts.ID = tt3.object_id)  LEFT JOIN agn_term_relationships AS tt4 ON (agn_posts.ID = tt4.object_id) WHERE 1=1  AND agn_posts.ID NOT IN (1440) AND agn_posts.post_parent NOT IN (1440) AND ( 
agn_term_relationships.term_taxonomy_id IN (2) 
AND 
( 
( 
tt1.term_taxonomy_id IN (1954,1958,1966,1970,1972) 
AND 
tt2.term_taxonomy_id IN (145) 
AND 
tt3.term_taxonomy_id IN (38) 
AND 
tt4.term_taxonomy_id IN (21)
)
)
) AND agn_posts.post_type = 'property' AND (agn_posts.post_status = 'publish' OR agn_posts.post_status = 'private') GROUP BY agn_posts.ID ORDER BY agn_posts.post_date DESC LIMIT 0, 10

它并没有给我所需要的结果。

如果我将tt1项关系改为OR，那么结果是好的。

tt1.term_taxonomy_id IN (1954,1958,1966,1970,1972) 
OR  //from AND to OR
tt2.term_taxonomy_id IN (145) 
OR //from AND to OR
tt3.term_taxonomy_id IN (38) 
OR //from AND to OR
tt4.term_taxonomy_id IN (21)

问题是，从我的肉眼来看，上面的参数列表对于创建我要查找的查询是有效的，但不知何故缺少了一些东西。也许你可以看到，我的代码中的问题在哪里？

Answer 1

您不应该在数组中嵌套四个数组/子句：

'tax_query' => array(
'relation' => 'AND', // for clauses 1 and 2
array( // clause 1
'taxonomy' => 'language',
'terms'    => '2',
),
array( // clause 2
'relation' => 'OR', // for sub-clause 1..
// you shouldn't nest the sub-sub-clauses
array( // sub-clause 1
array( // sub-sub-clause 1
'taxonomy' => 'property-feature',
...
),
array( // sub-sub-clause 2
'taxonomy' => 'property-city',
...
),
array( // sub-sub-clause 3
'taxonomy' => 'property-status',
...
),
array( // sub-sub-clause 4
'taxonomy' => 'property-type',
...
),
),
),
),

相反，将阵列设置为与relation:相同的级别

'tax_query' => array(
'relation' => 'AND', // for clauses 1 and 2
array( // clause 1
'taxonomy' => 'language',
'terms'    => '2',
),
array( // clause 2
'relation' => 'OR', // for the sub-clauses 1, 2, 3 and 4
// instead of nesting, do like so:
array( // sub-clause 1
'taxonomy' => 'property-feature',
'terms'    => array( 1954, 1958, 1966, 1970, 1972 ),
),
array( // sub-clause 2
'taxonomy' => 'property-city',
'terms'    => array( 145 ),
),
array( // sub-clause 3
'taxonomy' => 'property-status',
'terms'    => array( 38 ),
),
array( // sub-clause 4
'taxonomy' => 'property-type',
'terms'    => array( 21 ),
),
),
),

这将给您这个SQL命令，作为WHERE:的一部分

agn_term_relationships.term_taxonomy_id IN (2) # language
AND 
( 
tt1.term_taxonomy_id IN (1954,1958,1966,1970,1972) # feature
OR 
tt1.term_taxonomy_id IN (145) # city
OR 
tt1.term_taxonomy_id IN (38)  # status
OR 
tt1.term_taxonomy_id IN (21)  # type
)

顺便说一句，'field' => 'id'应该是'field' => 'term_id'，但默认字段实际上是term_id，所以可以省略field参数。此外，WordPress没有一个名为get_post_ID的函数，所以我认为你打算使用get_the_ID()？：(