Debugging Info
pagedictsize=44
sqltime = 0.182 s
cpu time = 0.050 s
real time = 0.319 s
memory increase = 0 kB
fields = id: '11F0E000000FD'
templates =
/data/aipn/current/generic/themes/shared/footer
/data/aipn/current/generic/themes/shared/header
/data/aipn/current/generic/themes/www/mako/meetings/viewMeeting
/data/aipn/current/generic/themes/www/webform/meeting/meetingHeader
scrapeAndDrape (CACHED) stub: http://www.aipn.maxx.matrixdev.net/courses-events/courses-events-stub/ (/data/aipn/current/aipn_org/cachedFiles//cachedStub___forms__meeting__MeetingFormPublic__view)
dg = ['Empty'] | [170015]
extra debug info =
queries = 51 queries

Total TimeCountAvg TimeQuery
0.0398 calls
1 row
0.005 SELECT version from databasemap;
0.0171 call
0 rows
0.017 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-21 08:47:22',`mxxUpdatedBy`=NULL, `PageRequestId`=0x447D0B00000003, `path`='forms/meeting/MeetingFormPublic/view', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='AIEN', `pid`='3416134', `requestNum`='2', `objectId`='558C00000039', `growth`='0', `server`='www.aipn.maxx.matrixdev.net', `dbThreadId`='1148173', `startTime`='2026-04-21 08:47:22', `sessionId`=0x57D5181D2C9B8B8E, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.027213573455810547', `timeTaken`='17', `dictSize`='44', `fields`='{\\'id\\':\\'558C00000039\\'}', `clientIPAddr`='216.73.217.47' WHERE `PageRequestId`=0x447D0B00000003
0.0151 call
1 row
0.015 SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)<=0) AND `Registration`.`MeetingId`=0x11F0E000000FD) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-04-21 08:47:23')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x11F0E000000FD)
0.0151 call
0 rows
0.015 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Meeting) WHERE `File`.`parentId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0144 calls
244 rows
0.004 SELECT * FROM Country ORDER BY orderindex, id
0.0111 call
12 rows
0.011 SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (MicrositeTab, Meeting) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2DF91600000001
0.0102 calls
1 row
0.005 select mxxCreated, mxxUpdated from Meeting where MeetingId=0x11F0E000000FD;
0.0102 calls
1 row
0.005 select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Meeting where MeetingId=0x11F0E000000FD
0.0101 call
1 row
0.010 SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)>0) AND `Registration`.`MeetingId`=0x11F0E000000FD) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-04-21 08:47:23')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x11F0E000000FD)
0.0092 calls
1 row
0.005 select max(returnOrder) from Stack where sessionId = 277235801761582130
0.0091 call
1 row
0.009 SELECT DISTINCT hex(`User`.`UserId`) AS `UserId`, `User`.`username`, `User`.`password`, `User`.`encoding`, hex(`User`.`VotingId`) AS `VotingId`, `User`.`lastSearchType`, `User`.`oneTimeKey`, `User`.`recoverPasswordKey`, `User`.`recoverPasswordTimeout`, `User`.`disableAllNotifications`, `User`.`otCodeTime`, `User`.`otCode`, `User`.`holyGrailSections`, `User`.`emailLoginToken`, `User`.`emailLoginTokenTime` FROM (User) WHERE `User`.`UserId`=0x4F7D00000040
0.0081 call
0 rows
0.008 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-21 08:47:23',`mxxCreatedBy`=NULL, `PageRequestId`=0x447D0B00000007, `path`='forms/meeting/MeetingFormPublic/view', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='AIEN', `pid`='3416134', `requestNum`='4', `pageDictSize`=NULL, `objectId`='11F0E000000FD', `templateMethod`=NULL, `growth`=NULL, `server`='www.aipn.maxx.matrixdev.net', `dbThreadId`='1148173', `startTime`='2026-04-21 08:47:23', `sessionId`=0x3D8F07E2B050C32, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'11F0E000000FD\\'}', `clientIPAddr`='216.73.217.47'
0.0081 call
1 row
0.008 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='meetings_WWWreg_noRegMsg_disabled' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0071 call
0 rows
0.007 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-21 08:47:22',`mxxCreatedBy`=NULL, `PageRequestId`=0x447D0B00000006, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='AIEN', `pid`='3416134', `requestNum`='3', `pageDictSize`=NULL, `objectId`='2DF91600000001', `templateMethod`=NULL, `growth`=NULL, `server`='www.aipn.maxx.matrixdev.net', `dbThreadId`='1148173', `startTime`='2026-04-21 08:47:22', `sessionId`=0x3D8F07E2B050C32, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'2DF91600000001\\'}', `clientIPAddr`='216.73.217.47'
0.0071 call
0 rows
0.007 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`birthYear`, `Individual`.`mailChimpMergeCache`, `Individual`.`primaryRegion`, `Individual`.`companyType`, `Individual`.`yearsExperience`, `Individual`.`jobDuties`, `Individual`.`jobDutiesDescription`, `Individual`.`seekingParticipation`, `Individual`.`seekingParticipationDescription`, `Individual`.`NOCDuesConsiderations`, `Individual`.`employmentField`, `Individual`.`companyTypeOther`, `Individual`.`isYoungNegotiator`, `Individual`.`Education1_Name`, `Individual`.`Education1_Time`, `Individual`.`Education1_Major`, `Individual`.`Education1_Degree`, `Individual`.`Education2_Name`, `Individual`.`Education2_Time`, `Individual`.`Education2_Major`, `Individual`.`Education2_Degree`, `Individual`.`Education3_Name`, `Individual`.`Education3_Time`, `Individual`.`Education3_Major`, `Individual`.`Education3_Degree`, `Individual`.`graduationDate`, `Individual`.`proofOfStudentEnrollment`, `Individual`.`createdOnWWW`, `Individual`.`howHeardAboutOther`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isWomenNegotiator`, `Individual`.`isMergeProtected` FROM (Meeting, Individual) WHERE `Meeting`.`MeetingId`=0x11F0E000000FD AND `Meeting`.`contactIndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0071 call
0 rows
0.007 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x2DF91600000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0071 call
0 rows
0.007 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-21 08:47:23',`mxxUpdatedBy`=NULL, `PageRequestId`=0x447D0B00000006, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='AIEN', `pid`='3416134', `requestNum`='3', `objectId`='2DF91600000001', `growth`='0', `server`='www.aipn.maxx.matrixdev.net', `dbThreadId`='1148173', `startTime`='2026-04-21 08:47:22', `sessionId`=0x3D8F07E2B050C32, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.03873896598815918', `timeTaken`='0', `dictSize`='44', `fields`='{\\'id\\':\\'2DF91600000001\\'}', `clientIPAddr`='216.73.217.47' WHERE `PageRequestId`=0x447D0B00000006
0.0051 call
0 rows
0.005 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Meeting) WHERE `Meeting`.`inSiteBannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0051 call
3 rows
0.005 SELECT DISTINCT hex(`Fee`.`FeeId`) AS `FeeId`, `Fee`.`expirationDate`, `Fee`.`amount`, hex(`Fee`.`itemId`) AS `itemId`, `Fee`.`name`, `Fee`.`description`, `Fee`.`minGroupSize`, `Fee`.`isEarlyDiscount`, `Fee`.`membersOnly`, `Fee`.`guestsOnly`, `Fee`.`availableToGuests`, `Fee`.`accountingCode`, `Fee`.`availableToSpouses`, `Fee`.`feeCode`, `Fee`.`published`, `Fee`.`rateCategory`, `Fee`.`showOnWWW`, `Fee`.`showMembershipTypesAsMembersOnWWW`, `Fee`.`membershipTypesLabelForWWW`, `Fee`.`groupSizeRule`, `Fee`.`specialDealType`, `Fee`.`recordOrigin`, `Fee`.`confirmationText` FROM (Meeting, Fee) WHERE `Fee`.`itemId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0051 call
1 row
0.005 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x2DF91600000001 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0051 call
0 rows
0.005 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x11F0E00000101 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0051 call
1 row
0.005 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Meeting) WHERE `Meeting`.`logoFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0051 call
0 rows
0.005 SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Meeting, Category, Meeting2Category) WHERE (0x11F0E000000FD=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Category`.`MeetingId` AND `Meeting2Category`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x11F0E000000FD AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`Meeting`.`MeetingId`) AS `MeetingId`, `Meeting`.`name`, `Meeting`.`hostName`, `Meeting`.`description`, `Meeting`.`audienceDescription`, `Meeting`.`cosponsors`, `Meeting`.`includes`, `Meeting`.`attire`, `Meeting`.`cancellationPolicy`, `Meeting`.`thankYouText`, `Meeting`.`registrationStarts`, `Meeting`.`registrationEnds`, `Meeting`.`earlybirdCutoff`, `Meeting`.`onlineRegistrationsEnabled`, `Meeting`.`selectSessionsOnRegForm`, `Meeting`.`accountingCode`, `Meeting`.`maximumNumAttendees`, `Meeting`.`type`, `Meeting`.`showPublicSessionSearch`, `Meeting`.`allowSpouseReg`, `Meeting`.`continuingEdUnits`, `Meeting`.`mediaAllowed`, `Meeting`.`travelInfo`, `Meeting`.`hotelBlurb`, `Meeting`.`dateClosed`, `Meeting`.`showFeesOnPublicView`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`eventId`, `Meeting`.`staffNotificationEmail`, `Meeting`.`paymentInstructions`, `Meeting`.`staffCancellationEmail`, `Meeting`.`lowRoomTrigger`, `Meeting`.`continuingEdNumber`, `Meeting`.`enableRSVP`, `Meeting`.`micrositePath`, `Meeting`.`bgcolor`, `Meeting`.`accentColor`, `Meeting`.`tabTitleColor`, `Meeting`.`bodyTextColor`, `Meeting`.`linkTextColor`, `Meeting`.`rightNavTextColor`, `Meeting`.`fontTitleSize`, `Meeting`.`fontBodySize`, `Meeting`.`fontName`, `Meeting`.`navbarColor`, `Meeting`.`sidebarColor`, `Meeting`.`highlightedTabTextColor`, `Meeting`.`headlineColor`, `Meeting`.`highlightedTabColor`, `Meeting`.`inSiteAccentColor`, `Meeting`.`inSiteBodyTextColor`, `Meeting`.`inSiteHeadlineColor`, `Meeting`.`inSiteHighlightedTabColor`, `Meeting`.`inSiteHighlightedTabTextColor`, `Meeting`.`inSiteLinkTextColor`, `Meeting`.`inSiteNavbarColor`, `Meeting`.`inSiteRightNavTextColor`, `Meeting`.`inSiteSidebarColor`, `Meeting`.`inSiteTabTitleColor`, `Meeting`.`inSiteFontBodySize`, `Meeting`.`inSiteFontName`, `Meeting`.`inSiteFontTitleSize`, `Meeting`.`useBadges`, `Meeting`.`staffNotificationRevisitedEmail`, `Meeting`.`anticipatedRegistrations`, `Meeting`.`_budgetedRevenue`, `Meeting`.`groupRegistrationOn`, `Meeting`.`allowPlaceholders`, `Meeting`.`feesPageTopText`, `Meeting`.`badgesPageTopText`, `Meeting`.`questionsPageTopText`, `Meeting`.`eventsPageTopText`, `Meeting`.`reviewPageTopText`, `Meeting`.`paymentPageTopText`, `Meeting`.`micrositeTemplate`, `Meeting`.`inSiteTemplate`, `Meeting`.`isWebinar`, `Meeting`.`housingPageTopText`, `Meeting`.`attendeesPageTopText`, `Meeting`.`shortCalDescription`, `Meeting`.`allowAddToCalendar`, `Meeting`.`campaignCode`, `Meeting`.`recordOrigin`, `Meeting`.`additionalFeesPageTopText`, `Meeting`.`referralText`, `Meeting`.`hasReferrals`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived`, `Meeting`.`hideIntranetSummary`, `Meeting`.`showGroupEdit` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x2DF91600000001
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`User`.`UserId`) AS `UserId`, `User`.`username`, `User`.`password`, `User`.`encoding`, hex(`User`.`VotingId`) AS `VotingId`, `User`.`lastSearchType`, `User`.`oneTimeKey`, `User`.`recoverPasswordKey`, `User`.`recoverPasswordTimeout`, `User`.`disableAllNotifications`, `User`.`otCodeTime`, `User`.`otCode`, `User`.`holyGrailSections`, `User`.`emailLoginToken`, `User`.`emailLoginTokenTime` FROM (User) WHERE `User`.`UserId`=0x387600000010
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`birthYear`, `Individual`.`mailChimpMergeCache`, `Individual`.`primaryRegion`, `Individual`.`companyType`, `Individual`.`yearsExperience`, `Individual`.`jobDuties`, `Individual`.`jobDutiesDescription`, `Individual`.`seekingParticipation`, `Individual`.`seekingParticipationDescription`, `Individual`.`NOCDuesConsiderations`, `Individual`.`employmentField`, `Individual`.`companyTypeOther`, `Individual`.`isYoungNegotiator`, `Individual`.`Education1_Name`, `Individual`.`Education1_Time`, `Individual`.`Education1_Major`, `Individual`.`Education1_Degree`, `Individual`.`Education2_Name`, `Individual`.`Education2_Time`, `Individual`.`Education2_Major`, `Individual`.`Education2_Degree`, `Individual`.`Education3_Name`, `Individual`.`Education3_Time`, `Individual`.`Education3_Major`, `Individual`.`Education3_Degree`, `Individual`.`graduationDate`, `Individual`.`proofOfStudentEnrollment`, `Individual`.`createdOnWWW`, `Individual`.`howHeardAboutOther`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isWomenNegotiator`, `Individual`.`isMergeProtected` FROM (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x4F7D00000040 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0041 call
0 rows
0.004 SELECT DISTINCT hex(`MyMeeting`.`MyMeetingId`) AS `MyMeetingId`, `MyMeeting`.`published`, `MyMeeting`.`description`, `MyMeeting`.`mxxCreated`, hex(`MyMeeting`.`mxxCreatedBy`) AS `mxxCreatedBy`, `MyMeeting`.`mxxUpdated`, hex(`MyMeeting`.`mxxUpdatedBy`) AS `mxxUpdatedBy`, `MyMeeting`.`rule`, `MyMeeting`.`introText`, `MyMeeting`.`embedCode` FROM (Meeting, MyMeeting) WHERE `MyMeeting`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0031 call
1 row
0.003 SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2DF91600000001 ORDER BY `CalendarItem`.`startDate`
0.0021 call
1 row
0.002 SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x11F0E000000FD ORDER BY `CalendarItem`.`startDate`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`birthYear`, `Individual`.`mailChimpMergeCache`, `Individual`.`primaryRegion`, `Individual`.`companyType`, `Individual`.`yearsExperience`, `Individual`.`jobDuties`, `Individual`.`jobDutiesDescription`, `Individual`.`seekingParticipation`, `Individual`.`seekingParticipationDescription`, `Individual`.`NOCDuesConsiderations`, `Individual`.`employmentField`, `Individual`.`companyTypeOther`, `Individual`.`isYoungNegotiator`, `Individual`.`Education1_Name`, `Individual`.`Education1_Time`, `Individual`.`Education1_Major`, `Individual`.`Education1_Degree`, `Individual`.`Education2_Name`, `Individual`.`Education2_Time`, `Individual`.`Education2_Major`, `Individual`.`Education2_Degree`, `Individual`.`Education3_Name`, `Individual`.`Education3_Time`, `Individual`.`Education3_Major`, `Individual`.`Education3_Degree`, `Individual`.`graduationDate`, `Individual`.`proofOfStudentEnrollment`, `Individual`.`createdOnWWW`, `Individual`.`howHeardAboutOther`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isWomenNegotiator`, `Individual`.`isMergeProtected` FROM (Address, Individual) WHERE `Address`.`AddressId`=0x11F0E00000101 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Meeting) WHERE `Meeting`.`bannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x2DF91600000016 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Meeting, Website) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x11F0E000000FD
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Meeting`.`MeetingId`) AS `MeetingId`, `Meeting`.`name`, `Meeting`.`hostName`, `Meeting`.`description`, `Meeting`.`audienceDescription`, `Meeting`.`cosponsors`, `Meeting`.`includes`, `Meeting`.`attire`, `Meeting`.`cancellationPolicy`, `Meeting`.`thankYouText`, `Meeting`.`registrationStarts`, `Meeting`.`registrationEnds`, `Meeting`.`earlybirdCutoff`, `Meeting`.`onlineRegistrationsEnabled`, `Meeting`.`selectSessionsOnRegForm`, `Meeting`.`accountingCode`, `Meeting`.`maximumNumAttendees`, `Meeting`.`type`, `Meeting`.`showPublicSessionSearch`, `Meeting`.`allowSpouseReg`, `Meeting`.`continuingEdUnits`, `Meeting`.`mediaAllowed`, `Meeting`.`travelInfo`, `Meeting`.`hotelBlurb`, `Meeting`.`dateClosed`, `Meeting`.`showFeesOnPublicView`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`eventId`, `Meeting`.`staffNotificationEmail`, `Meeting`.`paymentInstructions`, `Meeting`.`staffCancellationEmail`, `Meeting`.`lowRoomTrigger`, `Meeting`.`continuingEdNumber`, `Meeting`.`enableRSVP`, `Meeting`.`micrositePath`, `Meeting`.`bgcolor`, `Meeting`.`accentColor`, `Meeting`.`tabTitleColor`, `Meeting`.`bodyTextColor`, `Meeting`.`linkTextColor`, `Meeting`.`rightNavTextColor`, `Meeting`.`fontTitleSize`, `Meeting`.`fontBodySize`, `Meeting`.`fontName`, `Meeting`.`navbarColor`, `Meeting`.`sidebarColor`, `Meeting`.`highlightedTabTextColor`, `Meeting`.`headlineColor`, `Meeting`.`highlightedTabColor`, `Meeting`.`inSiteAccentColor`, `Meeting`.`inSiteBodyTextColor`, `Meeting`.`inSiteHeadlineColor`, `Meeting`.`inSiteHighlightedTabColor`, `Meeting`.`inSiteHighlightedTabTextColor`, `Meeting`.`inSiteLinkTextColor`, `Meeting`.`inSiteNavbarColor`, `Meeting`.`inSiteRightNavTextColor`, `Meeting`.`inSiteSidebarColor`, `Meeting`.`inSiteTabTitleColor`, `Meeting`.`inSiteFontBodySize`, `Meeting`.`inSiteFontName`, `Meeting`.`inSiteFontTitleSize`, `Meeting`.`useBadges`, `Meeting`.`staffNotificationRevisitedEmail`, `Meeting`.`anticipatedRegistrations`, `Meeting`.`_budgetedRevenue`, `Meeting`.`groupRegistrationOn`, `Meeting`.`allowPlaceholders`, `Meeting`.`feesPageTopText`, `Meeting`.`badgesPageTopText`, `Meeting`.`questionsPageTopText`, `Meeting`.`eventsPageTopText`, `Meeting`.`reviewPageTopText`, `Meeting`.`paymentPageTopText`, `Meeting`.`micrositeTemplate`, `Meeting`.`inSiteTemplate`, `Meeting`.`isWebinar`, `Meeting`.`housingPageTopText`, `Meeting`.`attendeesPageTopText`, `Meeting`.`shortCalDescription`, `Meeting`.`allowAddToCalendar`, `Meeting`.`campaignCode`, `Meeting`.`recordOrigin`, `Meeting`.`additionalFeesPageTopText`, `Meeting`.`referralText`, `Meeting`.`hasReferrals`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived`, `Meeting`.`hideIntranetSummary`, `Meeting`.`showGroupEdit` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x11F0E000000FD
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(`Event`.`EventId`) AS `EventId`, `Event`.`name`, `Event`.`description`, `Event`.`date`, `Event`.`price`, `Event`.`accountingCode`, `Event`.`selectOnRegForm`, `Event`.`maximumNumAttendees`, `Event`.`location`, `Event`.`startTime`, `Event`.`endTime`, `Event`.`notes`, `Event`.`useSignups`, `Event`.`showOnMeetingView`, `Event`.`publishToCalendar`, `Event`.`publishToSchedule` FROM (Meeting, Event) WHERE `Event`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x11F0E000000FD ORDER BY `Event`.`startTime`, `Event`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`birthYear`, `Individual`.`mailChimpMergeCache`, `Individual`.`primaryRegion`, `Individual`.`companyType`, `Individual`.`yearsExperience`, `Individual`.`jobDuties`, `Individual`.`jobDutiesDescription`, `Individual`.`seekingParticipation`, `Individual`.`seekingParticipationDescription`, `Individual`.`NOCDuesConsiderations`, `Individual`.`employmentField`, `Individual`.`companyTypeOther`, `Individual`.`isYoungNegotiator`, `Individual`.`Education1_Name`, `Individual`.`Education1_Time`, `Individual`.`Education1_Major`, `Individual`.`Education1_Degree`, `Individual`.`Education2_Name`, `Individual`.`Education2_Time`, `Individual`.`Education2_Major`, `Individual`.`Education2_Degree`, `Individual`.`Education3_Name`, `Individual`.`Education3_Time`, `Individual`.`Education3_Major`, `Individual`.`Education3_Degree`, `Individual`.`graduationDate`, `Individual`.`proofOfStudentEnrollment`, `Individual`.`createdOnWWW`, `Individual`.`howHeardAboutOther`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isWomenNegotiator`, `Individual`.`isMergeProtected` FROM (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x387600000010 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x11F0E00000102 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`