Product Details 

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

FACT IEC Quality Webinar: Tumor Infiltrating Lymphocytes

Format:
Electronic (digital download/no shipping)

Accredited Organization, Guest, NonMember - $100.00

Industry - $500.00

Inspector, Inspector Trainee - $0.00

Description:

Tumor-infiltrating lymphocytes (TILs) can recognize and kill cancer cells. This webinar provides a broad introduction to TILs and a review of current clinical experience and unique considerations in TIL manufacturing. Presenters discuss the need for establishing safety and efficacy quality benchmarks for TILs. Presenters: • Parameswaran Hari, MD, MRCP, DRCPath, MS, from Iovance Biotherapeutics • John Mullinax, MD, from H. Lee Moffitt Cancer Center & Research Institute Blood and Marrow

Product Details:

Product ID: 123578
Publication Year: 2023
Pages, Size, or Length: 67 minutes
Debugging Info
pagedictsize=683
sqltime = 0.036 s
cpu time = 0.530 s
real time = 0.716 s
memory increase = 15340 kB
fields =
templates =
/data/fact/current/fact_org/themes/www/store_footer
/data/fact/current/fact_org/themes/www/store_header
/data/fact/current/generic/themes/shared/dgelements/button
/data/fact/current/generic/themes/shared/dgelements/checkbox
/data/fact/current/generic/themes/shared/dgelements/checkboxyesno
/data/fact/current/generic/themes/shared/dgelements/date
/data/fact/current/generic/themes/shared/dgelements/datetime
/data/fact/current/generic/themes/shared/dgelements/fileView
/data/fact/current/generic/themes/shared/dgelements/find
/data/fact/current/generic/themes/shared/dgelements/input
/data/fact/current/generic/themes/shared/dgelements/money
/data/fact/current/generic/themes/shared/dgelements/moneyView
/data/fact/current/generic/themes/shared/dgelements/objectSelect
/data/fact/current/generic/themes/shared/dgelements/radio
/data/fact/current/generic/themes/shared/dgelements/radioLinear
/data/fact/current/generic/themes/shared/dgelements/select
/data/fact/current/generic/themes/shared/dgelements/submitButton
/data/fact/current/generic/themes/shared/dgelements/text
/data/fact/current/generic/themes/shared/dgelements/view
/data/fact/current/generic/themes/shared/mako/dgelements/file.html
/data/fact/current/generic/themes/www/mako/store/viewProduct.html
scrapeAndDrape FRESH stub: http://test.factglobal.org/product-details
dg = ['viewProduct'] | [80040]
extra debug info =
queries = 88 queries

Total TimeCountAvg TimeQuery
0.0071 call
0 rows
0.007 INSERT INTO PageRequest SET mxxCreated='2025-05-09 14:42:22',mxxCreatedBy=NULL, PageRequestId=0x21141C00000000, path='forms/store/ProductFormPublic/FACT-IEC_Tumor_Infiltrating_Lymphocytes', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='319521', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='104277', startTime='2025-05-09 14:42:22', sessionId=0x7D4AFEF284A369F4, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='18.191.86.218'
0.0051 call
0 rows
0.005 COMMIT
0.00524 calls
1 row
0.000 SELECT version from databasemap;
0.0011 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='FACT-IEC_Tumor_Infiltrating_Lymphocytes' ORDER BY Product.name
0.0013 calls
4 rows
0.000 SELECT * FROM ShipType ORDER BY orderindex, id
0.0011 call
2 rows
0.001 SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0x1B768C00000025=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name
0.0011 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.0012 calls
4 rows
0.000 SELECT * FROM Language ORDER BY orderindex, id
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0x1B768C00000023=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0x1B768C00000024=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name
0.0001 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=0x1B768C00000022 ORDER BY ProductPrice.description, ProductPrice.minQuantity
0.0002 calls
1 row
0.000 select max(returnOrder) from Stack where sessionId = 9028308720578423284
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(ProductRelation.ProductRelationId) AS ProductRelationId FROM (Product, ProductRelation) WHERE ProductRelation.ChildProductId=Product.ProductId AND Product.ProductId=0x1B768C00000022
0.0001 call
5 rows
0.000 SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (Product, MembershipType, MembershipType2Product) WHERE (0x1B768C00000022=Product.ProductId AND Product.ProductId=MembershipType2Product.ProductId AND MembershipType2Product.id=MembershipType.id) ORDER BY MembershipType.orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product, ProductRelation) WHERE ProductRelation.ProductRelationId=0x21141C00000002 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name
0.0001 call
158 rows
0.000 SELECT * FROM webselect
0.0002 calls
2 rows
0.000 SELECT * FROM ProductActivationStatus ORDER BY orderindex, id
0.0001 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.0001 call
4 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=0xA ORDER BY WebTab.WebTabId
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product, ProductRelation) WHERE ProductRelation.ProductRelationId=0x21141C00000005 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product) WHERE Product.ProductId=0x1B768C00000022 ORDER BY Product.name
0.0002 calls
1 row
0.000 select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0x1B768C00000022
0.0002 calls
1 row
0.000 select mxxCreated, mxxUpdated from Product where ProductId=0x1B768C00000022;
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product, ProductRelation) WHERE ProductRelation.ProductRelationId=0x21141C00000005 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(ReportingType.ReportingTypeId) AS ReportingTypeId, ReportingType.description, ReportingType.orderindex FROM (Product, ReportingType) WHERE Product.ProductId=0x1B768C00000022 AND Product.reportingTypeId=ReportingType.ReportingTypeId ORDER BY ReportingType.orderindex
0.0001 call
3 rows
0.000 SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0x1B768C00000023=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (Product, Product2MailingList, MailingList) WHERE (0x1B768C00000022=Product.ProductId AND Product.ProductId=Product2MailingList.ProductId AND Product2MailingList.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name
0.0002 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.0001 call
3 rows
0.000 SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0x1B768C00000024=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product, ProductRelation) WHERE ProductRelation.ProductRelationId=0x21141C00000002 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType, MembershipType2ProductPrice) WHERE (0x1B768C00000025=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex
0.0001 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=0x21141C00000015 ORDER BY Committee.name
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(ProductRelation.ProductRelationId) AS ProductRelationId FROM (Product, ProductRelation) WHERE ProductRelation.ParentProductId=Product.ProductId AND Product.ProductId=0x1B768C00000022
0.0001 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=0x1B768C00000022
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (Product, SpecialOffer, ProductPrice, ProductPrice2SpecialOffer) WHERE ((ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x1B768C00000022 AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-05-09 14:42:22')
0.0001 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=0x21141C0000000E ORDER BY Committee.name
0.0001 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=0x21141C00000012 ORDER BY Committee.name
0.0001 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=0x1FB500000014 ORDER BY Committee.name
0.0001 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=0xC97000000C6 ORDER BY Committee.name
0.0001 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=0x21141C00000010 ORDER BY Committee.name
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, ProductPrice2SpecialOffer, SpecialOffer) WHERE (0x1B768C00000023=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)
0.0001 call
1 row
0.000 SELECT DISTINCT hex(FileProtectionType.FileProtectionTypeId) AS FileProtectionTypeId, FileProtectionType.name, FileProtectionType.description, FileProtectionType.path, FileProtectionType.prefix FROM (FileProtectionType, File) WHERE File.FileId=0x1B769500000149 AND File.fileProtectionTypeId=FileProtectionType.FileProtectionTypeId
0.0001 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 (0x1B768C00000022=Product.ProductId AND Product.ProductId=Product2Site.ProductId AND Product2Site.SiteId=Site.SiteId)
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Category.CategoryId) AS CategoryId, Category.description, hex(Category.ParentCategoryId) AS ParentCategoryId FROM (Product, Category2Product, Category) WHERE (0x1B768C00000022=Product.ProductId AND Product.ProductId=Category2Product.ProductId AND Category2Product.CategoryId=Category.CategoryId) ORDER BY Category.description
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, ProductPrice2SpecialOffer, SpecialOffer) WHERE (0x1B768C00000024=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)
0.0001 call
8 rows
0.000 SELECT * FROM ProductType ORDER BY orderindex, id
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (Product, SpecialOffer) WHERE SpecialOffer.ProductId=Product.ProductId AND Product.ProductId=0x1B768C00000022
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice, ProductPrice2SpecialOffer, SpecialOffer) WHERE (0x1B768C00000025=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)
0.0001 call
1 row
0.000 SELECT DISTINCT hex(User.UserId) AS UserId, User.username, User.password, User.encoding, hex(User.VotingId) AS VotingId, User.lastSearchType, User.oneTimeKey, User.recoverPasswordKey, User.recoverPasswordTimeout, User.disableAllNotifications, User.otCodeTime, User.otCode, User.holyGrailSections FROM (User) WHERE User.UserId=0x164B8000000002
0.0001 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, ProductFeaturedOn2Site, Site) WHERE (0x1B768C00000022=Product.ProductId AND Product.ProductId=ProductFeaturedOn2Site.ProductId AND ProductFeaturedOn2Site.SiteId=Site.SiteId)
0.0001 call
12 rows
0.000 SELECT * FROM Month ORDER BY orderindex, id
0.0001 call
2 rows
0.000 SELECT * FROM YesNo ORDER BY orderindex, id
0.0001 call
4 rows
0.000 SELECT * FROM Folks ORDER BY orderindex, id
0.0001 call
3 rows
0.000 SELECT * FROM PriceType ORDER BY orderindex, id
0.0001 call
2 rows
0.000 SELECT * FROM ProductStatus ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows
0.000 START TRANSACTION