List tags associated with wordpress posts

post_tags.sql

SELECT
	wp_posts.ID AS 'Post ID' ,
	wp_posts.post_title AS 'Post Title' ,
	group_concat(
		DISTINCT wp_terms.`name` SEPARATOR ', '
	) AS 'Tags'
FROM
	wp_term_relationships
JOIN wp_posts ON wp_term_relationships.object_id = wp_posts.ID
JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_id
WHERE
	wp_term_taxonomy.taxonomy = 'post_tag'
AND wp_posts.post_status = 'publish'
AND wp_posts.post_type = 'post'
GROUP BY
	wp_posts.ID