I'm in the middle of assisting a colleague in reconfiguring a Wordpress database for use on another platform. The database is essentially details regarding all the posts and accompanying metadata, etc.
One of the things I'm stuck on is determining how to correlate each post with its Wordpress category. Essentially, I'd like to be able to pull out every post with its corresponding category into a spreadsheet, and to be able to do that, I clearly need to know their relationship within the tables.
Can anyone point me in the correct direction? Any help would be sincerely appreciated. Thank you.