WordPress.org

Support

Support » Plugins and Hacks » Postlists sort by custom field (meta_key)

Postlists sort by custom field (meta_key)

  • Hi!

    I am using the Postlists plugin (http://wordpress.org/extend/plugins/postlists/) and I would like to sort the output by a custom field. The field I would like to get from the wp_domusdox1postmeta table is custom field ‘prijs’ and sort it by its value. But I can’t find a way to do so via the plugin input options.

    The query produced by the plugin is currently:
    SELECT DISTINCT * FROM wp_domusdox1posts , wp_domusdox1term_relationships, wp_domusdox1term_taxonomy , wp_domusdox1postmeta WHERE 1 AND post_type = ‘post’ AND post_status = ‘publish’ AND ( 0 OR (wp_domusdox1posts.ID = wp_domusdox1term_relationships.object_id AND wp_domusdox1term_relationships.term_taxonomy_id = wp_domusdox1term_taxonomy.term_taxonomy_id AND wp_domusdox1term_taxonomy.term_id = 3 ) ) GROUP BY wp_domusdox1posts.ID LIMIT 25

    Can anyone help me on this one?
    Thanks a lot!

    Bjorn

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Postlists sort by custom field (meta_key)’ is closed to new replies.
Skip to toolbar