Guest User

Untitled

a guest
Jul 16th, 2018
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. $sql = "JOIN (
  2. SELECT post_parent AS post_id,meta_key,meta_value
  3. FROM $wpdb->postmeta
  4. JOIN $wpdb->posts
  5. ON $wpdb->posts.ID = $wpdb->postmeta.post_id
  6. WHERE meta_key = 'winning_bid_value'
  7. UNION ALL
  8. SELECT post_id,meta_key,meta_value
  9. FROM $wpdb->postmeta
  10. JOIN $wpdb->posts
  11. ON $wpdb->posts.ID = $wpdb->postmeta.post_id
  12. WHERE meta_key ='start_price'
  13. AND post_id NOT IN (
  14. SELECT post_parent
  15. FROM $wpdb->posts
  16. WHERE post_status = 'winning')
  17. ) AS new_meta
  18. ON $wpdb->posts.ID = post_id AND (meta_key = 'start_price' OR meta_key = 'winning_bid_value')";
Add Comment
Please, Sign In to add comment