Hi,
I have created a new page type call 'ServicePage', in the database, there are three table in relation to this page type. 'ServicePage', 'ServicePage_Live', 'ServicePage_versions'. Now, in the front end, I have a page which simply display all the services that has been created. Which table should I query, that will only display all published page if user views the published site, and display those new draft page, if user views draft site. In other words, I am trying not to display pages that are not published.
Thanks