Program Directory

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:



   
Debugging Info
pagedictsize=0
sqltime = 0.030 s
cpu time = 0.910 s
real time = 1.085 s
memory increase = 14808 kB
fields =
templates =
/data/acsa/current/acsa_org/themes/www/webform/searchCompanyPublic1
/data/acsa/current/generic/themes/shared/dgelements/checkboxes
/data/acsa/current/generic/themes/shared/dgelements/group
/data/acsa/current/generic/themes/shared/dgelements/input
/data/acsa/current/generic/themes/shared/dgelements/phunkyFone
/data/acsa/current/generic/themes/shared/dgelements/radio
/data/acsa/current/generic/themes/shared/dgelements/select
/data/acsa/current/generic/themes/shared/dgelements/view
/data/acsa/current/generic/themes/shared/dgelements/viewphunkyFone
/data/acsa/current/generic/themes/shared/dgelements/zipradius
scrapeAndDrape (CACHED) stub: https://www.acsa.maxx.matrixdev.net/schools-faculty/find-a-school (/data/acsa/current/acsa_org/cachedFiles//cachedStub___forms__CompanyFormPublic__search)
dg = ['searchCompanyPublic', 'searchCompanyPublic'] | [194, 194]
extra debug info =
queries = 69 queries

Total TimeCountAvg TimeQuery
0.0041 call
0 rows
0.004 COMMIT
0.0042 calls
244 rows
0.002 SELECT * FROM Country ORDER BY orderindex, id
0.00412 calls
21 rows
0.000 SELECT * FROM MembershipType ORDER BY orderindex, id
0.00312 calls
1 row
0.000 SELECT version from databasemap;
0.0021 call
167 rows
0.002 SELECT * FROM webselect
0.0022 calls
54 rows
0.001 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0022 calls
244 rows
0.001 SELECT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country) ORDER BY orderindex
0.0011 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`=0x8C22830000000B AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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`=0x8C228300000001 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0012 calls
0 rows
0.000 SELECT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service) ORDER BY orderindex
0.0011 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 (Address, Branch) WHERE `Address`.`AddressId`=0x8C228300000018 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 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 (Address, Branch) WHERE `Address`.`AddressId`=0x8C228300000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 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`=0x8C228300000026 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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`=0x8C228300000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 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 (Address, Branch) WHERE `Address`.`AddressId`=0x8C228300000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 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`=0x8C228300000001 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 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`=0x8C228300000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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 (Address, Branch) WHERE `Address`.`AddressId`=0x8C228300000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 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`=0x8C228300000017 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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 (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C228300000012 ORDER BY `Address`.`zip`
0.0011 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`=0x8C228300000020 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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`=0x8C22830000001A AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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`=0x8C228300000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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 (Address, Branch) WHERE `Address`.`AddressId`=0x8C228300000013 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000023 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
3 rows
0.000 SELECT * FROM AddressType ORDER BY orderindex, id
0.0001 call
2 rows
0.000 SELECT * FROM YesNo ORDER BY orderindex, id
0.0001 call
7 rows
0.000 SELECT * FROM Region ORDER BY orderindex, id
0.0001 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 (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C22830000000F ORDER BY `Address`.`zip`
0.0001 call
0 rows
0.000 START TRANSACTION
0.0001 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`=0x8C22830000001D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 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`=0x8C22830000001B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000027 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-03-30 13:50:38',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C228300000000, `path`='forms/CompanyFormPublic/search', `formName`='acsa_CompanyFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='1996872', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='515225', `startTime`='2026-03-30 13:50:38', `sessionId`=0x587D346B3CEB5617, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.158'
0.0001 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`=0x8C228300000014 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000024 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C22830000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000009 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000011 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000021 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C22830000001E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 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`=0x8C228300000010 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE