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=20629 or p.products_id=20628 or p.products_id=20627 or p.products_id=20626 or p.products_id=20547 or p.products_id=19474 or p.products_id=19300 or p.products_id=19292 or p.products_id=19261 or p.products_id=18555 or p.products_id=17470 or p.products_id=17467 or p.products_id=17447 or p.products_id=17431 or p.products_id=16954 or p.products_id=16670 or p.products_id=16643 or p.products_id=16503 or p.products_id=16475 or p.products_id=16454 or p.products_id=16425 or p.products_id=16404 or p.products_id=16010 or p.products_id=15906 or p.products_id=15858 or p.products_id=15686 or p.products_id=15630 or p.products_id=12317 or p.products_id=12158 or p.products_id=12147 or p.products_id=6655 or p.products_id=6490 or p.products_id=6517 or p.products_id=6538 or p.products_id=5998 or p.products_id=5954 or p.products_id=5892 or p.products_id=5793 or p.products_id=5744 or p.products_id=5765 or p.products_id=20543 or p.products_id=19256 or p.products_id=18974 or p.products_id=18968 or p.products_id=18967 or p.products_id=18957 or p.products_id=18551 or p.products_id=16946 or p.products_id=16448 or p.products_id=16429 or p.products_id=16400 or p.products_id=16037 or p.products_id=15623 or p.products_id=6002 or p.products_id=5950 or p.products_id=5778 or p.products_id=5797 or p.products_id=5739 or p.products_id=5740 or p.products_id=5769 or p.products_id=20540 or p.products_id=19562 or p.products_id=19253 or p.products_id=19045 or p.products_id=19044 or p.products_id=19043 or p.products_id=19041 or p.products_id=18976 or p.products_id=18975 or p.products_id=18971 or p.products_id=18966 or p.products_id=18962 or p.products_id=18961 or p.products_id=18959 or p.products_id=18952 or p.products_id=18548 or p.products_id=18412 or p.products_id=18411 or p.products_id=18410 or p.products_id=18409 or p.products_id=18408 or p.products_id=18407 or p.products_id=18406 or p.products_id=18405 or p.products_id=18404 or p.products_id=18403 or p.products_id=18402 or p.products_id=18401 or p.products_id=18400 or p.products_id=18399 or p.products_id=18398 or p.products_id=18397 or p.products_id=16941 or p.products_id=16445 or p.products_id=16432 or p.products_id=16397 or p.products_id=16040 or p.products_id=15617 or p.products_id=12355 or p.products_id=12333 or p.products_id=12178 or p.products_id=12165 or p.products_id=6006 or p.products_id=5947 or p.products_id=5800 or p.products_id=5736 or p.products_id=5772 or p.products_id=19556 or p.products_id=19555 or p.products_id=19225 or p.products_id=19224 or p.products_id=19223 or p.products_id=19222 or p.products_id=19221 or p.products_id=19220 or p.products_id=19219 or p.products_id=19218 or p.products_id=19217 or p.products_id=19216 or p.products_id=19215 or p.products_id=19214 or p.products_id=18541 or p.products_id=18540 or p.products_id=16685 or p.products_id=16684 or p.products_id=16439 or p.products_id=16438 or p.products_id=16391 or p.products_id=16046 or p.products_id=12362 or p.products_id=12361 or p.products_id=12172 or p.products_id=12171 or p.products_id=5938 or p.products_id=5941 or p.products_id=5806 or p.products_id=5807 or p.products_id=18597 or p.products_id=18580 or p.products_id=18578 or p.products_id=16080 or p.products_id=16031 or p.products_id=16030 or p.products_id=16663 or p.products_id=16496 or p.products_id=16481 or p.products_id=15702 or p.products_id=12105 or p.products_id=12104 or p.products_id=12101 or p.products_id=12100 or p.products_id=12098 or p.products_id=12097 or p.products_id=12096 or p.products_id=12093 or p.products_id=12092 or p.products_id=6648 or p.products_id=6497 or p.products_id=6510 or p.products_id=6454 or p.products_id=6467 or p.products_id=6402 or p.products_id=6212 or p.products_id=6039 or p.products_id=16658 or p.products_id=16655 or p.products_id=16491 or p.products_id=15937 or p.products_id=15932 or p.products_id=6502 or p.products_id=16650 or p.products_id=6172 or p.products_id=6026 or p.products_id=16487 or p.products_id=15717 or p.products_id=15712 or p.products_id=6505 or p.products_id=16003 or p.products_id=15920 or p.products_id=15722 or p.products_id=6304 or p.products_id=6222 or p.products_id=12328 or p.products_id=12311 or p.products_id=12304 or p.products_id=12162 or p.products_id=6639 or p.products_id=6643 or p.products_id=6459)
AND pd.language_id = 1 order by p.products_date_added DESC limit 0, 24]