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 ('3578', '3579', '3580', '3581', '3582', '3583', '3584', '3585', '9632', '9633', '9634', '9635', '9636', '3586', '3587', '3588', '3589', '3590', '3591', '3592', '3593', '3594', '3595', '3596', '9620', '9624', '3597', '3598', '3599', '3600', '3601', '3602', '3603', '3604', '3605', '3606', '3607', '3608', '3609', '9621', '9637', '3610', '3611', '3612', '3613', '3614', '3615', '3616', '3617', '3618', '3619', '3620', '3621', '3622', '3623', '3624', '3625', '3626', '3627', '3628', '3629', '3630', '3631', '3632', '3633', '3634', '3635', '3636', '3637', '3638', '3639', '3640', '3641', '3642', '3643', '3644', '3645', '3646', '3647', '3648', '3649', '3650', '3651', '3652', '3653', '3654', '3655', '3656', '3657', '3658', '3659', '3660', '3661', '3662', '3663', '3664', '3665', '3666', '3667', '3668', '3669', '3670', '3671', '3672', '3673', '3674', '3675', '3676', '3677', '3678', '3679', '3680', '3681', '3682', '3683', '3684', '3685', '3686', '3687', '3688', '3689', '3690', '3691', '3692', '3693', '3694', '3695', '3696', '3697', '3698', '3699', '3700', '3701', '3702', '3703', '3704', '3705', '9630', '3706', '3707', '3708', '3709', '3710', '3711', '3712', '3713', '3714', '3715', '3716', '3717', '3718', '3719', '7749', '9622', '9623', '9625', '9626', '9640', '9627', '9628', '9629', '9631', '9638', '9639', '3577') ORDER BY m.`name`
auf Lager
auf Anfrage
