Product Details 

You can only gain access to certain items and special pricing if you have logged in. Login Now.

Quality and Accreditation for Cellular Therapy A Global Perspective

Format:
Digital

Accredited Organization, Guest, Inspector, Inspector Trainee, NonMember - $0.00

Description:

Join FACT-JACIE and the WBMT for a webinar, Quality and Accreditation for Cellular Therapy: A Global Perspective. Presenters described the essential requirements for establishing a hematopoietic stem cell program and emphasized the required quality elements. Existing tools to help achieve accreditation in low and middle income countries were discussed, and presenters shared their experience in developing a Cellular Therapy quality program in the Asia-Pacific region. Presenters include: •WBMT representative: Dr. Dietger Niederwieser, Professor of Medicine and Head of Hematology and Oncology at University Hospital Leipzig, Germany •APBMT representative: Dr. Alok Srivastava, Centre for Stem Cell Research at Christian Medical College Vellore, India •FACT/JACIE representative: Dr. Carlos Bachier, Program Director and Processing Facility Director at Sarah Cannon Blood and Marrow Transplant Program. Webinar Moderators: •Dr. Joseph Schwartz, Transfusion Medicine and Cellular Therapy •Eoin McGrath, Director, Advocacy and Quality of Care Department at EBMT.

Product Details:

Product ID: 466
Publication Year: 2021
Pages, Size, or Length: 60 minutes
Debugging Info
pagedictsize=552
sqltime = 0.059 s
cpu time = 0.520 s
real time = 0.952 s
memory increase = 15380 kB
fields =
templates =
/data/fact/current/fact_org/themes/www/store_footer
/data/fact/current/fact_org/themes/www/store_header
/data/fact/current/generic/themes/shared/dgelements/button
/data/fact/current/generic/themes/shared/dgelements/checkbox
/data/fact/current/generic/themes/shared/dgelements/checkboxyesno
/data/fact/current/generic/themes/shared/dgelements/date
/data/fact/current/generic/themes/shared/dgelements/datetime
/data/fact/current/generic/themes/shared/dgelements/fileView
/data/fact/current/generic/themes/shared/dgelements/find
/data/fact/current/generic/themes/shared/dgelements/input
/data/fact/current/generic/themes/shared/dgelements/money
/data/fact/current/generic/themes/shared/dgelements/moneyView
/data/fact/current/generic/themes/shared/dgelements/objectSelect
/data/fact/current/generic/themes/shared/dgelements/radio
/data/fact/current/generic/themes/shared/dgelements/radioLinear
/data/fact/current/generic/themes/shared/dgelements/select
/data/fact/current/generic/themes/shared/dgelements/submitButton
/data/fact/current/generic/themes/shared/dgelements/text
/data/fact/current/generic/themes/shared/dgelements/view
/data/fact/current/generic/themes/shared/mako/dgelements/file.html
/data/fact/current/generic/themes/www/mako/store/viewProduct.html
scrapeAndDrape FRESH stub: http://test.factglobal.org/product-details
dg = ['viewProduct'] | [80040]
extra debug info =
queries = 79 queries

Total TimeCountAvg TimeQuery
0.01024 calls
1 row
0.000 SELECT version from databasemap;
0.0042 calls
1 row
0.002 select max(returnOrder) from Stack where sessionId = 593806502610334299
0.0041 call
0 rows
0.004 COMMIT
0.0031 call
1 row
0.003 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (Product) WHERE `Product`.`slug`='fact-jacie-and-wbmt-webinar' ORDER BY `Product`.`name`
0.0031 call
0 rows
0.003 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 (Product2MailingList, MailingList, Product) WHERE (0x16E34300000011=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2MailingList`.`ProductId` AND `Product2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`
0.0031 call
1 row
0.003 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Product) WHERE `Product`.`downloadFileId`=`File`.`FileId` AND `Product`.`ProductId`=0x16E34300000011
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (SpecialOffer, Product) WHERE `SpecialOffer`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x16E34300000011
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x22B04700000006 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0022 calls
4 rows
0.001 SELECT * FROM Language ORDER BY orderindex, id
0.0022 calls
1 row
0.001 select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0x16E34300000011
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x22B04700000002 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0021 call
0 rows
0.002 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`=0x1FB500000014 ORDER BY `Committee`.`name`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice2SpecialOffer, ProductPrice, SpecialOffer, Product) WHERE ((`ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x16E34300000011 AND (`ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)) AND `SpecialOffer`.`expires`>'2025-08-17 15:10:11')
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category, Category2Product, Product) WHERE (0x16E34300000011=`Product`.`ProductId` AND `Product`.`ProductId`=`Category2Product`.`ProductId` AND `Category2Product`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (Product) WHERE ProductId=(select PreviousProductId from Product where ProductId = 0x16E34300000011) ORDER BY `Product`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (Product) WHERE `Product`.`ProductId`=0x16E34300000011 ORDER BY `Product`.`name`
0.0011 call
0 rows
0.001 START TRANSACTION
0.0012 calls
1 row
0.000 select mxxCreated, mxxUpdated from Product where ProductId=0x16E34300000011;
0.0011 call
1 row
0.001 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 (ProductPrice, MailingList, MailingList2ProductPrice) WHERE (0x16E2D700000036=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MailingList2ProductPrice`.`ProductPriceId` AND `MailingList2ProductPrice`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`
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`.`criticalNotes`, `Individual`.`emergencyContact`, `Individual`.`signedForms`, `Individual`.`affiliatedWithBank`, `Individual`.`affiliatedWithOrg`, `Individual`.`affiliatedWithOrgName`, `Individual`.`affiliatedWithBankName`, `Individual`.`inspectionAgencyNumber`, `Individual`.`otherProfessionalSocieties`, `Individual`.`membershipNumberASBMT`, `Individual`.`membershipNumberISCT`, `Individual`.`readConfidentialityPolicy`, `Individual`.`conflictOfInterests`, `Individual`.`medicalLicenseExpiration`, `Individual`.`professionalLiabilityUploaded`, `Individual`.`professionalHistoryRestrictions`, `Individual`.`professionalLiabilityCase`, `Individual`.`professionalLiabilityReasonToDeny`, `Individual`.`appropriateAffiliation`, `Individual`.`affiliationComments`, `Individual`.`cellularTherapyWorkshopDate`, `Individual`.`cordBloodWorkshopDate`, `Individual`.`cellularTherapyTestDate`, `Individual`.`cordBloodTestDate`, `Individual`.`professionalInspectionWebinarDate`, `Individual`.`trainingInspectionWebinarDate`, `Individual`.`trainingInspectionDate`, `Individual`.`satisfactoryEvaluationReport`, `Individual`.`satisfactoryInspectionReport`, `Individual`.`isInspectorPending`, `Individual`.`accreditationEndDate`, `Individual`.`accreditationStartDate`, `Individual`.`congresspersonFor`, `Individual`.`factWebAssessmentDate`, `Individual`.`factWebEventDate`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`otherMemberships`, `Individual`.`dateCVReceived`, `Individual`.`iieCTTestDate`, `Individual`.`anniversaryVideoDate`, `Individual`.`iecTutorialDate`, `Individual`.`accredPortalTrainingDate`, `Individual`.`annualComplianceReceived`, `Individual`.`medicalLicenseExpDate`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x78498000000F5 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 call
4 rows
0.001 SELECT DISTINCT hex(`WebTab`.`WebTabId`) AS `WebTabId`, `WebTab`.`name`, `WebTab`.`link`, `WebTab`.`description`, hex(`WebTab`.`parent`) AS `parent`, `WebTab`.`requiredSetting`, `WebTab`.`defaultSubTab` FROM (WebTab) WHERE `WebTab`.`parent`=0xA ORDER BY `WebTab`.`WebTabId`
0.0011 call
158 rows
0.001 SELECT * FROM webselect
0.0011 call
13 rows
0.001 SELECT DISTINCT hex(`WebTab`.`WebTabId`) AS `WebTabId`, `WebTab`.`name`, `WebTab`.`link`, `WebTab`.`description`, hex(`WebTab`.`parent`) AS `parent`, `WebTab`.`requiredSetting`, `WebTab`.`defaultSubTab` FROM (WebTab) WHERE `WebTab`.`parent` is null ORDER BY `WebTab`.`WebTabId`
0.0002 calls
2 rows
0.000 SELECT * FROM ProductActivationStatus ORDER BY orderindex, id
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ChildProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x16E34300000011
0.0002 calls
5 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0001 call
5 rows
0.000 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (MembershipType, Product, MembershipType2Product) WHERE (0x16E34300000011=`Product`.`ProductId` AND `Product`.`ProductId`=`MembershipType2Product`.`ProductId` AND `MembershipType2Product`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0001 call
5 rows
0.000 SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0x16E2D700000036=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x22B04700000002 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Product`.`ProductId`) AS `ProductId`, `Product`.`name`, `Product`.`ProductTypeId`, `Product`.`govRelations`, `Product`.`training`, `Product`.`laborRelations`, `Product`.`MembersOnlyId`, `Product`.`description`, `Product`.`size`, `Product`.`weight`, `Product`.`year`, `Product`.`memberPrice`, `Product`.`nonMemberPrice`, `Product`.`bookStorePrice`, `Product`.`governmentPrice`, `Product`.`retiredPrice`, `Product`.`uploadCover`, `Product`.`imageAltTag`, `Product`.`fullDocument`, `Product`.`fileType`, `Product`.`fileSize`, `Product`.`submitted`, `Product`.`toc`, `Product`.`productNumber`, `Product`.`electronic`, `Product`.`print`, `Product`.`language`, `Product`.`coverSize`, `Product`.`tocSize`, `Product`.`vendorId`, `Product`.`department`, `Product`.`productionNotes`, `Product`.`shipType`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteDirectoryURL`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteExpirationDate`, `Product`.`expirationDuration`, `Product`.`activationStatus`, `Product`.`orderindex`, `Product`.`mxxCreated`, `Product`.`mxxUpdated`, `Product`.`recordOrigin`, `Product`.`slug`, `Product`.`specialNotes`, `Product`.`campaignCode`, `Product`.`originalImage`, `Product`.`publishStartDate`, `Product`.`publishEndDate`, `Product`.`imageOverlayText`, `Product`.`embedCode`, `Product`.`featuredExpirationDate`, `Product`.`externalContentLink` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ProductRelationId`=0x22B04700000006 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`
0.0002 calls
0 rows
0.000 SELECT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType) ORDER BY `ReportingType`.`orderindex` LIMIT 0, 700
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`ProductPrice`.`ProductPriceId`) AS `ProductPriceId`, `ProductPrice`.`amount`, `ProductPrice`.`minQuantity`, `ProductPrice`.`maxQuantity`, `ProductPrice`.`shipType`, `ProductPrice`.`priceType`, `ProductPrice`.`description`, `ProductPrice`.`accountingCode`, `ProductPrice`.`membershipTypesLabelForWWW` FROM (ProductPrice, Product) WHERE `ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x16E34300000011 ORDER BY `ProductPrice`.`description`, `ProductPrice`.`minQuantity`
0.0001 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`=0x22B04700000012 ORDER BY `Committee`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (ProductRelation, Product) WHERE `ProductRelation`.`ParentProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0x16E34300000011
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-17 15:10:11',`mxxCreatedBy`=NULL, `PageRequestId`=0x22B04700000000, `path`='forms/store/ProductFormPublic/fact-jacie-and-wbmt-webinar', `formName`='fact_ProductFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='2157430', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='226858', `startTime`='2025-08-17 15:10:11', `sessionId`=0x83D9FDE3567F25B, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.186'
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x16E2D700000036=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Site`.`SiteId`) AS `SiteId`, `Site`.`dateDeleted`, `Site`.`face`, `Site`.`name`, `Site`.`storeFront`, `Site`.`howToOrder`, `Site`.`url` FROM (Product2Site, Site, Product) WHERE (0x16E34300000011=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2Site`.`ProductId` AND `Product2Site`.`SiteId`=`Site`.`SiteId`)
0.0001 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`=0x78498000000F5
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`FileProtectionType`.`FileProtectionTypeId`) AS `FileProtectionTypeId`, `FileProtectionType`.`name`, `FileProtectionType`.`description`, `FileProtectionType`.`path`, `FileProtectionType`.`prefix` FROM (File, FileProtectionType) WHERE `File`.`FileId`=0x16E30300000066 AND `File`.`fileProtectionTypeId`=`FileProtectionType`.`FileProtectionTypeId`
0.0001 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`=0x22B0470000000F ORDER BY `Committee`.`name`
0.0001 call
4 rows
0.000 SELECT * FROM Folks ORDER BY orderindex, id
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Site`.`SiteId`) AS `SiteId`, `Site`.`dateDeleted`, `Site`.`face`, `Site`.`name`, `Site`.`storeFront`, `Site`.`howToOrder`, `Site`.`url` FROM (ProductFeaturedOn2Site, Site, Product) WHERE (0x16E34300000011=`Product`.`ProductId` AND `Product`.`ProductId`=`ProductFeaturedOn2Site`.`ProductId` AND `ProductFeaturedOn2Site`.`SiteId`=`Site`.`SiteId`)
0.0001 call
8 rows
0.000 SELECT * FROM ProductType ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
2 rows
0.000 SELECT * FROM ProductStatus ORDER BY orderindex, id
0.0001 call
12 rows
0.000 SELECT * FROM Month ORDER BY orderindex, id
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType, Product) WHERE `Product`.`ProductId`=0x16E34300000011 AND `Product`.`reportingTypeId`=`ReportingType`.`ReportingTypeId` ORDER BY `ReportingType`.`orderindex`
0.0001 call
3 rows
0.000 SELECT * FROM PriceType ORDER BY orderindex, id
0.0001 call
2 rows
0.000 SELECT * FROM YesNo ORDER BY orderindex, id