Nuestros productos

select count(articulos.codigo) from articulos where articulos.idrubro =24 and Visible<>1 and (articulos.idSubrubro=14) and (articulos.habilitado=1) and articulos.Agotado != 1 order by codigo DESC, descripcion desc

select * from articulos where articulos.idrubro = 24 and Visible<>1 and articulos.idSubrubro=14 and articulos.habilitado=1 and articulos.Agotado != 1 order by codigo DESC, descripcion desc LIMIT 50,50
Ampliar!

CODIGO: EM0371

AGUILA EN VUELO 60CM
Ampliar!

CODIGO: EM0370/3

COBRA 0.50
Ampliar!

CODIGO: EM0368/2

DRAGON COMODO 0.30
Ampliar!

CODIGO: EM0367/1

IGUANA POLISH 0.20
Ampliar!

CODIGO: EM0363/5

DRAGON C/ ALAS 0.30
Ampliar!

CODIGO: EM0362/5

DRAGON SIN ALAS 1.00
Ampliar!

CODIGO: EM0362/3

DRAGON SIN ALAS 0.50
Ampliar!

CODIGO: EM0264/1

BUDHA HAPPY "M" 0.18
Ampliar!

CODIGO: EM0256/4

BUDHA SEAT POLISH 0.20
Ampliar!

CODIGO: EM0256/3

BUDHA SEAT POLISH 0.30
Ampliar!

CODIGO: EM0256/1

BUDHA SEAT POLISH 0.50