amp343

Good call, that makes sense now. Is there an easy way to see the SQL that the query functions generate? That might make this easier for future reference.

I figured I would run in to some issues with the duplicate post slugs — that apparently being one of them — but I’m hoping the query I have pulling the post now will work reliably.

I hope trying to keep this format up with duplicate post slugs doesn’t end up being a foolish endeavor; I’ve only really come across one other answer about how to do it in WP: Don’t!

Thanks again for the help.

Here’s what I came up with so far… not sure if this is really legit / going to work in the end, but it seems to be fore the time being!

$querystr ="
SELECT wposts.*
FROM $wpdb->posts wposts
	LEFT JOIN $wpdb->term_relationships tr ON (wposts.ID = tr.object_id)
	LEFT JOIN $wpdb->term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
	LEFT JOIN $wpdb->terms t ON (tt.term_id = t.term_id)

	WHERE wposts.post_name = '$postname_var'
	AND t.term_id = $this_cat_ID_var
	"

;

(postname and cat id having already been determined and stored as vars prior to running the query)

Is it possible to use this to retrieve a post based on a combination of slug and category?

I know you should be able to get the post by slug alone, but the database I’m working with has some duplicate entries for slugs, so it returns more than one post. I was thinking that by querying the post slug and category id, it would narrow down the selection since that would return one result only. However, query_posts breaks when I try to do this…

… a new, unique field