select codigo from products where codigo > '676260000' and marca = 'SCHECTER' and catalogid = '5' and subcatalogid = '10' and codtitulo = '988' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo previo
DEMON-6
articulo siguiente
DEMON-6 FR
Productos Guitarras Electricas Schecter
Link del articulo (Click para copiar)
6 cuerdas PickUps Activos Schecter FLOYD ROSE
DEMON-6 FR 6 cuerdas PickUps Activos Schecter FLOYD ROSE