Program Directory

Use this searchable directory to find ACSA member programs. With each program found in your search, you can click to go to the program's website or view details about the program's faculty. You may click here to view the full directory.

Program Search:
Searches university and school names

Membership Type:

Country:

State:
US State/Territory (Searches for organizations with any address in this state, not just their main address.)

Province:
If your search by province does not produce expected results, try using the province's official abbreviation.

ACSA Region:

Total Time

Count

Avg Time

Query

0.006

1 call
0 rows

0.006

INSERT INTO PageRequest SET mxxCreated='2025-07-04 12:45:30',mxxCreatedBy=NULL, PageRequestId=0x13AA8000000000, path='forms/CompanyFormPublic/search', formName='acsa_CompanyFormPublic', site='www', clientAcronym='ACSA', pid='3341430', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.acsa.maxx.matrixdev.net', dbThreadId='93308', startTime='2025-07-04 12:45:30', sessionId=0x79E379CE33DE2F65, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.138'

0.006

1 call
0 rows

0.006

COMMIT

0.005

1 call
0 rows

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 (Company, Individual) WHERE Company.CompanyId=0x13AA8000000001 AND Company.KeyContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.004

1 call
0 rows

0.004

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

0.004

12 calls
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.003

1 call
0 rows

0.003

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=0x13AA8000000003 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.003

2 calls
244 rows

0.002

SELECT * FROM Country ORDER BY orderindex, id

0.002

2 calls
54 rows

0.001

SELECT * FROM StateProvince ORDER BY orderindex, id

0.002

12 calls
1 row

0.000

SELECT version from databasemap;

0.002

2 calls
244 rows

0.001

SELECT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Country) ORDER BY orderindex

0.002

1 call
7 rows

0.002

SELECT * FROM Region ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

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

0.001

1 call
3 rows

0.001

SELECT * FROM AddressType ORDER BY orderindex, id

0.001

1 call
2 rows

0.001

SELECT * FROM YesNo ORDER BY orderindex, id

0.001

2 calls
0 rows

0.001

SELECT Service.description, hex(Service.ServiceId) AS ServiceId FROM (Service) ORDER BY orderindex

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) WHERE Company.CompanyId=0x13AA8000000001 AND Company.BillingContactId=Individual.IndividualId 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 (Company, Individual) WHERE Company.CompanyId=0x13AA8000000001 AND Company.DirectoryContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
167 rows

0.001

SELECT * FROM webselect

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=0x13AA8000000012 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=0x13AA8000000026 AND Individual.mainAddressId=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=0x13AA8000000013 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=0x13AA8000000020 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=0x13AA8000000017 AND Individual.mainAddressId=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=0x13AA8000000004 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=0x13AA8000000006 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=0x13AA8000000023 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=0x13AA800000001D 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=0x13AA800000001A 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=0x13AA8000000008 AND Individual.mainAddressId=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=0x13AA8000000011 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

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=0x13AA800000000B AND Individual.mainAddressId=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=0x13AA8000000014 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=0x13AA800000001B 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=0x13AA800000001E 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=0x13AA8000000018 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=0x13AA8000000021 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=0x13AA8000000010 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=0x13AA8000000009 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=0x13AA8000000027 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=0x13AA8000000024 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=0x13AA800000000C AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

START TRANSACTION

1730577 function calls (1710156 primitive calls) in 3.061 seconds Ordered by: cumulative time List reduced from 2394 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 3.062 3.062 /data/acsa/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 2.802 2.802 /data/acsa/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 2.743 2.743 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 2.743 2.743 /data/acsa/current/acsa_org/sites/www/forms/acsa_CompanyFormPublic.py:170(search) 1 0.000 0.000 2.743 2.743 /data/acsa/current/generic/sites/www/forms/CompanyFormPublic.py:87(search) 1 0.000 0.000 2.723 2.723 /data/acsa/current/libs/framework/WebForm.py:1091(search) 1 0.000 0.000 2.156 2.156 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 2.156 2.156 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 2.065 2.065 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 2.064 2.064 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 1.730 1.730 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 1.729 1.729 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 1.729 0.576 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 1.728 0.864 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 1.728 0.864 /usr/lib/python3.11/urllib/request.py:1390(https_open) 2 0.000 0.000 1.728 0.864 /usr/lib/python3.11/urllib/request.py:1307(do_open) 60 0.004 0.000 1.652 0.028 {method 'readline' of '_io.BufferedReader' objects} 2 0.000 0.000 1.649 0.824 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 1.649 0.824 /usr/lib/python3.11/http/client.py:318(begin) 12 0.000 0.000 1.648 0.137 /usr/lib/python3.11/socket.py:704(readinto) 12 0.000 0.000 1.648 0.137 /usr/lib/python3.11/ssl.py:1299(recv_into) 12 0.000 0.000 1.648 0.137 /usr/lib/python3.11/ssl.py:1157(read) 12 1.648 0.137 1.648 0.137 {method 'read' of '_ssl._SSLSocket' objects} 2 0.000 0.000 1.648 0.824 /usr/lib/python3.11/http/client.py:285(_read_status) 2/1 0.000 0.000 0.907 0.907 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.907 0.907 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.906 0.906 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.567 0.567 /data/acsa/current/generic/sites/www/forms/CompanyFormPublic.py:136(getSearchHTML) 1 0.000 0.000 0.567 0.567 /data/acsa/current/libs/framework/WebForm.py:1532(getSearchHTML) 318 0.002 0.000 0.346 0.001 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 318 0.003 0.000 0.344 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 3920/318 0.004 0.000 0.306 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 5010/318 0.045 0.000 0.305 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 34 0.004 0.000 0.246 0.007 /data/acsa/current/libs/framework/DGESelect.py:36(getEditHTML) 1 0.000 0.000 0.242 0.242 /data/acsa/current/libs/framework/WebManager.py:89(createNewHandler) 42 0.009 0.000 0.242 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_In.py:665(renderwob) 1 0.000 0.000 0.242 0.242 /data/acsa/current/libs/framework/WebSite.py:92(__init__) 13 0.000 0.000 0.220 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 13 0.000 0.000 0.220 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 13 0.000 0.000 0.220 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 13 0.000 0.000 0.218 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 13 0.000 0.000 0.218 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 13 0.007 0.001 0.216 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.191 0.191 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 6/4 0.000 0.000 0.189 0.047 /data/acsa/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 6/4 0.000 0.000 0.189 0.047 /data/acsa/current/libs/framework/DGEAssoc.py:42(getEditHTML) 106 0.001 0.000 0.189 0.002 /data/acsa/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 346/157 0.004 0.000 0.187 0.001 {built-in method builtins.exec} 206/128 0.001 0.000 0.185 0.001 :1165(_find_and_load) 206/128 0.001 0.000 0.183 0.001 :1120(_find_and_load_unlocked) 2 0.000 0.000 0.162 0.081 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 211/132 0.001 0.000 0.146 0.001 :666(_load_unlocked) 209/132 0.000 0.000 0.142 0.001 :934(exec_module) 1 0.004 0.004 0.128 0.128 /data/acsa/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 443/253 0.000 0.000 0.125 0.000 :233(_call_with_frames_removed) 125 0.001 0.000 0.124 0.001 /data/acsa/current/libs/framework/DGEAttribute.py:58(getEditHTML) 8305 0.021 0.000 0.118 0.000 /data/acsa/current/libs/framework/MaxxDTML.py:29(render) 7 0.000 0.000 0.116 0.017 /data/acsa/current/libs/framework/DGEMethod.py:90(getBBTDictionary) 7 0.000 0.000 0.116 0.017 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 9 0.000 0.000 0.116 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 9 0.000 0.000 0.116 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 9 0.000 0.000 0.114 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 19 0.000 0.000 0.114 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 19 0.002 0.000 0.114 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 8 0.000 0.000 0.112 0.014 /data/acsa/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 3927 0.019 0.000 0.112 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.111 0.111 /data/acsa/current/libs/framework/DisplayGroup.py:311(initialize) 22241/21810 0.013 0.000 0.106 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter) 7 0.000 0.000 0.104 0.015 /data/acsa/current/libs/framework/DGEMethod.py:31(getEditHTML) 8 0.000 0.000 0.099 0.012 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 1 0.000 0.000 0.098 0.098 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 4 0.002 0.001 0.093 0.023 /data/acsa/current/libs/framework/DGEObjectMultiSelect.py:53(getEditHTML) 1 0.000 0.000 0.093 0.093 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 4830 0.005 0.000 0.092 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.091 0.091 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process) 22266/21814 0.012 0.000 0.090 0.000 {built-in method builtins.__import__} 14093 0.009 0.000 0.090 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 94490 0.083 0.000 0.083 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 91 0.000 0.000 0.079 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 4198/4186 0.004 0.000 0.079 0.000 /data/acsa/current/libs/framework/LazyDict.py:186(__getitem__) 91 0.000 0.000 0.078 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 18 0.000 0.000 0.078 0.004 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML) 2 0.001 0.000 0.074 0.037 /data/acsa/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 51 0.000 0.000 0.074 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 51 0.001 0.000 0.074 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 8 0.004 0.001 0.073 0.009 /data/acsa/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 41 0.000 0.000 0.072 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 4830 0.007 0.000 0.070 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1806/1654 0.002 0.000 0.070 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 8 0.054 0.007 0.068 0.009 /data/acsa/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 115 0.001 0.000 0.068 0.001 /data/acsa/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 14201 0.027 0.000 0.068 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:376(getitem) 374 0.002 0.000 0.067 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:207(getValue) 125 0.001 0.000 0.066 0.001 /data/acsa/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 91 0.000 0.000 0.064 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 91 0.064 0.001 0.064 0.001 {function Connection.query at 0xefd335468900} 1084/531 0.002 0.000 0.058 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 2 0.000 0.000 0.057 0.029 /usr/lib/python3.11/http/client.py:1426(__init__) 2 0.000 0.000 0.057 0.029 /usr/lib/python3.11/ssl.py:745(create_default_context) 1624 0.004 0.000 0.057 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal)

Other ACSA Websites

Program Directory

Program Directory

Already have an account?

I’m new here

Stay in Touch