Display post based on custom fields with a custom query

<?php
/*
Template Name: Custom query
*/
$querystr = “
SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = ‘tag’
AND wpostmeta.meta_value = ’email’
AND wposts.post_status = ‘publish’
AND wposts.post_type = ‘post’
ORDER BY wposts.post_date DESC
“;
$pageposts = $wpdb->get_results($querystr, OBJECT);
if ($pageposts): foreach ($pageposts as $post):
setup_postdata($post);
// Display your post info. For exemple: the_title();the_exerpt();
endforeach;
endif; ?>


custom fields with a custom query