When I run my original query, it's based off of the slug name of one category, which traced through the join retrieves term_taxonomy_id "8" and returns both id 130 and 128 in wp_posts.

What I'd like to do is check for 2 slug names (the parent and the child), and only return ID's that have both slug names, so basically, find the id that is part of both category "8" and category "12", and only return the 130.

SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (
INNER JOIN wp_terms
ON wp_terms.term_id=wp_term_relationships.term_taxonomy_id
WHERE wp_terms.slug=("homeblocks", "1x2")
)
GROUP
BY object_id
HAVING COUNT(*) = 2

And I'm not surprised, but even with my awesome homemade syntax, the query doesn't work.