Barajas

Baraja Moai
Nuevo
Baraja Moai
En stock
14,99 €

Precio Select Magician 12,74€

Baraja Bee roja
Baraja Bee roja
En stock
5,99 €

Precio Select Magician 5,09€

Show 30 Items of 38 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 = 5 AND active = 1) GROUP BY product_id ORDER BY sales DESC LIMIT 10