I'm trying to show all pending posts on a page, and create a link to each post. When the post is not approved yet the link is broken and doesn't work. As soon as I publish the post the link works again. If I access the post GUID the one where the status is "publish" the link works, but the the one with the status "pending" does not.

I want to know what is the difference between a pending post and a published one in the post table in the database so that I can take those changes into account in order for the pending posts links to work.