Данил Бабаков

SELECT 
    t1.post_id AS id
    ,t1.meta_value AS seo_title
    ,t2.meta_value AS seo_descr
FROM 
    table t1
    LEFT JOIN table t2 on t1.post_id = t2.post_id AND t1.meta_id != t2.meta_id
GROUP BY 
    t1.post_id;