testoitemq
SELECT DISTINCT shop_view_active_item.item_no FROM shop_view_active_item
JOIN shop_item_has_category ON shop_item_has_category.item_no = shop_view_active_item.item_no
AND (
shop_item_has_category.category_line_no = 104000000
OR shop_item_has_category.category_line_no IN (104010000,
104020000,
104030000,
104040000,
104050000,
104060000,
104070000,
104080000,
104090000,
104100000,
104110000)
)
AND
shop_item_has_category.company = 'gastrotiger' AND
shop_item_has_category.shop_code = 'B2C' AND
shop_item_has_category.category_shop_code = 'B2C'
WHERE shop_item_has_category.category_language_code = 'DEU'
testoitemq
SELECT DISTINCT shop_view_active_item.item_no FROM shop_view_active_item
JOIN shop_item_has_category ON shop_item_has_category.item_no = shop_view_active_item.item_no
AND (
shop_item_has_category.category_line_no = 104000000
OR shop_item_has_category.category_line_no IN (104010000,
104020000,
104030000,
104040000,
104050000,
104060000,
104070000,
104080000,
104090000,
104100000,
104110000)
)
AND
shop_item_has_category.company = 'gastrotiger' AND
shop_item_has_category.shop_code = 'B2C' AND
shop_item_has_category.category_shop_code = 'B2C'
WHERE shop_item_has_category.category_language_code = 'DEU'
testo222 Array
(
[WSGERAETEFILTER] => 79271
)
testo222Y
Alles für die professionelle Küche - schnell und direkt! Bei gastrotiger finden Sie Ersatzteile und Zubehörartikel passend für über 500 Hersteller.
