Nuestros productos

select count(articulos.codigo) from articulos where articulos.idrubro =34 and Visible<>1 and (articulos.habilitado=1) and articulos.Agotado != 1 order by codigo asc, descripcion asc

select * from articulos where articulos.idrubro = 34 and Visible<>1 and articulos.habilitado=1 and articulos.Agotado != 1 order by codigo asc, descripcion asc LIMIT 0,50
Ampliar!

CODIGO: AKA0106

CESTO RATTAN 0.30X0.50