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

query_mysql_total_posts_exclude_pages_cpt_WP.sql

SELECT 
    p.ID,
    p.post_title,
    p.post_status,
    CONCAT(u.option_value, '/', p.post_name, '/') AS permalink
FROM 
    wp_posts p
JOIN 
    wp_options u 
    ON u.option_name = 'siteurl'
WHERE 
    p.post_type = 'post'
    AND p.post_status IN ('publish', 'draft', 'pending', 'private')
ORDER BY 
    p.post_date DESC;