Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I am trying to sort posts based on rating (using wp-postrating plugin) and numbers of comments. I have made this using wpdb, but i kinda wish to make it easier and use it with wp_query. Seems that I can not find any way to achieve this because I do not know any method to orderby two items in $args.

My wpdb code looks like this...

$wpdb->get_results("SELECT wp_postmeta.meta_value, id, post_title, comment_count FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.id WHERE post_type='post' AND wp_postmeta.meta_key='ratings_average' ORDER BY wp_postmeta.meta_value DESC, comment_count DESC");

Any idea?

share|improve this question
add comment

2 Answers

You can do it with wp_query

$args = array(  'post_type'     => 'post',
                'numberposts'   => -1,
                'posts_per_page'=> -1,
                'orderby'       => 'meta_value_num',
                'meta_key'      => 'ratings_average',
                'order'         => 'DESC',
            );
$posts = new WP_Query($args);

Now the result is DESC Order.

share|improve this answer
    
Yes, but I also need to sort it DESC by comments number. –  Iulian Bozeanu Jun 22 '13 at 7:38
    
I'm pretty sure this answer doesn't solve Iulians problem. You just showed how to order posts by meta_value. Am I missing something? –  Krzysiek Dróżdż Jun 22 '13 at 7:45
1  
sorry i didnt read the full problem –  ksr89 Jun 22 '13 at 7:49
add comment

First of all, you can use multiple fields in orderby argument. Codex shows you how to do it:

$query = new WP_Query( array( 'post_type' => 'page', 'orderby' => 'title menu_order', 'order' => 'ASC' ) );

And it should solve your problem. (It should, but if you want to sort DESC it probably won't, because of this WordPress bug: http://core.trac.wordpress.org/ticket/17065)

Of course you always can use posts_orderby filter to create your own ORDER BY part of query.

function my_posts_orderby($orderby_statement) {
    $orderby_statement = "YOUR ORDER BY STATEMENT";
    return $orderby_statement;
}
add_filter('posts_orderby', 'my_posts_orderby');

Just add this filter just before you call your query and remove it after.

share|improve this answer
    
If I use this: $args = array( 'posts_per_page' => 5, 'paged' => $paged, 'meta_key' => 'ratings_average', 'orderby' => 'meta_value comment_count', 'order' => 'DESC' ); it works somehow. But it`s not filtering right. –  Iulian Bozeanu Jun 22 '13 at 7:46
    
What do you mean by "not filtering right"? You can always look at SQL query that was generated by wp_query (just var_dump wp_query object). –  Krzysiek Dróżdż Jun 22 '13 at 7:53
    
For example I have a post with 5 average rating, 0 comments. I have one with 4 average rating and 3 comments, and I have another one with 5 average and 2 comments. By using that exact code the order is just as I wrote it...should be 1 3 2. –  Iulian Bozeanu Jun 22 '13 at 7:58
    
What SQL does this wp_query generate? –  Krzysiek Dróżdż Jun 22 '13 at 8:02
    
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 = 'post' AND (wp_posts.post_status = 'publish') AND (wp_postmeta.meta_key = 'ratings_average' ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value,wp_posts.comment_count DESC LIMIT 0, 5) –  Iulian Bozeanu Jun 22 '13 at 8:07
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.