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

1 call
0 rows

0.003

COMMIT

0.002

12 calls
1 row

0.000

SELECT version from databasemap;

0.002

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

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

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

0.000

2 calls
0 rows

0.000

SELECT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service) 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`=0x833E0000000023 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`=0x833E0000000012 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`=0x833E000000001A 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 (Address, Branch) WHERE `Address`.`AddressId`=0x833E0000000010 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 (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x833E000000000F 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`=0x833E0000000017 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`=0x833E000000001D 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 (Address, Branch) WHERE `Address`.`AddressId`=0x833E0000000013 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`=0x833E000000000B 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`=0x833E0000000008 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 (Address, Branch) WHERE `Address`.`AddressId`=0x833E0000000024 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-11-05 15:20:23',`mxxCreatedBy`=NULL, `PageRequestId`=0x833E0000000000, `path`='forms/CompanyFormPublic/search', `formName`='acsa_CompanyFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='1368226', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='365566', `startTime`='2025-11-05 15:20:23', `sessionId`=0x100CE695B9F9BB7, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.40'

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`=0x833E0000000027 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`=0x833E0000000021 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`=0x833E0000000003 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`=0x833E0000000005 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 (Address, Branch) WHERE `Address`.`AddressId`=0x833E000000001B 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`=0x833E0000000009 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`=0x833E0000000014 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`=0x833E0000000018 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`=0x833E0000000011 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`=0x833E000000001E 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`=0x833E0000000004 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`=0x833E0000000006 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`=0x833E000000000C 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
7 rows

0.000

SELECT * FROM Region ORDER BY orderindex, id

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

START TRANSACTION

1961079 function calls (1939215 primitive calls) in 1.762 seconds Ordered by: cumulative time List reduced from 2396 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.762 1.762 /data/acsa/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 1.506 1.506 /data/acsa/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.470 1.470 /data/acsa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.470 1.470 /data/acsa/current/acsa_org/sites/www/forms/acsa_CompanyFormPublic.py:170(search) 1 0.000 0.000 1.470 1.470 /data/acsa/current/generic/sites/www/forms/CompanyFormPublic.py:87(search) 1 0.000 0.000 1.457 1.457 /data/acsa/current/libs/framework/WebForm.py:1089(search) 1 0.000 0.000 0.890 0.890 /data/acsa/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.890 0.890 /data/acsa/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 0.650 0.650 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.649 0.649 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 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:1530(getSearchHTML) 13 0.000 0.000 0.425 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 13 0.000 0.000 0.424 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 13 0.000 0.000 0.424 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 13 0.000 0.000 0.422 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 13 0.000 0.000 0.422 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 13 0.015 0.001 0.420 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.383 0.383 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:530(_addStylesAndScripts) 318 0.002 0.000 0.346 0.001 /data/acsa/current/libs/framework/DTWrapper.py:47(__call__) 2 0.000 0.000 0.346 0.173 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:362(rebuildSoup) 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.312 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 5010/318 0.047 0.000 0.311 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 34 0.004 0.000 0.249 0.007 /data/acsa/current/libs/framework/DGESelect.py:36(getEditHTML) 42 0.009 0.000 0.246 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_In.py:665(renderwob) 1 0.000 0.000 0.244 0.244 /data/acsa/current/libs/framework/WebManager.py:88(createNewHandler) 1 0.000 0.000 0.244 0.244 /data/acsa/current/libs/framework/WebSite.py:91(__init__) 1 0.000 0.000 0.240 0.240 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:718(process) 1 0.000 0.000 0.226 0.226 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:498(_includeMaxxJavascript) 5080 0.029 0.000 0.218 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 9 0.000 0.000 0.217 0.024 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 9 0.000 0.000 0.217 0.024 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 9 0.000 0.000 0.215 0.024 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 19 0.000 0.000 0.215 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 19 0.005 0.000 0.215 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 206/128 0.001 0.000 0.200 0.002 :1165(_find_and_load) 346/157 0.004 0.000 0.198 0.001 {built-in method builtins.exec} 206/128 0.001 0.000 0.197 0.002 :1120(_find_and_load_unlocked) 6/4 0.000 0.000 0.194 0.049 /data/acsa/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 106 0.001 0.000 0.193 0.002 /data/acsa/current/libs/framework/DGEAttribute.py:138(getBBTDictionary) 211/132 0.001 0.000 0.187 0.001 :666(_load_unlocked) 6/4 0.000 0.000 0.184 0.046 /data/acsa/current/libs/framework/DGEAssoc.py:42(getEditHTML) 209/132 0.000 0.000 0.182 0.001 :934(exec_module) 6333 0.009 0.000 0.176 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 443/253 0.000 0.000 0.173 0.001 :233(_call_with_frames_removed) 8 0.000 0.000 0.166 0.021 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 1 0.000 0.000 0.157 0.157 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:477(_includeMaxxCSS) 28219/27790 0.024 0.000 0.152 0.000 /data/acsa/current/libs/framework/BaseHandler.py:1471(mxxImporter) 6333 0.010 0.000 0.135 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 2370/2155 0.003 0.000 0.134 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 1 0.004 0.004 0.128 0.128 /data/acsa/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups) 125 0.001 0.000 0.123 0.001 /data/acsa/current/libs/framework/DGEAttribute.py:57(getEditHTML) 28244/27794 0.025 0.000 0.121 0.000 {built-in method builtins.__import__} 4 0.000 0.000 0.120 0.030 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 2847/4 0.032 0.000 0.120 0.030 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 2847/4 0.013 0.000 0.120 0.030 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 7 0.000 0.000 0.120 0.017 /data/acsa/current/libs/framework/DGEMethod.py:90(getBBTDictionary) 7 0.000 0.000 0.120 0.017 /data/acsa/current/libs/framework/DGEMethod.py:107(getDataDictionary) 8305 0.021 0.000 0.120 0.000 /data/acsa/current/libs/framework/MaxxDTML.py:29(render) 8 0.000 0.000 0.116 0.014 /data/acsa/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 1 0.000 0.000 0.112 0.112 /data/acsa/current/libs/framework/DisplayGroup.py:311(initialize) 2125 0.005 0.000 0.111 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 7 0.000 0.000 0.106 0.015 /data/acsa/current/libs/framework/DGEMethod.py:31(getEditHTML) 6333 0.006 0.000 0.099 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 18 0.000 0.000 0.095 0.005 /data/acsa/current/libs/utils/htmlTools.py:100(cleanHTML) 4 0.002 0.001 0.093 0.023 /data/acsa/current/libs/framework/DGEObjectMultiSelect.py:52(getEditHTML) 2 0.000 0.000 0.093 0.046 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 14093 0.010 0.000 0.091 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 94490 0.086 0.000 0.086 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 1 0.000 0.000 0.086 0.086 /data/acsa/current/acsa_org/classes/acsa_ScrapeAndDrape.py:43(_manipulateLogin) 52 0.000 0.000 0.085 0.002 /usr/lib/python3.11/re/__init__.py:225(compile) 52 0.001 0.000 0.085 0.002 /usr/lib/python3.11/re/__init__.py:272(_compile) 42 0.000 0.000 0.084 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 2 0.001 0.000 0.076 0.038 /data/acsa/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML) 8 0.004 0.001 0.075 0.009 /data/acsa/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile) 8 0.055 0.007 0.070 0.009 /data/acsa/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 6333 0.012 0.000 0.069 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 115 0.001 0.000 0.068 0.001 /data/acsa/current/libs/framework/DGEInput.py:28(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:206(getValue) 125 0.001 0.000 0.067 0.001 /data/acsa/current/libs/framework/DGEAttribute.py:44(massageDictForEditHTML) 1 0.000 0.000 0.064 0.064 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:406(_applyTitle) 4198/4186 0.004 0.000 0.061 0.000 /data/acsa/current/libs/framework/LazyDict.py:186(__getitem__) 42 0.000 0.000 0.061 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 14203 0.043 0.000 0.057 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 10094 0.026 0.000 0.054 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:314(charsUntil) 2138 0.010 0.000 0.054 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 1084/531 0.002 0.000 0.053 0.000 /data/acsa/current/libs/PLayer/PersistentObject.py:108(new_init) 1 0.000 0.000 0.051 0.051 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:578(_fixStubAuthLinks) 283/282 0.040 0.000 0.051 0.000 {built-in method builtins.__build_class__} 114 0.049 0.000 0.050 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 6977 0.010 0.000 0.050 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/formatter.py:75(substitute) 666 0.001 0.000 0.049 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP) 8015/7771 0.003 0.000 0.049 0.000 {method 'update' of 'dict' objects} 1 0.000 0.000 0.048 0.048 /data/acsa/current/libs/framework/baseScrapeAndDrape.py:707(_drape) 1 0.000 0.000 0.047 0.047 /data/acsa/current/libs/framework/BaseHandler.py:1600(writeCachedFile) 502/462 0.001 0.000 0.047 0.000 :1207(_handle_fromlist) 1 0.000 0.000 0.046 0.046 /usr/lib/python3.11/urllib/request.py:139(urlopen) 1 0.000 0.000 0.045 0.045 /usr/lib/python3.11/urllib/request.py:500(open)

Other ACSA Websites

Program Directory

Program Directory

Already have an account?

I’m new here

Stay in Touch