Reposicion de Stock

Card Frame Jumbo
Card Frame Jumbo
Últimas unidades en stock
34,99 €

Precio Select Magician 29,74€

Aparición de Mocho
Aparición de Mocho
Últimas unidades en stock
44,99 €

Precio Select Magician 38,24€

Fallin Head
Falling Head
Últimas unidades en stock
39,99 €

Precio Select Magician 33,99€

Baraja Houdini
Baraja Houdini
Últimas unidades en stock
14,99 €

Precio Select Magician 12,74€

Show 21 Items of 21 item(s)
SELECT product_id, COUNT(product_id) AS sales FROM `ps_order_detail` WHERE product_id IN (SELECT id_product FROM `ps_category_product` LEFT JOIN ps_product USING (id_product) WHERE id_category = 41 AND active = 1) GROUP BY product_id ORDER BY sales DESC LIMIT 10