Program Directory

Program Directory Search Results

Search Criteria:
Region: Mid Atlantic

The following 22 ACSA member(s) match(es) your search criteria. Click on the organization name for more information.


American University of Sharjah, College of Architecture, Art and Design
PO Box 26666
Sharjah,
United Arab Emirates

Main Phone: 971-6-5152869
Fax: 971-651-52800
E-mail: test@maxx.matrixgroup.net
Website: https://www.aus.edu/caad www.aus.edu https://www.aus.edu/caad/department-of-architecture
#caadaus
Mr. Jason F. Carlow, Head of the Department of Architecture and Associate Professor

Carnegie Mellon University, School of Architecture
500 Forbes Avenue
College of Fine Arts 201
Pittsburgh, PA 15213
United States

Main Phone: 412-268-2355
Fax: 412-268-7819
Website: architecture@cmu.edu www.cmu.edu
Mr. Omar Khan, Head of the School of Architecture

Catholic University of America, School of Architecture and Planning
Edward M. Crough Center for Architectural Studies
620 Michigan Ave NE
Washington, DC 20064
United States

Main Phone: 202-319-5188
Fax: 202-238-2023
E-mail: test@maxx.matrixgroup.net
Website: http://architecture.cua.edu/ http://www.cua.edu/
Mark Ferguson, Dean

Clemson University, School of Architecture
3-131 Lee Hall
Clemson, SC 29634-0503
United States

Main Phone: 864-656-3898
Fax: 864-656-1810
E-mail: test@maxx.matrixgroup.net
Website: http://www.clemson.edu/caah/architecture/
James Corbin Stevens, Director + Professor

Drexel University, Antoinette Westphal College of Media Arts & Design
3101 Chestnut St
Philadelphia, PA 19104
United States

Main Phone: 215-895-0207
E-mail: test@maxx.matrixgroup.net
Website: https://drexel.edu/westphal/ https://drexel.edu/westphal/academics/undergraduate/ARCH/
Dr. Ulrike Altenmueller-Lewis, Department Head, Architecture, Design & Urbanism; Associate Professor

Georgia Institute of Technology, School of Architecture
College of Design
245 Fourth St NW
Atlanta, GA 30332-0155
United States

Main Phone: 404-894-4485
Website: www.arch.gatech.edu www.coa.gatech.edu
Julie Ju-Youn Kim FAIA, William H Harrison Professor and Chair, School of Architecture

Hampton University, School of Engineering and Technology
Department of Architecture
714 Orchard Road
Hampton, VA 23668
United States

Main Phone: 757-727-5440
Fax: 757-728-6680
Website: https://home.hamptonu.edu/engineering/architecture/
Dr. Daya Irene Taylor AIA, NOMA, Chairperson and Associate Professor

Howard University, College of Engineering and Architecture, Department of Architecture
2366 6th Street NW
Washington, DC 20059
United States

Main Phone: 202-806-7424
Website: arch.cea.howard.edu
Dr. John Onyango, Chair

Kennesaw State University, Department of Architecture
1100 South Marietta Parkway
Building N
Marietta, GA 30060-2896
United States

Main Phone: 678-915-7253
Fax: 770-528-7228
E-mail: test@maxx.matrixgroup.net
Website: http://cacm.kennesaw.edu/architecture/index.php https://www.facebook.com/ksuarch/
Jeffrey Collins, Associate Chair of the Department of Architecture and Associate Professor of Architecture

Marywood University, School of Architecture
2300 Adams Avenue
Scranton, PA 18509-1598
United States

Main Phone: 570-340-6063
Fax: 570-961-4522
E-mail: test@maxx.matrixgroup.net
Website: http://www.marywood.edu/architecture/index.html www.marywood.edu
Jodi La Coe, Director

Morgan State University, School of Architecture and Planning
104 CBEIS
1700 East Cold Spring Lane
Baltimore, MD 21251
United States

Main Phone: 443-885-3225
Fax: 443-885-8233
Website: https://www.morgan.edu/sap
Dr. Abimbola Asojo PhD, FAIA, IDEC, LEED AP, NOMA, Dean and Professor

North Carolina State University, School of Architecture, College of Design
50 Pullen Road
Campus Box 7701
Raleigh, NC 27695-7701
United States

Main Phone: 919-515-8350
Fax: 919-515-7330
E-mail: test@maxx.matrixgroup.net
Website: www.design.ncsu.edu
Mr. David Hill, Head of the School of Architecture

Pennsylvania State University, Department of Architecture
121 Stuckeman Family Building
University Park, PA 16802
United States

Main Phone: 814-865-9535
Fax: 814-865-3289
Website: https://arts.psu.edu/academics/department-of-architecture/
Mr. Frank Richard Jacobus, Head of the Department of Architecture

Savannah College of Art and Design, School of Building Arts Department of Architecture
229 Martin Luther King Blvd.
PO Box 3146
Savannah, GA 31402-3146
United States

Main Phone: 912-525-6861
E-mail: test@maxx.matrixgroup.net
Website: www.scad.edu http://www.scad.edu/architecture/index.cfm
Dr. Geoffrey S. Taylor, Dean, School of Building Arts

Temple University, Tyler School of Art and Architecture
Tyler School of Art and Architecture
2001 North 13th Street, Architecture Building
Philadelphia, PA 19122
United States

Main Phone: 215-204-8813
Fax: 215-204-5481
E-mail: test@maxx.matrixgroup.net
Website: https://tyler.temple.edu/
Sasha Eisenman, Associate Professor and Chair of Architecture and Environmental Design

Thomas Jefferson University, College of Architecture and the Built Environment
School House Lane & Henry Avenue
4201 Henry Avenue
Philadelphia, PA 19144-5497
United States

Main Phone: 215-951-2896
Fax: 215-951-2110
E-mail: test@maxx.matrixgroup.net
Website: https://www.jefferson.edu/academics/colleges-schools-institutes/architecture-and-the-built-environment.html
Ms. Barbara Klinkhammer, Executive Dean

University of Maryland, School of Architecture, Planning & Preservation
3835 Campus Drive
College Park, MD 20742-1411
United States

Main Phone: 301-405-8000
Fax: 301-314-9583
E-mail: test@maxx.matrixgroup.net
Website: www.arch.umd.edu
Mohammad Gharipour, Chair/Director of the Architecture Program

University of North Carolina at Charlotte, School of Architecture
9201 University City Blvd.
Charlotte, NC 28223-0001
United States

Main Phone: 704-687-0101
Fax: 704-687-0105
Website: http://www.coaa.uncc.edu/ soa.uncc.edu
Mr. Blaine E. Brownell, Professor and Director

University of Pennsylvania, Stuart Weitzman School of Design
207 Meyerson Hall
210 South 34th Street
Philadelphia, PA 19104-6311
United States

Main Phone: 215-898-5728
Fax: 215-573-2192
E-mail: test@maxx.matrixgroup.net
Website: http://www.design.upenn.edu/architecture
Dr. Frederick Steiner, Dean

University of the District of Columbia, College of Agriculture, Urban Sustainability & Environmental Sciences
4200 Connecticut Avenue NW
Building 32, Suite 104-E
Washington, DC 20008
United States

Main Phone: 202-274-5000
Website: https://www.udc.edu/causes/architecture/
Dr. Anna Franz, Chair & Director

University of Virginia, School of Architecture
Campbell Hall
PO Box 400122
Charlottesville, VA 22904-4122
United States

Main Phone: 434-924-1493
Fax: 434-982-2678
Website: http://www.arch.virginia.edu/
Ms. Jeana Ripple, Chair + Associate Professor

Virginia Tech, School of Architecture
201 Cowgill Hall (0205)
1325 Perry St.
Blacksburg, VA 24061
United States

Main Phone: 540-231-5383
Website: https://arch.vt.edu/
vtarchschool vtarchschool vtarchschool @vtarchschool
Jim Bassett, Director, School of Architecture


1 - 22 of 22 results
Debugging Info
pagedictsize=15897
sqltime = 0.432 s
cpu time = 1.010 s
real time = 1.685 s
memory increase = 21380 kB
fields = Company_region: '2'
action: 'find'
templates =
/data/acsa/current/acsa_org/themes/www/webform/searchRSCompanyPublic1
/data/acsa/current/generic/themes/shared/dgelements/viewphunkyFone
/data/acsa/current/generic/themes/shared/dgelements/viewphunkyFoneNoExt
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', 'searchRSCompanyPublic', 'searchRSCompanyPublic'] | [194, 194, 204, 204]
extra debug info =
libs.framework.WebForm:fillCursor starting at 1774898913.944...
libs.framework.WebForm:fillCursor took 129.100 ms
libs.framework.WebForm:outputSearchResults starting at 1774898915.053...
libs.framework.WebForm:outputSearchResults took 345.530 ms
queries = 481 queries

Total TimeCountAvg TimeQuery
0.0431 call
22 rows
0.043 SELECT DISTINCT hex(`generalLiabilityAgent`.`IndividualId`) AS generalLiabilityAgent___IndividualId, `generalLiabilityAgent`.`EthnicityId` AS generalLiabilityAgent___EthnicityId, `generalLiabilityAgent`.`firstName` AS generalLiabilityAgent___firstName, `generalLiabilityAgent`.`lastName` AS generalLiabilityAgent___lastName, `generalLiabilityAgent`.`prefix` AS generalLiabilityAgent___prefix, `generalLiabilityAgent`.`suffix` AS generalLiabilityAgent___suffix, `generalLiabilityAgent`.`title` AS generalLiabilityAgent___title, `generalLiabilityAgent`.`mxxUpdatedBy` AS generalLiabilityAgent___mxxUpdatedBy, `generalLiabilityAgent`.`enteredBy` AS generalLiabilityAgent___enteredBy, `generalLiabilityAgent`.`gender` AS generalLiabilityAgent___gender, `generalLiabilityAgent`.`SalaryId` AS generalLiabilityAgent___SalaryId, `generalLiabilityAgent`.`ssn` AS generalLiabilityAgent___ssn, `generalLiabilityAgent`.`middleInitial` AS generalLiabilityAgent___middleInitial, `generalLiabilityAgent`.`email` AS ... AND (`Company`.`region`=2 AND `Company`.`CompanyId` IN (1765231560305, 47321949667992, 1765231560389, 1765231559804, 1765231558762, 4750641851269209, 1765231558767, 3488831999312072, 1765231558776, 3507085610319893, 1765231558781, 3302443303567509, 204019536502784, 1765231558786, 1765231559661, 3146862408247566, 34260954120663, 1765231558791, 1765231558796, 1765231558801, 1765231560522, 1765231560729, 1765231558806, 1765231558811, 1765231558816, 1765231559600, 2858932095680693, 1765231558825, 1765231558830, 1765231558889, 15253344423510017, 1765231558835, 1765231558845, 1765231558850, 1765231558854, 1765231559184, 1765231558858, 3117802659512795, 1765231558875, 1765231558880, 872337922588939, 2182281473033183, 3269990530678796, 2875759777546340, 1765231558893, 3862940830663328, 1765231560875, 1765231558897, 1765231559538, 1765231558902, 144650203572601, 68315749810202, 1765231558912, 55040005900821, 1765231558917, 3654750880923685, 1765231558922, 866690040595814, 1765231558927, 60009283061368, 1765231558932, 598301829236655, 1765231560682, 1765231558942, 1765231560639, 1765231559565, 1765231558947, 1716238866712497, 1765231560421, 534796442805769, 1765231559152, 1765231558952, 36728116479000577, 109229608273002, 1765231558965, 1765231558970, 1765231558975, 1765231558980, 2628846402668193, 1765231560711, 1765231560607, 1765231558989, 32579818021191681, 36331119766929412, 1765231559002, 2534773733983148, 1765231559007, 1765231560464, 1765231559012, 1765231559017, 269595097170390, 1765231560916, 1765231559031, 1765231559041, 1765231559036, 109641925135307, 1765231559046, 1765231559051, 1765231559026, 1765231559056, 1765231559065, 1765231559070, 4277259145838594, 124833224460444, 1765231559078, 1765231561021, 1765231559083, 1765231559391, 3689510051250337, 3384434229540, 1765231559098, 1765231559103, 1765231559108, 1765231560697, 4246051913465937, 1765231559116, 1765231559121, 1765231559126, 971779300393710, 1765231560935, 1765231559131, 1765231559825, 5231472029990916, 2655200321994902, 1765231559672, 1765231560155, 1765231559620, 1765231560701, 15808099579330561, 1765231559147, 1765231559157, 1765231560777, 1765231560250, 917718547038473, 3659960676254192, 1765231559175, 1765231559189, 1765231559194, 3000850700042294, 1765231559199, 1765231558840, 284124971533104, 1765231559417, 899074094012546, 1765231559088, 1765231559204, 1765231559209, 3059202125725746, 36645369639075841, 1765231559629, 2989804044156989, 437532613410958, 1765231559412, 1765231560185, 36724482936668161, 36258113922840, 1765231559408, 1765231559348, 1765231558960, 1765231559170, 1765231559214, 1765231559218, 1765231559223, 1765231559887, 1765231559228, 1765231559233, 1765231559238, 1765231559243, 3060748313952544, 1765231559251, 1765231559256, 1765231559264, 1765231559269, 1765231558731, 1765231559279, 1765231559289, 1765231559294, 1765231559299, 1765231559304, 1765231559309, 1765231559314, 1765231559432, 1765231560164, 1765231559319, 1765231559324, 1765231560180, 8774618185887, 1765231559765, 1765231559329, 1765231559334, 1765231559339, 1765231560435, 1765231559344, 1765231559353, 1765231559358, 1765231559363, 1765231559533, 1765231560531, 1765231559368, 1765231559373, 1765231559378, 1765231559383, 1765231559396, 1765231560190, 1765231560568, 1765231559422, 1765231559427, 1765231559437, 54649163880039, 1765231559650, 1765231559441, 1765231559446, 1765231559451, 1765231559461, 544026327515148, 1765231559456, 1765231559466, 1765231559471, 1765231559476, 1765231559481, 1765231559486, 1765231559489, 1765231560458, 3365420409028711, 1765231559882, 1765231559494, 1765231559503, 1765231559508, 1765231559513, 3002010341213277, 1765231559518, 1765231559523))) AND IFNULL(`Company`.`silent`, 2)!=\'1\') AND IFNULL(`Company`.`silent`, "2")=\'2\') AND `Company`.`MembershipId`=`Membership`.`MembershipId`) AND `Membership`.`status`=1) AND `Membership`.`MembershipTypeId` IN (22, 21, 20, 14, 13, 9, 23, 40, 41, 42)) ORDER BY `Company`.`alphaSort`, `Company`.`name` LIMIT 0, 100
0.03011 calls
244 rows
0.003 SELECT * FROM Country ORDER BY orderindex, id
0.01724 calls
54 rows
0.001 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0081 call
0 rows
0.008 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000009B
0.0081 call
1 row
0.008 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000047C
0.0071 call
0 rows
0.007 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000A0
0.0061 call
232 rows
0.006 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`status`=1) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0051 call
1 row
0.005 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B00015BDA) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0055 calls
2 rows
0.001 SELECT * FROM YesNo ORDER BY orderindex, id
0.0055 calls
1 row
0.001 SELECT version from databasemap;
0.0052 calls
21 rows
0.002 SELECT * FROM MembershipType ORDER BY orderindex, id
0.0041 call
0 rows
0.004 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000010F
0.0042 calls
1 row
0.002 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0xb
0.0041 call
0 rows
0.004 COMMIT
0.0041 call
1 row
0.004 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000009D ORDER BY `Address`.`zip`
0.0041 call
2 rows
0.004 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000A0
0.0041 call
0 rows
0.004 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000005DB
0.0041 call
1 row
0.004 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`=0x19B000000A3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
1 row
0.003 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0xC656300000049) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0031 call
1 row
0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000000A3 ORDER BY `Address`.`zip`
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000186
0.0031 call
3 rows
0.003 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000047C
0.0031 call
1 row
0.003 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`=0x19B0000009E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x8C23AD00000020 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000100
0.0031 call
1 row
0.003 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`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000A2 ORDER BY `Address`.`zip`
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001F0
0.0031 call
0 rows
0.003 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000000A0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0031 call
0 rows
0.003 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`=0x8C23AD00000015 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
0 rows
0.003 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`=0x8C23AD0000000B AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
1 row
0.003 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`=0xE15DA0000007B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows
0.003 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B0000009B=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0031 call
1 row
0.003 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`=0x19B000000A2 ORDER BY `Address`.`zip`
0.0031 call
11 rows
0.003 SELECT * FROM SocialNetwork ORDER BY orderindex, id
0.0031 call
1 row
0.003 SELECT COUNT(DISTINCT `Company`.`CompanyId`) AS count FROM (Company, Membership) WHERE ((((((`Company`.`companyStatusId`=0x1 AND (`Company`.`region`=2 AND `Company`.`CompanyId` IN (1765231560305, 47321949667992, 1765231560389, 1765231559804, 1765231558762, 4750641851269209, 1765231558767, 3488831999312072, 1765231558776, 3507085610319893, 1765231558781, 3302443303567509, 204019536502784, 1765231558786, 1765231559661, 3146862408247566, 34260954120663, 1765231558791, 1765231558796, 1765231558801, 1765231560522, 1765231560729, 1765231558806, 1765231558811, 1765231558816, 1765231559600, 2858932095680693, 1765231558825, 1765231558830, 1765231558889, 15253344423510017, 1765231558835, 1765231558845, 1765231558850, 1765231558854, 1765231559184, 1765231558858, 3117802659512795, 1765231558875, 1765231558880, 872337922588939, 2182281473033183, 3269990530678796, 2875759777546340, 1765231558893, 3862940830663328, 1765231560875, 1765231558897, 1765231559538, 1765231558902, 144650203572601, 68315749810202, 1765231558912, 55040005900821, 1765231558917, 3654750880923685, 1765231558922, 866690040595814, 1765231558927, 60009283061368, 1765231558932, 598301829236655, 1765231560682, 1765231558942, 1765231560639, 1765231559565, 1765231558947, 1716238866712497, 1765231560421, 534796442805769, 1765231559152, 1765231558952, 36728116479000577, 109229608273002, 1765231558965, 1765231558970, 1765231558975, 1765231558980, 2628846402668193, 1765231560711, 1765231560607, 1765231558989, 32579818021191681, 36331119766929412, 1765231559002, 2534773733983148, 1765231559007, 1765231560464, 1765231559012, 1765231559017, 269595097170390, 1765231560916, 1765231559031, 1765231559041, 1765231559036, 109641925135307, 1765231559046, 1765231559051, 1765231559026, 1765231559056, 1765231559065, 1765231559070, 4277259145838594, 124833224460444, 1765231559078, 1765231561021, 1765231559083, 1765231559391, 3689510051250337, 3384434229540, 1765231559098, 1765231559103, 1765231559108, 1765231560697, 4246051913465937, 1765231559116, 1765231559121, 1765231559126, 971779300393710, 1765231560935, 1765231559131, 1765231559825, 5231472029990916, 2655200321994902, 1765231559672, 1765231560155, 1765231559620, 1765231560701, 15808099579330561, 1765231559147, 1765231559157, 1765231560777, 1765231560250, 917718547038473, 3659960676254192, 1765231559175, 1765231559189, 1765231559194, 3000850700042294, 1765231559199, 1765231558840, 284124971533104, 1765231559417, 899074094012546, 1765231559088, 1765231559204, 1765231559209, 3059202125725746, 36645369639075841, 1765231559629, 2989804044156989, 437532613410958, 1765231559412, 1765231560185, 36724482936668161, 36258113922840, 1765231559408, 1765231559348, 1765231558960, 1765231559170, 1765231559214, 1765231559218, 1765231559223, 1765231559887, 1765231559228, 1765231559233, 1765231559238, 1765231559243, 3060748313952544, 1765231559251, 1765231559256, 1765231559264, 1765231559269, 1765231558731, 1765231559279, 1765231559289, 1765231559294, 1765231559299, 1765231559304, 1765231559309, 1765231559314, 1765231559432, 1765231560164, 1765231559319, 1765231559324, 1765231560180, 8774618185887, 1765231559765, 1765231559329, 1765231559334, 1765231559339, 1765231560435, 1765231559344, 1765231559353, 1765231559358, 1765231559363, 1765231559533, 1765231560531, 1765231559368, 1765231559373, 1765231559378, 1765231559383, 1765231559396, 1765231560190, 1765231560568, 1765231559422, 1765231559427, 1765231559437, 54649163880039, 1765231559650, 1765231559441, 1765231559446, 1765231559451, 1765231559461, 544026327515148, 1765231559456, 1765231559466, 1765231559471, 1765231559476, 1765231559481, 1765231559486, 1765231559489, 1765231560458, 3365420409028711, 1765231559882, 1765231559494, 1765231559503, 1765231559508, 1765231559513, 3002010341213277, 1765231559518, 1765231559523))) AND IFNULL(`Company`.`silent`, 2)!=\'1\') AND IFNULL(`Company`.`silent`, "2")=\'2\') AND `Company`.`MembershipId`=`Membership`.`MembershipId`) AND `Membership`.`status`=1) AND `Membership`.`MembershipTypeId` IN (22, 21, 20, 14, 13, 9, 23, 40, 41, 42))
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000169
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001AB
0.0031 call
0 rows
0.003 START TRANSACTION
0.0031 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 (Individual, Company) WHERE `Company`.`CompanyId`=0x8C23AD00000001 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x8C23AD00000011 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1EECA0000000C
0.0021 call
1 row
0.002 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`=0xDA6450000005A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
4 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000346
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000215
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000807
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000DB
0.0021 call
0 rows
0.002 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`=0x8C23AD00000012 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 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 (Individual, Company) WHERE `Company`.`CompanyId`=0x8C23AD00000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000032F
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001B0
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000029C
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000AE
0.0021 call
1 row
0.002 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`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000009D ORDER BY `Address`.`zip`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002E4
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000105
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Company) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002C8
0.0021 call
1 row
0.002 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`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000047E ORDER BY `Address`.`zip`
0.0021 call
1 row
0.002 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`=0x19B000000B0 ORDER BY `Address`.`zip`
0.0021 call
0 rows
0.002 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B0000047C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0024 calls
7 rows
0.001 SELECT * FROM Region ORDER BY orderindex, id
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B0000047F ORDER BY `Address`.`zip`
0.0021 call
0 rows
0.002 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`=0x8C23AD0000001D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
1 row
0.002 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`=0x5A460C00000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (1765231560305, 47321949667992, 1765231560389, 1765231559804, 1765231558762, 4750641851269209, 1765231558767, 3488831999312072, 1765231558776, 3507085610319893, 1765231558781, 3302443303567509, 204019536502784, 1765231558786, 1765231559661, 3146862408247566, 34260954120663, 1765231558791, 1765231558796, 1765231558801, 1765231560522, 1765231560729, 1765231558806, 1765231558811, 1765231558816, 1765231559600, 2858932095680693, 1765231558825, 1765231558830, 1765231558889, 15253344423510017, 1765231558835, 1765231558845, 1765231558850, 1765231558854, 1765231559184, 1765231558858, 3117802659512795, 1765231558875, 1765231558880, 872337922588939, 2182281473033183, 3269990530678796, 2875759777546340, 1765231558893, 3862940830663328, 1765231560875, 1765231558897, 1765231559538, 1765231558902, 144650203572601, 68315749810202, 1765231558912, 55040005900821, 1765231558917, 3654750880923685, 1765231558922, 866690040595814, 1765231558927, 60009283061368, 1765231558932, 598301829236655, 1765231560682, 1765231558942, 1765231560639, 1765231559565, 1765231558947, 1716238866712497, 1765231560421, 534796442805769, 1765231559152, 1765231558952, 36728116479000577, 109229608273002, 1765231558965, 1765231558970, 1765231558975, 1765231558980, 2628846402668193, 1765231560711, 1765231560607, 1765231558989, 32579818021191681, 36331119766929412, 1765231559002, 2534773733983148, 1765231559007, 1765231560464, 1765231559012, 1765231559017, 269595097170390, 1765231560916, 1765231559031, 1765231559041, 1765231559036, 109641925135307, 1765231559046, 1765231559051, 1765231559026, 1765231559056, 1765231559065, 1765231559070, 4277259145838594, 124833224460444, 1765231559078, 1765231561021, 1765231559083, 1765231559391, 3689510051250337, 3384434229540, 1765231559098, 1765231559103, 1765231559108, 1765231560697, 4246051913465937, 1765231559116, 1765231559121, 1765231559126, 971779300393710, 1765231560935, 1765231559131, 1765231559825, 5231472029990916, 2655200321994902, 1765231559672, 1765231560155, 1765231559620, 1765231560701, 15808099579330561, 1765231559147, 1765231559157, 1765231560777, 1765231560250, 917718547038473, 3659960676254192, 1765231559175, 1765231559189, 1765231559194, 3000850700042294, 1765231559199, 1765231558840, 284124971533104, 1765231559417, 899074094012546, 1765231559088, 1765231559204, 1765231559209, 3059202125725746, 36645369639075841, 1765231559629, 2989804044156989, 437532613410958, 1765231559412, 1765231560185, 36724482936668161, 36258113922840, 1765231559408, 1765231559348, 1765231558960, 1765231559170, 1765231559214, 1765231559218, 1765231559223, 1765231559887, 1765231559228, 1765231559233, 1765231559238, 1765231559243, 3060748313952544, 1765231559251, 1765231559256, 1765231559264, 1765231559269, 1765231558731, 1765231559279, 1765231559289, 1765231559294, 1765231559299, 1765231559304, 1765231559309, 1765231559314, 1765231559432, 1765231560164, 1765231559319, 1765231559324, 1765231560180, 8774618185887, 1765231559765, 1765231559329, 1765231559334, 1765231559339, 1765231560435, 1765231559344, 1765231559353, 1765231559358, 1765231559363, 1765231559533, 1765231560531, 1765231559368, 1765231559373, 1765231559378, 1765231559383, 1765231559396, 1765231560190, 1765231560568, 1765231559422, 1765231559427, 1765231559437, 54649163880039, 1765231559650, 1765231559441, 1765231559446, 1765231559451, 1765231559461, 544026327515148, 1765231559456, 1765231559466, 1765231559471, 1765231559476, 1765231559481, 1765231559486, 1765231559489, 1765231560458, 3365420409028711, 1765231559882, 1765231559494, 1765231559503, 1765231559508, 1765231559513, 3002010341213277, 1765231559518, 1765231559523)) AND `Relationship`.`relationType` IN (1, 2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B0000009E ORDER BY `Address`.`zip`
0.0022 calls
2 rows
0.001 SELECT * FROM FundingSource ORDER BY orderindex, id
0.0021 call
11 rows
0.002 SELECT * FROM Accreditation ORDER BY orderindex, id
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000009B ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
1 row
0.002 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`=0x7E5AE000010F1 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows
0.002 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`=0x8C23AD00000010 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
8 rows
0.002 SELECT * FROM TermType ORDER BY orderindex, id
0.0021 call
54 rows
0.002 select id, abbreviation from StateProvince
0.0021 call
2 rows
0.002 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000009B
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x7CC43000000C9) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x57D7100000119) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
0 rows
0.002 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Company, File) WHERE `Company`.`highResImageId`=`File`.`FileId` AND `Company`.`CompanyId`=0x8C23AD00000001
0.0022 calls
12 rows
0.001 SELECT * FROM Month ORDER BY orderindex, id
0.0021 call
1 row
0.002 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B00050B13) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
0 rows
0.002 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`=0x8C23AD00000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x3F9500000F1B) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000047C ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows
0.001 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B0000009B=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0011 call
0 rows
0.001 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B0000047C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x6657D0000073F) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B0005398A) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0xB866000000023) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
0 rows
0.001 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000000A0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0011 call
1 row
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`=0x19B000001F3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x3E02E00000845) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B000B045C) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0xD65F800000047) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
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`=0x19B0000047E ORDER BY `Address`.`zip`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x9A0000000C5) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x55267000002B7) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B000327FD) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0xCF0B900000089) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B000B4802) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B0005417C) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B0004804B) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B0002A498) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x10385000024BA) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`mainPhone`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`department`, `Company`.`region`, `Company`.`numFullTimeEmployees`, `Company`.`extraPublications`, `Company`.`customerType`, `Company`.`numFullTimeFaculty`, `Company`.`numFullTimeStudents`, `Company`.`numPartTimeFaculty`, `Company`.`numPartTimeStudents`, `Company`.`percentFemaleStudents`, `Company`.`percentMinorityStudents`, `Company`.`percentInternationalStudents`, `Company`.`percentOutOfStateStudents`, `Company`.`tuition`, `Company`.`tuitionResident`, `Company`.`tuitionNonresident`, `Company`.`tuitionUndergraduate`, `Company`.`tuitionResidentUndergraduate`, `Company`.`tuitionNonresidentUndergraduate`, `Company`.`tuitionGraduate`, `Company`.`tuitionResidentGraduate`, `Company`.`tuitionNonresidentGraduate`, `Company`.`fundingSource`, `Company`.`percentFederalAid`, `Company`.`percentUniversityAid`, `Company`.`percentDepartmentAid`, `Company`.`percentScholarship`, `Company`.`feesForArchitectureStudents`, `Company`.`averageAnnualScholarship`, `Company`.`guideSummary`, `Company`.`guideUniversitySetting`, `Company`.`guideSchoolPhilosophy`, `Company`.`guideProgramDescription`, `Company`.`guideAreasOfFocus`, `Company`.`guideSpecialActivities`, `Company`.`guideFacilities`, `Company`.`guideScholarshipsFinAid`, `Company`.`numFilledSlots`, `Company`.`preProfessionalOffered`, `Company`.`postProfessionalOffered`, `Company`.`postProfessionalPrograms`, `Company`.`studyAbroadOffered`, `Company`.`communityDesignOffered`, `Company`.`specialProgramsOffered`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, BranchAffiliationHistory, Branch, Company) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x19B0005A4CF) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row
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`=0xBD5D600001123 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`=0x8C23AD00000009 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
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`=0xE15E90000000B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
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`=0x19B0000047F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000A0 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
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`=0x19B0000009D 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`=0x8C23AD00000026 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
8 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000001AD ORDER BY `Address`.`zip`
0.0011 call
5 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000001F2 ORDER BY `Address`.`zip`
0.0011 call
8 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000188 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`=0x8C23AD00000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
9 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000001B2 ORDER BY `Address`.`zip`
0.0011 call
1 row
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`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000047E ORDER BY `Address`.`zip`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000029C ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
64 rows
0.001 SELECT * FROM DegreeLevel ORDER BY orderindex, id
0.0011 call
1 row
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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B0000047E ORDER BY `Address`.`zip`
0.0011 call
1 row
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`=0x11D85B0000001F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
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`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001B2 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`=0x8C23AD00000001 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 call
1 row
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`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001F2 ORDER BY `Address`.`zip`
0.0011 call
7 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000809 ORDER BY `Address`.`zip`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000215
0.0011 call
10 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000331 ORDER BY `Address`.`zip`
0.0011 call
11 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000002E6 ORDER BY `Address`.`zip`
0.0011 call
1 row
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`=0x60C0D0000050F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row
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`=0x19B0000016B ORDER BY `Address`.`zip`
0.0011 call
2 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000000A2 ORDER BY `Address`.`zip`
0.0011 call
7 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B0000016B ORDER BY `Address`.`zip`
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000029C
0.0011 call
1 row
0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000215 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x11573E000000B8 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
5 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B0000009D ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x4FAD6000000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
10 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000005DD ORDER BY `Address`.`zip`
0.0001 call
3 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000000B0 ORDER BY `Address`.`zip`
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`=0x8C23AD00000022 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
4 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000217 ORDER BY `Address`.`zip`
0.0001 call
12 rows
0.000 SELECT * FROM DegreeDiscipline ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001B0 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
6 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000348 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000346
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000331 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000002CA ORDER BY `Address`.`zip`
0.0001 call
167 rows
0.000 SELECT * FROM webselect
0.0001 call
3 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B0000029E ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000809 ORDER BY `Address`.`zip`
0.0001 call
4 rows
0.000 SELECT * FROM CompanyStatus ORDER BY orderindex, id
0.0001 call
2 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000107 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB699A00000014 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000807
0.0001 call
3 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000102 ORDER BY `Address`.`zip`
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`=0x8C23AD00000025 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000105 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000002CA ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001F0 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
4 rows
0.000 SELECT * FROM CustomerType ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x8162C200000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x81949400000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x893D100000005 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
2 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B00000111 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB2C0900001132 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000105
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000217 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x1EECA0000000D ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000002E6 ORDER BY `Address`.`zip`
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000100
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xA59CE0000027D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000010F ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000032F
0.0001 call
2 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x19B000000DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B00000112 ORDER BY `Address`.`zip`
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`=0x8C23AD00000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B00000108 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000107 ORDER BY `Address`.`zip`
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000005DB
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001B0
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000029E ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000032F ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000AE ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002C8 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x3C1E00002EE4 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`=0x8C23AD0000001E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000005DB ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB78C10000056C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1EECA0000000C ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000107 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1EECA0000000C
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001AD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000100 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000AE
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000B0 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000102 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B00000349 ORDER BY `Address`.`zip`
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`=0x8C23AD0000000F ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001AB ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x1EECA0000000D ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000001F3 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000DB ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000029E ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000111 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000186
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002E4
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000169 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001F0
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000005DE ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x2
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001F2 ORDER BY `Address`.`zip`
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002C8
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000807 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000000B1 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000188 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000186 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000010F
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002E4 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000169
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000107 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000809 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB2CD30000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000346 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001F2 ORDER BY `Address`.`zip`
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`=0x8C23AD0000001F AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000108 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000217 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000348 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000029E ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000331 ORDER BY `Address`.`zip`
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`=0x8C23AD00000018 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000016B ORDER BY `Address`.`zip`
0.0001 call
2 rows
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000DB
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`=0x8C23AD00000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001AB
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000188 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001B2 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000005DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B000000B1 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x1EF4A000000C7 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`=0x8C23AD00000013 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B0000010F=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000005DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000A2 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B0000029F ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001B2 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000331 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B0000080A ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x4
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000102 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000002E6 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x1094B00001EFD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B0000016C ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001AD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000B0 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x18D18000024DF ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000002CA ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000111 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000001AD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B00000189 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000001B3 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`=0x8C23AD0000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000111 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`=0x8C23AD00000016 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000809 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B0000016B ORDER BY `Address`.`zip`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-03-30 15:28:33',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C23AD00000000, `path`='forms/CompanyFormPublic/search', `formName`='acsa_CompanyFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='2010741', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='525217', `startTime`='2026-03-30 15:28:33', `sessionId`=0x4C4868E94FD43C90, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_region\\':\\'2\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.158'
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000348 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000102 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B00000332 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x3C1E00002EE4 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x37BE00000D61 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B0000029C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B0000010F=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB8A0C000001C8 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x552E0500000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000001AE ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000005DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xBD2D8000008F0 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000100=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x1EECA0000000D ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000002E6 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x15757700000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000002CB ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x9
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000188 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000002CA ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B000000DD ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x82ADDA00000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x13A6200000084 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`=0x8C23AD00000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000348 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x130A7F00000005 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`=0x8C23AD00000023 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB2973000006A3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x1EECA0000000D ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB27AA00000969 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x19B00000217 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x19B000002E7 ORDER BY `Address`.`zip`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xDBAA30000000F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000807=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB9C9000000330 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000218 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B000002CB AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xE349A00000026 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000000AE=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1160C100000063 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xF694700000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000005DB=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x5028E500000029 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xF488000000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B0000029F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB3F01000005B4 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xAB6B7000000E3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1C33E00000038 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000215=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B000002E7 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x118D090000002B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000100=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x48F5000005BB AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x81C6F00000014 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xDA635000000E4 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xF399D00000002 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB6DDF00000883 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000038 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000189 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xD9FC3000001B6 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B000001AE AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000002E4=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000001B0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x16B0000000E0 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x130A8000000002 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x12366200000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB6B860000046F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B0000080A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xD9900000055B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x9EE0A00000864 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x18D18000024DF AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xAF5F30000073B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xC481A00000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000807=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000332 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000001B0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B000001B3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCD1D100000260 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x10A0DD0000001F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1094B00001EFD AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000215=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B0000032F=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000112 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xDA757000002C8 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x3913E00000054 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xADFCE000001A3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xC60D400000007 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xED20C0000004A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xBD2D300000D72 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB297C000001F1 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xD027F00000139 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCDB12000000BD AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000346=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xAB1F300000362 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xAAE1700000746 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`=0x8C23AD00000019 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B0000029C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x1EECA0000000C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xE66E20000007D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x893E600000023 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000105=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xDA8DC00000279 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x1EECA0000000C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B0000016C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B0000BFE0 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000002C8=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1232910000000B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B000005DE AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x19B00000349 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xC382000000284 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1EF4A000000C7 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xF3BD200000039 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000001F0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xAB2A900000584 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000000DB=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x81A4D300000002 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
3 rows
0.000 SELECT * FROM AddressType ORDER BY orderindex, id
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xC32820000014F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xBD2D90000040B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x8084A500000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB878300000B93 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x108D2100000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xA041C00000487 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xA90660000055B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000002C8=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000169=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xF268D00000035 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB7A53000002FE AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x11574400000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B00000186=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country, Company, Company2Country) WHERE (0x19B000001AB=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B0000032F=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000186=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
1 row
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xB768200000296 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000346=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000000DB=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000105=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000000AE=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000005DB=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B00000169=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000002E4=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000001F0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000DB
0.0001 call
0 rows
0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company2Service, Company) WHERE (0x19B000001AB=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000047C
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002E4
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000105
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000010F
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000009B
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000032F
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000A0
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000000AE
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001F0
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000186
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1EECA0000000C
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000100
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001B0
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000346
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000001AB
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000005DB
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000807
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000215
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B000002C8
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B00000169
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x19B0000029C