tags for wp post

wordpress-tags-for-a-post.sql

set @post_id = 587;
select t.term_id, t.name, t.slug
from terms as t
inner join term_taxonomy as tt
on tt.term_id = t.term_id
and taxonomy = 'post_tag'
where tt.term_id in (
	select term_taxonomy_id from term_relationships where object_id = @post_id
)