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 = 75578 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SelectNamesByIDs (Datasource=ritesite, Time=0ms) in D:\inetpub\wwwroot\ritesite.com\gbl\spSelectNamesByIDs.cfm @ 13:01:29.029

	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.mcdanielcontrols.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=441&createfile=23&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=5730646 CFTOKEN=7736b242fcec8dc1-B8905CF5-C004-8046-B4638122E41E4D52 

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

Session Variables: cfid=5730646 cftoken=7736b242fcec8dc1-B8905CF5-C004-8046-B4638122E41E4D52 jobrecon=0 reconwindowsame=1 resultsperpage=20 rsdirectonly=0 rsjava_ok=1 rswindowsame=1 sessionid=RITESITE_5730646_7736b242fcec8dc1-B8905CF5-C004-8046-B4638122E41E4D52 urltoken=CFID=5730646&CFTOKEN=7736b242fcec8dc1-B8905CF5-C004-8046-B4638122E41E4D52 

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