select codigo from products where codigo > '608000700' and marca = 'PAISTE' and catalogid = '20' and subcatalogid = '340' and codtitulo = '534' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo previo
Signature Precision SP-10
articulo siguiente
Signature Precision HR-20
Productos Platillos Paiste
Link del articulo (Click para copiar)
China 18"
Signature Precision CH-18 China 18"