Cacher is the code snippet organizer for pro developers

SELECT key1.post_id, key4.meta_value FROM wp_postmeta AS key1
    INNER JOIN wp_postmeta AS key2
        ON key1.post_id = key2.post_id
        AND key2.meta_key = 'paris_sku'
        AND key2.meta_value != ''
    INNER JOIN wp_postmeta AS key3
        ON key1.post_id = key3.post_id
        AND key3.meta_key = '_stock_status'
        AND key3.meta_value = 'instock'
    INNER JOIN wp_postmeta AS key4
        ON key1.post_id = key4.post_id
        AND key4.meta_key = '_sku'
        AND key4.meta_value
    WHERE key1.meta_key = '_input_paris'
    AND key1.meta_value = 'yes';