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 ('3274', '3275', '3276', '3277', '3278', '3279', '3280', '3281', '3282', '3283', '3284', '3285', '3286', '3287', '3288', '3289', '3290', '3291', '3292', '3293', '3294', '3295', '3296', '3297', '3298', '3299', '3300', '7856', '7877', '7878', '7889', '7890', '7891', '8387', '7879', '7880', '7881', '7892', '8385', '8386', '7882', '7883', '7884', '7885', '7886', '7887', '7888', '7893', '7894', '8388', '8389', '8390', '8391', '8392', '8393', '8394', '8395', '8396', '8397', '8398', '8399', '8400', '8401', '8402', '8403', '8404', '8405', '7857', '7895', '7896', '7897', '7898', '7899', '8307', '8308', '8309', '8310', '7858', '7859', '7900', '7901', '7902', '7903', '7904', '7905', '7906', '7907', '7908', '7860', '7909', '7910', '7911', '7912', '7913', '7914', '7915', '7916', '7917', '7861', '7918', '7929', '7949', '7950', '7919', '7920', '7921', '7922', '7923', '7924', '7931', '7932', '7933', '7938', '7939', '7940', '7941', '7942', '7943', '7925', '7926', '7927', '7928', '7934', '7935', '7936', '7937', '7944', '7945', '7946', '7947', '7948', '7862', '7951', '7952', '7953', '7954', '7955', '7957', '7958', '7959', '7960', '7863', '7961', '7962', '7963', '7964', '7965', '7966', '7967', '7864', '7968', '7969', '7970', '7971', '7972', '7973', '7974', '7975', '7865', '7866', '7976', '7977', '7978', '7979', '7980', '7981', '7982', '7983', '7984', '7867', '7985', '7986', '7988', '7989', '7990', '7991', '7992', '7993', '7868', '7994', '8002', '8003', '8004', '8005', '8006', '8008', '8009', '8010', '7995', '8011', '8012', '8013', '8014', '8015', '8016', '8017', '8018', '8019', '7996', '8020', '8021', '8022', '8023', '8024', '8025', '8026', '8027', '7997', '8028', '8029', '8030', '8031', '8032', '8034', '8035', '8036', '8037', '7998', '8038', '8039', '8040', '8041', '8042', '7999', '8043', '8044', '8045', '8046', '8047', '8048', '8000', '8049', '8050', '8051', '8052', '8053', '8054', '8055', '8001', '8056', '8057', '8058', '8059', '8060', '8061', '8062', '8063', '8362', '8363', '8364', '8365', '8366', '8367', '8368', '8369', '8370', '8371', '7869', '8064', '8065', '8066', '8067', '8068', '8069', '8070', '8071', '8072', '7870', '8073', '8074', '8075', '8076', '8077', '8078', '8081', '8082', '8083', '8084', '8085', '8086', '8087', '8088', '8089', '8079', '8080', '8090', '8091', '8092', '7871', '8093', '8094', '8095', '8096', '8097', '8098', '8099', '8100', '8101', '8102', '8372', '8373', '8374', '7872', '8103', '8104', '8105', '8106', '8107', '8108', '8109', '8110', '8111', '7873', '8112', '8113', '8121', '8114', '8122', '8123', '8124', '8125', '8126', '8127', '8128', '8129', '8130', '8115', '8131', '8132', '8133', '8135', '8134', '8239', '8241', '8240', '8242', '8243', '8244', '8116', '8136', '8137', '8138', '8139', '8140', '8141', '8142', '8117', '8143', '8144', '8147', '8145', '8148', '8146', '8149', '8150', '8151', '8152', '8153', '8154', '8155', '8118', '8156', '8158', '8157', '8231', '8236', '8232', '8237', '8233', '8238', '8234', '8235', '8119', '8159', '8160', '8162', '8161', '8163', '8164', '8165', '8167', '8166', '8120', '8168', '8169', '8170', '8171', '8172', '8173', '8174', '8175', '8176', '8245', '8249', '8253', '8246', '8247', '8248', '8250', '8251', '8252', '7874', '8177', '8178', '8179', '8180', '8181', '8182', '8183', '8184', '8185', '8186', '8187', '8188', '8189', '8190', '8191', '8192', '8193', '8194', '8195', '8196', '8197', '8198', '8199', '8200', '8201', '8202', '8203', '8204', '8205', '8206', '8207', '8208', '7875', '8209', '8210', '8211', '8212', '8213', '8214', '8215', '8216', '8217', '7876', '8218', '8219', '8220', '8221', '8222', '8223', '8224', '8225', '8254', '8255', '8256', '8257', '8258', '8259', '8260', '8261', '8262', '8263', '8264', '8265', '8266', '8267', '8268', '8269', '8270', '8271', '8272', '8273', '8274', '8275', '8276', '8277', '8278', '8279', '8280', '8281', '8282', '8283', '8284', '8285', '8286', '8287', '8288', '8289', '8290', '8291', '8292', '8293', '8295', '8296', '8297', '8298', '8299', '8300', '8301', '8302', '8303', '8304', '8305', '8306', '8311', '8312', '8313', '8314', '8315', '8316', '8317', '8318', '8319', '8320', '8321', '8322', '8323', '8324', '8325', '8326', '8327', '8328', '8329', '8330', '8331', '8332', '8333', '8334', '8335', '8336', '8337', '8338', '8339', '8340', '8341', '8342', '8343', '8344', '8345', '8346', '8347', '8348', '8349', '8350', '8351', '8352', '8353', '8354', '8355', '8356', '8357', '8358', '8359', '8360', '8361', '8375', '8376', '8377', '8378', '8379', '8380', '8381', '8382', '8383', '8384', '3301', '3302', '3303', '3304', '3305', '3306', '3307', '3308', '3748', '3273') ORDER BY m.`name`
auf Anfrage
Beschaffungsartikel
Lieferung in 2-3 Werktagen
