I needed to export a table of all posts with their categories and tags for the team to update ready to import back into WordPress with WP All Import. This is the query I used. I ran it in phpMyAdmin and then used phpMyAdmin to export the result to CSV. SELECT ID, post_title, (SELECT group_concat(wp_terms.name [...]