Why orderbyb meta_value_num won’t affect the generated SQL Query order?

I’ve exhausted myself with this and I couldn’t figure out why when I do this

$myposts = new WP_Query( array('numberposts' => 5,
'offset' => '0',
'post_type' => 'noticias',
'orderby' => 'meta_value_num',
'order' => 'DESC',
'post_status' => 'publish',
'meta_key' => '_countview'
));

wordpress queries the db with the following SQL:

Read More
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) 
WHERE 1=1 
 AND wp_posts.post_type = 'noticias' 
 AND (wp_posts.post_status = 'publish') 
 AND (wp_postmeta.meta_key = '_countview' ) 
GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC LIMIT 0, 5

did something change for 3.4 and i’m missing the syntax?

Related posts

Leave a Reply