SELECT file from gallery where cartella='P345' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Sedia Acquaseria
The Acquaseria collection contains chairs and stools with decorated backs ( with or without armrests), pieces made with the PP (polypropylene) structure that makes them durable over time given the strength and quality of the material. Both stools and chairs Acquaseria are available in different shades such as the color Avocado, White, Gray or Beige that together with the minimalist structure make them aesthetically modern without depriving them of the functionality of housing.
Related products
SELECT
t1.*,
t2.url_rw AS urlSC,
t2.url_rw_i AS urlSC_i,
t3.url_rw AS urlC,
t3.url_rw_i AS urlC_i
FROM prodotti AS t1
LEFT JOIN articoli AS t2 ON t2.id_art = t1.id_prec
LEFT JOIN articoli AS t3 ON t3.id_art = t2.id_prec
WHERE t1.tipo = '108'
AND t1.id_art <> '345'
and t1.flag4=1
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;