EPA's HFC Management Final Rule with Hunton Andrews Kurth

Monday, December 9, 2024
1:00 pm ET / 12:00 pm CT / 11:00 am MT/ 10:00 am PT

Description:  

The Environmental Protection Agency (EPA) recently finalized the Phasedown of Hydrofluorocarbons: Management of Certain Hydrofluorocarbons and Substitutes Under the American Innovation and Manufacturing Act of 2020 (HFC Management) Final Rule. The rule is the third component of a series of rulemakings required under the American Innovation and Manufacturing (AIM) Act and establishes a new program for the management, recycling, and reuse of Hydrofluorocarbons (HFCs), synthetic gases primarily used for refrigeration and cooling.

Hear from the law firm Hunton Andrews Kurth who will provide an overview of the final rule, addressing how it differs from the proposed rule and whether requests made in our previous association coalition comments were included. Hunton will be available to answer question on the final rule, so please submit anything you would like addressed to Erin McCarthy prior to the webinar so that presenters can come prepared.

This digital seminar is hosted in conjunction with The National Grocers Association, The National Retail Federation and The Retail Industry Leaders Association.

David Terry, Counsel, Hunton Andrews Kurth LLP

Matt Leopold, Partner, Hunton Andrews Kurth LLP

David Terry, Counsel, Hunton Andrews Kurth LLP

David Terry, Counsel, Hunton Andrews Kurth LLP

Explore FMI's Digital Seminars

 

EPA's HFC Management Final Rule with Hunton Andrews Kurth

Virtual

Debugging Info
pagedictsize=0
sqltime = 0.215 s
cpu time = 0.060 s
real time = 0.345 s
memory increase = 5120 kB
fields =
templates =
/data/fmiam/current/generic/themes/shared/vue-apps/maxx-theme/dist/.vite/manifest.json
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_footer.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_pixel
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_responsive.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index_responsive.html
dg = [] | []
extra debug info =
queries = 66 queries

Total TimeCountAvg TimeQuery
0.1251 call
1 row		0.125 SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0xAEA7E300000007 ORDER BY `MicrositeTabComponent`.`orderindex`
0.0361 call
1 row		0.036 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`, `Meeting`.`hideIntranetSummary`, `Meeting`.`finePrint` FROM (Meeting) WHERE `Meeting`.`micrositePath`='HFCManagement'
0.0271 call
1086 rows		0.027 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (0x7150F900000001, 0x2BD5000083B7, 0x46C48B00000097, 0xDF0C0000000E, 0xBFF27600000006, 0x3B8E6000005E0, 0x2BD500019EBE, 0x6D2F00000001, 0x2BD500007513, 0x819D3000000005, 0xA09300000036, 0x4AAEA40000001B, 0x4C1CF8000001C6, 0xE6409600000005, 0x2BD500016891, 0x2BD5000240FE, 0x2BD50001DF51, 0x2BD500003D74, 0x2BD500001B3F, 0x4CB5500000C56, 0xF5C44400000001, 0x206340000003D, 0x2BD500003669, 0x2BD5000046BF, 0x2BD50001ECF6, 0x1F72B1000001F0, 0x2BD50001C604, 0x14F5580000005D, 0x60FF3B00000636, 0x7D4D4B00000009, 0x6694F0000012B, 0xE5040800000008, 0x6D42610000005B, 0x2BD500015AC9, 0xD5D800000011, 0x2BD50001AC34, 0x109465F00000001, 0x1FE400000029, 0x2BD50001CEC6, 0x81BE4D00000006, 0x386BB00000065, 0x2BD5000004C0, 0x2BD50001FC97, 0x2BD50001C1F7, 0x1172600000000, 0xFD620F00000002, 0x2BD50001D49F, 0x2BD50001D553, ...3253C0000007D, 0x2BD500025400, 0x6F1ECC00000033, 0x2BD5000227A3, 0x2BD500024E7D, 0x2BD5000227BF, 0x1881400000050, 0x2BD500021DD7, 0x2A1BAE000004A0, 0x1D821C000001B7, 0x2BD500023ACB, 0x2BD500022CEB, 0x2BD500022598, 0x2BD5000225D7, 0x2BD5000252BB, 0x2BD500014FC9, 0x8697A000001F3, 0x8695700000191, 0x869840000004B, 0x4DED1E0000013D, 0x2BD500021E50, 0x2BD500025407, 0x869760000028E, 0x2BD500024361, 0x2BD500024368, 0x2BD50002436F, 0x4D45200000463, 0x7336860000000E, 0x29675600000009, 0x296765000001CE, 0x29677500000038, 0x29678500000044, 0x2717B0000000D, 0x2BD5000242D7, 0x271780000007F, 0x2BD5000242DE, 0x67C69300000074, 0x627F5D0000021F, 0x627DFF00000B00, 0x627E2300000006, 0x9FC76600000001, 0x5BD614000000AB, 0x2BD50000F295, 0x9FC7A800000001, 0x1E6B200000031, 0x3B624900000001, 0x1E6B800000007, 0x2BD500022575, 0x3B6249000000B5, 0x3B6237000004B2, 0x1E6BA00000015, 0x1E6B800000026, 0x1E6AF0000003F, 0x452DD3000000A3, 0x3B611B0000005D, 0x31AADA000000F4, 0x107B98B00000001, 0x86966000005A5, 0x6F0BA600000005, 0x29678C0000003F, 0x2967A600000001, 0x8697600000053, 0xAC20F600000001, 0x8E770000005E, 0x2BD500025425, 0x2BD5000223E5, 0x98EA00000013, 0x2BD500002CDD, 0x4DED6C000002EB, 0x2EA4200000005, 0x2BD5000248D5, 0xA6BC6300000005, 0x5F1A3D0000013E, 0x2BD500015188, 0x2BD500025434, 0xD3A500000001, 0x2BD500002E0B, 0x514A0F00000010, 0x2BD5000233A6, 0x3B61CC000003F2, 0x2BD500022C5F, 0x2BD50002521B, 0x2BD5000047EB, 0x2BD5000224DD, 0x2BD500024E6F, 0x2BD5000254B3, 0x2BD50002547A, 0x2BD500023D5E, 0x6A575900000320, 0x1409A00000000, 0x8696600000539, 0x36C8400000006, 0x2BD50002549D, 0x2967B70000000F, 0x4F642900000127, 0x46240100000019, 0x13B7D600000005, 0x23E41400000039, 0x2967CB0000001F, 0x2D3C8C00000235, 0x6FE3E800003247, 0x70146600000007, 0x293D6B0000004C, 0x167560000004F, 0x293D6F0000020C, 0x2BD50002428F, 0x31A7810000019F, 0x4407000000B90, 0x293DBB000000FB, 0x2BD50002280C, 0x2BD50002257C, 0x2BD500022813, 0x2BD500023C8F, 0x33240500000671, 0x2BD500022583, 0x62DF3800000120, 0x2BD500022821, 0x2DA1CC00000013, 0x2BD50002258A, 0x2DA1DC00000001, 0x50D19B00000028, 0x2BD50002281A, 0x1D9CA00000032, 0x2BD50000D448, 0x9A4000000046, 0x2964DF00000085, 0x9D0F0500000006, 0x78CB30000045E, 0x293DC1000002EE, 0x2BD500022193, 0x8693200000398, 0x39950800000791, 0x293DD000000060, 0x2BD5000229D3, 0x2BD500015FA4, 0x2BD500006331, 0xB2FD5A00000001, 0x2BD50002252E, 0x132B700000009, 0x2BD500023D7B, 0x2BD500011954, 0x293DDA00000063, 0x293DE300000030, 0x7C64DD000000A7, 0x70AE00000019, 0x4C15860000001F, 0x457D600001182, 0x2BD500023C81, 0x4DED5300000B03, 0x9CD80D00000006, 0x2AFE91000000A8, 0x5BA5FA00000255, 0x1793400000025, 0x5EF41500000072, 0x2BD50000E855, 0x2BD50000EE6C, 0x2BD50002053B, 0x1660700000038, 0x12A6D00000000, 0x12B6500000003, 0xD6A200000012, 0x2BD50001BDC9, 0x2BD500014FA7, 0x2BD50000E2AF, 0x2BD500009672, 0x4614E9000001CA, 0x293DEC000000A8, 0x2BD50002233C, 0x7886C100000014, 0x8692D00000037, 0x4D0148000002F7, 0x69F31E0000000E, 0x293DEC00000145, 0x2BD50000E533, 0x3B61E100000011, 0x4774E00000001, 0x398185000000CA, 0x29504C00000458, 0x2BD500024D43, 0x2BD5000244D8, 0x2BD5000254C2, 0x2950900000003C, 0x86914000003C5, 0x21CC7300000282, 0x2BD5000254C9, 0x2BD500011A96, 0x5AE75B0000000E, 0x2BD500011091, 0x20FAD4000000D0, 0x89976000000C2, 0x2BD5000094B2, 0x2BD50000817A, 0x90C20000000A, 0x385A90000000E, 0x2BD50001355F, 0x90D500000000, 0x3AA92700000136, 0x2BD500022772, 0x2BD5000003C2, 0x61F93000000008, 0x2BD500003326, 0x4B8FB000000754, 0x29508800000506, 0x7C873C00000007, 0x2950A5000000B2, 0x2950880000059C, 0x2950BE0000007A, 0x1E2E100000054, 0x2BD500009938, 0x31AABC00000197, 0xD40000000012, 0x2BD500000257, 0x3B61E1000000CA, 0x2BD500000261, 0x8685700000057, 0x2BD50001A842, 0x31AAEF000000B7, 0x2BD50000CFA2, 0x73E3EF00000008, 0x3A9C500000001F, 0x384F00000000A, 0x2950E100000030, 0x2BD5000219FA, 0x2BD500003271, 0x8684A0000058C, 0x2950E10000007C, 0x3D09B00000025, 0x2BD500017646, 0x4AF51C00000076)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0251 call
1088 rows		0.025 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (0x7150F900000001, 0x2BD5000083B7, 0x46C48B00000097, 0xDF0C0000000E, 0xBFF27600000006, 0x3B8E6000005E0, 0x2BD500019EBE, 0x6D2F00000001, 0x2BD500007513, 0x819D3000000005, 0xA09300000036, 0x4AAEA40000001B, 0x4C1CF8000001C6, 0xE6409600000005, 0x2BD500016891, 0x2BD5000240FE, 0x2BD50001DF51, 0x2BD500003D74, 0x2BD500001B3F, 0x4CB5500000C56, 0xF5C44400000001, 0x206340000003D, 0x2BD500003669, 0x2BD5000046BF, 0x2BD50001ECF6, 0x1F72B1000001F0, 0x2BD50001C604, 0x14F5580000005D, 0x60FF3B00000636, 0x7D4D4B00000009, 0x6694F0000012B, 0xE5040800000008, 0x6D42610000005B, 0x2BD500015AC9, 0xD5D800000011, 0x2BD50001AC34, 0x109465F00000001, 0x1FE400000029, 0x2BD50001CEC6, 0x81BE4D00000006, 0x386BB00000065, 0x2BD5000004C0, 0x2BD50001FC97, 0x2BD50001C1F7, 0x1172600000000, 0xFD620F00000002, 0x2BD50001D49F, 0x2BD50001D553, ...D3A500000001, 0x2BD500002E0B, 0x514A0F00000010, 0x2BD5000233A6, 0x3B61CC000003F2, 0x2BD500022C5F, 0x2BD50002521B, 0x2BD5000047EB, 0x2BD5000224DD, 0x2BD500024E6F, 0x2BD5000254B3, 0x2BD50002547A, 0x2BD500023D5E, 0x6A575900000320, 0x1409A00000000, 0x8696600000539, 0x36C8400000006, 0x2BD50002549D, 0x2967B70000000F, 0x4F642900000127, 0x46240100000019, 0x13B7D600000005, 0x23E41400000039, 0x2967CB0000001F, 0x2D3C8C00000235, 0x6FE3E800003247, 0x70146600000007, 0x293D6B0000004C, 0x167560000004F, 0x293D6F0000020C, 0x2BD50002428F, 0x31A7810000019F, 0x4407000000B90, 0x293DBB000000FB, 0x2BD50002280C, 0x2BD50002257C, 0x2BD500022813, 0x2BD500023C8F, 0x33240500000671, 0x2BD500022583, 0x62DF3800000120, 0x2BD500022821, 0x2DA1CC00000013, 0x2BD50002258A, 0x2DA1DC00000001, 0x50D19B00000028, 0x2BD50002281A, 0x1D9CA00000032, 0x2BD50000D448, 0x9A4000000046, 0x2964DF00000085, 0x9D0F0500000006, 0x78CB30000045E, 0x293DC1000002EE, 0x2BD500022193, 0x8693200000398, 0x39950800000791, 0x293DD000000060, 0x2BD5000229D3, 0x2BD500015FA4, 0x2BD500006331, 0xB2FD5A00000001, 0x2BD50002252E, 0x132B700000009, 0x2BD500023D7B, 0x2BD500011954, 0x293DDA00000063, 0x293DE300000030, 0x7C64DD000000A7, 0x70AE00000019, 0x4C15860000001F, 0x457D600001182, 0x2BD500023C81, 0x4DED5300000B03, 0x9CD80D00000006, 0x2AFE91000000A8, 0x5BA5FA00000255, 0x1793400000025, 0x5EF41500000072, 0x2BD50000E855, 0x2BD50000EE6C, 0x2BD50002053B, 0x1660700000038, 0x12A6D00000000, 0x12B6500000003, 0xD6A200000012, 0x2BD50001BDC9, 0x2BD500014FA7, 0x2BD50000E2AF, 0x2BD500009672, 0x4614E9000001CA, 0x293DEC000000A8, 0x2BD50002233C, 0x7886C100000014, 0x8692D00000037, 0x4D0148000002F7, 0x69F31E0000000E, 0x293DEC00000145, 0x2BD50000E533, 0x3B61E100000011, 0x4774E00000001, 0x398185000000CA, 0x29504C00000458, 0x2BD500024D43, 0x2BD5000244D8, 0x2BD5000254C2, 0x2950900000003C, 0x86914000003C5, 0x21CC7300000282, 0x2BD5000254C9, 0x2BD500011A96, 0x5AE75B0000000E, 0x2BD500011091, 0x20FAD4000000D0, 0x89976000000C2, 0x2BD5000094B2, 0x2BD50000817A, 0x90C20000000A, 0x385A90000000E, 0x2BD50001355F, 0x90D500000000, 0x3AA92700000136, 0x2BD500022772, 0x2BD5000003C2, 0x61F93000000008, 0x2BD500003326, 0x4B8FB000000754, 0x29508800000506, 0x7C873C00000007, 0x2950A5000000B2, 0x2950880000059C, 0x2950BE0000007A, 0x1E2E100000054, 0x2BD500009938, 0x31AABC00000197, 0xD40000000012, 0x2BD500000257, 0x3B61E1000000CA, 0x2BD500000261, 0x8685700000057, 0x2BD50001A842, 0x31AAEF000000B7, 0x2BD50000CFA2, 0x73E3EF00000008, 0x3A9C500000001F, 0x384F00000000A, 0x2950E100000030, 0x2BD5000219FA, 0x2BD500003271, 0x8684A0000058C, 0x2950E10000007C, 0x3D09B00000025, 0x2BD500017646, 0x4AF51C00000076, 0x2BD500010189, 0x2BD500023743, 0x2BD500013E9D, 0x2BD5000236EF, 0x42E660000022A, 0x3702100000025, 0x2BD5000239AD, 0x2BD50001E472, 0x2BD5000009DA, 0x269CD100000196, 0x2BD500023EBC, 0x2BD500022544, 0x16FDE0000001E, 0x370260000003B, 0x370260000000E, 0x2BD500025130, 0x2BD5000241EE, 0x2BD500023BF7, 0x2BD500024022, 0x2BD500023C73, 0x2BD500024E4C, 0x5CA3E2000000E7, 0x3511DC0000028E, 0x3701F00000024, 0x2BD500023EB5, 0x2BD500023704, 0x2BD500022C0E, 0x107BA3B00000001, 0x1318700000016, 0x2BD50001D708, 0x2BD500023720, 0x70C78E00000001, 0x175C49000002A8, 0xD3750000001D, 0x2BD500022E98, 0x2BD50002254B, 0x2BD50002402E, 0x2BD5000034E1, 0x5BD3BF0000021B, 0x2BD500024028, 0x432A00000024B, 0x2BD500023735, 0x2BD5000226CA, 0x35C2200000024, 0x4D41700000074, 0x252AD0000004A, 0x2BD5000253DB, 0x2BD5000252E5, 0x2BD500023450, 0x2BD5000239BB, 0x2BD5000226F0, 0x2BD5000236E8, 0x370240000001C, 0x2BD5000239C2, 0x3702300000014, 0x2BD50002548F, 0x2BD500022068, 0x2BD5000226C4, 0x665B260000000E, 0x2BD500025011, 0x10D0B00000008, 0x2BD50002530F, 0x2BD50001B1BD, 0x2BD500025137, 0x3702300000023, 0x4C1795000002A1, 0x2BD50002275E, 0x2BD5000226F7, 0x4C179A00000180, 0x4C179200000174, 0x4C179500000293, 0x2BD500022CD0, 0x4C17930000045A, 0x4C179A0000010A, 0x2BD500022915, 0x2BD500022B52, 0x4C17980000019A)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0251 call
1088 rows		0.025 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (0x7150F900000001, 0x2BD5000083B7, 0x46C48B00000097, 0xDF0C0000000E, 0xBFF27600000006, 0x3B8E6000005E0, 0x2BD500019EBE, 0x6D2F00000001, 0x2BD500007513, 0x819D3000000005, 0xA09300000036, 0x4AAEA40000001B, 0x4C1CF8000001C6, 0xE6409600000005, 0x2BD500016891, 0x2BD5000240FE, 0x2BD50001DF51, 0x2BD500003D74, 0x2BD500001B3F, 0x4CB5500000C56, 0xF5C44400000001, 0x206340000003D, 0x2BD500003669, 0x2BD5000046BF, 0x2BD50001ECF6, 0x1F72B1000001F0, 0x2BD50001C604, 0x14F5580000005D, 0x60FF3B00000636, 0x7D4D4B00000009, 0x6694F0000012B, 0xE5040800000008, 0x6D42610000005B, 0x2BD500015AC9, 0xD5D800000011, 0x2BD50001AC34, 0x109465F00000001, 0x1FE400000029, 0x2BD50001CEC6, 0x81BE4D00000006, 0x386BB00000065, 0x2BD5000004C0, 0x2BD50001FC97, 0x2BD50001C1F7, 0x1172600000000, 0xFD620F00000002, 0x2BD50001D49F, 0x2BD50001D553, ...514A0F00000010, 0x2BD5000233A6, 0x3B61CC000003F2, 0x2BD500022C5F, 0x2BD50002521B, 0x2BD5000047EB, 0x2BD5000224DD, 0x2BD500024E6F, 0x2BD5000254B3, 0x2BD50002547A, 0x2BD500023D5E, 0x6A575900000320, 0x1409A00000000, 0x8696600000539, 0x36C8400000006, 0x2BD50002549D, 0x2967B70000000F, 0x4F642900000127, 0x46240100000019, 0x13B7D600000005, 0x23E41400000039, 0x2967CB0000001F, 0x2D3C8C00000235, 0x6FE3E800003247, 0x70146600000007, 0x293D6B0000004C, 0x167560000004F, 0x293D6F0000020C, 0x2BD50002428F, 0x31A7810000019F, 0x4407000000B90, 0x293DBB000000FB, 0x2BD50002280C, 0x2BD50002257C, 0x2BD500022813, 0x2BD500023C8F, 0x33240500000671, 0x2BD500022583, 0x62DF3800000120, 0x2BD500022821, 0x2DA1CC00000013, 0x2BD50002258A, 0x2DA1DC00000001, 0x50D19B00000028, 0x2BD50002281A, 0x1D9CA00000032, 0x2BD50000D448, 0x9A4000000046, 0x2964DF00000085, 0x9D0F0500000006, 0x78CB30000045E, 0x293DC1000002EE, 0x2BD500022193, 0x8693200000398, 0x39950800000791, 0x293DD000000060, 0x2BD5000229D3, 0x2BD500015FA4, 0x2BD500006331, 0xB2FD5A00000001, 0x2BD50002252E, 0x132B700000009, 0x2BD500023D7B, 0x2BD500011954, 0x293DDA00000063, 0x293DE300000030, 0x7C64DD000000A7, 0x70AE00000019, 0x4C15860000001F, 0x457D600001182, 0x2BD500023C81, 0x4DED5300000B03, 0x9CD80D00000006, 0x2AFE91000000A8, 0x5BA5FA00000255, 0x1793400000025, 0x5EF41500000072, 0x2BD50000E855, 0x2BD50000EE6C, 0x2BD50002053B, 0x1660700000038, 0x12A6D00000000, 0x12B6500000003, 0xD6A200000012, 0x2BD50001BDC9, 0x2BD500014FA7, 0x2BD50000E2AF, 0x2BD500009672, 0x4614E9000001CA, 0x293DEC000000A8, 0x2BD50002233C, 0x7886C100000014, 0x8692D00000037, 0x4D0148000002F7, 0x69F31E0000000E, 0x293DEC00000145, 0x2BD50000E533, 0x3B61E100000011, 0x4774E00000001, 0x398185000000CA, 0x29504C00000458, 0x2BD500024D43, 0x2BD5000244D8, 0x2BD5000254C2, 0x2950900000003C, 0x86914000003C5, 0x21CC7300000282, 0x2BD5000254C9, 0x2BD500011A96, 0x5AE75B0000000E, 0x2BD500011091, 0x20FAD4000000D0, 0x89976000000C2, 0x2BD5000094B2, 0x2BD50000817A, 0x90C20000000A, 0x385A90000000E, 0x2BD50001355F, 0x90D500000000, 0x3AA92700000136, 0x2BD500022772, 0x2BD5000003C2, 0x61F93000000008, 0x2BD500003326, 0x4B8FB000000754, 0x29508800000506, 0x7C873C00000007, 0x2950A5000000B2, 0x2950880000059C, 0x2950BE0000007A, 0x1E2E100000054, 0x2BD500009938, 0x31AABC00000197, 0xD40000000012, 0x2BD500000257, 0x3B61E1000000CA, 0x2BD500000261, 0x8685700000057, 0x2BD50001A842, 0x31AAEF000000B7, 0x2BD50000CFA2, 0x73E3EF00000008, 0x3A9C500000001F, 0x384F00000000A, 0x2950E100000030, 0x2BD5000219FA, 0x2BD500003271, 0x8684A0000058C, 0x2950E10000007C, 0x3D09B00000025, 0x2BD500017646, 0x4AF51C00000076, 0x2BD500010189, 0x2BD500023743, 0x2BD500013E9D, 0x2BD5000236EF, 0x42E660000022A, 0x3702100000025, 0x2BD5000239AD, 0x2BD50001E472, 0x2BD5000009DA, 0x269CD100000196, 0x2BD500023EBC, 0x2BD500022544, 0x16FDE0000001E, 0x370260000003B, 0x370260000000E, 0x2BD500025130, 0x2BD5000241EE, 0x2BD500023BF7, 0x2BD500024022, 0x2BD500023C73, 0x2BD500024E4C, 0x5CA3E2000000E7, 0x3511DC0000028E, 0x3701F00000024, 0x2BD500023EB5, 0x2BD500023704, 0x2BD500022C0E, 0x107BA3B00000001, 0x1318700000016, 0x2BD50001D708, 0x2BD500023720, 0x70C78E00000001, 0x175C49000002A8, 0xD3750000001D, 0x2BD500022E98, 0x2BD50002254B, 0x2BD50002402E, 0x2BD5000034E1, 0x5BD3BF0000021B, 0x2BD500024028, 0x432A00000024B, 0x2BD500023735, 0x2BD5000226CA, 0x35C2200000024, 0x4D41700000074, 0x252AD0000004A, 0x2BD5000253DB, 0x2BD5000252E5, 0x2BD500023450, 0x2BD5000239BB, 0x2BD5000226F0, 0x2BD5000236E8, 0x370240000001C, 0x2BD5000239C2, 0x3702300000014, 0x2BD50002548F, 0x2BD500022068, 0x2BD5000226C4, 0x665B260000000E, 0x2BD500025011, 0x10D0B00000008, 0x2BD50002530F, 0x2BD50001B1BD, 0x2BD500025137, 0x3702300000023, 0x4C1795000002A1, 0x2BD50002275E, 0x2BD5000226F7, 0x4C179A00000180, 0x4C179200000174, 0x4C179500000293, 0x2BD500022CD0, 0x4C17930000045A, 0x4C179A0000010A, 0x2BD500022915, 0x2BD500022B52, 0x4C17980000019A, 0x2BD500024FFD, 0x2BD500024F15)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0181 call
1009 rows		0.018 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (0x7150F900000001, 0x2BD5000083B7, 0x46C48B00000097, 0xDF0C0000000E, 0xBFF27600000006, 0x3B8E6000005E0, 0x2BD500019EBE, 0x6D2F00000001, 0x2BD500007513, 0x819D3000000005, 0xA09300000036, 0x4AAEA40000001B, 0x4C1CF8000001C6, 0xE6409600000005, 0x2BD500016891, 0x2BD5000240FE, 0x2BD50001DF51, 0x2BD500003D74, 0x2BD500001B3F, 0x4CB5500000C56, 0xF5C44400000001, 0x206340000003D, 0x2BD500003669, 0x2BD5000046BF, 0x2BD50001ECF6, 0x1F72B1000001F0, 0x2BD50001C604, 0x14F5580000005D, 0x60FF3B00000636, 0x7D4D4B00000009, 0x6694F0000012B, 0xE5040800000008, 0x6D42610000005B, 0x2BD500015AC9, 0xD5D800000011, 0x2BD50001AC34, 0x109465F00000001, 0x1FE400000029, 0x2BD50001CEC6, 0x81BE4D00000006, 0x386BB00000065, 0x2BD5000004C0, 0x2BD50001FC97, 0x2BD50001C1F7, 0x1172600000000, 0xFD620F00000002, 0x2BD50001D49F, 0x2BD50001D553, ...AB, 0x6BF6E1000002F1, 0x2BD50001CBAD, 0x4CD5A70000000C, 0x207FF200000067, 0x639100000011, 0x2F716B00000413, 0xAE400E00000009, 0x3376200000001, 0x2BD50000153E, 0x268FF0000005F, 0x79E82300000008, 0x2BD50001DD34, 0x2BD500019243, 0x58032B00000231, 0xF85EA500000005, 0x37AD50000006E, 0x2BD500021878, 0x58D78300000007, 0xEDFDA600000002, 0x128D10000000E, 0x200500000000, 0x59892500000196, 0x5CF80800000125, 0x2BD50001703B, 0xEFE44500000001, 0x2BD50001ED4B, 0x647EEC00000009, 0x4DC9EB00000158, 0xA8E5BF00000005, 0x5CC8A700000267, 0x519DE60000000E, 0x453B2000000189, 0xE8768B00000005, 0x1C68B0000007B, 0x57CF0000001C, 0xEE0BFE00000005, 0x87E400000000, 0x8601DA00000020, 0x1E69A0000006A, 0x16AFB7000000B6, 0x2BD500001657, 0x452CF30000006E, 0x5CFFA1000002E2, 0x3B1F90000015C, 0x210A500000003, 0x2BD50001D668, 0x40588A000000AC, 0x52D5F100000012, 0x2BD50001FFC8, 0x2BD50001FFE9, 0x2BD500020059, 0x2BD500000BFC, 0x2BD5000149CF, 0x2BD5000202F0, 0xCC2BAA00000005, 0x91A15300000001, 0x6D01CB00000258, 0x2BD500020604, 0x2BD5000206C2, 0x8C5D000000169, 0x6BE94700000137, 0x21EE00000000, 0x2BD50001AC7F, 0x2BD5000092C9, 0x2BD50000038E, 0x2BCE100000009C, 0x2BD500014DDD, 0x2BD500023C28, 0x2BD500021D24, 0x2BD5000075C2, 0xBC2B6A00000007, 0x691E39000003D2, 0x2BD500002A65, 0x2BD500012D1B, 0x2BD500000ACB, 0x2BD50001F5EC, 0x2BD500021D87, 0xB2B400000010, 0x45A1E800000089, 0x782BFB00000004, 0xFE85A700000006, 0x58B0BE0000041E, 0xF5D19E00000001, 0x5BB18C00000254, 0x5B1BD00000319, 0x746B5A0000001A, 0x7DDE200000A64, 0xFA616400000004, 0x53DEB70000013C, 0x2BD500021E88, 0x71EAC400000001, 0xBD111000002CD, 0x26CF500000002, 0x2BD500021EB8, 0x47BBA5000000A3, 0x7C01F000000010, 0x3213000000BD, 0x2BD50001D1C8, 0x364AF4000000C2, 0x2BD500021EDE, 0x3C87DF0000006A, 0x413C4E00000305, 0x660930000000B, 0x2BD50001A3A5, 0x88684B0000000C, 0x68ED7000000A7, 0x2BD500021F67, 0x5DC04100000179, 0xE144C700000011, 0x6E69A0000344B, 0x57D9F4000001F2, 0x6DF8D3000000EE, 0xC7C48D00000020, 0x2BD500015178, 0x45537900000097, 0x10E811F00000001, 0x2BD500021FDD, 0x2BD500002D06, 0x5BEF21000002D7, 0xD60C7600000004, 0x12D4240000004C, 0x2BD50001DCBD, 0x10CEEA400000001, 0xB1289500000002, 0x9A845600000005, 0x39569A0000008F, 0x2BD50001BDB8, 0x79C30000008E9, 0x44AC5B000000B1, 0x1C4E10000002D, 0x106BB9500000005, 0x2BD50002213E, 0x2BD500022141, 0x2BD5000007F3, 0x2BD500022163, 0xC39EE000000005, 0x7C3A5000000058, 0x8EDC700000511, 0x85EEC300000005, 0x8176AE00000006, 0x1F8900000012, 0x8848100000302, 0xC69E2000000006, 0xB6B38F00000003, 0xBA9F6B00000001, 0x2BD500000820, 0xA7879D00000007, 0x2BD5000002B5, 0x46B18F000001BD, 0xB16A9400000001, 0x85EE0A0000001D, 0x6C64D70000002D, 0x76FC3500000042, 0xFAD52000000008, 0x2BD5000221F0, 0xBE60F800000005, 0x2BD500022211, 0x4C1290000092B, 0x2BD50001AA6D, 0x2BD5B30000003D, 0x50AE00000089C, 0x2BD5000197AA, 0x393880000031A, 0x1AC3820000015B, 0x838EDA000000BB, 0x57184400000178, 0x2BD500001C0E, 0x230C00000000, 0x29527900000008, 0x212F0000004A, 0x2BD50001C29E, 0x2BD5000031A0, 0x5EEA92000001C9, 0x2BD5000222C6, 0x6CB7B4000002F1, 0x1D5C910000025D, 0x2BD5000223AC, 0x2BD5000223B2, 0x2BD500000B84, 0x5AD40000000C, 0x2BD500022411, 0x2BD50000EEA1, 0x5F11F9000001DE, 0x67E637000003DE, 0x2BD500022427, 0x66D400000003, 0x2BD500014F89, 0x5CFCE50000000A, 0x2BD5000223B8, 0x2BD5000223BB, 0x6381F300000002, 0x6CFD030000001A, 0xC4A87A00000005, 0x728E9200000005, 0xC51F6600000005, 0x2BD500000144, 0x2BD500003034, 0x2BD500000190, 0x2BD50000018D, 0x2BD50000295F, 0x2BD50000EDB8, 0x2BD5000001D0, 0x2BD5000001D8, 0xF65D6A00000001, 0x2BD500000207, 0x2BD500007AD5, 0x2BD50000020B, 0xE2F3F300000004, 0x2BD50000021A, 0x2CB5600000001B, 0x9D114B00000005, 0x13EF700000014, 0x844F8F00000007, 0x2BD5000002B2, 0x2BD5000002BD, 0xE0BF00000001, 0x7C0C5000000001, 0x2BD60D00000123, 0x7CFA6700000009, 0x71211F000000D2, 0x2BD500000321, 0x5F29CC0000000D, 0x215400000000, 0x2BD5000012B6, 0x2BD500000EA7, 0x2BD5000158B6, 0x14AF50000000D, 0x2BD500000EEA)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0151 call
743 rows		0.015 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`status`=1) ORDER BY `Company`.`alphaSort`, `Company`.`name`
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`='personalProfile_editPhoto' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0071 call
1 row		0.007 SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (FeeDateRange, Fee2FeeDateRange, Fee) WHERE (0xAEA7E300000004=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2FeeDateRange`.`FeeId` AND `Fee2FeeDateRange`.`FeeDateRangeId`=`FeeDateRange`.`FeeDateRangeId`)
0.0061 call
1 row		0.006 SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Invoice, Registration) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND (`Invoice`.`_SABalance` <=0 OR `Invoice`.`_SABalance` IS NULL)) AND `Registration`.`MeetingId`=0xAEA7E300000002) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-06-13 09:36:44')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0xAEA7E300000002)
0.0068 calls
1 row		0.001 SELECT version from databasemap;
0.0052 calls
1 row		0.003 SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Invoice, Registration) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND `Invoice`.`_SABalance` >0) AND `Registration`.`MeetingId`=0xAEA7E300000002) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-06-13 09:36:44')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0xAEA7E300000002)
0.0052 calls
244 rows		0.002 SELECT * FROM Country ORDER BY orderindex, id
0.0041 call
0 rows		0.004 COMMIT
0.0031 call
1 row		0.003 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`=0xAEA7E300000002
0.0031 call
1 row		0.003 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`=0xAEA7E300000002
0.0031 call
2 rows		0.003 SELECT * FROM MaleOrFemale ORDER BY orderindex, id
0.0031 call
4 rows		0.003 SELECT * FROM MinorityType ORDER BY orderindex, id
0.0031 call
1 row		0.003 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`=0xAEA7E300000002
0.0021 call
0 rows		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, Individual) WHERE `Individual`.`IndividualId`=0x111B2F60000000B AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-13 09:36:18', `mxxCreatedBy`=NULL, `PageRequestId`=0x111B2F600000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='1025344', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='506021', `startTime`='2026-06-13 09:36:18', `sessionId`=0x238F8B4A20247812, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_id\\':\\'6E4556000003DE\\', \\'action\\':\\'find\\', \\'submit\\':\\'Create PDF\\'}', `clientIPAddr`='216.73.216.64'
0.0026 calls
2 rows		0.000 SELECT * FROM YesNo ORDER BY orderindex, id
0.0021 call
2 rows		0.002 SELECT * FROM StaffLevel ORDER BY orderindex, id
0.0022 calls
54 rows		0.001 SELECT * FROM StateProvince ORDER BY orderindex, id
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`.`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`=0xAEA7E300000006 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0021 call
1 row		0.002 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`CompanyId`=0x6E4556000003DE AND `Company`.`CompanyId` IN (0x7150F900000001, 0x2BD5000083B7, 0x46C48B00000097, 0xDF0C0000000E, 0xBFF27600000006, 0x3B8E6000005E0, 0x2BD500019EBE, 0x6D2F00000001, 0x2BD500007513, 0x819D3000000005, 0xA09300000036, 0x4AAEA40000001B, 0x4C1CF8000001C6, 0xE6409600000005, 0x2BD500016891, 0x2BD5000240FE, 0x2BD50001DF51, 0x2BD500003D74, 0x2BD500001B3F, 0x4CB5500000C56, 0xF5C44400000001, 0x206340000003D, 0x2BD500003669, 0x2BD5000046BF, 0x2BD50001ECF6, 0x1F72B1000001F0, 0x2BD50001C604, 0x14F5580000005D, 0x60FF3B00000636, 0x7D4D4B00000009, 0x6694F0000012B, 0xE5040800000008, 0x6D42610000005B, 0x2BD500015AC9, 0xD5D800000011, 0x2BD50001AC34, 0x109465F00000001, 0x1FE400000029, 0x2BD50001CEC6, 0x81BE4D00000006, 0x386BB00000065, 0x2BD5000004C0, 0x2BD50001FC97, 0x2BD50001C...6A575900000320, 0x1409A00000000, 0x8696600000539, 0x36C8400000006, 0x2BD50002549D, 0x2967B70000000F, 0x4F642900000127, 0x46240100000019, 0x13B7D600000005, 0x23E41400000039, 0x2967CB0000001F, 0x2D3C8C00000235, 0x6FE3E800003247, 0x70146600000007, 0x293D6B0000004C, 0x167560000004F, 0x293D6F0000020C, 0x2BD50002428F, 0x31A7810000019F, 0x4407000000B90, 0x293DBB000000FB, 0x2BD50002280C, 0x2BD50002257C, 0x2BD500022813, 0x2BD500023C8F, 0x33240500000671, 0x2BD500022583, 0x62DF3800000120, 0x2BD500022821, 0x2DA1CC00000013, 0x2BD50002258A, 0x2DA1DC00000001, 0x50D19B00000028, 0x2BD50002281A, 0x1D9CA00000032, 0x2BD50000D448, 0x9A4000000046, 0x2964DF00000085, 0x9D0F0500000006, 0x78CB30000045E, 0x293DC1000002EE, 0x2BD500022193, 0x8693200000398, 0x39950800000791, 0x293DD000000060, 0x2BD5000229D3, 0x2BD500015FA4, 0x2BD500006331, 0xB2FD5A00000001, 0x2BD50002252E, 0x132B700000009, 0x2BD500023D7B, 0x2BD500011954, 0x293DDA00000063, 0x293DE300000030, 0x7C64DD000000A7, 0x70AE00000019, 0x4C15860000001F, 0x457D600001182, 0x2BD500023C81, 0x4DED5300000B03, 0x9CD80D00000006, 0x2AFE91000000A8, 0x5BA5FA00000255, 0x1793400000025, 0x5EF41500000072, 0x2BD50000E855, 0x2BD50000EE6C, 0x2BD50002053B, 0x1660700000038, 0x12A6D00000000, 0x12B6500000003, 0xD6A200000012, 0x2BD50001BDC9, 0x2BD500014FA7, 0x2BD50000E2AF, 0x2BD500009672, 0x4614E9000001CA, 0x293DEC000000A8, 0x2BD50002233C, 0x7886C100000014, 0x8692D00000037, 0x4D0148000002F7, 0x69F31E0000000E, 0x293DEC00000145, 0x2BD50000E533, 0x3B61E100000011, 0x4774E00000001, 0x398185000000CA, 0x29504C00000458, 0x2BD500024D43, 0x2BD5000244D8, 0x2BD5000254C2, 0x2950900000003C, 0x86914000003C5, 0x21CC7300000282, 0x2BD5000254C9, 0x2BD500011A96, 0x5AE75B0000000E, 0x2BD500011091, 0x20FAD4000000D0, 0x89976000000C2, 0x2BD5000094B2, 0x2BD50000817A, 0x90C20000000A, 0x385A90000000E, 0x2BD50001355F, 0x90D500000000, 0x3AA92700000136, 0x2BD500022772, 0x2BD5000003C2, 0x61F93000000008, 0x2BD500003326, 0x4B8FB000000754, 0x29508800000506, 0x7C873C00000007, 0x2950A5000000B2, 0x2950880000059C, 0x2950BE0000007A, 0x1E2E100000054, 0x2BD500009938, 0x31AABC00000197, 0xD40000000012, 0x2BD500000257, 0x3B61E1000000CA, 0x2BD500000261, 0x8685700000057, 0x2BD50001A842, 0x31AAEF000000B7, 0x2BD50000CFA2, 0x73E3EF00000008, 0x3A9C500000001F, 0x384F00000000A, 0x2950E100000030, 0x2BD5000219FA, 0x2BD500003271, 0x8684A0000058C, 0x2950E10000007C, 0x3D09B00000025, 0x2BD500017646, 0x4AF51C00000076, 0x2BD500010189, 0x2BD500023743, 0x2BD500013E9D, 0x2BD5000236EF, 0x42E660000022A, 0x3702100000025, 0x2BD5000239AD, 0x2BD50001E472, 0x2BD5000009DA, 0x269CD100000196, 0x2BD500023EBC, 0x2BD500022544, 0x16FDE0000001E, 0x370260000003B, 0x370260000000E, 0x2BD500025130, 0x2BD5000241EE, 0x2BD500023BF7, 0x2BD500024022, 0x2BD500023C73, 0x2BD500024E4C, 0x5CA3E2000000E7, 0x3511DC0000028E, 0x3701F00000024, 0x2BD500023EB5, 0x2BD500023704, 0x2BD500022C0E, 0x107BA3B00000001, 0x1318700000016, 0x2BD50001D708, 0x2BD500023720, 0x70C78E00000001, 0x175C49000002A8, 0xD3750000001D, 0x2BD500022E98, 0x2BD50002254B, 0x2BD50002402E, 0x2BD5000034E1, 0x5BD3BF0000021B, 0x2BD500024028, 0x432A00000024B, 0x2BD500023735, 0x2BD5000226CA, 0x35C2200000024, 0x4D41700000074, 0x252AD0000004A, 0x2BD5000253DB, 0x2BD5000252E5, 0x2BD500023450, 0x2BD5000239BB, 0x2BD5000226F0, 0x2BD5000236E8, 0x370240000001C, 0x2BD5000239C2, 0x3702300000014, 0x2BD50002548F, 0x2BD500022068, 0x2BD5000226C4, 0x665B260000000E, 0x2BD500025011, 0x10D0B00000008, 0x2BD50002530F, 0x2BD50001B1BD, 0x2BD500025137, 0x3702300000023, 0x4C1795000002A1, 0x2BD50002275E, 0x2BD5000226F7, 0x4C179A00000180, 0x4C179200000174, 0x4C179500000293, 0x2BD500022CD0, 0x4C17930000045A, 0x4C179A0000010A, 0x2BD500022915, 0x2BD500022B52, 0x4C17980000019A, 0x2BD500024FFD, 0x2BD500024F15))) AND (`Company`.`silent` !='1' OR `Company`.`silent` IS NULL)) AND `Company`.`MembershipId`=`Membership`.`MembershipId`) AND `Membership`.`status`=1) AND `Membership`.`MembershipTypeId` IN (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 1))) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
0 rows		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, Individual) WHERE `Individual`.`IndividualId`=0x111B2F600000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
3 rows		0.001 SELECT * FROM AddressType ORDER BY orderindex, id
0.0011 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 (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0xAEA7E300000002 ORDER BY `CalendarItem`.`startDate`
0.0011 call
173 rows		0.001 SELECT * FROM webselect
0.0011 call
0 rows		0.001 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`=0xAEA7E300000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 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 (Address, Meeting) WHERE `Meeting`.`MeetingId`=0xAEA7E300000002 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
6 rows		0.001 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`=0xAEA7E300000002
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (FeeDateRange, Meeting) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0xAEA7E300000002
0.0011 call
0 rows		0.001 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`=0x111B2F600000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 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`=0x111B2F600000009 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 UPDATE `PageRequest` SET `mxxUpdated`='2026-06-13 09:36:20', `mxxUpdatedBy`=NULL, `PageRequestId`=0x111B2F600000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='1025344', `requestNum`='1', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='506021', `startTime`='2026-06-13 09:36:18', `sessionId`=0x238F8B4A20247812, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.125626802444458', `timeTaken`='2', `dictSize`='0', `fields`='{\\'Company_id\\':\\'6E4556000003DE\\', \\'action\\':\\'find\\', \\'submit\\':\\'Create PDF\\'}', `clientIPAddr`='216.73.216.64' WHERE `PageRequestId`=0x111B2F600000000
0.0011 call
21 rows		0.001 SELECT * FROM MembershipType ORDER BY orderindex, id
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (Timezone, CalendarItem) WHERE `CalendarItem`.`CalendarItemId`=0xAEA7E300000015 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (0x6E4556000003DE)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0001 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`=0x111B2F600000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows		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 (Address, Individual) WHERE `Individual`.`IndividualId`=0x111B2F600000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
10 rows		0.000 SELECT * FROM MemberCommunicationType ORDER BY orderindex, id
0.0001 call
3 rows		0.000 SELECT * FROM JobLevel ORDER BY orderindex, id
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Website, Meeting) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0xAEA7E300000002
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-13 09:36:44', `mxxCreatedBy`=NULL, `PageRequestId`=0x111B2F60000000E, `path`='forms/meeting/Microsite/HFCManagement', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='1025344', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='506021', `startTime`='2026-06-13 09:36:44', `sessionId`=0x476282296E9AC99C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.64'
0.0001 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`=0x111B2F60000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company) WHERE `Company`.`CompanyId` IN (0x6E4556000003DE) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows		0.000 START TRANSACTION
0.0001 call
2 rows		0.000 SELECT * FROM EmailType ORDER BY orderindex, id