Are these of any use?
I went through the articles and got an idea of what data stays in which table and came up with above query. However from above query, I cannot find parent page names and types all the way till root. That is what am trying to find.
I tried putting the data in temp tables and creating joins but with that I can get only upto one level up.
Creating some temp tables and eventually joining on data I need, was able to get this resolved. However big thanks to the articles mentioned above which served as reference (understanding) which table to look for what kind of data.
Glad those links helped and hope Khurram sees this post one day - thank you Khurram :)
There has been a one time need for pulling some content with the criteria so looking for database query:
I need to be able to query data based on a page type and with some other filters:
I have a page type as ContentArticle and need to query all Content Article pages, with data like, Name, id, expiration date, its parent link (type and Name)
T.pkID 'Content Id',
TPL.Name 'Content Name',
T.fkParentID 'Parent Id',
TPL.LinkURL 'Link URL'
from tblPage T
inner join tblPageLanguage TPL ON T.pkID = TPL.fkPageID
inner join tblPageType TP
on T.fkPageTypeID = TP.pkID
where TP.Name = 'ContentArticlePage'