SELECT DISTINCT
post_title,ID, post_author, post_date, post_modified, post_parent
, post_content
,(SELECT group_concat(wpuq_terms.name separator ', ')
FROM wpuq_terms
INNER JOIN wpuq_term_taxonomy on wpuq_terms.term_id = wpuq_term_taxonomy.term_id
INNER JOIN wpuq_term_relationships wpr on wpr.term_taxonomy_id = wpuq_term_taxonomy.term_taxonomy_id
WHERE taxonomy= 'category' and wpuq_posts.ID = wpr.object_id
) AS "Categories"
,(SELECT group_concat(wpuq_terms.name separator ', ')
FROM wpuq_terms
INNER JOIN wpuq_term_taxonomy on wpuq_terms.term_id = wpuq_term_taxonomy.term_id
INNER JOIN wpuq_term_relationships wpr on wpr.term_taxonomy_id = wpuq_term_taxonomy.term_taxonomy_id
WHERE taxonomy= 'post_tag' and wpuq_posts.ID = wpr.object_id
) AS "Tags"
FROM wpuq_posts
WHERE post_type = 'post'
ORDER BY
post_title
, post_content
post_title,ID, post_author, post_date, post_modified, post_parent
, post_content
,(SELECT group_concat(wpuq_terms.name separator ', ')
FROM wpuq_terms
INNER JOIN wpuq_term_taxonomy on wpuq_terms.term_id = wpuq_term_taxonomy.term_id
INNER JOIN wpuq_term_relationships wpr on wpr.term_taxonomy_id = wpuq_term_taxonomy.term_taxonomy_id
WHERE taxonomy= 'category' and wpuq_posts.ID = wpr.object_id
) AS "Categories"
,(SELECT group_concat(wpuq_terms.name separator ', ')
FROM wpuq_terms
INNER JOIN wpuq_term_taxonomy on wpuq_terms.term_id = wpuq_term_taxonomy.term_id
INNER JOIN wpuq_term_relationships wpr on wpr.term_taxonomy_id = wpuq_term_taxonomy.term_taxonomy_id
WHERE taxonomy= 'post_tag' and wpuq_posts.ID = wpr.object_id
) AS "Tags"
FROM wpuq_posts
WHERE post_type = 'post'
ORDER BY
post_title
, post_content
Comments
Post a Comment