You will need to set the repeater to not to select published pages only. Then, you should be able to use a variant of the WHERE condition used to get all published pages:
([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE()) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE()))
So, the above condition is used to get published pages. You can modify it to fit your needs. And also, you may want to check what is the difference between content scheduling and workflow.