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' WHERE shop_item_has_category.category_language_code = 'DEU'

Heizpatronen - Brasilia

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