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=10542 or p.products_id=11938 or p.products_id=11914 or p.products_id=11922 or p.products_id=11924 or p.products_id=11893 or p.products_id=11894 or p.products_id=11895 or p.products_id=11896 or p.products_id=10278 or p.products_id=10281 or p.products_id=10341 or p.products_id=10282 or p.products_id=10315 or p.products_id=10489 or p.products_id=10316 or p.products_id=10320 or p.products_id=11901 or p.products_id=11905 or p.products_id=11909 or p.products_id=10387 or p.products_id=17357 or p.products_id=17343 or p.products_id=17319 or p.products_id=16563 or p.products_id=16504 or p.products_id=16456 or p.products_id=17295 or p.products_id=17271 or p.products_id=16954 or p.products_id=16587 or p.products_id=16480 or p.products_id=17247 or p.products_id=17223 or p.products_id=16869 or p.products_id=17026 or p.products_id=16978 or p.products_id=17002 or p.products_id=16845 or p.products_id=16821 or p.products_id=16797 or p.products_id=16658 or p.products_id=16634 or p.products_id=16528 or p.products_id=18746 or p.products_id=18722)
AND pd.language_id = 1 limit 0, 24]