WordPress.org

1. teknoledge
   Member
   Posted 3 years ago #

   I have custom field called "featured" for displaying featured post on index page.

   $querystr = "
   	SELECT * FROM $wpdb->posts
   	LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
   	LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
   	LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
   	WHERE $wpdb->term_taxonomy.taxonomy = 'category'
   	AND $wpdb->posts.post_status = 'publish'
   	AND $wpdb->postmeta.meta_key = 'featured'
   	AND $wpdb->postmeta.meta_value = '1'
   	ORDER BY $wpdb->postmeta.meta_value ASC
       ";

   Works fine but it doesn't return post tags within resultset. Anyone knows how to resolve this?

   Thanks,
   Milos

2. teknoledge
   Member
   Posted 3 years ago #

   Resolved as per this post:
   http://wordpress.org/support/topic/138092?replies=5

Topic Closed

This topic has been closed to new replies.