SELECT p.*, pl.link_rewrite, pl.name, 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 p.active = 1 AND pl.name != "Montealegría" AND id_category_default = 116 AND image_shop.id_image IS NOT NULL ORDER by rand() LIMIT 3
Montealegría | BATAVIA

Montealegría

Proyecto de arquitectura: ÁBATON

Proyecto íntegro de interiorismo: BATAVIA.

PIDA INFORMACIÓN

+ 34 91 594 2233