Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.*,b.Meta_id, b.post_id,
- CASE WHEN b.meta_key ='mk1' THEN b.meta_value END `mk1`,
- CASE WHEN b.meta_key ='mk2' THEN b.meta_value END `mk2`,
- CASE WHEN b.meta_key ='mk3' THEN b.meta_value END `mk3`
- FROM wp_posts a
- JOIN wp_postmeta b ON( a.ID = b.post_id )
- WHERE a.post_status = 'publish'
- AND a.post_type='wpsc-product'
- AND b.meta_key IN('mk1','mk2','mk3')
- SELECT p.*,
- a.Meta_id,
- a.post_id,
- a.meta_value mk1,
- b.meta_value mk2,
- c.meta_value mk3
- FROM wp_posts p
- LEFT JOIN wp_postmeta a ON(p.ID =a.post_id)
- JOIN wp_postmeta b USING(post_id) /* is equal to ON(b.post_id = a.post_id) */
- JOIN wp_postmeta c USING(post_id)
- WHERE a.meta_key = 'mk1'
- AND b.meta_key = 'mk2'
- AND c.meta_key='mk3'
- SELECT Meta_id,post_id,
- MAX(case when meta_key= 'mk1' then meta_value end) As mk1,
- MAX(case when meta_key= 'mk2' then meta_value end) As mk2,
- MAX(case when meta_key= 'mk3' then meta_value end) As mk3,
- MAX(case when meta_key= 'mk4' then meta_value end) As mk4
- FROM wp_postmeta
- GROUP BY Meta_id,post_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement