Query - MySQL - WordPress | Display all Posts with Categories exclude pages and other content type

query_mysql_total_posts_categories_exclude_pages_cpt_WP.sql

SELECT 
    p.ID,
    p.post_title,
    p.post_status,
    CONCAT(u.option_value, '/', p.post_name, '/') AS permalink,
    GROUP_CONCAT(t.name ORDER BY t.name SEPARATOR ', ') AS categories
FROM 
    wp_posts p
JOIN 
    wp_options u 
    ON u.option_name = 'siteurl'
LEFT JOIN 
    wp_term_relationships tr ON p.ID = tr.object_id
LEFT JOIN 
    wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
    AND tt.taxonomy = 'category'
LEFT JOIN 
    wp_terms t ON tt.term_id = t.term_id
WHERE 
    p.post_type = 'post'
    AND p.post_status IN ('publish', 'draft', 'pending', 'private')
GROUP BY 
    p.ID, p.post_title, p.post_status, permalink
ORDER BY 
    p.post_date DESC;