Product: QM Series 12 Webinar: Program's Perspective: Three Views: 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 12 Webinar: Program's Perspective: Three Views

Format:
Electronic (digital download/no shipping)

Accredited Organization, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

Tuesday, January 16, 2024, Quality Management Series 12 webinar: Program's Perspective: Three Views. The theme for Series 12 is Embrace Change: Growing Your Cellular Therapy Services. Each webinar will equip your organization with practical strategies and insights to successfully incorporate a new service or product into your cellular therapy organization while ensuring compliance, optimizing patient outcomes, and driving continuous improvement. Each webinar will consist of a 45-minute live lecture period followed by a 15-minute Q&A session. This webinar is a roundtable featuring three presenters and the following objectives: Presentation #1 - Dr. Juan A. Merayo-Rodriguez, MD, CABP • Evaluate requirements for new products or services. • Execute a change control workshop for new products or services. • Demonstrate the management and documentation of change to comply with FACT standards. Presentation #2 - Karen Collum, DNP, RN, OCN • Construct actionable process metrics for clinical quality indicators. • Analyze outcome metrics for clinical quality indicators. • Implement a benchmarking plan for clinical quality indicators. Presentation #3 - Korrynn Vincent, BS • Review the different types of written agreements and describe appropriate review and approval processes. • Explain FACT’s requirements for written agreements • Define quality agreements and outline their critical elements. • Examine the reporting of Risk Evaluation and Mitigation Strategies (REMS)

Product Details:

Product ID: 123590

Publication Year: 2023

Pages, Size, or Length: 1 hour

Related Products

QM Series 12 Webinar: Facility Needs Assessment & Change Control Accredited Organization, Guest, NonMember - $100.00
Inspector, Inspector Trainee - $0.00

Quality Management Series 12 Webinar Bundle, Part 1 - 2023 Accredited Organization, Guest, NonMember - $340.00
Inspector, Inspector Trainee - $0.00

QM Series 12 Webinar: Establishing Quality Indicators Accredited Organization, Guest, NonMember - $100.00
Inspector, Inspector Trainee - $0.00

QM Series 12 Webinar: Written Agreements Accredited Organization, Guest, NonMember - $100.00
Inspector, Inspector Trainee - $0.00

Product ID:	123590
Publication Year:	2023
Pages, Size, or Length:	1 hour

Total Time

Count

Avg Time

Query

0.032

1 call
0 rows

0.032

INSERT INTO PageRequest SET mxxCreated='2025-05-09 07:21:43',mxxCreatedBy=NULL, PageRequestId=0x21122600000000, path='forms/store/ProductFormPublic/qm12webinar-programperspective', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='258767', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='80228', startTime='2025-05-09 07:21:43', sessionId=0x49FD191E8EFF1FCE, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='18.221.85.236'

0.018

2 calls
4 rows

0.009

SELECT * FROM Language ORDER BY orderindex, id

0.017

3 calls
4 rows

0.006

SELECT * FROM ShipType ORDER BY orderindex, id

0.016

1 call
1 row

0.016

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

0.013

1 call
13 rows

0.013

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

1 call
158 rows

0.013

SELECT * FROM webselect

0.011

1 call
1 row

0.011

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='qm12webinar-programperspective' ORDER BY Product.name

0.009

1 call
0 rows

0.009

COMMIT

0.009

1 call
0 rows

0.009

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

0.008

1 call
12 rows

0.008

SELECT * FROM Month ORDER BY orderindex, id

0.007

24 calls
1 row

0.000

SELECT version from databasemap;

0.005

1 call
0 rows

0.005

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

0.003

1 call
3 rows

0.003

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

0.003

1 call
3 rows

0.003

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

0.003

1 call
5 rows

0.003

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

0.003

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

0.003

1 call
0 rows

0.003

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

0.002

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 5331445152915333070

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(User.UserId) AS UserId, User.username, User.password, User.encoding, hex(User.VotingId) AS VotingId, User.lastSearchType, User.oneTimeKey, User.recoverPasswordKey, User.recoverPasswordTimeout, User.disableAllNotifications, User.otCodeTime, User.otCode, User.holyGrailSections FROM (User) WHERE User.UserId=0x164B8000000002

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

0.002

1 call
4 rows

0.002

SELECT * FROM Folks ORDER BY orderindex, id

0.002

2 calls
2 rows

0.001

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.002

1 call
1 row

0.002

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

0.002

1 call
1 row

0.002

SELECT * FROM uuid FOR UPDATE

0.002

1 call
0 rows

0.002

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

0.002

1 call
8 rows

0.002

SELECT * FROM ProductType ORDER BY orderindex, id

0.001

1 call
3 rows

0.001

SELECT * FROM PriceType ORDER BY orderindex, id

0.001

1 call
1 row

0.001

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

0.001

1 call
4 rows

0.001

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

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

0.001

1 call
0 rows

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 (Site, ProductFeaturedOn2Site, Product) WHERE (0x1CA240000001BF=Product.ProductId AND Product.ProductId=ProductFeaturedOn2Site.ProductId AND ProductFeaturedOn2Site.SiteId=Site.SiteId)

0.001

1 call
1 row

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

0.001

1 call
2 rows

0.001

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.001

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

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

0.001

1 call
2 rows

0.001

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1CA240000001C1=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(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=0x1CA240000001C3 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name

0.001

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

0.001

1 call
4 rows

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1CA240000001C2=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(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=0x1CA240000001C4 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.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=0x21122600000002 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

0.001

2 calls
1 row

0.000

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

0.001

1 call
0 rows

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

0.001

1 call
2 rows

0.001

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

0.000

2 calls
1 row

0.000

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

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 (SpecialOffer, ProductPrice, ProductPrice2SpecialOffer, Product) WHERE ((ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1CA240000001BF AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-05-09 07:21:43')

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1CA240000001C2=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1CA240000001C1=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.000

1 call
3 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=0x1BCA7C00000002 ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
3 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=0x1C50A50000000D ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
3 rows

0.000

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

0.000

1 call
0 rows

0.000

1 call
3 rows

0.000

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

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

1 call
3 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=0x1C1CEC00000048 ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
2 rows

0.000

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

0.000

1 call
2 rows

0.000

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

0.000

1 call
3 rows

0.000

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

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
3 rows

0.000

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

0.000

1 call
2 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1BCA7E0000000F=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(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1BF40100000004=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1C1CEC0000004A=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.000

1 call
2 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1C1CEC0000004A=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(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1C50A500000010=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(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1C50A50000000F=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1BF3EC0000014D=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1C207200000041=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(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x1C022D00000011=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(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1BCA7E0000000F=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1BCA7C00000037=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1C50A50000000E=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0x1C1CEC00000049=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.000

1 call
0 rows

0.000

START TRANSACTION

909776 function calls (899282 primitive calls) in 1.463 seconds Ordered by: cumulative time List reduced from 2691 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.464 1.464 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 1.046 1.046 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.977 0.977 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.977 0.977 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 0.964 0.964 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.489 0.489 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.489 0.489 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.419 0.419 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 150 0.001 0.000 0.400 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 150 0.001 0.000 0.398 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.397 0.397 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.386 0.386 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.386 0.386 /data/fact/current/libs/framework/WebSite.py:92(__init__) 7/1 0.000 0.000 0.364 0.364 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 17/1 0.000 0.000 0.364 0.364 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 150 0.001 0.000 0.330 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 150 0.329 0.002 0.329 0.002 {function Connection.query at 0xf27e51900ae0} 176 0.002 0.000 0.291 0.002 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 1 0.000 0.000 0.231 0.231 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 0.230 0.230 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 0.230 0.077 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 0.230 0.115 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.230 0.115 /usr/lib/python3.11/urllib/request.py:1307(do_open) 2 0.000 0.000 0.179 0.090 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 0.179 0.090 /usr/lib/python3.11/http/client.py:318(begin) 77 0.000 0.000 0.178 0.002 {method 'readline' of '_io.BufferedReader' objects} 14 0.000 0.000 0.178 0.013 /usr/lib/python3.11/socket.py:704(readinto) 2 0.000 0.000 0.178 0.089 /usr/lib/python3.11/http/client.py:285(_read_status) 2/1 0.000 0.000 0.171 0.171 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.171 0.171 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.171 0.171 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.170 0.170 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.166 0.166 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 131/113 0.000 0.000 0.165 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__) 1 0.011 0.011 0.162 0.162 /data/fact/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 19/10 0.001 0.000 0.161 0.016 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 358/175 0.005 0.000 0.155 0.001 {built-in method builtins.exec} 119 0.001 0.000 0.154 0.001 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 202/129 0.001 0.000 0.153 0.001 :1165(_find_and_load) 202/129 0.001 0.000 0.150 0.001 :1120(_find_and_load_unlocked) 1 0.004 0.004 0.145 0.145 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 220/147 0.001 0.000 0.144 0.001 :666(_load_unlocked) 70 0.001 0.000 0.144 0.002 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 9/5 0.000 0.000 0.143 0.029 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 221/150 0.001 0.000 0.139 0.001 :934(exec_module) 13 0.000 0.000 0.129 0.010 /usr/lib/python3.11/ssl.py:1299(recv_into) 13 0.000 0.000 0.129 0.010 /usr/lib/python3.11/ssl.py:1157(read) 13 0.129 0.010 0.129 0.010 {method 'read' of '_ssl._SSLSocket' objects} 451/273 0.000 0.000 0.125 0.000 :233(_call_with_frames_removed) 539 0.002 0.000 0.114 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 385 0.002 0.000 0.112 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 385 0.003 0.000 0.109 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 101 0.001 0.000 0.106 0.001 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 12 0.000 0.000 0.103 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.102 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.102 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 119 0.001 0.000 0.100 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 15523/15110 0.009 0.000 0.099 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 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) 105 0.001 0.000 0.097 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 597/379 0.001 0.000 0.092 0.000 /data/fact/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 60 0.000 0.000 0.091 0.002 /data/fact/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 15547/15115 0.009 0.000 0.089 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.088 0.088 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 47 0.001 0.000 0.087 0.002 /data/fact/current/libs/PLayer/PersistentBroker.py:336(processSql) 15 0.000 0.000 0.084 0.006 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 3 0.000 0.000 0.080 0.027 /data/fact/current/libs/framework/DGELongInput.py:14(massageDictForEditHTML) 1 0.000 0.000 0.075 0.075 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 13 0.000 0.000 0.074 0.006 /data/fact/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 13 0.000 0.000 0.074 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 2 0.001 0.000 0.074 0.037 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 13 0.000 0.000 0.074 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 3621/3597 0.004 0.000 0.073 0.000 /data/fact/current/libs/framework/LazyDict.py:186(__getitem__) 163 0.001 0.000 0.072 0.000 /usr/lib/python3.11/re/__init__.py:272(_compile) 159 0.000 0.000 0.072 0.000 /usr/lib/python3.11/re/__init__.py:225(compile) 8 0.005 0.001 0.072 0.009 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 2 0.000 0.000 0.072 0.036 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 9825/9310 0.005 0.000 0.072 0.000 {built-in method builtins.getattr} 13 0.000 0.000 0.071 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 19 0.000 0.000 0.071 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 485/385 0.001 0.000 0.070 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 19 0.001 0.000 0.070 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 48 0.000 0.000 0.070 0.001 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.070 0.070 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 1463/385 0.013 0.000 0.069 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 1 0.000 0.000 0.067 0.067 /data/fact/current/libs/framework/WebForm.py:2883(getViewDG) 1 0.000 0.000 0.067 0.067 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:75(_getDGByName) 1 0.000 0.000 0.067 0.067 /data/fact/current/libs/framework/WebSite.py:973(getDGByName) 2 0.000 0.000 0.067 0.034 /data/fact/current/libs/framework/LazyDict.py:172(get) 22/1 0.001 0.000 0.067 0.067 /data/fact/current/libs/framework/BaseHandler.py:470(_createDisplayGroup) 8 0.053 0.007 0.067 0.008 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 112/1 0.001 0.000 0.066 0.066 /data/fact/current/libs/framework/DisplayGroup.py:631(_createDGE) 6/1 0.000 0.000 0.066 0.066 /data/fact/current/libs/framework/DisplayGroup.py:835(_createDGEGroup) 150 0.001 0.000 0.060 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:144(_do_get_result) 1 0.000 0.000 0.060 0.060 /usr/lib/python3.11/urllib/request.py:1376(http_open) 150 0.000 0.000 0.058 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:351(_get_result) 150 0.058 0.000 0.058 0.000 {method 'store_result' of '_mysql.connection' objects} 2 0.000 0.000 0.057 0.028 /data/fact/current/libs/framework/WebSite.py:698(_logPageRequest)

QM Series 12 Webinar: Program's Perspective: Three Views

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org