1054 - Unknown column 'manufacturers_name' in 'order clause'

[ERROR:] db.php (0)
[ERROR:] class-page-results.php (0)
[ERROR:] mod-product-listing.php (0)
[ERROR:] store-search-result.php (0)

SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*, '1' as searchres, pd.products_name, pd.products_short_description AS products_short_description, pd.products_head_title_tag as products_title, slp.slp_value, slp.slp_value2, s.specials_new_products_price, f.status FROM products p LEFT JOIN products_description pd ON (pd.products_id = p.products_id AND pd.language_id = '2') LEFT JOIN products_options_details pod ON (p.products_id = pod.products_id) LEFT JOIN featured f ON p.products_id = f.products_id LEFT JOIN specials s ON (p.products_id = s.products_id AND s.status = '1' AND s.customers_group_id = '0') LEFT JOIN slp slp ON (p.products_unit_id = slp.slp_id AND slp.slp_type = 'pu' AND slp.language_id = '2') WHERE ((pd.products_name LIKE '%16HO2210%' OR p.products_model LIKE '%16HO2210%' OR pod.model LIKE '%16HO2210%') AND (pd.products_name LIKE '%CIWL%' OR p.products_model LIKE '%CIWL%' OR pod.model LIKE '%CIWL%') AND (pd.products_name LIKE '%Set%' OR p.products_model LIKE '%Set%' OR pod.model LIKE '%Set%') AND (pd.products_name LIKE '%C-M-EX%' OR p.products_model LIKE '%C-M-EX%' OR pod.model LIKE '%C-M-EX%')) AND p.products_status = '1' and (p.products_family = '' or (p.products_master = p.products_id or p.products_master = '0')) order by manufacturers_name, pd.products_name LIMIT 0, 20;

[TEP STOP]