SELECT id,imagen,nombre_en as nombre,orden, titulo_en as titulo,texto_en as texto,descripcion_grupo_en as descripcion_grupo ,descripcion2_en as descripcion2,texto_accesorios_en as texto_accesorios,texto_descarga_en as texto_descarga, id_categoria,color,precio_en as precio FROM productos WHERE id_categoria=50 and estado=1 ORDER by orden

NEO SHADOW GREY



INNOVATIVE TECHNOLOGY, PURE DESIGN
Sporty buggy with sophisticated chassis for perfect road holding and high manoeuvrability; extremely small dimensions when folded and easy to transport.