I am lost, and the more I read, the more lost I seem to be... normally, I get this, but for some reason it is as clear as mud to me right now.
I need to be able to query the database, pulling data that matches only certain criteria. I am using the Media Category plugin which is assigning a CPT to the media. So I need to pull only attachments under a specific media category.
So, my query must pull post_type = 'attachment' so long as the custom post type term matches. Don't care if I compare with term ID, name, ect.
From what I am seeing, it looks like I need a JOIN query, but I am not getting the markup at all, and I have been playing with this for hours. I need help!