Carnegie Club
Categories: Night Life

Neighborhood: Midtown

156 West 56th Street

CitySpire Center

New York CityNY10019

United States

+1 212 957 9676

www.hospitalityholdings.com

Privy 5 Overview

Share |

The Carnegie Club is a gem of vintage class - this is not only caused by the nostalgic scent of cigar smoke pervading the air. Frank Sinatra fans will love it; it is in this atmosphere that authentic crooners came to be. The Carnegie Club is from the same design team of the Campbell Apartment at Grand Central, and features hand carved, hard-cover, book-filled cases. There is a mellow mood, larger than life cathedral windows and a small floor space which seats an 11 piece band and a Sinatra show, guest crooner, trumpeter or didgeridoo player. Men still wear jackets and ties while waitresses adorn themselves in pearls and the long-lost little black number.

TYPE: Bars, Cigar Bar

Price Range: $31-$60

Attire: Casual

Takes Reservations: No

Parking: Street

Takeout: No

Delivers: No

Accept Credit Cards: Yes

Good For Groups: Yes

Good For Kids: No

Waiter Service: No

write a comment

Comments (0)

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 /newyork/index.cfm
Time Stamp 23-Dec-19 09:50 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
1938 ms 1938 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequest(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
1078 ms 1078 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
1078 ms 1078 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
618 ms 618 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto.cfm
618 ms 618 ms 1 D:/www/privy/guestcfc/inc_views_cityguide_go_whereto_singlelisting.cfm
618 ms 618 ms 1 D:/www/privy/newyork/views/go/drink.cfm
559 ms 559 ms 1 D:/Mappings/lib-tag/cuisinetype.cfm
157 ms 157 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | whereto(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
45 ms 45 ms 1 D:/www/privy/guestcfc/inc_popular_posts.cfm
30 ms 30 ms 1 CFC[ D:/www/privy/newyork/services/users.cfc | getcommentbyid(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/users.cfc
25 ms 25 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5neighborhood(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
10 ms 10 ms 1 D:/www/privy/newyork/layouts/go.cfm
9 ms 5 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
9 ms 9 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
7 ms 7 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
6 ms 1 ms 6 D:/Mappings/lib-tag/categorygroup.cfm
6 ms 0 ms 1080 D:/Mappings/lib-tag/getmaxminusone.cfm
5 ms 5 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | drink(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
5 ms 5 ms 1 D:/www/privy/guestcfc/cfc_services_users_inc.cfm
4 ms 4 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestStart(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5list(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
3 ms 3 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | p5memberlist(argumentCollection = [complex value]) ] from D:/www/privy/newyork/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/newyork/Application.cfc | service(cityguide.p5memberlist, cityguide_p5memberlist) ] from D:/www/privy/newyork/Application.cfc
2 ms 2 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(users.getcommentbyid, users_getcommentbyid) ] from D:/www/privy/newyork/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5neighborhood, cityguide_p5neighborhood) ] from D:/www/privy/newyork/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/newyork/services/cityguide.cfc | mapjsheader(argumentCollection = [complex value]) ] from D:/www/privy/newyork/services/cityguide.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_controller_cityguide_go.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/cfc_services_users.cfc
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_application_setuprequest_cityguide.cfm
1 ms 1 ms 1 D:/www/privy/guestcfc/inc_views_go_mapfunc.cfm
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 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | getrcq([complex value]) ] from D:/www/privy/guestcfc/global_event.cfc
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/guestcfc/global_event.cfc | p5thumbnail(original = carnegieclub.jpg, type = 3) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | onRequestEnd(/newyork/index.cfm) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.mapjsheader, cityguide_mapjsheader) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.p5list, cityguide_p5list) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/Application.cfc | service(cityguide.whereto, cityguide_whereto) ] from D:/www/privy/newyork/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | enddrink(rc = [complex value]) ] from D:/www/privy/newyork/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/newyork/controllers/go.cfc | init(CFC: newyork.Application) ] from D:/www/privy/newyork/controllers/go.cfc
0 ms 0 ms 1 D:/Mappings/lib-tag/commaspace.cfm
0 ms 0 ms 1 D:/Mappings/lib-tag/hoursop.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_cityguide.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_login_popup.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_privy5cities.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_views_comments.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1943 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

local.dbfindshortened (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\inc_application_setuprequest_cityguide.cfm @ 09:50:35.035
		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/drink/Carnegie-Club
Parameter #2(CF_SQL_CHAR) = New York
Parameter #3(CF_SQL_CHAR) = New York,%
Parameter #4(CF_SQL_CHAR) = %,New York
Parameter #5(CF_SQL_CHAR) = %,New York,%

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

local.checksession (Datasource=entre360ds, Time=536ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:50:36.036
	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=536ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 09:50:36.036
	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:50:36.036
						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=1ms, Records=32) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:36.036
			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) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%

local.retval.query (Datasource=entre360ds, Time=3ms, Records=8) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:36.036
			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 
				AND whereto = ? 
			ORDER BY Category
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%
Parameter #5(CF_SQL_CHAR) = drink

local.retval.query (Datasource=entre360ds, Time=25ms, Records=20) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
			SELECT PRIVY5NEIGHBORHOODS.neighborhood, PRIVY5NEIGHBORHOODS.closestprivycity, PRIVY5NEIGHBORHOODS.directoryurl 
			FROM PRIVY5NEIGHBORHOODS 
			WHERE 
				PRIVY5NEIGHBORHOODS.closestprivycity = ? 
				AND ltrim(rtrim(PRIVY5NEIGHBORHOODS.neighborhood)) IN 
				(
					SELECT ltrim(rtrim(LOCATION.Neighborhood))
					FROM LOCATION
					WHERE 
						(LOCATION.p5 = 1) AND 
						(LOCATION.ClosestPrivyCity = ?) AND 
						(
							categorywhereto LIKE 'drink' OR
							categorywhereto LIKE 'drink,%' OR
							categorywhereto LIKE '%,drink' OR 
							categorywhereto LIKE '%,drink,%'
						)		 
					GROUP BY ltrim(rtrim(LOCATION.Neighborhood))
				)		
				
			ORDER BY PRIVY5NEIGHBORHOODS.neighborhood  
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York

local.retval.getCategory (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
					SELECT * 
					FROM privy5codes 
					WHERE 
						(
							directoryurl = ? OR 
							shortenedurl = ?
						) AND 
						(
							City LIKE ? OR 
							City LIKE ? OR
							City LIKE ? OR 
							City LIKE ?
						) 
						 
						AND p5=1
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Carnegie-Club
Parameter #2(CF_SQL_CHAR) = Carnegie-Club
Parameter #3(CF_SQL_CHAR) = New York
Parameter #4(CF_SQL_CHAR) = New York,%
Parameter #5(CF_SQL_CHAR) = %,New York
Parameter #6(CF_SQL_CHAR) = %,New York,%

local.retval.getlocation (Datasource=entre360ds, Time=27ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
					SELECT 
						*, 
						(
							SELECT privy5codes.whereto 
							FROM privy5codes
							WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
						) AS categorywhereto2,
						(
							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,
						(
							SELECT COUNT(MyReviews.myreviewid) 
	        				FROM myreviews, MEMBER  
	        				WHERE 
								MYREVIEWS.MemberId = member.MemberID AND 
								MyReviews.LocationId= location.locationid AND
								member.can_login=1
						) AS manyreviews,
						(
							SELECT TOP 1 signaturedishes 
							FROM myreviews 
							WHERE 
								myreviews.LocationId = location.locationid AND 
								myreviews.signaturedishes IS NOT NULL AND 
								myreviews.signaturedishes != ''
						) AS signaturedishes,
						
						'' AS buttonselection	 
						
					FROM location 
					WHERE 
						(
							locationid = ? OR 
							directoryurl = ?
						)
						AND (Location.ClosestPrivyCity=?)
						 
						AND (Location.P5=1)
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Carnegie-Club
Parameter #2(CF_SQL_CHAR) = Carnegie-Club
Parameter #3(CF_SQL_CHAR) = New York

local.findprivy5category (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
						SELECT Code, category 
						FROM privy5codes 
						WHERE Code =
							? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 136

local.retval.p5memberlovethis (Datasource=entre360ds, Time=1ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
						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 
						  
						AND 
						(
							
									Code = ? 
						)
							
						ORDER BY Category 
					
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York
Parameter #2(CF_SQL_CHAR) = New York,%
Parameter #3(CF_SQL_CHAR) = %,New York
Parameter #4(CF_SQL_CHAR) = %,New York,%
Parameter #5(cf_sql_integer) = 136

local.retval.getrelatedlocation_singlecategory (Datasource=entre360ds, Time=52ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
						SELECT 
							*,
							(
								SELECT privy5codes.whereto 
								FROM privy5codes
								WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
							) AS categorywhereto2, 
							(
								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,
							(
								SELECT COUNT(MyReviews.myreviewid) 
		        				FROM myreviews, MEMBER  
		        				WHERE 
									MYREVIEWS.MemberId = member.MemberID AND 
									MyReviews.LocationId= location.locationid AND
									member.can_login=1
							) AS manyreviews,
							(
								SELECT TOP 1 signaturedishes 
								FROM myreviews 
								WHERE 
									myreviews.LocationId = location.locationid AND 
									myreviews.signaturedishes IS NOT NULL AND 
									myreviews.signaturedishes != ''
							) AS signaturedishes,
							
							'' AS buttonselection	 
							
						FROM location 
						WHERE 
							(Location.ClosestPrivyCity=?) AND
							(Location.P5=1) AND
							( 
									Location.privy5codes LIKE '136' OR
									Location.privy5codes LIKE '136,%' OR
									Location.privy5codes LIKE '%,136' OR 
									Location.privy5codes LIKE '%,136,%' 
							)
					
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.retval.getrelatedlocation (Datasource=entre360ds, Time=57ms, Records=5) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
						SELECT 
							*,
							(
								SELECT privy5codes.whereto 
								FROM privy5codes
								WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',')
							) AS categorywhereto2, 
							(
								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,
							(
								SELECT COUNT(MyReviews.myreviewid) 
		        				FROM myreviews, MEMBER  
		        				WHERE 
									MYREVIEWS.MemberId = member.MemberID AND 
									MyReviews.LocationId= location.locationid AND
									member.can_login=1
							) AS manyreviews,
							(
								SELECT TOP 1 signaturedishes 
								FROM myreviews 
								WHERE 
									myreviews.LocationId = location.locationid AND 
									myreviews.signaturedishes IS NOT NULL AND 
									myreviews.signaturedishes != ''
							) AS signaturedishes,
							
							'' AS buttonselection	 
							
						FROM location 
						WHERE 
							(Location.ClosestPrivyCity=?) AND
							(Location.P5=1) 
							   
							AND
							( 
								
									Location.privy5codes LIKE '136' OR
									Location.privy5codes LIKE '136,%' OR
									Location.privy5codes LIKE '%,136' OR 
									Location.privy5codes LIKE '%,136,%' 
							)
							
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = New York

local.retval.getlocationphotos (Datasource=entre360ds, Time=11ms, Records=1) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
		            	SELECT FileUploadLogs.* 
						FROM FileUploadLogs INNER JOIN MEMBER ON FileUploadLogs.MemberId = MEMBER.MemberID 
						WHERE FileUploadLogs.LocationId = ?
						ORDER BY FileUploadLogs.Created DESC
		        	
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 9AFF4B27-188B-FCEA-608F12B867482A12

local.retval.getp5bookmark1 (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
							SELECT 
								MEMBERGUESTS.memberid, 
								MEMBERGUESTS_PLACES.placeid, 
								MEMBERGUESTS.firstname, 
								MEMBERGUESTS.picture,
								MEMBERGUESTS.fbid,
								MEMBERGUESTS.gender
							FROM MEMBERGUESTS_PLACES INNER JOIN MEMBERGUESTS ON MEMBERGUESTS_PLACES.memberid = MEMBERGUESTS.memberid 
							WHERE MEMBERGUESTS_PLACES.placeid = ? AND wantorbeen=2
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 9AFF4B27-188B-FCEA-608F12B867482A12

local.retval.getp5bookmark2 (Datasource=entre360ds, Time=2ms, Records=0) in D:\www\privy\guestcfc\cfc_services_cityguide.cfc @ 09:50:37.037
							SELECT 
								MEMBERGUESTS.memberid, 
								MEMBERGUESTS_PLACES.placeid, 
								MEMBERGUESTS.firstname, 
								MEMBERGUESTS.picture,
								MEMBERGUESTS.fbid,
								MEMBERGUESTS.gender
							FROM MEMBERGUESTS_PLACES INNER JOIN MEMBERGUESTS ON MEMBERGUESTS_PLACES.memberid = MEMBERGUESTS.memberid 
							WHERE MEMBERGUESTS_PLACES.placeid = ? AND wantorbeen=1
						
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 9AFF4B27-188B-FCEA-608F12B867482A12

local.getid (Datasource=entre360ds, Time=0ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 09:50:37.037
					SELECT Code 
					FROM privy5codes 
					WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Carnegie-Club

local.getid (Datasource=entre360ds, Time=24ms, Records=1) in D:\www\privy\guestcfc\cfc_services_users.cfc @ 09:50:37.037
						SELECT locationid 
						FROM location 
						WHERE directoryurl = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Carnegie-Club

local.retval.comments (Datasource=entre360ds, Time=4ms, Records=0) in D:\www\privy\guestcfc\cfc_services_users_inc.cfm @ 09:50:37.037
		SELECT 
			MEMBERGUESTS.memberid,
			isnull(MEMBERGUESTS.firstname,'')+' '+isnull(MEMBERGUESTS.lastname,'') AS personname, 
			MEMBERGUESTS.picture,
			MEMBERGUESTS.fbid,
			MEMBERGUESTS.gender,
			MEMBERGUESTS_COMMENTS.commentid,
			MEMBERGUESTS_COMMENTS.comment,
			MEMBERGUESTS_COMMENTS.commentdate
		FROM MEMBERGUESTS_COMMENTS 
			INNER JOIN MEMBERGUESTS ON MEMBERGUESTS_COMMENTS.memberid = MEMBERGUESTS.memberid 
		WHERE 
			
			MEMBERGUESTS_COMMENTS.locationid = ? 
			AND MEMBERGUESTS_COMMENTS.commentshow = 1 
		ORDER BY MEMBERGUESTS_COMMENTS.commentdate DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 9AFF4B27-188B-FCEA-608F12B867482A12

getcategory (Datasource=entre360ds, Time=0ms, Records=9, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:50:37.037
	SELECT GroupCategory 
    FROM LocationCategory 
    GROUP BY GroupCategory  
getcategorynew (Datasource=entre360ds, Time=0ms, Records=162, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:50:37.037
	SELECT Category 
    FROM LocationCategory 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
getfeaturenew (Datasource=entre360ds, Time=0ms, Records=105, Cached Query) in D:\Mappings\lib-tag\cuisinetype.cfm @ 09:50:37.037
	SELECT feature
    FROM LocationFeature 
    WHERE GroupCategory='Restaurants' OR GroupCategory='Night Life' OR GroupCategory='Hotels' 
local.traffic (Datasource=entre360ds, Time=29ms, Records=0) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:50:37.037
	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=2ms, Records=4) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:50:37.037
		SELECT TOP 4 directoryurl FROM magazine ORDER BY initpopular DESC
	
local.getMagDB (Datasource=entre360ds, Time=5ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:50:37.037
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Privy-NYE-2011

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:50:37.037
						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:50:37.037
						SELECT *
						FROM magazine
						WHERE directoryurl=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = Member-Interview---Sara-Mibo-Sohn

local.getMagDB (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_popular_posts.cfm @ 09:50:37.037
						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=5ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 09:50:37.037
						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\newyork\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/newyork
HTTP_URL=/newyork/index.cfm/go/drink/Carnegie-Club
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/drink/Carnegie-Club
PATH_TRANSLATED=d:\www\privy\newyork\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/newyork/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: 18 ms