Le Ka Restaurant and Lounge - Downtown LA

Le Ka is a new upscale contemporary American restaurant located in downtown Los Angeles on 6th and Flower.

Shin - Hair Salon in Santa Monica

Shin hair salon is located on Montana Avenue in the heart of Santa Monica between 10th and 11th. SHIN incorporated the critical elements of a luxury salon experience into an art installation that represented her personality and philosophy.

Lexington - Hollywood

For decades, Hollywood & Vine has been known as the epicenter of Hollywood culture where colors, trends, preferences and art meld seamlessly together to create a masterpiece of an experience.

Bottega Louie -Downtown

Nearly everyone raves about Bottega Louie and among those people, many rank it at the top of their list when it comes to Italian food in Los Angeles.

Katsuya - Beverly Hills

Everyone in LA knows Katsuya primarily for being a local hotspot for celebrities and paparazzi. In fact, TMZ practically owns property right in front of Katsuya's entrance.

Peninsula Beverly Hills - Beverly Hills

"Old Hollywood glamour here. It''s a celeb heavy spot. It''s a short walk to plenty of stuff, allowing you to go on a shopping spree without the need for motor vehicles."

Providence - Melrose

"A seafood restaurant par excellence, this venue has a lot more to offer. Autumnal décor and hues mark it out as a discreet place to come dine, but it''s the right side of spacious too, with high ceilings.

LA Mill Coffee - Silver Lake

With its chic decor, you''ll feel hip even as you come into the venue. It is very fancy with palatial like architecture that makes it seem as if you''re having a cup of coffee with royalty.

PRIVY TOP 5 PLACES IN LOS ANGELES

OTHER PRIVY 5 CITIES

Click here

Are you who we think you are?

  • Looks like we've already got some information from you on file.
  • Enter your password to link Facebook Connect with your existing Privy Guest account.


Debugging Information
ColdFusion Server Standard 2016,0,10,314028
Template /losangeles/index.cfm
Time Stamp 23-Dec-19 09:05 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
2232 ms 2232 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | onRequest(/losangeles/index.cfm) ] from D:/www/privy/losangeles/Application.cfc
1118 ms 1118 ms 1 D:/www/privy/losangeles/views/go/overview.cfm
1117 ms 1117 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_overview.cfm
1043 ms 1043 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/losangeles/controllers/go.cfc
1043 ms 1043 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
125 ms 125 ms 1 D:/www/privy/guestcfc/inc_privy5topplaces.cfm
47 ms 47 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | weather(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
24 ms 24 ms 1 D:/www/privy/guestcfc/inc_popular_posts.cfm
14 ms 14 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ConvertXmlToStruct(<?xml version="1.0" encoding="ISO-8859-1"?> <rss version='2.0' xmlns:dc='http://purl.org/dc/elements/1.1/'> <channel> <title>Weather at Los Angeles, Los Angeles International Airport, CA - via NOAA's National Weather Service</title> <link>http://www.weather.gov/xml/current_obs/</link> <lastBuildDate>Mon, 23 Dec 2019 08:53:00 -0800</lastBuildDate> <ttl>60</ttl> <description>Weather conditions from NOAA's National Weather Service. </description> <language>en-us</language> <managingEditor>sdb.support@noaa.gov</managingEditor> <webMaster>w-nws.webmaster@noaa.gov</webMaster> <image> <url>http://www.weather.gov/images/xml_logo.gif</url> <title>NOAA - National Weather Service</title> <link>http://www.weather.gov/xml/current_obs/</link> </image> <item> <title> Mostly Cloudy and 55 F at Los Angeles, Los Angeles International Airport, CA</title> <link>http://w1.weather.gov/data/obhistory/KLAX.html</link> <description> <![CDATA[<img src="http://forecast.weather.gov/images/wtf/small/bkn.png" class="noaaWeatherIcon" width="55" height="58" alt="Mostly Cloudy" style="float:left;" /><br />]]> Winds are East at 5.8 MPH (5 KT). The pressure is 1010.3 mb and the humidity is 74%. The wind chill is 54. Last Updated on Dec 23 2019, 8:53 am PST. </description> <guid isPermaLink="false">Mon, 23 Dec 2019 08:53:00 -0800</guid> </item> </channel> </rss>, [complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
8 ms 3 ms 3 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
5 ms 5 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
5 ms 5 ms 1 D:/www/privy/losangeles/layouts/go.cfm
3 ms 3 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 17) ] 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
3 ms 3 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | onRequestStart(/losangeles/index.cfm) ] from D:/www/privy/losangeles/Application.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | overview(rc = [complex value]) ] from D:/www/privy/losangeles/controllers/go.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | privystar(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.slides, cityguide_slides) ] from D:/www/privy/losangeles/Application.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Coffee Shop) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
0 ms 0 ms 4 CFC[ D:/www/privy/guestcfc/cfc_helper_view.cfc | getrightaction2(PEOPLE ) ] from D:/www/privy/guestcfc/cfc_helper_view.cfc
0 ms 0 ms 4 CFC[ D:/www/privy/guestcfc/cfc_helper_view.cfc | getrightaction2(SOCIETY+EVENTS ) ] from D:/www/privy/guestcfc/cfc_helper_view.cfc
0 ms 0 ms 3 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/guestcfc/global_event.cfc | ucaseOnFirstChar(Afternoon Tea) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(American/Traditional) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Asian Fusion/Contemporary) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Bar/Lounges) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Barbecue) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Boutique Hotels) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Brunch) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Burgers) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Business Lunch) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(California) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Banquet) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Breakfast) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Dim Sum) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Dumplings) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Noodles) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Shanghainese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Chinese Sichuan) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Clubs/Dancing) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Delis) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Dessert/Bakeries) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Diners) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(French) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hot Pot) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hotel Bars) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Hotels) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Indian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Italian Pizza) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Italian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Bar Food) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Ramen) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Sushi) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese Udon/Soba) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Japanese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Karaoke/Noraebang) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Korean BBQ) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Korean Noodles) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Lounges) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Mexican/Latin) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(New/American) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Romantic Restaurants) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Seafood) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Shopping Areas/Malls) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Spa) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Steakhouses) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Taiwanese) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Thai) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vegan/Vegetarian) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vietnamese Banh Mi) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Vietnamese Pho) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(View Bars) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | ucaseOnFirstChar(Wine List) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | onRequestEnd(/losangeles/index.cfm) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.privystar, cityguide_privystar) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/Application.cfc | service(cityguide.weather, cityguide_weather) ] from D:/www/privy/losangeles/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | endoverview(rc = [complex value]) ] from D:/www/privy/losangeles/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/controllers/go.cfc | init(CFC: losangeles.Application) ] from D:/www/privy/losangeles/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/losangeles/services/cityguide.cfc | slides(argumentCollection = [complex value]) ] from D:/www/privy/losangeles/services/cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_privy5cities.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2236 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

local.checksession (Datasource=entre360ds, Time=520ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:05:30.030
	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=516ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:05:30.030
	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=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:05:30.030
						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.retval.query (Datasource=entre360ds, Time=3ms, Records=24) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:05:30.030
			SELECT * 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND star=1 AND p5=1
			ORDER BY orderstar
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%

local.retval.query (Datasource=entre360ds, Time=2ms, Records=55) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:05:30.030
			SELECT Code, Category, directoryurl, picture2, IntroMiddle, whereto, star, shortenedurl 
			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) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%

local.retval.query (Datasource=entre360ds, Time=2ms, Records=52) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:05:30.030
			SELECT Code, Category, directoryurl, picture3, IntroMiddle, whereto 
			FROM privy5codes 
			WHERE 
			(
				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) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%

local.getthelist (Datasource=entre360ds, Time=11ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '107' OR
										privy5codes LIKE '107,%' OR
										privy5codes LIKE '%,107' OR 
										privy5codes LIKE '%,107,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '113' OR
										privy5codes LIKE '113,%' OR
										privy5codes LIKE '%,113' OR 
										privy5codes LIKE '%,113,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=11ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '121' OR
										privy5codes LIKE '121,%' OR
										privy5codes LIKE '%,121' OR 
										privy5codes LIKE '%,121,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '92' OR
										privy5codes LIKE '92,%' OR
										privy5codes LIKE '%,92' OR 
										privy5codes LIKE '%,92,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '106' OR
										privy5codes LIKE '106,%' OR
										privy5codes LIKE '%,106' OR 
										privy5codes LIKE '%,106,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '118' OR
										privy5codes LIKE '118,%' OR
										privy5codes LIKE '%,118' OR 
										privy5codes LIKE '%,118,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '120' OR
										privy5codes LIKE '120,%' OR
										privy5codes LIKE '%,120' OR 
										privy5codes LIKE '%,120,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '97' OR
										privy5codes LIKE '97,%' OR
										privy5codes LIKE '%,97' OR 
										privy5codes LIKE '%,97,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '130' OR
										privy5codes LIKE '130,%' OR
										privy5codes LIKE '%,130' OR 
										privy5codes LIKE '%,130,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '82' OR
										privy5codes LIKE '82,%' OR
										privy5codes LIKE '%,82' OR 
										privy5codes LIKE '%,82,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '236' OR
										privy5codes LIKE '236,%' OR
										privy5codes LIKE '%,236' OR 
										privy5codes LIKE '%,236,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '128' OR
										privy5codes LIKE '128,%' OR
										privy5codes LIKE '%,128' OR 
										privy5codes LIKE '%,128,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '189' OR
										privy5codes LIKE '189,%' OR
										privy5codes LIKE '%,189' OR 
										privy5codes LIKE '%,189,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '233' OR
										privy5codes LIKE '233,%' OR
										privy5codes LIKE '%,233' OR 
										privy5codes LIKE '%,233,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '96' OR
										privy5codes LIKE '96,%' OR
										privy5codes LIKE '%,96' OR 
										privy5codes LIKE '%,96,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '103' OR
										privy5codes LIKE '103,%' OR
										privy5codes LIKE '%,103' OR 
										privy5codes LIKE '%,103,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '111' OR
										privy5codes LIKE '111,%' OR
										privy5codes LIKE '%,111' OR 
										privy5codes LIKE '%,111,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '85' OR
										privy5codes LIKE '85,%' OR
										privy5codes LIKE '%,85' OR 
										privy5codes LIKE '%,85,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '108' OR
										privy5codes LIKE '108,%' OR
										privy5codes LIKE '%,108' OR 
										privy5codes LIKE '%,108,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '87' OR
										privy5codes LIKE '87,%' OR
										privy5codes LIKE '%,87' OR 
										privy5codes LIKE '%,87,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:30.030
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '232' OR
										privy5codes LIKE '232,%' OR
										privy5codes LIKE '%,232' OR 
										privy5codes LIKE '%,232,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '100' OR
										privy5codes LIKE '100,%' OR
										privy5codes LIKE '%,100' OR 
										privy5codes LIKE '%,100,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '194' OR
										privy5codes LIKE '194,%' OR
										privy5codes LIKE '%,194' OR 
										privy5codes LIKE '%,194,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '131' OR
										privy5codes LIKE '131,%' OR
										privy5codes LIKE '%,131' OR 
										privy5codes LIKE '%,131,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '123' OR
										privy5codes LIKE '123,%' OR
										privy5codes LIKE '%,123' OR 
										privy5codes LIKE '%,123,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '81' OR
										privy5codes LIKE '81,%' OR
										privy5codes LIKE '%,81' OR 
										privy5codes LIKE '%,81,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '119' OR
										privy5codes LIKE '119,%' OR
										privy5codes LIKE '%,119' OR 
										privy5codes LIKE '%,119,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '126' OR
										privy5codes LIKE '126,%' OR
										privy5codes LIKE '%,126' OR 
										privy5codes LIKE '%,126,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '83' OR
										privy5codes LIKE '83,%' OR
										privy5codes LIKE '%,83' OR 
										privy5codes LIKE '%,83,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '215' OR
										privy5codes LIKE '215,%' OR
										privy5codes LIKE '%,215' OR 
										privy5codes LIKE '%,215,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=8ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '115' OR
										privy5codes LIKE '115,%' OR
										privy5codes LIKE '%,115' OR 
										privy5codes LIKE '%,115,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '80' OR
										privy5codes LIKE '80,%' OR
										privy5codes LIKE '%,80' OR 
										privy5codes LIKE '%,80,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '114' OR
										privy5codes LIKE '114,%' OR
										privy5codes LIKE '%,114' OR 
										privy5codes LIKE '%,114,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '89' OR
										privy5codes LIKE '89,%' OR
										privy5codes LIKE '%,89' OR 
										privy5codes LIKE '%,89,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '116' OR
										privy5codes LIKE '116,%' OR
										privy5codes LIKE '%,116' OR 
										privy5codes LIKE '%,116,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '112' OR
										privy5codes LIKE '112,%' OR
										privy5codes LIKE '%,112' OR 
										privy5codes LIKE '%,112,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '122' OR
										privy5codes LIKE '122,%' OR
										privy5codes LIKE '%,122' OR 
										privy5codes LIKE '%,122,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '193' OR
										privy5codes LIKE '193,%' OR
										privy5codes LIKE '%,193' OR 
										privy5codes LIKE '%,193,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '244' OR
										privy5codes LIKE '244,%' OR
										privy5codes LIKE '%,244' OR 
										privy5codes LIKE '%,244,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '102' OR
										privy5codes LIKE '102,%' OR
										privy5codes LIKE '%,102' OR 
										privy5codes LIKE '%,102,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=11ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '110' OR
										privy5codes LIKE '110,%' OR
										privy5codes LIKE '%,110' OR 
										privy5codes LIKE '%,110,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '209' OR
										privy5codes LIKE '209,%' OR
										privy5codes LIKE '%,209' OR 
										privy5codes LIKE '%,209,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '90' OR
										privy5codes LIKE '90,%' OR
										privy5codes LIKE '%,90' OR 
										privy5codes LIKE '%,90,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '137' OR
										privy5codes LIKE '137,%' OR
										privy5codes LIKE '%,137' OR 
										privy5codes LIKE '%,137,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '88' OR
										privy5codes LIKE '88,%' OR
										privy5codes LIKE '%,88' OR 
										privy5codes LIKE '%,88,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '84' OR
										privy5codes LIKE '84,%' OR
										privy5codes LIKE '%,84' OR 
										privy5codes LIKE '%,84,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '105' OR
										privy5codes LIKE '105,%' OR
										privy5codes LIKE '%,105' OR 
										privy5codes LIKE '%,105,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '86' OR
										privy5codes LIKE '86,%' OR
										privy5codes LIKE '%,86' OR 
										privy5codes LIKE '%,86,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '98' OR
										privy5codes LIKE '98,%' OR
										privy5codes LIKE '%,98' OR 
										privy5codes LIKE '%,98,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '247' OR
										privy5codes LIKE '247,%' OR
										privy5codes LIKE '%,247' OR 
										privy5codes LIKE '%,247,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '74' OR
									privy5codes LIKE '74,%' OR
									privy5codes LIKE '%,74' OR 
									privy5codes LIKE '%,74,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '72' OR
									privy5codes LIKE '72,%' OR
									privy5codes LIKE '%,72' OR 
									privy5codes LIKE '%,72,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '73' OR
									privy5codes LIKE '73,%' OR
									privy5codes LIKE '%,73' OR 
									privy5codes LIKE '%,73,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '10' OR
									privy5codes LIKE '10,%' OR
									privy5codes LIKE '%,10' OR 
									privy5codes LIKE '%,10,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '11' OR
									privy5codes LIKE '11,%' OR
									privy5codes LIKE '%,11' OR 
									privy5codes LIKE '%,11,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '16' OR
									privy5codes LIKE '16,%' OR
									privy5codes LIKE '%,16' OR 
									privy5codes LIKE '%,16,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '61' OR
									privy5codes LIKE '61,%' OR
									privy5codes LIKE '%,61' OR 
									privy5codes LIKE '%,61,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '62' OR
									privy5codes LIKE '62,%' OR
									privy5codes LIKE '%,62' OR 
									privy5codes LIKE '%,62,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=9ms, Records=4) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '63' OR
									privy5codes LIKE '63,%' OR
									privy5codes LIKE '%,63' OR 
									privy5codes LIKE '%,63,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '76' OR
									privy5codes LIKE '76,%' OR
									privy5codes LIKE '%,76' OR 
									privy5codes LIKE '%,76,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '36' OR
									privy5codes LIKE '36,%' OR
									privy5codes LIKE '%,36' OR 
									privy5codes LIKE '%,36,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '37' OR
									privy5codes LIKE '37,%' OR
									privy5codes LIKE '%,37' OR 
									privy5codes LIKE '%,37,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '40' OR
									privy5codes LIKE '40,%' OR
									privy5codes LIKE '%,40' OR 
									privy5codes LIKE '%,40,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=10ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '77' OR
									privy5codes LIKE '77,%' OR
									privy5codes LIKE '%,77' OR 
									privy5codes LIKE '%,77,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=7ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '52' OR
									privy5codes LIKE '52,%' OR
									privy5codes LIKE '%,52' OR 
									privy5codes LIKE '%,52,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=5ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.getthelist (Datasource=entre360ds, Time=6ms, Records=5) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=3ms, Records=41) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
					SELECT * 
					FROM privy5codes 
					WHERE 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) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=6) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
					SELECT * 
					FROM privy5codes 
					WHERE 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) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=2) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
					SELECT * 
					FROM privy5codes 
					WHERE 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) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
					SELECT * 
					FROM privy5codes 
					WHERE 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) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
					SELECT * 
					FROM privy5codes 
					WHERE 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) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.dbprivy4featurelist2 (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_cityguide_go_overview.cfm @ 09:05:31.031
					SELECT * 
					FROM privy5codes 
					WHERE 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) = Los Angeles
Parameter #3(CF_SQL_CHAR) = Los Angeles,%
Parameter #4(CF_SQL_CHAR) = %,Los Angeles
Parameter #5(CF_SQL_CHAR) = %,Los Angeles,%

local.traffic (Datasource=entre360ds, Time=16ms, Records=0) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:05:31.031
	SELECT TOP 4
		magazine_id,
		COUNT(magazine_id) AS hits,
		(
			SELECT directoryurl
	        FROM magazine
	        WHERE magazine.id = magazine_views.magazine_id
		) AS directoryurl
	FROM MAGAZINE_VIEWS
	WHERE
		created>=CONVERT(datetime,'2019-12-22 00:00:00') AND
		created<=CONVERT(datetime,'2019-12-28 23:59:59') AND
		magazine_id!=17
	GROUP BY magazine_id
	ORDER BY COUNT(magazine_id) DESC
local.traffic (Datasource=entre360ds, Time=1ms, Records=4) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:05:31.031
		SELECT TOP 4 directoryurl FROM magazine ORDER BY initpopular DESC
	
local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:05:31.031
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-NYE-2011

local.getMagDB (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:05:31.031
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Emily-Cho

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:05:31.031
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Sara-Mibo-Sohn

local.getMagDB (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:05:31.031
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-Bordeaux-Event-at-Strip-Prime-Shanghai

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:05:31.031
						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.dbprivy5topplaces (Datasource=entre360ds, Time=112ms, Records=22) in D:\www\privy\guestcfc\inc_privy5topplaces.cfm @ 09:05:31.031
	SELECT
		LOCATION.Name,
		LOCATION.LocationId,
		LOCATION.Privy5Codes,
		LOCATION.Privy5Text,
		LOCATION.Thumbnail,
		LOCATION.directoryurl,
		(
			SELECT privy5codes.whereto
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorywhereto2,
		(
			SELECT privy5codes.category
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorytext,
		(
			SELECT privy5codes.directoryurl
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categoryurl
	FROM PRIVY5TOPPLACES INNER JOIN LOCATION ON PRIVY5TOPPLACES.LocationId = LOCATION.LocationId
	WHERE (PRIVY5TOPPLACES.City = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Los Angeles
Parameter #2(CF_SQL_CHAR) = Los Angeles,%
Parameter #3(CF_SQL_CHAR) = %,Los Angeles
Parameter #4(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #5(CF_SQL_CHAR) = Los Angeles
Parameter #6(CF_SQL_CHAR) = Los Angeles,%
Parameter #7(CF_SQL_CHAR) = %,Los Angeles
Parameter #8(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #9(CF_SQL_CHAR) = Los Angeles
Parameter #10(CF_SQL_CHAR) = Los Angeles,%
Parameter #11(CF_SQL_CHAR) = %,Los Angeles
Parameter #12(CF_SQL_CHAR) = %,Los Angeles,%
Parameter #13(CF_SQL_CHAR) = Los Angeles

local.getdb (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:05:31.031
						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)
[email protected]
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\losangeles\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=/
HTTP_HOST=www.privy.net
HTTP_REFERER=http://www.privy.net/losangeles
HTTP_URL=/losangeles/index.cfm
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=
PATH_TRANSLATED=d:\www\privy\losangeles\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/losangeles/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
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: 17 ms