select s.sectionid, s.name, s.uri, substring( s.uri, charindex( '=', s.uri ) + 1, len( s.uri ) ) as setname, s.parentsectionid, s.requiredpermission, s.displayRank, s.live from fsenablers..tbl_CUS_WebsiteSections s inner join fsenablers..tbl_CUS_Websites w on s.websiteid = w.websiteid where w.websiteid = and s.channel = 'FOODSERVICE' and ( or s.uri = '/apps/CDA/index.cfm?set=#_setname#' ) or s.sectionId in ( select distinct parentSectionId from fsenablers..tbl_CUS_WebsiteSections where websiteId = and s.channel = 'FOODSERVICE' and ( or uri = '/apps/CDA/index.cfm?set=#_setname#' ) )

Dashboard
Add New Section
Nav Menu	Others

Click the link above to see configuration options