How to display multiple Post meta_key/meta_values by SQL query
change where clause with or SELECT P.ID, P.post_title, P.post_content, P.post_author, meta_value FROM wp_posts AS P LEFT JOIN wp_postmeta AS PM on PM.post_id = P.ID WHERE P.post_type=”post” and P.post_status=”publish” and ( meta_key = ‘job_title’ or meta_key = ‘company_email’ ) ORDER BY P.post_date DESC but this sql will return the same post in 2 row for your … Read more