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 ('3223', '3224', '3225', '3226', '3227', '3228', '3229', '9756', '9757', '3230', '3231', '3232', '3233', '3234', '3235', '3236', '3237', '3238', '3239', '9753', '9754', '9755', '3240', '3241', '3242', '3243', '3244', '3245', '3246', '3247', '3248', '3249', '3250', '3251', '3252', '3253', '4217', '3254', '3255', '3256', '3257', '3258', '3259', '3260', '3261', '3262', '3263', '3264', '3265', '3266', '3267', '3268', '3269', '3270', '3271', '3272', '3222') 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 ('3223', '3224', '3225', '3226', '3227', '3228', '3229', '9756', '9757', '3230', '3231', '3232', '3233', '3234', '3235', '3236', '3237', '3238', '3239', '9753', '9754', '9755', '3240', '3241', '3242', '3243', '3244', '3245', '3246', '3247', '3248', '3249', '3250', '3251', '3252', '3253', '4217', '3254', '3255', '3256', '3257', '3258', '3259', '3260', '3261', '3262', '3263', '3264', '3265', '3266', '3267', '3268', '3269', '3270', '3271', '3272', '3222') ORDER BY m.`name`