2025 Canada Chapter Thread Rolling


Thursday, September 25, 2025 (5pm - 7pm US/Eastern)
That's Italian Ristorante
2 Tall Grass Trail #4
Woodbridge, ON L4L 3Y9
Canada


The registration period for this meeting has ended.



Speakers: Berto Perez and Lib Pietrantoni, CJWinter

Description: Berto Perez of CJWinter will provide a technical overview of the thread rolling process. Discover the benefits of thread rolling, including stronger threads, superior quality, accuracy, and lower costs. The session will cover best practices for optimal blank design, thread rolling options, tooth form geometries, and gaging options to ensure quality parts. Additionally, learn about the industries currently benefiting from rolled threads.

Following the presentation, Berto Perez will be joined by Lib Pietrantoni for a collaborative Q&A session to address audience questions and share further insights on the topic.

This session promises to be both engaging and informative, offering valuable insights you won't want to miss. Mark your calendars and get ready for an evening of great food, insightful discussions, and wonderful company. We look forward to seeing you there!

SCHEDULE:

5 p.m.- 6:00 p.m. Networking & Dinner
6:00 p.m.- 7:30 p.m. Threadrolling Presentation and Q&A

COST: TBD
Please register above, and remit payment (cash or cheque-made payable to Jamie Smith) upon arrival at the meeting site.

Deadline to Register: Thursday, September 25


Registration Includes:

Dinner and Presentation

Who Should Attend:

Estimators/Engineers, Setup Machinists, Operators, Quality, Sales

Registration Fees:

These fees are available through 09/25/2025
Name Price Available To
Canada Chapter Registration $0.00   TRIAL Manufacturing Membership (USA Contract Mfg.)
TRIAL Manufacturing Membership (Canadian Contract Mfg.)
Affiliate Membership (Educational Institutions)
Associate Membership (Captive Departments/Shops)
Manufacturing Membership (USA Contract Mfg.)
Manufacturing Membership (Canadian Contract Mfg.)
Technical Membership (Suppliers)
Guest


For more information please contact:

Carli Kistler-Miller
Director of Programs & Marketing
Precision Machined Products Association
Phone: (440) 526-0300
Fax: (440) 526-5803
Email: cmiller-pmpa.org@maxx.matrixgroup.net
Debugging Info
pagedictsize=44
sqltime = 0.072 s
cpu time = 0.670 s
real time = 1.419 s
memory increase = 18088 kB
fields = id: '38312700000001'
templates =
/data/pmpa/current/generic/themes/www/mako/meetings/viewMeeting
/data/pmpa/current/generic/themes/www/webform/meeting/meetingHeader
/data/pmpa/current/pmpa_org/themes/www/footer
/data/pmpa/current/pmpa_org/themes/www/meetings_header
scrapeAndDrape FRESH stub: https://www.pmpa.maxx.matrixdev.net/for-members/committees-mx-stub/
dg = ['Empty'] | [170015]
extra debug info =
queries = 48 queries

Total TimeCountAvg TimeQuery
0.0111 call
0 rows
0.011 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Website, Meeting) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x38312700000001
0.0074 calls
244 rows
0.002 SELECT * FROM Country ORDER BY orderindex, id
0.0051 call
8 rows
0.005 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (MembershipType, Fee2MembershipType, Fee) WHERE (0x38312700000003=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MembershipType`.`FeeId` AND `Fee2MembershipType`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0041 call
0 rows
0.004 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `File`.`parentId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x38312700000001
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x38312700000001 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
0 rows
0.004 SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category, Meeting2Category, Meeting) WHERE (0x38312700000001=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Category`.`MeetingId` AND `Meeting2Category`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`
0.0031 call
0 rows
0.003 COMMIT
0.0031 call
1 row
0.003 SELECT DISTINCT hex(`Meeting`.`MeetingId`) AS `MeetingId`, `Meeting`.`name`, `Meeting`.`hostName`, `Meeting`.`description`, `Meeting`.`audienceDescription`, `Meeting`.`cosponsors`, `Meeting`.`includes`, `Meeting`.`attire`, `Meeting`.`cancellationPolicy`, `Meeting`.`thankYouText`, `Meeting`.`registrationStarts`, `Meeting`.`registrationEnds`, `Meeting`.`earlybirdCutoff`, `Meeting`.`onlineRegistrationsEnabled`, `Meeting`.`selectSessionsOnRegForm`, `Meeting`.`accountingCode`, `Meeting`.`maximumNumAttendees`, `Meeting`.`type`, `Meeting`.`showPublicSessionSearch`, `Meeting`.`allowSpouseReg`, `Meeting`.`continuingEdUnits`, `Meeting`.`mediaAllowed`, `Meeting`.`travelInfo`, `Meeting`.`hotelBlurb`, `Meeting`.`dateClosed`, `Meeting`.`showFeesOnPublicView`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`eventId`, `Meeting`.`staffNotificationEmail`, `Meeting`.`paymentInstructions`, `Meeting`.`staffCancellationEmail`, `Meeting`.`lowRoomTrigger`, `Meeting`.`continuingEdNumber`, `Meeting`.`enableRSVP`, `Meeting`.`micrositePath`, `Meeting`.`bgcolor`, `Meeting`.`accentColor`, `Meeting`.`tabTitleColor`, `Meeting`.`bodyTextColor`, `Meeting`.`linkTextColor`, `Meeting`.`rightNavTextColor`, `Meeting`.`fontTitleSize`, `Meeting`.`fontBodySize`, `Meeting`.`fontName`, `Meeting`.`navbarColor`, `Meeting`.`sidebarColor`, `Meeting`.`highlightedTabTextColor`, `Meeting`.`headlineColor`, `Meeting`.`highlightedTabColor`, `Meeting`.`inSiteAccentColor`, `Meeting`.`inSiteBodyTextColor`, `Meeting`.`inSiteHeadlineColor`, `Meeting`.`inSiteHighlightedTabColor`, `Meeting`.`inSiteHighlightedTabTextColor`, `Meeting`.`inSiteLinkTextColor`, `Meeting`.`inSiteNavbarColor`, `Meeting`.`inSiteRightNavTextColor`, `Meeting`.`inSiteSidebarColor`, `Meeting`.`inSiteTabTitleColor`, `Meeting`.`inSiteFontBodySize`, `Meeting`.`inSiteFontName`, `Meeting`.`inSiteFontTitleSize`, `Meeting`.`useBadges`, `Meeting`.`staffNotificationRevisitedEmail`, `Meeting`.`anticipatedRegistrations`, `Meeting`.`_budgetedRevenue`, `Meeting`.`groupRegistrationOn`, `Meeting`.`allowPlaceholders`, `Meeting`.`feesPageTopText`, `Meeting`.`badgesPageTopText`, `Meeting`.`questionsPageTopText`, `Meeting`.`eventsPageTopText`, `Meeting`.`reviewPageTopText`, `Meeting`.`paymentPageTopText`, `Meeting`.`micrositeTemplate`, `Meeting`.`inSiteTemplate`, `Meeting`.`isWebinar`, `Meeting`.`housingPageTopText`, `Meeting`.`attendeesPageTopText`, `Meeting`.`shortCalDescription`, `Meeting`.`allowAddToCalendar`, `Meeting`.`campaignCode`, `Meeting`.`recordOrigin`, `Meeting`.`additionalFeesPageTopText`, `Meeting`.`referralText`, `Meeting`.`hasReferrals`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived`, `Meeting`.`hideIntranetSummary` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x38312700000001
0.0031 call
3 rows
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`=0x38312700000001
0.0031 call
1 row
0.003 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`includeInPrintedMemberDirectory`, `Individual`.`rankInPrintedMemberDirectory`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0xC151600000003 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`User`.`UserId`) AS `UserId`, `User`.`username`, `User`.`password`, `User`.`encoding`, hex(`User`.`VotingId`) AS `VotingId`, `User`.`lastSearchType`, `User`.`oneTimeKey`, `User`.`recoverPasswordKey`, `User`.`recoverPasswordTimeout`, `User`.`disableAllNotifications`, `User`.`otCodeTime`, `User`.`otCode`, `User`.`holyGrailSections` FROM (User) WHERE `User`.`UserId`=0xC151600000003
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Event`.`EventId`) AS `EventId`, `Event`.`name`, `Event`.`description`, `Event`.`date`, `Event`.`price`, `Event`.`accountingCode`, `Event`.`selectOnRegForm`, `Event`.`maximumNumAttendees`, `Event`.`location`, `Event`.`startTime`, `Event`.`endTime`, `Event`.`notes`, `Event`.`useSignups`, `Event`.`showOnMeetingView`, `Event`.`publishToCalendar`, `Event`.`publishToSchedule` FROM (Meeting, Event) WHERE `Event`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x38312700000001 ORDER BY `Event`.`startTime`, `Event`.`name`
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (Meeting, FeeDateRange) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x38312700000001
0.0022 calls
1 row
0.001 select max(returnOrder) from Stack where sessionId = 8701369778814465088
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`includeInPrintedMemberDirectory`, `Individual`.`rankInPrintedMemberDirectory`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Address, Individual) WHERE `Address`.`AddressId`=0x38312700000006 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0022 calls
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`minimumDiameter`, `Company`.`maximumDiameter`, `Company`.`maximumLength`, `Company`.`keywords`, `Company`.`corporateCapabilities`, `Company`.`numPrimaryMachines`, `Company`.`annualNetSales`, `Company`.`pacSolicitation`, `Company`.`SICCode`, `Company`.`NAICSCode`, `Company`.`unionName`, `Company`.`numEmployees`, `Company`.`district`, `Company`.`chapter`, `Company`.`companySurveyCode`, `Company`.`adminProfClerSurvey`, `Company`.`benchmarkingSurvey`, `Company`.`businessForecastSurvey`, `Company`.`businessTrendsSurvey`, `Company`.`executiveCompensationSurvey`, `Company`.`financialMeasuresSurvey`, `Company`.`wagesBenefitsSurvey`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`executiveAdminSurvey`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`industryOther`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (BranchAffiliationHistory, Company, Individual, Branch) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x8496B00000003) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (MailingList, Fee2MailingList, Fee) WHERE (0x38312700000003=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MailingList`.`FeeId` AND `Fee2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`
0.0021 call
1 row
0.002 SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x38312700000001 ORDER BY `CalendarItem`.`startDate`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x38312700000007 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0016 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='meetings_WWWreg_noRegMsg_reg_ended' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0011 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`=0x38312700000001
0.0011 call
0 rows
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`.`logoFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x38312700000001
0.0011 call
158 rows
0.001 SELECT * FROM webselect
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`includeInPrintedMemberDirectory`, `Individual`.`rankInPrintedMemberDirectory`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Meeting, Individual) WHERE `Meeting`.`MeetingId`=0x38312700000001 AND `Meeting`.`contactIndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
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`=0x38312700000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0012 calls
1 row
0.000 select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Meeting where MeetingId=0x38312700000001
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`minimumDiameter`, `Company`.`maximumDiameter`, `Company`.`maximumLength`, `Company`.`keywords`, `Company`.`corporateCapabilities`, `Company`.`numPrimaryMachines`, `Company`.`annualNetSales`, `Company`.`pacSolicitation`, `Company`.`SICCode`, `Company`.`NAICSCode`, `Company`.`unionName`, `Company`.`numEmployees`, `Company`.`district`, `Company`.`chapter`, `Company`.`companySurveyCode`, `Company`.`adminProfClerSurvey`, `Company`.`benchmarkingSurvey`, `Company`.`businessForecastSurvey`, `Company`.`businessTrendsSurvey`, `Company`.`executiveCompensationSurvey`, `Company`.`financialMeasuresSurvey`, `Company`.`wagesBenefitsSurvey`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`executiveAdminSurvey`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`industryOther`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch) WHERE `Branch`.`BranchId`=0x1D200000027 AND `Branch`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0002 calls
1 row
0.000 select mxxCreated, mxxUpdated from Meeting where MeetingId=0x38312700000001;
0.0001 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` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8496B00000003 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-27 15:46:38',`mxxCreatedBy`=NULL, `PageRequestId`=0x4581EB00000000, `path`='forms/meeting/MeetingFormPublic/view', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='PMPA', `pid`='3328911', `requestNum`='1', `pageDictSize`=NULL, `objectId`='38312700000001', `templateMethod`=NULL, `growth`=NULL, `server`='www.pmpa.maxx.matrixdev.net', `dbThreadId`='37667', `startTime`='2026-02-27 15:46:38', `sessionId`=0x78C179B6458E3440, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'38312700000001\\'}', `clientIPAddr`='216.73.216.211'
0.0001 call
0 rows
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`.`inSiteBannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x38312700000001
0.0001 call
1 row
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`=0x1D200000028 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
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`=0x38312700000001
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows
0.000 START TRANSACTION