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