I have a query were I'm grabbing all post types of "news" in 2010, but it doesn't select the posts from that year. What am I doing wrong?
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'news'
AND year($wpdb->posts.post_date) = 2010,
ORDER BY $wpdb->posts.post_date DESC
";
Taking this line out does fetch the news posts, but really I want them from a particular year.
AND year($wpdb->posts.post_date) = 2010,