Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Find all the order with duplicate meta data
- select
- post_id
- ,meta_key
- ,count(meta_key) as value_count
- from
- wp_postmeta
- where
- (meta_key like '%_base_currency%')
- group by
- post_id,
- meta_key
- having
- value_count >= 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement