Skip to content

Instantly share code, notes, and snippets.

@dannewns
Created April 14, 2015 13:44
Show Gist options
  • Save dannewns/9fcf8a7a5791852f641f to your computer and use it in GitHub Desktop.
Save dannewns/9fcf8a7a5791852f641f to your computer and use it in GitHub Desktop.
'meta_query' => array(
array(
'key' => 'product_current_stock',
'value' => "(SELECT wp_postmeta.meta_value as min_stock FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = 'product_minimum_stock')",
'compare' => '>='
)
),
@trovster
Copy link

function _site_get_meta_sql($sql, $queries, $type, $primary_table, $primary_id_column, $context) {
    if(!empty($context->query_vars['unescape']) && !empty($sql['where'])) {
        $sql['where'] = str_replace("\'" . $context->query_vars['unescape'] . "\'", "'" . $context->query_vars['unescape'] . "'", $sql['where']);
    }

    return $sql;
}
add_filter('get_meta_sql', '_site_get_meta_sql', 10, 6);

get_posts(array(
    'unescape'  => 'product_minimum_stock',
    'meta_query' => array(
        array(
            'key' => 'product_current_stock',
            'value' => "(SELECT wp_postmeta.meta_value  as min_stock FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = 'product_minimum_stock')",
            'compare' => '>='
        )
    ),
));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment