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=9288 or p.products_id=9313 or p.products_id=9230 or p.products_id=9279 or p.products_id=9276 or p.products_id=8913 or p.products_id=9229 or p.products_id=9257 or p.products_id=9066 or p.products_id=9219 or p.products_id=9306 or p.products_id=9191 or p.products_id=9107 or p.products_id=9157 or p.products_id=9037 or p.products_id=9016 or p.products_id=9027 or p.products_id=9024 or p.products_id=9026 or p.products_id=9021 or p.products_id=9025 or p.products_id=9176 or p.products_id=9180 or p.products_id=9277 or p.products_id=9177 or p.products_id=9069 or p.products_id=8964 or p.products_id=8960 or p.products_id=8991 or p.products_id=9001 or p.products_id=9050 or p.products_id=9091 or p.products_id=9169 or p.products_id=8958 or p.products_id=9179 or p.products_id=8989 or p.products_id=9218 or p.products_id=8962 or p.products_id=9241 or p.products_id=9080 or p.products_id=9233 or p.products_id=9126 or p.products_id=9082 or p.products_id=9100 or p.products_id=9079 or p.products_id=9013 or p.products_id=9003 or p.products_id=8997)
AND pd.language_id = 1 limit 0, 24]