loop query exclude meta_key with meta_value

Question

Hi I use a loop like this:

// show all active coupons for this store and setup pagination
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
query_posts( array(
    'post_type' => APP_POST_TYPE,
    'post_status' => 'publish',
    APP_TAX_STORE => $term->slug,
    'ignore_sticky_posts' => 1,
    'posts_per_page' => -1,
    'paged' => $paged
) );

Now I have a meta value meta_key' => 'clpr_excoupon' it is either 1 or 0.

I would like to exclude all meta_key' => 'clpr_excoupon' with 'meta_value'=> 0, and also 'NOT EXISTS' need help!!

Answer 1

Do NOT use query_posts() - it is bad, very bad to be exact.

For more information read:

• When should you use WP_Query vs query_posts() vs get_posts()?
• When to use WP_query(), query_posts() and pre_get_posts

Use WP_Query instead.

Example with meta_key, meta_value and meta_compare parameters in use:

$args = array(
    'meta_key'     => 'clpr_excoupon',
    'meta_value'   => '0',
    'meta_compare' => '!='
);
$query = new WP_Query( $args );

Note: those parameters work for query_posts too, but as said, you shouldn't use it.

---

Update:

With NOT EXISTS compare.

$args = array(
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key'     => 'clpr_excoupon',
            'compare' => 'NOT EXISTS',
            'value'   => 'prior to WP 3.9 a value was needed due to bug #23268'
        ),
        array(
            'key'     => 'clpr_excoupon',
            'compare' => '!=',
            'value'   => '0'
        ),
    ),
);
$query = new WP_Query( $args );

Answer 2

You should use 2 queries for this:

$excluded = query_posts( array(
        'meta_key=> 'clpr_excoupon';
        'meta_value' => '0'
) );

//$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
query_posts( array(
    'post__not_in => $excluded;
    'post_type' => APP_POST_TYPE,
    'post_status' => 'publish',
    APP_TAX_STORE => $term->slug,
    'ignore_sticky_posts' => 1,
    'posts_per_page' => -1
    //'paged' => $paged
) );

with this code you will get all the posts that have the clpr_excoupon with value 1 :)

Hope this helps...

Cheers, Mile

Answer 3

It is working with this, thanks @ialocin for your help :

// show all active coupons for this store and setup pagination
                    $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
                    query_posts( array(
                        'post_type' => APP_POST_TYPE,
                        'post_status' => 'publish',
                        APP_TAX_STORE => $term->slug,
                        'ignore_sticky_posts' => 1,
                        'posts_per_page' => -1,
                        'meta_query' => array(
    'relation' => 'OR',
    array(
        'key'     => 'clpr_excoupon',
        'compare' => 'NOT EXISTS'

    ),
    array(
        'key'     => 'clpr_excoupon',
        'compare' => '!=',
        'value'   => '1'
    ),
),
                        'paged' => $paged
                    ) );