SELECT DISTINCT m.*  FROM  `products` AS p, `products_description` AS pd, `products_price` AS pp, `products_images` AS pi, `tax_classes` AS tc, `manufacturers` AS m, `products_to_categories` as ptc  WHERE p.`manufactures_id` = m.`id` AND p.`is_locked` != '1' AND ((p.`is_stockable`='1' && p.`stock_info`>=p.`min_order_qty`) OR p.`is_stockable`='0') AND p.`is_shop`='1' AND p.`id`=pd.`products_id` AND p.`id`=pi.`products_id` AND pd.`shop_id`=1 AND pd.`language_id`=1 AND m.`name` != '' AND p.`id` = pp.`products_id` AND pp.`customers_group_id` = 1 AND pp.`tax_class_id` = tc.`id` AND p.`id` = ptc.`products_id` AND ptc.`shop_id` = 1 AND ptc.`categories_id` in ('3496', '3497', '3498', '3499', '3500', '3501', '9746', '3502', '3503', '3504', '3505', '3506', '3507', '3508', '3509', '3510', '3511', '3512', '3513', '3514', '3515', '3516', '3517', '3518', '3519', '3520', '3521', '3522', '3523', '3524', '3525', '3526', '3527', '3528', '3529', '3530', '3531', '3532', '3533', '9747', '3534', '3535', '3536', '3537', '3538', '3539', '3540', '3541', '3542', '9748', '3543', '3544', '3545', '3546', '9751', '9752', '3547', '3548', '3549', '3550', '3551', '3552', '3553', '3554', '3555', '3556', '3557', '9749', '9750', '3558', '3559', '3560', '3561', '3562', '3563', '3564', '3565', '3566', '3567', '3568', '3569', '3570', '3571', '3572', '3573', '3574', '3575', '3576', '7412', '3495') ORDER BY m.`name` 

 SELECT DISTINCT m.*  FROM  `products` AS p, `products_description` AS pd, `products_price` AS pp, `products_images` AS pi, `tax_classes` AS tc, `manufacturers` AS m, `products_to_categories` as ptc  WHERE p.`manufactures_id` = m.`id` AND p.`is_locked` != '1' AND ((p.`is_stockable`='1' && p.`stock_info`>=p.`min_order_qty`) OR p.`is_stockable`='0') AND p.`is_shop`='1' AND p.`id`=pd.`products_id` AND p.`id`=pi.`products_id` AND pd.`shop_id`=1 AND pd.`language_id`=1 AND m.`name` != '' AND p.`id` = pp.`products_id` AND pp.`customers_group_id` = 1 AND pp.`tax_class_id` = tc.`id` AND p.`id` = ptc.`products_id` AND ptc.`shop_id` = 1 AND ptc.`categories_id` in ('3496', '3497', '3498', '3499', '3500', '3501', '9746', '3502', '3503', '3504', '3505', '3506', '3507', '3508', '3509', '3510', '3511', '3512', '3513', '3514', '3515', '3516', '3517', '3518', '3519', '3520', '3521', '3522', '3523', '3524', '3525', '3526', '3527', '3528', '3529', '3530', '3531', '3532', '3533', '9747', '3534', '3535', '3536', '3537', '3538', '3539', '3540', '3541', '3542', '9748', '3543', '3544', '3545', '3546', '9751', '9752', '3547', '3548', '3549', '3550', '3551', '3552', '3553', '3554', '3555', '3556', '3557', '9749', '9750', '3558', '3559', '3560', '3561', '3562', '3563', '3564', '3565', '3566', '3567', '3568', '3569', '3570', '3571', '3572', '3573', '3574', '3575', '3576', '7412', '3495') ORDER BY m.`name`