SELECT p1.pcCont_PageName, p1.pcCont_IncHeader, p1.pcCont_MetaTitle, p1.pcCont_Description, p1.pcCont_Parent, p1.pcCont_MetaDesc, p1.pcCont_MetaKeywords, p1.pcCont_PageTitle, p2.pcCont_PageName AS ParentName FROM pcContents p1, pcContents p2 WHERE p2.pcCont_IDPage = p1.pcCont_Parent AND p1.pcCont_IDPage=13 AND p1.pcCont_InActive=0 AND p1.pcCont_Published=1 AND p1.pcCont_CustomerType = 'ALL'