我需要通过WP\\U查询对象运行以下查询：

SELECT wp_posts.* FROM wp_posts  
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  
INNER JOIN wp_postmeta mt1 ON ( wp_posts.ID = mt1.post_id )  
WHERE 1=1  
AND 
(
  (
    wp_term_relationships.term_taxonomy_id IN (47) /* current season */
    AND wp_postmeta.meta_key = \'show_is_creation\' AND wp_postmeta.meta_value = \'1\'
  ) 
  OR (
    mt1.meta_key = \'show_in_ontour\' AND mt1.meta_value = \'1\'
    AND wp_postmeta.meta_key = \'show_is_creation\' AND wp_postmeta.meta_value = \'1\'
  )
) 
AND wp_posts.post_type = \'show\' 
AND ((wp_posts.post_status = \'publish\')) 

GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC;

所以，我需要进行税务查询inside 元查询子句。对于“meta\\u query”参数，这似乎是不可能的，如下所示：

$meta_query = [
     \'relation\' => \'OR\',
     [
       \'relation\'           => \'AND\',
       \'current_season_clause\' => [
         \'tax_query\' => [
           \'taxonomy\' => \'season\',
           \'operator\' => \'IN\',
           \'terms\'    => [47],
         ],
       ],
       \'is_creation_clause\' => [
         \'key\'     => \'show_is_creation\',
         \'compare\' => \'=\',
         \'value\'   => 1,
       ],
     ],
     [
       \'relation\'           => \'AND\',
       \'is_creation_clause\' => [
         \'key\'     => \'show_is_creation\',
         \'compare\' => \'=\',
         \'value\'   => 1,
       ],
       \'is_ontour_clause\'   => [
         \'key\'     => \'show_in_ontour\',
         \'compare\' => \'=\',
         \'value\'   => 1,
       ],
     ],
 ];

实现这一目标的最佳方式是什么？（不运行原始SQL查询）。我应该使用过滤器来修改WHERE语句吗？

谢谢

// should we show this post on the homepage?
if ( has_term( [ \'homepage\' ], \'show_on\' ) {
    //
}

add_action( \'pre_get_posts\', function( $query ) {
    if ( $query->is_home() && $query->is_main_query() ) {
        $query->set( \'hidden_post_markers\', \'show_on_homepage\' );
    }
} );