DB query to fetch topics by tag

[OblivionNW]

Hey all, I have another application that I'm connecting to the ipb database and using the data. I am trying to understand how to fetch related topics by tag, but this is such a confusing architecture i find myself making big circles back to where I begin.

What I know: The `core_tags` contains all of the tags that are in use currently, and they have these hashes for aai and aap lookup, which I have yet to find a connection between those and the topics themselves. I imagine that is the secret ingredient, So if anyone understands the database architecture and provide me with a mysql query to fetech posts by tag please help me out!

Thanks

[OblivionNW]

this can be closed, I figured it out.

[rgf100]

Or alternatively you could post what you figured to help me do something similar?