get_results(“SELECT ID, post_title FROM wp_posts WHERE post_status = ‘future’
AND post_type=’post’ ORDER BY post_date ASC LIMIT 0,4”)

// Echo the title of the first scheduled post
echo $posts[0]->post_title;
?>