Sql Query For Retrieve Post title, time, category, tags, contents in WordPress

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

Comments