Program Directory

Program Directory Search Results

Search Criteria:
Region: West Central

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


Drury University, Hammons School of Architecture
900 North Benton Avenue
Springfield, MO 65802
United States

Main Phone: 417-873-7580
Fax: 417-873-7446
E-mail: test@maxx.matrixgroup.net
Website: http://www.drury.edu/architecture
Dr. Robert Weddle, Professor + Dean

Dunwoody College of Technology, Department of Architecture
818 Dunwoody Boulevard
Minneapolis, MN 55403
United States

Main Phone: 612-381-8237
Website: www.dunwoody.edu http://www.dunwoody.edu/construction/architecture/
Trevor Bullen, Dean

Iowa State University, Department of Architecture
146 College of Design
Ames, IA 50011-3093
United States

Main Phone: 515-294-2557
Fax: 515-294-1440
E-mail: test@maxx.matrixgroup.net

Cameron Campbell, Interim Department Chair

Kansas State University, College of Architecture, Planning & Design
211 Seaton Hall
Manhattan, KS 66506-2901
United States

Main Phone: 785-532-5953
Fax: 785-532-6722
E-mail: test@maxx.matrixgroup.net
Website: http://apdesign.k-state.edu/arch/
Mr. Michael A. McClure, Dean

North Dakota State University, Dept of Architecture & Landscape Architecture
NDSU Downtown
650 NP Avenue
Fargo, ND 58102
United States

Main Phone: 701-231-5789
Fax: 701-231-7342
Website: https://www.ndsu.edu/programs/undergraduate/architecture
Susan Schaefer Kliman, Department Chair

Oklahoma State University, School of Architecture
101 Donald W. Reynolds School of Architecture Building
Stillwater, OK 74078-5051
United States

Main Phone: 405-744-6043
Fax: 405-744-6491
E-mail: test@maxx.matrixgroup.net
Website: https://ceat.okstate.edu/arch/
John J. Phillips, Interim Head & Professor

Prairie View A&M University, School of Architecture
P.O. Box 519, Mail Stop 2100
University Dr. @ L.W. Minor St.
Prairie View, TX 77446
United States

Main Phone: 936-261-9800
Fax: 936-261-9826
E-mail: test@maxx.matrixgroup.net
Website: https://www.pvamu.edu/architecture https://www.pvamu.edu/soa/
Ikhlas Sabouni, Dean/ ACSA & PVAMU Distinguished Professor

Rice University, School of Architecture
6100 Main Street
MS 50
Houston, TX 77005-1892
United States

Main Phone: 713-348-4864
Fax: 713-348-5277
E-mail: test@maxx.matrixgroup.net
Website: www.arch.rice.edu
Igor Marjanovic, Dean

South Dakota State University, Department of Architecture
SIM 108 Box 2203
Brookings, SD 57007
United States

Main Phone: 605-688-4841
E-mail: test@maxx.matrixgroup.net
Website: https://www.sdstate.edu/architecture
Pat Crawford, Professor and Director School of Design

Texas A&M University, Department of Architecture
3137 Texas A&M University
Langford Building A
College Station, TX 77843-3137
United States

Main Phone: 979-845-1015
Fax: 979-842-1571
E-mail: test@maxx.matrixgroup.net
Website: https://www.arch.tamu.edu/arch/
Gregory A. Luhan PhD, Department Head and Professor

Texas Tech University, College of Architecture
Box 42091
Lubbock, TX 79409-2091
United States

Main Phone: 806-742-3136
Fax: 806-742-2855
E-mail: test@maxx.matrixgroup.net
Website: http://www.arch.ttu.edu/default.asp
Urs Peter Flueckiger, Dean and Professor

University of Houston, Gerald D. Hines College of Architecture
122 College of Architecture Bldg.
Houston, TX 77204-4000
United States

Main Phone: 713-743-2400
Fax: 713-743-2358
E-mail: test@maxx.matrixgroup.net
Website: http://www.arch.uh.edu
Patricia Belton Oliver, Dean + Professor

University of Kansas, School of Architecture & Design
200 Marvin Hall
1465 Jayhawk Blvd.
Lawrence, KS 66045-2250
United States

Main Phone: 785-864-4281
Fax: 785-864-5393
E-mail: test@maxx.matrixgroup.net
Website: http://sadp.ku.edu/
Dr. Hui Cai, Chair, Associate Professor

University of Minnesota, College of Design
89 Church St. SE
Rapson Hall - Room 145
Minneapolis, MN 55455
United States

Main Phone: 612-624-7866
Fax: 612-625-7525
E-mail: test@maxx.matrixgroup.net
Website: http://arch.design.umn.edu/ http://design.umn.edu/
Jennifer Yoos, Head of the School of Architecture

University of Nebraska-Lincoln, College of Architecture
232 Architecture Hall West
Lincoln, NE 68588-0107
United States

Main Phone: 402-472-9233
Fax: 402-472-3806
E-mail: test@maxx.matrixgroup.net
Website: http://archweb.unl.edu
Kevin Van Den Wymelenberg PhD, Dean

University of Oklahoma, College of Architecture
830 Van Vleet Oval
Gould Hall, Rm 180
Norman, OK 73019-0265
United States

Main Phone: 405-325-2444
Fax: 405-325-7558
E-mail: test@maxx.matrixgroup.net
Website: http://arch.ou.edu/
Hans Butzer, Dean, Mabrey Presidential Professor & Acting Director

University of Texas at Arlington, School of Architecture
Box 19108
601 W. Nedderman Drive
Arlington, TX 76019
United States

Main Phone: 817-272-2801
Fax: 817-272-5098
Website: http://www.uta.edu/architecture/
Mr. Donald F. Gatzke, Interim Director + Professor

University of Texas at Austin, School of Architecture
310 Inner Campus Drive B7500
Austin, TX 78712-1009
United States

Main Phone: 512-471-1922
Fax: 512-471-0716
E-mail: test@maxx.matrixgroup.net
Website: http://soa.utexas.edu
Heather Woofter, Dean

University of Texas at San Antonio, Department of Architecture
Department of Architecture, DB 2.112
501 W. Cesar E. Chavez Blvd.
San Antonio, TX 78207
United States

Main Phone: 210-458-3010
E-mail: test@maxx.matrixgroup.net
Website: http://architecture.utsa.edu/academic-programs/department-of-architecture/ www.utsa.edu
Mark A. Blizard, Associate Professor, Director of School of Architecture and Planning

Washington University in St. Louis, Sam Fox School of Design & Visual Arts / College of Architecture and Graduate School of Architecture & Urban Design
Campus Box 1079
One Brookings Drive
St. Louis, MO 63130-4899
United States

Main Phone: 314-935-6200
Fax: 314-935-7656
E-mail: test@maxx.matrixgroup.net
Website: http://www.arch.wustl.edu/ http://www.arch.wustl.edu/archprograms
Dr. Linda C. Samuels, Interim Director + Professor


1 - 20 of 20 results
Debugging Info
pagedictsize=14365
sqltime = 0.390 s
cpu time = 0.760 s
real time = 1.141 s
memory increase = 19500 kB
fields = Company_region: '5'
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 1751666364.494...
libs.framework.WebForm:fillCursor took 134.562 ms
libs.framework.WebForm:outputSearchResults starting at 1751666365.299...
libs.framework.WebForm:outputSearchResults took 201.344 ms
queries = 442 queries

Total TimeCountAvg TimeQuery
0.0951 call
20 rows
0.095 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 generalLiabilityAgent___email, generalLiabilityAgent.alt... on (Company.generalLiabilityAgentId = generalLiabilityAgent.IndividualId ) WHERE ((((((Company.companyStatusId=0x1 AND (Company.region=5 AND Company.CompanyId IN (1765231560305, 5023492533649414, 47321949667992, 1765231560389, 1765231559804, 1765231558762, 1765231558767, 3488831999312072, 1765231558776, 3507085610319893, 1765231558781, 3302443303567509, 204019536502784, 1765231558786, 1765231559661, 3146862408247566, 1765231560102, 34260954120663, 1765231558791, 1765231558796, 1765231558801, 1765231560729, 1765231558806, 1765231558811, 1765231558816, 1765231559600, 1765231558825, 1765231558830, 1765231558889, 1765231558835, 1765231558845, 1765231558850, 1765231560482, 1765231558854, 1765231559184, 1765231558858, 3117802659512795, 1765231558866, 1765231558875, 1765231558880, 872337922588939, 2182281473033183, 3269990530678796, 2875759777546340, 1765231558893, 3862940830663328, 1765231560875, 1765231558897, 1765231559538, 1765231558902, 68315749810202, 1765231558912, 4069292534399036, 55040005900821, 1765231558917, 3654750880923685, 1765231558922, 866690040595814, 1765231558927, 1765231558932, 598301829236655, 1765231560682, 1765231558942, 1765231560639, 1765231559565, 1765231558947, 1716238866712497, 534796442805769, 1765231559152, 1765231558952, 109229608273002, 1765231558965, 1765231558970, 1765231558975, 1765231558980, 2628846402668193, 1765231560711, 1765231560607, 1765231558989, 1765231558994, 3976529830739997, 749604937138385, 1765231559002, 2534773733983148, 1765231559007, 1765231560464, 1765231559012, 1765231559017, 1765231560916, 1765231559031, 1765231559041, 1765231559036, 1765231559046, 1765231559051, 1765231559026, 1765231559056, 1765231559065, 1765231559070, 4277259145838594, 1765231559075, 1765231559078, 1765231561021, 1765231559083, 1765231559391, 3384434229540, 1765231559093, 1765231559098, 1765231559103, 1765231559108, 1765231560697, 4246051913465937, 1765231559116, 1765231559121, 1765231559126, 971779300393710, 1765231560935, 1765231559131, 1765231559825, 2655200321994902, 1765231559672, 1765231560155, 1765231559620, 1765231559733, 1765231560701, 1765231559147, 1765231559157, 1765231560777, 1765231560250, 917718547038473, 3659960676254192, 1765231559175, 1765231559189, 1765231559194, 1765231559199, 1765231558840, 1765231558907, 284124971533104, 1765231559417, 899074094012546, 1765231559088, 2124127615844634, 1765231559204, 1765231559209, 3059202125725746, 1615367264797295, 1765231559629, 3556786971869316, 2989804044156989, 437532613410958, 1765231559412, 1765231560185, 36258113922840, 1765231559408, 1765231559348, 69909182680817, 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, 3365420409028711, 1765231559882, 1765231559494, 1765231559503, 1765231559508, 1765231559513, 93162135621496, 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.01123 calls
54 rows
0.000 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0061 call
229 rows
0.006 SELECT DISTINCT hex(Company.CompanyId) AS CompanyId FROM (Membership, Company) WHERE (Company.MembershipId=Membership.MembershipId AND Membership.status=1) ORDER BY Company.alphaSort, Company.name
0.0061 call
0 rows
0.006 INSERT INTO PageRequest SET mxxCreated='2025-07-04 17:59:24',mxxCreatedBy=NULL, PageRequestId=0x13AAD200000000, path='forms/CompanyFormPublic/search', formName='acsa_CompanyFormPublic', site='www', clientAcronym='ACSA', pid='3370020', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.acsa.maxx.matrixdev.net', dbThreadId='103062', startTime='2025-07-04 17:59:24', sessionId=0x43BD51BC048FFA29, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{\\'Company_region\\':\\'5\\', \\'action\\':\\'find\\'}', clientIPAddr='216.73.216.138'
0.0061 call
0 rows
0.006 COMMIT
0.0061 call
0 rows
0.006 SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Company) WHERE Company.CompanyId=0x13AAD200000001 AND Company.KeyContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial
0.0051 call
12 rows
0.005 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B00000221 ORDER BY Address.zip
0.0051 call
0 rows
0.005 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AAD200000005 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip
0.0041 call
8 rows
0.004 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B000002BB ORDER BY Address.zip
0.0043 calls
244 rows
0.001 SELECT * FROM Country ORDER BY orderindex, id
0.0041 call
1 row
0.004 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x51FB9000005B0) 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(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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x5830000000152) 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(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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B00016CD8) 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(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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B00004B67) 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(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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0004B1EF) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name
0.0031 call
11 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B0000021C ORDER BY Address.zip
0.0031 call
5 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B0000018D ORDER BY Address.zip
0.0031 call
10 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B000002D4 ORDER BY Address.zip
0.0031 call
5 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B000001A0 ORDER BY Address.zip
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x50DD5000000A2) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name
0.0031 call
7 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B000002AD ORDER BY Address.zip
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xD4A83000000CB) AND BranchAffiliationHistory.BranchId=Branch.BranchId) AND Branch.CompanyId=Company.CompanyId) ORDER BY Company.alphaSort, Company.name
0.0031 call
1 row
0.003 SELECT COUNT(DISTINCT Company.CompanyId) AS count FROM (Membership, Company) WHERE ((((((Company.companyStatusId=0x1 AND (Company.region=5 AND Company.CompanyId IN (1765231560305, 5023492533649414, 47321949667992, 1765231560389, 1765231559804, 1765231558762, 1765231558767, 3488831999312072, 1765231558776, 3507085610319893, 1765231558781, 3302443303567509, 204019536502784, 1765231558786, 1765231559661, 3146862408247566, 1765231560102, 34260954120663, 1765231558791, 1765231558796, 1765231558801, 1765231560729, 1765231558806, 1765231558811, 1765231558816, 1765231559600, 1765231558825, 1765231558830, 1765231558889, 1765231558835, 1765231558845, 1765231558850, 1765231560482, 1765231558854, 1765231559184, 1765231558858, 3117802659512795, 1765231558866, 1765231558875, 1765231558880, 872337922588939, 2182281473033183, 3269990530678796, 2875759777546340, 1765231558893, 3862940830663328, 1765231560875, 1765231558897, 1765231559538, 1765231558902, 68315749810202, 1765231558912, 4069292534399036, 55040005900821, 1765231558917, 3654750880923685, 1765231558922, 866690040595814, 1765231558927, 1765231558932, 598301829236655, 1765231560682, 1765231558942, 1765231560639, 1765231559565, 1765231558947, 1716238866712497, 534796442805769, 1765231559152, 1765231558952, 109229608273002, 1765231558965, 1765231558970, 1765231558975, 1765231558980, 2628846402668193, 1765231560711, 1765231560607, 1765231558989, 1765231558994, 3976529830739997, 749604937138385, 1765231559002, 2534773733983148, 1765231559007, 1765231560464, 1765231559012, 1765231559017, 1765231560916, 1765231559031, 1765231559041, 1765231559036, 1765231559046, 1765231559051, 1765231559026, 1765231559056, 1765231559065, 1765231559070, 4277259145838594, 1765231559075, 1765231559078, 1765231561021, 1765231559083, 1765231559391, 3384434229540, 1765231559093, 1765231559098, 1765231559103, 1765231559108, 1765231560697, 4246051913465937, 1765231559116, 1765231559121, 1765231559126, 971779300393710, 1765231560935, 1765231559131, 1765231559825, 2655200321994902, 1765231559672, 1765231560155, 1765231559620, 1765231559733, 1765231560701, 1765231559147, 1765231559157, 1765231560777, 1765231560250, 917718547038473, 3659960676254192, 1765231559175, 1765231559189, 1765231559194, 1765231559199, 1765231558840, 1765231558907, 284124971533104, 1765231559417, 899074094012546, 1765231559088, 2124127615844634, 1765231559204, 1765231559209, 3059202125725746, 1615367264797295, 1765231559629, 3556786971869316, 2989804044156989, 437532613410958, 1765231559412, 1765231560185, 36258113922840, 1765231559408, 1765231559348, 69909182680817, 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, 3365420409028711, 1765231559882, 1765231559494, 1765231559503, 1765231559508, 1765231559513, 93162135621496, 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.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=0x19B000000E0
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0001B58A) 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(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Company) WHERE SocialNetworking.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000011E
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=0x13AAD20000001E AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0021 call
6 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B0000027B ORDER BY Address.zip
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B00018A42) 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(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Company) WHERE SocialNetworking.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000123
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=0x19B000002B9
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=0x319630000010B
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=0x19B000001BA
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=0x19B0000019E
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=0x19B0000021A
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=0x19B0000021F
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=0x19B00000325
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=0x19B0000028D
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B00056BA5) 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(SocialNetworking.SocialNetworkingId) AS SocialNetworkingId, SocialNetworking.socialnetwork, SocialNetworking.url, SocialNetworking.usertext FROM (SocialNetworking, Company) WHERE SocialNetworking.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000354
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0004A66D) 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(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=0x19B00000327 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=0x19B00000279
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=0x19B000002AB
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=0x19B0000018B
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=0x19B000007FD
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=0x19B00000316
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=0x19B000001D6
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=0x19B000002D2
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=0x19B0000031B
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=0x319630000010C 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.primaryAddressId=Address.AddressId AND Branch.BranchId=0x319630000010C ORDER BY Address.zip
0.0021 call
11 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B00000356 ORDER BY Address.zip
0.0021 call
3 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x319630000010C ORDER BY Address.zip
0.0022 calls
21 rows
0.001 SELECT * FROM MembershipType 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B000245F8) 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0009811C) 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(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x19B00030A49 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0021 call
5 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 (Address, Branch) WHERE Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B000001BC ORDER BY Address.zip
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=0x128B7F0000000C AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B00031FC4) 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0001989C) 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(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x19B00047F71 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x49E0800000719) 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=0xC85EF0000008C AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
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=0x19B000007FD
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=0x19B0000021C 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=0xDD52800000029 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
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=0x19B0000031D 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=0x19B000007FE 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 Address.BranchId=Branch.BranchId AND Branch.BranchId=0x19B000000E2 ORDER BY Address.zip
0.0015 calls
2 rows
0.000 SELECT * FROM YesNo ORDER BY orderindex, id
0.0015 calls
1 row
0.000 SELECT version from databasemap;
0.0014 calls
7 rows
0.000 SELECT * FROM Region ORDER BY orderindex, id
0.0011 call
4 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=0x19B00000318 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B000193DA) 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=0xA986500000928 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0011 call
3 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=0x19B0000028F 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=0x121E8800000014 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
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=0x19B0000021A
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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0001CF41) 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=0xA22D400000226 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0x19B0003B8AA) 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=0x6503D00000234 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=0xC17C800001EA7 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=0x989760000013E 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=0xB6C970000020E 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 FROM (Individual, Branch, BranchAffiliationHistory, Company) WHERE (((BranchAffiliationHistory.active='Y' AND BranchAffiliationHistory.IndividualId=Individual.IndividualId AND Individual.IndividualId=0xD41260000004C) 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x319630000010B 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=0x1127CE00000002 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=0x12606800000023 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=0xECF200000FF1 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=0xD441E00000143 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=0xC0B3D00000349 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0012 calls
2 rows
0.000 SELECT * FROM FundingSource ORDER BY orderindex, id
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=0xDB74700000028 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=0x977D400000940 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(Company.CompanyId) AS CompanyId FROM (Relationship, Company) WHERE ((Company.CompanyId=Relationship.childCompanyId AND Relationship.parentCompanyId in (1765231560305, 5023492533649414, 47321949667992, 1765231560389, 1765231559804, 1765231558762, 1765231558767, 3488831999312072, 1765231558776, 3507085610319893, 1765231558781, 3302443303567509, 204019536502784, 1765231558786, 1765231559661, 3146862408247566, 1765231560102, 34260954120663, 1765231558791, 1765231558796, 1765231558801, 1765231560729, 1765231558806, 1765231558811, 1765231558816, 1765231559600, 1765231558825, 1765231558830, 1765231558889, 1765231558835, 1765231558845, 1765231558850, 1765231560482, 1765231558854, 1765231559184, 1765231558858, 3117802659512795, 1765231558866, 1765231558875, 1765231558880, 872337922588939, 2182281473033183, 3269990530678796, 2875759777546340, 1765231558893, 3862940830663328, 1765231560875, 1765231558897, 1765231559538, 1765231558902, 68315749810202, 1765231558912, 4069292534399036, 55040005900821, 1765231558917, 3654750880923685, 1765231558922, 866690040595814, 1765231558927, 1765231558932, 598301829236655, 1765231560682, 1765231558942, 1765231560639, 1765231559565, 1765231558947, 1716238866712497, 534796442805769, 1765231559152, 1765231558952, 109229608273002, 1765231558965, 1765231558970, 1765231558975, 1765231558980, 2628846402668193, 1765231560711, 1765231560607, 1765231558989, 1765231558994, 3976529830739997, 749604937138385, 1765231559002, 2534773733983148, 1765231559007, 1765231560464, 1765231559012, 1765231559017, 1765231560916, 1765231559031, 1765231559041, 1765231559036, 1765231559046, 1765231559051, 1765231559026, 1765231559056, 1765231559065, 1765231559070, 4277259145838594, 1765231559075, 1765231559078, 1765231561021, 1765231559083, 1765231559391, 3384434229540, 1765231559093, 1765231559098, 1765231559103, 1765231559108, 1765231560697, 4246051913465937, 1765231559116, 1765231559121, 1765231559126, 971779300393710, 1765231560935, 1765231559131, 1765231559825, 2655200321994902, 1765231559672, 1765231560155, 1765231559620, 1765231559733, 1765231560701, 1765231559147, 1765231559157, 1765231560777, 1765231560250, 917718547038473, 3659960676254192, 1765231559175, 1765231559189, 1765231559194, 1765231559199, 1765231558840, 1765231558907, 284124971533104, 1765231559417, 899074094012546, 1765231559088, 2124127615844634, 1765231559204, 1765231559209, 3059202125725746, 1615367264797295, 1765231559629, 3556786971869316, 2989804044156989, 437532613410958, 1765231559412, 1765231560185, 36258113922840, 1765231559408, 1765231559348, 69909182680817, 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, 3365420409028711, 1765231559882, 1765231559494, 1765231559503, 1765231559508, 1765231559513, 93162135621496, 3002010341213277, 1765231559518, 1765231559523)) AND Relationship.relationType IN (1, 2)) ORDER BY Company.alphaSort, Company.name
0.0011 call
167 rows
0.001 SELECT * FROM webselect
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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000021A ORDER BY Branch.isMain, Branch.name
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.congresspersonFor, Individual.practiceSpecialty, Individual.researchSpecialty, Individual.primaryProfessionalField, Individual.terminalDegree, Individual.terminalSchool, Individual.discipline, Individual.highestDegree, Individual.facultyRank, Individual.tenured, Individual.isAdminContact, Individual.timeCommitment, Individual.birthYear, Individual.pilotParticipant, Individual.naabUser, Individual.naabStaff, Individual.lesbigay, Individual.disability, Individual.topazLaureate, Individual.distinguishedProfessor, Individual.initialLicenseDate, Individual.isPartTime, Individual.congressParty, Individual.mailChimpMergeCache, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.spokenLanguagesOther, Individual.teachingLoadPct, Individual.researchLoadPct, Individual.serviceLoadPct, Individual.secondaryInstitution, Individual.secondaryInstitutionTitle, Individual.tertiaryInstitutionTitle, Individual.tertiaryInstitution, Individual.isLicensed, Individual.baseSalary, Individual.degreeGrantingInst1, Individual.degreeGrantingInst2, Individual.degreeGrantingInst3, Individual.degreeGrantingInst4, Individual.degreeGrantingInst5, Individual.degree1, Individual.degree2, Individual.degree3, Individual.degree4, Individual.degree5, Individual.adminLoadPct, Individual.definedResearchArea, Individual.initialLicensureYear, Individual.SAIsBoard, Individual.delinquentSince FROM (Individual, Company) WHERE Company.CompanyId=0x13AAD200000001 AND Company.BillingContactId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial
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 FROM (Individual, Company) WHERE Company.CompanyId=0x13AAD200000001 AND Company.DirectoryContactId=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=0x19B0000027B ORDER BY Address.zip
0.0012 calls
12 rows
0.000 SELECT * FROM Month ORDER BY orderindex, id
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=0x13AAD200000003 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000001BA 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000001D6 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=0x19B000000E0
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=0x19B00000120 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000011E 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=0x19B000001D8 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=0x19B00000327 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000002AB 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000123 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=0x19B000001D6
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=0x19B00000125 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000002D2 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000021F 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=0xB891200001DA6 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000316 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=0x13437100000003 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000031B 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000018B 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000354 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000325 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000002B9 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=0xF0D820000000A 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=0x19B0000028D
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=0x19B0000021C ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Service.description, hex(Service.ServiceId) AS ServiceId FROM (Company, Service, Company2Service) WHERE (0x19B000000E0=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.shippingAddressId=Address.AddressId AND Branch.BranchId=0x19B000002BB 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=0x19B000000E2 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000000E0 ORDER BY Branch.isMain, Branch.name
0.0001 call
4 rows
0.000 SELECT * FROM CompanyStatus ORDER BY orderindex, id
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=0x19B00000356 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=0x19B000000E2 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B00000279 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 (Company2Country, Company, Country) WHERE (0x19B000000E0=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=0x19B0000027B 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=0x19B000002AB
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=0xDB89D000000F9 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B000007FD 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000019E 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=0x19B000001BD AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
11 rows
0.000 SELECT * FROM SocialNetwork 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 (Branch, Company) WHERE Branch.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000028D 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=0x19B0000031D 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=0x19B0000027C ORDER BY Address.zip
0.0001 call
11 rows
0.000 SELECT * FROM Accreditation ORDER BY orderindex, id
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=0x19B0000021F
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=0x13AAD200000012 AND Individual.mainAddressId=Address.AddressId ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(File.FileId) AS FileId, File.filename, File.description, File.caption, File.altTag, hex(File.parentId) AS parentId FROM (File, Company) WHERE Company.highResImageId=File.FileId AND Company.CompanyId=0x13AAD200000001
0.0001 call
64 rows
0.000 SELECT * FROM DegreeLevel ORDER BY orderindex, id
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=0x19B00000222 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=0x319630000010B
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=0x19B00000221 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=0x19B0000021C 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=0x19B000001D8 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=0x19B0000031B
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=0x19B00000318 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=0x19B00000123
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=0x19B000002AD 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=0x319630000010C 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=0x19B000001BD 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=0x19B000002D4 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=0x19B00000325
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=0x19B00000120 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=0x19B000002AD 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=0xA14F60000071B 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=0xF096D00000001 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=0x19B000007FE 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=0x19B00000354
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=0x19B000000E2 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=0x19B000002D4 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=0x19B00000121 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=0xC4E4500000248 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=0x19B000002B9
0.0001 call
54 rows
0.000 select id, abbreviation from StateProvince
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=0x13AAD200000008 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=0x19B000002D2
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=0x19B00000279
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=0xDB74700000028 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=0x12FAB700000030 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
0 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=0x19B0000011E
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=0x19B000001D8 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=0x19B000001D8 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=0x19B000001A1 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=0x19B0000027B 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=0x955D90000004D 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=0x19B0000031D 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=0xF17DC00000089 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=0x19B00000120 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=0x19B000001BC 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=0x19B0000028F ORDER BY Address.zip
0.0001 call
8 rows
0.000 SELECT * FROM TermType ORDER BY orderindex, id
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AAD20000000B 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=0x19B0000018D 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=0x19B00000221 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=0x19B00000316
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=0x19B000001BA
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.shippingAddressId=Address.AddressId AND Branch.BranchId=0x19B00000125 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(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=0x19B000000E3 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=0x19B000001A0 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=0x19B00000318 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=0xABBF30000074F 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=0x19B000002AD 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=0x19B0000031D 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=0x19B00000356 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=0x19B0000018E 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=0x19B0000028F 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=0x19B0000018B
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=0xB120E0000043A AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
0 rows
0.000 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Individual, Address) WHERE Individual.IndividualId=0x13AAD200000018 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.primaryAddressId=Address.AddressId AND Branch.BranchId=0x19B00000120 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=0x19B00000221 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=0x13AAD200000015 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=0x19B00000126 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=0x19B0000028F 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=0x19B000001A0 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=0x19B0000018D 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=0x19B000002BB 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=0x19B00000327 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=0x31962000000E4 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=0x19B000002AE 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=0x19B00000318 ORDER BY Address.zip
0.0001 call
4 rows
0.000 SELECT * FROM CustomerType ORDER BY orderindex, id
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=0x19B000001A0 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=0xC3BE700000166 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=0xC4B730000020F 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=0x19B000007FF ORDER BY Address.zip
0.0001 call
3 rows
0.000 SELECT * FROM AddressType ORDER BY orderindex, id
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=0x19B00000356 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=0x19B000002BB ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company2Country, Company, Country) WHERE (0x19B000001D6=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.primaryAddressId=Address.AddressId AND Branch.BranchId=0x19B00000125 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=0x19B000007FE 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=0xA7071000017B3 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=0x19B000002D4 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=0xE1A220000008A 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=0x31962000000E4 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=0x19B000001D9 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=0x13AAD200000010 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=0x19B000000E3 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=0x13437200000001 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=0x19B00000357 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=0x13AAD200000025 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=0x49E60000001F 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=0x19B000002BC ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company2Country, Company, Country) WHERE (0x19B000002AB=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(Website.WebsiteId) AS WebsiteId, Website.description, Website.address FROM (Company, Website) WHERE Website.CompanyId=Company.CompanyId AND Company.CompanyId=0x19B0000019E
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=0x19B0000018D 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=0x19B00000290 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 (Company2Country, Company, Country) WHERE (0x319630000010B=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=0x19B000001A1 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=0x13AAD20000001D 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=0x19B00000121 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=0x19B0000031E 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=0x19B00000125 ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Service.description, hex(Service.ServiceId) AS ServiceId FROM (Company, Service, Company2Service) WHERE (0x19B000002B9=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) WHERE Address.AddressId=0x19B00000290 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=0x13AAD200000022 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=0xA884900000D29 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 (Company2Country, Company, Country) WHERE (0x19B0000021F=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 (Company2Country, Company, Country) WHERE (0x19B0000028D=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.shippingAddressId=Address.AddressId AND Branch.BranchId=0x19B000007FE 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=0xB1B560000009C 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=0x19B00000319 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=0x19B000002AE 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=0x1C6A9000009D2 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=0x19B00000327 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=0x19B000001BC ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company2Country, Company, Country) WHERE (0x19B000002D2=Company.CompanyId AND Company.CompanyId=Company2Country.CompanyId AND Company2Country.CountryId=Country.CountryId) ORDER BY orderindex
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=0x13AAD20000001F 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=0x19B000007FF 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=0x19B00000319 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=0xAB7B3000007A8 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=0x13AAD200000006 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=0xBD708000000AA 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=0xB6F550000051B 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=0xF2EF500000022 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=0x19B000002D5 ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company2Country, Company, Country) WHERE (0x19B0000031B=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 (Company, Service, Company2Service) WHERE (0x19B000002AB=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(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=0x13AAD20000000F ORDER BY Address.zip
0.0001 call
0 rows
0.000 SELECT DISTINCT Country.orderindex, Country.description, hex(Country.CountryId) AS CountryId FROM (Company2Country, Company, Country) WHERE (0x19B0000011E=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=0x19B0000018E 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=0x19B00000009 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=0x10B20400000008 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=0xE247D00000024 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 (Company2Country, Company, Country) WHERE (0x19B0000018B=Company.CompanyId AND Company.CompanyId=Company2Country.CompanyId AND Company2Country.CountryId=Country.CountryId) ORDER BY orderindex
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=0x13AAD200000019 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=0xC4B7C00000296 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=0xC3AF600000165 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 (Company, Service, Company2Service) WHERE (0x19B00000123=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=0x9E33800000487 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=0xEF67100000017 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 (Company2Country, Company, Country) WHERE (0x19B00000325=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 (Company2Country, Company, Country) WHERE (0x19B000002B9=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=0xC3BC4000000C2 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 (Company2Country, Company, Country) WHERE (0x19B000007FD=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=0xB2C8100000579 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=0xBD472000007F9 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=0xC3CE800000365 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=0x19B00000126 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=0xC43EF00000167 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=0x9EEF300000118 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=0x19B000001D9 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=0xDB0EA00000368 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=0xB984800000F50 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=0xDA3DF000000C8 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=0x13AAD200000004 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=0xC43120000031C 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=0x19B00000222 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=0xC463B00000040 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 (Company, Service, Company2Service) WHERE (0x19B00000279=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=0xC429B0000004C 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 (Company2Country, Company, Country) WHERE (0x19B00000123=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=0xBAD7B00000675 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=0xB4CD400000007 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=0x19B000002D5 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=0x11834700000372 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=0x19B0000021D 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=0x1C6A9000009D2 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 (Company2Country, Company, Country) WHERE (0x19B0000021A=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 (Company2Country, Company, Country) WHERE (0x19B00000279=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=0xCD3D400000082 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=0xBB893000005EC 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=0x19B0000027C 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=0xB1C8B00000006 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=0xB7B3C0000097E 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=0xF0C1200000004 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=0xF0D8400000005 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=0x9C04E000006B0 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=0x19B00000357 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 (Company, Service, Company2Service) WHERE (0x19B0000031B=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=0x19B0000031E 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=0xA941800000FC6 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 (Company2Country, Company, Country) WHERE (0x19B00000316=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=0xDCD560000000C 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 (Company2Country, Company, Country) WHERE (0x19B00000354=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 (Company, Service, Company2Service) WHERE (0x19B000007FD=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=0xB782800002054 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 (Company, Service, Company2Service) WHERE (0x19B00000354=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=0xA884A00000061 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=0x13AAD20000000C 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=0x19B000001BC 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=0x132CAE00000032 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=0x10DDE20000000A 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=0x19B000002BC 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=0xA65D3000008F7 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=0xB4D4C000004B6 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=0x13AAD200000013 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 (Company, Service, Company2Service) WHERE (0x19B0000021A=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=0xD65AC000021C9 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=0xCD8EC000000AD 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=0xB4CE500000212 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=0xA922200000E4A 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 (Company, Service, Company2Service) WHERE (0x19B0000021F=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 (Company, Service, Company2Service) WHERE (0x319630000010B=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 (Company, Service, Company2Service) WHERE (0x19B000001D6=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=0xC37DE00000158 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 (Company2Country, Company, Country) WHERE (0x19B0000019E=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=0x12856000000029 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=0xCBAF3000000CE 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 (Company, Service, Company2Service) WHERE (0x19B0000028D=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(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x13AAD200000009 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 (Company, Service, Company2Service) WHERE (0x19B0000018B=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=0xA132700000465 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=0xCBAF3000000AC 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 (Company, Service, Company2Service) WHERE (0x19B0000019E=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 (Company, Service, Company2Service) WHERE (0x19B00000325=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(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x13AAD200000016 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 (Company, Service, Company2Service) WHERE (0x19B00000316=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 (Company2Country, Company, Country) WHERE (0x19B000001BA=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 (Company, Service, Company2Service) WHERE (0x19B000002D2=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 (Company, Service, Company2Service) WHERE (0x19B0000011E=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(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Address, Branch) WHERE Address.AddressId=0x13AAD200000011 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=0x13AAD200000023 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
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=0x19B000000E0
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=0x13AAD200000020 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
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=0x19B0000011E
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=0x13AAD200000026 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
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=0x19B000001BA
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=0x19B00000123
0.0001 call
0 rows
0.000 SELECT DISTINCT Service.description, hex(Service.ServiceId) AS ServiceId FROM (Company, Service, Company2Service) WHERE (0x19B000001BA=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=0x19B000002AB
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=0x19B00000316
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
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=0x319630000010B
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=0x19B0000021F
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=0x19B0000018B
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=0x19B000001D6
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=0x19B0000019E
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=0x19B00000325
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=0x19B000007FD
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=0x19B000002D2
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=0x19B0000028D
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=0x19B0000031B
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=0x19B0000021A
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=0x19B000002B9
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=0x19B00000354
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=0x19B00000279
0.0001 call
0 rows
0.000 START TRANSACTION