select codigo from products where codigo > '620415000' and marca = 'PAISTE' and catalogid = '20' and subcatalogid = '340' and codtitulo = '529' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo previo
2002 HHH-14B
articulo siguiente
2002 BBBH-16
Productos Platillos Paiste
Link del articulo (Click para copiar)
Black Big Beat Hi-Hat 15"
2002 BBBH-15 Black Big Beat Hi-Hat 15"