2012 Technology Leadership Summit: Registration & Housing

REGISTRATION

INDIVIDUAL REGISTRATION RATES

Retailer/Wholesaler (Member)	$249
Retailer/Wholesaler (Non-Member)	$399

CANCELLATION POLICY

Please notify registrar in writing by email to aowusu@fmi.org or fax 202.220.0830. A full refund, less a $75 processing fee is granted when a cancellation is received prior to October 12, 2012. A 60% refund is granted if cancellation is received by October 19, 2012. No refund if notification is received after October 19, 2012.

HOUSING

The official hotel for the 2012 FMI Technology Leadership Summit is the Crowne Plaza O’Hare (http://www.crowneplazaohare.com/)

Crowne Plaza O’Hare

5440 North River Road

Rosemont, Illinois 60018

RESERVATIONS

Room Rate: $156, includes breakfast coupon and free wireless internet in sleeping room.

Cut-off date: October 1, 2012

Make online reservations here: FMI Technology Leadership Summit 2012

Call: 1-877-337-5793 between the hours of 9am – 8pm, Monday – Friday, EST.

Hotel Check-in: 3:00pm

Hotel Check-out: 12 Noon

All reservations must be guaranteed with a credit card or advance deposit. Reservations must be cancelled 72 hours prior to scheduled arrival date.

TRAVEL

The Crowne Plaza Chicago O’Hare Hotel is located 1.5 miles from the Chicago O’Hare Airport (ORD). The hotel provides 24 hour complimentary airport shuttle to and from O’Hare Airport. The pickup location for domestic travelers is at Door 2 of the Shuttle Bus Center.

Taxi’s are readily available in all terminals and the approximate one-way fare is 12 dollars.

Parking is available for 15 dollars per day and is available on a first come, first serve basis.

Debugging Info

pagedictsize=0

sqltime = 0.073 s

cpu time = 0.090 s

real time = 0.174 s

memory increase = 11472 kB

fields =

templates =
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_footer.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_pixel
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index.html

dg = [] | []

extra debug info =

queries = 40 queries

Total Time	Count	Avg Time	Query
0.043	1 call 0 rows	0.043	SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Meeting, Website) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0xA6BE900000001
0.011	1 call 1 row	0.011	SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0xA6BE9000000B5 ORDER BY `MicrositeTabComponent`.`orderindex`
0.007	1 call 1 row	0.007	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`='tech2012'
0.007	1 call 6 rows	0.007	SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (Meeting, MicrositeTab) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0xA6BE900000001
0.007	1 call 6 rows	0.007	SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (Meeting, MicrositeTab) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7A4FA00000005
0.004	1 call 0 rows	0.004	COMMIT
0.002	11 calls 1 row	0.000	SELECT version from databasemap;
0.001	1 call 0 rows	0.001	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`=0xA6BE900000001
0.001	1 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`.`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`.`MeetingId`=0xD6F6A00000232
0.001	1 call 173 rows	0.001	SELECT * FROM webselect
0.001	1 call 1 row	0.001	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`=0xA6BE900000001 ORDER BY `CalendarItem`.`startDate`
0.001	1 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`.`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`.`MeetingId`=0x7A4FA00000005
0.001	1 call 1 row	0.001	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`=0x7A4FA00000005 ORDER BY `CalendarItem`.`startDate`
0.001	1 call 1 row	0.001	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 (Meeting, Address) WHERE `Meeting`.`MeetingId`=0xA6BE900000001 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.001	1 call 1 row	0.001	SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `Meeting`.`bannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0xD6F6A00000232
0.000	1 call 1 row	0.000	SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `Meeting`.`bannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0xA6BE900000001
0.000	1 call 0 rows	0.000	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 (Address, Individual) WHERE `Address`.`AddressId`=0xA6BE90000000C AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.000	1 call 1 row	0.000	SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0xA6BE900000010 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
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`=0xA6BE90000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.000	1 call 0 rows	0.000	UPDATE `PageRequest` SET `mxxUpdated`='2025-09-10 08:47:33',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB4B300000000, `path`='forms/meeting/Microsite/css', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2796850', `requestNum`='1', `objectId`='D6F6A00000232', `growth`='6724', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1589007', `startTime`='2025-09-10 08:47:33', `sessionId`=0x648FEFD2DA6166DC, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.005530834197998047', `timeTaken`='3', `dictSize`='0', `fields`='{\\'id\\':\\'D6F6A00000232\\', \\'sidebar\\':\\'1\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB4B300000000
0.000	1 call 54 rows	0.000	select id, abbreviation from StateProvince
0.000	1 call 1 row	0.000	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 (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x7A4FA00000005 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.000	1 call 1 row	0.000	SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x7A4FA0000003B AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.000	1 call 0 rows	0.000	INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-10 08:49:47',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB4B300000002, `path`='forms/meeting/Microsite/tech2012,2', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2796850', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1589007', `startTime`='2025-09-10 08:49:47', `sessionId`=0x308F92C99E6656D1, `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	UPDATE `PageRequest` SET `mxxUpdated`='2025-09-10 08:47:34',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB4B300000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2796850', `requestNum`='2', `objectId`='7A4FA00000005', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1589007', `startTime`='2025-09-10 08:47:34', `sessionId`=0x648FEFD2DA6166DC, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.00907754898071289', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'7A4FA00000005\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB4B300000001
0.000	1 call 0 rows	0.000	INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-10 08:47:34',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB4B300000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2796850', `requestNum`='2', `pageDictSize`=NULL, `objectId`='7A4FA00000005', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1589007', `startTime`='2025-09-10 08:47:34', `sessionId`=0x648FEFD2DA6166DC, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'7A4FA00000005\\'}', `clientIPAddr`='216.73.216.31'
0.000	1 call 0 rows	0.000	INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-10 08:47:33',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB4B300000000, `path`='forms/meeting/Microsite/css', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2796850', `requestNum`='1', `pageDictSize`=NULL, `objectId`='D6F6A00000232', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1589007', `startTime`='2025-09-10 08:47:33', `sessionId`=0x648FEFD2DA6166DC, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'D6F6A00000232\\', \\'sidebar\\':\\'1\\'}', `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`=0x7A4FA00000031 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.000	1 call 1 row	0.000	SELECT * FROM uuid FOR UPDATE
0.000	1 call 0 rows	0.000	START TRANSACTION

         95984 function calls (92216 primitive calls) in 0.180 seconds

   Ordered by: cumulative time
   List reduced from 1124 to 100 due to restriction <100>

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    0.180    0.180 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest)
        1    0.000    0.000    0.177    0.177 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest)
        1    0.000    0.000    0.169    0.169 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall)
        1    0.000    0.000    0.169    0.169 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:24(index)
        1    0.000    0.000    0.139    0.139 /data/fmiam/current/libs/framework/WebApp.py:298(writeHTMLWithMicrosite)
      4/3    0.000    0.000    0.085    0.028 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__)
        4    0.000    0.000    0.085    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render)
        4    0.000    0.000    0.085    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render)
        4    0.000    0.000    0.084    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context)
        4    0.000    0.000    0.084    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template)
        4    0.000    0.000    0.079    0.020 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML)
       29    0.000    0.000    0.077    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       29    0.000    0.000    0.077    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
       29    0.000    0.000    0.076    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       29    0.076    0.003    0.076    0.003 {function Connection.query at 0xed7a2e536de0}
       13    0.000    0.000    0.073    0.006 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList)
        1    0.000    0.000    0.071    0.071 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header.html.py:31(render_body)
    82/21    0.000    0.000    0.069    0.003 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__)
     10/8    0.000    0.000    0.069    0.009 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc)
        2    0.000    0.000    0.063    0.032 /data/fmiam/current/libs/PLayer/PersistentObject.py:4406(getDescriptionForMeta)
        2    0.000    0.000    0.063    0.032 /data/fmiam/current/libs/PLayer/PersistentObject.py:2693(getCleanAttr)
        1    0.000    0.000    0.063    0.063 /data/fmiam/current/libs/framework/WebApp.py:563(getMetaDescription)
        3    0.000    0.000    0.062    0.021 /data/fmiam/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc)
        3    0.000    0.000    0.062    0.021 /data/fmiam/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL)
    39/12    0.000    0.000    0.057    0.005 :934(exec_module)
  400/229    0.000    0.000    0.056    0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter)
  413/229    0.001    0.000    0.056    0.000 {built-in method builtins.__import__}
     30/3    0.000    0.000    0.055    0.018 :1165(_find_and_load)
     30/3    0.000    0.000    0.055    0.018 :1120(_find_and_load_unlocked)
    82/13    0.000    0.000    0.055    0.004 :233(_call_with_frames_removed)
     30/3    0.000    0.000    0.055    0.018 :666(_load_unlocked)
    39/12    0.000    0.000    0.054    0.005 {built-in method builtins.exec}
        1    0.000    0.000    0.050    0.050 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:51(render_original_microsite_startOfContent)
        1    0.000    0.000    0.049    0.049 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:56(micrositeBannerAndNav)
        1    0.000    0.000    0.049    0.049 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:347(render_micrositeBannerAndNav)
        1    0.000    0.000    0.048    0.048 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:352(microsite_sidebar)
        1    0.000    0.000    0.048    0.048 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:244(render_microsite_sidebar)
        1    0.000    0.000    0.042    0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1()
       41    0.000    0.000    0.035    0.001 /usr/lib/python3.11/re/__init__.py:272(_compile)
       27    0.000    0.000    0.034    0.001 /usr/lib/python3.11/re/__init__.py:225(compile)
        1    0.000    0.000    0.034    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1()
       19    0.000    0.000    0.034    0.002 /usr/lib/python3.11/re/_compiler.py:740(compile)
    65/33    0.000    0.000    0.030    0.001 :1207(_handle_fromlist)
        6    0.021    0.003    0.021    0.003 /data/fmiam/current/libs/utils/htmlTools.py:53(init)
       19    0.000    0.000    0.018    0.001 /usr/lib/python3.11/re/_compiler.py:573(_code)
        1    0.000    0.000    0.018    0.018 /data/fmiam/current/generic/classes/Meeting.py:3279(getSingleLineAddress)
        2    0.000    0.000    0.017    0.009 /data/fmiam/current/generic/classes/Address.py:297(getPrintPlain)
        2    0.000    0.000    0.017    0.009 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML)
        1    0.000    0.000    0.017    0.017 /data/fmiam/current/generic/classes/Address.py:323(getPrintPlainSingleLine)
        1    0.000    0.000    0.016    0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1()
        2    0.000    0.000    0.016    0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean)
       19    0.000    0.000    0.015    0.001 /usr/lib/python3.11/re/_parser.py:979(parse)
    73/19    0.001    0.000    0.015    0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub)
   654/19    0.006    0.000    0.015    0.001 /usr/lib/python3.11/re/_parser.py:516(_parse)
        2    0.000    0.000    0.015    0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__)
        2    0.000    0.000    0.014    0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__)
        2    0.000    0.000    0.014    0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__)
        1    0.000    0.000    0.013    0.013 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index.html.py:31(render_body)
   703/19    0.004    0.000    0.013    0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile)
        2    0.000    0.000    0.012    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder)
        1    0.000    0.000    0.012    0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/etree.py:1()
        1    0.000    0.000    0.011    0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1()
        1    0.000    0.000    0.011    0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1()
       53    0.010    0.000    0.011    0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset)
        1    0.000    0.000    0.009    0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re)
        1    0.000    0.000    0.008    0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re)
        1    0.000    0.000    0.008    0.008 /data/fmiam/current/generic/classes/Meeting.py:3336(getMeetingByMicrositePath)
        1    0.000    0.000    0.008    0.008 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria)
        9    0.000    0.000    0.008    0.001 /data/fmiam/current/generic/classes/Meeting.py:3350(getTabs)
       39    0.000    0.000    0.007    0.000 :1007(get_code)
        8    0.000    0.000    0.007    0.001 /data/fmiam/current/libs/framework/BaseHandler.py:312(getTemplate)
      7/5    0.000    0.000    0.007    0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc)
      7/5    0.000    0.000    0.007    0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL)
       71    0.001    0.000    0.006    0.000 {built-in method builtins.__build_class__}
        1    0.000    0.000    0.006    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:1()
       19    0.000    0.000    0.006    0.000 /usr/lib/python3.11/re/_compiler.py:511(_compile_info)
        1    0.000    0.000    0.005    0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:1()
        6    0.000    0.000    0.005    0.001 /data/fmiam/current/libs/framework/BaseHandler.py:596(getTemplateDefaults)
       39    0.000    0.000    0.005    0.000 :727(_compile_bytecode)
       39    0.004    0.000    0.004    0.000 {built-in method marshal.loads}
    12/11    0.000    0.000    0.004    0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow)
        1    0.000    0.000    0.004    0.004 /tmp/mako_modules_1011/fmiam/www/25.1.1/helpers/meetingHelpers.html.py:57(render_addToCalendarWidget)
        1    0.000    0.000    0.004    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:159(Version)
        9    0.000    0.000    0.003    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:239(__init__)
       30    0.000    0.000    0.003    0.000 :1054(_find_spec)
        1    0.003    0.003    0.003    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/serializer.py:1()
        1    0.000    0.000    0.003    0.003 /data/fmiam/current/libs/framework/WebSite.py:420(outputDebugTable)
       12    0.000    0.000    0.003    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:562(__init__)
        9    0.000    0.000    0.003    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:403(_compile_from_file)
        8    0.000    0.000    0.003    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:830(_lookup_template)
        8    0.000    0.000    0.003    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/lookup.py:238(get_template)
     4074    0.002    0.000    0.003    0.000 /usr/lib/python3.11/re/_parser.py:261(get)
       30    0.000    0.000    0.003    0.000 :1499(find_spec)
        7    0.000    0.000    0.003    0.000 /data/fmiam/current/libs/framework/Auth.py:414(getValidSessionRecord)
       30    0.000    0.000    0.003    0.000 :1467(_get_spec)
        9    0.000    0.000    0.003    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/compat.py:106(load_module)
        1    0.000    0.000    0.003    0.003 /data/fmiam/current/generic/classes/Meeting.py:160(getContentDate)
        1    0.000    0.000    0.003    0.003 /data/fmiam/current/generic/classes/Meeting.py:152(getStartDate)
        1    0.000    0.000    0.003    0.003 /data/fmiam/current/libs/framework/WebForm.py:94(__init__)
        1    0.000    0.000    0.002    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_inputstream.py:1()