1054 Unknown column 'm.manufacturers_name' in 'field list'
in:
[SELECT p.products_id, p.products_type, pd.products_name, pd.products_small_description, p.products_image, p.products_price,
p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model,
p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id,p.product_is_wholesale,p.product_wholesale_min,p.products_price_sample,
p.products_price_retail,p.products_quantity,p.products_quantity_order_min,p.products_status,p.products_recommend
FROM products p, products_description pd
WHERE p.products_status = 1
AND p.products_id = pd.products_id AND (p.products_id=9918 or p.products_id=9735 or p.products_id=6497 or p.products_id=8090 or p.products_id=8049 or p.products_id=2995 or p.products_id=3044 or p.products_id=3045 or p.products_id=2825 or p.products_id=2840 or p.products_id=7403 or p.products_id=7055 or p.products_id=7064 or p.products_id=3845 or p.products_id=3539 or p.products_id=3611 or p.products_id=3492 or p.products_id=3242 or p.products_id=3243 or p.products_id=3244 or p.products_id=3246 or p.products_id=3247 or p.products_id=3137 or p.products_id=3174 or p.products_id=7580 or p.products_id=7581 or p.products_id=6797 or p.products_id=6801 or p.products_id=7368 or p.products_id=7369 or p.products_id=7371 or p.products_id=6706 or p.products_id=6708 or p.products_id=6684 or p.products_id=6709 or p.products_id=6682 or p.products_id=6692 or p.products_id=6697 or p.products_id=6623 or p.products_id=6625 or p.products_id=6622 or p.products_id=6619 or p.products_id=6694 or p.products_id=6693 or p.products_id=6626 or p.products_id=6624 or p.products_id=6616 or p.products_id=7834)
AND pd.language_id = 1 limit 0, 24]