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.010

1 call
0 rows

0.010

COMMIT

0.005

1 call
0 rows

0.005

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

0.003

1 call
0 rows

0.003

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

0.003

12 calls
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.002

2 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.002

12 calls
1 row

0.000

SELECT version from databasemap;

0.002

1 call
0 rows

0.002

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

0.002

2 calls
244 rows

0.001

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

0.001

2 calls
54 rows

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

2 calls
0 rows

0.000

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

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 (Individual, Address) WHERE `Individual`.`IndividualId`=0x14B3E300000020 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
167 rows

0.000

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 (Individual, Address) WHERE `Individual`.`IndividualId`=0x14B3E30000001A 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`=0x14B3E300000026 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`=0x14B3E30000001D 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 (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x14B3E300000012 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`=0x14B3E300000013 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x14B3E30000000F 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`=0x14B3E300000024 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(`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`=0x14B3E300000017 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 17:47:33',`mxxCreatedBy`=NULL, `PageRequestId`=0x14B3E300000000, `path`='forms/CompanyFormPublic/search', `formName`='acsa_CompanyFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='2971949', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='640692', `startTime`='2025-08-21 17:47:33', `sessionId`=0x31057DC19DED0062, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.122'

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`=0x14B3E300000021 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 (Branch, Address) WHERE `Address`.`AddressId`=0x14B3E30000001B 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`=0x14B3E30000001E 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`=0x14B3E300000027 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`=0x14B3E300000014 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`=0x14B3E300000005 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`=0x14B3E300000004 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`=0x14B3E300000008 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`=0x14B3E300000011 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`=0x14B3E30000000B 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`=0x14B3E300000009 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`=0x14B3E300000018 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`=0x14B3E300000010 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`=0x14B3E30000000C 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`=0x14B3E300000006 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

1947609 function calls (1925821 primitive calls) in 1.520 seconds Ordered by: cumulative time List reduced from 2407 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.521 1.521 /data/acsa/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 1.267 1.267 /data/acsa/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 1.217 1.217 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.217 1.217 /data/acsa/current/acsa_org/sites/www/forms/acsa_CompanyFormPublic.py:170(search) 1 0.000 0.000 1.217 1.217 /data/acsa/current/generic/sites/www/forms/CompanyFormPublic.py:87(search) 1 0.000 0.000 1.204 1.204 /data/acsa/current/libs/framework/WebForm.py:1090(search) 1 0.000 0.000 0.606 0.606 /data/acsa/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.605 0.605 /data/acsa/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.599 0.599 /data/acsa/current/generic/sites/www/forms/CompanyFormPublic.py:136(getSearchHTML) 1 0.000 0.000 0.599 0.599 /data/acsa/current/libs/framework/WebForm.py:1531(getSearchHTML) 1 0.000 0.000 0.493 0.493 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.493 0.493 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 318 0.002 0.000 0.363 0.001 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 318 0.003 0.000 0.361 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 3920/318 0.004 0.000 0.324 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 5010/318 0.049 0.000 0.323 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 13 0.000 0.000 0.294 0.023 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 13 0.000 0.000 0.294 0.023 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 13 0.000 0.000 0.293 0.023 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 13 0.000 0.000 0.291 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 13 0.000 0.000 0.291 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 13 0.009 0.001 0.290 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 34 0.005 0.000 0.253 0.007 /data/acsa/current/libs/framework/DGESelect.py:36(getEditHTML) 1 0.000 0.000 0.251 0.251 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 42 0.009 0.000 0.249 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/WebManager.py:90(createNewHandler) 1 0.000 0.000 0.242 0.242 /data/acsa/current/libs/framework/WebSite.py:92(__init__) 2 0.000 0.000 0.214 0.107 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 6/4 0.000 0.000 0.209 0.052 /data/acsa/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 106 0.001 0.000 0.206 0.002 /data/acsa/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 6/4 0.000 0.000 0.202 0.051 /data/acsa/current/libs/framework/DGEAssoc.py:42(getEditHTML) 346/157 0.004 0.000 0.188 0.001 {built-in method builtins.exec} 206/128 0.001 0.000 0.187 0.001 :1165(_find_and_load) 206/128 0.001 0.000 0.184 0.001 :1120(_find_and_load_unlocked) 5056 0.026 0.000 0.154 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 9 0.000 0.000 0.151 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 9 0.000 0.000 0.151 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 9 0.000 0.000 0.150 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 19 0.000 0.000 0.150 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 19 0.003 0.000 0.149 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 211/132 0.001 0.000 0.145 0.001 :666(_load_unlocked) 209/132 0.000 0.000 0.140 0.001 :934(exec_module) 7 0.000 0.000 0.130 0.019 /data/acsa/current/libs/framework/DGEMethod.py:90(getBBTDictionary) 7 0.000 0.000 0.130 0.019 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 8 0.000 0.000 0.129 0.016 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 1 0.004 0.004 0.129 0.129 /data/acsa/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 1 0.000 0.000 0.128 0.128 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 125 0.001 0.000 0.128 0.001 /data/acsa/current/libs/framework/DGEAttribute.py:58(getEditHTML) 8305 0.023 0.000 0.127 0.000 /data/acsa/current/libs/framework/MaxxDTML.py:29(render) 8 0.000 0.000 0.126 0.016 /data/acsa/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 443/253 0.000 0.000 0.125 0.000 :233(_call_with_frames_removed) 1 0.000 0.000 0.123 0.123 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 6261 0.006 0.000 0.121 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 7 0.000 0.000 0.120 0.017 /data/acsa/current/libs/framework/DGEMethod.py:31(getEditHTML) 27943/27513 0.017 0.000 0.117 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1458(mxxImporter) 1 0.000 0.000 0.112 0.112 /data/acsa/current/libs/framework/DisplayGroup.py:311(initialize) 1 0.000 0.000 0.112 0.112 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:714(process) 27968/27517 0.017 0.000 0.096 0.000 {built-in method builtins.__import__} 14093 0.010 0.000 0.094 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 4 0.002 0.001 0.093 0.023 /data/acsa/current/libs/framework/DGEObjectMultiSelect.py:53(getEditHTML) 6261 0.009 0.000 0.093 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 2346/2131 0.002 0.000 0.091 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 94490 0.091 0.000 0.091 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 18 0.000 0.000 0.078 0.004 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML) 2101 0.005 0.000 0.074 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 2 0.001 0.000 0.074 0.037 /data/acsa/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 52 0.000 0.000 0.073 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 52 0.001 0.000 0.073 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) 4198/4186 0.005 0.000 0.072 0.000 /data/acsa/current/libs/framework/LazyDict.py:186(__getitem__) 42 0.000 0.000 0.072 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 115 0.001 0.000 0.071 0.001 /data/acsa/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 6261 0.004 0.000 0.071 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 374 0.002 0.000 0.070 0.000 /data/acsa/current/libs/framework/DGEAttribute.py:207(getValue) 14201 0.028 0.000 0.070 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:376(getitem) 4 0.000 0.000 0.069 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 2815/4 0.021 0.000 0.069 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 2815/4 0.008 0.000 0.069 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 8 0.054 0.007 0.068 0.009 /data/acsa/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 125 0.001 0.000 0.067 0.001 /data/acsa/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 1084/531 0.002 0.000 0.061 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 91 0.000 0.000 0.059 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 91 0.004 0.000 0.059 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 204 0.002 0.000 0.054 0.000 :1054(_find_spec) 42 0.000 0.000 0.051 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 7991/7747 0.005 0.000 0.051 0.000 {method 'update' of 'dict' objects} 531 0.004 0.000 0.050 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:348(__init__) 204 0.000 0.000 0.050 0.000 :1499(find_spec) 204 0.036 0.000 0.049 0.000 :1467(_get_spec) 1 0.000 0.000 0.049 0.049 /usr/lib/python3.11/urllib/request.py:139(urlopen) 1 0.000 0.000 0.048 0.048 /usr/lib/python3.11/urllib/request.py:500(open) 1 0.000 0.000 0.048 0.048 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.048 0.024 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 1 0.000 0.000 0.048 0.048 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.048 0.048 /usr/lib/python3.11/urllib/request.py:1307(do_open) 6261 0.006 0.000 0.047 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 6490 0.014 0.000 0.045 0.000 /usr/lib/python3.11/copy.py:66(copy) 2 0.000 0.000 0.044 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 9685 0.014 0.000 0.043 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:338(_pop) 114 0.041 0.000 0.042 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset)

Other ACSA Websites

Program Directory

Program Directory

Already have an account?

I’m new here

Stay in Touch