select t1.pkDocumentId, t1.pageTitle, t1.documentname from tblDocuments t1 inner join tblDocuments t2 on t1.parentDocumentId = t2.pkDocumentId inner join tblDocuments t3 on t2.parentDocumentId = t3.pkDocumentId where t1.isActive = 1 and t1.templateId = 8 and t1.archivedOn is null and t3.documentName = 'us-en' order by t1.pageOrder