title: Wordpress WP_Query where clause with OR?
body: <p>hello friends this is my args for WP_Query.</p>
  
  <pre><code>$args = array('post_type' =&gt; 'job_listing');
  $args['meta_query']=array(
     'relation' =&gt; 'OR',
      array(
          'key' =&gt; 'app_trailer-type',
          'value' =&gt; $job_tailor,
          'compare' =&gt; 'LIKE'
      ),
      array(
          'key' =&gt; 'app_pay-type',
          'value' =&gt; $app_pay_type,
          'compare' =&gt; 'LIKE'
      ),
      array(
          'key' =&gt; 'geo_address',
          'value' =&gt; $geo_address,
          'compare' =&gt; 'LIKE'
      ),
      array(
          'key' =&gt; 'geo_country',
          'value' =&gt; $geo_country,
          'compare' =&gt; 'LIKE'
      ),
      array(
          'key' =&gt; 'geo_short_address',
          'value' =&gt; $geo_short_address,
          'compare' =&gt; 'LIKE'
      ),
  );
  </code></pre>
  
  <p>this is return query like.</p>
  
  <pre><code>SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
  INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
  INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
  INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
  INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id) WHERE 1=1  AND wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'tr_pending' OR wp_posts.post_status = 'tr_failed' OR wp_posts.post_status = 'tr_completed' OR wp_posts.post_status = 'tr_activated' OR wp_posts.post_status = 'private') AND ( (wp_postmeta.meta_key = 'app_trailer-type' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE '%Flatbed%')
  AND  (mt1.meta_key = 'app_pay-type' AND CAST(mt1.meta_value AS CHAR) LIKE '%Per Week%')
  AND  (mt2.meta_key = 'geo_address' AND CAST(mt2.meta_value AS CHAR) LIKE '%Davenport%')
  AND  (mt3.meta_key = 'geo_country' AND CAST(mt3.meta_value AS CHAR) LIKE '%United States%')
  AND  (mt4.meta_key = 'geo_short_address' AND CAST(mt4.meta_value AS CHAR) LIKE '%Davenport%') ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
  </code></pre>
  
  <p>i required query that query like.</p>
  
  <pre><code>SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
  INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
  INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
  INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
  INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id) WHERE 1=1  AND wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'tr_pending' OR wp_posts.post_status = 'tr_failed' OR wp_posts.post_status = 'tr_completed' OR wp_posts.post_status = 'tr_activated' OR wp_posts.post_status = 'private') AND ( (wp_postmeta.meta_key = 'app_trailer-type' OR CAST(wp_postmeta.meta_value AS CHAR) LIKE '%Flatbed%')
  OR  (mt1.meta_key = 'app_pay-type' AND CAST(mt1.meta_value AS CHAR) LIKE '%Per Week%')
  OR  (mt2.meta_key = 'geo_address' AND CAST(mt2.meta_value AS CHAR) LIKE '%Davenport%')
  OR  (mt3.meta_key = 'geo_country' AND CAST(mt3.meta_value AS CHAR) LIKE '%United States%')
  OR  (mt4.meta_key = 'geo_short_address' AND CAST(mt4.meta_value AS CHAR) LIKE '%Davenport%') ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
  </code></pre>
  
  <p>please help.</p>