1054 - Unknown column 'm.manufacturers_id' in 'where clause'
select distinct c.categories_id as id, cd.categories_name as name from products p left join products_to_categories p2c on (p.products_id = p2c.products_id) left join categories c on (p2c.categories_id = c.categories_id) left join categories_description cd on (p2c.categories_id = cd.categories_id) where p.products_status = '1' and cd.language_id = '4' and p.manufacturers_id = '8597' and m.manufacturers_id is not null group by name order by cd.categories_name
[TEP STOP]