Title: Using get_posts with multiple meta values
Last modified: August 19, 2016

---

# Using get_posts with multiple meta values

 *  Resolved [overwolf](https://wordpress.org/support/users/overwolf/)
 * (@overwolf)
 * [16 years ago](https://wordpress.org/support/topic/using-get_posts-with-multiple-meta-values/)
 * How can i use get_posts() with multiple meta_key – meta_value agruments?
 *     ```
       $args = array(
          'numberposts' => 100,
          'meta_key'=>'category',
          'meta_value'=>'a',
          'meta_key'=>'color',
          'meta_value'=>'red'
        );
       get_posts($args);
       ```
   
 * don’t works and uses only first meta

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [16 years ago](https://wordpress.org/support/topic/using-get_posts-with-multiple-meta-values/#post-1498959)
 * You could code a custom query as shown [here in the CODEX](http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query).
 * Your SQL statement would be like this:
 *     ```
       $querystr = "
           SELECT wposts.*, meta1.meta_value as meta_value1, meta2.meta_value as meta_value2
           FROM $wpdb->posts wposts, $wpdb->postmeta meta1, $wpdb->postmeta meta2
           WHERE wposts.ID = meta1.post_id
           AND meta1.meta_key = 'category'
           AND meta1.meta_value = 'a'
           AND wposts.ID = meta2.post_id
           AND meta2.meta_key = 'color'
           AND meta2.meta_value = 'red'
           AND wposts.post_status = 'publish'
           AND wposts.post_type = 'post'
           ORDER BY wposts.post_date DESC
        ";
       ```
   
 * Or, you could use the [Query Multiple Taxonomies plugin](http://scribu.net/wordpress/query-multiple-taxonomies).
 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [16 years ago](https://wordpress.org/support/topic/using-get_posts-with-multiple-meta-values/#post-1498993)
 * Scratch the plugin – its for categories and tags, not custom fields.
 *  Thread Starter [overwolf](https://wordpress.org/support/users/overwolf/)
 * (@overwolf)
 * [16 years ago](https://wordpress.org/support/topic/using-get_posts-with-multiple-meta-values/#post-1499027)
 * **vtxyzzy**, thanks a lot! I’ve tried to use custom query, but had problems with
   SQL.
 *  [dwzemens](https://wordpress.org/support/users/dwzemens/)
 * (@dwzemens)
 * [15 years, 10 months ago](https://wordpress.org/support/topic/using-get_posts-with-multiple-meta-values/#post-1499171)
 * overwolf: Here’s the SQL that I am using to query for more than one custom field.
   Works great. Let me know if you think it works for you.
 *     ```
       $querydetails = "
       SELECT wposts.*
         FROM $wpdb->posts wposts
       INNER
         JOIN ( SELECT post_id
                  FROM $wpdb->postmeta wpostmeta
                 WHERE ( ( wpostmeta.meta_key = 'available'
                       AND wpostmeta.meta_value =  '$available' )
                      OR ( wpostmeta.meta_key = 'beds'
                       AND wpostmeta.meta_value $operator_beds '$beds' )
                      OR ( wpostmeta.meta_key = 'baths'
                       AND wpostmeta.meta_value = '$baths' )
                      OR ( wpostmeta.meta_key = 'type'
                       AND wpostmeta.meta_value = '$type' )
                      )
                GROUP
                    BY post_id
                HAVING COUNT(*) = 4 ) AS t
           ON t.post_id = wposts.ID
        WHERE wposts.post_status = 'publish'
          AND wposts.post_type = 'post'
       ORDER
           BY wposts.post_date DESC
        ";
   
       $pageposts = $wpdb->get_results($querydetails, OBJECT);
       ```
   
 * The only problem I am having is that I cannot get pagination to work because 
   of the custom query. Can anyone offer any help with that?

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Using get_posts with multiple meta values’ is closed to new replies.

## Tags

 * [get_posts](https://wordpress.org/support/topic-tag/get_posts/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [dwzemens](https://wordpress.org/support/users/dwzemens/)
 * Last activity: [15 years, 10 months ago](https://wordpress.org/support/topic/using-get_posts-with-multiple-meta-values/#post-1499171)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics