Display post based without a feature image in wp

displaydatawp.php

   global $wpdb;
   
/* -- Preparing your query -- */
	$query = "SELECT wp_posts.* FROM wp_posts
			LEFT JOIN wp_postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '_thumbnail_id' )
			WHERE $wpdb->posts.post_type = 'photo' AND ( $wpdb->posts.post_status = 'publish' ) AND ( $wpdb->postmeta.post_id IS NULL )";
			
			// $wpdb->posts.post_type = 'photo' -------> custom post type