SELECT SQL_CALC_FOUND_ROWS bos_member.* , GROUP_CONCAT(DISTINCT `directoryClassificationSelectedText`.optionName SEPARATOR ', ') AS `directoryClassification` , IF(logoField.fileid > 0, CONCAT('/os/', `logoField`.filePath, `logoField`.fileName), '/os/resources/images/spacer.gif') AS `logo-url` , IF(logoField.fileid > 0, CONCAT(''), ' ') AS `logo` FROM bos_member LEFT OUTER JOIN bos_memberFieldSelected AS `directoryClassificationSelected` ON (bos_member.userid = directoryClassificationSelected.userid AND directoryClassificationSelected.formFieldid = '34' ) LEFT OUTER JOIN bos_memberOptions AS `directoryClassificationSelectedText` ON (`directoryClassificationSelected`.formFieldid = `directoryClassificationSelectedText`.formFieldid AND directoryClassificationSelected.optionid = `directoryClassificationSelectedText`.optionValue) LEFT OUTER JOIN bos_resourceFiles AS `logoField` ON bos_member.`logo` = logoField.fileid LEFT JOIN `bos_memberFieldSubmissionGroupData` ON bos_member.userid = submissionid WHERE 1 AND isApproved > 0 AND (expDate >= CURDATE() OR expDate = '0000-00-00') AND bos_member.membershipLevelid IN(0,1,4,5,6,7,8,9,10,11,15,18,16,21,25,23,24,2,3,22) AND (`displayDirectory` = 1 ) AND bos_member.userid IN(85,249,303,307,360,417,451,460,532,541,572,574,786,792,798,813,917,918,919,1057,1219,1222,1238,1279,1340,1398,1427,1512,1523,1546,1550,1738,1745,1753,1767,2281,2348,2359,2378,2407,2423) GROUP BY bos_member.userid ORDER BY `company` Manufacturing - Henderson Chamber of Commerce

Manufacturing

Manufacturing
 
Allen Tel Products, Inc.
Nettles, Gary

Manufacturing
 
Crafthaus Brewery LLC
Forrest, Wyndee

Manufacturing
 
Creative Tent International Inc.
Fontius, Carol

Manufacturing
 
EMT-West
Endicott, Laura

Manufacturing
 
Ethel Chocolates w/Mars Retail Group
Gudgel, Jennifer

Manufacturing
 
Innovations Mfg & Distributing
Freeman, Dan

Manufacturing
 
Lake Industries, Inc.
Irigoyen, Louis

Manufacturing
 
Lift-Tech
Equihua, Esther

Promotional Products, Manufacturing, Printing
 
MakeIt LLC
Mike Emminger

Manufacturing
 
Mars Chocolate North America
Wrona, Joe