How will this query be rewritten using JOIN?

How will this query be rewritten using JOIN?
There are 4 tables at least, like these:
1. PostsTable
pid, stat, title, etc etc
2. tagsTable
id, pid, tag
3. profilesTable
profileID, username, […]

See original post by invalid@example.com (JEET)

Leave a Reply