SELECT p.*, pl.link_rewrite,, pl.description_short, (image_shop.id_image) id_image FROM ps_product p LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1 LEFT JOIN ps_image_shop image_shop ON (image_shop.id_product = p.id_product AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN ps_image_lang il ON (image_shop.id_image = il.id_image AND il.id_lang = 1) WHERE = 1 AND != "Casa L" AND id_category_default = 116 AND image_shop.id_image IS NOT NULL ORDER by rand() LIMIT 3
Casa L

Casa L

Disponible venta online: Si

Proyecto de arquitectura: ÁBATON

Proyecto de interiorismo: BATAVIA

Fotograías: Carlos Muntadas Prim


+ 34 91 594 2233