Haushalt - KOKA Shop

string(1371) "SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '15' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `groesse_idx` ON groesse_idx.entity_id = e.entity_id AND groesse_idx.attribute_id = '388' AND groesse_idx.store_id = 1 AND groesse_idx.value IN('122030', '122209', '122014', '121793', '122011', '122225', '121728', '121995', '122016', '122187', '121778', '121718', '121575', '122189', '121729', '121613', '121787', '121694', '121791', '120529', '121682', '122176', '121996', '121993', '121620', '121784', '121725', '121789', '122221', '121790', '121715', '121780', '121797', '122029', '121697', '121621', '122222', '121969', '121723', '121779', '121684', '121730', '121685')"

string(1619) "SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '15' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `groesse_idx` ON groesse_idx.entity_id = e.entity_id AND groesse_idx.attribute_id = '388' AND groesse_idx.store_id = 1 AND groesse_idx.value IN('122030', '122209', '122014', '121793', '122011', '122225', '121728', '121995', '122016', '122187', '121778', '121718', '121575', '122189', '121729', '121613', '121787', '121694', '121791', '120529', '121682', '122176', '121996', '121993', '121620', '121784', '121725', '121789', '122221', '121790', '121715', '121780', '121797', '122029', '121697', '121621', '122222', '121969', '121723', '121779', '121684', '121730', '121685') INNER JOIN `catalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = 1 AND manufacturer_idx.value IN('120403', '3611', '121564')"