Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.37 KB | None | 0 0
  1. SELECT DISTINCT
  2.     wpm.meta_value
  3. FROM wp_postmeta wpm
  4. JOIN wp_posts wp ON wpm.post_id = wp.ID
  5. JOIN wp_postmeta wpm2 ON wpm.post_id = wpm2.post_id
  6. WHERE
  7.     /** specify that we only want items under subcat1 **/
  8.     wpm.meta_key = 'subcat1' AND
  9.    
  10.     /** This is how we specify only to get values under commercial **/
  11.     (wpm2.meta_key = 'category' AND wpm2.meta_value = 'commercial')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement