Company: Athabasca University: ACSA

Athabasca University
RAIC Center for Architecture

1 University Drive
Athabasca
Alberta, T9S 3A3
Canada

Main Phone: 250-766-3575
Fax: 780-675-6437
Website: http://architecture.athabascau.ca
E-mail: test@maxx.matrixgroup.net

4-Year Programs
FTE Faculty: 3

Dr. Douglas MacLeod, Chair, RAIC Center for Architecture

Faculty/Staff Roster

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

Last Updated: 01/30/2024

Total Time

Count

Avg Time

Query

0.022

24 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:42:30',mxxCreatedBy=NULL, PageRequestId=0x13AC4600000000, path='forms/CompanyFormPublic/view', formName='acsa_CompanyFormPublic', site='www', clientAcronym='ACSA', pid='3421382', requestNum='1', pageDictSize=NULL, objectId='C6513000000C8', templateMethod=NULL, growth=NULL, server='www.acsa.maxx.matrixdev.net', dbThreadId='139198', startTime='2025-07-05 01:42:30', sessionId=0x487E7D6C0CF70ADA, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{\\'id\\':\\'C6513000000C8\\'}', clientIPAddr='216.73.216.138'

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

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

0.002

1 call
0 rows

0.002

1 call
2 rows

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

0.002

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

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 (Company, Individual, BranchAffiliationHistory, Branch) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xCB4080000007C) 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(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=0xCB30C00000026

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 (User, Individual) WHERE Individual.userId=User.UserId AND User.UserId=0xCB30C00000026 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, BranchAffiliationHistory, Branch) WHERE ((((BranchAffiliationHistory.active='Y' AND Individual.IndividualId=BranchAffiliationHistory.IndividualId) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=0xC6513000000C8) AND Individual.personalStatus=1) ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

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, JobFunction, BranchAffiliationHistory, Branch) 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=0xC6513000000C8) 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=0x4

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, JobFunction, BranchAffiliationHistory, Branch) 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=0xC6513000000C8) 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
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 (Company, Individual, Company2AlternateContact) WHERE (0xC6513000000C8=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(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=0xC6513000000C8 AND Company.KeyContactId=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 (Company) WHERE Company.CompanyId=0xC6513000000C8 ORDER BY Company.alphaSort, Company.name

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=0x13AC4600000030 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.000

3 calls
1 row

0.000

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

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

0.000

1 call
0 rows

0.000

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 (SocialNetworking, Company) WHERE SocialNetworking.SocialNetworkingId=0xCBA10000002AF AND SocialNetworking.CompanyId=Company.CompanyId ORDER BY Company.alphaSort, Company.name

0.000

1 call
167 rows

0.000

SELECT * FROM webselect

0.000

1 call
0 rows

0.000

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 (SocialNetworking, Company) WHERE SocialNetworking.SocialNetworkingId=0xCBA1D000003E8 AND SocialNetworking.CompanyId=Company.CompanyId ORDER BY Company.alphaSort, Company.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, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0xC6513000000C8 ORDER BY Branch.isMain, Branch.name

0.000

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 5223750520823810778

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=0xC6513000000CA ORDER BY Address.zip

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(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=0xCB4080000007C 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=0xC6513000000C5 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

2 calls
1 row

0.000

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

0.000

1 call
1 row

0.000

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

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 Address.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xC6513000000C5 ORDER BY Address.zip

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

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=0xCB4080000007C AND Individual.mainAddressId=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=0xC6513000000C8

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=0xC733800000657 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.shippingAddressId=Address.AddressId AND Branch.BranchId=0xC6513000000CA 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=0xC6513000000C8

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

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=0xC733800000657 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=0xC6513000000CA 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=0xC6513000000CA 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=0xC6513000000C5 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=0x13AC460000001C 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=0xCB2FE00000056 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(BranchAffiliationHistory.BranchAffiliationHistoryId) AS BranchAffiliationHistoryId, BranchAffiliationHistory.startdate, BranchAffiliationHistory.enddate, BranchAffiliationHistory.active, BranchAffiliationHistory.vote, BranchAffiliationHistory.rosterOrder FROM (Individual, BranchAffiliationHistory) WHERE BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xC6513000000C5

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=0xCB2FE00000056 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=0x13AC4600000006 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip

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 (Company, Membership) WHERE Company.MembershipId=Membership.MembershipId AND Company.CompanyId=0xC6513000000C8

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=0x13AC4600000021 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=0x13AC460000001C 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=0x13AC4600000026 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=0x13AC460000000E 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=0x13AC460000000E AND Individual.mainAddressId=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=0xC6513000000C8

0.000

1 call
0 rows

0.000

SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Country, Company, Company2Country) WHERE (0xC6513000000C8=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=0x13AC4600000021 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=0x13AC4600000006 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 (Address, Branch) WHERE Address.AddressId=0x13AC460000001E 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000015 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=0x13AC4600000013 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=0x13AC4600000026 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
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=0xCB2FE0000004E 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 (Address, Branch) WHERE Address.AddressId=0xCB2FE0000004E 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=0x13AC4600000013 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, BranchAffiliationHistory) WHERE BranchAffiliationHistory.BranchAffiliationHistoryId=0xC6513000000C9 AND BranchAffiliationHistory.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

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(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x13AC460000001F 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000010 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000008 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 (0xC6513000000C8=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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000011 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000023 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000029 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
0 rows

0.000

SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x13AC4600000028 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000009 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000024 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 (Address, Branch) WHERE Address.AddressId=0x13AC4600000016 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

801199 function calls (792689 primitive calls) in 0.802 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.803 0.803 /data/acsa/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.541 0.541 /data/acsa/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.495 0.495 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.001 0.001 0.495 0.495 /data/acsa/current/libs/webform/CompanyForm.py:138(view) 1 0.000 0.000 0.492 0.492 /data/acsa/current/libs/framework/WebForm.py:191(view) 2/1 0.000 0.000 0.311 0.311 /data/acsa/current/libs/framework/DGEGroup.py:43(getDataDictionary) 57/1 0.001 0.000 0.311 0.311 /data/acsa/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 44/37 0.000 0.000 0.251 0.007 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 1 0.000 0.000 0.243 0.243 /data/acsa/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.243 0.243 /data/acsa/current/libs/framework/WebSite.py:92(__init__) 590 0.001 0.000 0.168 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:111(getDataDictionary) 5 0.000 0.000 0.158 0.032 /data/acsa/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 1 0.000 0.000 0.150 0.150 /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) 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) 754 0.003 0.000 0.149 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:207(getValue) 204/127 0.001 0.000 0.146 0.001 :1120(_find_and_load_unlocked) 219/141 0.001 0.000 0.140 0.001 :666(_load_unlocked) 217/141 0.000 0.000 0.135 0.001 :934(exec_module) 1 0.039 0.039 0.127 0.127 /data/acsa/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 33 0.000 0.000 0.126 0.004 /data/acsa/current/generic/classes/Address.py:340(generatePrettyHTML) 450/260 0.000 0.000 0.124 0.000 :233(_call_with_frames_removed) 28 0.000 0.000 0.116 0.004 /data/acsa/current/generic/classes/Address.py:226(getPrintPrettyHTML) 152 0.001 0.000 0.105 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 152 0.001 0.000 0.104 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 56 0.000 0.000 0.101 0.002 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML) 9281/8857 0.006 0.000 0.088 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter) 152 0.000 0.000 0.083 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 152 0.083 0.001 0.083 0.001 {function Connection.query at 0xf49bfdc38d60} 9307/8862 0.007 0.000 0.082 0.000 {built-in method builtins.__import__} 144 0.006 0.000 0.078 0.001 /data/acsa/current/libs/framework/DGESelect.py:120(getDataDictionary) 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) 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:72(__init__) 1 0.000 0.000 0.073 0.073 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.073 0.073 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 8 0.004 0.001 0.073 0.009 /data/acsa/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 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.072 0.072 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.072 0.072 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 102 0.001 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 98 0.000 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 1 0.000 0.000 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.002 0.002 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 38 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) 9920 0.022 0.000 0.063 0.000 /usr/lib/python3.11/copy.py:66(copy) 144 0.004 0.000 0.062 0.000 /data/acsa/current/libs/framework/DGESelect.py:154() 86 0.001 0.000 0.055 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 38 0.000 0.000 0.051 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 111 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) 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.000 0.000 0.040 0.040 /data/acsa/current/libs/framework/WebManInterface.py:92(createBroker) 134/116 0.000 0.000 0.039 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:78(__new__) 528/467 0.001 0.000 0.039 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 62/61 0.000 0.000 0.038 0.001 /data/acsa/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 1 0.000 0.000 0.037 0.037 /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__) 26 0.000 0.000 0.037 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 1 0.012 0.012 0.036 0.036 /data/acsa/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 32 0.000 0.000 0.035 0.001 /data/acsa/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 32 0.003 0.000 0.035 0.001 /data/acsa/current/libs/framework/WebManInterface.py:37(readWebSelect) 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) 50 0.000 0.000 0.034 0.001 /data/acsa/current/libs/PLayer/PersistentBroker.py:336(processSql) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 803/38 0.004 0.000 0.033 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 455/413 0.001 0.000 0.032 0.000 :1207(_handle_fromlist) 23 0.001 0.000 0.031 0.001 /data/acsa/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 1 0.000 0.000 0.030 0.030 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin) 23 0.000 0.000 0.030 0.001 /data/acsa/current/libs/framework/BaseHandler.py:1202(WSKey2Value) 150/66 0.000 0.000 0.030 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 27772/27565 0.010 0.000 0.029 0.000 {built-in method builtins.getattr} 21 0.000 0.000 0.029 0.001 /data/acsa/current/generic/classes/Address.py:1010(getCountryName) 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) 111 0.001 0.000 0.026 0.000 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 217 0.002 0.000 0.026 0.000 :1007(get_code) 110 0.001 0.000 0.025 0.000 /data/acsa/current/libs/framework/DGEPhunkyFone.py:104(getValue) 111 0.001 0.000 0.025 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 9384 0.012 0.000 0.025 0.000 /usr/lib/python3.11/copy.py:259(_reconstruct) 66 0.001 0.000 0.025 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:348(__init__) 2 0.000 0.000 0.025 0.012 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 589/538 0.001 0.000 0.023 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 55 0.000 0.000 0.022 0.000 /data/acsa/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 111 0.022 0.000 0.022 0.000 /data/acsa/current/libs/utils/htmlTools.py:53(init) 49 0.000 0.000 0.021 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1530(createPOClassByName) 49 0.000 0.000 0.021 0.000 /data/acsa/current/libs/PLayer/PersistentBroker.py:160(createPO) 38 0.000 0.000 0.020 0.001 /usr/lib/python3.11/re/_parser.py:979(parse) 118/38 0.001 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub)

Other ACSA Websites

Program Directory

Already have an account?

I’m new here

Stay in Touch