Query posts only without featured image

Question

want to query 100 posts, but only those which do not have a featured image attached. I am using meta_key method for this with WP_Query as such:

$args = array(
   'post_type'  => 'post',
   'posts_per_page' => 100,
    'meta_query' => array(
        array(
         'key' => '_thumbnail_id',
         'compare' => 'NOT EXISTS'
        ),
    )
);

But Not work with me

Any help ?

Answer 1

Try this code , its working for me

value=>'?' 

because(value was required for NOT EXISTS comparisons to work correctly prior to 3.9. You had to supply some string for the value parameter. An empty string or NULL will NOT work. However, any other string will do the trick and will NOT show up in your SQL when using NOT EXISTS.)

For more information about value=>? please refer this link

$args = array(
  'post_type'  => 'post',
  'posts_per_page' => 100,
  'meta_query' => array(
     array(
       'key' => '_thumbnail_id',
       'value' => '?',
       'compare' => 'NOT EXISTS'
     )
  ),
);
$new_query = new WP_Query( $args );