How to get psots number with WP_Query based on post

I am trying to write a code at my WordPress website to count posts with type ( season ) and contains ( 12-monkeys ) at its slug [ post_name column ] . I tried this but it didn't work .

     $args = array(  
        'post_type'      => 'season',
        'name' => array(
              'key' => '12-monkeys',
              'compare' => 'LIKE',
            )
        );
        
        
        $qureys = new WP_Query($args);
        
        $Seasons_in_Series = $qureys->found_posts;
        echo  $Seasons_in_Series;

it was using at this template here : egybest

But it shows always wrong number

CodePudding user response：

You can count all the posts which contain '12-monkeys' in the post name by using a custom sql query instead.

global $wpdb;

$post_count = $wpdb->get_var( $wpdb->prepare( "
   SELECT COUNT(*) 
   FROM {$wpdb->posts} 
   WHERE `post_name` 
   LIKE '%s%' 
   AND `post_type` = 'season' ", 
'-monkeys%' ) 
);