About Us
- About Us
- History
- Leadership
- Staff
- Policy Statements
- Contact Us
- Careers
  - Job Listings
- Year in Review
Join FMI
Careers
- Job Listings
Newsroom
- Latest News
- News Archive
  - 2024
  - 2023
  - 2022
  - 2021
  - 2020
  - 2019
  - 2018
  - 2017
  - 2016
  - 2015
  - 2014
  - 2013
  - 2012
  - 2011
  - 2010
  - 2009
  - 2008
  - 2007
  - 2006
  - 2005
  - 2004
  - 2003
  - 2002
  - 2001
  - 2000
  - 1999
  - 1998
- Press Credentials
- Voice of The Food Industry Blog
Store

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

JOH

20 Commerce Dr – Suite 350
Cranford, NJ 07016-3617
United States
Tel: 978-663-9000 | https://www.johare.com/

JOH is one of the strongest brokers in the country. With offices and strategic partnerships across the United States, we are extremely focused on finding profitable solutions for both our clients and customers. At JOH we deeply believe in selling the right way, with passion and integrity.

Our teams represent each client with tenacity and respect. We deliver on all fronts by offering the best in all services and extraordinary access to decision makers.

JOH is family-owned, privately held and Driven To Sell Right.

Primary Contact:
Mr. John Saidnawey
Executive Chairman of the Board

Products/Services:
Baby Care
Beverages
Brokers
Confectionery
Fixtures/Shelving/Floors
Food Products/Snacks
Nonfoods
Health & Beauty Care
Household Products/Cleaning/Supplies
Merchandising Services
Natural/Organic
Perishables
Pet Health & Nutrition
Point-of-Sale Equipment

Trade Name:
JOH

Conduct Another Search

2345 Crystal Drive, Suite 800, Arlington, VA 22202 | phone: 202-452-8444 | fax: 202-429-4519

Website design by Matrix Group International, Inc. ®

Sign Up for the

FREE daily briefing on top stories in food retailing.

fmi-icon-frozen-goods
fmi-icon-workforce
fmi-icon-certificate
fmi-icon-pharmacy
fmi-icon-food-safety
fmi-icon-asset-protection
fmi-icon-education force-icon-3
fmi-icon-research
fmi-icon-government-affairs
fmi-icon-get-involved
fmi-icon-industry-topic force-icon-3
fmi-icon-labeling
fmi-icon-corporate-social-responsibility
fmi-icon-payments
fmi-icon-crisis-management
fmi-icon-private-brands
fmi-icon-food-assistance
fmi-icon-supplier-diversity
fmi-icon-fresh-foods
fmi-icon-supply-chain
fmi-icon-general-merchandise
fmi-icon-technology
fmi-icon-health-wellness
fmi-icon-total-store-collaboration
fmi-icon-Health-Reform
fmi-icon-wage-labor
fmi-icon-independent-operator
fmi-icon-wholesaler-topic
fmi-icon-newsroom force-icon-3
fmi-icon-tax-reform
fmi-icon-about_icon force-icon-4
fmi-icon-about_icon
fmi-icon-cart
fmi-icon-blog_icon force-icon-5
fmi-icon-cart
fmi-icon-Communications
fmi-icon-omnichannel
fmi-icon-biotechnology-topic

Total Time

Count

Avg Time

Query

0.033

1 call
1013 rows

0.033

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.030

1 call
1089 rows

0.030

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.024

1 call
1089 rows

0.024

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.022

1 call
717 rows

0.022

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.020

1 call
1 row

0.020

SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0xAB690000001D

0.016

1 call
0 rows

0.016

SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (SocialNetworking, Individual) WHERE `SocialNetworking`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x1B9B200000040

0.014

11 calls
2 rows

0.001

SELECT * FROM YesNo ORDER BY orderindex, id

0.009

3 calls
244 rows

0.003

SELECT * FROM Country ORDER BY orderindex, id

0.008

4 calls
54 rows

0.002

SELECT * FROM StateProvince ORDER BY orderindex, id

0.006

5 calls
1 row

0.001

SELECT version from databasemap;

0.005

2 calls
21 rows

0.002

SELECT * FROM MembershipType ORDER BY orderindex, id

0.005

2 calls
8 rows

0.002

SELECT * FROM CompanyStructure ORDER BY orderindex, id

0.004

1 call
2 rows

0.004

SELECT * FROM DiversityCertificationType ORDER BY orderindex, id

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56B8800000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.004

2 calls
1 row

0.002

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Individual, Branch, Company, BranchAffiliationHistory) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x1B9B200000040) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

1 call
0 rows

0.003

COMMIT

0.003

1 call
1 row

0.003

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`CompanyId`=0xAB690000001D 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.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0xF56B8800000001 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56B8800000011 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.003

1 call
1 row

0.003

SELECT COUNT(DISTINCT `Company`.`CompanyId`) AS count FROM (Company) WHERE `Company`.`CompanyId` IN (188467459915805)

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56B880000001D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.003

1 call
1 row

0.003

SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x4

0.003

1 call
1 row

0.003

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Company) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0xAB690000001D ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.003

1 call
0 rows

0.003

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`=0xF56B8800000001

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56B8800000024 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56B8800000018 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.003

1 call
54 rows

0.003

select id, abbreviation from StateProvince

0.002

2 calls
3 rows

0.001

SELECT * FROM SizeOfCompany ORDER BY orderindex, id

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x1B9B200000040 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56B8800000014 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Relationship) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (188467459915805)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.002

1 call
173 rows

0.002

SELECT * FROM webselect

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56B8800000017 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Company, File) WHERE `Company`.`highResImageId`=`File`.`FileId` AND `Company`.`CompanyId`=0xF56B8800000001

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56B8800000009 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.002

1 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`=0xAB690000001D ORDER BY `DiversityCertification`.`endDate` DESC

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56B880000001B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.002

1 call
0 rows

0.002

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`=0xF56B8800000001

0.002

1 call
4 rows

0.002

SELECT * FROM CompanyStatus ORDER BY orderindex, id

0.002

1 call
1 row

0.002

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..._renewalAmount, `membership`.`paidDues` 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 (188467459915805) ORDER BY `Company`.`alphaSort`, `Company`.`name` LIMIT 0, 100

0.001

1 call
0 rows

0.001

START TRANSACTION

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0xF56B8800000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 call
10 rows

0.001

SELECT * FROM SocialNetwork ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xF56B8800000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.001

1 call
1 row

0.001

SELECT COUNT(DISTINCT `Exhibit`.`ExhibitId`) AS count FROM (Exhibit, Meeting, CalendarItem, TradeShow) WHERE ((((`Exhibit`.`CompanyId`=0xAB690000001D AND `Exhibit`.`TradeShowId`=`TradeShow`.`TradeShowId`) AND `TradeShow`.`MeetingId`=`Meeting`.`MeetingId`) AND (`CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `CalendarItem`.`endDate`>='2024-12-26 08:03:00')) 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.001

1 call
11 rows

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`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`=0xAB6900000024 ORDER BY `Address`.`zip`

0.001

2 calls
4 rows

0.000

SELECT * FROM MinorityType ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0xF56B8800000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x5E8410000002DA AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0xF56B8800000001 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Branch, Address) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0xAB6900000024 ORDER BY `Address`.`zip`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Company, Relationship) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0xAB690000001D

0.000

1 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`=0xF56B8800000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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`=0xF56B880000000B AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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`=0x1B9B200000040 AND `Individual`.`directoryAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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`=0xF56B8800000020 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
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`=0x8C2FA000003F6 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
14 rows

0.000

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Service, Company2Service) WHERE (0xAB690000001D=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.000

1 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`=0xAB6900000024 ORDER BY `Address`.`zip`

0.000

1 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`=0xAB690000001D

0.000

1 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`=0xF56B880000000F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 14:03:00',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56B8800000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3353421', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='512482', `startTime`='2025-12-26 14:03:00', `sessionId`=0x36F35F040AA01735, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_id\\':\\'AB690000001D\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.150'

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company2Country, Company, Country) WHERE (0xAB690000001D=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex

0.000

1 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 (0xAB690000001D=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2StateProvince`.`CompanyId` AND `Company2StateProvince`.`StateProvinceId`=`StateProvince`.`StateProvinceId`) ORDER BY `StateProvince`.`description`

0.000

1 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`=0xAB6900000024 ORDER BY `Address`.`zip`

0.000

1 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`=0xF56B880000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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`=0x2BD50000251D ORDER BY `Address`.`zip`

0.000

1 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`=0xF56B880000001E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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`=0xF56B8800000012 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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`=0xF56B8800000023 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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`=0xF56B8800000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
6 rows

0.000

SELECT * FROM MemberSegment ORDER BY orderindex, id

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

0.000

1 call
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`=0x8325ED00000008 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 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`=0xF56B8800000021 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0x2BD50000251D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0x19979D00000143 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0x490DDC00001057 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0xB46B1600000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0xF2685500000005 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0x2D61FC00000093 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0x4A07D00000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
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`=0x5693620000038D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

920014 function calls (910661 primitive calls) in 1.888 seconds Ordered by: cumulative time List reduced from 2381 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.889 1.889 /data/fmiam/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 1.185 1.185 /data/fmiam/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.093 1.093 /data/fmiam/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.093 1.093 /data/fmiam/current/fmiam_org/sites/www/forms/fmiam_CompanyFormPublic.py:19(search) 1 0.000 0.000 1.093 1.093 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:87(search) 1 0.000 0.000 1.062 1.062 /data/fmiam/current/libs/framework/WebForm.py:1089(search) 1 0.000 0.000 0.714 0.714 /data/fmiam/current/libs/framework/WebForm.py:1505(mungeResultsAfterSearch) 1 0.000 0.000 0.671 0.671 /data/fmiam/current/libs/framework/WebManager.py:88(createNewHandler) 1 0.000 0.000 0.671 0.671 /data/fmiam/current/libs/framework/WebSite.py:91(__init__) 2 0.000 0.000 0.607 0.304 /data/fmiam/current/libs/utils/decoratorutils.py:282(wrapper) 1 0.000 0.000 0.475 0.475 /data/fmiam/current/libs/framework/WebForm.py:1653(outputSearchResults) 1 0.000 0.000 0.425 0.425 /data/fmiam/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 357/167 0.010 0.000 0.425 0.003 {built-in method builtins.exec} 1 0.000 0.000 0.422 0.422 /data/fmiam/current/libs/framework/WebApp.py:212(wrapHTML) 205/128 0.001 0.000 0.415 0.003 :1165(_find_and_load) 224/143 0.005 0.000 0.413 0.003 :666(_load_unlocked) 205/128 0.001 0.000 0.412 0.003 :1120(_find_and_load_unlocked) 222/143 0.001 0.000 0.390 0.003 :934(exec_module) 1 0.008 0.008 0.356 0.356 /data/fmiam/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups) 124 0.001 0.000 0.340 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 124 0.001 0.000 0.337 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.305 0.305 /data/fmiam/current/libs/framework/DisplayGroup.py:311(initialize) 124 0.001 0.000 0.301 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 124 0.301 0.002 0.301 0.002 {function Connection.query at 0xfb9050a798a0} 1 0.000 0.000 0.277 0.277 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:718(process) 455/262 0.000 0.000 0.258 0.001 :233(_call_with_frames_removed) 1 0.000 0.000 0.235 0.235 /data/fmiam/current/libs/framework/WebForm.py:3254(processCursorForSearch) 27/1 0.000 0.000 0.235 0.235 /data/fmiam/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 1 0.000 0.000 0.235 0.235 /data/fmiam/current/libs/framework/DGEGroup.py:43(getDataDictionary) 66 0.001 0.000 0.220 0.003 /data/fmiam/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 2 0.001 0.000 0.211 0.105 /data/fmiam/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML) 8 0.016 0.002 0.206 0.026 /data/fmiam/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile) 8 0.147 0.018 0.190 0.024 /data/fmiam/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 21970/21530 0.029 0.000 0.182 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 9/8 0.000 0.000 0.157 0.020 /data/fmiam/current/libs/framework/DGEMethod.py:107(getDataDictionary) 314/121 0.001 0.000 0.155 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:108(new_init) 222 0.002 0.000 0.154 0.001 :1007(get_code) 21994/21534 0.032 0.000 0.154 0.000 {built-in method builtins.__import__} 78 0.003 0.000 0.148 0.002 /usr/lib/python3.11/re/__init__.py:272(_compile) 76 0.000 0.000 0.148 0.002 /usr/lib/python3.11/re/__init__.py:225(compile) 1 0.000 0.000 0.146 0.146 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 149 0.000 0.000 0.145 0.001 /data/fmiam/current/libs/framework/DGEAttribute.py:110(getDataDictionary) 1 0.000 0.000 0.145 0.145 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.145 0.145 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 40 0.000 0.000 0.144 0.004 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.143 0.143 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.143 0.143 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.143 0.143 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.143 0.143 /data/fmiam/current/libs/framework/WebForm.py:1301(getCompleteSearchPC) 1 0.000 0.000 0.141 0.141 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.141 0.141 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.005 0.005 0.141 0.141 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 9/3 0.000 0.000 0.137 0.046 /data/fmiam/current/libs/PLayer/PersistentBroker.py:769(processCriteria) 4 0.000 0.000 0.136 0.034 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 4 0.000 0.000 0.136 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 4 0.000 0.000 0.136 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 4 0.000 0.000 0.135 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 6 0.000 0.000 0.135 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 6 0.001 0.000 0.135 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 222 0.001 0.000 0.133 0.001 :727(_compile_bytecode) 1 0.000 0.000 0.133 0.133 /data/fmiam/current/libs/framework/WebForm.py:2983(fillCursor) 183 0.003 0.000 0.131 0.001 /data/fmiam/current/libs/framework/DGEAttribute.py:206(getValue) 222 0.129 0.001 0.129 0.001 {built-in method marshal.loads} 121 0.007 0.000 0.129 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:348(__init__) 10/4 0.001 0.000 0.127 0.032 /data/fmiam/current/libs/PLayer/PersistentBroker.py:899(_preprocessCriteria) 40 0.000 0.000 0.115 0.003 /usr/lib/python3.11/re/_compiler.py:573(_code) 19 0.000 0.000 0.109 0.006 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 635/473 0.001 0.000 0.108 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2679(__getattr__) 53/42 0.000 0.000 0.107 0.003 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 1 0.000 0.000 0.105 0.105 /data/fmiam/current/libs/framework/DGEEmail.py:1() 1 0.000 0.000 0.104 0.104 /data/fmiam/current/libs/framework/DisplayedAttribute.py:208(getCriteria) 1 0.001 0.001 0.104 0.104 /data/fmiam/current/libs/framework/DisplayedAttribute.py:228(process) 11 0.000 0.000 0.102 0.009 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML) 110 0.093 0.001 0.100 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.099 0.099 /data/fmiam/current/libs/framework/WebManInterface.py:92(createBroker) 199/181 0.000 0.000 0.095 0.001 /data/fmiam/current/libs/PLayer/PersistentBroker.py:77(__new__) 6 0.000 0.000 0.094 0.016 /data/fmiam/current/generic/classes/Address.py:226(getPrintPrettyHTML) 2875 0.005 0.000 0.094 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 120 0.000 0.000 0.092 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2778(_loadDefaults) 1 0.000 0.000 0.091 0.091 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 1 0.000 0.000 0.090 0.090 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1() 88 0.013 0.000 0.090 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2825(_loadDefaultAssocs) 1 0.000 0.000 0.090 0.090 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1() 1 0.000 0.000 0.090 0.090 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 1 0.026 0.026 0.088 0.088 /data/fmiam/current/libs/PLayer/PersistentBroker.py:441(retrieveClassMaps) 1 0.000 0.000 0.079 0.079 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:27(_manipulateLogin) 806/40 0.007 0.000 0.078 0.002 /usr/lib/python3.11/re/_compiler.py:37(_compile) 3191 0.020 0.000 0.077 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2796(_setDefaultAssoc) 43 0.001 0.000 0.073 0.002 /data/fmiam/current/libs/PLayer/PersistentBroker.py:335(processSql) 294/265 0.005 0.000 0.073 0.000 /data/fmiam/current/libs/framework/LazyDict.py:186(__getitem__) 5 0.000 0.000 0.072 0.014 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:176(_getDGByName) 5 0.000 0.000 0.072 0.014 /data/fmiam/current/libs/framework/WebSite.py:972(getDGByName) 5 0.000 0.000 0.072 0.014 /data/fmiam/current/libs/framework/LazyDict.py:172(get) 21/2 0.001 0.000 0.072 0.036 /data/fmiam/current/libs/framework/BaseHandler.py:481(_createDisplayGroup) 10 0.000 0.000 0.070 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.011 0.001 0.070 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 2875 0.006 0.000 0.070 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 2691 0.015 0.000 0.067 0.000 /data/fmiam/current/libs/PLayer/PersistentBroker.py:177(loadClass) 133/19 0.001 0.000 0.066 0.003 /data/fmiam/current/libs/framework/DisplayGroup.py:631(_createDGE) 1 0.000 0.000 0.064 0.064 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:707(_drape)

Search Results

JOH

Mega Menu

Sign Up for the