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 ('3895', '3911', '3912', '3913', '3914', '3915', '3916', '3917', '3918', '3919', '3920', '3921', '4160', '4161', '4197', '4198', '3896', '3922', '3923', '4183', '4206', '6058', '6059', '6060', '9569', '9570', '9571', '3897', '3924', '3925', '3926', '3927', '3928', '3929', '3930', '3898', '3931', '3932', '3933', '3934', '3935', '3936', '3937', '3938', '3939', '3940', '3941', '3942', '3943', '3944', '3945', '3946', '3947', '3948', '3950', '3951', '3952', '3953', '3954', '3955', '3956', '4143', '4144', '4145', '4146', '4159', '4184', '4185', '4186', '4187', '4188', '4189', '4190', '4191', '4192', '4193', '4194', '4195', '4196', '4200', '4208', '6047', '6048', '6049', '6050', '6051', '6052', '6053', '6054', '7721', '9698', '3899', '3957', '3958', '3959', '3960', '3961', '3962', '3963', '3964', '4199', '3900', '3965', '3966', '3967', '3968', '3969', '3970', '3971', '3972', '3973', '3974', '3901', '3975', '3902', '3976', '3977', '3978', '3979', '3980', '3981', '3982', '3983', '3903', '3984', '3985', '3986', '3987', '3988', '3989', '3990', '3991', '4154', '4155', '4156', '4157', '4207', '6065', '3904', '3992', '3993', '3994', '3905', '3995', '4158', '3906', '3996', '3997', '3998', '3999', '4000', '3907', '4001', '4002', '4003', '4004', '4005', '4006', '4007', '4008', '4009', '4010', '4011', '4012', '4013', '4014', '4015', '4214', '6066', '7722', '3908', '4016', '4017', '3909', '4018', '4019', '4020', '4021', '4022', '4023', '4024', '3910', '4025', '4026', '4027', '4028', '4029', '4030', '4201', '4202', '4203', '4204', '4205', '4221', '4222', '9676', '9677', '9678', '9679', '9680', '4223', '4224', '4225', '6055', '6056', '7718', '7719', '7720', '6063', '6064', '7713', '7714', '7715', '7716', '7717', '9572', '9593', '9594', '9595', '9596', '9597', '9598', '9592', '3838') ORDER BY m.`name`
Lieferung in 2-3 Werktagen
