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=3585 or p.products_id=3594 or p.products_id=3602 or p.products_id=3611 or p.products_id=3620 or p.products_id=3627 or p.products_id=3652 or p.products_id=3475 or p.products_id=3121 or p.products_id=2835 or p.products_id=3586 or p.products_id=3588 or p.products_id=3591 or p.products_id=3595 or p.products_id=3597 or p.products_id=3603 or p.products_id=3605 or p.products_id=3608 or p.products_id=3612 or p.products_id=3617 or p.products_id=3614 or p.products_id=3621 or p.products_id=3623 or p.products_id=3626 or p.products_id=3630 or p.products_id=3632 or p.products_id=3635 or p.products_id=3653 or p.products_id=3655 or p.products_id=3658 or p.products_id=3476 or p.products_id=3484 or p.products_id=3491 or p.products_id=3143 or p.products_id=3175 or p.products_id=2922 or p.products_id=2839 or p.products_id=2855 or p.products_id=2913) AND pd.language_id = 1 limit 0, 24]