string(1263) "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 = '96'
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 `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('120212', '120106', '76784', '119869', '120663', '2875', '2373', '2007', '1928', '120220', '2824', '120184', '2584', '3616', '2603', '2270', '120513', '120119', '2365', '120540', '120223', '119819', '2320', '8924', '122256', '76787', '120181', '121159', '1933', '121748', '3622', '7670', '119544')"
string(1481) "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 = '96'
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 `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('120212', '120106', '76784', '119869', '120663', '2875', '2373', '2007', '1928', '120220', '2824', '120184', '2584', '3616', '2603', '2270', '120513', '120119', '2365', '120540', '120223', '119819', '2320', '8924', '122256', '76787', '120181', '121159', '1933', '121748', '3622', '7670', '119544')
INNER JOIN `catalog_product_index_eav` AS `farbe_idx` ON farbe_idx.entity_id = e.entity_id AND farbe_idx.attribute_id = '381' AND farbe_idx.store_id = 1 AND farbe_idx.value IN('3610', '3752', '8942', '3781')"
Handy- & Mobilfunk-Zubehör - KOKA Shop
Vielen Dank für Ihre Anmeldung!
Ihren persönlichen Gutscheincode erhalten
Sie in Kürze per eMail.
Sortieren:
Kostenloser Versand
(nur für Deutschland)
Ohne Ausnahme – Wir schicken Ihnen alle Produkte versandkostenfrei zu.
Sicher einkaufen,
schnelle Lieferung
Alle angebotenen Markenartikel haben wir auf Lager, deshalb sind sie sofort lieferbar.
1 Monat Widerrufsrecht
& kostenloser Rückversand
Artikel können binnen 1 Monat kostenlos an uns zurück geschickt werden.
Sonderpreis-Aktion%
WhatsApp
Hotline
eMail
Fax
Seite
1
/ 2 
