Already a member? Click here to Sign In

View Sample Report

New York Metro Office

First Quarter 2013

Metro Trend FREE

VIEW SAMPLE

Purchase This Report

New York Metro Office

Third Quarter 2017

Metro Trend $475.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 11-Dec-17 08:06 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.91.171.137
Host Name 54.91.171.137


Exceptions

08:06:02.002 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
08:06:02.002 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
08:06:06.006 - 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.
	    
08:06:06.006 - 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.
	    
08:06:06.006 - 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.
	    
08:06:06.006 - 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=2ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 08:06:02.002
		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 @ 08:06:02.002
		SELECT REGEXPATTERN,REGEXDESCRIPTION
		FROM PASSWORDREGEXPATTERN
		WHERE PASSWORDREGEXPATTERN_ID = 21
		
getSessionID (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 08:06:02.002
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/wwwroot/Application.cfc @ 08:06:02.002
			INSERT INTO customerRequestLog(
				SESSIONID,
				REQUESTTIME,
				TEMPLATE,
				URL,
				FORM
			)
			VALUES(
				?,
				?,
				?,
				?,
				?
			)
			
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 3AD313640A964682B45B698C6B39559F.axis1
Parameter #2(cf_sql_timestamp) = 2017-12-11 08:06:02.583
Parameter #3(cf_sql_varchar) = /index.cfm
Parameter #4(cf_sql_varchar) = {"state":"NY","sector":"Off","event":"metro.metro3","msa":"NY"}
Parameter #5(cf_sql_varchar) = {}

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
local.getIsEntitled (Datasource=pQuarterlyMinus, Time=3ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 08:06:02.002
			
			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) = NY
Parameter #2(cf_sql_varchar) = NY
Parameter #3(cf_sql_varchar) = Off
Parameter #4(cf_sql_varchar) = Off
Parameter #5(cf_sql_numeric) = 0

local.payperiods (Datasource=pQuarterlyMinus, Time=0ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			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 @ 08:06:02.002
		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) = NY
Parameter #2(cf_sql_varchar) = Off

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=3ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 08:06:02.002
			
			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=0ms, Records=7, Cached Query) in /websiteReisReports/modelglueapp/controller/reisreports/reisreports.cfc @ 08:06:02.002
			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 @ 08:06:02.002
		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) = Off
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 @ 08:06:02.002
		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=0ms, Records=0) in /websiteReisReports/components/com/reis/transaction/CustomerAccounting.cfc @ 08:06:02.002
			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 @ 08:06:02.002
		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 @ 08:06:02.002
				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 @ 08:06:02.002
			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 @ 08:06:02.002
			SELECT 	year, quarter
			FROM 	quarterinfo
		
getSector (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/util/CommonLib.cfc @ 08:06:02.002
			SELECT SECTOR
			FROM REPORT
			WHERE REPORTID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4501

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

equivalentReportIDs (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 4501
Parameter #2(cf_sql_varchar) = Off
Parameter #3(cf_sql_varchar) = Q

getPastTrans (Datasource=pQuarterlyMinus, Time=100ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 4501
Parameter #5(cf_sql_varchar) = NY
Parameter #6(cf_sql_varchar) = Off
Parameter #7(cf_sql_integer) = 0

getReportID (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 08:06:02.002
		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) = Off
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 @ 08:06:02.002
		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 @ 08:06:02.002
			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 @ 08:06:02.002
		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 @ 08:06:02.002
				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 @ 08:06:02.002
			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 @ 08:06:02.002
			SELECT 	year, quarter
			FROM 	quarterinfo
		
getSector (Datasource=pQuarterlyMinus, Time=0ms, Records=1, Cached Query) in /websiteReisReports/components/com/reis/util/CommonLib.cfc @ 08:06:02.002
			SELECT SECTOR
			FROM REPORT
			WHERE REPORTID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6501

getPrice (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 6501
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = H
Parameter #4(cf_sql_varchar) = NY
Parameter #5(cf_sql_varchar) = NY

qryTotalMonths (Datasource=pQuarterlyMinus, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 6501

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

equivalentReportIDs (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 6501
Parameter #2(cf_sql_varchar) = Off
Parameter #3(cf_sql_varchar) = Q

getPastTrans (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 6011
Parameter #5(cf_sql_varchar) = 6501
Parameter #6(cf_sql_varchar) = NY
Parameter #7(cf_sql_varchar) = Off
Parameter #8(cf_sql_integer) = 0
Parameter #9(cf_sql_integer) = 2

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=3ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 08:06:02.002
			
			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) = NY
Parameter #2(cf_sql_varchar) = Off
Parameter #3(cf_sql_numeric) = 0.0

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 08:06:02.002
			
			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) = NY
Parameter #2(cf_sql_varchar) = NY
Parameter #3(cf_sql_varchar) = Off
Parameter #4(cf_sql_varchar) = Off
Parameter #5(cf_sql_numeric) = 0.0

local.getIsEntitled (Datasource=pQuarterlyMinus, Time=4ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 08:06:02.002
			
			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 @ 08:06:02.002
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			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 @ 08:06:02.002
		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) = NY
Parameter #2(cf_sql_varchar) = Off

local.corpParentCorpInfo (Datasource=pQuarterlyMinus, Time=0ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
				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 @ 08:06:02.002
			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 @ 08:06:02.002
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			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 @ 08:06:02.002
		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) = NY
Parameter #2(cf_sql_varchar) = Off

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			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 @ 08:06:02.002
		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) = NY
Parameter #2(cf_sql_varchar) = Off

qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 4501

qryTotalMonths (Datasource=pQuarterlyMinus, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 4501

insOrder (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 29775597
Parameter #2(cf_sql_integer) = 4501
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) = NY
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.91.171.137
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) = Off
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) = 3AD313640A964682B45B698C6B39559F.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=0ms, Records=0) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
				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=0ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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 @ 08:06:02.002
			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) = 6501

qryTotalMonths (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 6501

insOrder (Datasource=pQuarterlyMinus, Time=5ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:02.002
			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) = 29775598
Parameter #2(cf_sql_integer) = 6501
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) = NY
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) = 29775597
Parameter #19(cf_sql_varchar) = 54.91.171.137
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) = Off
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) = 3AD313640A964682B45B698C6B39559F.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 @ 08:06:02.002
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = NY

qryOffer (Datasource=pMonthly, Time=1ms, Records=2) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 08:06:02.002
			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=2ms, Records=1) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 08:06:02.002
			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=0ms, Records=1) in /websiteReisReports/components/com/reisreports2/reportBarrier/reportBarrierDAO.cfc @ 08:06:02.002
			select reisreports_tier 
			from msa 
			where msa = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = NY

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:02.002
			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=3ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 08:06:02.002
		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 @ 08:06:02.002
						SELECT S_CUSTOMERTESTGROUP.nextVal AS nextVal
						FROM DUAL
					
getCurrentDistribution (Datasource=pQuarterlyMinus, Time=3898ms, Records=2) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 08:06:06.006
						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=4ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 08:06:06.006
						INSERT INTO CUSTOMERTESTGROUP(CUSTOMERTESTGROUPID,TESTGROUP,CREATEDATE,USERAGENT,sessionid,ipaddress)
						VALUES(	?,
								?,
								sysdate,
								?,
								?,
								?
								)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 4376166
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = CCBot/2.0 (http://commoncrawl.org/faq/)
Parameter #4(cf_sql_varchar) = 3AD313640A964682B45B698C6B39559F.axis1
Parameter #5(cf_sql_varchar) = 54.91.171.137

updateHits (Datasource=pQuarterlyMinus, Time=7ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 08:06:06.006
				UPDATE
					CUSTOMERTESTGROUP
				SET HITS = HITS + 1
				WHERE CUSTOMERTESTGROUPID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 4376166.0

jobFunctionQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=7) in /websiteReisReports/modelglueapp/controller/reisreports/registration.cfc @ 08:06:06.006
		
		SELECT title AS NAME,
			title AS VALUE
		FROM CUSTOMER_TITLE
		WHERE CORPORATE_ID = 16280034
		ORDER BY NAME
		
getPrice (Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:06.006
			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) = 6501
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = H
Parameter #4(cf_sql_varchar) = NY
Parameter #5(cf_sql_varchar) = NY

getPrice (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/transaction/Transaction.cfc @ 08:06:06.006
			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) = 6501
Parameter #2(cf_sql_varchar) = H
Parameter #3(cf_sql_varchar) = H
Parameter #4(cf_sql_varchar) = NY
Parameter #5(cf_sql_varchar) = NY

RecordSet (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/util/cfo_tags.cfc @ 08:06:06.006
select * from qryToQuery order by discountedPrice asc 
local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:06.006
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 08:06:06.006
			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 @ 08:06:06.006
		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) = NY
Parameter #2(cf_sql_varchar) = Off

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


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=Off&state=NY&msa=NY
REMOTE_ADDR=54.91.171.137
REMOTE_HOST=54.91.171.137
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=B8CAF214-B658-A0AD-ABC7211043657EB4
CUSTOMERTESTGROUPID=4376166
Session Variables:
getpropertyreport=Complex type
getuser=Complex type
googleecommercearr=Array (0)
googleeventarr=Array (0)
haspropertyreport=Complex type
propertyreport=Struct (8)
reportbarriergui=Struct (18)
sessionid=3AD313640A964682B45B698C6B39559F.axis1
setpropertyreport=Complex type
setuser=Complex type
urltoken=CFID=1270083&CFTOKEN=d5e38f4bcb056179-B8CAF1C7-E643-1E0C-07F39FECF7930428&jsessionid=3AD313640A964682B45B698C6B39559F.axis1
user=Struct (99)
URL Parameters:
event=metro.metro3
msa=NY
sector=Off
state=NY
Debug Rendering Time: 8 ms