SQL Query to return all PUBLISHED pages in Episerver 6


I am trying to run a SQL query to get all of the pages that are published on my live website. I can't find the table property to highlight this published state. Does any know the table name and table property that I need to query please.



Aug 26, 2016 16:15

tblPageLanguage (PendingPublish/StartPublish/StopPublish)

Aug 30, 2016 16:23
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.