Find Store by Manufacturer or Product Type

user warning: Unknown column 'node_data_field_manufacturers_field_manufacturers_value' in 'order clause' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, location.name AS location_name, location.street AS location_street, location.additional AS location_additional, location.city AS location_city, location.province AS location_province, location.country AS location_country, location.postal_code AS location_postal_code, location.longitude AS location_longitude, location.latitude AS location_latitude FROM node node LEFT JOIN location_instance location_instance_node ON node.vid = location_instance_node.vid LEFT JOIN location location ON location_instance_node.lid = location.lid LEFT JOIN content_field_product_types node_data_field_product_types ON node.vid = node_data_field_product_types.vid LEFT JOIN content_field_manufacturers node_data_field_manufacturers ON node.vid = node_data_field_manufacturers.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type IN ('retaillocation')) ) ORDER BY node_data_field_manufacturers_field_manufacturers_value ASC LIMIT 0, 20 in /www/sites/www.midatlantichomefurnishings.com/files/html/includes/database.mysql.inc on line 174.