Product: Time, Effort, and Resources for FACT Accreditation: 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

Time, Effort, and Resources for FACT Accreditation

Format:
Electronic (digital download/no shipping)

Accredited, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

Virtual roundtables serve as an online peer network session, enabling collaboration and idea sharing. This virtual roundtable consists of short presentations from three cellular therapy programs of varying services, sizes, and locations regarding the time, effort, and resources they utilized to achieve FACT accreditation. Following the presentations, participants are invited to share their own experiences and ask questions to the presenters or the FACT Program Relations Committee.

Product Details:

Product ID: 303

Publication Year: 2009

Related Products

QM Series 1 Webinar Bundle: Administrative Aspects of QM Accredited, Guest, NonMember - $230.00
Inspector, Inspector Trainee - $0.00

Establishing and Implementing a Quality Management Plan Accredited, Guest, NonMember - $100.00
Inspector, Inspector Trainee - $0.00

The Role of the QM Supervisor Accredited, Guest, NonMember - $100.00
Inspector, Inspector Trainee - $0.00

The SOP for SOPs Accredited, Guest, NonMember - $50.00
Inspector, Inspector Trainee - $0.00

Product ID:	303
Publication Year:	2009

Total Time

Count

Avg Time

Query

0.008

1 call
0 rows

0.008

INSERT INTO PageRequest SET mxxCreated='2025-05-09 14:38:07',mxxCreatedBy=NULL, PageRequestId=0x21141400000000, path='forms/store/ProductFormPublic/time-effort-and-resources-for-fact-accreditation', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='319404', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='104245', startTime='2025-05-09 14:38:07', sessionId=0x42CBAC19AC04F616, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='3.133.129.9'

0.006

1 call
0 rows

0.006

COMMIT

0.005

24 calls
1 row

0.000

SELECT version from databasemap;

0.003

2 calls
4 rows

0.001

SELECT * FROM Language ORDER BY orderindex, id

0.003

1 call
12 rows

0.003

SELECT * FROM Month ORDER BY orderindex, id

0.002

1 call
3 rows

0.002

SELECT * FROM PriceType ORDER BY orderindex, id

0.002

2 calls
2 rows

0.001

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.002

1 call
8 rows

0.002

SELECT * FROM ProductType ORDER BY orderindex, id

0.002

1 call
2 rows

0.002

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.002

3 calls
4 rows

0.001

SELECT * FROM ShipType ORDER BY orderindex, id

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product) WHERE Product.slug='time-effort-and-resources-for-fact-accreditation' ORDER BY Product.name

0.001

1 call
1 row

0.001

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

0.001

1 call
1 row

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

1 call
1 row

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

0.001

1 call
1 row

0.001

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

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

0.001

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 4813129853035673110

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

0.001

1 call
158 rows

0.001

SELECT * FROM webselect

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=0x1C0BED00000064 AND ProductRelation.ParentProductId=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=0xC7300000914

0.000

1 call
5 rows

0.000

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

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

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21141400000005 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

0.000

2 calls
1 row

0.000

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21141400000002 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

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

0.000

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

0.000

1 call
4 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 (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0xC7300000914 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 (0x9F8000000E5=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(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, MailingList, Product2MailingList) WHERE (0xC7300000914=Product.ProductId AND Product.ProductId=Product2MailingList.ProductId AND Product2MailingList.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.000

1 call
3 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0xC740000085E=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(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=0xC7A00000269 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 (0xC7300000144=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(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=0xC730000000D ORDER BY ProductPrice.description, ProductPrice.minQuantity

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

0.000

1 call
2 rows

0.000

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21141400000002 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name

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
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=0x32C0000005E 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 (0x9FB000000B0=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 (0xC7A00000277=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(Committee.CommitteeId) AS CommitteeId, Committee.description, Committee.startDate, Committee.endDate, Committee.status, Committee.deleted, Committee.type, Committee.category, Committee.name, Committee.reportsTo, Committee.lifespan, Committee.hidden, Committee.showParticipationOnIndividualView, Committee.showOnMemberParticipationreport, Committee.recordOrigin, Committee.isBoard, Committee.myCommitteeNotes, Committee.inceptionYear, Committee.notes FROM (MailingList, Committee) WHERE MailingList.CommitteeId=Committee.CommitteeId AND MailingList.MailingListId=0x21141400000015 ORDER BY Committee.name

0.000

1 call
1 row

0.000

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

0.000

1 call
2 rows

0.000

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

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0xCAE00000147=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(ProductRelation.ProductRelationId) AS ProductRelationId FROM (Product, ProductRelation) WHERE ProductRelation.ParentProductId=Product.ProductId AND Product.ProductId=0xC7300000914

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 (0xC7B00000820=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 (0xB3800000089=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 (0xCB9000000C9=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(Category.CategoryId) AS CategoryId, Category.description, hex(Category.ParentCategoryId) AS ParentCategoryId FROM (Product, Category2Product, Category) WHERE (0xC7300000914=Product.ProductId AND Product.ProductId=Category2Product.ProductId AND Category2Product.CategoryId=Category.CategoryId) ORDER BY Category.description

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0xC740000085E=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 (0xCB50000020B=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(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0xCA3000001AE=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(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0xCB900000124=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(FileProtectionType.FileProtectionTypeId) AS FileProtectionTypeId, FileProtectionType.name, FileProtectionType.description, FileProtectionType.path, FileProtectionType.prefix FROM (File, FileProtectionType) WHERE File.FileId=0xC6F00001364 AND File.fileProtectionTypeId=FileProtectionType.FileProtectionTypeId

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 (0xC7A00000277=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 (0x9FB000000B0=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 (0xCAE00000147=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 (0x9F8000000E5=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 (0xC7400000018=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0xB3800000089=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 (0xC7B0000000F=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 (0xC7300000144=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

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

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

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

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

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=0xC7300000914 AND Product.reportingTypeId=ReportingType.ReportingTypeId ORDER BY ReportingType.orderindex

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

909790 function calls (899362 primitive calls) in 1.396 seconds Ordered by: cumulative time List reduced from 2647 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.002 0.002 1.396 1.396 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 1.069 1.069 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 1.020 1.020 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.020 1.020 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 1.017 1.017 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.648 0.648 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.647 0.647 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.556 0.556 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.001 0.001 0.547 0.547 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.294 0.294 /usr/lib/python3.11/urllib/request.py:139(urlopen) 7/1 0.000 0.000 0.293 0.293 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 15/1 0.000 0.000 0.293 0.293 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 2/1 0.000 0.000 0.293 0.293 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 0.293 0.098 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 0.293 0.146 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.293 0.146 /usr/lib/python3.11/urllib/request.py:1307(do_open) 1 0.000 0.000 0.291 0.291 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.291 0.291 /data/fact/current/libs/framework/WebSite.py:92(__init__) 2/1 0.000 0.000 0.270 0.270 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.270 0.270 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.270 0.270 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.270 0.270 /usr/lib/python3.11/urllib/request.py:1390(https_open) 172 0.001 0.000 0.259 0.002 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 2 0.000 0.000 0.209 0.104 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 0.208 0.104 /usr/lib/python3.11/http/client.py:318(begin) 77 0.000 0.000 0.208 0.003 {method 'readline' of '_io.BufferedReader' objects} 14 0.000 0.000 0.208 0.015 /usr/lib/python3.11/socket.py:704(readinto) 2 0.000 0.000 0.208 0.104 /usr/lib/python3.11/http/client.py:285(_read_status) 13 0.000 0.000 0.190 0.015 /usr/lib/python3.11/ssl.py:1299(recv_into) 13 0.000 0.000 0.190 0.015 /usr/lib/python3.11/ssl.py:1157(read) 13 0.190 0.015 0.190 0.015 {method 'read' of '_ssl._SSLSocket' objects} 358/175 0.005 0.000 0.174 0.001 {built-in method builtins.exec} 12 0.000 0.000 0.173 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.172 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 202/129 0.002 0.000 0.172 0.001 :1165(_find_and_load) 12 0.000 0.000 0.172 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.170 0.170 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 12 0.000 0.000 0.169 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.169 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 202/129 0.001 0.000 0.169 0.001 :1120(_find_and_load_unlocked) 220/147 0.001 0.000 0.166 0.001 :666(_load_unlocked) 12 0.004 0.000 0.164 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 221/150 0.001 0.000 0.161 0.001 :934(exec_module) 117 0.001 0.000 0.159 0.001 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 451/273 0.000 0.000 0.147 0.001 :233(_call_with_frames_removed) 2 0.000 0.000 0.147 0.073 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 1 0.012 0.012 0.137 0.137 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 16513/16100 0.010 0.000 0.126 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 529 0.002 0.000 0.115 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 101 0.000 0.000 0.113 0.001 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 19/10 0.001 0.000 0.113 0.011 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 16537/16105 0.010 0.000 0.111 0.000 {built-in method builtins.__import__} 9/5 0.000 0.000 0.109 0.022 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 2 0.001 0.000 0.108 0.054 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 371 0.002 0.000 0.108 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 8 0.007 0.001 0.106 0.013 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 371 0.003 0.000 0.105 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 14 0.000 0.000 0.105 0.007 /data/fact/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 14 0.000 0.000 0.105 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 14 0.000 0.000 0.105 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 117 0.001 0.000 0.103 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 151 0.001 0.000 0.102 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 103 0.000 0.000 0.102 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 14 0.000 0.000 0.101 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 151 0.001 0.000 0.101 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 20 0.000 0.000 0.101 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 20 0.001 0.000 0.101 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 8 0.079 0.010 0.099 0.012 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 1 0.000 0.000 0.092 0.092 /data/fact/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 3 0.000 0.000 0.092 0.031 /data/fact/current/libs/framework/DGELongInput.py:14(massageDictForEditHTML) 1 0.000 0.000 0.091 0.091 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 151 0.000 0.000 0.086 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 151 0.085 0.001 0.085 0.001 {function Connection.query at 0xf55c3f59cae0} 171 0.001 0.000 0.080 0.000 /usr/lib/python3.11/re/__init__.py:272(_compile) 167 0.000 0.000 0.080 0.000 /usr/lib/python3.11/re/__init__.py:225(compile) 1 0.000 0.000 0.078 0.078 /data/fact/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 49 0.000 0.000 0.078 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 3043 0.005 0.000 0.075 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.074 0.074 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 469/371 0.001 0.000 0.067 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 2512 0.013 0.000 0.066 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1424/371 0.012 0.000 0.066 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 1 0.000 0.000 0.062 0.062 /usr/lib/python3.11/http/client.py:1426(__init__) 1 0.000 0.000 0.062 0.062 /usr/lib/python3.11/ssl.py:745(create_default_context) 1 0.000 0.000 0.058 0.058 /usr/lib/python3.11/ssl.py:591(load_default_certs) 1 0.058 0.058 0.058 0.058 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 3043 0.006 0.000 0.056 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 15 0.000 0.000 0.054 0.004 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 1 0.000 0.000 0.054 0.054 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.053 0.053 /data/fact/current/libs/framework/baseScrapeAndDrape.py:659(addMetaTags) 49 0.000 0.000 0.051 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 6868 0.047 0.000 0.050 0.000 /data/fact/current/libs/framework/LazyDict.py:71(__setitem__) 3043 0.002 0.000 0.048 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 1 0.000 0.000 0.044 0.044 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 730/679 0.001 0.000 0.043 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 132/114 0.000 0.000 0.043 0.000 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__) 1 0.000 0.000 0.042 0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 71 0.001 0.000 0.040 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 3533/3509 0.004 0.000 0.040 0.000 /data/fact/current/libs/framework/LazyDict.py:186(__getitem__) 1 0.011 0.011 0.040 0.040 /data/fact/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps)

Time, Effort, and Resources for FACT Accreditation

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org