Correct. I’m currently working on using something like:
$querystr = "
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'customposttype'
AND $wpdb->posts.post_date < NOW()
ORDER BY $wpdb->posts.post_date DESC
$pageposts = $wpdb->get_results($querystr, OBJECT);
Then looping through. However, the permalink doesn’t work the way you would think it should and I still haven’t gotten any meta data to go with it. It would be great to get the custom fields and featured image too.