Product: Example Quality Assessment Programs: FACT

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

Store main page

Advanced Search

How to order

View cart

Example Quality Assessment Programs

Format:
Electronic (digital download/no shipping)

Accredited Organization, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

This Virtual Roundtable discusses the challenges and successes of performing quality assessments in cellular therapy programs and a cord blood bank. Examples of the assessment processes in these organizations are presented followed by a question and answer period with experts from the field of cellular therapy.

Product Details:

Product ID: 304

Publication Year: 2010

Product ID:	304
Publication Year:	2010

Total Time

Count

Avg Time

Query

0.016

1 call
1 row

0.016

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='example-quality-assessment-programs' ORDER BY Product.name

0.010

24 calls
1 row

0.000

SELECT version from databasemap;

0.008

1 call
3 rows

0.008

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=0xC7B0000084A ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.007

1 call
0 rows

0.007

INSERT INTO PageRequest SET mxxCreated='2025-05-09 14:17:39',mxxCreatedBy=NULL, PageRequestId=0x2113EF00000000, path='forms/store/ProductFormPublic/example-quality-assessment-programs', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='317704', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='104131', startTime='2025-05-09 14:17:39', sessionId=0x47D02163B41D75EA, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='18.218.213.153'

0.006

1 call
0 rows

0.006

SELECT DISTINCT hex(Category.CategoryId) AS CategoryId, Category.description, hex(Category.ParentCategoryId) AS ParentCategoryId FROM (Category2Product, Category, Product) WHERE (0xC7B0000084A=Product.ProductId AND Product.ProductId=Category2Product.ProductId AND Category2Product.CategoryId=Category.CategoryId) ORDER BY Category.description

0.006

1 call
0 rows

0.006

COMMIT

0.006

1 call
5 rows

0.006

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType2Product, MembershipType, Product) WHERE (0xC7B0000084A=Product.ProductId AND Product.ProductId=MembershipType2Product.ProductId AND MembershipType2Product.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.005

2 calls
4 rows

0.003

SELECT * FROM Language ORDER BY orderindex, id

0.005

1 call
13 rows

0.005

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

1 call
0 rows

0.005

SELECT DISTINCT hex(ProductRelation.ProductRelationId) AS ProductRelationId FROM (ProductRelation, Product) WHERE ProductRelation.ParentProductId=Product.ProductId AND Product.ProductId=0xC7B0000084A

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0xC8000000025=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(Site.SiteId) AS SiteId, Site.dateDeleted, Site.face, Site.name, Site.storeFront, Site.howToOrder, Site.url FROM (Product2Site, Site, Product) WHERE (0xC7B0000084A=Product.ProductId AND Product.ProductId=Product2Site.ProductId AND Product2Site.SiteId=Site.SiteId)

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(ReportingType.ReportingTypeId) AS ReportingTypeId, ReportingType.description, ReportingType.orderindex FROM (ReportingType, Product) WHERE Product.ProductId=0xC7B0000084A AND Product.reportingTypeId=ReportingType.ReportingTypeId ORDER BY ReportingType.orderindex

0.004

1 call
8 rows

0.004

SELECT * FROM ProductType ORDER BY orderindex, id

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (MailingList, Product2MailingList, Product) WHERE (0xC7B0000084A=Product.ProductId AND Product.ProductId=Product2MailingList.ProductId AND Product2MailingList.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.003

3 calls
4 rows

0.001

SELECT * FROM ShipType ORDER BY orderindex, id

0.003

2 calls
2 rows

0.001

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.003

1 call
1 row

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 (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0xCB9000001D1=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.003

1 call
0 rows

0.003

START TRANSACTION

0.003

1 call
3 rows

0.003

SELECT * FROM PriceType ORDER BY orderindex, id

0.002

2 calls
0 rows

0.001

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

0.002

1 call
2 rows

0.002

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(FileProtectionType.FileProtectionTypeId) AS FileProtectionTypeId, FileProtectionType.name, FileProtectionType.description, FileProtectionType.path, FileProtectionType.prefix FROM (File, FileProtectionType) WHERE File.FileId=0xC6F00001368 AND File.fileProtectionTypeId=FileProtectionType.FileProtectionTypeId

0.002

1 call
12 rows

0.002

SELECT * FROM Month ORDER BY orderindex, id

0.002

1 call
4 rows

0.002

SELECT * FROM Folks ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, ProductPrice2SpecialOffer, SpecialOffer) WHERE (0xCB9000001D1=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.002

1 call
4 rows

0.002

1 call
3 rows

0.002

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0xC8000000025=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(ProductRelation.ProductRelationId) AS ProductRelationId FROM (ProductRelation, Product) WHERE ProductRelation.ChildProductId=Product.ProductId AND Product.ProductId=0xC7B0000084A

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 (MailingList, Committee) WHERE MailingList.CommitteeId=Committee.CommitteeId AND MailingList.MailingListId=0x2113EF0000000E ORDER BY Committee.name

0.001

1 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 (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x2113EF00000005 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, ProductPrice2SpecialOffer, SpecialOffer) WHERE (0xC8000000025=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0xCB9000001D1=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.001

1 call
1 row

0.001

1 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 (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x2113EF00000005 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name

0.001

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 5174672683956008426

0.001

2 calls
1 row

0.000

select mxxCreated, mxxUpdated from Product where ProductId=0xC7B0000084A;

0.001

1 call
0 rows

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 (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0xC7A00000316=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.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.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 FROM (Individual, User) WHERE Individual.userId=User.UserId AND User.UserId=0x164B8000000002 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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.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 FROM (Individual, User) WHERE Individual.userId=User.UserId AND User.UserId=0x2140000000C ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
0 rows

0.001

1 call
158 rows

0.001

SELECT * FROM webselect

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Site.SiteId) AS SiteId, Site.dateDeleted, Site.face, Site.name, Site.storeFront, Site.howToOrder, Site.url FROM (ProductFeaturedOn2Site, Site, Product) WHERE (0xC7B0000084A=Product.ProductId AND Product.ProductId=ProductFeaturedOn2Site.ProductId AND ProductFeaturedOn2Site.SiteId=Site.SiteId)

0.001

1 call
2 rows

0.001

SELECT * FROM YesNo ORDER BY orderindex, id

0.001

1 call
2 rows

0.001

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0xC7A00000316=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(File.FileId) AS FileId, File.filename, File.description, File.caption, File.altTag, hex(File.parentId) AS parentId FROM (File, Product) WHERE Product.downloadFileId=File.FileId AND Product.ProductId=0xC7B0000084A

0.001

1 call
0 rows

0.001

0.000

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0xC7B0000084A

0.000

1 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=0x2113EF00000002 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

0.000

1 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=0x2113EF00000002 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (SpecialOffer, ProductPrice2SpecialOffer, ProductPrice, Product) WHERE ((ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0xC7B0000084A AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-05-09 14:17:39')

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, ProductPrice2SpecialOffer, SpecialOffer) WHERE (0xC7A00000316=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.000

1 call
0 rows

0.000

1 call
0 rows

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=0x164B8000000002

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
1 row

0.000

859050 function calls (849178 primitive calls) in 1.785 seconds Ordered by: cumulative time List reduced from 2653 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.788 1.788 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 1.379 1.379 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 1.325 1.325 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.325 1.325 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 1.307 1.307 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.822 0.822 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.820 0.820 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.695 0.695 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 2 0.000 0.000 0.501 0.251 /usr/lib/python3.11/urllib/request.py:139(urlopen) 3/2 0.000 0.000 0.501 0.250 /usr/lib/python3.11/urllib/request.py:500(open) 7/5 0.000 0.000 0.498 0.100 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 3 0.000 0.000 0.498 0.166 /usr/lib/python3.11/urllib/request.py:529(_open) 3 0.000 0.000 0.498 0.166 /usr/lib/python3.11/urllib/request.py:1307(do_open) 2 0.000 0.000 0.478 0.239 /usr/lib/python3.11/urllib/request.py:1390(https_open) 97 0.014 0.000 0.409 0.004 {method 'readline' of '_io.BufferedReader' objects} 7/1 0.000 0.000 0.398 0.398 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 11/1 0.000 0.000 0.398 0.398 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 3 0.000 0.000 0.396 0.132 /usr/lib/python3.11/http/client.py:1351(getresponse) 3 0.000 0.000 0.396 0.132 /usr/lib/python3.11/http/client.py:318(begin) 1 0.000 0.000 0.396 0.396 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 15 0.000 0.000 0.395 0.026 /usr/lib/python3.11/socket.py:704(readinto) 3 0.000 0.000 0.395 0.132 /usr/lib/python3.11/http/client.py:285(_read_status) 1 0.000 0.000 0.380 0.380 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.380 0.380 /data/fact/current/libs/framework/WebSite.py:92(__init__) 14 0.000 0.000 0.378 0.027 /usr/lib/python3.11/ssl.py:1299(recv_into) 14 0.000 0.000 0.378 0.027 /usr/lib/python3.11/ssl.py:1157(read) 14 0.378 0.027 0.378 0.027 {method 'read' of '_ssl._SSLSocket' objects} 140 0.001 0.000 0.317 0.002 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 1 0.000 0.000 0.296 0.296 /data/fact/current/libs/framework/WebApp.py:399(getHeaderDict) 1 0.000 0.000 0.284 0.284 /data/fact/current/libs/framework/WebApp.py:494(getSupportCenterContent) 1 0.000 0.000 0.282 0.282 /data/fact/current/libs/utils/supportCenter.py:9(getSupportCenterArticles) 1 0.006 0.006 0.235 0.235 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 356/173 0.013 0.000 0.233 0.001 {built-in method builtins.exec} 218/145 0.003 0.000 0.226 0.002 :666(_load_unlocked) 200/127 0.001 0.000 0.226 0.002 :1165(_find_and_load) 200/127 0.001 0.000 0.221 0.002 :1120(_find_and_load_unlocked) 219/148 0.001 0.000 0.220 0.001 :934(exec_module) 3/2 0.000 0.000 0.204 0.102 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.204 0.204 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.204 0.204 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 123 0.001 0.000 0.198 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 123 0.001 0.000 0.197 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 446/270 0.001 0.000 0.190 0.001 :233(_call_with_frames_removed) 93 0.001 0.000 0.182 0.002 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 123 0.001 0.000 0.170 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 123 0.170 0.001 0.170 0.001 {function Connection.query at 0xfb7111aa8680} 19/10 0.001 0.000 0.147 0.015 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 16120/15707 0.020 0.000 0.142 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 295 0.002 0.000 0.136 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 443 0.002 0.000 0.134 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 295 0.003 0.000 0.134 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 9/5 0.000 0.000 0.127 0.025 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 1 0.000 0.000 0.125 0.125 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 1 0.000 0.000 0.125 0.125 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 53 0.000 0.000 0.123 0.002 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 93 0.001 0.000 0.121 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 16143/15711 0.009 0.000 0.121 0.000 {built-in method builtins.__import__} 14 0.000 0.000 0.116 0.008 /data/fact/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 14 0.000 0.000 0.116 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 14 0.000 0.000 0.116 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 79 0.000 0.000 0.115 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 14 0.000 0.000 0.113 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 20 0.000 0.000 0.113 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 20 0.001 0.000 0.112 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 106 0.001 0.000 0.112 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 102 0.000 0.000 0.112 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 48 0.000 0.000 0.110 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 3 0.000 0.000 0.106 0.035 /data/fact/current/libs/framework/DGELongInput.py:14(massageDictForEditHTML) 43 0.001 0.000 0.105 0.002 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 6540 0.096 0.000 0.102 0.000 /data/fact/current/libs/framework/LazyDict.py:71(__setitem__) 12 0.000 0.000 0.102 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.101 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.101 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.099 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.099 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.004 0.000 0.098 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.088 0.088 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 48 0.000 0.000 0.083 0.002 /usr/lib/python3.11/re/_compiler.py:573(_code) 385/295 0.001 0.000 0.082 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 1156/295 0.015 0.000 0.082 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 2 0.000 0.000 0.081 0.041 /usr/lib/python3.11/http/client.py:1426(__init__) 2 0.000 0.000 0.081 0.040 /usr/lib/python3.11/ssl.py:745(create_default_context) 3043 0.003 0.000 0.081 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 2 0.000 0.000 0.079 0.040 /usr/lib/python3.11/ssl.py:591(load_default_certs) 2 0.079 0.040 0.079 0.040 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 2 0.000 0.000 0.073 0.036 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 112 0.071 0.001 0.072 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 2 0.001 0.000 0.072 0.036 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 399/315 0.001 0.000 0.072 0.000 /data/fact/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 32 0.000 0.000 0.071 0.002 /data/fact/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 8 0.004 0.001 0.071 0.009 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 2861/2837 0.003 0.000 0.070 0.000 /data/fact/current/libs/framework/LazyDict.py:186(__getitem__) 1 0.000 0.000 0.068 0.068 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 104/86 0.000 0.000 0.068 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__) 8096/7770 0.006 0.000 0.067 0.000 {built-in method builtins.getattr} 8 0.053 0.007 0.067 0.008 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 1 0.000 0.000 0.066 0.066 /data/fact/current/libs/framework/baseScrapeAndDrape.py:659(addMetaTags) 1 0.000 0.000 0.066 0.066 /data/fact/current/libs/framework/WebForm.py:2883(getViewDG) 1 0.000 0.000 0.066 0.066 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:75(_getDGByName) 1 0.000 0.000 0.066 0.066 /data/fact/current/libs/framework/WebSite.py:973(getDGByName)

Example Quality Assessment Programs

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org