Is it possible to order posts by two meta values?

2 comments

1. AFAIK, you can’t do it using a meta query. Check this example, does what you want.

   Log in to Reply

2. The simplest solution I can think of is to join the posts meta table with posts table twice. Modifying codex example a bit you can use this:

   $querystr = "
   SELECT wposts.* 
   FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta1, $wpdb->postmeta wpostmeta2
   WHERE wposts.ID = wpostmeta1.post_id
   AND wposts.ID = wpostmeta2.post_id
   AND wpostmeta1.meta_key = 'genus'
   AND wpostmeta2.meta_key = 'species'
   AND wposts.post_type = 'post'
   ORDER BY wpostmeta1.meta_value ASC,
            wpostmeta2.meta_value ASC
   ";
   

   Log in to Reply