SELECT SMGROUP_ID, SMGroup_Name, SMGroup_URL, SMGroup_Index_Page, 
 SMGroup_html_page_title_tag, SMGroup_meta_description, 
 SMGroup_meta_keywords, SMGroup_meta_Author, SMGroup_meta_robots, 
 SMGroup_html_page_heading_H1, SMGroup_SQL_Query, SMGroup_SQL_ResumeID_Query, SMGroup_Preferred_Function
 FROM SITEMAPU_Resume_ByFunction_Groups WHERE (SMGROUP_ID = 35)

 SELECT rs.ResumeID, rs.UniqueKey, rs.Title, rs.ShowGeo, rs.DatePosted, rs.DateUpdated, 
 rs.Summary, rs.Conceal, rs.ResumeAttached, cmp.Compensation, 
 c.CityID, c.CityName, s.State, s.StateName, r.RegionID, r.Region,
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyPriority, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.TitleExpanded, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyUsed
 FROM tblResume rs 
 INNER JOIN lutCompensation cmp ON rs.CompensationID = cmp.CompensationID
 INNER JOIN tblUser u ON rs.UserID = u.UserID
 INNER JOIN tblUrights ur ON u.Urights = ur.UrightsID
 INNER JOIN jntResumeIndPosCmp ripc ON rs.ResumeID = ripc.ResumeID
 INNER JOIN jntIndustryPosition indPos ON ripc.IndustryPositionID = indpos.IndustryPositionID
 INNER JOIN jntCityStateRegion csr ON rs.CityStateRegionID = csr.CityStateRegionID
 INNER JOIN lutRegion r ON csr.Region = r.RegionID
 INNER JOIN lutCity c ON csr.CityID = c.CityID
 INNER JOIN lutState s ON csr.State = s.State
 INNER JOIN dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder ON rs.ResumeID = 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.ResumeID
 WHERE rs.ResumeID IN ( SELECT DISTINCT ResumeID FROM SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder )
 AND rs.DateInactive IS NULL 
 AND rs.DateDeleted IS NULL
 AND rs.DatePosted IS NOT NULL
 AND IsNull(rs.Frozen, 0) = 0
 AND rs.Conceal = 1
 ORDER BY dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyPriority, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.TitleExpanded, 
 dbo.SITEMAPU_Resume_ByFunction_Temporary_Title_Group_InKeyOrder.KeyUsed

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 23026 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 7172 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 54636 

 SELECT PageID, UniqueKey, ResumeID,
 PageFileName, PageType, DiskPath, URL_Index_Page, LastMOD,
 ChangeFreq_sitemap, PagePriority
 FROM SITEMAPU_Resume_ByFunction_Pages
 WHERE ResumeID = 22322 

SelectNamesByIDs (Datasource=ritesite, Time=0ms) in D:\inetpub\wwwroot\ritesite.com\gbl\spSelectNamesByIDs.cfm @ 08:41:28.028

	parameters type CFSQLType value variable dbVarName  IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_CHAR  NULL      IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_INTEGER  NULL      IN  CF_SQL_INTEGER  NULL
	resultsets name resultset  rsSelectNamesByIDs1  1  rsSelectNamesByIDs2  2  rsSelectNamesByIDs3  3  rsSelectNamesByIDs4  4  rsSelectNamesByIDs5  5  rsSelectNamesByIDs6  6

Application Variables: applicationname=RiteSite 

CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE=128 CERT_SECRETKEYSIZE=2048 CERT_SERIALNUMBER= CERT_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert TLS RSA SHA256 2020 CA1 CERT_SERVER_SUBJECT=C=US, S=Mississippi, L=Ocean Springs, O=Ritesite Custom Career Services LLC, CN=www.ritesite.com CERT_SUBJECT= CF_TEMPLATE_PATH=D:\inetpub\wwwroot\ritesite.com\ResumeDatabase\SiteMapping_specific_index_By_Function.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=on HTTPS_KEYSIZE=128 HTTPS_SECRETKEYSIZE=2048 HTTPS_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert TLS RSA SHA256 2020 CA1 HTTPS_SERVER_SUBJECT=C=US, S=Mississippi, L=Ocean Springs, O=Ritesite Custom Career Services LLC, CN=www.ritesite.com HTTP_ACCEPT= HTTP_ACCEPT_ENCODING=gzip,deflate HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION=close HTTP_COOKIE= HTTP_HOST=www.ritesite.com HTTP_REFERER= HTTP_URL= HTTP_USER_AGENT=ColdFusion LOCAL_ADDR=www.ritesite.com PATH_INFO= PATH_TRANSLATED=D:\inetpub\wwwroot\ritesite.com\ResumeDatabase\SiteMapping_specific_index_By_Function.cfm QUERY_STRING=page=enter&IndustryID=0&FunctionID=1022&geoPreference=1&city=&state=&region=&cityName=&stateName=&regionName=&compensation=&compensationName=&start=601&createfile=31&showhide=1&SiteMapFunctionName=Technology&SMGROUP_ID=35&RequestTimeout=999999 REMOTE_ADDR=192.168.1.49 REMOTE_HOST=192.168.1.49 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/ResumeDatabase/SiteMapping_specific_index_By_Function.cfm SERVER_NAME=www.ritesite.com SERVER_PORT=443 SERVER_PORT_SECURE=1 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/8.5 WEB_SERVER_API= 

Cookie Variables: CFID=4182787 CFTOKEN=d8c5f2b38035858c-B9C10831-FD42-2FCA-D07C57464C24BCC7 

Server Variables: coldfusion=Struct (10) os=Struct (5) 

Session Variables: cfid=4182787 cftoken=d8c5f2b38035858c-B9C10831-FD42-2FCA-D07C57464C24BCC7 jobrecon=0 reconwindowsame=1 resultsperpage=20 rsdirectonly=0 rsjava_ok=1 rswindowsame=1 sessionid=RITESITE_4182787_d8c5f2b38035858c-B9C10831-FD42-2FCA-D07C57464C24BCC7 urltoken=CFID=4182787&CFTOKEN=d8c5f2b38035858c-B9C10831-FD42-2FCA-D07C57464C24BCC7 

URL Parameters: FunctionID=1022 IndustryID=0 RequestTimeout=999999 SMGROUP_ID=35 SiteMapFunctionName=Technology city= cityName= compensation= compensationName= createfile=31 geoPreference=1 page=enter region= regionName= showhide=1 start=601 state= stateName=