SELECT CODIGO_ARTICULO FROM pim_geinfor g LEFT JOIN pim_productsCSV p ON g.CODIGO_ARTICULO = p.codart WHERE CODIGO_ARTICULO IN (08817,14495,14496) AND imagen!='' AND (g.AMFER_GRANO = '280') SELECT CODIGO_ARTICULO FROM pim_geinfor g LEFT JOIN pim_productsCSV p ON g.CODIGO_ARTICULO = p.codart WHERE CODIGO_ARTICULO IN (01096,10825,10826,10827,10828,10829,10830,10831,10832,23725,23727,01095,01377) AND imagen!='' AND (g.AMFER_GRANO = '280') SELECT CODIGO_ARTICULO FROM pim_geinfor g LEFT JOIN pim_productsCSV p ON g.CODIGO_ARTICULO = p.codart WHERE CODIGO_ARTICULO IN (22620,22621) AND imagen!='' AND (g.AMFER_GRANO = '280') Wide belt of rigid cloth

Rigid cloth

There are 3 products.

Showing 1-3 of 3 item(s)

Active filters

  • Grit: 280
  • Width: 680