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

U.S. Regulation of Cell and Gene Therapy Products

Format:
Digital

Accredited Organization, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

This webinar was live on Wednesday, October 25, 2017, at 11:00 am ET. With the increase in clinical trials and licensure for immune effector cells at FACT-accredited programs, Dr. Scott Burger of Advanced Cell & Gene Therapy, LLC, provides a review of FDA regulations that can help collection and processing facilities and clinical units understand the regulatory approval process and how they impact the success of these new therapies.

Product Details:

Product ID:	424
Pages, Size, or Length:	75 minutes

Total Time

Count

Avg Time

Query

0.004

1 call
0 rows

0.004

INSERT INTO PageRequest SET mxxCreated='2025-07-01 09:12:20',mxxCreatedBy=NULL, PageRequestId=0x21E2E90000001C, path='forms/store/ProductFormPublic/u-s-regulation-of-cell-and-gene-therapy-products', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='2810790', requestNum='2', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='421022', startTime='2025-07-01 09:12:20', sessionId=0x20689367621421DC, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.125'

0.004

1 call
0 rows

0.004

UPDATE PageRequest SET mxxUpdated='2025-07-01 09:11:48',mxxUpdatedBy=NULL, PageRequestId=0x21E2E900000000, path='forms/store/ProductFormPublic/inspection-exit-interview', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='2810790', requestNum='1', growth='15292', server='www.fact.maxx.matrixdev.net', dbThreadId='421022', startTime='2025-07-01 09:11:46', sessionId=0x34AA8055CBCC5114, userId=0x0, userName='public', result='0', sqltime='0.03782081604003906', timeTaken='53', dictSize='670', fields='{}', clientIPAddr='216.73.216.125' WHERE PageRequestId=0x21E2E900000000

0.002

1 call
1 row

0.002

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='u-s-regulation-of-cell-and-gene-therapy-products' ORDER BY Product.name

0.002

1 call
1 row

0.002

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

0.002

6 calls
1 row

0.000

SELECT version from databasemap;

0.001

1 call
0 rows

0.001

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

0.001

1 call
5 rows

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 2335278479028003292

0.001

1 call
0 rows

0.001

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

0.001

1 call
4 rows

0.001

SELECT * FROM Language ORDER BY orderindex, id

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 (0x10CE7900000005=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(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=0x10CE4E000007F8

0.001

1 call
2 rows

0.001

SELECT DISTINCT hex(ProductPrice.ProductPriceId) AS ProductPriceId, ProductPrice.amount, ProductPrice.minQuantity, ProductPrice.maxQuantity, ProductPrice.shipType, ProductPrice.priceType, ProductPrice.description, ProductPrice.accountingCode, ProductPrice.membershipTypesLabelForWWW FROM (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x10CE4E000007F8 ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.001

1 call
0 rows

0.001

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

0.001

1 call
13 rows

0.001

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

1 call
3 rows

0.001

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

0.001

1 call
0 rows

0.001

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

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 (0x10CE4E00000821=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(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=0x78498000000F5

0.001

1 call
1 row

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

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

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 (Product) WHERE ProductId=(select PreviousProductId from Product where ProductId = 0x10CE4E000007F8) ORDER BY Product.name

0.000

2 calls
1 row

0.000

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

0.000

2 calls
1 row

0.000

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

0.000

1 call
2 rows

0.000

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

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

0.000

1 call
4 rows

0.000

1 call
1 row

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=0x21E2E90000001E 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=0x21E2E900000022 AND ProductRelation.ChildProductId=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=0x21E2E900000022 AND ProductRelation.ParentProductId=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
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, Product, ProductPrice) WHERE ((ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x10CE4E000007F8 AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-07-01 09:12:20')

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

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

568050 function calls (564157 primitive calls) in 0.664 seconds Ordered by: cumulative time List reduced from 1639 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.664 0.664 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.651 0.651 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.637 0.637 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.637 0.637 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 0.635 0.635 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.503 0.503 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.502 0.502 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.438 0.438 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.431 0.431 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.211 0.211 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 0.211 0.211 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 0.211 0.070 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 0.211 0.105 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.211 0.105 /usr/lib/python3.11/urllib/request.py:1307(do_open) 2/1 0.000 0.000 0.180 0.180 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.180 0.180 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.180 0.180 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.180 0.180 /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:1351(getresponse) 2 0.000 0.000 0.170 0.085 /usr/lib/python3.11/http/client.py:318(begin) 14 0.000 0.000 0.170 0.012 /usr/lib/python3.11/socket.py:704(readinto) 2 0.000 0.000 0.170 0.085 /usr/lib/python3.11/http/client.py:285(_read_status) 28 0.000 0.000 0.170 0.006 {method 'readline' of '_io.BufferedReader' objects} 13 0.000 0.000 0.141 0.011 /usr/lib/python3.11/ssl.py:1299(recv_into) 13 0.000 0.000 0.141 0.011 /usr/lib/python3.11/ssl.py:1157(read) 13 0.141 0.011 0.141 0.011 {method 'read' of '_ssl._SSLSocket' objects} 12 0.000 0.000 0.141 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.141 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.140 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.139 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.139 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.007 0.001 0.137 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.132 0.132 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 7/1 0.000 0.000 0.117 0.117 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 11/1 0.000 0.000 0.117 0.117 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 2 0.000 0.000 0.113 0.056 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 130 0.001 0.000 0.087 0.001 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 13 0.000 0.000 0.085 0.007 /data/fact/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 13 0.000 0.000 0.085 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 1 0.000 0.000 0.085 0.085 /data/fact/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 13 0.000 0.000 0.085 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 13 0.000 0.000 0.084 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 19 0.000 0.000 0.084 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 19 0.001 0.000 0.083 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 17/10 0.000 0.000 0.066 0.007 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 1 0.000 0.000 0.064 0.064 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 274 0.001 0.000 0.061 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 2819 0.004 0.000 0.061 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 274 0.002 0.000 0.060 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 8/5 0.000 0.000 0.059 0.012 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 2512 0.011 0.000 0.052 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 362/274 0.000 0.000 0.051 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 1073/274 0.010 0.000 0.050 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 60 0.001 0.000 0.048 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 1 0.000 0.000 0.047 0.047 /data/fact/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 60 0.000 0.000 0.047 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 2819 0.006 0.000 0.046 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 60 0.000 0.000 0.045 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 60 0.045 0.001 0.045 0.001 {function Connection.query at 0xe9c1abf520c0} 730/679 0.002 0.000 0.041 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 84 0.000 0.000 0.039 0.000 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 2819 0.003 0.000 0.038 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 39 0.000 0.000 0.034 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 654 0.002 0.000 0.031 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 1 0.000 0.000 0.030 0.030 /usr/lib/python3.11/urllib/request.py:1376(http_open) 1 0.000 0.000 0.029 0.029 /data/fact/current/libs/framework/baseScrapeAndDrape.py:659(addMetaTags) 1 0.000 0.000 0.029 0.029 /usr/lib/python3.11/http/client.py:1426(__init__) 1 0.000 0.000 0.029 0.029 /usr/lib/python3.11/ssl.py:745(create_default_context) 1 0.000 0.000 0.029 0.029 /usr/lib/python3.11/ssl.py:591(load_default_certs) 1 0.029 0.029 0.029 0.029 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 1 0.028 0.028 0.028 0.028 {method 'recv_into' of '_socket.socket' objects} 18 0.000 0.000 0.027 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 18 0.004 0.000 0.027 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 379/298 0.001 0.000 0.027 0.000 /data/fact/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 29 0.000 0.000 0.026 0.001 /data/fact/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 4 0.000 0.000 0.025 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 895/4 0.007 0.000 0.025 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 895/4 0.004 0.000 0.025 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 2819 0.004 0.000 0.024 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 876 0.001 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 14501 0.010 0.000 0.022 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 4774/4464 0.001 0.000 0.021 0.000 {built-in method builtins.getattr} 2832 0.004 0.000 0.021 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants) 876 0.003 0.000 0.020 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 6260 0.007 0.000 0.020 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 9575 0.007 0.000 0.020 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag) 8 0.000 0.000 0.019 0.002 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 1 0.000 0.000 0.019 0.019 /data/fact/current/libs/framework/baseScrapeAndDrape.py:650(prepMetaTags) 5807 0.013 0.000 0.018 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 640 0.001 0.000 0.018 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre) 18541 0.017 0.000 0.017 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 1119 0.003 0.000 0.017 0.000 /data/fact/current/libs/framework/MaxxDTML.py:29(render) 1587 0.006 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 2476 0.002 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 666 0.003 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 222 0.001 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP) 15 0.000 0.000 0.015 0.001 /data/fact/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc) 88077/87729 0.014 0.000 0.015 0.000 {built-in method builtins.isinstance} 15 0.000 0.000 0.015 0.001 /data/fact/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL) 2 0.000 0.000 0.014 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__)

U.S. Regulation of Cell and Gene Therapy Products

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org