EXPAND YOUR NETWORK WITH PRIVY EVENTS

Let me know when Privy has a new event!

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 /events/index.cfm
Time Stamp 23-Dec-19 12:24 PM
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
7297 ms 7297 ms 1 CFC[ D:/www/privy/events/Application.cfc | onRequest(/events/index.cfm) ] from D:/www/privy/events/Application.cfc
5191 ms 5191 ms 1 CFC[ D:/www/privy/events/controllers/go.cfc | before(rc = [complex value]) ] from D:/www/privy/events/controllers/go.cfc
5191 ms 5191 ms 1 D:/www/privy/guestcfc/inc_controller_go_before.cfm
1592 ms 1592 ms 1 D:/www/privy/events/views/go/overview.cfm
1580 ms 1580 ms 1 D:/www/privy/guestcfc/inc_views_my_overview_events_all_members.cfm
1185 ms 1185 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy Party- APEX 20th Anniversary Gala After Party at Le Ka Restaurant and Lounge, 100) ] from D:/www/privy/guestcfc/global_event.cfc
389 ms 389 ms 1 CFC[ D:/www/privy/events/services/event.cfc | browse(argumentCollection = [complex value]) ] from D:/www/privy/events/services/event.cfc
55 ms 55 ms 1 D:/www/privy/events/layouts/go.cfm
41 ms 21 ms 2 CFC[ D:/www/privy/guestcfc/global_event.cfc | isusip(172.6.167.56) ] from D:/www/privy/guestcfc/global_event.cfc
37 ms 37 ms 1 D:/www/privy/guestcfc/inc_layouts_go.cfm
23 ms 23 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 16) ] from D:/www/privy/guestcfc/global_event.cfc
21 ms 21 ms 1 CFC[ D:/www/privy/events/Application.cfc | service(event.browse, event_browse) ] from D:/www/privy/events/Application.cfc
21 ms 21 ms 1 CFC[ D:/www/privy/events/controllers/go.cfc | overview(rc = [complex value]) ] from D:/www/privy/events/controllers/go.cfc
18 ms 18 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | adgen(172.6.167.56, 18) ] from D:/www/privy/guestcfc/global_event.cfc
18 ms 18 ms 1 D:/www/privy/guestcfc/inc_layouts_go_event_tabs.cfm
3 ms 3 ms 1 CFC[ D:/www/privy/events/Application.cfc | onRequestStart(/events/index.cfm) ] from D:/www/privy/events/Application.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(** $75 pre sale tickets will expire on Thursday. Day of pricing and at-the-door will be $95/person *** If you are fresh seafood lover, you are going to love this upcoming Privy Supper Club. Privy has arranged with EMC Seafood & Raw Bar for a special Chef’s Choice Prix Fixe 10 course (family style) menu that includes all-you-can-eat oysters for $75 (inclusive tax and tip, pre-sale). Bring a bottle of wine to share with everyone, as the corkage is waived as well. After 10pm, we invite you to stay for, 150) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 0 ms 3 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(150) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(As 2010 drew to a close, Privy rang in the New Year in style with A Privy New Year’s Rockin’ Eve. We celebrated a year filled with Privy Private Events spanning the East and West, the launch of the Privy 5 City Guides, and the re-design of the Privy website. We also took advantage of the opportunity to raise some money for a cause near to our hearts—that of Privy nonprofit partner LiNK (Liberty in North Korea)., 150) ] from D:/www/privy/guestcfc/global_event.cfc
1 ms 1 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(We would like to kick off our second Supper Club of the year at our new fave restaurant Le Ka Restaurant & Lounge. Privy members and guests will be treated to a delicious 4 course meal prepared by the Le Ka executive chef Remi Lauvand. We have special reserved the entire outside patio. It’s also the birthdays of Stephen Liu and Julia Lee., 150) ] from D:/www/privy/guestcfc/global_event.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
0 ms 0 ms 1 CFC[ D:/www/privy/events/Application.cfc | onRequestEnd(/events/index.cfm) ] from D:/www/privy/events/Application.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/events/controllers/go.cfc | endoverview(rc = [complex value]) ] from D:/www/privy/events/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/events/controllers/go.cfc | init(CFC: events.Application) ] from D:/www/privy/events/controllers/go.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Come for some Drinks 'n Chatter @ Le Ka Restaurant Lounge at Le Ka Restaurant and Lounge, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(For those who want to ring in the New Year with style, sophistication and without the massive crowds -- join Privy and Glam for a special New Year’s lounge experience at ultra glamorous Lexington Social House, 150) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(It's been a hot hot summer and as a friend of Privy.net, we would love to invite you to the LEKA Restaurant & Lounge for the official LA Premiere After Party of the new movie $upercapitalist, a financial thriller set in New York and Hong Kong starring Privy members Derek Ting and Kathy Uyen. The film has received quite a buzz has been recently featured in the NY Times, BBC World, Forbes, NBC News and CNBC News., 150) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(New Years's Eve Celebration Under The Stars Starlight Starbright, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(On behalf of Privy Causes, we’d love to invite you to sip some wine while listening to some killer music under the lush backdrop of an open-air amphitheatre – all while supporting a worthy non-profit cause. What’s not to like about that?, 150) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Please come out for some drinks n' chatter at EMC Seafood, one of the hottest restaurant/bars to hit ktown. Urban Daddy's call this place "A K-Town Shrine to Oysters and Whiskey Starting at 10pm, we are taking over the lounge. Come on out and down some oyster shooters. Given the capacity constraints, we are running a strict guest list. No cost to attend, but RSVP is required. We are doing a Privy Supper Club at 7pm. More details at: http://bit.ly/1eEOE9d *** To RSVP, you can also email assistant@pr, 150) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy Drinks Come for some Drinks 'n Chatter at EMC Seafood & Raw Bar, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy Evening Under the Stars: Kollaboration Acoustic at Ford Amphitheatre, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy Fall Soirée @ Le Ka Restaurant & Lounge at Le Ka Restaurant and Lounge, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy New Year Eve 2011 Party, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy New Years Rockin' Eve 2013 Midnight Masquerade at Le Ka Restaurant and Lounge, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy Supper Club @ EMC Seafood & Raw Bar at EMC Seafood & Raw Bar, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy Supper Club @ Le Ka Restaurant Lounge at Le Ka Restaurant and Lounge, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy members and guests are invited to yet another exclusive soiree at Le Ka, a $3.4 million restaurant and lounge that is the brainchild of the Kwan brothers of the popular Wokcano franchise. It’s also the birthdays of Stephen Liu and Julia Lee. Come out and celebrate!, 150) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy’s 2nd Hangover Vegas - Nobu Hotel - Memorial Day Weekend 2013 at Nobu Hotel, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Privy’s New Year’s Rockin’ Eve 2012 at Lexington Social House at Lexington Social House, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(Supercapitalist at Le Ka Restaurant and Lounge, 100) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(We are organizing a casual “drinks n’ chatter” evening at one of our favorite venues in LA - Le Ka, which was also the location of our raucous NYE party. The main excuse is it is the birthday of Privy’s lovely Creative Director Linda Kim! Feel free to bring and invite friends. We’ll be on the outside patio. Hope you can make it., 150) ] from D:/www/privy/guestcfc/global_event.cfc
0 ms 0 ms 1 CFC[ D:/www/privy/guestcfc/global_event.cfc | fullLeft(We'd like to cordially invite to Privy's 2nd "The Hangover" Weekend Junket at the newest hotel on the Las Vegas Strip – Nobu Hotel. Opened by Nobu Matsuhisa and Robert DeNiro, the Nobu Hotel is a separate luxury hotel located literally smack in the middle of the action, with its small lobby in the beating heart of Caesar’s, next to the longstanding and iconic Cleopatra’s Barge bar, just steps from Bobby Flay’s Mesa Grill, the new Gordon Ramsay Bar & Grill, several bars, a nightclub, more restaurants, two c, 150) ] 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 D:/www/privy/guestcfc/cfc_controller_event_go.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/cfc_services_event.cfc
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_controller_go.cfm
0 ms 0 ms 1 D:/www/privy/guestcfc/inc_views_event_subscription_inside_overview.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
7301 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

local.checksession (Datasource=entre360ds, Time=2474ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:24:01.001
	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=2690ms, Records=1) in D:\www\privy\guestcfc\inc_controller_go_before.cfm @ 12:24:04.004
	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=22ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:24:04.004
						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.recent (Datasource=entre360ds, Time=19ms, Records=1) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT TOP 1 Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total
			FROM PRIVYEVENTS
			WHERE (publish = 1) 
			ORDER BY StartDateTime DESC	  
		
local.retval.upcoming (Datasource=entre360ds, Time=17ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total
			FROM PRIVYEVENTS
			WHERE 
				(GETDATE() <= startdatetime) 
				AND (publish = 1) 
				
					AND (EventType=1)	
				
			ORDER BY StartDateTime DESC	  
		
local.retval.past_all (Datasource=entre360ds, Time=34ms, Records=13) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2
			FROM PRIVYEVENTS
			WHERE (GETDATE() > startdatetime) AND (publish = 1) AND (EventType=1)
			ORDER BY StartDateTime DESC	
		
local.retval.future_all (Datasource=entre360ds, Time=17ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2 
			FROM PRIVYEVENTS
			WHERE (GETDATE() <= startdatetime) AND (publish = 1) AND (eventtype=1)
			ORDER BY StartDateTime DESC 
		
local.retval.past_privy (Datasource=entre360ds, Time=131ms, Records=15) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2 
			FROM PRIVYEVENTS
			WHERE (GETDATE() > startdatetime) AND (publish = 1) AND (eventtype=2)
			ORDER BY StartDateTime DESC 
		
local.retval.future_privy (Datasource=entre360ds, Time=36ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2 
			FROM PRIVYEVENTS
			WHERE (GETDATE() <= startdatetime) AND (publish = 1) AND (eventtype=2) 
			ORDER BY StartDateTime DESC
		
local.getcityid (Datasource=entre360ds, Time=24ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT cityid 
			FROM privyevents_cityid 
			WHERE cityurl = 
			? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = past

local.retval.past_bycity_all (Datasource=entre360ds, Time=27ms, Records=13) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2 
			FROM PRIVYEVENTS
			WHERE (GETDATE() > startdatetime) 
				AND (publish = 1) 
				
					AND (EventType=1)	
				
			ORDER BY PRIVYEVENTS.p5regional, StartDateTime DESC	  
		
local.retval.future_bycity_all (Datasource=entre360ds, Time=24ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2 
			FROM PRIVYEVENTS
			WHERE (GETDATE() <= startdatetime) 
				AND (publish = 1) 
				
					AND (EventType=1)	
				
			ORDER BY PRIVYEVENTS.p5regional, StartDateTime DESC	 
		
local.retval.past_bycity_city (Datasource=entre360ds, Time=36ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2
			FROM PRIVYEVENTS
			WHERE 
				(GETDATE() > startdatetime) AND 
				(publish = 1) AND 
				(P5regional = 
					? 
				)  
				
					AND (EventType=1)	
				
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =

local.retval.future_bycity_city (Datasource=entre360ds, Time=20ms, Records=0) in D:\www\privy\guestcfc\cfc_services_event.cfc @ 12:24:04.004
			SELECT  Header, StartDateTime, TypeEvent, EventPicture, MaximumGuest, Title, PhotoAlbumUrl, publish, EventType, DirUrl, Detail, EventDetails, P5regional, NameLocation, CityLocation, MagazineURL,
			(
				SELECT SUM(totalguest) 
				FROM memberguests_rsvps 
				WHERE (memberguests_rsvps.eventid = privyevents.id)
			) AS rsvp_total,
			(
				SELECT SUM(quantity) 
				FROM privyevents_paypal 
				WHERE (privyevents_paypal.eventid = privyevents.id) 
			) AS ticket_total,
			(
				SELECT SUM(PRIVYEVENTSTICKETSORDERSDETAILS.Quantity)
				FROM PRIVYEVENTSTICKETSORDERS 
					INNER JOIN PRIVYEVENTSTICKETSORDERSDETAILS ON PRIVYEVENTSTICKETSORDERS.OrderId = PRIVYEVENTSTICKETSORDERSDETAILS.Orderid 
					INNER JOIN PRIVYEVENTSTICKETS ON PRIVYEVENTSTICKETSORDERSDETAILS.TicketId = PRIVYEVENTSTICKETS.Id 
				WHERE (PRIVYEVENTSTICKETS.privyeventid = privyevents.id) AND (PRIVYEVENTSTICKETSORDERS.status=2)	
			) AS ticket_total2 
			FROM PRIVYEVENTS
			WHERE 
				(GETDATE() <= startdatetime) AND 
				(publish = 1) AND 
				(P5regional = 
					? 
				) 
				
					AND (EventType=1)	
				
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =

local.eventcity (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:04.004
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=55ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:05.005
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=71ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:05.005
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=14ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 9

local.eventcity (Datasource=entre360ds, Time=83ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=1ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=20ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=19ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=36ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=72ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=3ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.eventcity (Datasource=entre360ds, Time=0ms, Records=1) in D:\www\privy\guestcfc\inc_views_my_overview_events_all_members.cfm @ 12:24:06.006
							SELECT city, p5url 
							FROM privyevents_cityid 
							WHERE cityid = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 3

local.getdb (Datasource=entre360ds, Time=17ms, Records=0) in D:\www\privy\guestcfc\global_event.cfc @ 12:24:06.006
						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\events\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/events
HTTP_URL=/events/index.cfm/go/overview/events-all-members/past
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/overview/events-all-members/past
PATH_TRANSLATED=d:\www\privy\events\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/events/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: 236 ms