Search Results

Your search criteria returned the following Associate Members, listed alphabetically by Organization Name.

If you would like to download these search results as a PDF, click here.

Criteria

Red Gold, Inc.


Family Owned

1500 Tomato Country Way
P. O. Box 83
Elwood, IN 46036-3437
United States
Tel: 765-557-5500 | www.redgold.com | www.redgoldfoods.com
test@maxx.matrixgroup.net

Red Gold is a 4th generation family owned and operated manufacturer of tomato-based products. Serving Retail and Foodservice customers with quality brands as well as Customer owned Private Brands.

Primary Contact:
Mr. Gary Petersen
Senior Vice President, Sales
Products/Services:
Beverages
Co-Packer
Food Products/Snacks
Private Brands
Brands:
Red Gold, Red Pack, Tuttorosso, Sacramento, Private Brands

RefPlus, Inc.

2777 Grand Allee
St. Hubert, Quebec J4T 2R4
Canada
Tel: 450-641-2665 | www.refplus.com
test@maxx.matrixgroup.net

RefPlus, Leader in Custom Quality Refrigeration​ Equipment
A leader in custom refrigeration, RefPlus designs and manufactures high-performance products tailored to your needs.

Driven by a constant concern for the environment, quality craftsmanship and higher performance, our engineers and technicians design and build the best refrigeration equipment in the industry.

Primary Contact:
Mr. Mathieu Cardinal
President
Products/Services:
Equipment

Refresco

8112 Woodland Center Boulevard
Tampa, FL 33614-2403
United States
Tel: 331-777-2312 | www.refresco.com

Primary Contact:
Ms. Jeanine Antiporek
Senior Director Retail Sales - Brands: Vintage, Harvest Classic
Products/Services:
Beverages
Private Brands
Brands:
Vintage, Harvest Classic

Relex Solutions

1201 Peachtree Street
Suite 1000
Atlanta, GA 30361-3511
United States
Tel: 678-203-0091 | www.relexsolutions.com
test@maxx.matrixgroup.net
https://www.linkedin.com/company/relexsolutions/

RELEX Solutions helps retailers and consumer goods brands drive profitable growth across all sales and distribution channels by maximizing customer satisfaction and minimizing operative costs in a rapidly changing market.

Primary Contact:
Ms. Susan Boyme
Vice President, Strategic Accounts
Products/Services:
Consulting Services
Research
Supply Chain
Technology Services
Sustainability
Brands:
Acquired Galleria in 2016 Acquired Formulate in 2022 Acquired Optimity in 2023

Renaissance Capital Alliance, LLC

5440 Corporate Dr
Troy, MI 48098-2646
United States
Tel: 248-299-7800 | rcalliance.com

At the heart of RCA is a rich background with strong leadership and commitment to diversity and corporate responsibility.

Renaissance Capital Alliance (RCA) has been providing equipment financing solutions to some of the largest corporations in North America since 2001. As an independent Lessor, RCA’s financing programs allow you to keep your current OEM relationships in place while lowering your overall cost of ownership through low-cost financing.

Primary Contact:
Joshua Larish
North America Program Manager
Products/Services:
Other

Respect Foods, Inc.

3801 PGA Boulevard
Suite 600
Palm Beach Gardens, FL 33410-2756
United States
Tel: 866-732-1676 | www.respectfoods.com

“Wow!” That’s your brain’s response when something surprising hits your tastebuds—when a simple, wholesome food blows away your expectations. And it’s just the feeling Respect® is going for. See, we got bored with the food conversation: too scientific, too complex. Yawn. Let’s talk about the joy of simple and well-prepared food. Let’s go to tastytown. Let’s get together at the kitchen table and change those mealtime woes into mealtime wows.

Primary Contact:
Mr. Ken Hartman
President
Products/Services:
Bakery
Brokers
Co-Packer
Consulting Services
Food Products/Snacks
Fresh
Frozen
Meat/Poultry
Natural/Organic
Packaging
Perishables
Private Brands
Seafood

Retail Insight

1 Parkshot
Richmond, UK TW9 2RD
United Kingdom
Tel: 802-254-8600 | https://www.retailinsight.io/
https://uk.linkedin.com/company/retailinsightio

Retail Insight is a leading provider of in-store execution software for grocery retail. We help retailers tackle some of their biggest challenges, including product availability, food waste management, labor productivity, and phantom inventory.

We believe that successful solutions are built on a fundamental understanding of the nuances and complexities that come with the retail industry. This is why we use cognitive technology; the augmentation of human subject-matter expertise and analytics with advanced mathematical techniques.

Our software solutions ingest a retailer’s foundational data to surface actions for your in-store teams as well as provide all-level reporting. As a result, we seamlessly integrate with your existing tech stack, require little IT investment or change management, supplement existing inventory and ordering systems and carry little to no capital investment.

As a result, we now work with many of the world’s leading grocery retailers and CPGs.

Primary Contact:
Mr. Paul Boyle
CEO
Products/Services:
Technology Services

Retail Insight Ltd


United States

Parent Company:
Retail Insight

Reynolds Consumer Products

1900 W. Field Court
Lake Forest, IL 60045-4828
United States
Tel: 847-482-2480 | http://www.reynoldsconsumerproducts.com/

Two of the most trusted household brands, Reynolds® and Hefty®, joined together as Reynolds Consumer Products in 2010. While the establishment of this new company made it official, the truth is that Reynolds® and Hefty® products have been found side-by-side in the kitchens of American families for more than three generations.

The creation of both the Reynolds® and Hefty® brands is the direct result of American ingenuity mixed with a bit of elbow grease. Reynolds Wrap® foil was invented after aluminum was no longer needed for military use; and became a new staple for American kitchens. Hefty® waste bags were first developed with excess material from an early plastics innovator, creating another household essential.

Primary Contact:
Mr. Steve Pace
President of Sales and Chief Customer Officer
Products/Services:
Fresh
Frozen
Nonfoods

RSM US LLP

4 Times Square, 151 W 42nd Street
19th Floor
New York, NY 10036
United States
Tel: 212-372-1000 | www.rsmus.com | www.rsmus.com

Primary Contact:
Ms. Jennifer Chelebi
Marketing Manager, National Consumer Products
Products/Services:
Consulting Services
Financial Services
Technology Services

Rudolph Foods Co.

6575 Bellefontaine Rd
Lima, OH 45804-4415
United States
Tel: 419-648-3611 | https://www.rudolphfoodscorp.com/
https://www.linkedin.com/company/rudolph-foods/

For Us, Pork Rinds are a Family Affair. Our commitment to excellence has been passed from generation to generation. In 1955, John Rudolph learned of an untapped market for pork rinds and the Ohio entrepreneur quickly launched his own company producing pork rinds from smoked bacon rinds.

And we've remained the family's namesake brand of pork rinds for nearly 70 years!

Primary Contact:
Mark Singleton
Vice President, Sales & Marketing
Products/Services:
Agricultural
Food Products/Snacks
Merchandising Services
Packaging
Supply Chain
Brands:
Southern Recipe Small Batch, Southern Recipe, Lee's, Grandpa John's

Conduct Another Search

Debugging Info
pagedictsize=23035
sqltime = 1.210 s
cpu time = 1.060 s
real time = 3.415 s
memory increase = 20236 kB
fields = Company_alphaSort: 'R*'
action: 'find'
templates =
/data/fmiam/current/fmiam_org/themes/www/webform/searchRSCompanyPublic
/data/fmiam/current/generic/themes/shared/dgelements/viewphunkyFone
/data/fmiam/current/generic/themes/shared/dgelements/viewphunkyFoneNoExt
scrapeAndDrape (CACHED) stub: https://www.fmiam.maxx.matrixdev.net/scrape.axd?target=https://www.fmiam.maxx.matrixdev.net/get-involved/directories/association-council-directory-maxx-stub (/data/fmiam/current/fmiam_org/cachedFiles//cachedStub___forms__CompanyFormPublic__search)
dg = ['searchCompanyPublic', 'searchCompanyPublic', 'searchRSCompanyPublic', 'searchRSCompanyPublic'] | [194, 194, 204, 204]
extra debug info =
libs.framework.WebForm:fillCursor starting at 1757453154.401...
libs.framework.WebForm:fillCursor took 317.589 ms
libs.framework.WebForm:outputSearchResults starting at 1757453156.680...
libs.framework.WebForm:outputSearchResults took 648.548 ms
queries = 434 queries

Total TimeCountAvg TimeQuery
0.05225 calls
244 rows		0.002 SELECT * FROM Country ORDER BY orderindex, id
0.0511 call
997 rows		0.051 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...833, 2018711938532289, 25639885310263699, 48193828031956, 48193828114575, 48193828150198, 48193828150249, 48193828150261, 48193828085199, 48193828030128, 48193828150706, 48193828148359, 48193828169182, 2238249191866945, 48193828150986, 12224310148071565, 7684963507897137, 48193828153216, 48193828031909, 51599737094162, 48193828123819, 30389268736115441, 48193828146093, 21627011466264588, 9147876613554279, 109474421407761, 13354028280841235, 30040221038937604, 905318976454657, 48193828033854, 678394379370591, 34313709203488776, 48193828131395, 979480176754798, 48193828165752, 25006755591225351, 326353089986574, 35205846925312, 25202064934044054, 32389366286385159, 26168411100807461, 41305263126347781, 48193828122683, 48193828154699, 31232349341483315, 28287049748447241, 48193828036661, 47540404588904453, 26116317442474599, 22621545503392792, 499775279464571, 149413322293248, 96546569846812, 535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 581250809069571, 48193828148840, 18111748238213292, 23316179154108434, 48193828159432, 48193828159465, 48193828159577, 48193828031484, 48193828112847, 48193828160240, 48193828161028, 2469296957555049, 30374313659990327, 37306085933056, 48193828138111, 48193828065993, 12329992113356956, 48193828113885, 48193828174888, 48193828180919, 48193828030496, 48193828166948, 48193828058562, 29588102716589010, 48193828105499, 48193828031179, 48193828156908, 48193828167047, 196486163857424, 19599791197520009, 33825354242064388, 24964128040813598, 25809437734208084, 1602800190489369, 32769131589664794, 26047752584561380, 2214287569324644, 48193828167195, 48193828114522, 48193828167304, 32064799902793729, 3326095688467149, 682749476208642, 48193828167352, 20191040690454691, 48193828029109, 34905027415900176, 55057185767613, 48193828147656, 48193828167390, 17037890450096234, 18362179191309061, 48193828135845, 38395268164485132, 1845903929376935, 36542213114560514, 48193828167527, 26388558239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 48193828167645, 34737330417828005, 25877147893629655, 5299800664703052, 48193828150461, 43492651315494917, 48193828142520, 2142054809340137, 19329805258326193, 497945623396397, 48193828167998, 48193828168001, 48193828030451, 48193828168035, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 34673270980626, 55905905664851974, 48193828061517, 52529627578499073, 27359512906170458, 48193828046932, 19898476108186045, 49938254765490177, 37697898619600925, 30510172065497133, 48193828117628, 33491351815323714, 48193828168176, 53586863843180549, 48193828168209, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 1419332072507548, 26420607285461439, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 24515003310670200, 48193828035598, 38534446579712, 51425872523034627, 11631153689657352, 36485747179594, 48193828143774, 11791497703719022, 48193828041120, 26716560596926921, 30601281206747889, 8264552164622941, 48193828168620, 48193828168626, 48193828031364, 29168849483989679, 48193828168721, 26759883932041694, 48193828168743, 113060719099907, 48193828114313, 26173758335090698, 48193828168632, 48193828168635, 28008903371390978, 50773750458613790, 30677486811480090, 32244905061384197, 55485093359124485, 48193828028740, 48193828040756, 48193828167566, 48193828028816, 48193828028813, 42398289353506818, 48193828039007, 48193828089272, 48193828028880, 48193828028888, 48193828028935, 48193828059861, 48193828028939, 48193828028954, 12584322896756763, 44210585163792389, 350705554554900, 37242172524724231, 48193828029106, 48193828029117, 247110943375361, 34916434849038337, 35178217400696841, 31843089396007122, 48193828029217, 26786078937579533, 36644660969472, 48193828033206, 48193828032167, 48193828116662, 363891104153613, 48193828032234)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0511 call
1056 rows		0.051 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...9581, 48193828169663, 431094457434192, 48193828167127, 11852383160108192, 48193828174539, 48193828170987, 48193828169112, 48193828169175, 48193828180667, 48193828114377, 2367772520612339, 2367622196756881, 2367815470284875, 21934286311522621, 48193828167248, 48193828180999, 48193828092607, 2367755340743310, 48193828176737, 48193828176744, 48193828176751, 1073789068640293, 1359348559250531, 32429571475243022, 11654093109985289, 11654157534495182, 11654226253971512, 11654294973448260, 687723048337421, 48193828176599, 687710163435647, 48193828176606, 29210257263689844, 27724585126330911, 27723081887779584, 27723236506599430, 44973762197585921, 25849604268359851, 44974045665427457, 535127155277873, 16715089298063361, 535152925081607, 48193828169077, 16715089298063541, 16715011988653234, 535161515016213, 535152925081638, 535114270375999, 55057185767705, 13980127138414836, 2367686621267365, 11654325038219327, 11654436707368961, 2367755340742739, 156641752252510, 48193828181029, 48193828168677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0491 call
1056 rows		0.049 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...8677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828109981, 1257046733226076, 48193828056206, 1176915528385066, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 48193828176366, 48193828180258, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 48193828175541, 335930867056662, 48193828179965, 6575393066713768, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828174274, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 21418026947576481, 48193828169566, 48193828169463, 21418048422412672, 21418014062674292, 21418026947576467, 48193828170960, 21418018357642330, 21418048422412554, 48193828170005, 48193828170578, 21418039832478106)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0341 call
700 rows		0.034 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`status`=1) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.03111 calls
2 rows		0.003 SELECT * FROM YesNo ORDER BY orderindex, id
0.0311 call
10 rows		0.031 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`alphaSort` LIKE 'R%' AND `Company`.`CompanyId` IN (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 4819382814856...7, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828109981, 1257046733226076, 48193828056206, 1176915528385066, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 48193828176366, 48193828180258, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 48193828175541, 335930867056662, 48193828179965, 6575393066713768, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828174274, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 21418026947576481, 48193828169566, 48193828169463, 21418048422412672, 21418014062674292, 21418026947576467, 48193828170960, 21418018357642330, 21418048422412554, 48193828170005, 48193828170578, 21418039832478106))) AND IFNULL(`Company`.`silent`, 2)!='1') AND `Company`.`MembershipId`=`Membership`.`MembershipId`) AND `Membership`.`status`=1) AND `Membership`.`MembershipTypeId` IN (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 1))) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0261 call
11 rows		0.026 SELECT DISTINCT hex(`joinSponsorship`.`SponsorshipId`) AS joinSponsorship___SponsorshipId, `joinSponsorship`.`name` AS joinSponsorship___name, `joinSponsorship`.`startDate` AS joinSponsorship___startDate, `joinSponsorship`.`endDate` AS joinSponsorship___endDate, `joinSponsorship`.`year` AS joinSponsorship___year, `joinSponsorship`.`location` AS joinSponsorship___location, `joinSponsorship`.`description` AS joinSponsorship___description, `joinSponsorship`.`targetAudience` AS joinSponsorship___targetAudience, `joinSponsorship`.`cityState` AS joinSponsorship___cityState, `joinSponsorship`.`status` AS joinSponsorship___status, `joinSponsorship`.`staffContact` AS joinSponsorship___staffContact, `joinSponsorship`.`showOnWWW` AS joinSponsorship___showOnWWW, `joinSponsorship`.`private` AS joinSponsorship___private, `joinSponsorship`.`staffContactEmail` AS joinSponsorship___staffContactEmail, `joinSponsorship`.`useSponsorImage` AS joinSponsorship___useSponsorImage, `joinSponsorship`.`imgHelptex...Date, `membership`.`status` AS membership___status, `membership`.`marketingCode` AS membership___marketingCode, `membership`.`mxxUpdated` AS membership___mxxUpdated, `membership`.`memberRecordComment` AS membership___memberRecordComment, hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company) left join `Membership` as membership on (`Company`.`MembershipId` = `membership`.`MembershipId` ) left join `Individual` as directoryContact on (`Company`.`DirectoryContactId` = `directoryContact`.`IndividualId` ) left join `Individual` as keyContact on (`Company`.`KeyContactId` = `keyContact`.`IndividualId` ) left join `SizeCode` as sizeCode on (`Company`.`SizeCodeId` = `sizeCode`.`SizeCodeId` ) left join `Individual` as billingContact on (`Company`.`BillingContactId` = `billingContact`.`IndividualId` ) left join `Sponsorship` as joinSponsorship on (`Company`.`joinSponsorshipId` = `joinSponsorship`.`SponsorshipId` ) WHERE `Company`.`CompanyId` IN (535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 18111748238213292, 23316179154108434, 2469296957555049, 30374313659990327, 17987593618587653) ORDER BY `Company`.`alphaSort`, `Company`.`name` LIMIT 0, 100
0.02411 calls
54 rows		0.002 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0171 call
0 rows		0.017 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x9FB98C00000006
0.0161 call
0 rows		0.016 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0xC6406A0000004C
0.0155 calls
1 row		0.003 SELECT version from databasemap;
0.0131 call
0 rows		0.013 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x6D720600000172
0.0121 call
0 rows		0.012 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1E69A0000006A
0.0121 call
0 rows		0.012 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x7FA33F00000053
0.0121 call
0 rows		0.012 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3FE79F00000005
0.0111 call
1 row		0.011 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x1E69A0000006A AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
0.0111 call
1 row		0.011 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x40588A000000AC
0.0111 call
0 rows		0.011 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD500001657
0.0111 call
0 rows		0.011 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x7FA33F000000B0
0.0111 call
0 rows		0.011 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x9FB98C00000002
0.0101 call
173 rows		0.010 SELECT * FROM webselect
0.0101 call
0 rows		0.010 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x1E58300012981
0.0101 call
0 rows		0.010 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3B1F90000015C
0.0101 call
0 rows		0.010 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x8C5D000000169
0.0091 call
0 rows		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x72685500000011
0.0091 call
0 rows		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x16AFB7000000B2
0.0091 call
1 row		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x5BA452000000AD
0.0091 call
1 row		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x6BE94700000137
0.0092 calls
21 rows		0.004 SELECT * FROM MembershipType ORDER BY orderindex, id
0.0091 call
0 rows		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x16AFB7000000B6
0.0091 call
0 rows		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x23261600000A4A
0.0091 call
0 rows		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x5F929D0000003B
0.0081 call
0 rows		0.008 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x1E6F700000026
0.0081 call
1 row		0.008 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x452CF30000006E
0.0081 call
0 rows		0.008 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Individual, SocialNetworking) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x59C092000001B8
0.0081 call
0 rows		0.008 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x52D5F100000012
0.0081 call
14 rows		0.008 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x2BD500001658 ORDER BY `Address`.`zip`
0.0071 call
10 rows		0.007 SELECT * FROM SocialNetwork ORDER BY orderindex, id
0.0071 call
0 rows		0.007 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Company, File) WHERE `Company`.`profileUploadId`=`File`.`FileId` AND `Company`.`CompanyId`=0xCFAF2F00000001
0.0071 call
0 rows		0.007 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x9FB98C00000006 ORDER BY `DiversityCertification`.`endDate` DESC
0.0071 call
0 rows		0.007 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000023 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0061 call
0 rows		0.006 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x8C5D000000169 ORDER BY `DiversityCertification`.`endDate` DESC
0.0061 call
1 row		0.006 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x175BC10000042E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0062 calls
8 rows		0.003 SELECT * FROM CompanyStructure ORDER BY orderindex, id
0.0061 call
0 rows		0.006 START TRANSACTION
0.0061 call
0 rows		0.006 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0061 call
1 row		0.006 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x1E58300012981 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0061 call
0 rows		0.006 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000012 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0062 calls
3 rows		0.003 SELECT * FROM SizeOfCompany ORDER BY orderindex, id
0.0061 call
54 rows		0.006 select id, abbreviation from StateProvince
0.0051 call
0 rows		0.005 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x9FB98C00000006=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0054 calls
1 row		0.001 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x4
0.0051 call
1 row		0.005 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x2BD500001657 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
0.0051 call
1 row		0.005 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x9FB98C00000006 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
0.0052 calls
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x72685500000011) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0051 call
0 rows		0.005 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3FE79F00000005 ORDER BY `DiversityCertification`.`endDate` DESC
0.0051 call
0 rows		0.005 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x40588A000000AC ORDER BY `DiversityCertification`.`endDate` DESC
0.0051 call
1 row		0.005 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3B1F90000015C
0.0051 call
0 rows		0.005 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x52D5F100000012 ORDER BY `DiversityCertification`.`endDate` DESC
0.0051 call
1 row		0.005 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x9FB98C00000006
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F0000000B AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0051 call
1 row		0.005 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x5BA452000000AD) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0052 calls
4 rows		0.002 SELECT * FROM MinorityType ORDER BY orderindex, id
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD500001657 ORDER BY `DiversityCertification`.`endDate` DESC
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000056 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0041 call
0 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000080 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
13 rows		0.004 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x3B1F90000015C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0041 call
0 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F0000001D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
7 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x6BE94700000138 ORDER BY `Address`.`zip`
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F0000000F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 18111748238213292, 23316179154108434, 2469296957555049, 30374313659990327, 17987593618587653)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0041 call
0 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x9FB98C00000007 ORDER BY `Address`.`zip`
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Company, File) WHERE `Company`.`highResImageId`=`File`.`FileId` AND `Company`.`CompanyId`=0xCFAF2F00000001
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0041 call
0 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000054 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x2BD500001658 ORDER BY `Address`.`zip`
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000018 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0041 call
0 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000020 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x9FB98C00000006 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x16AFB7000000B8 ORDER BY `Address`.`zip`
0.0042 calls
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0xC6406A0000004C) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x75BF2500000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0041 call
1 row		0.004 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x40588A000000AC=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x3B1F90000015C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x59C092000001B8 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0041 call
1 row		0.004 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x16AFB7000000B6
0.0041 call
0 rows		0.004 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x452CF30000006E
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x16AFB7000000B2 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0032 calls
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x7FA33F00000053) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3B1F90000015C ORDER BY `DiversityCertification`.`endDate` DESC
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x6BE94700000137 ORDER BY `DiversityCertification`.`endDate` DESC
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x7FA33F000000B0) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x175BC10000042E 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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x6D720600000172) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0032 calls
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x23261600000A4A) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x5F929D0000003B AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
0 rows		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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`SocialNetworkingId`=0x5E837200000213 AND `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1BE659000003EE AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x52D5F100000012
0.0031 call
6 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x52D5F100000013 ORDER BY `Address`.`zip`
0.0031 call
4 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x1E69A00000075 ORDER BY `Address`.`zip`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x6D723700000017 AND `IndividualAddress`.`IndividualId`=0x59C092000001B8)
0.0031 call
0 rows		0.003 COMMIT
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x616987000000B8 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000061 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x8C5D000000169
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x63D6A20000000B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `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`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0xCFAF2F00000001 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x1E6F700000026 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000014 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x72685500000011 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
0 rows		0.003 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x9FB98C00000006=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x6D700C0000002C AND `IndividualAddress`.`IndividualId`=0x23261600000A4A)
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3B1F90000015C ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F000000A4 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x452CF30000006E
0.0031 call
4 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x16AFB7000000B7 ORDER BY `Address`.`zip`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x6BE94700000137
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x2BD500001659 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x5142FE00000140 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x16AFB7000000B6=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0031 call
1 row		0.003 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x9FB98C00000008 ORDER BY `Address`.`zip`
0.0031 call
1 row		0.003 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x3B1F90000015C AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x16AFB7000000B2) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F0000008F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000024 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0031 call
0 rows		0.003 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `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`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0xCFAF2F00000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000080 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3B1F90000015C
0.0021 call
52 rows		0.002 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x1E69A0000006A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`=0xCFAF2F000000A6 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000054 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
1 row		0.002 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x16AFB7000000B6 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x452CF30000006F ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x5473DC0000022A AND `IndividualAddress`.`IndividualId`=0x1E58300012981)
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`=0x6BE9470000061D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
1 row		0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x8C5D000000169 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x16AFB7000000B6
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x52D5F100000013 ORDER BY `Address`.`zip`
0.0021 call
2 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x452CF30000006F 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 (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x52D5F100000012 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
1 row		0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x2BD50001809F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x23261600000A4A AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F0000001B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
1 row		0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x4E054E00000144 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3FE79F00000005
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x9FB98C00000008 AND `IndividualAddress`.`IndividualId`=0xC6406A0000004C)
0.0021 call
2 rows		0.002 SELECT * FROM DiversityCertificationType ORDER BY orderindex, id
0.0021 call
1 row		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x2BD500001658 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xC6406A0000004C AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 17:25:54',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFAF2F00000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2674793', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1531341', `startTime`='2025-09-09 17:25:53', `sessionId`=0x67212C968AC9BDA6, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_alphaSort\\':\\'R*\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.31'
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000061 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000009 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
1 row		0.002 SELECT * FROM uuid FOR UPDATE
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`=0xCFAF2F000000A7 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x7FA33F000000B0 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x40588A000000AE 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x6BE94700000139 ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x52D5F100000012=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x1E69A00000075 ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD500001657
0.0021 call
6 rows		0.002 SELECT * FROM MemberSegment ORDER BY orderindex, id
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x16AFB7000000B8 AND `IndividualAddress`.`IndividualId`=0x1E6F700000026)
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Address`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x16AFB7000000B2 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x9FB98C00000007 ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x6BE94700000139 AND `IndividualAddress`.`IndividualId`=0x6D720600000172)
0.0021 call
2 rows		0.002 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x8C5D000000169
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x16AFB7000000B6 ORDER BY `DiversityCertification`.`endDate` DESC
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x2BD500001658 ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1E69A0000006A ORDER BY `DiversityCertification`.`endDate` DESC
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x452CF30000006E=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x59C092000001B8) 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x452CF30000006F 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`=0x5DD32900000030 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x1E6F700000026 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F0000001E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F000000AB AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`=0x382A690000004A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x40588A000000AC=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x452CF30000006E ORDER BY `DiversityCertification`.`endDate` DESC
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x40588A000000AE ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x2BD500001657=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`=0x241A700000060 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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x9FB98C00000002) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
1 row		0.002 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x40588A000000AC AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F0000008D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0021 call
4 rows		0.002 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x1E69A0000006A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x3FE79F00000007 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x3B1F800000237 ORDER BY `Address`.`zip`
0.0021 call
1 row		0.002 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x1E69A0000006A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0021 call
1 row		0.002 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x3FE79F00000005 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
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`=0x46C64C00000020 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `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`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0xCFAF2F00000001 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x3B1F800000238 AND `IndividualAddress`.`IndividualId`=0x9FB98C00000002)
0.0011 call
3 rows		0.001 SELECT * FROM AddressType ORDER BY orderindex, id
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x9FB98C00000002 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x6D720600000172 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x52D5F100000014 ORDER BY `Address`.`zip`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000083 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x40588A000000AC=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x2BD500043D7C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
3 rows		0.001 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x8C5D000000169=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x4A551900000008 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x59C092000001B8 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x9FB98C00000002 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x40588A000000AC
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`=0x7EB44300000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x5F929D0000003B AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C5D00000016A ORDER BY `Address`.`zip`
0.0011 call
25 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x8C5D00000016A 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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x1E6F700000026) 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`=0x4979200000562 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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x1E58300012981) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F000000C1 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`=0x1C999200000036 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`=0x2A5200000319 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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Branch, Individual, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x5F929D0000003B) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x4D0DEC00000166 AND `IndividualAddress`.`IndividualId`=0x16AFB7000000B2)
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`=0x16AFB7000000B8 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F000000BE AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`=0x4AB5720000005C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x6BE94700000138 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x5DD32900000030 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`=0x4E196C000000EB 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`=0x6E5D330000005B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000057 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`=0xE98100000006 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`=0x2BD50000ECDA 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`=0x8C5D00000016B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x16AFB7000000B7 ORDER BY `Address`.`zip`
0.0011 call
1 row		0.001 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x3B1F90000015C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 18111748238213292, 23316179154108434, 2469296957555049, 30374313659990327)) AND `Relationship`.`relationType` IN (2)) 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`=0x2BD5000147E0 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`=0x9FB98C00000008 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x8C5D000000169 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
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`=0xA147AC00000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F00000090 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`.`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`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, Relationship) WHERE `Relationship`.`RelationshipId`=0x7B58870000000D AND `Relationship`.`parentCompanyId`=`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`=0x6D700C0000002C 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`=0x232A7900000014 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`=0x2BD500003E56 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x452CF90000023C AND `IndividualAddress`.`IndividualId`=0x23261600000A4A)
0.0011 call
2 rows		0.001 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1E69A0000006A
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x40588A000000AE ORDER BY `Address`.`zip`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x6BE94700000137
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C5D00000016A ORDER BY `Address`.`zip`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Membership`.`MembershipId`) AS `MembershipId`, `Membership`.`MembershipTypeId`, `Membership`.`joined`, `Membership`.`expires`, `Membership`.`billingCycle`, `Membership`.`billingStart`, `Membership`.`renewalNoticeSent`, `Membership`.`dateRenewed`, `Membership`.`dateRenewallLetterSent`, `Membership`.`lastRenewallLentDate`, `Membership`.`dateCanncelled`, `Membership`.`cancelReason`, `Membership`.`enteredBy`, `Membership`.`updatedBy`, `Membership`.`dateofPaymeny`, `Membership`.`balanceDue`, `Membership`.`renewalAmount`, `Membership`.`paidDues`, `Membership`.`renewalStatus`, `Membership`.`memberSinceDate`, `Membership`.`status`, `Membership`.`marketingCode`, `Membership`.`mxxUpdated`, `Membership`.`memberRecordComment` FROM (Company, Membership) WHERE `Company`.`MembershipId`=`Membership`.`MembershipId` AND `Company`.`CompanyId`=0xCFAF2F00000001
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x52D5F100000012 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F000000AD AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x5BA452000000AD AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x452CF30000006E AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
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`=0x232EB00000037 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x72685500000011 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`=0x1141630000001E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows		0.001 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFAF2F000000C0 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x7FA33F000000B0 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000017 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F0000008D AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, CalendarItem, Exhibit, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x6BE94700000137 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-09-09 11:25:54')) AND ((`Exhibit`.`submitDate` is not null AND `Exhibit`.`deletedDate` is null) AND ((`Exhibit`.`cancelled`!='Y' OR `Exhibit`.`cancelled` is null) AND `Exhibit`.`canceledDate` is null)))
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x9FB98C00000006
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x5BA452000000AD AND `Individual`.`directoryAddressId`=`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`=0x7B497000002B6 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`=0xA55DC000000002 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1E69A0000006A 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x9FB98C00000007 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x3B1F800000237 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`=0xCFAF2F00000064 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C5D00000016A ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x3FE79F00000005=`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x1E58300012981 AND `Individual`.`directoryAddressId`=`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x1E69A00000075 ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x40588A000000AC
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x3B1F800000238 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x1E69A00000075 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`=0x4AB3FE000001C8 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x16AFB7000000B7 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F00000011 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x16AFB7000000B6=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x8C5D000000169=`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x6D723700000017 ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x6BE94700000137 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x6D720600000172 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3FE79F00000005 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD500001657 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x1E69A0000006A
0.0001 call
5 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x452CF30000006E=`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x4D0DEC00000166 ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x72685500000014 AND `IndividualAddress`.`IndividualId`=0x6D720600000172)
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x23261600000A4A AND `Individual`.`directoryAddressId`=`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x3B1F800000237 ORDER BY `Address`.`zip`
0.0001 call
2 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x452CF30000006E=`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 (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x40588A000000AC ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x452CF30000006E ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x3FE79F00000005
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`=0x1E69A00000076 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xC6406A0000004C AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x16AFB7000000B2 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x8C5D000000169=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F000000A4 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x3FE79F00000007 ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x16AFB7000000B6=`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 (Company, Country, Company2Country) WHERE (0x3FE79F00000005=`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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x6D700C0000002C ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x9FB98C00000006=`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 (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x16AFB7000000B6 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
2 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x2BD500001657=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row		0.000 SELECT COUNT(DISTINCT `Company`.`CompanyId`) AS count FROM (Company) WHERE `Company`.`CompanyId` IN (535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 18111748238213292, 23316179154108434, 2469296957555049, 30374313659990327, 17987593618587653)
0.0001 call
3 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x52D5F100000012=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
3 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x2BD500001657=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
5 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service, Company, Company2Service) WHERE (0x6BE94700000137=`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`=0x6E5D2A00000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x6BE94700000137=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x52D5F100000012=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F000000AB AND `Individual`.`directoryAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAF2F000000BE AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`BranchAffiliationHistory`.`BranchAffiliationHistoryId`) AS `BranchAffiliationHistoryId`, `BranchAffiliationHistory`.`startdate`, `BranchAffiliationHistory`.`enddate`, `BranchAffiliationHistory`.`active`, `BranchAffiliationHistory`.`vote`, `BranchAffiliationHistory`.`rosterOrder` FROM (Individual, BranchAffiliationHistory) WHERE `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x16AFB7000000B2
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`=0x452CF90000023C 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x7FA33F00000053 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x9FB98C00000007 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x7FA33F00000053 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x3FE79F00000007 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`=0x2BD500001657
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`=0x52D5F100000012
0.0001 call
0 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x6BE94700000137=`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`=0x2BD5000150BE 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x6BE94700000138 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x40588A000000AE 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`=0xCFAF2F00000021 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x52D5F100000013 ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x3FE79F00000005=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x5DD32900000030 AND `IndividualAddress`.`IndividualId`=0x1E58300012981)
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x452CF30000006F 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x3B1F800000237 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`=0xCFAF2F00000082 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`=0x53D7C10000020A 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x16AFB7000000B7 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x6BE94700000138 ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x232A7900000014 AND `IndividualAddress`.`IndividualId`=0x16AFB7000000B2)
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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x52D5F100000013 ORDER BY `Address`.`zip`
0.0001 call
4 rows		0.000 SELECT * FROM CompanyStatus 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`=0xCFAF2F0000000C 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`=0x2BD500001E47 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`=0x4790F000009AC 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`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x3FE79F00000007 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`=0x5473DC0000022A 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`=0x4E5096000000CE 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`=0x5A804B00000194 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`=0xB836400000001 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`=0x7C89DA00000005 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`=0x4D0DEC00000166 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`=0x6D723700000017 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`=0x7F42B70000001C 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 (BranchAffiliationHistory, Branch) WHERE `BranchAffiliationHistory`.`BranchAffiliationHistoryId`=0x16AFB7000000BA AND `BranchAffiliationHistory`.`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`=0x9C048100000004 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`=0x52D5F100000014 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`=0x300B400000006 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`=0x5CFAD20000012E 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`=0x6BE94700000139 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`=0x3B1F800000238 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`=0x235599000006D5 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`=0xCFAF2F00000063 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`=0xCD807D0000000E 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`=0xD5EC40000002A 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`=0x4B5320000002BE 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`=0x495CA0000015C 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`=0x6E5D0D000001CD 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`=0x77BE1A0000000D 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`=0x72685500000014 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`=0x77BFC800000007 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`=0x49BB200000508 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`=0xCFAF2F000000AE AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`