BROWSE ALL PRIVY 5 SAN FRANCISCO LISTINGS

  • where to eat
  • where to drink
  • where to sleep
  • where to play
  • where to shop
  • where to relax


Debugging Information
ColdFusion Server Standard 2016,0,10,314028
Template /sanfrancisco/index.cfm
Time Stamp 23-Dec-19 10:04 AM
Locale English (US)
User Agent Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote IP 172.6.167.56
Host Name 172.6.167.56


Execution Time

Total Time Avg Time Count Template
42328 ms 42328 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequest(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
33690 ms 33690 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | listing(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
8446 ms 8446 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
8446 ms 8446 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
181 ms 181 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
171 ms 171 ms 1 D:/www/privy/sanfrancisco/views/go/listing.cfm
129 ms 129 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_listing.cfm
18 ms 18 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestStart(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
15 ms 15 ms 1 D:/www/privy/sanfrancisco/layouts/go.cfm
6 ms 6 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
5 ms 3 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
0 ms 0 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | ip4todecimal(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | onRequestEnd(/sanfrancisco/index.cfm) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.listing, cityguide_listing) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/sanfrancisco/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | init(CFC: sanfrancisco.Application) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/sanfrancisco/controllers/go.cfc | listing(rc = [complex value]) ] from D:/www/privy/sanfrancisco/controllers/go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
14 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
42360 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 10:04:15.015
		SELECT directoryurl,whereto 
		FROM privy5codes 
		WHERE (shortenedurl=?) AND 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go/listing
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getwebpg (Datasource=entre360ds, Time=181ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:04:15.015
				SELECT * FROM webpg_event WHERE name = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = go,listing

local.checksession (Datasource=entre360ds, Time=3290ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 10:04:19.019
	SELECT memberguests_login.sessionid 
	FROM memberguests_login 
	WHERE sessionid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB

local.getlogininfo (Datasource=entre360ds, Time=4969ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 10:04:24.024
	SELECT 
		memberguests_login.memberid,
	 	memberguests_login.logindatetime,
	 	memberguests_login.loginvia,
	 	memberguests_login.logoutdatetime,
	 	memberguests_login.sessionid,
	 	memberguests_login.fbuid,
	 	memberguests_login.fbaccesstoken,
	 	memberguests_login.fbsignedrequest,
	 	memberguests_login.fbexpiresin,
	 	memberguests_login.fbpicture,
	 	memberguests_login.logininviteonly 
	FROM memberguests_login 
	WHERE sessionid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB

local.getdb (Datasource=entre360ds, Time=3ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:04:24.024
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176

local.getp5codes (Datasource=entre360ds, Time=36ms, Records=36) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:24.024
					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = eat
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=240ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:24.024
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '1' OR
						privy5codes LIKE '1,%' OR
						privy5codes LIKE '%,1' OR 
						privy5codes LIKE '%,1,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=316ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:24.024
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '125' OR
						privy5codes LIKE '125,%' OR
						privy5codes LIKE '%,125' OR 
						privy5codes LIKE '%,125,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=365ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:25.025
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '3' OR
						privy5codes LIKE '3,%' OR
						privy5codes LIKE '%,3' OR 
						privy5codes LIKE '%,3,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=752ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:25.025
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '7' OR
						privy5codes LIKE '7,%' OR
						privy5codes LIKE '%,7' OR 
						privy5codes LIKE '%,7,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=238ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:26.026
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '8' OR
						privy5codes LIKE '8,%' OR
						privy5codes LIKE '%,8' OR 
						privy5codes LIKE '%,8,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=233ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:26.026
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '9' OR
						privy5codes LIKE '9,%' OR
						privy5codes LIKE '%,9' OR 
						privy5codes LIKE '%,9,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=225ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:26.026
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '12' OR
						privy5codes LIKE '12,%' OR
						privy5codes LIKE '%,12' OR 
						privy5codes LIKE '%,12,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=382ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:26.026
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '13' OR
						privy5codes LIKE '13,%' OR
						privy5codes LIKE '%,13' OR 
						privy5codes LIKE '%,13,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=743ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:27.027
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '14' OR
						privy5codes LIKE '14,%' OR
						privy5codes LIKE '%,14' OR 
						privy5codes LIKE '%,14,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=200ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:27.027
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '15' OR
						privy5codes LIKE '15,%' OR
						privy5codes LIKE '%,15' OR 
						privy5codes LIKE '%,15,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=262ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:28.028
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '17' OR
						privy5codes LIKE '17,%' OR
						privy5codes LIKE '%,17' OR 
						privy5codes LIKE '%,17,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=894ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:28.028
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '18' OR
						privy5codes LIKE '18,%' OR
						privy5codes LIKE '%,18' OR 
						privy5codes LIKE '%,18,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=189ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:29.029
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '19' OR
						privy5codes LIKE '19,%' OR
						privy5codes LIKE '%,19' OR 
						privy5codes LIKE '%,19,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=679ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:29.029
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '22' OR
						privy5codes LIKE '22,%' OR
						privy5codes LIKE '%,22' OR 
						privy5codes LIKE '%,22,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=712ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:30.030
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '50' OR
						privy5codes LIKE '50,%' OR
						privy5codes LIKE '%,50' OR 
						privy5codes LIKE '%,50,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=393ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:30.030
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '23' OR
						privy5codes LIKE '23,%' OR
						privy5codes LIKE '%,23' OR 
						privy5codes LIKE '%,23,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=243ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:31.031
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '27' OR
						privy5codes LIKE '27,%' OR
						privy5codes LIKE '%,27' OR 
						privy5codes LIKE '%,27,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=267ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:31.031
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '28' OR
						privy5codes LIKE '28,%' OR
						privy5codes LIKE '%,28' OR 
						privy5codes LIKE '%,28,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=418ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:31.031
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '29' OR
						privy5codes LIKE '29,%' OR
						privy5codes LIKE '%,29' OR 
						privy5codes LIKE '%,29,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=861ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:32.032
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '30' OR
						privy5codes LIKE '30,%' OR
						privy5codes LIKE '%,30' OR 
						privy5codes LIKE '%,30,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=715ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:33.033
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '31' OR
						privy5codes LIKE '31,%' OR
						privy5codes LIKE '%,31' OR 
						privy5codes LIKE '%,31,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=690ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:34.034
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '33' OR
						privy5codes LIKE '33,%' OR
						privy5codes LIKE '%,33' OR 
						privy5codes LIKE '%,33,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=503ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:34.034
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '35' OR
						privy5codes LIKE '35,%' OR
						privy5codes LIKE '%,35' OR 
						privy5codes LIKE '%,35,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=332ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:34.034
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '38' OR
						privy5codes LIKE '38,%' OR
						privy5codes LIKE '%,38' OR 
						privy5codes LIKE '%,38,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=1209ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:36.036
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '39' OR
						privy5codes LIKE '39,%' OR
						privy5codes LIKE '%,39' OR 
						privy5codes LIKE '%,39,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=73ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:36.036
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '42' OR
						privy5codes LIKE '42,%' OR
						privy5codes LIKE '%,42' OR 
						privy5codes LIKE '%,42,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=680ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:36.036
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '43' OR
						privy5codes LIKE '43,%' OR
						privy5codes LIKE '%,43' OR 
						privy5codes LIKE '%,43,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=219ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '2' OR
						privy5codes LIKE '2,%' OR
						privy5codes LIKE '%,2' OR 
						privy5codes LIKE '%,2,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=94ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '44' OR
						privy5codes LIKE '44,%' OR
						privy5codes LIKE '%,44' OR 
						privy5codes LIKE '%,44,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=73ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '45' OR
						privy5codes LIKE '45,%' OR
						privy5codes LIKE '%,45' OR 
						privy5codes LIKE '%,45,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=71ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '51' OR
						privy5codes LIKE '51,%' OR
						privy5codes LIKE '%,51' OR 
						privy5codes LIKE '%,51,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=58ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '53' OR
						privy5codes LIKE '53,%' OR
						privy5codes LIKE '%,53' OR 
						privy5codes LIKE '%,53,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=58ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '60' OR
						privy5codes LIKE '60,%' OR
						privy5codes LIKE '%,60' OR 
						privy5codes LIKE '%,60,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=66ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '54' OR
						privy5codes LIKE '54,%' OR
						privy5codes LIKE '%,54' OR 
						privy5codes LIKE '%,54,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=62ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '56' OR
						privy5codes LIKE '56,%' OR
						privy5codes LIKE '%,56' OR 
						privy5codes LIKE '%,56,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=64ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '55' OR
						privy5codes LIKE '55,%' OR
						privy5codes LIKE '%,55' OR 
						privy5codes LIKE '%,55,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getp5codes (Datasource=entre360ds, Time=4ms, Records=7) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = drink
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=79ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:37.037
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '5' OR
						privy5codes LIKE '5,%' OR
						privy5codes LIKE '%,5' OR 
						privy5codes LIKE '%,5,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=354ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:38.038
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '6' OR
						privy5codes LIKE '6,%' OR
						privy5codes LIKE '%,6' OR 
						privy5codes LIKE '%,6,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=166ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:38.038
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '20' OR
						privy5codes LIKE '20,%' OR
						privy5codes LIKE '%,20' OR 
						privy5codes LIKE '%,20,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=362ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:38.038
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '21' OR
						privy5codes LIKE '21,%' OR
						privy5codes LIKE '%,21' OR 
						privy5codes LIKE '%,21,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=523ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:39.039
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '26' OR
						privy5codes LIKE '26,%' OR
						privy5codes LIKE '%,26' OR 
						privy5codes LIKE '%,26,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=357ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:39.039
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '57' OR
						privy5codes LIKE '57,%' OR
						privy5codes LIKE '%,57' OR 
						privy5codes LIKE '%,57,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=349ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:39.039
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '58' OR
						privy5codes LIKE '58,%' OR
						privy5codes LIKE '%,58' OR 
						privy5codes LIKE '%,58,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getp5codes (Datasource=entre360ds, Time=19ms, Records=2) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:39.039
					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = sleep
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=308ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:40.040
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '25' OR
						privy5codes LIKE '25,%' OR
						privy5codes LIKE '%,25' OR 
						privy5codes LIKE '%,25,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=763ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '24' OR
						privy5codes LIKE '24,%' OR
						privy5codes LIKE '%,24' OR 
						privy5codes LIKE '%,24,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getp5codes (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = play
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=167ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '4' OR
						privy5codes LIKE '4,%' OR
						privy5codes LIKE '%,4' OR 
						privy5codes LIKE '%,4,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getp5codes (Datasource=entre360ds, Time=20ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = shop
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=133ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '46' OR
						privy5codes LIKE '46,%' OR
						privy5codes LIKE '%,46' OR 
						privy5codes LIKE '%,46,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getp5codes (Datasource=entre360ds, Time=15ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = relax
Parameter #2(CF_SQL_CHAR) = San Francisco
Parameter #3(CF_SQL_CHAR) = San Francisco,%
Parameter #4(CF_SQL_CHAR) = %,San Francisco
Parameter #5(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=188ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '47' OR
						privy5codes LIKE '47,%' OR
						privy5codes LIKE '%,47' OR 
						privy5codes LIKE '%,47,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getp5codes (Datasource=entre360ds, Time=23ms, Records=42) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT * 
					FROM privy5codes 
					WHERE  
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember=1 AND P5=1
					ORDER BY Category	
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco
Parameter #2(CF_SQL_CHAR) = San Francisco,%
Parameter #3(CF_SQL_CHAR) = %,San Francisco
Parameter #4(CF_SQL_CHAR) = %,San Francisco,%

local.getrelatedlocation (Datasource=entre360ds, Time=199ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:41.041
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '204' OR
						privy5codes LIKE '204,%' OR
						privy5codes LIKE '%,204' OR 
						privy5codes LIKE '%,204,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=435ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:42.042
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '179' OR
						privy5codes LIKE '179,%' OR
						privy5codes LIKE '%,179' OR 
						privy5codes LIKE '%,179,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=569ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:42.042
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '174' OR
						privy5codes LIKE '174,%' OR
						privy5codes LIKE '%,174' OR 
						privy5codes LIKE '%,174,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=670ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:43.043
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '148' OR
						privy5codes LIKE '148,%' OR
						privy5codes LIKE '%,148' OR 
						privy5codes LIKE '%,148,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=556ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:44.044
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '205' OR
						privy5codes LIKE '205,%' OR
						privy5codes LIKE '%,205' OR 
						privy5codes LIKE '%,205,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=181ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:44.044
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '185' OR
						privy5codes LIKE '185,%' OR
						privy5codes LIKE '%,185' OR 
						privy5codes LIKE '%,185,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=187ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:44.044
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '188' OR
						privy5codes LIKE '188,%' OR
						privy5codes LIKE '%,188' OR 
						privy5codes LIKE '%,188,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=135ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:44.044
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '183' OR
						privy5codes LIKE '183,%' OR
						privy5codes LIKE '%,183' OR 
						privy5codes LIKE '%,183,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=230ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:44.044
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '155' OR
						privy5codes LIKE '155,%' OR
						privy5codes LIKE '%,155' OR 
						privy5codes LIKE '%,155,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=120ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:44.044
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '99' OR
						privy5codes LIKE '99,%' OR
						privy5codes LIKE '%,99' OR 
						privy5codes LIKE '%,99,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=235ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:45.045
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '162' OR
						privy5codes LIKE '162,%' OR
						privy5codes LIKE '%,162' OR 
						privy5codes LIKE '%,162,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=174ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:45.045
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '160' OR
						privy5codes LIKE '160,%' OR
						privy5codes LIKE '%,160' OR 
						privy5codes LIKE '%,160,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=231ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:45.045
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '176' OR
						privy5codes LIKE '176,%' OR
						privy5codes LIKE '%,176' OR 
						privy5codes LIKE '%,176,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=373ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:45.045
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '180' OR
						privy5codes LIKE '180,%' OR
						privy5codes LIKE '%,180' OR 
						privy5codes LIKE '%,180,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=328ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:46.046
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '117' OR
						privy5codes LIKE '117,%' OR
						privy5codes LIKE '%,117' OR 
						privy5codes LIKE '%,117,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=677ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:46.046
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '195' OR
						privy5codes LIKE '195,%' OR
						privy5codes LIKE '%,195' OR 
						privy5codes LIKE '%,195,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=731ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:47.047
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '151' OR
						privy5codes LIKE '151,%' OR
						privy5codes LIKE '%,151' OR 
						privy5codes LIKE '%,151,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=380ms, Records=3) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:48.048
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '169' OR
						privy5codes LIKE '169,%' OR
						privy5codes LIKE '%,169' OR 
						privy5codes LIKE '%,169,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=340ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:48.048
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '182' OR
						privy5codes LIKE '182,%' OR
						privy5codes LIKE '%,182' OR 
						privy5codes LIKE '%,182,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=224ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:48.048
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '181' OR
						privy5codes LIKE '181,%' OR
						privy5codes LIKE '%,181' OR 
						privy5codes LIKE '%,181,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=283ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:48.048
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '186' OR
						privy5codes LIKE '186,%' OR
						privy5codes LIKE '%,186' OR 
						privy5codes LIKE '%,186,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=892ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:49.049
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '158' OR
						privy5codes LIKE '158,%' OR
						privy5codes LIKE '%,158' OR 
						privy5codes LIKE '%,158,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=610ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:50.050
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '184' OR
						privy5codes LIKE '184,%' OR
						privy5codes LIKE '%,184' OR 
						privy5codes LIKE '%,184,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=756ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '140' OR
						privy5codes LIKE '140,%' OR
						privy5codes LIKE '%,140' OR 
						privy5codes LIKE '%,140,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=67ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '101' OR
						privy5codes LIKE '101,%' OR
						privy5codes LIKE '%,101' OR 
						privy5codes LIKE '%,101,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=91ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '165' OR
						privy5codes LIKE '165,%' OR
						privy5codes LIKE '%,165' OR 
						privy5codes LIKE '%,165,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=100ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '104' OR
						privy5codes LIKE '104,%' OR
						privy5codes LIKE '%,104' OR 
						privy5codes LIKE '%,104,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=75ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '91' OR
						privy5codes LIKE '91,%' OR
						privy5codes LIKE '%,91' OR 
						privy5codes LIKE '%,91,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=94ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '156' OR
						privy5codes LIKE '156,%' OR
						privy5codes LIKE '%,156' OR 
						privy5codes LIKE '%,156,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=267ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:51.051
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '175' OR
						privy5codes LIKE '175,%' OR
						privy5codes LIKE '%,175' OR 
						privy5codes LIKE '%,175,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=205ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:52.052
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '192' OR
						privy5codes LIKE '192,%' OR
						privy5codes LIKE '%,192' OR 
						privy5codes LIKE '%,192,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=246ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:52.052
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '190' OR
						privy5codes LIKE '190,%' OR
						privy5codes LIKE '%,190' OR 
						privy5codes LIKE '%,190,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=272ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:52.052
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '153' OR
						privy5codes LIKE '153,%' OR
						privy5codes LIKE '%,153' OR 
						privy5codes LIKE '%,153,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=110ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:52.052
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '143' OR
						privy5codes LIKE '143,%' OR
						privy5codes LIKE '%,143' OR 
						privy5codes LIKE '%,143,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=292ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:52.052
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '178' OR
						privy5codes LIKE '178,%' OR
						privy5codes LIKE '%,178' OR 
						privy5codes LIKE '%,178,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=442ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:53.053
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '177' OR
						privy5codes LIKE '177,%' OR
						privy5codes LIKE '%,177' OR 
						privy5codes LIKE '%,177,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=1265ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:54.054
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '154' OR
						privy5codes LIKE '154,%' OR
						privy5codes LIKE '%,154' OR 
						privy5codes LIKE '%,154,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=365ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:55.055
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '243' OR
						privy5codes LIKE '243,%' OR
						privy5codes LIKE '%,243' OR 
						privy5codes LIKE '%,243,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=747ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:55.055
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '173' OR
						privy5codes LIKE '173,%' OR
						privy5codes LIKE '%,173' OR 
						privy5codes LIKE '%,173,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=488ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:56.056
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '246' OR
						privy5codes LIKE '246,%' OR
						privy5codes LIKE '%,246' OR 
						privy5codes LIKE '%,246,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=747ms, Records=4) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:57.057
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '166' OR
						privy5codes LIKE '166,%' OR
						privy5codes LIKE '%,166' OR 
						privy5codes LIKE '%,166,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getrelatedlocation (Datasource=entre360ds, Time=755ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 10:04:57.057
					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '132' OR
						privy5codes LIKE '132,%' OR
						privy5codes LIKE '%,132' OR 
						privy5codes LIKE '%,132,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = San Francisco

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 10:04:57.057
						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_bigint) = 2886117176
Parameter #2(cf_sql_bigint) = 2886117176


Scope Variables

Application Variables:
applicationname=16674C21BBD774F3F0CD46198107AC84
devmode=false
dsn_name=entre360ds
dsn_name10=entre360_2011ds
event=Struct (26)
ipallow=24.199.44.252
magazine_imageupload=/upload/net/privy/www/p5photos/
org.corfield.framework=Struct (3)
paypal_biz=paypal@privy.net
paypal_url=https://www.paypal.com/cgi-bin/webscr
recaptcha_private=6LfrQtQSAAAAAGuECx5CZ5jRb4TPBzgrBVTK_IPH
recaptcha_public=6LfrQtQSAAAAALsfdvrJmY-JULezQbwYw4ea1nE2
site_addr=www.privy.net
upload=/upload/net/privy/www/
upload_magazine=/upload/net/privy/www/p5photos/
upload_root=/upload/net/privy/
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=d:\www\privy\sanfrancisco\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=en, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=5955090; $Path=/; CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB; $Path=/; DESTINATION=Los%20Angeles; $Path=/; RECENTCITIES=Hong%20Kong%2CShanghai%2CLondon%2CLos%20Angeles%2CNew%20York%2CMacau; $Path=/
HTTP_HOST=www.privy.net
HTTP_REFERER=http://www.privy.net/sanfrancisco
HTTP_URL=/sanfrancisco/index.cfm/go/listing
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/listing
PATH_TRANSLATED=d:\www\privy\sanfrancisco\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sanfrancisco/index.cfm
SERVER_NAME=www.privy.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=5955090
CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
DESTINATION=Los Angeles
RECENTCITIES=Hong Kong,Shanghai,London,Los Angeles,New York,Macau
Session Variables:
cfid=5955090
cftoken=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
sessionid=16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
urltoken=CFID=5955090&CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
Debug Rendering Time: 20 ms