[wp-trac] [WordPress Trac] #17165: Introduce WP_Meta_Query

[WordPress Trac]

#17165: Introduce WP_Meta_Query
------------------------------+------------------
 Reporter:  scribu            |       Owner:
     Type:  enhancement       |      Status:  new
 Priority:  normal            |   Milestone:  3.2
Component:  Query             |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+------------------

Comment (by greuben):

 One small change, check if parsed queries are arrays.
 Try this query
 {{{
 $q = new WP_Query(
 array(
         'fields' => 'ids',
         'ignore_sticky_posts' => true,
         'meta_query' => array(
                 'test' => 'test',
                 array(
                         'key' => 'foo',
                         'value' => array( 'foobar' ),
                         'compare' => 'IN'
                 )
         )
 ) );
 echo  $q->request;
 }}}

 The result
 {{{
 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN
 wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) INNER JOIN wp_postmeta
 AS mt1 ON (wp_posts.ID = mt1.post_id) WHERE 1=1 AND wp_posts.post_type =
 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status =
 'private') AND wp_postmeta.meta_key = 't' AND CAST(wp_postmeta.meta_value
 AS CHAR) = 't' AND mt1.meta_key = 'foo' AND CAST(mt1.meta_value AS CHAR)
 IN ('foobar') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT
 0, 5
 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17165#comment:19>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software