jeudi 29 janvier 2015

orderby multiple meta keys and meta values


In wordpress, I have posts with meta key "country" and meta values: "usa", "france", "spain", "venezuela" etc... I have the same posts with meta key "rating" and meta values from "1" to "10"


I would like to rank posts first by meta value "usa" of meta key "country" then all other meta values of "country".


I also would like to rank the "usa" meta values post by highest rating ( 10 to 1 ) and then all other "country" meta values also by rating ( 10 to 1 ).


For example a post listing:



  1. Meta key "country", meta value "usa", meta key "rating" meta value "9"

  2. Meta key "country", meta value "usa", meta key "rating" meta value "5"

  3. Meta key "country", meta value "france", meta key "rating" meta value "10"

  4. Meta key "country", meta value "venezuela", meta key "rating" meta value "5"

  5. Meta key "country", meta value "france", meta key "rating" meta value "4"


Thanks for your help.





Aucun commentaire:

Enregistrer un commentaire