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

AKI Technologies

375 Alabama St.
Suite 480
San Francisco, CA 94110-7329
United States
| https://www.a.ki/

Parent Company:
Inmar Inc.

Collective Bias

1750 S. Osage Springs Drive
Suite 100
Rogers, AR 72758-8320
United States
Tel: 479-268-3232 | www.collectivebias.com

We reach hard-to-reach affinity groups like Latinas or Millennials. We drive traffic via inspiring real life product stories promoting new items. We amplify demos to spike sales outside the 4-6 hour demo period. We make new store openings incredibly successful. And we do all this by using social media to solve shopper marketing problems.

CB harnesses the power of social content through our community of geographically and demographically diverse social influencers who have micro audiences centered on specific affinities and passions. They have incredible reach and their content generates high levels of engagement with value-conscious shoppers; this content gets deployed across all social channels and initiates two-way conversations directly with customers to influence purchase decisions.

This is shopper social media and CB is the only one who does it.

Products/Services:
Advertising/Marketing and Design
Consulting Services
Parent Company:
Inmar Inc.

Inmar Inc.


formerly CLS/MedTurn

One West Fourth St.
Suite 500
Winston Salem, NC 27101-3971
United States
Tel: 336-770-1969 | https://www.inmar.com/
test@maxx.matrixgroup.net
https://www.linkedin.com/company/inmarintelligence/mycompany/ inmarintelligence

For more than 40 years — through curiosity and the intelligent use of data and
technology — we’ve been uncovering valuable insights that make it easier for brands and retailers to understand, predict and meet the personalized needs of shoppers. Today, we continue to empower brands and retailers to maximize value to their customers by offering the leading self-service loyalty platform — with best-in-class audience selection, hyper-personalization of incentives + media, advanced analytics, and enhanced measurement. Thanks to proprietary technology, we can apply hundreds of contextual rules to each incentive, creative element, and copy, ensuring personalized media and offers that resonate with shoppers and deliver enhanced results for retailers and advertisers.

Primary Contact:
Kathy Hayden
Senior Vice President, Strategic Partnerships
Products/Services:
Advertising/Marketing and Design
Consulting Services
Financial Services
Pharmaceuticals
Private Brands
Research
Supply Chain
Technology Services
Unsaleables
Other - Promotions, Recalls, Retail Media, eCommerce, Digital Coupons and Incentives, Loyalty
Trade Name:
Inmar Intelligence

Willard Bishop, LLC, an Inmar Analytics Company

840 S. Northwest Highway
Barrington, IL 60010-4622
United States
Tel: 847-381-4443 | www.willardbishop.com

Products/Services:
Consulting Services
Research
Parent Company:
Inmar Inc.

Conduct Another Search

Debugging Info
pagedictsize=8360
sqltime = 0.159 s
cpu time = 0.640 s
real time = 0.853 s
memory increase = 16240 kB
fields = Company_id: '2BD500017F41'
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 1766782570.618...
libs.framework.WebForm:fillCursor took 61.691 ms
libs.framework.WebForm:outputSearchResults starting at 1766782571.020...
libs.framework.WebForm:outputSearchResults took 338.630 ms
queries = 191 queries

Total TimeCountAvg TimeQuery
0.0121 call
1089 rows		0.012 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (31895702745382913, 48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 64810257632722949, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 1349465839504470, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 48193828032356, 35269356606717961, 64462202072989704, 30753756840722523, 48193828117193, 404701883400249, 48193828117367, 235123689652241, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828029632, 48193828158615, 48193828143607, 306926952906752, 38152417828667406, 4819382...8193828168925, 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, 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, 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, 48193828166138, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828173635, 48193828109981, 48193828173551, 1257046733226076, 48193828056206, 1176915528385066, 967711966363685, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 967733441200187, 967733441200142, 48193828180272, 48193828176366, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 967703376429092, 48193828175541, 48193828173572, 335930867056662, 48193828179965, 48193828173600, 31744610090876929, 6575393066713768, 232499464634397, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828173621, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828173544, 967742031134743, 967724851265564, 48193828174274, 967720556298260, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 48193828180279, 967720556298275, 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.0111 call
1089 rows		0.011 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (31895702745382913, 48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 64810257632722949, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 1349465839504470, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 48193828032356, 35269356606717961, 64462202072989704, 30753756840722523, 48193828117193, 404701883400249, 48193828117367, 235123689652241, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828029632, 48193828158615, 48193828143607, 306926952906752, 38152417828667406, 4819382... 11852383160108192, 8305831095304631, 48193828174539, 48193828170987, 48193828169112, 48193828169175, 48193828180667, 48193828114377, 2367772520612339, 2367622196756881, 2367815470284875, 21934286311522621, 48193828167248, 48193828180999, 2367755340743310, 48193828176737, 48193828176744, 48193828176751, 1073789068640293, 1359348559250531, 32429571475243022, 11654093109985289, 11654157534495182, 11654226253971512, 11654294973448260, 687723048337421, 48193828176599, 687710163435647, 48193828176606, 29210257263689844, 27724585126330911, 27723081887779584, 27723236506599430, 44973762197585921, 25849604268359851, 48193828090517, 44974045665427457, 535127155277873, 16715089298063361, 535152925081607, 48193828169077, 16715089298063541, 16715011988653234, 535161515016213, 535152925081638, 535114270375999, 19472157654384803, 16713792217940061, 55057185767705, 13980127138414836, 2367686621267365, 11654325038219327, 11654436707368961, 2367755340742739, 156641752252510, 48193828181029, 48193828168677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828040203, 22880901398528016, 48193828172710, 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, 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, 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, 48193828166138, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0101 call
1013 rows		0.010 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (31895702745382913, 48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 64810257632722949, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 1349465839504470, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 48193828032356, 35269356606717961, 64462202072989704, 30753756840722523, 48193828117193, 404701883400249, 48193828117367, 235123689652241, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828029632, 48193828158615, 48193828143607, 306926952906752, 38152417828667406, 4819382...7302999045, 48193828030128, 48193828150706, 48193828148359, 48193828169182, 68076447117344770, 52184385222344708, 2238249191866945, 48193828150986, 12224310148071565, 7684963507897137, 48193828153216, 48193828031909, 51599737094162, 48193828123819, 30389268736115441, 48193828146093, 21627011466264588, 9147876613554279, 109474421407761, 13354028280841235, 30040221038937604, 905318976454657, 48193828033854, 678394379370591, 34313709203488776, 48193828150580, 48193828131395, 24773281169015345, 979480176754798, 48193828165752, 25006755591225351, 66988458886823938, 326353089986574, 35205846925312, 25202064934044054, 26168411100807461, 48193828122683, 48193828154699, 31232349341483315, 28287049748447241, 21895584361218392, 47540404588904453, 26116317442474599, 22973084281602062, 19486782018027913, 499775279464571, 149413322293248, 96546569846812, 535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 1040107935105372, 581250809069571, 48193828148840, 18111748238213292, 23316179154108434, 48193828159432, 48193828159465, 48193828159577, 48193828031484, 48193828112847, 48193828160240, 57468904393408517, 40991249477402625, 48193828161028, 2469296957555049, 30374313659990327, 37306085933056, 48193828138111, 48193828065993, 48193828029326, 12329992113356956, 48193828113885, 48193828174888, 48193828180919, 48193828166948, 48193828058562, 52965029888131079, 29588102716589010, 48193828039269, 48193828105499, 48193828031179, 48193828156908, 48193828167047, 196486163857424, 19599791197520009, 33825354242064388, 24964128040813598, 25809437734208084, 1602800190489369, 32769131589664794, 2214287569324644, 23607300627366204, 48193828167304, 32064799902793729, 3326095688467149, 682749476208642, 48193828167352, 20191040690454691, 34905027415900176, 55057185767613, 48193828147656, 15282060574851266, 48193828167390, 17037890450096234, 18362179191309061, 1795034336722955, 48193828135845, 38395268164485132, 1845903929376935, 36542213114560514, 48193828167527, 26388558239498617, 63407491249078289, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 48193828114808, 48193828167645, 48193828039942, 25877147893629655, 60249345961754628, 5299800664703052, 48193828150461, 43492651315494917, 48193828142520, 2142054809340137, 19329805258326193, 497945623396397, 48193828167998, 48193828168001, 48193828030451, 48193828168035, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 34673270980626, 55905905664851974, 48193828061517, 51425872523034627, 52529627578499073, 48193828030496, 48193828029109, 19898476108186045, 49938254765490177, 37697898619600925, 30510172065497133, 33491351815323714, 48193828168176, 53586863843180549, 48193828168209, 1338281744664875, 48193828137581, 12338388774420541, 1419332072507548, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 24515003310670200, 48193828035598, 38534446579712, 11631153689657352, 36485747179594, 48193828143774, 48193828041120, 26716560596926921, 48193828168390, 30601281206747889, 8264552164622941, 48193828168620, 48193828168626, 48193828031364, 99866579566604, 48193828168721, 26759883932041694, 48193828168743, 113060719099907, 48193828114313, 26173758335090698, 48193828168632, 48193828168635, 28008903371390978, 50773750458613790, 30677486811480090, 55354337374765061, 32244905061384197, 55485093359124485, 48193828028740, 48193828040756, 48193828167566, 48193828028816, 48193828028813, 48193828039007, 48193828089272, 48193828028880, 48193828028888, 48193828028935, 48193828059861, 48193828028939, 63881569739210756, 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.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`=0x724A870000000C
0.0091 call
0 rows		0.009 SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Individual) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x68B59100000013
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`=0x717C000000013
0.0091 call
2 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`=0x2BD500017F41
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`=0x2BD50001A842
0.0081 call
4 rows		0.008 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...p___paidDues, `membership`.`renewalStatus` AS membership___renewalStatus, `membership`.`memberSinceDate` AS membership___memberSinceDate, `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 (48193828126529, 32170091026055180, 1996438238134291, 48193828137026) ORDER BY `Company`.`alphaSort`, `Company`.`name` LIMIT 0, 100
0.0071 call
717 rows		0.007 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.0041 call
0 rows		0.004 COMMIT
0.0037 calls
54 rows		0.000 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0033 calls
244 rows		0.001 SELECT * FROM Country ORDER BY orderindex, id
0.00211 calls
2 rows		0.000 SELECT * FROM YesNo ORDER BY orderindex, id
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`=0x2BD50001A842 ORDER BY `DiversityCertification`.`endDate` DESC
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`=0x724A870000000C ORDER BY `DiversityCertification`.`endDate` DESC
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`=0x717C000000013 ORDER BY `DiversityCertification`.`endDate` DESC
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`=0x2BD500017F41 ORDER BY `DiversityCertification`.`endDate` DESC
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`CompanyId`=0x2BD500017F41 AND `Company`.`CompanyId` IN (31895702745382913, 48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 64810257632722949, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 1349465839504470, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 48193828032356, 35269356606717961, 64462202072989704, 30753756840722523, 48193828117193, 404701883400249, 48193828117367, 235123689652241, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828029632, 48193...614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 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, 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, 48193828166138, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828173635, 48193828109981, 48193828173551, 1257046733226076, 48193828056206, 1176915528385066, 967711966363685, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 967733441200187, 967733441200142, 48193828180272, 48193828176366, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 967703376429092, 48193828175541, 48193828173572, 335930867056662, 48193828179965, 48193828173600, 31744610090876929, 6575393066713768, 232499464634397, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828173621, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828173544, 967742031134743, 967724851265564, 48193828174274, 967720556298260, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 48193828180279, 967720556298275, 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.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, Exhibit, CalendarItem, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x724A870000000C AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 09:56:10')) 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.0015 calls
1 row		0.000 SELECT version from databasemap;
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 (BranchAffiliationHistory, Company, Individual, Branch) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x68B59100000013) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0x2BD50001A843 ORDER BY `Address`.`zip`
0.0012 calls
1 row		0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x4
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, Exhibit, CalendarItem, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x2BD50001A842 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 09:56:10')) 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
10 rows		0.001 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0x2BD500017F42 ORDER BY `Address`.`zip`
0.0012 calls
21 rows		0.000 SELECT * FROM MembershipType ORDER BY orderindex, id
0.0011 call
0 rows		0.001 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x724A870000000C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, Exhibit, CalendarItem, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x2BD500017F41 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 09:56:10')) 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(`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`=0x37C7A500000058 AND `Relationship`.`parentCompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`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`=0x724A9A00000010 AND `Relationship`.`parentCompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`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`=0x467AA600000107 AND `Relationship`.`parentCompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Meeting, Exhibit, CalendarItem, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0x717C000000013 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 09:56:10')) 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
173 rows		0.001 SELECT * FROM webselect
0.0012 calls
8 rows		0.000 SELECT * FROM CompanyStructure ORDER BY orderindex, id
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD50001A842 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Company, File) WHERE `Company`.`profileUploadId`=`File`.`FileId` AND `Company`.`CompanyId`=0xF56BD600000001
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 (0x724A870000000C=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`=0x2BD50001A843 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`=0x2BD50001A844 AND `IndividualAddress`.`IndividualId`=0x68B59100000013)
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`=0x2BD50001A843 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000066 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x724A870000000C
0.0001 call
3 rows		0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828126529, 32170091026055180, 1996438238134291, 48193828137026)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0001 call
3 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0x717C000000012 ORDER BY `Address`.`zip`
0.0001 call
3 rows		0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828126529)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0002 calls
3 rows		0.000 SELECT * FROM SizeOfCompany ORDER BY orderindex, id
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 (0x2BD50001A842=`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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000008B AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
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`=0x2BD50001A842
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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000084 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 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`=0xF56BD600000001 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0001 call
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`=0x724A870000000C ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
54 rows		0.000 select id, abbreviation from StateProvince
0.0001 call
2 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0x724A870000000D 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000055 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 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`=0xF56BD600000001 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
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`=0x724A870000000D ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 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`=0xF56BD600000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
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`=0x724A870000000D ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Service, Company2Service) WHERE (0x724A870000000C=`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 (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x2BD50001A843 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000077 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
3 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x2BD500017F41=`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 (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x717C000000012 ORDER BY `Address`.`zip`
0.0001 call
3 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x2BD50001A842=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000003 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`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x2BD500017F42 ORDER BY `Address`.`zip`
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`=0x717C000000013
0.0001 call
10 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Service, Company2Service) WHERE (0x2BD500017F41=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000087 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 (0x717C000000013=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
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`=0x724A870000000C
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`=0x724A9200000001 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0x68B59100000013 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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 (0x717C000000013=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD500017F41
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`=0x2BD50001A842
0.0002 calls
4 rows		0.000 SELECT * FROM MinorityType ORDER BY orderindex, id
0.0001 call
2 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Service, Company2Service) WHERE (0x2BD50001A842=`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`=0x2BD500017F41 ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT COUNT(DISTINCT `Company`.`CompanyId`) AS count FROM (Company) WHERE `Company`.`CompanyId` IN (48193828126529, 32170091026055180, 1996438238134291, 48193828137026)
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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000066 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 (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x717C000000013 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000005C 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 (0x2BD500017F41=`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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0x2BD500017F42 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000006D 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000008B 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000084 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 15:56:10',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56BD600000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3365179', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='519524', `startTime`='2025-12-26 15:56:10', `sessionId`=0x762B4D1C71811BC9, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_id\\':\\'2BD500017F41\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.150'
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`=0x2BD500017F42 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 (Address) WHERE `Address`.`AddressId`=0x6D8FF800000033 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0x68B59100000013 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000055 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x717C000000013
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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000008D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
2 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Service, Company2Service) WHERE (0x717C000000013=`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 (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x717C000000012 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000000B 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000006D 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 (Branch, Address) WHERE `Address`.`AddressId`=0x5574400000076 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 (Address) WHERE `Address`.`AddressId`=0x2BD50001A844 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000086 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000005C 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 (Branch, Address) WHERE `Address`.`AddressId`=0x724A9200000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x8163BE00000004 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`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x717C000000012 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000011 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE
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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000068 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000014 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0x724A870000000D 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000020 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000017 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000057 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x31F5DE000001D0 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000006 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 (Address) WHERE `Address`.`AddressId`=0x717C000000015 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`=0x2BD500017F41
0.0001 call
0 rows		0.000 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`=0xF56BD600000001
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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000077 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 (Branch, Address) WHERE `Address`.`AddressId`=0x2BD50001A844 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD600000023 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0xF56BD60000001D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000079 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000005E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Company, File) WHERE `Company`.`highResImageId`=`File`.`FileId` AND `Company`.`CompanyId`=0xF56BD600000001
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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000009 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000006F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
10 rows		0.000 SELECT * FROM SocialNetwork 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000018 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000001B 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000008E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x717C000000015 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x3450170000014E 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000001E 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000069 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x5802AD000000B5 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000024 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000005F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x6D8FF800000033 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000070 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x1B55700000068 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000012 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x1DC7A00000053 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000000F 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000058 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x14A0400000038 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xDDB04D00000005 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xE2A30800000002 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD600000021 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 (Branch, Address) WHERE `Address`.`AddressId`=0xF56BD60000007A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
4 rows		0.000 SELECT * FROM CompanyStatus ORDER BY orderindex, id
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x6AD390000002F5 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x5780AA000001A6 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
2 rows		0.000 SELECT * FROM DiversityCertificationType ORDER BY orderindex, id
0.0001 call
3 rows		0.000 SELECT * FROM AddressType ORDER BY orderindex, id
0.0001 call
6 rows		0.000 SELECT * FROM MemberSegment ORDER BY orderindex, id
0.0001 call
0 rows		0.000 START TRANSACTION