title: How can I add to select multiple values of subquery in main query
body: <p>Query : </p>
  
  <pre><code>SELECT *
  FROM `wp_posts`
  WHERE `ID`
  IN GROUP_CONCAT(
  (
  SELECT post_id
  FROM `wp_postmeta`
  WHERE `meta_key` = 'friday_happy_hour_start_time'
  AND `meta_value` &lt;= '9'
  ) &amp;&amp; (
  SELECT post_id
  FROM `wp_postmeta`
  WHERE `meta_key` = 'friday_happy_hour_end_time'
  AND `meta_value` &gt;= '9'
  )
  )
  </code></pre>
  
  <p>Subquery 1 and 2 having multiple result, so I have used GROUP_CONCAT(). but it is not working.
  I want all the posts where 9 is equal or between <code>meta_value</code>('s) of <code>meta_key</code> = 'friday_happy_hour_end_time' and <code>meta_key</code> = 'friday_happy_hour_start_time'.Please provide me solution</p>