Filtering content with WHERE

where.sql

SELECT ID, post_title
FROM wp_posts
WHERE post_type = 'portfolio' AND post_status = 'publish';