1054 - Unknown column 'm.manufacturers_name' in 'where clause'

select distinct p.products_id , p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_quantity, p.products_availability, p.products_available_at_supplier, p.products_date_added, srp.status, GROUP_CONCAT(p2c.categories_id) AS categories, IF(srp.status, srp.specials_new_products_price, NULL) as specials_new_products_price, IF(srp.status, srp.specials_new_products_price, p.products_price) as final_price, productg.customers_group_price AS customers_group_price, srp.specials_new_products_price AS specials_new_products_price_1, s.specials_new_products_price AS specials_new_products_price_2 from products as p join products_description as pd on (pd.products_id = p.products_id and pd.country_available = 1 and pd.language_id = 4) join products_to_categories as p2c on (p.products_id = p2c.products_id) LEFT JOIN specials_retail_prices AS srp ON (p.products_id = srp.products_id AND srp.status = 1) LEFT JOIN specials AS s ON (p.products_id = s.products_id AND s.status = 1 AND s.customers_group_id = 0) LEFT JOIN products_groups AS productg ON (p.products_id = productg.products_id AND productg.customers_group_id = 0) where p.products_status = '1' and p2c.categories_id != 48 and ((pd.products_name like '%dtek50%' or p.products_model like '%dtek50%' or m.manufacturers_name like '%dtek50%' or p.products_id='dtek50') ) GROUP BY p.products_id