select pages.id,pages.parentid,pages.name,pages.title,metakeyword,metadescription,seopath,pages.description,pages.publish,pages.ishome,pages.headerimageid,pages.createdate,headerimage.imagefile from pages inner join headerimage on(pages.headerimageid=headerimage.id) where seopath ="about-us"
  • Available Properties
  • select pages.id,pages.parentid,pages.name,pages.title,metakeyword,metadescription,seopath,pages.description,pages.publish,pages.ishome,pages.headerimageid,pages.createdate,headerimage.imagefile from pages inner join headerimage on(pages.headerimageid=headerimage.id) where seopath ="about-us"select id,name,seopath from pages where publish='Y' and parentid=0 order by id
  • Home