in:
[select distinct m.manufacturers_id as id, m.manufacturers_name as name
from products p, products_to_categories p2c, manufacturers m
where p.products_status = 1
and p.manufacturers_id = m.manufacturers_id
and p.products_id = p2c.products_id
and p2c.categories_id = '30'
order by m.manufacturers_name]
