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

Nielsen Catalina Solutions

500 Fifth Avenue
56th Floor
New York, NY 10110-5699
United States
| www.ncsolutions.com

Parent Company:
NielsenIQ

NielsenIQ

200 W. Jackson Blvd.
Chicago, IL 60606-6910
United States
Tel: 856-321-2511 | https://nielseniq.com
test@maxx.matrixgroup.net
NielsenIQ NielsenIQ https://www.youtube.com/channel/UCYgAtbXKtOHSPlF81g56c3w NielsenIQ

NielsenIQ (NIQ) is the world’s leading consumer intelligence company, delivering the most complete understanding of consumer buying behavior and revealing new pathways to growth. In 2023, NIQ combined with GfK, bringing together the two industry leaders with unparalleled global reach. With a holistic retail read and the most comprehensive consumer insights—delivered with advanced analytics through state-of-the-art platforms—NIQ delivers The Full View.

NIQ is an Advent International portfolio company with operations in 100+ markets, covering more than 90% of the world’s population.

Primary Contact:
Liz Lundrigan
Project Specialist, Events & Marketing
Products/Services:
Consulting Services
Research
Technology Services
Trade Name:
NIQ
Brands:
NielsenIQ, GfK, Byzzer, BASES

Precima

351 King Street East
Suite 200
Toronto, ON M5A 0L6
Canada
Tel: 301-652-0694 | www.precima.com
test@maxx.matrixgroup.net

Primary Contact:
Mr. Brian Ross
President
Products/Services:
Consulting Services
Parent Company:
NielsenIQ

Conduct Another Search

Debugging Info
pagedictsize=7153
sqltime = 0.196 s
cpu time = 1.050 s
real time = 1.305 s
memory increase = 2636 kB
fields = Company_id: '204D00000004'
action: 'find'
templates =
/data/fmiam/current/fmiam_org/themes/www/webform/searchRSCompanyPublic
scrapeAndDrape FRESH stub: https://www.fmiam.maxx.matrixdev.net/scrape.axd?target=https://www.fmiam.maxx.matrixdev.net/get-involved/directories/association-council-directory-maxx-stub
dg = ['searchCompanyPublic', 'searchCompanyPublic', 'searchRSCompanyPublic', 'searchRSCompanyPublic'] | [194, 194, 204, 204]
extra debug info =
libs.framework.WebForm:fillCursor starting at 1766801787.713...
libs.framework.WebForm:fillCursor took 58.861 ms
libs.framework.WebForm:outputSearchResults starting at 1766801788.086...
libs.framework.WebForm:outputSearchResults took 858.152 ms
queries = 235 queries

Total TimeCountAvg TimeQuery
0.0331 call
54 rows		0.033 select id, abbreviation from StateProvince
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.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... 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`=0x44D75600000053
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`=0x6BAEF600000019
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`=0x582F9000004DE
0.0091 call
4 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`=0x204D00000004
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`=0x12E4500000000
0.00910 calls
244 rows		0.001 SELECT * FROM Country ORDER BY orderindex, id
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.0051 call
3 rows		0.005 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...es` AS membership___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 (35515084570628, 19377062783483987, 1551380842022110) ORDER BY `Company`.`alphaSort`, `Company`.`name` LIMIT 0, 100
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`IndividualAddress`.`IndividualAddressId`) AS `IndividualAddressId`, `IndividualAddress`.`line3` FROM (IndividualAddress) WHERE (`IndividualAddress`.`AddressId`=0x48E1A10000005B AND `IndividualAddress`.`IndividualId`=0x6BAEF600000019)
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`=0x44D75600000053 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`=0x582F9000004DE ORDER BY `DiversityCertification`.`endDate` DESC
0.0021 call
80 rows		0.002 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x205000000000 ORDER BY `Address`.`zip`
0.0021 call
0 rows		0.002 SELECT DISTINCT hex(`DiversityCertification`.`DiversityCertificationId`) AS `DiversityCertificationId`, `DiversityCertification`.`type`, `DiversityCertification`.`startDate`, `DiversityCertification`.`endDate`, `DiversityCertification`.`issuedBy` FROM (Company, DiversityCertification) WHERE `DiversityCertification`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x204D00000004 ORDER BY `DiversityCertification`.`endDate` DESC
0.0022 calls
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 (Branch, Company, BranchAffiliationHistory, Individual) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x12E4500000000) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0021 call
236 rows		0.002 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x204D00000004=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`CompanyId`=0x204D00000004 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.0019 calls
2 rows		0.000 SELECT * FROM YesNo ORDER BY orderindex, id
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 (Branch, Company, BranchAffiliationHistory, Individual) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x6BAEF600000019) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0012 calls
54 rows		0.000 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (TradeShow, CalendarItem, Meeting, Exhibit) WHERE ((((`Exhibit`.`CompanyId`=0x204D00000004 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 15:16:27')) 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
54 rows		0.001 SELECT DISTINCT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x204D00000004=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`
0.0011 call
1 row		0.001 SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (TradeShow, CalendarItem, Meeting, Exhibit) WHERE ((((`Exhibit`.`CompanyId`=0x582F9000004DE AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 15:16:27')) 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.0013 calls
1 row		0.000 SELECT version from databasemap;
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`=0x5831000000011 ORDER BY `Address`.`zip`
0.0011 call
1 row		0.001 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Relationship, Company) WHERE `Relationship`.`RelationshipId`=0x44D760000000B5 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 (TradeShow, CalendarItem, Meeting, Exhibit) WHERE ((((`Exhibit`.`CompanyId`=0x44D75600000053 AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 15:16:27')) 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.0012 calls
8 rows		0.000 SELECT * FROM CompanyStructure ORDER BY orderindex, id
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 (Relationship, Company) WHERE `Relationship`.`RelationshipId`=0x5F1A2C0000001C AND `Relationship`.`parentCompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0001 call
3 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x204D00000004=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
2 rows		0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (35515084570628)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x6BAEF600000019 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`=0x582F9000004DE 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`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x205000000000 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`=0x44D75600000053
0.0001 call
0 rows		0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-12-26 21:16:22',`mxxUpdatedBy`=NULL, `PageRequestId`=0xF56C9200000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3396100', `requestNum`='1', `growth`='15156', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='536590', `startTime`='2025-12-26 21:16:22', `sessionId`=0x1218211F45FE5991, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.09500622749328613', `timeTaken`='52', `dictSize`='2130', `fields`='{\\'Company_id\\':\\'8B6F780000000C\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.150' WHERE `PageRequestId`=0xF56C9200000000
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`=0xF56C920000005D AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x4
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x12E4500000000 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x3
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`=0x44D75600000053
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`=0xF56C920000005D AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000B1 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0002 calls
3 rows		0.000 SELECT * FROM SizeOfCompany ORDER BY orderindex, id
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x44D7560000005E 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`=0x49B51200000005 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x12E4500000000 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`=0x44D75600000053 ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0xF56C920000005D 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 `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x44D75600000054 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 (0x582F9000004DE=`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(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x204D00000004
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`=0x582F9000004DE
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x6BAEF600000019 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`=0x582F9000004DE
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000C2 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
2 rows		0.000 SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (35515084570628, 19377062783483987, 1551380842022110)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`
0.0001 call
2 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x582F9000004DE=`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(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (Company, StateProvince, Company2StateProvince) WHERE (0x44D75600000053=`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`=0x205000000000 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`=0x44D75600000054 ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x44D75600000054 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`=0x204D00000004 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 (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C9200000061 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x44D75600000053=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000C2 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5831000000011 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`=0x48E1A10000005B ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000B8 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x6C70E100000067 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`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5831000000011 ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 21:16:27',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56C920000005C, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3396100', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='536590', `startTime`='2025-12-26 21:16:27', `sessionId`=0x1218211F45FE5991, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_id\\':\\'204D00000004\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.150'
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000D2 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000B1 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT COUNT(DISTINCT `Company`.`CompanyId`) AS count FROM (Company) WHERE `Company`.`CompanyId` IN (35515084570628, 19377062783483987, 1551380842022110)
0.0001 call
1 row		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x582F9000004DE=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address) WHERE `Address`.`AddressId`=0x5A61C60000019D ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000D2 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`=0x46D19900000040 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x205000000000 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`=0xF56C920000005F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows		0.000 SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x44D75600000053=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C920000006D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C92000000B8 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C9200000073 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
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`=0xF56C920000005D
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C9200000070 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`=0xF56C92000000B3 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`=0x4C73CF00000998 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`=0x4594360000008F 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 (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C9200000079 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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`=0x204D00000004
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C9200000064 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`=0x44D75600000054 ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x9
0.0001 call
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`=0xF56C92000000B4 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`=0x52F73F00000061 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`=0x5475B0000000C3 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`=0xF56C92000000D4 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 (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C9200000067 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`=0x5831000000011 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`=0x4998A700000135 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`=0xF56C92000000C4 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 (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C920000007F 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`=0xF56C9200000062 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`=0x5EE3380000001C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x2
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56C920000007C AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x6E9CFA00000166 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`=0x48111F000003DB 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`=0xF56C92000000BA 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`=0xC36D4D00000007 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`=0x5E8C8C00000343 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`=0x48E1A10000005B 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`=0xC008FA00000004 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`=0x6FA55800000016 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`=0xBFCEC500000007 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`=0xE4DE1400000001 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`=0x5B3295000000B6 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`=0x5E8C86000001DA 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`=0xC3231900000004 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`=0x4DCC3D00000015 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`=0x44D7560000005E 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`=0xC337DE00000004 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`=0x5E9B5F00000005 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`=0x6FB03300000013 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`=0xF56C92000000D5 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`=0x361170000001A 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`=0x53BBDF000000BC 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`=0xAE3F7000000004 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`=0xC4649E00000005 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`=0x5E91290000018F 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`=0x36485900000041 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`=0x5E913E00000006 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`=0x72BB3D0000002B 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`=0xADDF7E00000004 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`=0x5A61C60000019D 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`=0x5E993F0000012B 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`=0xC4165F00000004 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`=0x5764D200000127 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`=0x8F5DA00000022 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`=0x1EF64F0000012E 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`=0xA6ED600000035B 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`=0x5E9AA90000007C 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`=0x7CDC230000000B 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`=0x188B33000000B2 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`=0x4F22B700000092 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`=0x470EF300000249 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`=0xF56C92000000C5 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`=0x44C56E00000060 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`=0x5D52E6000001FB 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`=0xECB51500000006 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`=0xF56C92000000BB 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`=0x1195950000005A 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`=0x1542AA00000129 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`=0xF56C920000006B 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`=0x5E7132000003A3 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`=0x6FA8730000000B 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`=0x457003000002AE 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`=0x36CBF000000038 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`=0xF56C9200000080 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`=0x81DF2E00000008 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`=0x4F4C200000006 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`=0x3A5E7000000F0 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`.`profileUploadId`=`File`.`FileId` AND `Company`.`CompanyId`=0xF56C920000005D
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`=0xF56C9200000071 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`=0xF56C9200000068 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`=0x4D9DE600000932 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`=0x26F6D0000001C 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`=0x52F7A6000000A0 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`=0x5E8CE500000159 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`=0x5158F70000003E 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`=0x4FC1EF00000240 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`=0xF56C9200000065 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`=0x5E915900000054 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`=0x578CF000000102 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`=0x578D1A00000ABC 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`=0x6DA9F700000267 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`=0xF56C9200000074 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`=0x5BA9CE0000031C 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`=0xF56C920000007A 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`=0x32551100000004 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`=0x5E936900000125 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`=0x44D7310000011C 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`=0xC313C500000008 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`=0x2BD50002F717 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`=0x4D57D100000253 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`=0xF56C920000006E 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`=0xE060E0000010A 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`=0x11E0800000004 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`=0xF56C9200000077 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`=0x57E5840000002F 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`=0xA8072A00000006 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`=0x45C9040000000C 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`=0x1E2EC300000038 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`=0x4CBD6900000063 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`=0x45AE1C00000483 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`=0x5E9B57000000A9 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`=0xB0C8BE00000007 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`=0x4CBA4A00000211 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`=0x1EE8080000021E 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`=0x888AE000000005 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`=0x84AE910000000A 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`=0x6684F500000058 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`=0xF56C920000005D
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`=0xF56C920000007D 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
4 rows		0.000 SELECT * FROM MinorityType ORDER BY orderindex, id
0.0001 call
6 rows		0.000 SELECT * FROM MemberSegment ORDER BY orderindex, id