Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Wordpress query join multiple conditions
- ------------------------------------------------------------
- SELECT a.post_title, b.meta_key, b.meta_value
- FROM wp_posts a join wp_postmeta b
- on a.ID = b.post_id join wp_term_relationships c
- on a.ID = c.object_id join wp_term_taxonomy d
- on c.term_taxonomy_id = d.term_taxonomy_id
- WHERE a.post_type= 'article'
- AND a.post_status = 'publish'
- AND (b.meta_key = 'article_type' AND b.meta_value NOT IN (1,2)) OR
- (b.meta_key = 'is_print' AND b.meta_value = 0) OR
- (b.meta_key = 'is_sponsored' AND b.meta_value != 'on')
- AND d.term_taxonomy_id = 21 AND d.taxonomy = 'sector'
- GROUP BY a.ID
- HAVING COUNT(distinct b.meta_key) = 3
- ORDER BY a.post_DATE DESC LIMIT 20
Advertisement
Add Comment
Please, Sign In to add comment