Company: Pasadena City College: ACSA

Pasadena City College
Visual Arts and Media Studies Division

1570 E. Colorado Blvd.
Pasadena, CA 91106
United States

Main Phone: 626-585-7689
Website: https://pasadena.edu/academics/divisions/visual-arts-and-media-studies/areas-of-study/architecture.php https://pasadena.edu/academics/degrees-and-certificates/aa-degrees/architecture.php
E-mail: test@maxx.matrixgroup.net

2-Year Programs
FTE Faculty: 2.25
Pre-professional programs: Architectue - Associate in Arts Degree

Gregory Zamora, Full-Time Faculty Coordinator in Architecture

Faculty/Staff Roster

ACSA Members: Click here to view detailed Faculty/Staff information (Members Only Content)

Last Updated: 03/27/2024

Total Time

Count

Avg Time

Query

0.006

1 call
0 rows

0.006

INSERT INTO PageRequest SET mxxCreated='2025-07-05 02:29:07',mxxCreatedBy=NULL, PageRequestId=0x13AC8100000000, path='forms/CompanyFormPublic/view', formName='acsa_CompanyFormPublic', site='www', clientAcronym='ACSA', pid='3429470', requestNum='1', pageDictSize=NULL, objectId='19B0000093D', templateMethod=NULL, growth=NULL, server='www.acsa.maxx.matrixdev.net', dbThreadId='145002', startTime='2025-07-05 02:29:07', sessionId=0x761DF09E156452D8, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{\\'id\\':\\'19B0000093D\\'}', clientIPAddr='216.73.216.138'

0.006

1 call
0 rows

0.006

COMMIT

0.006

7 calls
1 row

0.001

SELECT DISTINCT hex(Company.CompanyId) AS CompanyId, Company.name, Company.companyTypeId, Company.description, Company.logo, Company.enteredBy, Company.lastUpdatedBy, Company.taxId, Company.staffing, Company.mainPhone, Company.email, Company.article, Company.revenue, Company.paidDues, Company.lastUpdated, Company.isComplementary, Company.name2, Company.aliases, hex(Company.companyStatusId) AS companyStatusId, Company.isPubliclyTraded, Company.annualSales, Company.brands, Company.hasSubsidiaries, Company.otherProductCategory, Company.prospectStatus, Company.alphaSort, Company.yearEstablished, Company.companyNum, Company.ticker, Company.matchString, Company.recordOrigin, Company.minorityOwned, Company.womanOwned, Company.companyStruct, Company.howHeardAboutOther, Company.silent, Company.additionalRosterSlots, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.department, Company.region, Company.numFullTimeEmployees, Company.extraPublications, Company.customerType, Company.numFullTimeFaculty, Company.numFullTimeStudents, Company.numPartTimeFaculty, Company.numPartTimeStudents, Company.percentFemaleStudents, Company.percentMinorityStudents, Company.percentInternationalStudents, Company.percentOutOfStateStudents, Company.tuition, Company.tuitionResident, Company.tuitionNonresident, Company.tuitionUndergraduate, Company.tuitionResidentUndergraduate, Company.tuitionNonresidentUndergraduate, Company.tuitionGraduate, Company.tuitionResidentGraduate, Company.tuitionNonresidentGraduate, Company.fundingSource, Company.percentFederalAid, Company.percentUniversityAid, Company.percentDepartmentAid, Company.percentScholarship, Company.feesForArchitectureStudents, Company.averageAnnualScholarship, Company.guideSummary, Company.guideUniversitySetting, Company.guideSchoolPhilosophy, Company.guideProgramDescription, Company.guideAreasOfFocus, Company.guideSpecialActivities, Company.guideFacilities, Company.guideScholarshipsFinAid, Company.numFilledSlots, Company.preProfessionalOffered, Company.postProfessionalOffered, Company.postProfessionalPrograms, Company.studyAbroadOffered, Company.communityDesignOffered, Company.specialProgramsOffered, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.congressRep, Company.congressionalDistrict, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.createdOnWWW, Company.mxxCreated, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (Company, BranchAffiliationHistory, Individual, Branch) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xF373000000003) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

0.003

4 calls
1 row

0.001

SELECT DISTINCT hex(Company.CompanyId) AS CompanyId, Company.name, Company.companyTypeId, Company.description, Company.logo, Company.enteredBy, Company.lastUpdatedBy, Company.taxId, Company.staffing, Company.mainPhone, Company.email, Company.article, Company.revenue, Company.paidDues, Company.lastUpdated, Company.isComplementary, Company.name2, Company.aliases, hex(Company.companyStatusId) AS companyStatusId, Company.isPubliclyTraded, Company.annualSales, Company.brands, Company.hasSubsidiaries, Company.otherProductCategory, Company.prospectStatus, Company.alphaSort, Company.yearEstablished, Company.companyNum, Company.ticker, Company.matchString, Company.recordOrigin, Company.minorityOwned, Company.womanOwned, Company.companyStruct, Company.howHeardAboutOther, Company.silent, Company.additionalRosterSlots, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.department, Company.region, Company.numFullTimeEmployees, Company.extraPublications, Company.customerType, Company.numFullTimeFaculty, Company.numFullTimeStudents, Company.numPartTimeFaculty, Company.numPartTimeStudents, Company.percentFemaleStudents, Company.percentMinorityStudents, Company.percentInternationalStudents, Company.percentOutOfStateStudents, Company.tuition, Company.tuitionResident, Company.tuitionNonresident, Company.tuitionUndergraduate, Company.tuitionResidentUndergraduate, Company.tuitionNonresidentUndergraduate, Company.tuitionGraduate, Company.tuitionResidentGraduate, Company.tuitionNonresidentGraduate, Company.fundingSource, Company.percentFederalAid, Company.percentUniversityAid, Company.percentDepartmentAid, Company.percentScholarship, Company.feesForArchitectureStudents, Company.averageAnnualScholarship, Company.guideSummary, Company.guideUniversitySetting, Company.guideSchoolPhilosophy, Company.guideProgramDescription, Company.guideAreasOfFocus, Company.guideSpecialActivities, Company.guideFacilities, Company.guideScholarshipsFinAid, Company.numFilledSlots, Company.preProfessionalOffered, Company.postProfessionalOffered, Company.postProfessionalPrograms, Company.studyAbroadOffered, Company.communityDesignOffered, Company.specialProgramsOffered, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.congressRep, Company.congressionalDistrict, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.createdOnWWW, Company.mxxCreated, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (Company, BranchAffiliationHistory, Individual, Branch) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xE77CC00000197) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

0.003

4 calls
1 row

0.001

SELECT DISTINCT hex(Company.CompanyId) AS CompanyId, Company.name, Company.companyTypeId, Company.description, Company.logo, Company.enteredBy, Company.lastUpdatedBy, Company.taxId, Company.staffing, Company.mainPhone, Company.email, Company.article, Company.revenue, Company.paidDues, Company.lastUpdated, Company.isComplementary, Company.name2, Company.aliases, hex(Company.companyStatusId) AS companyStatusId, Company.isPubliclyTraded, Company.annualSales, Company.brands, Company.hasSubsidiaries, Company.otherProductCategory, Company.prospectStatus, Company.alphaSort, Company.yearEstablished, Company.companyNum, Company.ticker, Company.matchString, Company.recordOrigin, Company.minorityOwned, Company.womanOwned, Company.companyStruct, Company.howHeardAboutOther, Company.silent, Company.additionalRosterSlots, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.department, Company.region, Company.numFullTimeEmployees, Company.extraPublications, Company.customerType, Company.numFullTimeFaculty, Company.numFullTimeStudents, Company.numPartTimeFaculty, Company.numPartTimeStudents, Company.percentFemaleStudents, Company.percentMinorityStudents, Company.percentInternationalStudents, Company.percentOutOfStateStudents, Company.tuition, Company.tuitionResident, Company.tuitionNonresident, Company.tuitionUndergraduate, Company.tuitionResidentUndergraduate, Company.tuitionNonresidentUndergraduate, Company.tuitionGraduate, Company.tuitionResidentGraduate, Company.tuitionNonresidentGraduate, Company.fundingSource, Company.percentFederalAid, Company.percentUniversityAid, Company.percentDepartmentAid, Company.percentScholarship, Company.feesForArchitectureStudents, Company.averageAnnualScholarship, Company.guideSummary, Company.guideUniversitySetting, Company.guideSchoolPhilosophy, Company.guideProgramDescription, Company.guideAreasOfFocus, Company.guideSpecialActivities, Company.guideFacilities, Company.guideScholarshipsFinAid, Company.numFilledSlots, Company.preProfessionalOffered, Company.postProfessionalOffered, Company.postProfessionalPrograms, Company.studyAbroadOffered, Company.communityDesignOffered, Company.specialProgramsOffered, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.congressRep, Company.congressionalDistrict, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.createdOnWWW, Company.mxxCreated, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (Company, BranchAffiliationHistory, Individual, Branch) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x124B1200000068) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Individual) WHERE SocialNetworking.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xF373000000003

0.002

1 call
0 rows

0.002

1 call
2 rows

0.002

SELECT DISTINCT hex(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Company) WHERE SocialNetworking.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.002

1 call
0 rows

0.002

2 calls
3 rows

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Individual2JobFunction, Branch, BranchAffiliationHistory, JobFunction) WHERE ((((((JobFunction.JobFunctionId IN (13) AND (Individual.IndividualId=Individual2JobFunction.IndividualId AND Individual2JobFunction.JobFunctionId=JobFunction.JobFunctionId)) AND Individual.personalStatus=1) AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND BranchAffiliationHistory.active='Y') AND Branch.CompanyId=0x19B0000093D) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.002

2 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.001

7 calls
1 row

0.000

SELECT version from databasemap;

0.001

3 calls
54 rows

0.000

SELECT * FROM StateProvince ORDER BY orderindex, id

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, User) WHERE Individual.userId=User.UserId AND User.UserId=0xF373000000005 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

4 calls
1 row

0.000

SELECT DISTINCT hex(SocialNetwork.SocialNetworkId) AS SocialNetworkId, SocialNetwork.icon FROM (SocialNetwork) WHERE SocialNetwork.SocialNetworkId=0xb

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Individual2JobFunction, Branch, BranchAffiliationHistory, JobFunction) WHERE ((((((JobFunction.JobFunctionId IN (15) AND (Individual.IndividualId=Individual2JobFunction.IndividualId AND Individual2JobFunction.JobFunctionId=JobFunction.JobFunctionId)) AND Individual.personalStatus=1) AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND BranchAffiliationHistory.active='Y') AND Branch.CompanyId=0x19B0000093D) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
0 rows

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Individual2JobFunction, Branch, BranchAffiliationHistory, JobFunction) WHERE ((((((JobFunction.JobFunctionId IN (12) AND (Individual.IndividualId=Individual2JobFunction.IndividualId AND Individual2JobFunction.JobFunctionId=JobFunction.JobFunctionId)) AND Individual.personalStatus=1) AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND BranchAffiliationHistory.active='Y') AND Branch.CompanyId=0x19B0000093D) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
3 rows

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (BranchAffiliationHistory, Individual, Branch) WHERE ((((BranchAffiliationHistory.active='Y' AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=0x19B0000093D) AND Individual.personalStatus=1) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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

0.001

1 call
0 rows

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Company, Company2AlternateContact) WHERE (0x19B0000093D=Company.CompanyId AND Company.CompanyId=Company2AlternateContact.CompanyId AND Company2AlternateContact.IndividualId=Individual.IndividualId) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

3 calls
1 row

0.000

select mxxCreated, mxxUpdated from Company where CompanyId=0x19B0000093D;

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Company.CompanyId) AS CompanyId, Company.name, Company.companyTypeId, Company.description, Company.logo, Company.enteredBy, Company.lastUpdatedBy, Company.taxId, Company.staffing, Company.mainPhone, Company.email, Company.article, Company.revenue, Company.paidDues, Company.lastUpdated, Company.isComplementary, Company.name2, Company.aliases, hex(Company.companyStatusId) AS companyStatusId, Company.isPubliclyTraded, Company.annualSales, Company.brands, Company.hasSubsidiaries, Company.otherProductCategory, Company.prospectStatus, Company.alphaSort, Company.yearEstablished, Company.companyNum, Company.ticker, Company.matchString, Company.recordOrigin, Company.minorityOwned, Company.womanOwned, Company.companyStruct, Company.howHeardAboutOther, Company.silent, Company.additionalRosterSlots, Company.criticalNotes, Company.riskAssessment, Company.riskRating, Company.congressofficeFor, Company.department, Company.region, Company.numFullTimeEmployees, Company.extraPublications, Company.customerType, Company.numFullTimeFaculty, Company.numFullTimeStudents, Company.numPartTimeFaculty, Company.numPartTimeStudents, Company.percentFemaleStudents, Company.percentMinorityStudents, Company.percentInternationalStudents, Company.percentOutOfStateStudents, Company.tuition, Company.tuitionResident, Company.tuitionNonresident, Company.tuitionUndergraduate, Company.tuitionResidentUndergraduate, Company.tuitionNonresidentUndergraduate, Company.tuitionGraduate, Company.tuitionResidentGraduate, Company.tuitionNonresidentGraduate, Company.fundingSource, Company.percentFederalAid, Company.percentUniversityAid, Company.percentDepartmentAid, Company.percentScholarship, Company.feesForArchitectureStudents, Company.averageAnnualScholarship, Company.guideSummary, Company.guideUniversitySetting, Company.guideSchoolPhilosophy, Company.guideProgramDescription, Company.guideAreasOfFocus, Company.guideSpecialActivities, Company.guideFacilities, Company.guideScholarshipsFinAid, Company.numFilledSlots, Company.preProfessionalOffered, Company.postProfessionalOffered, Company.postProfessionalPrograms, Company.studyAbroadOffered, Company.communityDesignOffered, Company.specialProgramsOffered, Company.congressSenators, Company.congressSenator1, Company.congressSenator2, Company.congressRep, Company.congressionalDistrict, Company.emailDomains, Company.duesBudget, Company.invoiceInformation, Company.createdOnWWW, Company.mxxCreated, Company.SAIsBoard, Company.delinquentSince, Company.RealActiveMembershipStatus FROM (Company) WHERE Company.CompanyId=0x19B0000093D ORDER BY Company.alphaSort, Company.name

0.001

1 call
167 rows

0.001

SELECT * FROM webselect

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Company) WHERE Company.CompanyId=0x19B0000093D AND Company.KeyContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 8511223432554500824

0.000

1 call
0 rows

0.000

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Company) WHERE Company.CompanyId=0x19B0000093D AND Company.DirectoryContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.000

1 call
0 rows

0.000

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.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, User) WHERE Individual.userId=User.UserId AND User.UserId=0x19800000002 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.000

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Company where CompanyId=0x19B0000093D

0.000

2 calls
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
2 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B0000093E ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D ORDER BY Branch.isMain, Branch.name

0.000

1 call
2 rows

0.000

SELECT DISTINCT hex(Website.WebsiteId) AS WebsiteId, Website.description, Website.address FROM (Website, Company) WHERE Website.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(ProgramPreprofessional.ProgramPreprofessionalId) AS ProgramPreprofessionalId, ProgramPreprofessional.name, ProgramPreprofessional.url FROM (ProgramPreprofessional, Company) WHERE ProgramPreprofessional.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x124B1200000068 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0xF373000000003 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramStudyAbroad.ProgramStudyAbroadId) AS ProgramStudyAbroadId, ProgramStudyAbroad.name, ProgramStudyAbroad.url FROM (ProgramStudyAbroad, Company) WHERE ProgramStudyAbroad.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramSpecialProgram.ProgramSpecialProgramId) AS ProgramSpecialProgramId, ProgramSpecialProgram.name, ProgramSpecialProgram.url FROM (ProgramSpecialProgram, Company) WHERE ProgramSpecialProgram.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x124B1200000068 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0xF373000000003 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0xE77CC00000197 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramPostprofessional.ProgramPostprofessionalId) AS ProgramPostprofessionalId, ProgramPostprofessional.name, ProgramPostprofessional.url FROM (ProgramPostprofessional, Company) WHERE ProgramPostprofessional.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0xE77CC00000197 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Branch.directoryAddressId=Address.AddressId AND Branch.BranchId=0x19B0000093E ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC810000001A AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Branch.primaryAddressId=Address.AddressId AND Branch.BranchId=0x19B0000093E ORDER BY Address.zip

0.000

1 call
54 rows

0.000

select id, abbreviation from StateProvince

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC8100000006 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProgramCommunityDesign.ProgramCommunityDesignId) AS ProgramCommunityDesignId, ProgramCommunityDesign.name, ProgramCommunityDesign.url FROM (ProgramCommunityDesign, Company) WHERE ProgramCommunityDesign.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000093D

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Membership.MembershipId) AS MembershipId, Membership.MembershipTypeId, Membership.joined, Membership.expires, Membership.billingCycle, Membership.billingStart, Membership.renewalNoticeSent, Membership.dateRenewed, Membership.dateRenewallLetterSent, Membership.lastRenewallLentDate, Membership.dateCanncelled, Membership.cancelReason, Membership.enteredBy, Membership.updatedBy, Membership.dateofPaymeny, Membership.balanceDue, Membership.renewalAmount, Membership.paidDues, Membership.renewalStatus, Membership.memberSinceDate, Membership.status, Membership.marketingCode, Membership.memberRecordComment FROM (Membership, Company) WHERE Company.MembershipId=Membership.MembershipId AND Company.CompanyId=0x19B0000093D

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC8100000024 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC8100000012 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC810000001F AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Branch, Address) WHERE Branch.shippingAddressId=Address.AddressId AND Branch.BranchId=0x19B0000093E ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company, Country, Company2Country) WHERE (0x19B0000093D=Company.CompanyId AND Company.CompanyId=Company2Country.CompanyId AND Company2Country.CountryId=Country.CountryId) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC810000000D AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC8100000006 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address) WHERE Address.AddressId=0x19B0000093F ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC810000000D AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC8100000012 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC8100000024 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
11 rows

0.000

SELECT * FROM SocialNetwork ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC810000001A AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x19B0000093F AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000008 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AC810000001F AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000022 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x12205000025E0 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC810000001C AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT Service.description, hex(Service.ServiceId) AS ServiceId FROM (Service, Company, Company2Service) WHERE (0x19B0000093D=Company.CompanyId AND Company.CompanyId=Company2Service.CompanyId AND Company2Service.ServiceId=Service.ServiceId) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000009 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000014 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000021 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000026 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC810000000F AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
7 rows

0.000

SELECT * FROM Region ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000010 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000015 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC8100000027 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x13AC810000001D AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

747122 function calls (738465 primitive calls) in 0.764 seconds Ordered by: cumulative time List reduced from 2308 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.764 0.764 /data/acsa/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.495 0.495 /data/acsa/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.444 0.444 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.001 0.001 0.444 0.444 /data/acsa/current/libs/webform/CompanyForm.py:138(view) 1 0.000 0.000 0.442 0.442 /data/acsa/current/libs/framework/WebForm.py:191(view) 2/1 0.000 0.000 0.261 0.261 /data/acsa/current/libs/framework/DGEGroup.py:43(getDataDictionary) 51/1 0.001 0.000 0.261 0.261 /data/acsa/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 1 0.000 0.000 0.250 0.250 /data/acsa/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.250 0.250 /data/acsa/current/libs/framework/WebSite.py:92(__init__) 38/31 0.000 0.000 0.203 0.007 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 350/163 0.004 0.000 0.153 0.001 {built-in method builtins.exec} 204/127 0.001 0.000 0.152 0.001 :1165(_find_and_load) 1 0.000 0.000 0.151 0.151 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.150 0.150 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML) 204/127 0.001 0.000 0.149 0.001 :1120(_find_and_load_unlocked) 219/141 0.001 0.000 0.143 0.001 :666(_load_unlocked) 217/141 0.000 0.000 0.138 0.001 :934(exec_module) 512 0.001 0.000 0.131 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:111(getDataDictionary) 1 0.039 0.039 0.129 0.129 /data/acsa/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 450/260 0.000 0.000 0.127 0.000 :233(_call_with_frames_removed) 655 0.003 0.000 0.115 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:207(getValue) 5 0.000 0.000 0.112 0.022 /data/acsa/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 50 0.000 0.000 0.094 0.002 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML) 131 0.000 0.000 0.091 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 29 0.000 0.000 0.091 0.003 /data/acsa/current/generic/classes/Address.py:340(generatePrettyHTML) 131 0.001 0.000 0.090 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 9213/8789 0.006 0.000 0.087 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter) 24 0.000 0.000 0.087 0.004 /data/acsa/current/generic/classes/Address.py:226(getPrintPrettyHTML) 9239/8794 0.006 0.000 0.081 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.077 0.077 /data/acsa/current/libs/framework/DisplayGroup.py:311(initialize) 131 0.000 0.000 0.076 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 131 0.075 0.001 0.075 0.001 {function Connection.query at 0xe31bc5c00d60} 2 0.001 0.000 0.075 0.038 /data/acsa/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 1 0.000 0.000 0.075 0.075 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.075 0.075 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process) 95 0.001 0.000 0.075 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 90 0.000 0.000 0.075 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 1 0.000 0.000 0.074 0.074 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.074 0.074 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 8 0.005 0.001 0.074 0.009 /data/acsa/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 38 0.000 0.000 0.074 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.074 0.074 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.073 0.073 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.073 0.073 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.072 0.072 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.072 0.072 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.002 0.002 0.072 0.072 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 8 0.055 0.007 0.069 0.009 /data/acsa/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 124 0.005 0.000 0.067 0.001 /data/acsa/current/libs/framework/DGESelect.py:120(getDataDictionary) 85 0.001 0.000 0.058 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 8666 0.019 0.000 0.054 0.000 /usr/lib/python3.11/copy.py:66(copy) 124 0.003 0.000 0.053 0.000 /data/acsa/current/libs/framework/DGESelect.py:154() 38 0.000 0.000 0.052 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 1 0.000 0.000 0.044 0.044 /data/acsa/current/libs/framework/WebManInterface.py:92(createBroker) 129/111 0.000 0.000 0.043 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:78(__new__) 111 0.041 0.000 0.043 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 3 0.000 0.000 0.041 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 3 0.000 0.000 0.041 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 1 0.000 0.000 0.041 0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 3 0.000 0.000 0.041 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 8 0.000 0.000 0.041 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 8 0.001 0.000 0.041 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 1 0.011 0.011 0.040 0.040 /data/acsa/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 1 0.000 0.000 0.038 0.038 /data/acsa/current/libs/framework/DGEEmail.py:1() 1287 0.006 0.000 0.037 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 507/438 0.001 0.000 0.036 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 55/53 0.000 0.000 0.035 0.001 /data/acsa/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1() 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1() 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 803/38 0.004 0.000 0.034 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 1614 0.002 0.000 0.033 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 444/402 0.000 0.000 0.031 0.000 :1207(_handle_fromlist) 147/65 0.000 0.000 0.030 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 1 0.000 0.000 0.030 0.030 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin) 22 0.000 0.000 0.029 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 94 0.000 0.000 0.027 0.000 /data/acsa/current/libs/framework/DGEPhunkyFone.py:104(getValue) 24696/24468 0.009 0.000 0.027 0.000 {built-in method builtins.getattr} 1614 0.003 0.000 0.026 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 21 0.000 0.000 0.026 0.001 /data/acsa/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 217 0.002 0.000 0.026 0.000 :1007(get_code) 2 0.000 0.000 0.024 0.012 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 65 0.001 0.000 0.024 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:348(__init__) 589/538 0.001 0.000 0.024 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 21 0.000 0.000 0.023 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 95 0.001 0.000 0.023 0.000 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 95 0.001 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 49 0.000 0.000 0.022 0.000 /data/acsa/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 99 0.022 0.000 0.022 0.000 /data/acsa/current/libs/utils/htmlTools.py:53(init) 38 0.002 0.000 0.021 0.001 /usr/lib/python3.11/re/_parser.py:979(parse) 8146 0.011 0.000 0.021 0.000 /usr/lib/python3.11/copy.py:259(_reconstruct) 47 0.000 0.000 0.021 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1530(createPOClassByName) 90/55 0.000 0.000 0.020 0.000 /data/acsa/current/libs/utils/decoratorutils.py:24(wrapper) 47 0.000 0.000 0.020 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:160(createPO) 537 0.001 0.000 0.019 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 118/38 0.001 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 2227/2200 0.002 0.000 0.019 0.000 /data/acsa/current/libs/framework/LazyDict.py:186(__getitem__) 717/38 0.007 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:516(_parse)

Other ACSA Websites

Program Directory

Already have an account?

I’m new here

Stay in Touch