Company: British Columbia Institute of Technology: ACSA

British Columbia Institute of Technology

3700 Willindon Avenue
Burnaby, British Columbia V5G3H2
Canada

Main Phone: 778-331-1316
Website: https://www.bcit.ca/study/programs/8050btech
E-mail: test@maxx.matrixgroup.net

4-Year Programs

Jody Patterson, Program Head

Faculty/Staff Roster

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

Last Updated: 09/07/2023

Total Time

Count

Avg Time

Query

0.018

20 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.006

1 call
0 rows

0.006

COMMIT

0.006

1 call
0 rows

0.006

INSERT INTO PageRequest SET mxxCreated='2025-07-05 01:24:57',mxxCreatedBy=NULL, PageRequestId=0x13AC2E00000000, path='forms/CompanyFormPublic/view', formName='acsa_CompanyFormPublic', site='www', clientAcronym='ACSA', pid='3418431', requestNum='1', pageDictSize=NULL, objectId='B2E0E0000290E', templateMethod=NULL, growth=NULL, server='www.acsa.maxx.matrixdev.net', dbThreadId='138408', startTime='2025-07-05 01:24:57', sessionId=0x7B06FDB4D92DA921, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{\\'id\\':\\'B2E0E0000290E\\'}', clientIPAddr='216.73.216.138'

0.005

1 call
1 row

0.005

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=0xB2E0E0000290E AND Company.KeyContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.005

1 call
1 row

0.005

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=0xB2E0E0000290E ORDER BY Company.alphaSort, Company.name

0.005

6 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 (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xCBA0E00000033) 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, Company) WHERE SocialNetworking.CompanyId=Company.CompanyId AND Company.CompanyId=0xB2E0E0000290E

0.002

1 call
0 rows

0.002

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

0.002

1 call
0 rows

0.002

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

0.002

1 call
0 rows

0.002

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

0.002

1 call
0 rows

0.002

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

0.002

2 calls
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 (Individual2JobFunction, Branch, BranchAffiliationHistory, Individual, 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=0xB2E0E0000290E) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

2 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 (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xCBD3E000005B8) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

0.001

7 calls
1 row

0.000

SELECT version from databasemap;

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 (Individual2JobFunction, Branch, BranchAffiliationHistory, Individual, 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=0xB2E0E0000290E) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

2 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 (Individual2JobFunction, Branch, BranchAffiliationHistory, Individual, 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=0xB2E0E0000290E) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
4 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, Branch, BranchAffiliationHistory) WHERE ((((BranchAffiliationHistory.active='Y' AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=0xB2E0E0000290E) AND Individual.personalStatus=1) 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, Company2AlternateContact, Company) WHERE (0xB2E0E0000290E=Company.CompanyId AND Company.CompanyId=Company2AlternateContact.CompanyId AND Company2AlternateContact.IndividualId=Individual.IndividualId) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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 (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xB2E0E0000290A) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

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 (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xCBC7500000047) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name

0.001

1 call
1 row

0.001

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

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 (User, Individual) WHERE Individual.userId=User.UserId AND User.UserId=0x19B0005B91E ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
167 rows

0.001

SELECT * FROM webselect

0.001

1 call
0 rows

0.001

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

0.000

2 calls
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

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=0xB2E0E0000290E ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

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

0.000

3 calls
1 row

0.000

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

0.000

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 8865051869704988961

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 (User, Individual) WHERE Individual.userId=User.UserId AND User.UserId=0x13AC2E0000002E ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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

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=0xB2E0E0000290E AND Company.DirectoryContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Country, Company2Country, Company) WHERE (0xB2E0E0000290E=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(ProgramPostprofessional.ProgramPostprofessionalId) AS ProgramPostprofessionalId, ProgramPostprofessional.name, ProgramPostprofessional.url FROM (ProgramPostprofessional, Company) WHERE ProgramPostprofessional.CompanyId=Company.CompanyId AND Company.CompanyId=0xB2E0E0000290E

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

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 (Branch, Address) WHERE Branch.directoryAddressId=Address.AddressId AND Branch.BranchId=0xB2E0E0000290F 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 Address.BranchId=Branch.BranchId AND Branch.BranchId=0xB2E0E0000290F ORDER BY Address.zip

0.000

1 call
7 rows

0.000

SELECT * FROM Region ORDER BY orderindex, id

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(ProgramCommunityDesign.ProgramCommunityDesignId) AS ProgramCommunityDesignId, ProgramCommunityDesign.name, ProgramCommunityDesign.url FROM (ProgramCommunityDesign, Company) WHERE ProgramCommunityDesign.CompanyId=Company.CompanyId AND Company.CompanyId=0xB2E0E0000290E

0.000

1 call
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.000

2 calls
1 row

0.000

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

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

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=0xCBA0E00000033 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=0x13AC2E00000006 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=0xB2E0E0000290A 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=0x13AC2E0000001F 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=0xCBC7500000047 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=0xCBC7500000047 AND Individual.directoryAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

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

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=0xCBA0E00000033 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 (Branch, Address) WHERE Branch.shippingAddressId=Address.AddressId AND Branch.BranchId=0xB2E0E0000290F 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=0xCBD3E000005B8 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=0xCBD3E000005B8 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=0x13AC2E00000024 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 (Address) WHERE Address.AddressId=0xB2E0E00002910 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=0xB2E0E0000290A 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=0x13AC2E00000019 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=0x13AC2E0000000E 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 (Branch, Address) WHERE Branch.primaryAddressId=Address.AddressId AND Branch.BranchId=0xB2E0E0000290F 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=0x13AC2E0000000E 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=0x13AC2E00000013 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=0x13AC2E00000013 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=0x13AC2E0000001F 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=0x13AC2E00000006 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=0x13AC2E00000019 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=0x13AC2E00000024 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=0x13AC2E00000021 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=0x13AC2E00000010 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=0x13AC2E00000011 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=0x13AC2E0000001B 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=0xB2E0E00002910 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=0x13AC2E00000008 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=0x13AC2E00000015 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=0x13AC2E00000026 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=0x13AC2E00000009 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=0x13AC2E00000022 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=0x13AC2E00000016 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=0x13AC2E00000027 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=0x13AC2E0000001C AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

755783 function calls (747412 primitive calls) in 0.773 seconds Ordered by: cumulative time List reduced from 2278 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.773 0.773 /data/acsa/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.512 0.512 /data/acsa/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.464 0.464 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.001 0.001 0.464 0.464 /data/acsa/current/libs/webform/CompanyForm.py:138(view) 1 0.000 0.000 0.458 0.458 /data/acsa/current/libs/framework/WebForm.py:191(view) 2/1 0.000 0.000 0.279 0.279 /data/acsa/current/libs/framework/DGEGroup.py:43(getDataDictionary) 45/1 0.000 0.000 0.279 0.279 /data/acsa/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 1 0.000 0.000 0.244 0.244 /data/acsa/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.244 0.244 /data/acsa/current/libs/framework/WebSite.py:92(__init__) 38/31 0.000 0.000 0.229 0.007 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 1 0.000 0.000 0.151 0.151 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.151 0.151 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML) 350/163 0.004 0.000 0.150 0.001 {built-in method builtins.exec} 204/127 0.001 0.000 0.149 0.001 :1165(_find_and_load) 204/127 0.001 0.000 0.146 0.001 :1120(_find_and_load_unlocked) 502 0.001 0.000 0.143 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:111(getDataDictionary) 219/141 0.001 0.000 0.139 0.001 :666(_load_unlocked) 217/141 0.000 0.000 0.135 0.001 :934(exec_module) 1 0.039 0.039 0.128 0.128 /data/acsa/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 639 0.003 0.000 0.127 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:207(getValue) 450/260 0.000 0.000 0.124 0.000 :233(_call_with_frames_removed) 5 0.000 0.000 0.119 0.024 /data/acsa/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 29 0.000 0.000 0.114 0.004 /data/acsa/current/generic/classes/Address.py:340(generatePrettyHTML) 139 0.000 0.000 0.108 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 139 0.001 0.000 0.107 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 24 0.000 0.000 0.105 0.004 /data/acsa/current/generic/classes/Address.py:226(getPrintPrettyHTML) 46 0.000 0.000 0.092 0.002 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML) 139 0.000 0.000 0.088 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 139 0.087 0.001 0.087 0.001 {function Connection.query at 0xff29a34e8d60} 9192/8768 0.006 0.000 0.087 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter) 9218/8773 0.006 0.000 0.081 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.076 0.076 /data/acsa/current/libs/framework/DisplayGroup.py:311(initialize) 1 0.000 0.000 0.076 0.076 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process) 1 0.000 0.000 0.075 0.075 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.074 0.074 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 2 0.001 0.000 0.074 0.037 /data/acsa/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 1 0.000 0.000 0.074 0.074 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 1 0.000 0.000 0.073 0.073 /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) 8 0.005 0.001 0.073 0.009 /data/acsa/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 80 0.000 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 80 0.001 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 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) 37 0.000 0.000 0.071 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 8 0.054 0.007 0.068 0.009 /data/acsa/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 120 0.005 0.000 0.066 0.001 /data/acsa/current/libs/framework/DGESelect.py:120(getDataDictionary) 77 0.001 0.000 0.060 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 8636 0.019 0.000 0.053 0.000 /usr/lib/python3.11/copy.py:66(copy) 120 0.003 0.000 0.052 0.000 /data/acsa/current/libs/framework/DGESelect.py:154() 37 0.000 0.000 0.051 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 110 0.041 0.000 0.042 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 3 0.000 0.000 0.042 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 3 0.000 0.000 0.042 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 454/404 0.001 0.000 0.041 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 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) 57/56 0.000 0.000 0.041 0.001 /data/acsa/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 1 0.000 0.000 0.040 0.040 /data/acsa/current/libs/framework/WebManInterface.py:92(createBroker) 129/111 0.000 0.000 0.039 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:78(__new__) 1287 0.006 0.000 0.038 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.037 0.037 /data/acsa/current/libs/framework/DGEEmail.py:1() 1 0.011 0.011 0.035 0.035 /data/acsa/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 24398/24187 0.009 0.000 0.035 0.000 {built-in method builtins.getattr} 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.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/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() 1614 0.002 0.000 0.034 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 801/37 0.004 0.000 0.034 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 429/387 0.001 0.000 0.031 0.000 :1207(_handle_fromlist) 46 0.000 0.000 0.031 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:336(processSql) 28 0.000 0.000 0.030 0.001 /data/acsa/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 1 0.000 0.000 0.030 0.030 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin) 28 0.003 0.000 0.030 0.001 /data/acsa/current/libs/framework/WebManInterface.py:37(readWebSelect) 18 0.000 0.000 0.027 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 135/58 0.000 0.000 0.027 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 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) 217 0.002 0.000 0.025 0.000 :1007(get_code) 2 0.000 0.000 0.025 0.012 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 19 0.000 0.000 0.024 0.001 /data/acsa/current/libs/framework/BaseHandler.py:1202(WSKey2Value) 21 0.000 0.000 0.024 0.001 /data/acsa/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 95 0.001 0.000 0.023 0.000 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 17 0.000 0.000 0.023 0.001 /data/acsa/current/generic/classes/Address.py:1010(getCountryName) 589/538 0.001 0.000 0.023 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 95 0.001 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 16 0.000 0.000 0.022 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 45 0.000 0.000 0.022 0.000 /data/acsa/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 58 0.001 0.000 0.022 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:348(__init__) 91 0.022 0.000 0.022 0.000 /data/acsa/current/libs/utils/htmlTools.py:53(init) 41/40 0.000 0.000 0.021 0.001 /data/acsa/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 41/40 0.000 0.000 0.021 0.001 /data/acsa/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 8102 0.011 0.000 0.021 0.000 /usr/lib/python3.11/copy.py:259(_reconstruct) 94 0.000 0.000 0.020 0.000 /data/acsa/current/libs/framework/DGEPhunkyFone.py:104(getValue) 37 0.000 0.000 0.020 0.001 /usr/lib/python3.11/re/_parser.py:979(parse)

Other ACSA Websites

Program Directory

Already have an account?

I’m new here

Stay in Touch