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=1904 or p.products_id=2538 or p.products_id=2551 or p.products_id=1924 or p.products_id=2065 or p.products_id=2070 or p.products_id=2334 or p.products_id=2335 or p.products_id=2100 or p.products_id=1728 or p.products_id=1734 or p.products_id=1756 or p.products_id=1805 or p.products_id=1834 or p.products_id=2651 or p.products_id=2653 or p.products_id=2654 or p.products_id=1969 or p.products_id=2689 or p.products_id=1976 or p.products_id=2699 or p.products_id=2154 or p.products_id=2160 or p.products_id=36948 or p.products_id=2087 or p.products_id=1962 or p.products_id=2122 or p.products_id=2206 or p.products_id=2207 or p.products_id=2539 or p.products_id=10311 or p.products_id=10324 or p.products_id=11938 or p.products_id=15682 or p.products_id=15615 or p.products_id=15552 or p.products_id=15454 or p.products_id=15424 or p.products_id=15440 or p.products_id=14407 or p.products_id=14284 or p.products_id=14343 or p.products_id=14226 or p.products_id=14109 or p.products_id=13676 or p.products_id=13654 or p.products_id=13635 or p.products_id=13452)
AND pd.language_id = 1 limit 0, 24]