Product: QM Series 9: Auditing, Summarizing and Evaluating the Data: 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

QM Series 9: Auditing, Summarizing and Evaluating the Data

Format:
Electronic (digital download/no shipping)

Accredited Organization, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

This webinar was live on March 6, 2019. Ed Brindle MSc, MLT, BMT Quality Manager at UHN Blood and Marrow Transplant Program, discusses writing the audit report, determining WHY the errors occurred, and assigning appropriate corrective action and preventive action. This is the second webinar in the QM Series 9: Audits.

Product Details:

Product ID: 446

Publication Year: 2019

Pages, Size, or Length: 52 minutes

Product ID:	446
Publication Year:	2019
Pages, Size, or Length:	52 minutes

Total Time

Count

Avg Time

Query

0.006

1 call
0 rows

0.006

UPDATE PageRequest SET mxxUpdated='2025-05-09 14:17:41',mxxUpdatedBy=NULL, PageRequestId=0x2113EF00000000, path='forms/store/ProductFormPublic/example-quality-assessment-programs', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='317704', requestNum='1', growth='15404', server='www.fact.maxx.matrixdev.net', dbThreadId='104131', startTime='2025-05-09 14:17:39', sessionId=0x47D02163B41D75EA, userId=0x0, userName='public', result='0', sqltime='0.14399433135986328', timeTaken='60', dictSize='660', fields='{}', clientIPAddr='18.218.213.153' WHERE PageRequestId=0x2113EF00000000

0.003

1 call
0 rows

0.003

INSERT INTO PageRequest SET mxxCreated='2025-05-09 14:18:40',mxxCreatedBy=NULL, PageRequestId=0x2113EF0000001B, path='forms/store/ProductFormPublic/qm-series-9-summarizing-and-evaluating-the-data', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='317704', requestNum='2', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='104131', startTime='2025-05-09 14:18:40', sessionId=0x456906D734DD181D, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='3.16.216.138'

0.003

2 calls
1 row

0.001

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

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.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=0x46D900000045 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.002

1 call
13 rows

0.002

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

1 call
4 rows

0.002

SELECT * FROM ShipType ORDER BY orderindex, id

0.002

1 call
4 rows

0.002

SELECT * FROM Language ORDER BY orderindex, id

0.001

1 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.slug='qm-series-9-summarizing-and-evaluating-the-data' ORDER BY Product.name

0.001

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 5001536382546286621

0.001

6 calls
1 row

0.000

SELECT version from databasemap;

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=0x78498000000F5 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
2 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 (0x1484F30000000B=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

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

0.001

1 call
0 rows

0.001

2 calls
1 row

0.000

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

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

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=0x1484C2000000FC AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-05-09 14:18:40')

0.000

1 call
4 rows

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

0.000

1 call
3 rows

0.000

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

0.000

1 call
1 row

0.000

1 call
5 rows

0.000

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

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

0.000

1 call
2 rows

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

0.000

1 call
0 rows

0.000

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

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

0.000

1 call
2 rows

0.000

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

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

0.000

1 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=0x1484FD00000016 AND File.fileProtectionTypeId=FileProtectionType.FileProtectionTypeId

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

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 (0x1484C2000000FC=Product.ProductId AND Product.ProductId=Product2MailingList.ProductId AND Product2MailingList.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

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

0.000

1 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 (0x1484C2000000FC=Product.ProductId AND Product.ProductId=Product2Site.ProductId AND Product2Site.SiteId=Site.SiteId)

0.000

1 call
1 row

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

2 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.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 (0x1484C200000122=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

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

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 (0x1484F30000000B=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

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

581775 function calls (577889 primitive calls) in 0.682 seconds Ordered by: cumulative time List reduced from 1636 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.682 0.682 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.672 0.672 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.658 0.658 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.658 0.658 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 0.655 0.655 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.503 0.503 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.502 0.502 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.406 0.406 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.388 0.388 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.202 0.202 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 0.202 0.202 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 0.202 0.067 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 0.202 0.101 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.202 0.101 /usr/lib/python3.11/urllib/request.py:1307(do_open) 2/1 0.000 0.000 0.179 0.179 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.179 0.179 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.179 0.179 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.179 0.179 /usr/lib/python3.11/urllib/request.py:1390(https_open) 7/1 0.000 0.000 0.129 0.129 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 11/1 0.000 0.000 0.129 0.129 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 2 0.000 0.000 0.127 0.063 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 0.126 0.063 /usr/lib/python3.11/http/client.py:318(begin) 14 0.000 0.000 0.126 0.009 /usr/lib/python3.11/socket.py:704(readinto) 2 0.000 0.000 0.126 0.063 /usr/lib/python3.11/http/client.py:285(_read_status) 28 0.000 0.000 0.126 0.004 {method 'readline' of '_io.BufferedReader' objects} 12 0.000 0.000 0.118 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.117 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.117 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.115 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.115 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.005 0.000 0.114 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 13 0.000 0.000 0.107 0.008 /usr/lib/python3.11/ssl.py:1299(recv_into) 13 0.000 0.000 0.107 0.008 /usr/lib/python3.11/ssl.py:1157(read) 13 0.107 0.008 0.107 0.008 {method 'read' of '_ssl._SSLSocket' objects} 1 0.000 0.000 0.105 0.105 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 129 0.001 0.000 0.102 0.001 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 1 0.000 0.000 0.097 0.097 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 14 0.000 0.000 0.094 0.007 /data/fact/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 14 0.000 0.000 0.094 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 14 0.000 0.000 0.093 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 14 0.000 0.000 0.093 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 20 0.000 0.000 0.093 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 20 0.001 0.000 0.092 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 2 0.000 0.000 0.087 0.043 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 272 0.001 0.000 0.073 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 272 0.003 0.000 0.071 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 3043 0.003 0.000 0.066 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 17/10 0.001 0.000 0.063 0.006 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 1 0.000 0.000 0.061 0.061 /usr/lib/python3.11/http/client.py:1426(__init__) 1 0.002 0.002 0.060 0.060 /usr/lib/python3.11/ssl.py:745(create_default_context) 8/5 0.000 0.000 0.060 0.012 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 355/272 0.000 0.000 0.060 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 1062/272 0.013 0.000 0.059 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 1 0.000 0.000 0.058 0.058 /usr/lib/python3.11/ssl.py:591(load_default_certs) 1 0.058 0.058 0.058 0.058 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 1 0.000 0.000 0.053 0.053 /data/fact/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 3043 0.004 0.000 0.052 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.052 0.052 /data/fact/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 1 0.000 0.000 0.046 0.046 /data/fact/current/libs/framework/baseScrapeAndDrape.py:659(addMetaTags) 84 0.000 0.000 0.045 0.001 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 3043 0.003 0.000 0.044 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 2512 0.009 0.000 0.044 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 62 0.000 0.000 0.042 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 62 0.000 0.000 0.041 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 62 0.000 0.000 0.039 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 62 0.039 0.001 0.039 0.001 {function Connection.query at 0xfb7111aa8680} 18 0.000 0.000 0.036 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 18 0.010 0.001 0.036 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 730/679 0.001 0.000 0.034 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 3043 0.003 0.000 0.031 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 654 0.003 0.000 0.027 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 40 0.000 0.000 0.026 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 6287 0.016 0.000 0.025 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 3057 0.004 0.000 0.025 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants) 4 0.000 0.000 0.024 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 896/4 0.006 0.000 0.024 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 896/4 0.004 0.000 0.024 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 1 0.000 0.000 0.023 0.023 /usr/lib/python3.11/urllib/request.py:1376(http_open) 6262 0.006 0.000 0.023 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 15486 0.009 0.000 0.022 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 10325 0.009 0.000 0.021 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag) 389/302 0.002 0.000 0.020 0.000 /data/fact/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 1 0.000 0.000 0.020 0.020 /data/fact/current/libs/framework/baseScrapeAndDrape.py:443(_addToHead) 1088 0.005 0.000 0.020 0.000 /data/fact/current/libs/framework/MaxxDTML.py:29(render) 2432 0.002 0.000 0.020 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 11 0.000 0.000 0.019 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1742(find) 1 0.019 0.019 0.019 0.019 {method 'recv_into' of '_socket.socket' objects} 407 0.001 0.000 0.018 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 7 0.000 0.000 0.018 0.003 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 29 0.000 0.000 0.018 0.001 /data/fact/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 876 0.001 0.000 0.017 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 89227/88877 0.016 0.000 0.017 0.000 {built-in method builtins.isinstance} 18285 0.016 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 876 0.002 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 2442 0.009 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:376(getitem) 4 0.000 0.000 0.015 0.004 /data/fact/current/libs/framework/baseScrapeAndDrape.py:434(_appendOrCreateOGTag) 16 0.000 0.000 0.015 0.001 /data/fact/current/libs/framework/DGESelect.py:36(getEditHTML) 2 0.000 0.000 0.015 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 89 0.000 0.000 0.015 0.000 /data/fact/current/libs/framework/DGEAttribute.py:87(getViewHTMLFormxxView) 2 0.000 0.000 0.015 0.007 /usr/lib/python3.11/http/client.py:1300(request)

QM Series 9: Auditing, Summarizing and Evaluating the Data

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org