I'm working on a blog that pulls one entry each from 7 different blogs based on the most recently published category on the main blog. All that business is working fine.
The person who is going to maintain the needs to be able to preview what the site will look like once the next entry is released on the main blog.

I thought I had a silver bullet in the MTSQL plug-in using entry_status=1 but the unpublished entries aren't showing. I've checked my queries in phpmyadmin and everything checks out there.

Is this a known issue? Has anyone else had any luck with anything like this?

Figured it out. In order to show entries that are unpublished or scheduled, you have to include unfiltered="1" after the query.