Already a member? Click here to Sign In

View Sample Report

Greenville Apartment

First Quarter 2013

Metro Trend FREE

VIEW SAMPLE

Purchase This Report

Greenville Apartment

Fourth Quarter 2016

Metro Trend $375.00

PURCHASE REPORT

Start a Premium Subscription

A premium subscription entitles you to muliple reports every month for less than the cost of a single report.
Only $125.00/Month

GET STARTED

Questions? Contact Support

Please wait while your report is being generated…

Once your report has been built, it will open up in a new window.


Debugging Information
ColdFusion Server Enterprise 11,0,05,293506
Template /index.cfm
Time Stamp 24-Mar-17 02:17 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.158.109.89
Host Name 54.158.109.89


Exceptions

02:17:55.055 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
02:17:55.055 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
02:17:59.059 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element canonical is undefined in a CFML structure referenced as part of an expression.
	    
02:17:59.059 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element simplifi is undefined in a CFML structure referenced as part of an expression.
	    
02:17:59.059 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element inlineJS is undefined in a CFML structure referenced as part of an expression.
	    
02:17:59.059 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element underInlineJS is undefined in a CFML structure referenced as part of an expression.
	    


SQL Queries

getSessionID (Datasource=pQuarterly, Time=3ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 02:17:55.055
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
passwordData (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/reisReportsUser/ReisReportsUser.cfc @ 02:17:55.055
		SELECT REGEXPATTERN,REGEXDESCRIPTION
		FROM PASSWORDREGEXPATTERN
		WHERE PASSWORDREGEXPATTERN_ID = 21
		
getSessionID (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 02:17:55.055
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/wwwroot/Application.cfc @ 02:17:55.055
			INSERT INTO customerRequestLog(
				SESSIONID,
				REQUESTTIME,
				TEMPLATE,
				URL,
				FORM
			)
			VALUES(
				?,
				?,
				?,
				?,
				?
			)
			
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 8F78DEAEBC03D08F988C24AA4A4287D8.axis1
Parameter #2(cf_sql_timestamp) = 2017-03-24 02:17:55.711
Parameter #3(cf_sql_varchar) = /index.cfm
Parameter #4(cf_sql_varchar) = {"state":"SC","sector":"Apt","event":"metro.metro3","msa":"GN"}
Parameter #5(cf_sql_varchar) = {}

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
local.getIsEntitled (Datasource=pQuarterlyMinus, Time=4ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
			
			SELECT *
			FROM (
			/*-------------------------------------------------------------------------------*/
			
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
			/*-------------------------------------------------------------------------------*/
			)
			WHERE 
				(
				nvl(MSA,?) = ?
				AND
				nvl(SECTOR,?) = ?
				AND
				ID IS NULL
				AND ISSAMPLE = 'N'	
				)
				OR
				(ISSAMPLE = 'N'	
				 AND id = ?
				)
				
				
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = GN
Parameter #3(cf_sql_varchar) = Apt
Parameter #4(cf_sql_varchar) = Apt
Parameter #5(cf_sql_numeric) = 0

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribedToMSASector (Datasource=, Time=0ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
		SELECT *
		FROM customerPackageDetails
		WHERE
			(
			MSA = ?
			AND
			SECTOR = ?
			AND ISSAMPLE != 'Y'
			)
			OR
			(
			MSA IS NULL
			AND
			SECTOR IS NULL
			AND ISSAMPLE != 'Y'
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = Apt

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=4ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
			
			SELECT *
			FROM (
			/*-------------------------------------------------------------------------------*/
			
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
			/*-------------------------------------------------------------------------------*/
			)
			WHERE 
				(
				ISSAMPLE = 'Y'
				AND
				ID IS NULL				
				)
	
		
sectors (Datasource=pQuarterlyMinus, Time=1ms, Records=6, Cached Query) in /websiteReisReports/modelglueapp/controller/reisreports/reisreports.cfc @ 02:17:55.055
			SELECT *
			FROM SECTOR
			WHERE
				SECTOR <> 'Ind'
				AND
				SECTOR <> 'Hot'
				AND
				SECTOR <> 'Gen'
				AND
				SECTOR <> 'All'
				AND
				SECTOR <> 'Snr'
				AND
				SECTOR <> 'Sth'
				AND
				SECTOR <> 'Aff'
				AND
				SECTOR <> 'Spc'
			ORDER BY SORTORDER	
		
getReportID (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 02:17:55.055
		SELECT
			reportID
		FROM REPORT
		WHERE
			PRODUCTTYPE = ?
			AND
			
					REPORTNAME = ?
					AND
				
			SECTOR = ?
			AND
			NVL(PUBLICATIONFREQUENCY,?) = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = reisReports
Parameter #2(cf_sql_varchar) = PropertyReport
Parameter #3(cf_sql_varchar) = Apt
Parameter #4(cf_sql_varchar) = Q
Parameter #5(cf_sql_varchar) = Q

getCustomerInfo (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reis/transaction/CustomerAccounting.cfc @ 02:17:55.055
		SELECT
			cc.corporate_id,
			DECODE(cc.co_off_id, NULL, 0, cc.co_off_id) AS co_off_id,
			cc.customerid,
			NVL(PARENTCORP.CO_NAME,c.co_name) AS co_name,
			REP.FIRSTNAME || ' ' || REP.LASTNAME AS sales_rep,
			REP.emailAddress AS repEmailAddress,
			c.start_date,
			c.end_date,
			c.prog_type,
			cc.co_administrator,
			cc.status_flag,
			c.dis_percent,
			1 AS isCorporate,
			c.use_parent_funds,
			c.parent_corporate_id
		FROM
			corp_customer cc
			INNER JOIN corporate c ON cc.corporate_id = c.corporate_id
			LEFT JOIN(
				SELECT corporate_id,co_name
				FROM corporate
				WHERE corporate_id NOT IN (?,?,?,?,?,?,?,?)
			) PARENTCORP ON PARENTCORP.corporate_id = c.parent_corporate_id
			LEFT JOIN
			(
				SELECT CORPORATE_ID,SALES_REP_ID
				FROM corp_salesRep
				WHERE IS_PRIMARY = 'Y'
			) CSR ON CSR.CORPORATE_ID = NVL(PARENTCORP.corporate_id,C.CORPORATE_ID)
			LEFT JOIN CUSTOMER REP ON REP.CUSTOMERID = CSR.SALES_REP_ID
		WHERE
			cc.customerid = ?
			AND c.status_flag != 'S'
			AND	cc.status_flag = 'A'
        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 2
Parameter #3(cf_sql_integer) = 3
Parameter #4(cf_sql_integer) = 4
Parameter #5(cf_sql_integer) = 5
Parameter #6(cf_sql_integer) = 6
Parameter #7(cf_sql_integer) = 7
Parameter #8(cf_sql_integer) = 2316711
Parameter #9(cf_sql_integer) = 0

getIndvCustomerInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/CustomerAccounting.cfc @ 02:17:55.055
			SELECT
				cc.customerid,
				cc.corporate_id
			FROM
				corp_customer cc
			WHERE
				cc.customerid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

getCorporateInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/Permissions.cfc @ 02:17:55.055
		SELECT cc.corporate_id,
		 cc.customerid,
		 c.start_date,
		 c.end_date,
		 c.prog_type,
		 cc.co_administrator,
		 cc.status_flag,
		 rc_limit,
		 sc_limit,
		 nc_limit
		FROM corp_customer cc, corporate c
		WHERE cc.customerid = ?
		 AND c.status_flag != 'S'
		 AND cc.status_flag = 'A'
		 AND trunc(SYSDATE) BETWEEN c.start_date AND c.end_date
		 AND cc.corporate_id = c.corporate_id
		 AND co_name <> 'NonSubscriber'  and co_name <> 'NonSubscriberReisReports'
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getNonSubscriberCorp (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/Permissions.cfc @ 02:17:55.055
				SELECT
					corporate_id
				FROM
					corporate
				WHERE
					co_name = 'NonSubscriber'
			
getMereUserInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/Permissions.cfc @ 02:17:55.055
			SELECT cc.corporate_id
			FROM corp_customer cc, corporate c
			WHERE cc.customerid = ?
			AND cc.corporate_id = c.corporate_id
			AND co_name in('NonSubscriber','NonSubscriberReisReports')
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getQuarterInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT 	year, quarter
			FROM 	quarterinfo
		
getSector (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/util/CommonLib.cfc @ 02:17:55.055
			SELECT SECTOR
			FROM REPORT
			WHERE REPORTID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4502

qryIsMonthlyReport (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
				select
					count(1) as cn
				from
					report
				where
					reportid = ?
				and	publicationfrequency =  ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_integer) = 4502
Parameter #2(CF_SQL_VARCHAR) = M

equivalentReportIDs (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT DISTINCT
				reportid
			FROM
				reporttemplateequivalents rte
			LEFT JOIN report r
			ON rte.reportTemplateIDEquivalent = r.reportTemplateID
			WHERE
				rte.reportTemplateID IN (
					SELECT reportTemplateID FROM report
					WHERE reportID = ?
				)
				AND sector = ?
				AND publicationfrequency =
				? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4502
Parameter #2(cf_sql_varchar) = Apt
Parameter #3(cf_sql_varchar) = Q

getPastTrans (Datasource=pQuarterlyMinus, Time=26ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT 	ID
			FROM 	transactions
			WHERE 	customer_id = ? 
				AND 	year = 	?
				AND 	quarter = ? 
			AND 		trans_status = 'C'
			AND 		report_id in (?)
			AND 		(billable = 1 OR is_combo_report = 1)
			AND 		MSA = ?
			AND 		sector = ? 

			
			AND  order_date >= sysdate - ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0
Parameter #2(cf_sql_integer) = 2013
Parameter #3(cf_sql_integer) = 1
Parameter #4(cf_sql_varchar) = 4502
Parameter #5(cf_sql_varchar) = GN
Parameter #6(cf_sql_varchar) = Apt
Parameter #7(cf_sql_integer) = 0

getReportID (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 02:17:55.055
		SELECT
			reportID
		FROM REPORT
		WHERE
			PRODUCTTYPE = ?
			AND
			
			REPORTTEMPLATEID = ?
			AND
			
			SECTOR = ?
			AND
			NVL(PUBLICATIONFREQUENCY,?) = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = reisReports
Parameter #2(cf_sql_numeric) = 5
Parameter #3(cf_sql_varchar) = Apt
Parameter #4(cf_sql_varchar) = Q
Parameter #5(cf_sql_varchar) = Q

getCustomerInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/CustomerAccounting.cfc @ 02:17:55.055
		SELECT
			cc.corporate_id,
			DECODE(cc.co_off_id, NULL, 0, cc.co_off_id) AS co_off_id,
			cc.customerid,
			NVL(PARENTCORP.CO_NAME,c.co_name) AS co_name,
			REP.FIRSTNAME || ' ' || REP.LASTNAME AS sales_rep,
			REP.emailAddress AS repEmailAddress,
			c.start_date,
			c.end_date,
			c.prog_type,
			cc.co_administrator,
			cc.status_flag,
			c.dis_percent,
			1 AS isCorporate,
			c.use_parent_funds,
			c.parent_corporate_id
		FROM
			corp_customer cc
			INNER JOIN corporate c ON cc.corporate_id = c.corporate_id
			LEFT JOIN(
				SELECT corporate_id,co_name
				FROM corporate
				WHERE corporate_id NOT IN (?,?,?,?,?,?,?,?)
			) PARENTCORP ON PARENTCORP.corporate_id = c.parent_corporate_id
			LEFT JOIN
			(
				SELECT CORPORATE_ID,SALES_REP_ID
				FROM corp_salesRep
				WHERE IS_PRIMARY = 'Y'
			) CSR ON CSR.CORPORATE_ID = NVL(PARENTCORP.corporate_id,C.CORPORATE_ID)
			LEFT JOIN CUSTOMER REP ON REP.CUSTOMERID = CSR.SALES_REP_ID
		WHERE
			cc.customerid = ?
			AND c.status_flag != 'S'
			AND	cc.status_flag = 'A'
        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 2
Parameter #3(cf_sql_integer) = 3
Parameter #4(cf_sql_integer) = 4
Parameter #5(cf_sql_integer) = 5
Parameter #6(cf_sql_integer) = 6
Parameter #7(cf_sql_integer) = 7
Parameter #8(cf_sql_integer) = 2316711
Parameter #9(cf_sql_integer) = 0

getIndvCustomerInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/CustomerAccounting.cfc @ 02:17:55.055
			SELECT
				cc.customerid,
				cc.corporate_id
			FROM
				corp_customer cc
			WHERE
				cc.customerid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

getCorporateInfo (Datasource=pQuarterlyMinus, Time=0ms, Records=0) in /websiteReisReports/components/com/reis/Permissions.cfc @ 02:17:55.055
		SELECT cc.corporate_id,
		 cc.customerid,
		 c.start_date,
		 c.end_date,
		 c.prog_type,
		 cc.co_administrator,
		 cc.status_flag,
		 rc_limit,
		 sc_limit,
		 nc_limit
		FROM corp_customer cc, corporate c
		WHERE cc.customerid = ?
		 AND c.status_flag != 'S'
		 AND cc.status_flag = 'A'
		 AND trunc(SYSDATE) BETWEEN c.start_date AND c.end_date
		 AND cc.corporate_id = c.corporate_id
		 AND co_name <> 'NonSubscriber'  and co_name <> 'NonSubscriberReisReports'
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getNonSubscriberCorp (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/Permissions.cfc @ 02:17:55.055
				SELECT
					corporate_id
				FROM
					corporate
				WHERE
					co_name = 'NonSubscriber'
			
getMereUserInfo (Datasource=pQuarterlyMinus, Time=0ms, Records=0, Cached Query) in /websiteReisReports/components/com/reis/Permissions.cfc @ 02:17:55.055
			SELECT cc.corporate_id
			FROM corp_customer cc, corporate c
			WHERE cc.customerid = ?
			AND cc.corporate_id = c.corporate_id
			AND co_name in('NonSubscriber','NonSubscriberReisReports')
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

getQuarterInfo (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT 	year, quarter
			FROM 	quarterinfo
		
getSector (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/util/CommonLib.cfc @ 02:17:55.055
			SELECT SECTOR
			FROM REPORT
			WHERE REPORTID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502

getPrice (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT
				
				price,
				
				partial_price
			FROM
				report_price rp
			WHERE
				reportid = ? 
					AND  NVL( format , ?) = ? 
					
					AND NVL(msa,?) = ? 
			order by msa
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = H
Parameter #4(cf_sql_varchar) = GN
Parameter #5(cf_sql_varchar) = GN

qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			select
				case when publicationfrequency = 'Q' then
					TOTALMONTHSQUARTERLY
				else
					TOTALMONTHSMONTHLY
				end as totalmonths
			from
				report r
				cross join quarterinfo q
			where
				r.reportid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502

qryIsMonthlyReport (Datasource=pQuarterlyMinus, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
				select
					count(1) as cn
				from
					report
				where
					reportid = ?
				and	publicationfrequency =  ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_integer) = 6502
Parameter #2(CF_SQL_VARCHAR) = M

equivalentReportIDs (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT DISTINCT
				reportid
			FROM
				reporttemplateequivalents rte
			LEFT JOIN report r
			ON rte.reportTemplateIDEquivalent = r.reportTemplateID
			WHERE
				rte.reportTemplateID IN (
					SELECT reportTemplateID FROM report
					WHERE reportID = ?
				)
				AND sector = ?
				AND publicationfrequency =
				? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502
Parameter #2(cf_sql_varchar) = Apt
Parameter #3(cf_sql_varchar) = Q

getPastTrans (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT 	ID
			FROM 	transactions
			WHERE 	customer_id = ? 
				AND 	year = 	?
				AND 	quarter = ? 
			AND 		trans_status = 'C'
			AND 		report_id in (?,?)
			AND 		(billable = 1 OR is_combo_report = 1)
			AND 		MSA = ?
			AND 		sector = ? 
				AND 	subid = ? 

			
			AND  order_date >= sysdate - ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0
Parameter #2(cf_sql_integer) = 2013
Parameter #3(cf_sql_integer) = 1
Parameter #4(cf_sql_varchar) = 6012
Parameter #5(cf_sql_varchar) = 6502
Parameter #6(cf_sql_varchar) = GN
Parameter #7(cf_sql_varchar) = Apt
Parameter #8(cf_sql_integer) = 0
Parameter #9(cf_sql_integer) = 2

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=5ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
			
			SELECT *
			FROM (
			/*-------------------------------------------------------------------------------*/
			
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
			/*-------------------------------------------------------------------------------*/
			)
			WHERE 
				(
				MSA = ?
				AND
				SECTOR = ?
				AND
				ID IS NULL
				AND
				ISSUBSCRIPTIONTOKEN = 'N'				
				)
				OR
				(ISSUBSCRIPTIONTOKEN = 'N'	
				 AND id = ?
				)
				
				
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = Apt
Parameter #3(cf_sql_numeric) = 0.0

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=4ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
			
			SELECT *
			FROM (
			/*-------------------------------------------------------------------------------*/
			
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
			/*-------------------------------------------------------------------------------*/
			)
			WHERE 
				(
				nvl(MSA,?) = ?
				AND
				nvl(SECTOR,?) = ?
				AND
				ID IS NULL
				AND ISSAMPLE = 'N'	
				)
				OR
				(ISSAMPLE = 'N'	
				 AND id = ?
				)
				
				
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = GN
Parameter #3(cf_sql_varchar) = Apt
Parameter #4(cf_sql_varchar) = Apt
Parameter #5(cf_sql_numeric) = 0.0

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=5ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
			
			SELECT *
			FROM (
			/*-------------------------------------------------------------------------------*/
			
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
			/*-------------------------------------------------------------------------------*/
			)
			WHERE 
				(
				ISSAMPLE = 'Y'
				AND
				ID IS NULL				
				)
	
		
local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribedToMSASector (Datasource=, Time=0ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
		SELECT *
		FROM customerPackageDetails
		WHERE
			(
			MSA = ?
			AND
			SECTOR = ?
			AND ISSAMPLE != 'Y'
			)
			OR
			(
			MSA IS NULL
			AND
			SECTOR IS NULL
			AND ISSAMPLE != 'Y'
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = Apt

local.corpParentCorpInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
				select
				  PARENT_CORPORATE_ID,
					case when USE_PARENT_FUNDS = 'Y' then
					 parent_corporate_id
					else
						corporate_id
					end as Corporate_id_for_funds
				from
					corporate
				where
					corporate_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

selNextTransId (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT 	S_TRANSACTIONS_ID.nextval AS trans_id
			FROM 	dual
		
local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribedToMSASector (Datasource=, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
		SELECT *
		FROM customerPackageDetails
		WHERE
			(
			MSA = ?
			AND
			SECTOR = ?
			AND ISSAMPLE != 'Y'
			)
			OR
			(
			MSA IS NULL
			AND
			SECTOR IS NULL
			AND ISSAMPLE != 'Y'
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = Apt

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribedToMSASector (Datasource=, Time=0ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
		SELECT *
		FROM customerPackageDetails
		WHERE
			(
			MSA = ?
			AND
			SECTOR = ?
			AND ISSAMPLE != 'Y'
			)
			OR
			(
			MSA IS NULL
			AND
			SECTOR IS NULL
			AND ISSAMPLE != 'Y'
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = Apt

qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			select
				case when publicationfrequency = 'Q' then
					TOTALMONTHSQUARTERLY
				else
					TOTALMONTHSMONTHLY
				end as totalmonths
			from
				report r
				cross join quarterinfo q
			where
				r.reportid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4502

qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			select
				case when publicationfrequency = 'Q' then
					TOTALMONTHSQUARTERLY
				else
					TOTALMONTHSMONTHLY
				end as totalmonths
			from
				report r
				cross join quarterinfo q
			where
				r.reportid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4502

insOrder (Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			INSERT INTO transactions (
				id,
				report_id,
				customer_id,
				corporate_id,
				cc_amount,
				debit_amount,
				subsc_amount,
				order_date,
				discount,
				retail_cost,
				year,
				quarter,
				totalmonths,
				msa,
				subid,
				search_method,
				report_format,
				billable,
				parent_trans_id,
				trans_status,
				usage_track,
				full_sc_records,
				partial_sc_records,
				num_rent_comp_records,
				is_redownload,
				sector,
				is_combo_report,
				num_child_reports,
				net_cost,
				secondary_parent_trans_id,
				comp_subject_id,
				isFull,
				balance,
				report_vintage,
				sessionID,
				pnref,
				PayPalProfileID,
				producttype,
				is_custom_report,
				parent_corporate_id,
				Corporate_id_for_funds
			) VALUES (
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				sysdate,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				'I',
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				NULL,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27114247
Parameter #2(cf_sql_integer) = 4502
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) =
Parameter #5(cf_sql_numeric) = 0
Parameter #6(cf_sql_numeric) = 0
Parameter #7(cf_sql_numeric) = 0
Parameter #8(cf_sql_numeric) = 0
Parameter #9(cf_sql_numeric) = 0
Parameter #10(cf_sql_integer) = 2013
Parameter #11(cf_sql_integer) = 1
Parameter #12(cf_sql_integer) = 24159
Parameter #13(cf_sql_varchar) = GN
Parameter #14(cf_sql_integer) =
Parameter #15(cf_sql_varchar) =
Parameter #16(cf_sql_varchar) = H
Parameter #17(cf_sql_integer) = 0
Parameter #18(cf_sql_integer) =
Parameter #19(cf_sql_varchar) = 54.158.109.89
Parameter #20(cf_sql_integer) =
Parameter #21(cf_sql_integer) =
Parameter #22(cf_sql_integer) =
Parameter #23(cf_sql_integer) = 0
Parameter #24(cf_sql_varchar) = Apt
Parameter #25(cf_sql_integer) = 0
Parameter #26(cf_sql_integer) = 1
Parameter #27(cf_sql_numeric) = 0
Parameter #28(cf_sql_integer) =
Parameter #29(cf_sql_integer) =
Parameter #30(cf_sql_integer) = 1
Parameter #31(cf_sql_date) =
Parameter #32(cf_sql_varchar) = 8F78DEAEBC03D08F988C24AA4A4287D8.axis1
Parameter #33(cf_sql_varchar) =
Parameter #34(cf_sql_integer) =
Parameter #35(cf_sql_varchar) = RFSB
Parameter #36(cf_sql_integer) = 0
Parameter #37(cf_sql_integer) =
Parameter #38(cf_sql_integer) =

local.corpParentCorpInfo (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
				select
				  PARENT_CORPORATE_ID,
					case when USE_PARENT_FUNDS = 'Y' then
					 parent_corporate_id
					else
						corporate_id
					end as Corporate_id_for_funds
				from
					corporate
				where
					corporate_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

selNextTransId (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			SELECT 	S_TRANSACTIONS_ID.nextval AS trans_id
			FROM 	dual
		
qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			select
				case when publicationfrequency = 'Q' then
					TOTALMONTHSQUARTERLY
				else
					TOTALMONTHSMONTHLY
				end as totalmonths
			from
				report r
				cross join quarterinfo q
			where
				r.reportid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502

qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			select
				case when publicationfrequency = 'Q' then
					TOTALMONTHSQUARTERLY
				else
					TOTALMONTHSMONTHLY
				end as totalmonths
			from
				report r
				cross join quarterinfo q
			where
				r.reportid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502

insOrder (Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:55.055
			INSERT INTO transactions (
				id,
				report_id,
				customer_id,
				corporate_id,
				cc_amount,
				debit_amount,
				subsc_amount,
				order_date,
				discount,
				retail_cost,
				year,
				quarter,
				totalmonths,
				msa,
				subid,
				search_method,
				report_format,
				billable,
				parent_trans_id,
				trans_status,
				usage_track,
				full_sc_records,
				partial_sc_records,
				num_rent_comp_records,
				is_redownload,
				sector,
				is_combo_report,
				num_child_reports,
				net_cost,
				secondary_parent_trans_id,
				comp_subject_id,
				isFull,
				balance,
				report_vintage,
				sessionID,
				pnref,
				PayPalProfileID,
				producttype,
				is_custom_report,
				parent_corporate_id,
				Corporate_id_for_funds
			) VALUES (
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				sysdate,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				'I',
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				NULL,
				?,
				?,
				?,
				?,
				?,
				?,
				?,
				?
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27114248
Parameter #2(cf_sql_integer) = 6502
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) =
Parameter #5(cf_sql_numeric) = 0
Parameter #6(cf_sql_numeric) = 0
Parameter #7(cf_sql_numeric) = 0
Parameter #8(cf_sql_numeric) = 0
Parameter #9(cf_sql_numeric) = 0
Parameter #10(cf_sql_integer) = 2013
Parameter #11(cf_sql_integer) = 1
Parameter #12(cf_sql_integer) = 24159
Parameter #13(cf_sql_varchar) = GN
Parameter #14(cf_sql_integer) = 0
Parameter #15(cf_sql_varchar) =
Parameter #16(cf_sql_varchar) = H
Parameter #17(cf_sql_integer) = 0
Parameter #18(cf_sql_integer) = 27114247
Parameter #19(cf_sql_varchar) = 54.158.109.89
Parameter #20(cf_sql_integer) =
Parameter #21(cf_sql_integer) =
Parameter #22(cf_sql_integer) =
Parameter #23(cf_sql_integer) = 0
Parameter #24(cf_sql_varchar) = Apt
Parameter #25(cf_sql_integer) = 0
Parameter #26(cf_sql_integer) = 0
Parameter #27(cf_sql_numeric) = 0
Parameter #28(cf_sql_integer) =
Parameter #29(cf_sql_integer) =
Parameter #30(cf_sql_integer) = 1
Parameter #31(cf_sql_date) =
Parameter #32(cf_sql_varchar) = 8F78DEAEBC03D08F988C24AA4A4287D8.axis1
Parameter #33(cf_sql_varchar) =
Parameter #34(cf_sql_integer) =
Parameter #35(cf_sql_varchar) = RFSB
Parameter #36(cf_sql_integer) = 0
Parameter #37(cf_sql_integer) =
Parameter #38(cf_sql_integer) =

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 02:17:55.055
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = SC

qryOffer (Datasource=pMonthly, Time=29ms, Records=2) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 02:17:55.055
			SELECT 	
					o.OFFERNAME, 
					o.INCLUDEDREPORTS, 
					o.ADDITIONALSECTORDISCOUNT, 
					o.PURCHASEDREPORTDISCOUNT, 
					o.CREATEDATE, 
					o.UPDATEDATE,
					op.OfferPriceId,
					op.PAYPERIODID,
					op.TIER1MSAPRICE,
					op.TIER2MSAPRICE,
					op.TIER3MSAPRICE,
					op.TIER1REPORTPRICE,
					op.TIER2REPORTPRICE,
					op.TIER3REPORTPRICE,
					o.ISLOCAL
			FROM	offer o
				join offerPrice op on o.offerId = op.offerId
			WHERE o.offerid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3

(Datasource=pMonthly, Time=4ms, Records=1) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 02:17:55.055
			INSERT INTO CUSTOMERPACKAGEOFFER (CUSTOMERPACKAGEOFFERID,
							CUSTOMERPACKAGEID,
							OFFERPRICEID,
							CREATEDATE)
			SELECT LOCALPACKAGE.nextval, (select CUSTOMERPACKAGEID from CUSTOMERPACKAGE where customerid = ?), ?, sysdate
			  FROM dual
			 WHERE NOT EXISTS (select 1 from (
									select 	cp.CUSTOMERPACKAGEID,
											cp.CUSTOMERID,
											cp.PAYPALPROFILEID,
											cpo.CUSTOMERPACKAGEOFFERID,
											cpo.OFFERPRICEID,
											op.offerId,
											ROW_NUMBER() OVER (PARTITION BY CUSTOMERID ORDER BY cpo.createDATE DESC, CUSTOMERPACKAGEOFFERID DESC) latest
									from customerpackage cp
										join CUSTOMERPACKAGEOFFER cpo on cp.customerpackageid = cpo.customerpackageid
										join OfferPrice op on cpo.offerpriceid = op.offerpriceid
									where customerid = ?
									)
									where latest = 1
									and offerpriceid = ?
			                  	)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0
Parameter #2(cf_sql_integer) = 6
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) = 6

qryMsaTier (Datasource=pMonthly, Time=1ms, Records=1) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 02:17:55.055
			select reisreports_tier 
			from msa 
			where msa = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:55.055
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribed (Datasource=pQuarterlyMinus, Time=4ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:55.055
		SELECT *
		FROM (
		
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
		)
		WHERE
			ISSAMPLE != 'Y'
			AND ISSUBSCRIPTIONTOKEN != 'N'
		
getCustomerTestGroupID (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 02:17:55.055
						SELECT S_CUSTOMERTESTGROUP.nextVal AS nextVal
						FROM DUAL
					
getCurrentDistribution (Datasource=pQuarterlyMinus, Time=3537ms, Records=2) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 02:17:59.059
						SELECT
							NVL( DATA.TESTGROUP , SKELETON.TESTGROUP ) TESTGROUP,
							NVL( DATA.TESTGROUPPERCENT , SKELETON.TESTGROUPPERCENT ) TESTGROUPPERCENT
						FROM
						(
							SELECT 'A' AS TESTGROUP,-1  AS TESTGROUPPERCENT
							FROM DUAL
							UNION
							SELECT 'B',-1
							FROM DUAL
							UNION
							SELECT 'C',-1
							FROM DUAL
							UNION
							SELECT 'E',-1
							FROM DUAL
							UNION
							SELECT 'F',-1
							FROM DUAL
							UNION
							SELECT 'G',-1
							FROM DUAL
							UNION
							SELECT 'H',-1
							
							FROM DUAL
						) SKELETON
						LEFT JOIN
						(
							SELECT
								TESTGROUP,
								GROUPCOUNT/ROWCOUNT TESTGROUPPERCENT
							FROM (
								SELECT
									DISTINCT
									TESTGROUP,
								    COUNT(*) OVER (PARTITION BY TESTGROUP) GROUPCOUNT,
								    COUNT(*) OVER (PARTITION BY NULL) ROWCOUNT
								FROM CUSTOMERTESTGROUP
								WHERE createDate > TO_DATE('08/28/2014 02:38 P.M.','mm/dd/YYYY HH:MI A.M.')
								AND TESTGROUP in ('G','H')
							)
						) DATA
						ON SKELETON.TESTGROUP = DATA.TESTGROUP
						where SKELETON.TESTGROUP in ('G','H')
						ORDER BY SKELETON.TESTGROUP
					
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 02:17:59.059
						INSERT INTO CUSTOMERTESTGROUP(CUSTOMERTESTGROUPID,TESTGROUP,CREATEDATE,USERAGENT,sessionid,ipaddress)
						VALUES(	?,
								?,
								sysdate,
								?,
								?,
								?
								)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 3600705
Parameter #2(cf_sql_varchar) = G
Parameter #3(cf_sql_varchar) = CCBot/2.0 (http://commoncrawl.org/faq/)
Parameter #4(cf_sql_varchar) = 8F78DEAEBC03D08F988C24AA4A4287D8.axis1
Parameter #5(cf_sql_varchar) = 54.158.109.89

updateHits (Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 02:17:59.059
				UPDATE
					CUSTOMERTESTGROUP
				SET HITS = HITS + 1
				WHERE CUSTOMERTESTGROUPID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 3600705.0

jobFunctionQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=7) in /websiteReisReports/modelglueapp/controller/reisreports/registration.cfc @ 02:17:59.059
		
		SELECT title AS NAME,
			title AS VALUE
		FROM CUSTOMER_TITLE
		WHERE CORPORATE_ID = 16280034
		ORDER BY NAME
		
getPrice (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:59.059
			SELECT
				
				REISREPORTS_price as price,
				
				partial_price
			FROM
				report_price rp
			WHERE
				reportid = ? 
					AND  NVL( format , ?) = ? 
					
					AND NVL(msa,?) = ? 
			order by msa
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = H
Parameter #4(cf_sql_varchar) = GN
Parameter #5(cf_sql_varchar) = GN

getPrice (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 02:17:59.059
			SELECT
				
				REISREPORTS_price as price,
				
				partial_price
			FROM
				report_price rp
			WHERE
				reportid = ? 
					AND  NVL( format , ?) = ? 
					
					AND NVL(msa,?) = ? 
			order by msa
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6502
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = H
Parameter #4(cf_sql_varchar) = GN
Parameter #5(cf_sql_varchar) = GN

RecordSet (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/util/cfo_tags.cfc @ 02:17:59.059
select * from qryToQuery order by discountedPrice asc 
local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:59.059
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 02:17:59.059
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribedToMSASector (Datasource=, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 02:17:59.059
		SELECT *
		FROM customerPackageDetails
		WHERE
			(
			MSA = ?
			AND
			SECTOR = ?
			AND ISSAMPLE != 'Y'
			)
			OR
			(
			MSA IS NULL
			AND
			SECTOR IS NULL
			AND ISSAMPLE != 'Y'
			)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN
Parameter #2(cf_sql_varchar) = Apt

qryMsaTier (Datasource=pMonthly, Time=1ms, Records=1) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 02:17:59.059
			select reisreports_tier 
			from msa 
			where msa = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GN


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/websiteReisReports/wwwroot/reisreports2/index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=rr.reis.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/websiteReisReports/wwwroot/reisreports2/index.cfm
QUERY_STRING=event=metro.metro3&sector=Apt&state=SC&msa=GN
REMOTE_ADDR=54.158.109.89
REMOTE_HOST=54.158.109.89
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=rr.reis.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_jk/1.2.40
WEB_SERVER_API=
Cookie Variables:
CLIENTID=F593B7F4-CEB1-0E0C-54701486E64E26C1
CUSTOMERTESTGROUPID=3600705
Session Variables:
getpropertyreport=Complex type
getuser=Complex type
googleecommercearr=Array (0)
googleeventarr=Array (0)
haspropertyreport=Complex type
propertyreport=Struct (8)
reportbarriergui=Struct (18)
sessionid=8F78DEAEBC03D08F988C24AA4A4287D8.axis1
setpropertyreport=Complex type
setuser=Complex type
urltoken=CFID=1022042&CFTOKEN=3cb8025092f6ab41-F593B778-A286-E606-1CB03694C2637C1E&jsessionid=8F78DEAEBC03D08F988C24AA4A4287D8.axis1
user=Struct (99)
URL Parameters:
event=metro.metro3
msa=GN
sector=Apt
state=SC
Debug Rendering Time: 9 ms