Reply To: Querying Relationship Fields with SQL

• chriscarvache

• April 1, 2017 at 1:54 am

Edit. The above query should use a LEFT JOIN towards the end.

SELECT
  wp_shzat400yd_data_questions.*,
  wp_shzat400yd_posts.post_content,
  wp_shzat400yd_posts.post_title,
  wp_shzat400yd_postmeta.post_id AS section_id,
  wp_shzat400yd_postmeta.meta_value,
  wp_shzat400yd_postmeta.meta_key
FROM wp_shzat400yd_data_questions
  INNER JOIN wp_shzat400yd_posts
    ON wp_shzat400yd_data_questions.question_id = wp_shzat400yd_posts.ID
  LEFT JOIN wp_shzat400yd_postmeta
    ON wp_shzat400yd_posts.ID LIKE CONCAT('%', wp_shzat400yd_postmeta.meta_value, '%')
WHERE wp_shzat400yd_postmeta.meta_key = 'questions';