select codigo from products where codigo > '504119000' and marca = 'LINE 6' and catalogid = '45' and subcatalogid = '220' and codtitulo = '855' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo previo
HX Effects
articulo siguiente
HX Stomp XL
Productos Pedaleras Line 6
Link del articulo (Click para copiar)
Stock HOY: 8 Stock HOY: 8
Pedalera Multiefectos COMPACTA HX 3 SWITCHES USB
HX Stomp Pedalera Multiefectos COMPACTA HX 3 SWITCHES USB