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

[ERROR:] func-db.php (0)
[ERROR:] mod-product-listing.php (0)
[ERROR:] store-search-result.php (412)

select distinct p.products_id, p.products_ean, p.products_model, p.discount, pd.products_name, pd.products_short_description, pd.products_head_title_tag as products_title, p.manufacturers_id, p.products_quantity, p.shipping_profile, p.non_cart, p.non_price, p.products_weight, slp.slp_value, slp.slp_value2, s.specials_new_products_price, pi.images_file as products_image, p.products_sort_order, f.status, p.products_top_new, p.products_free_shipping, p.products_points, ((match (pd.products_name) against ('dartboardblade63032') * 2) + (match (pd.products_head_keywords_tag) against ('dartboardblade63032') * 1) + (match (p2e.products_extra_fields_value) against ('dartboardblade63032') * 1.5)) as score from products p left join products_images pi on (p.products_id = pi.products_id and pi.sort = 0 and pi.options_id = 0) left join products_to_categories p2c on (p2c.products_id = p.products_id) left join products_description pd on (pd.products_id = p.products_id and pd.language_id = '2') left join featured f on p.products_id = f.products_id left join specials s on p.products_id = s.products_id left join slp slp on (p.products_unit_id = slp.slp_id and slp.slp_type = 'pu' and slp.language_id = '2') left join extra_tmp p2e on p2e.products_id = p.products_id where ((pd.products_name like '%dartboardblade63032%' or pd.products_head_keywords_tag like '%dartboardblade63032%' or p2e.products_extra_fields_value like '%dartboardblade63032%')) and p2c.categories_id not in (1257) and p.products_status = '1' order by m.manufacturers_name, pd.products_name limit 0, 20

[TEP STOP]