Создать сложный запрос mysql wordpress

<?php
 
 $querystr = "SELECT *  FROM $wpdb->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)
WHERE (wp_term_taxonomy.term_id = ".$category->cat_ID." AND wp_term_taxonomy.taxonomy = 'category'
AND wp_posts.post_type = 'post'
AND wp_posts.post_status = 'publish')";
 
$pageposts = $wpdb->get_results($querystr, OBJECT);
 
$count=0;
foreach($pageposts as $post) { 
setup_postdata($post); 
 
$today = date('Y-m-d H:i:S');
 
$validity = get_post_meta($post->ID, 'valid_until', true);
 
$city = get_post_meta($post->ID, 'post_location', true);
 
$action = get_post_meta($post->ID, 'post_action', true);
 
 
$cities = explode("|", $city);
 
$session_city = $_SESSION["session_city"];
 
 
$timestamp1 = strtotime(get_the_time('Y-m-d'));
$timestamp2 = strtotime(date('Y-m-d', strtotime('-'.$validity.' days')));
 
if($_SESSION["session_city"] and !$_SESSION["session_action"] or $_SESSION["session_action"]=='All') {
    if($validity >= $today and in_array($session_city, $cities)) { $count++;}
}
 
if($_SESSION["session_action"] and !$_SESSION["session_city"] or $_SESSION["session_city"]=='All') {
    if($validity >= $today and $action == $_SESSION["session_action"]) { $count++;}
}
 
if($_SESSION["session_action"] and $_SESSION["session_city"]) {
    if($validity >= $today and $action == $_SESSION["session_action"] and in_array($session_city, $cities)) { $count++;}
}
 
if(!isset($_SESSION["session_city"]) and !isset($_SESSION["session_action"])) {
    if($validity >= $today) { $count++;}
}
 
 
}
 
echo $count;
 
?>