SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa LEFT JOIN prstshp_stock_available sa ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute WHERE pa.id_product = 987 AND sa.quantity > 0 SELECT DISTINCT( SUBSTRING_INDEX(reference, '.', 1) ) AS reference FROM prstshp_product_attribute pa LEFT JOIN prstshp_stock_available sa ON sa.id_product = pa.id_product AND sa.id_product_attribute = pa.id_product_attribute WHERE pa.id_product = 1011 AND sa.quantity > 0 Rigid cloth

Rigid cloth

BÚSQUEDA DE PRODUCTO

CATEGORÍAS

SUBCATEGORÍAS

There are 2 products.

Sort by:
Best sellers Relevance Name, A to Z Name, Z to A Price, low to high Price, high to low
Showing 1-2 of 2 item(s)

Active filters

  • Grit: 40
  • Material: Aparejo