Heizpatronen - Brasilia
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 = 102070000
)
AND
shop_item_has_category.company = 'gastrotiger' AND
shop_item_has_category.shop_code = 'B2C' AND
shop_item_has_category.category_shop_code = 'B2C'
LEFT JOIN shop_attribute_link ON (shop_attribute_link.no = shop_view_active_item.item_no AND shop_attribute_link.shop_code = shop_view_active_item.shop_code)
WHERE shop_item_has_category.category_language_code = 'DEU'
AND( shop_attribute_link.attribute_code='WSGERAETEFILTER' AND shop_attribute_link.value_option = '72165')
GROUP BY shop_attribute_link.id
HAVING COUNT(DISTINCT shop_attribute_link.id) = 1
testocache
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 = 102070000
)
AND
shop_item_has_category.company = 'gastrotiger' AND
shop_item_has_category.shop_code = 'B2C' AND
shop_item_has_category.category_shop_code = 'B2C'
LEFT JOIN shop_attribute_link ON (shop_attribute_link.no = shop_view_active_item.item_no AND shop_attribute_link.shop_code = shop_view_active_item.shop_code)
WHERE shop_item_has_category.category_language_code = 'DEU'
AND( shop_attribute_link.attribute_code='WSGERAETEFILTER' AND shop_attribute_link.value_option = '72165')
GROUP BY shop_attribute_link.id
HAVING COUNT(DISTINCT shop_attribute_link.id) = 1
Top-Hersteller der Kategorie