0Item(s)

U hebt niets in uw winkelwagen.


Online bestellen kan bij ons nog steeds - Je bestelling wordt gewoon aan huis bezorgd (NL + BE)!

Product was successfully added to your shopping cart.

Onze best verkochte masturbators - top 20!

Op deze pagina vindt u een overzicht van onze masturbator toppers! Het zijn de meest verkochte masturbators binnen onze shop.

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=8 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '86' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '8' 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 '2019-06-05' AND '2020-06-06')) AND o.state NOT IN ('pending_payment', 'new', 'canceled') AND o.store_id = '8' 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 42
Van hoog naar laag sorteren

Artikelen 43 tot 63 van 114 in totaal

Van hoog naar laag sorteren

Artikelen 43 tot 63 van 114 in totaal