Query Wordpress for posts with associated meta data

wp_posts_pivot.sql

SELECT  p.ID,   
        p.post_title,
        p.post_date,
        p.post_excerpt,
        p.post_content,
        MAX(CASE WHEN pm.meta_key = '_aioseop_description' then pm.meta_value ELSE NULL END) as meta_description,
        MAX(CASE WHEN pm.meta_key = '_aioseop_title' then pm.meta_value ELSE NULL END) as meta_title 
        
FROM wp_posts p LEFT JOIN wp_postmeta pm ON ( pm.post_id = p.ID)

WHERE p.post_status = 'publish' AND p.post_type = 'post'
                 
GROUP BY p.ID, p.post_title;