WordPress.org

Ready to get started?Download WordPress

Forums

Postlists sort by custom field (meta_key) (2 posts)

  1. Bo
    Member
    Posted 4 years ago #

    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

  2. Bo
    Member
    Posted 4 years ago #

    Anyone?!

Topic Closed

This topic has been closed to new replies.

About this Topic