Really interesting and worth mentioning imitative, and the current winner QueryPosts looks like something WP developers could find useful.

BTW. @Sarah, the "WordPress StackExchange" link is broken