select distinct(ma.manufacturers_id),ma.manufacturers_name FROM manufacturers ma,products_to_categories pc,products p ,categories c WHERE p.manufacturers_id=ma.manufacturers_id AND c.categories_id = pc.categories_id AND pc.products_id = p.products_id AND p.products_status = '1' AND (pc.categories_id = '56' OR c.parent_id = ' 56') ORDER BY p.sort_order 56