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

QM Series 12 Webinar: Written Agreements

Format:
Digital

Accredited Organization, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

Tuesday, November 14, 2023 - Quality Management Series 12 webinar: Written Agreements. 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. Jay Tanna is the Quality Assurance Lead for the Children's National Health System Blood and Marrow Transplant Program. After this webinar, attendees should be able to: • Describe what a written agreement is and the purpose it serves • Identify when a written agreement is necessary based on FACT Standards • Compare and contrast quality agreements vs. financial/operational agreements • Determine what key elements should be included within written agreements

Product Details:

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

Total Time

Count

Avg Time

Query

0.006

1 call
0 rows

0.006

INSERT INTO PageRequest SET mxxCreated='2025-07-01 07:29:01',mxxCreatedBy=NULL, PageRequestId=0x21E2CE00000000, path='forms/store/ProductFormPublic/qm12webinar-writtenagreements', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='2803312', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='418410', startTime='2025-07-01 07:29:01', sessionId=0x7B50DAA2684C29FB, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.125'

0.006

1 call
0 rows

0.006

COMMIT

0.003

24 calls
1 row

0.000

SELECT version from databasemap;

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

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 (Product, File) WHERE Product.downloadFileId=File.FileId AND Product.ProductId=0x1C50A50000000D

0.001

1 call
3 rows

0.001

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1CA240000001C0=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(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.emergencyContact, Individual.signedForms, Individual.affiliatedWithBank, Individual.affiliatedWithOrg, Individual.affiliatedWithOrgName, Individual.affiliatedWithBankName, Individual.inspectionAgencyNumber, Individual.otherProfessionalSocieties, Individual.membershipNumberASBMT, Individual.membershipNumberISCT, Individual.readConfidentialityPolicy, Individual.conflictOfInterests, Individual.medicalLicenseExpiration, Individual.professionalLiabilityUploaded, Individual.professionalHistoryRestrictions, Individual.professionalLiabilityCase, Individual.professionalLiabilityReasonToDeny, Individual.appropriateAffiliation, Individual.affiliationComments, Individual.cellularTherapyWorkshopDate, Individual.cordBloodWorkshopDate, Individual.cellularTherapyTestDate, Individual.cordBloodTestDate, Individual.professionalInspectionWebinarDate, Individual.trainingInspectionWebinarDate, Individual.trainingInspectionDate, Individual.satisfactoryEvaluationReport, Individual.satisfactoryInspectionReport, Individual.isInspectorPending, Individual.accreditationEndDate, Individual.accreditationStartDate, Individual.congresspersonFor, Individual.factWebAssessmentDate, Individual.factWebEventDate, Individual.congressParty, Individual.mailChimpMergeCache, Individual.otherMemberships, Individual.dateCVReceived, Individual.iieCTTestDate, Individual.anniversaryVideoDate, Individual.iecTutorialDate, Individual.accredPortalTrainingDate, Individual.annualComplianceReceived, Individual.medicalLicenseExpDate, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, User) WHERE Individual.userId=User.UserId AND User.UserId=0x164B8000000002 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

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

0.001

2 calls
4 rows

0.000

SELECT * FROM Language ORDER BY orderindex, id

0.001

1 call
158 rows

0.001

SELECT * FROM webselect

0.000

1 call
13 rows

0.000

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

1 call
5 rows

0.000

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

0.000

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 8885842455871367675

0.000

1 call
3 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1C50A50000000E=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 (Product) WHERE ProductId=(select PreviousProductId from Product where ProductId = 0x1C50A50000000D) ORDER BY Product.name

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 (Product, Product2MailingList, MailingList) WHERE (0x1C50A50000000D=Product.ProductId AND Product.ProductId=Product2MailingList.ProductId AND Product2MailingList.MailingListId=MailingList.MailingListId) ORDER BY MailingList.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 (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1BF3E400000256 ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
0 rows

0.000

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

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

0.000

2 calls
5 rows

0.000

SELECT * FROM ShipType ORDER BY orderindex, id

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

0.000

1 call
1 row

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

0.000

1 call
1 row

0.000

1 call
0 rows

0.000

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

0.000

1 call
1 row

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

0.000

2 calls
1 row

0.000

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

0.000

1 call
1 row

0.000

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

0.000

1 call
3 rows

0.000

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

0.000

2 calls
2 rows

0.000

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1C50A500000010=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 (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1C50A50000000F=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.000

1 call
1 row

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

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 (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1C50A50000000D ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
4 rows

0.000

1 call
1 row

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

0.000

1 call
1 row

0.000

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

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

0.000

2 calls
1 row

0.000

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

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

0.000

1 call
3 rows

0.000

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

0.000

1 call
8 rows

0.000

SELECT * FROM ProductType ORDER BY orderindex, id

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 (Product, ProductPrice) 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(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1BCA7C00000037=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
0 rows

0.000

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice2SpecialOffer, Product, ProductPrice, SpecialOffer) WHERE ((ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1C50A50000000D AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-07-01 07:29:01')

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 (Product, ProductRelation) WHERE ProductRelation.ProductRelationId=0x21E2CE00000006 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 (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1CA240000001C1=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.000

1 call
4 rows

0.000

SELECT * FROM Folks ORDER BY orderindex, id

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 (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1CA240000001BF ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ReportingType.ReportingTypeId) AS ReportingTypeId, ReportingType.description, ReportingType.orderindex FROM (Product, ReportingType) WHERE Product.ProductId=0x1C50A50000000D AND Product.reportingTypeId=ReportingType.ReportingTypeId ORDER BY ReportingType.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 (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1C1CEC00000049=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 * FROM PriceType ORDER BY orderindex, id

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

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 (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1C1CEC00000048 ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1CA240000001C2=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

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

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
12 rows

0.000

SELECT * FROM Month ORDER BY orderindex, id

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
2 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1BF40100000004=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
2 rows

0.000

SELECT * FROM ProductStatus ORDER BY orderindex, id

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) WHERE (0x1CA240000001C0=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 (SpecialOffer, ProductPrice2SpecialOffer, ProductPrice) WHERE (0x1CA240000001C1=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 (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1C1CEC0000004A=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 (MembershipType, MembershipType2ProductPrice, ProductPrice) 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 (SpecialOffer, ProductPrice2SpecialOffer, ProductPrice) WHERE (0x1C50A500000010=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 (MembershipType, MembershipType2ProductPrice, ProductPrice) WHERE (0x1C207200000041=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

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

0.000

1 call
0 rows

0.000

START TRANSACTION

908782 function calls (898256 primitive calls) in 1.199 seconds Ordered by: cumulative time List reduced from 2684 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.200 1.200 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.943 0.943 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.914 0.914 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.914 0.914 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 0.911 0.911 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.596 0.596 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.596 0.596 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.530 0.530 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.522 0.522 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.361 0.361 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 0.360 0.360 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 0.360 0.120 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 0.360 0.180 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.360 0.180 /usr/lib/python3.11/urllib/request.py:1307(do_open) 7/1 0.000 0.000 0.270 0.270 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 17/1 0.000 0.000 0.270 0.270 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 1 0.000 0.000 0.238 0.238 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.238 0.238 /data/fact/current/libs/framework/WebSite.py:92(__init__) 177 0.001 0.000 0.236 0.001 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 1 0.000 0.000 0.182 0.182 /usr/lib/python3.11/urllib/request.py:1376(http_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.178 0.178 /usr/lib/python3.11/urllib/request.py:1390(https_open) 2 0.000 0.000 0.170 0.085 /usr/lib/python3.11/http/client.py:1300(request) 2 0.000 0.000 0.170 0.085 /usr/lib/python3.11/http/client.py:1305(_send_request) 2 0.000 0.000 0.169 0.085 /usr/lib/python3.11/http/client.py:1287(endheaders) 2 0.000 0.000 0.169 0.085 /usr/lib/python3.11/http/client.py:1049(_send_output) 2 0.000 0.000 0.169 0.085 /usr/lib/python3.11/http/client.py:988(send) 2 0.000 0.000 0.161 0.080 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 0.160 0.080 /usr/lib/python3.11/http/client.py:318(begin) 79 0.000 0.000 0.160 0.002 {method 'readline' of '_io.BufferedReader' objects} 14 0.000 0.000 0.160 0.011 /usr/lib/python3.11/socket.py:704(readinto) 2 0.000 0.000 0.160 0.080 /usr/lib/python3.11/http/client.py:285(_read_status) 2 0.000 0.000 0.159 0.080 /usr/lib/python3.11/http/client.py:959(connect) 2 0.000 0.000 0.159 0.080 /usr/lib/python3.11/socket.py:821(create_connection) 2 0.000 0.000 0.158 0.079 /usr/lib/python3.11/socket.py:957(getaddrinfo) 2 0.157 0.079 0.157 0.079 {built-in method _socket.getaddrinfo} 359/176 0.004 0.000 0.146 0.001 {built-in method builtins.exec} 202/129 0.001 0.000 0.145 0.001 :1165(_find_and_load) 202/129 0.001 0.000 0.143 0.001 :1120(_find_and_load_unlocked) 221/148 0.001 0.000 0.137 0.001 :666(_load_unlocked) 119 0.001 0.000 0.137 0.001 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 13 0.000 0.000 0.137 0.011 /usr/lib/python3.11/ssl.py:1299(recv_into) 13 0.000 0.000 0.137 0.011 /usr/lib/python3.11/ssl.py:1157(read) 13 0.137 0.011 0.137 0.011 {method 'read' of '_ssl._SSLSocket' objects} 222/151 0.000 0.000 0.132 0.001 :934(exec_module) 1 0.004 0.004 0.124 0.124 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 452/274 0.000 0.000 0.121 0.000 :233(_call_with_frames_removed) 19/10 0.001 0.000 0.111 0.011 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 9/5 0.000 0.000 0.107 0.021 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 387 0.002 0.000 0.106 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 387 0.003 0.000 0.104 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 12 0.000 0.000 0.100 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.099 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.099 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 541 0.002 0.000 0.098 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 12 0.000 0.000 0.097 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.097 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.004 0.000 0.096 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 101 0.000 0.000 0.096 0.001 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 15541/15128 0.009 0.000 0.091 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 119 0.001 0.000 0.088 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 105 0.001 0.000 0.087 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 1 0.000 0.000 0.086 0.086 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 15565/15133 0.008 0.000 0.080 0.000 {built-in method builtins.__import__} 3 0.000 0.000 0.076 0.025 /data/fact/current/libs/framework/DGELongInput.py:14(massageDictForEditHTML) 163 0.001 0.000 0.075 0.000 /usr/lib/python3.11/re/__init__.py:272(_compile) 1 0.000 0.000 0.075 0.075 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 159 0.000 0.000 0.075 0.000 /usr/lib/python3.11/re/__init__.py:225(compile) 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) 48 0.000 0.000 0.074 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 13 0.000 0.000 0.074 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 2 0.001 0.000 0.073 0.036 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 8 0.004 0.001 0.072 0.009 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 150 0.001 0.000 0.071 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 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) 2 0.000 0.000 0.071 0.035 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 19 0.001 0.000 0.070 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 150 0.001 0.000 0.070 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 493/387 0.001 0.000 0.069 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 1477/387 0.013 0.000 0.068 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 8 0.054 0.007 0.067 0.008 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 1 0.000 0.000 0.066 0.066 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 150 0.000 0.000 0.056 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 150 0.056 0.000 0.056 0.000 {function Connection.query at 0xee8688db60c0} 16 0.000 0.000 0.053 0.003 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 48 0.000 0.000 0.053 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 2819 0.003 0.000 0.051 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.044 0.044 /data/fact/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 6922 0.041 0.000 0.044 0.000 /data/fact/current/libs/framework/LazyDict.py:71(__setitem__) 113 0.042 0.000 0.043 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.042 0.042 /data/fact/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 1 0.000 0.000 0.040 0.040 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 2512 0.007 0.000 0.039 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.039 0.039 /data/fact/current/libs/framework/DGEEmail.py:1() 1 0.000 0.000 0.039 0.039 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 132/114 0.000 0.000 0.038 0.000 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__)

QM Series 12 Webinar: Written Agreements

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org

Description:

Product Details:

Related Products

Services

About

Help and Advice

Phone

Address

fact@factglobal.org