get list of wordpress post tags and taxonomies

wordpress-post-tags-and-categories.sql

select x.taxonomy, left(t.name, 50) name, left(p.post_title, 50) post_title from
  wp_terms t,
  wp_term_taxonomy x,
  wp_term_relationships r,
  wp_posts p
where
  t.term_id = x.term_id
and
  x.term_taxonomy_id = r.term_taxonomy_id
and
  r.object_id = p.ID

With group by post title

select  x.taxonomy as taxonomy, left(p.post_title, 50) as post_title, left(group_concat(t.name, ' '), 50) as name
from
  wp_terms t,
  wp_term_taxonomy x,
  wp_term_relationships r,
  wp_posts p
where
  t.term_id = x.term_id
and
  x.term_taxonomy_id = r.term_taxonomy_id
and
  r.object_id = p.ID
group by 
 x.taxonomy, p.post_title

Group by taxonomy and agg post titles

select  x.taxonomy as taxonomy, left(t.name, 50) as post_title, left(group_concat(p.post_title, ' '), 50) as name
from
  wp_terms t,
  wp_term_taxonomy x,
  wp_term_relationships r,
  wp_posts p
where
  t.term_id = x.term_id
and
  x.term_taxonomy_id = r.term_taxonomy_id
and
  r.object_id = p.ID
group by 
 x.taxonomy, t.name