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 ('3', '10', '75', '76', '77', '78', '79', '80', '81', '82', '83', '2481', '2482', '2494', '2495', '2499', '2500', '2502', '2503', '2510', '11', '84', '85', '86', '87', '88', '89', '90', '91', '92', '13', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '4219', '15', '105', '106', '107', '108', '109', '110', '111', '9685', '18', '115', '116', '117', '118', '119', '120', '121', '19', '122', '21', '124', '22', '125', '23', '126', '127', '128', '129', '130', '131', '132', '2507', '24', '133', '25', '134', '135', '136', '137', '26', '138', '139', '140', '141', '142', '143', '27', '144', '145', '146', '147', '29', '149', '150', '151', '152', '153', '30', '154', '155', '156', '157', '158', '159', '2479', '32', '161', '162', '163', '164', '165', '33', '166', '167', '168', '169', '170', '171', '172', '173', '174', '175', '2501', '34', '176', '177', '2429', '2430', '2480', '35', '178', '179', '180', '181', '182', '183', '36', '184', '185', '186', '187', '188', '37', '189', '190', '191', '192', '193', '194', '38', '195', '3807', '39', '196', '197', '9686', '9687', '9688', '40', '198', '199', '200', '201', '2496', '2497', '41', '202', '203', '204', '205', '2350', '42', '206', '207', '43', '208', '209', '210', '211', '212', '213', '214', '44', '2252', '2253', '2254', '2255', '2256', '48', '2324', '2325', '2431', '2432', '2433', '2434', '2435', '2436', '2437', '2504', '2508', '2509', '4220', '2438', '2439', '2440', '2441', '2442', '2498', '2483', '2484', '2485', '2486', '2487', '2488', '2489', '2490', '2491', '2492', '2493', '9684', '3326', '3327', '3328', '3329', '3330', '3331', '3332', '3333', '3334', '9611', '9612', '9651', '9652', '9613', '9614', '9646', '9653', '9650', '3335', '377', '378', '2321', '2257', '2258', '2259', '2260', '2261', '2262', '2263', '2264', '2265', '2266', '2267', '2268', '2368', '2369', '2370', '2505', '2522', '1133', '1135', '2367', '3336', '3337', '3338', '3339', '3340', '3341', '3342', '3343', '3344', '3780', '3781', '3782', '3783', '3784', '3785', '3786', '3787', '3788', '3789', '3790', '3791', '3792', '3793', '3794', '3795', '3796', '3797', '3798', '3799', '3800', '3801', '3802', '3803', '3804', '3805', '3806', '3808', '3810', '3811', '3812', '3813', '3815', '3816', '3824', '3825', '4182', '4215', '9656', '9657', '9658', '3351', '3352', '3353', '3354', '3355', '3356', '3357', '3358', '3814', '9654', '9655', '3411', '3412', '3413', '3414', '3415', '3809', '9648', '6647') ORDER BY m.`name`
auf Lager
