filter posts without images or featured image

global $wpdb;

$posts = $wpdb->get_results(" SELECT * FROM `wp_posts` p inner join `wp_posts` i on i.id=p.id and p.post_type="post" and i.post_type="attachment" where i.post_parent=p.id ");