> > " JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id"; > > but that was returning duplicated posts You can add a GROUP BY wp_posts.ID to remove the duplicates. -- http://scribu.net