October 21-22, 2015 Fall MEETING

TO: FMI ICC Council

FROM: Pat Walsh

RE: Industry Collaboration Council Meeting, October 21-22, 2015

DATE: August 26, 2015

As previously announced at our last ICC meeting in April, the next FMI Industry Collaboration Council and Committee meeting will be held on October 21-22, 2015. The meeting will take place at the following location:

Westfields Marriott

14750 Conference Center Drive

Chantilly, Virginia 20151

Phone: (703) 818-0300

Online: Reservation Link

Room Rate: $ 199.00

Cut-off date for reservations : September 25. Please contact Adell if you need a room after this date.

Complimentary internet access.

Airport Info: The hotel is 8.5 miles from Washington Dulles International Airport and the estimated taxi fare is approximately $30.76.

The hotel is 29.3miles from the Ronald Reagan Washington National Airport and the estimated taxi fare is approximately $82.05.

Please plan your air travel arrangements as soon as possible to arrive on Tuesday, October 20. The meeting will begin at 8:00 am on Wednesday, October 21 and conclude by 12:00 pm on Thursday October 22.

Please visit www.fmi.org/icc, click on the link for the October 2015 meeting, and select the register now button to register for the meeting by September 25. If you plan to send a representative for your company, please forward the individual’s name to Adell Cokley at acokley@fmi.org. If you would like your assistant to have access to this site, please forward their name and email address to Adell as well.

Please click on the “Hotel & Logistics” tab for complete meeting and registration information. Our room block closes on September 25. If you need a room after that date, please contact Adell

For Members of the ICC Leadership Committee Only: We will be holding a joint reception and dinner with the FMI Executive Committee and Finance Committee the evening of Tuesday, October 20 at 6:30p at the FMI offices. You can arrange your arrival flight into Reagan National Airport and depart out of Dulles Airport if that is convenient. If you elect to fly into and out of Dulles Airport a shuttle will be departing from the Westfield at 4:30 pm to transport you to the FMI offices.

I hope this information is helpful. The draft agenda is attached for your review. Additional background materials will follow at a later date. If you have any questions concerning the meeting please contact Adell Cokley at (202) 220-0708 or at acokley@fmi.org or me.

I look forward to seeing you in Virginia.

Total Time

Count

Avg Time

Query

0.196

1 call
1 row

0.196

SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Meeting, Website) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2ED98B000001AD

0.060

1 call
1 row

0.060

SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0x2ED98B000001B9 ORDER BY `MicrositeTabComponent`.`orderindex`

0.040

1 call
6 rows

0.040

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`=0x20D59100000062

0.039

1 call
1 row

0.039

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`.`eventId`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `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`.`apptScheduler`, `Meeting`.`hasReferrals`, `Meeting`.`referralText`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived` FROM (Meeting) WHERE `Meeting`.`micrositePath`='FMIICCMeeting_2015'

0.029

1 call
6 rows

0.029

0.028

1 call
6 rows

0.028

0.027

18 calls
1 row

0.001

SELECT version from databasemap;

0.011

1 call
0 rows

0.011

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:42',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000004, `path`='forms/meeting/Microsite/css', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='5', `objectId`='5B2CF10000037E', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.007225513458251953', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'5B2CF10000037E\\', \\'sidebar\\':\\'1\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000004

0.009

1 call
2 rows

0.009

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 (Fee, Meeting) WHERE `Fee`.`itemId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2ED98B000001AD

0.009

1 call
1 row

0.009

SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (FeeDateRange, Meeting) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2ED98B000001AD

0.009

1 call
1 row

0.009

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 (MyMeeting, Meeting) WHERE `MyMeeting`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2ED98B000001AD

0.007

1 call
1 row

0.007

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`, `Address`.`dateVerified` FROM (Address, Meeting) WHERE `Meeting`.`MeetingId`=0x55B48000000049 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.007

1 call
0 rows

0.007

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:43',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000008, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='9', `objectId`='7741BD00000003', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:43', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0424647331237793', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'7741BD00000003\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000008

0.006

1 call
1 row

0.006

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`, `Address`.`dateVerified` FROM (Address, Meeting) WHERE `Meeting`.`MeetingId`=0x20D59100000062 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.006

1 call
0 rows

0.006

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`=0x55B48000000057 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.006

1 call
1 row

0.006

SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x55B48000000055 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.006

1 call
0 rows

0.006

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:42',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000003, `path`='forms/meeting/Microsite/PrivateBrands2013,5', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='4', `growth`='16732', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:41', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.39734435081481934', `timeTaken`='13', `dictSize`='0', `fields`='{}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000003

0.005

1 call
1 row

0.005

SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x2ED98B000001C5 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.005

1 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`, `Address`.`dateVerified` FROM (Address, Meeting) WHERE `Meeting`.`MeetingId`=0x7741BD00000003 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.005

1 call
1 row

0.005

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 (CalendarItem, Meeting) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x55B48000000049 ORDER BY `CalendarItem`.`startDate`

0.005

1 call
1 row

0.005

1 call
1 row

0.005

0.004

1 call
1 row

0.004

SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x20D591000000B4 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.004

1 call
0 rows

0.004

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:42',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000007, `path`='forms/meeting/Microsite/css', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='8', `pageDictSize`=NULL, `objectId`='63837A00000803', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'63837A00000803\\', \\'sidebar\\':\\'1\\'}', `clientIPAddr`='216.73.216.31'

0.004

1 call
1 row

0.004

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`=0x2ED98B000001AD

0.004

1 call
0 rows

0.004

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`=0x20D59100000071 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.004

1 call
0 rows

0.004

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:42',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000005, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='6', `objectId`='20D59100000062', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.06271529197692871', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'20D59100000062\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000005

0.004

1 call
0 rows

0.004

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:42',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000006, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='7', `objectId`='55B48000000049', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.028017282485961914', `timeTaken`='2', `dictSize`='0', `fields`='{\\'id\\':\\'55B48000000049\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000006

0.004

1 call
0 rows

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`.`isTrainer`, `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`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, Address) WHERE `Address`.`AddressId`=0x2ED98B000001B1 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.004

1 call
1 row

0.004

0.003

1 call
0 rows

0.003

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:42',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000004, `path`='forms/meeting/Microsite/css', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='5', `pageDictSize`=NULL, `objectId`='5B2CF10000037E', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'5B2CF10000037E\\', \\'sidebar\\':\\'1\\'}', `clientIPAddr`='216.73.216.31'

0.003

1 call
1 row

0.003

1 call
0 rows

0.003

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:42',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000005, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='6', `pageDictSize`=NULL, `objectId`='20D59100000062', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'20D59100000062\\'}', `clientIPAddr`='216.73.216.31'

0.003

1 call
1 row

0.003

0.002

1 call
1 row

0.002

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`, `Address`.`dateVerified` FROM (Address, Meeting) WHERE `Meeting`.`MeetingId`=0x2ED98B000001AD AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.002

1 call
1 row

0.002

1 call
54 rows

0.002

SELECT * FROM StateProvince ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:42',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000006, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='7', `pageDictSize`=NULL, `objectId`='55B48000000049', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'55B48000000049\\'}', `clientIPAddr`='216.73.216.31'

0.002

1 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`=0x7741BD00000018 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
0 rows

0.001

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:43',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000007, `path`='forms/meeting/Microsite/css', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='8', `objectId`='63837A00000803', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:42', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.011954784393310547', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'63837A00000803\\', \\'sidebar\\':\\'1\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000007

0.001

1 call
1 row

0.001

1 call
0 rows

0.001

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:43',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000008, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='9', `pageDictSize`=NULL, `objectId`='7741BD00000003', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:43', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'7741BD00000003\\'}', `clientIPAddr`='216.73.216.31'

0.000

1 call
0 rows

0.000

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`=0x2ED98B000001B1 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:43',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000009, `path`='forms/meeting/Microsite/FMIICCMeeting_2015,0', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='10', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:43', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.31'

0.000

1 call
0 rows

0.000

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`=0x7741BD00000008 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

24092 function calls (23721 primitive calls) in 0.485 seconds Ordered by: cumulative time List reduced from 909 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.485 0.485 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 0.472 0.472 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.431 0.431 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall) 1 0.000 0.000 0.431 0.431 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:24(index) 31 0.000 0.000 0.416 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 31 0.000 0.000 0.416 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 31 0.000 0.000 0.415 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 31 0.415 0.013 0.415 0.013 {function Connection.query at 0xe3777a0b6980} 15 0.000 0.000 0.371 0.025 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 12/10 0.000 0.000 0.339 0.034 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 4/3 0.000 0.000 0.330 0.110 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 4 0.000 0.000 0.330 0.082 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 4 0.000 0.000 0.330 0.082 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 4 0.000 0.000 0.329 0.082 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 110/33 0.000 0.000 0.329 0.010 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 4 0.000 0.000 0.329 0.082 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.314 0.314 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index_responsive.html.py:31(render_body) 5 0.000 0.000 0.304 0.061 /data/fmiam/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc) 5 0.000 0.000 0.304 0.061 /data/fmiam/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL) 1 0.000 0.000 0.250 0.250 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:244(render_microsite_sidebar) 8 0.000 0.000 0.042 0.005 /data/fmiam/current/libs/framework/BaseHandler.py:312(getTemplate) 6 0.000 0.000 0.040 0.007 /data/fmiam/current/libs/framework/BaseHandler.py:596(getTemplateDefaults) 1 0.000 0.000 0.039 0.039 /data/fmiam/current/generic/classes/Meeting.py:3336(getMeetingByMicrositePath) 1 0.000 0.000 0.039 0.039 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 1 0.000 0.000 0.036 0.036 /data/fmiam/current/generic/classes/Meeting.py:2163(getIsAcceptingOnlineRegistrations) 1 0.000 0.000 0.036 0.036 /data/fmiam/current/generic/classes/Meeting.py:2120(getNoOnlineRegistrationsReason) 1 0.000 0.000 0.036 0.036 /data/fmiam/current/libs/framework/WebApp.py:298(writeHTMLWithMicrosite) 7/5 0.000 0.000 0.034 0.007 /data/fmiam/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 7/5 0.000 0.000 0.034 0.007 /data/fmiam/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 7 0.000 0.000 0.033 0.005 /data/fmiam/current/libs/framework/Auth.py:414(getValidSessionRecord) 6 0.000 0.000 0.030 0.005 /data/fmiam/current/libs/framework/WebSite.py:1076(getImpersonatingUser) 10 0.000 0.000 0.029 0.003 /data/fmiam/current/generic/classes/Meeting.py:3350(getTabs) 2 0.000 0.000 0.024 0.012 /data/fmiam/current/generic/classes/Meeting.py:1976(getDateRegistrationStarts) 1 0.002 0.002 0.023 0.023 /data/fmiam/current/libs/framework/WebSite.py:420(outputDebugTable) 73 0.000 0.000 0.020 0.000 /data/fmiam/current/libs/framework/WebSite.py:1285(debugHTML) 1 0.000 0.000 0.016 0.016 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_responsive.html.py:28(render_body) 73 0.000 0.000 0.014 0.000 /data/fmiam/current/libs/framework/WebSite.py:925(writeHTML) 2 0.000 0.000 0.014 0.007 /data/fmiam/current/libs/framework/WebSite.py:698(_logPageRequest) 2 0.000 0.000 0.013 0.007 /data/fmiam/current/libs/PLayer/PersistentObject.py:679(saveWithoutABS) 74 0.001 0.000 0.013 0.000 /data/fmiam/current/libs/framework/MaxxRequestWrapper.py:53(write) 74 0.000 0.000 0.012 0.000 /data/fmiam/current/libs/framework/wsgiapp.py:286(write) 1 0.000 0.000 0.011 0.011 /data/fmiam/current/libs/framework/WebForm.py:94(__init__) 74 0.011 0.000 0.011 0.000 {uwsgi_write} 7 0.000 0.000 0.010 0.001 /data/fmiam/current/libs/PLayer/PersistentBroker.py:336(processSql) 1 0.000 0.000 0.010 0.010 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:82(render_responsive_microsite_startOfContent) 17/16 0.000 0.000 0.010 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow) 1 0.000 0.000 0.009 0.009 /data/fmiam/current/generic/classes/Meeting.py:2839(getBannerWidth) 1 0.000 0.000 0.009 0.009 /data/fmiam/current/libs/framework/WebSite.py:603(logEndRequest) 1 0.000 0.000 0.009 0.009 /data/fmiam/current/generic/classes/Meeting.py:3520(shouldShowMeetingDocuments) 48 0.008 0.000 0.008 0.000 {method 'strftime' of 'datetime.date' objects} 6 0.000 0.000 0.008 0.001 /data/fmiam/current/libs/framework/BaseHandler.py:590(getDevDataTime) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/libs/PLayer/ClassMap.py:129(getUpdateSqlFor) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/libs/PLayer/SQLStatement.py:590(buildForObject) 32 0.000 0.000 0.008 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DateTimeBackup.py:31(__init__) 4 0.000 0.000 0.008 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DateTimeBackup.py:116(ISO) 1 0.000 0.000 0.008 0.008 /tmp/mako_modules_1011/fmiam/www/25.1.1/helpers/meetingHelpers.html.py:57(render_addToCalendarWidget) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/generic/classes/CalendarItem.py:59(processAfterRetrieve) 1 0.000 0.000 0.006 0.006 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:12(getHeader) 21 0.000 0.000 0.006 0.000 /data/fmiam/current/libs/utils/dateutils.py:146(MakeDateTime) 1 0.000 0.000 0.006 0.006 /data/fmiam/current/generic/classes/Meeting.py:3266(getGoogleLink) 1 0.000 0.000 0.006 0.006 /data/fmiam/current/libs/utils/calendarUtils.py:10(getGoogleLink) 897 0.006 0.000 0.006 0.000 /data/fmiam/current/libs/framework/MaxxRequestWrapper.py:25(__getattribute__) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/libs/framework/WebSite.py:559(logBeginRequest) 2 0.000 0.000 0.005 0.003 /data/fmiam/current/generic/classes/Address.py:297(getPrintPlain) 2 0.000 0.000 0.005 0.003 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML) 2 0.000 0.000 0.005 0.003 /data/fmiam/current/generic/classes/Meeting.py:3328(getLocation) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/generic/classes/File.py:63(getImageSize) 1 0.000 0.000 0.005 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:3081(open) 1 0.000 0.000 0.005 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:3146(_open_core) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:18(getFooter) 1 0.000 0.000 0.005 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/JpegImagePlugin.py:798(jpeg_factory) 1 0.000 0.000 0.005 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/ImageFile.py:87(__init__) 1 0.000 0.000 0.005 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/JpegImagePlugin.py:346(_open) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/libs/framework/WebApp.py:638(getFooter) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/generic/classes/Meeting.py:3279(getSingleLineAddress) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/generic/classes/Address.py:323(getPrintPlainSingleLine) 1 0.000 0.000 0.004 0.004 /data/fmiam/current/libs/PLayer/ClassMap.py:121(getInsertSqlFor) 1 0.004 0.004 0.004 0.004 /data/fmiam/current/libs/PLayer/SQLStatement.py:687(buildForObject) 10 0.000 0.000 0.004 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:1270(parse) 10 0.000 0.000 0.004 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:572(parse) 1 0.000 0.000 0.004 0.004 /data/fmiam/current/libs/framework/Auth.py:85(getUserAndSession) 1 0.000 0.000 0.004 0.004 /data/fmiam/current/libs/framework/Auth.py:367(hasValidSession) 10 0.000 0.000 0.004 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:666(_parse) 1 0.000 0.000 0.003 0.003 /data/fmiam/current/generic/classes/Meeting.py:1993(getDateRegistrationEnds) 10 0.000 0.000 0.003 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:199(split) 13 0.000 0.000 0.003 0.000 /data/fmiam/current/libs/PLayer/SQLStatement.py:482(buildForCriteria) 108 0.000 0.000 0.003 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:189(__next__) 2 0.000 0.000 0.003 0.001 {built-in method builtins.min} 13 0.000 0.000 0.003 0.000 /data/fmiam/current/libs/PLayer/SQLStatement.py:342(buildForObject) 4 0.000 0.000 0.003 0.001 /data/fmiam/current/generic/classes/Meeting.py:1984() 1 0.000 0.000 0.003 0.003 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:406(render_responsive_footer) 108 0.000 0.000 0.003 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:77(get_token) 14 0.002 0.000 0.003 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/pytz/tzinfo.py:258(localize) 5 0.000 0.000 0.003 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/JpegImagePlugin.py:60(APP) 673/671 0.002 0.000 0.002 0.000 {built-in method builtins.len} 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/BaseHandler.py:1215(WSKey2Value) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/WebManInterface.py:37(readWebSelect) 63 0.002 0.000 0.002 0.000 {method 'pop' of 'list' objects} 15 0.000 0.000 0.002 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/ImageFile.py:539(_safe_read)