CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY SELECT cp.id_product, MIN(cp.position) position FROM ps_category c STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND c.nleft >= 26 AND c.nright <= 27 AND c.active = 1) STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY position, id_product AR10 Magazines

AR10 Magazines

AR10 Magazines

There is 1 product.

Showing 1-1 of 1 item(s)

Active filters