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 ('3117', '3118', '3119', '3120', '3121', '3122', '3123', '3124', '3125', '9719', '9720', '3126', '3127', '3128', '3129', '3130', '3131', '3132', '9726', '9727', '9728', '9729', '3134', '3135', '3136', '3137', '3138', '3139', '3140', '3141', '3142', '3143', '3144', '3145', '3146', '3147', '3148', '9718', '9730', '3149', '3150', '3151', '3152', '3153', '3154', '3155', '3156', '3157', '9724', '9725', '3158', '3159', '9721', '9722', '9723', '5') 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 ('3117', '3118', '3119', '3120', '3121', '3122', '3123', '3124', '3125', '9719', '9720', '3126', '3127', '3128', '3129', '3130', '3131', '3132', '9726', '9727', '9728', '9729', '3134', '3135', '3136', '3137', '3138', '3139', '3140', '3141', '3142', '3143', '3144', '3145', '3146', '3147', '3148', '9718', '9730', '3149', '3150', '3151', '3152', '3153', '3154', '3155', '3156', '3157', '9724', '9725', '3158', '3159', '9721', '9722', '9723', '5') ORDER BY m.`name`