WP SQL Meta Query

meta-query.sql

SELECT
  wp_posts.ID,
  wp_posts.post_title,
  bill.meta_value AS bill,
  year.meta_value AS year,
  chapter.meta_value AS chapter,
  house.meta_value AS house
FROM
  wp_posts
  LEFT JOIN wp_postmeta AS bill ON wp_posts.ID = bill.post_id
  AND bill.meta_key = 'bill'
  LEFT JOIN wp_postmeta AS year ON wp_posts.ID = year.post_id
  AND year.meta_key = 'year'
  LEFT JOIN wp_postmeta AS chapter ON wp_posts.ID = chapter.post_id
  AND chapter.meta_key = 'chapter'
  LEFT JOIN wp_postmeta AS house ON wp_posts.ID = house.post_id
  AND house.meta_key = 'house'
WHERE
  wp_posts.post_status = 'publish'
  AND wp_posts.post_type = 'product'
ORDER BY
  wp_posts.post_title