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 = 26)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	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=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=1020&geoPreference=1&city=&state=&region=&cityName=&stateName=&regionName=&compensation=&compensationName=&start=21&createfile=2&showhide=1&SiteMapFunctionName=Sales&SMGROUP_ID=26&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=4435589 CFTOKEN=bdab1d54a846a508-0351C4CF-F8DE-D0FC-ACE89BF2FE715D76 

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

Session Variables: cfid=4435589 cftoken=bdab1d54a846a508-0351C4CF-F8DE-D0FC-ACE89BF2FE715D76 jobrecon=0 reconwindowsame=1 resultsperpage=20 rsdirectonly=0 rsjava_ok=1 rswindowsame=1 sessionid=RITESITE_4435589_bdab1d54a846a508-0351C4CF-F8DE-D0FC-ACE89BF2FE715D76 urltoken=CFID=4435589&CFTOKEN=bdab1d54a846a508-0351C4CF-F8DE-D0FC-ACE89BF2FE715D76 

URL Parameters: FunctionID=1020 IndustryID=0 RequestTimeout=999999 SMGROUP_ID=26 SiteMapFunctionName=Sales city= cityName= compensation= compensationName= createfile=2 geoPreference=1 page=enter region= regionName= showhide=1 start=21 state= stateName=