[Wodpress]各投稿タイプ最新1件を取得する

gistfile1.txt

<?php
/**
 * @link http://betterwp.net/latest-posts-from-each-post-type/
 */
global $wpdb;
$query = <<<EOT
SELECT * FROM
	(
		SELECT post_type, max(post_date) AS tmp FROM {$wpdb->posts}
			WHERE post_status = 'publish'
			AND post_type NOT IN ('post', 'page')
			GROUP BY post_type
	) AS post
	INNER JOIN {$wpdb->posts} AS ij ON ij.post_type = post.post_type
	AND ij.post_date = post.tmp
EOT;
$posts = $wpdb->get_results($wpdb->prepare($query, null));

foreach ($posts as $post) {
	setup_postdata($post);
	//
}