explain select p.operatorname, p.shortname, p.address, p.city, p.state, p.zip, p.telephone, 
		p.email, p.siteurl, p.rootdomain, p.maxpagerevisions, p.googleid, p.fax, p.subheadertext,
		c.backcolor, c.imageprefix, c.headertextalignment, c.SchemeName, c.footercolor, p.theme, p.locale,
		p.NavBarPosition, p.ContentReviewMailbox, p.SitePrefix, sympathygifts, memorialproducts, p.defaultcondolencemode,
		p.hfstyle, p.siteid, p.dynamicheader, p.dynamicheadertext, p.basedir, h.image as headerimage,
		p.metadescription, p.metakeywords, p.obituaryfontfamily, p.obituaryfontsize, p.obituaryrichtext,
		p.multilocationsonsidebar, p.notifyorders, p.idx as siteidx, p.livebilling, p.sitegroup, p.unifiedlisting,
		p.shortnameinsidebar, h.useimagemap, h.imagemap, p.includecode, p.videotributes, c.innerbackcolor, p.GroupIndependent, 
		c.sidebaraddresscolor, p.suppressnavsidebar, p.wheelchairaccessible, p.navbarscroll, p.customsidebaraddress, p.usflag,
		p.flagmessage, p.newstyleobits, p.favicon
		from colortable c, sitepreferences p, headerimages h
		where c.IDX = p.ColorScheme 
		and h.idx = p.headerid
		and p.siteprefix = 'DMO' ;

explain select AccessRights, SidebarPermitted, SidebarObits, SidebarBooks, SidebarFlowers, IDX
		from subsections where PageURL = '/about/veterans.php' and ( siteid = 350 or siteid = 0 );

explain select sitesection as SID from subsections where PageURL = '/about/veterans.php' and siteid = 350;

explain select s.HeaderItem, ss.IDX as SSID, s.IDX as SID, s.ItemText, PageURL, 
				nav.rootdir, nav.classname, sp.navbargraphic, sp.systemsite, sp.navbargraphiclink, nav.graphical
				from sitesections s, subsections ss, sitepreferences sp, navbarstyle nav
				where s.active=1
				and ss.active=1
				and ss.Navigable=1
				and ( s.AccessRights & 63 ) > 0
				and ( ss.AccessRights & 63 ) > 0
				and ss.sitesection=s.IDX
				and s.siteid = 350
				and sp.siteid = 350
				and sp.navbarstyle = nav.idx
				order by s.ListOrder, ss.ListOrder;

explain select IDX, version from fixedpagecontent 
			where URL = '/about/veterans.php' and Active = 1 and siteid = 350 order by Version asc;

explain select SiteSection, IDX, ItemText, PageTitle from subsections where PageURL = '/about/veterans.php' and siteid = 350 and active=1 order by pagetitle desc;

explain select IDX as SSID, ItemText, PageURL, FixedPage
		from subsections
		where SiteSection = 1843 
		and Active = 1
		and Navigable = 1
		and Suspended = 0 
		and ( AccessRights & 63 ) > 0 
		and siteid = 350
		order by ListOrder;

explain select PageContent, Version
			from fixedpagecontent 
			where active = 1 and URL = '/about/veterans.php' and siteid = 350
			order by version desc;