About Us
- About Us
- History
- Leadership
- Staff
- Policy Statements
- Contact Us
- Careers
  - Job Listings
- Year in Review
Join FMI
Careers
- Job Listings
Newsroom
- Latest News
- News Archive
  - 2024
  - 2023
  - 2022
  - 2021
  - 2020
  - 2019
  - 2018
  - 2017
  - 2016
  - 2015
  - 2014
  - 2013
  - 2012
  - 2011
  - 2010
  - 2009
  - 2008
  - 2007
  - 2006
  - 2005
  - 2004
  - 2003
  - 2002
  - 2001
  - 2000
  - 1999
  - 1998
- Press Credentials
- Voice of The Food Industry Blog
Store

SQF Train the Trainer 12/2005 Washington, DC

Monday, December 12 - Wednesday, December 14, 2005
Hotel Washington
Corner of 15th and Pennsylvania Avenue [map]
Washington, DC 20004

Add to Calendar

My Meetings

The registration period for this meeting has ended.

Schedule

This course is designed as comprehensive course to train SQF Auditors and SQF Consultants to deliver
SQF systems training course. The satisfactory completion of recognized HACCP training is a prerequisite
for those planning to attend the SQF systems training course

Related Web Pages and Sites:
http://www.sqfi.com

Registration Includes:

Each participant will receive the entire suite of SQFI Training materials and lunch is also included.

Who Should Attend:

Registration is by invitation only

Meeting Attire:

Please note that the dress attire is casual.

Registration Fees: These fees are available through 12/09/2005
Name	Price
Registration	$750.00

Cancellation and Other Policies:

All cancellations must be received in writing to the SQFI by 30 November, 2005 in order to recieve a 60% refund. After this date all registrations are non-refundable.

General Hotel Information:

For your convenience a block of rooms have been reserved at the Hotel Washington, Cnr. 15th Street and
Pennsylvania Avenue, N.W., Washington DC 20004. Please call the hotel directly on Tel: +1-202-783-
7800; Fax +1-202-783-7801 quoting the Food Marketing Institute SQF Training Meeting. Reservation
cutoff date: 30th November ‘05. The Hotel Washington is an older style hotel but more reasonably
priced than most in central DC. It is located close to Metro Centre, across from the White House and a
short walk to the training venue.

Travel Information:

Hotel Washington is across the street from the White House, only 10 minutes from National Airport, and convenient to the Metrorail system. Two blocks from Metro Center 13th and F street.

Driving Directions
From Ronald Reagan Washington Airport
Take ramp towards GW Parkway North. Merge onto George Washington Memorial Parkway N. Take I-395N/US-1 N exit towards Washington. Merge onto I-395N. Take the US-1N exit on the left. Merge onto US-1N. Stay straight to go onto 14th Street NW. Turn left onto Pennsylvania Avenue NW. Turn right onto 15th Street, NW. Turn right onto F Street to unload/park.

From Washington Dulles International Airport
Take Dulles Airport Access Road. Dulles Access Road becomes VA-267E. Take I-66E. Take Constitution Avenue exit. Continue on Constitution Avenue. Turn left onto 15th Street, NW. Turn right onto F Street to unload/park.

Other Transportation Information to Hotel Washington
FROM REAGAN NATIONAL AIRPORT

Metro Center-Take the blue line towards Addison Road. Get off at Metro center and take the escalator or elevator to F Street exit this is a two block walking distance from the hotel
Taxi cab Fare ($12.00 $15.00 one way)
Super Shuttle you must call for rates and reservation 1-800-258-3826

FROM DULLES INTERNATIONAL AIRPORT

Super Shuttle you must call for rates and reservation 1-800-258-3826
Taxi cab Fare ($40.00 $45.00 one way)

FROM BWI AIRPORT

Taxi cab Fare ($50.00 $55.00 one way)

Area Information

Reagan National (DCA)

Distance: 4 MI/ 6.44 KM N
Taxi Fee: $14.00 (USD)
Time by taxi: 10 to 15 minutes
Time by train: 22 minutes
Alt. Transportation: Metro Subway
Alt. Transportation Fee: $1.45 (USD)

Dulles International (IAD)

Distance: 35 MI/ 56.33 KM E
Taxi Fee: $45.00 (USD)
Time by taxi: 45 minutes
Alt. Transportation: Super Shuttle
Atl. Transportation Fee: $22.00 (USD)

Baltimore-Washington Int'l (BWI)

Distance: 40 MI/ 64.37 KM SW
Taxi Fee: $50.00 (USD)
Time by taxi: 45 minutes
Time by train: 60 minutes
Alt. Transportation: Super Shuttle
Atl. Transportation Fee: $25.00 (USD)

Union Station Metro Subway

Subway Station Name: Union Station Metro Subway
Train Station Distance 0.25 MI/ 0.4 KM SW
Taxi Fee $5.00 (USD)

Union Station AMTRAK

Subway Station Name: Union Station AMTRAK
Train Station Distance 0.25 MI/ 0.4 KM SW
Taxi Fee $5.00 (USD)

Judiciary Square Metro Station

Subway Station Name: Judiciary Square Metro Station
Train Station Distance 0.25 MI/ 0.4 KM E
Taxi Fee $5.00 (USD)

Washington Dc Convention Ctr

Convention Name Washington Dc Convention Ctr
Convention Distance 1 MI/ 1.61 KM
Taxi Fee $8.00 (USD)

2345 Crystal Drive, Suite 800, Arlington, VA 22202 | phone: 202-452-8444 | fax: 202-429-4519

Website design by Matrix Group International, Inc. ®

Sign Up for the

FREE daily briefing on top stories in food retailing.

fmi-icon-frozen-goods
fmi-icon-workforce
fmi-icon-certificate
fmi-icon-pharmacy
fmi-icon-food-safety
fmi-icon-asset-protection
fmi-icon-education force-icon-3
fmi-icon-research
fmi-icon-government-affairs
fmi-icon-get-involved
fmi-icon-industry-topic force-icon-3
fmi-icon-labeling
fmi-icon-corporate-social-responsibility
fmi-icon-payments
fmi-icon-crisis-management
fmi-icon-private-brands
fmi-icon-food-assistance
fmi-icon-supplier-diversity
fmi-icon-fresh-foods
fmi-icon-supply-chain
fmi-icon-general-merchandise
fmi-icon-technology
fmi-icon-health-wellness
fmi-icon-total-store-collaboration
fmi-icon-Health-Reform
fmi-icon-wage-labor
fmi-icon-independent-operator
fmi-icon-wholesaler-topic
fmi-icon-newsroom force-icon-3
fmi-icon-tax-reform
fmi-icon-about_icon force-icon-4
fmi-icon-about_icon
fmi-icon-cart
fmi-icon-blog_icon force-icon-5
fmi-icon-cart
fmi-icon-Communications
fmi-icon-omnichannel
fmi-icon-biotechnology-topic

Total Time

Count

Avg Time

Query

0.104

1 call
1 row

0.104

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

0.038

1 call
0 rows

0.038

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

0.019

1 call
1 row

0.019

SELECT DISTINCT hex(`RegistrationQuestion`.`RegistrationQuestionId`) AS `RegistrationQuestionId`, `RegistrationQuestion`.`text`, `RegistrationQuestion`.`options`, `RegistrationQuestion`.`publishToWWW`, `RegistrationQuestion`.`type`, `RegistrationQuestion`.`required`, `RegistrationQuestion`.`orderindex` FROM (Meeting, RegistrationQuestion) WHERE `RegistrationQuestion`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x1B4630000003E ORDER BY `RegistrationQuestion`.`orderindex`, `RegistrationQuestion`.`RegistrationQuestionId`

0.012

1 call
1 row

0.012

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

0.011

1 call
1 row

0.011

SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (Fee, FeeDateRange, Fee2FeeDateRange) WHERE (0x1B4630000004B=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2FeeDateRange`.`FeeId` AND `Fee2FeeDateRange`.`FeeDateRangeId`=`FeeDateRange`.`FeeDateRangeId`)

0.010

1 call
1 row

0.010

SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (Fee, FeeDateRange, Fee2FeeDateRange) WHERE (0x1B46300000045=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2FeeDateRange`.`FeeId` AND `Fee2FeeDateRange`.`FeeDateRangeId`=`FeeDateRange`.`FeeDateRangeId`)

0.007

7 calls
1 row

0.001

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)>0) AND `Registration`.`MeetingId`=0x1B4630000003E) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2025-12-26 11:15:01')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x1B4630000003E)

0.005

1 call
1 row

0.005

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

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`MeetingHotel`.`MeetingHotelId`) AS `MeetingHotelId`, `MeetingHotel`.`distance`, `MeetingHotel`.`deadline`, `MeetingHotel`.`hotelCode`, `MeetingHotel`.`compRate`, `MeetingHotel`.`description`, `MeetingHotel`.`comments`, `MeetingHotel`.`allowReservationsFromWWW`, `MeetingHotel`.`enableWWWReservations`, `MeetingHotel`.`inventoryComments`, `MeetingHotel`.`inventoryUpdatedOn`, `MeetingHotel`.`dateDeleted`, `MeetingHotel`.`cancellationPolicy`, `MeetingHotel`.`lowInventoryThreshold` FROM (Meeting, MeetingHotel) WHERE `MeetingHotel`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x1B4630000003E

0.004

1 call
0 rows

0.004

UPDATE `PageRequest` SET `mxxUpdated`='2025-12-26 11:15:01',`mxxUpdatedBy`=NULL, `PageRequestId`=0xF56AAD00000000, `path`='forms/meeting/MeetingFormPublic/view', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3336980', `requestNum`='1', `objectId`='121FA00000004', `growth`='16080', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='503436', `startTime`='2025-12-26 11:14:59', `sessionId`=0x1C6DBCCF688D3D81, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.5077404975891113', `timeTaken`='68', `dictSize`='2073', `fields`='{\\'id\\':\\'121FA00000004\\'}', `clientIPAddr`='216.73.216.150' WHERE `PageRequestId`=0xF56AAD00000000

0.004

1 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 `Meeting`.`logoFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x1B4630000003E

0.004

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

0.004

6 calls
1 row

0.001

SELECT version from databasemap;

0.004

1 call
1 row

0.004

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.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD00000096 ORDER BY `Committee`.`category`, `Committee`.`name`

0.003

1 call
1 row

0.003

SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x1B4630000003E ORDER BY `CalendarItem`.`startDate`

0.003

1 call
0 rows

0.003

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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `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`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Branch, Company) WHERE `Branch`.`BranchId`=0xF56AAD000000AB AND `Branch`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

1 call
0 rows

0.003

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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `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`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (MeetingHotel, Company) WHERE `MeetingHotel`.`MeetingHotelId`=0xF56AAD000000A9 AND `MeetingHotel`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

2 calls
1 row

0.001

SELECT `MetaMeeting`.`cancellationPolicy`, hex(`MetaMeeting`.`MetaMeetingId`) AS `MetaMeetingId`, `MetaMeeting`.`thankYouText`, `MetaMeeting`.`attire`, `MetaMeeting`.`defaultBlurb`, `MetaMeeting`.`feesPageTopText`, `MetaMeeting`.`badgesPageTopText`, `MetaMeeting`.`questionsPageTopText`, `MetaMeeting`.`eventsPageTopText`, `MetaMeeting`.`reviewPageTopText`, `MetaMeeting`.`paymentPageTopText`, `MetaMeeting`.`housingPageTopText`, `MetaMeeting`.`attendeesPageTopText`, `MetaMeeting`.`emailFromContact`, `MetaMeeting`.`prominentComments`, `MetaMeeting`.`thankYouFullyPaidText`, `MetaMeeting`.`additionalFeesPageTopText` FROM (MetaMeeting)

0.003

1 call
2 rows

0.003

SELECT DISTINCT `Calendar`.`name`, `Calendar`.`type`, hex(`Calendar`.`CalendarId`) AS `CalendarId` FROM (Calendar, CalendarItem, CalendarToCalendarItem) WHERE (0x1B46300000046=`CalendarItem`.`CalendarItemId` AND `CalendarItem`.`CalendarItemId`=`CalendarToCalendarItem`.`CalendarItemId` AND `CalendarToCalendarItem`.`CalendarId`=`Calendar`.`CalendarId`)

0.002

1 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`=0x1B4630000003E ORDER BY `Event`.`startTime`, `Event`.`name`

0.002

1 call
1 row

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 (Meeting, Individual) WHERE `Meeting`.`MeetingId`=0x1B4630000003E AND `Meeting`.`contactIndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.002

1 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`.`showNewsletterMemberParticipationReport`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (Fee, MailingList, Fee2MailingList) WHERE (0x1B4630000004B=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MailingList`.`FeeId` AND `Fee2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.002

1 call
1 row

0.002

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)<=0) AND `Registration`.`MeetingId`=0x1B4630000003E) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2025-12-26 11:15:01')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x1B4630000003E)

0.002

1 call
21 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 (MetaMeeting, MetaMeetingContact2Individual, Individual) WHERE (0x2C74000000CE=`MetaMeeting`.`MetaMeetingId` AND `MetaMeeting`.`MetaMeetingId`=`MetaMeetingContact2Individual`.`MetaMeetingId` AND `MetaMeetingContact2Individual`.`IndividualId`=`Individual`.`IndividualId`) ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 11:15:01',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56AAD00000088, `path`='forms/meeting/MeetingFormPublic/view', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3336980', `requestNum`='2', `pageDictSize`=NULL, `objectId`='1B4630000003E', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='503436', `startTime`='2025-12-26 11:15:01', `sessionId`=0x1C6DBCCF688D3D81, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'1B4630000003E\\'}', `clientIPAddr`='216.73.216.150'

0.002

1 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`.`showNewsletterMemberParticipationReport`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (Fee, MailingList, Fee2MailingList) WHERE (0x1B46300000045=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MailingList`.`FeeId` AND `Fee2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Hotel`.`HotelId`) AS `HotelId`, `Hotel`.`reservationsPhone`, `Hotel`.`reservationsFax` FROM (Hotel, Company) WHERE `Hotel`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0xF56AAD000000AC

0.001

1 call
0 rows

0.001

1 call
2 rows

0.001

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

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`=0x1B4630000003E AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.001

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x1B46300000042 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

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

0.001

1 call
8 rows

0.001

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (Fee2MembershipType, Fee, MembershipType) WHERE (0x1B46300000045=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MembershipType`.`FeeId` AND `Fee2MembershipType`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

0.001

1 call
8 rows

0.001

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (Fee2MembershipType, Fee, MembershipType) WHERE (0x1B4630000004B=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MembershipType`.`FeeId` AND `Fee2MembershipType`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD0000008B ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
0 rows

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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `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`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Branch, Company) WHERE `Branch`.`BranchId`=0xF56AAD000000B3 AND `Branch`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD000000D2 ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD000000BB ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
0 rows

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`.`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 (EventStaff, Individual) WHERE `EventStaff`.`EventStaffId`=0xF56AAD0000009B AND `EventStaff`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD000000C6 ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 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`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, User) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x20FF0000000B ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 2048501004521782657

0.001

1 call
1 row

0.001

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration) WHERE (`Registration`.`dateRejected` is not null AND `Registration`.`MeetingId`=0x1B4630000003E)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD00000090 ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`SpecialDeal`.`SpecialDealId`) AS `SpecialDealId`, `SpecialDeal`.`numFeesToQualify`, `SpecialDeal`.`numSpecialFees` FROM (Fee, SpecialDeal) WHERE `SpecialDeal`.`FeeId`=`Fee`.`FeeId` AND `Fee`.`FeeId`=0x1B46300000045

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, Meeting2Committee, Meeting) WHERE (0x1B4630000003E=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Committee`.`MeetingId` AND `Meeting2Committee`.`CommitteeId`=`Committee`.`CommitteeId`) ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
1 row

0.001

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration) WHERE (((`Registration`.`dateSubmitted` is not null AND (`Registration`.`dateCancelled` is not null AND `Registration`.`dateCancelled`<'2025-12-26 11:15:01')) AND `Registration`.`dateRejected` is null) AND `Registration`.`MeetingId`=0x1B4630000003E)

0.001

1 call
0 rows

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 (MeetingHotel, Address) WHERE `MeetingHotel`.`MeetingHotelId`=0xF56AAD000000A9 AND `MeetingHotel`.`AddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.001

1 call
54 rows

0.001

SELECT * FROM StateProvince ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD000000DD ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD000000C0 ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 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`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, User) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x8B570000000D ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Meeting where MeetingId=0x1B4630000003E

0.001

1 call
6 rows

0.001

SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Meeting, Meeting2Category, Category) WHERE (0x1B4630000003E=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Category`.`MeetingId` AND `Meeting2Category`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`

0.001

1 call
1 row

0.001

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration) WHERE ((((`Registration`.`dateApproved` is null AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2025-12-26 11:15:01')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x1B4630000003E)

0.000

2 calls
1 row

0.000

select mxxCreated, mxxUpdated from Meeting where MeetingId=0x1B4630000003E;

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 (Individual, Address) WHERE `Address`.`AddressId`=0x1B46300000042 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xF56AAD000000D7 ORDER BY `Committee`.`category`, `Committee`.`name`

0.000

1 call
4 rows

0.000

SELECT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (Timezone) ORDER BY `Timezone`.`orderindex` LIMIT 0, 700

0.000

1 call
0 rows

0.000

1 call
0 rows

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 (Timezone, CalendarItem) WHERE `CalendarItem`.`CalendarItemId`=0x1B46300000046 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 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`=0x1B4630000003E

0.000

1 call
0 rows

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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56AAD000000AA AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

1 call
28 rows

0.000

SELECT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType) ORDER BY `ReportingType`.`orderindex` LIMIT 0, 700

0.000

1 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`=0x1B4630000003E

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (Meeting, ReportingType) WHERE `Meeting`.`MeetingId`=0x1B4630000003E AND `Meeting`.`reportingTypeId`=`ReportingType`.`ReportingTypeId` ORDER BY `ReportingType`.`orderindex`

0.000

1 call
1 row

0.000

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

0.000

1 call
1 row

0.000

905458 function calls (900830 primitive calls) in 1.353 seconds Ordered by: cumulative time List reduced from 1522 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.354 1.354 /data/fmiam/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 1.340 1.340 /data/fmiam/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.290 1.290 /data/fmiam/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.290 1.290 /data/fmiam/current/libs/webform/meeting/baseMeetingForm.py:317(view) 1 0.000 0.000 1.290 1.290 /data/fmiam/current/libs/webform/PhatForm.py:420(view) 1 0.000 0.000 1.289 1.289 /data/fmiam/current/libs/framework/WebForm.py:189(view) 1 0.000 0.000 0.782 0.782 /data/fmiam/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.780 0.780 /data/fmiam/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 0.579 0.579 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:718(process) 10 0.000 0.000 0.490 0.049 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 10 0.000 0.000 0.489 0.049 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 10 0.000 0.000 0.489 0.049 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 10 0.000 0.000 0.486 0.049 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 13 0.000 0.000 0.486 0.037 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 13 0.007 0.001 0.485 0.037 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 1 0.000 0.000 0.425 0.425 /data/fmiam/current/libs/framework/DGEGroup.py:43(getDataDictionary) 54/1 0.000 0.000 0.425 0.425 /data/fmiam/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 6869 0.025 0.000 0.351 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.338 0.338 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:663(addMetaTags) 98 0.000 0.000 0.316 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 98 0.001 0.000 0.315 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 98 0.000 0.000 0.311 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 98 0.310 0.003 0.310 0.003 {function Connection.query at 0xf7f833cad8a0} 55/33 0.003 0.000 0.295 0.009 /data/fmiam/current/libs/framework/DGEAssocList.py:451(getDataDictionary) 65 0.001 0.000 0.276 0.004 /data/fmiam/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 59/57 0.000 0.000 0.274 0.005 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 1136/976 0.002 0.000 0.269 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2679(__getattr__) 10329/9628 0.006 0.000 0.249 0.000 {built-in method builtins.getattr} 6869 0.025 0.000 0.237 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 22 0.000 0.000 0.225 0.010 /data/fmiam/current/libs/PLayer/PersistentObject.py:2859(_loadListAssoc) 17 0.000 0.000 0.225 0.013 /data/fmiam/current/libs/PLayer/PersistentObject.py:2905(_loadAssocListSQL) 6869 0.017 0.000 0.201 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 1 0.000 0.000 0.201 0.201 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.201 0.201 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.201 0.201 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 1 0.000 0.000 0.200 0.200 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.200 0.200 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.200 0.200 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.200 0.200 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.200 0.200 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.005 0.005 0.200 0.200 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 6869 0.008 0.000 0.129 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 6879 0.039 0.000 0.127 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants) 26007 0.041 0.000 0.119 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag) 37872 0.046 0.000 0.113 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 14021 0.074 0.000 0.107 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 29/22 0.000 0.000 0.097 0.004 /data/fmiam/current/libs/framework/DGEAssoc.py:93(getDataDictionary) 1 0.000 0.000 0.093 0.093 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:27(_manipulateLogin) 704/685 0.003 0.000 0.079 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 312 0.001 0.000 0.074 0.000 /data/fmiam/current/libs/framework/DGEAttribute.py:110(getDataDictionary) 444 0.004 0.000 0.074 0.000 /data/fmiam/current/libs/framework/DGEAttribute.py:206(getValue) 2615 0.014 0.000 0.073 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 684 0.002 0.000 0.066 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 6869 0.013 0.000 0.058 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:501(get_tag) 6869 0.007 0.000 0.056 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:648(match_namespace) 445/200 0.001 0.000 0.049 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:108(new_init) 10 0.000 0.000 0.049 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.005 0.000 0.049 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 685 0.002 0.000 0.049 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 37/35 0.000 0.000 0.048 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2916(_loadAssoc) 218 0.001 0.000 0.048 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1062(startTagListItem) 37/35 0.001 0.000 0.048 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2982(_loadAssocSQL) 181 0.003 0.000 0.045 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:348(__init__) 1 0.000 0.000 0.042 0.042 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:406(_applyTitle) 1 0.000 0.000 0.042 0.042 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 1 0.000 0.000 0.042 0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 1 0.000 0.000 0.042 0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 37873/37872 0.038 0.000 0.042 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.042 0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 1 0.000 0.000 0.042 0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.042 0.042 /tmp/mako_modules_1011/fmiam/www/25.2.1/data/fmiam/current/generic/themes/www/mako/meetings/viewMeeting.html.py:28(render_body) 112 0.001 0.000 0.040 0.000 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 7736 0.009 0.000 0.040 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 691 0.001 0.000 0.040 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:455(new_tag) 88 0.001 0.000 0.040 0.000 /data/fmiam/current/libs/PLayer/PersistentBroker.py:159(createPO) 6879 0.013 0.000 0.039 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:88(is_doc) 92 0.001 0.000 0.039 0.000 /data/fmiam/current/libs/framework/DGESelect.py:120(getDataDictionary) 125298/124663 0.037 0.000 0.039 0.000 {built-in method builtins.isinstance} 694 0.037 0.000 0.038 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1068(__init__) 40 0.000 0.000 0.038 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 5 0.000 0.000 0.038 0.008 /data/fmiam/current/generic/classes/Meeting.py:2120(getNoOnlineRegistrationsReason) 45 0.000 0.000 0.037 0.001 /data/fmiam/current/libs/utils/emailTools.py:20(regexpEmailAndURLs) 87 0.000 0.000 0.037 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1543(createPOClassByName) 1 0.000 0.000 0.036 0.036 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:88(_makeBreadCrumbs) 4 0.000 0.000 0.035 0.009 /data/fmiam/current/generic/classes/Meeting.py:2163(getIsAcceptingOnlineRegistrations) 17 0.000 0.000 0.033 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:164(linkify) 57 0.000 0.000 0.033 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:287(parseFragment) 1 0.001 0.001 0.032 0.032 /data/fmiam/current/libs/framework/WebSite.py:419(outputDebugTable) 57 0.000 0.000 0.032 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:425(_parse) 1257 0.001 0.000 0.031 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 40 0.000 0.000 0.031 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:153(clean) 1 0.000 0.000 0.031 0.031 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:707(_drape) 99 0.000 0.000 0.030 0.000 /data/fmiam/current/libs/framework/WebSite.py:1284(debugHTML) 1257 0.002 0.000 0.030 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 1 0.000 0.000 0.030 0.030 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:11(getTitleElement) 100 0.000 0.000 0.029 0.000 /data/fmiam/current/libs/framework/MaxxRequestWrapper.py:53(write) 100 0.000 0.000 0.029 0.000 /data/fmiam/current/libs/framework/wsgiapp.py:285(write) 99 0.000 0.000 0.029 0.000 /data/fmiam/current/libs/framework/WebSite.py:924(writeHTML) 1 0.000 0.000 0.028 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1 0.000 0.000 0.028 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode)

SQF Train the Trainer 12/2005 Washington, DC

Registration Includes:

Who Should Attend:

Meeting Attire:

Registration Fees:

Cancellation and Other Policies:

General Hotel Information:

Travel Information:

Mega Menu

Sign Up for the