Keurmerk
0Item(s)

U hebt niets in uw winkelwagen.

Product was successfully added to your shopping cart.

Onze strapon top 20! De best verkochte voorbind dildo's

Op deze pagina vindt u een overzicht van voorbind dildo's welke het best verkopen binnen onze webshop

SELECT DISTINCT `e`.*, `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`, -stats.qty_ordered AS `cat_index_position` 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=14 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '218' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '15' AND price_index.customer_group_id = 0 LEFT JOIN (SELECT stats.product_id AS product_id, SUM(stats.qty_ordered - IFNULL(stats.qty_canceled, 0)) AS qty_ordered FROM sales_flat_order_item AS stats INNER JOIN sales_flat_order AS o ON (o.entity_id = stats.order_id AND (o.created_at BETWEEN '2018-09-18' AND '2019-09-19')) AND o.state NOT IN ('pending_payment', 'new', 'canceled') AND o.store_id = '14' GROUP BY stats.product_id) AS `stats` ON stats.product_id = e.entity_id WHERE ((1=1 ) OR (final_price is NULL)) AND (stats.qty_ordered > 0) AND ((1=1 ) OR (final_price is NULL)) ORDER BY `e`.`created_at` ASC LIMIT 21 OFFSET 21
Van hoog naar laag sorteren

Artikelen 22 tot 42 van 89 in totaal

Van hoog naar laag sorteren

Artikelen 22 tot 42 van 89 in totaal