Concrete look ceramic tiles
Cement-effect porcelain stoneware and wall tiles
A neutral, urban appearance yet full of contemporary nuances. Ceramic cement is one of the star aesthetics in interior design for its timeless and functional character. An ideal material for floors and walls with a wide catalogue of different designs to choose from.
SELECT MIN(s.id) id, s.nom nom, MIN(f.nom_cm) formato, MIN(s.tipomaterial) tipid, MIN(s.subtipomaterial) subid, MIN(tm.tipomaterial_en) tipnom, MIN(sm.subtipo_en) subnom, lower(t.nom_en) tipol FROM vives_db.series s left join vives_db.serie_has_tipologia as st on st.id_serie = s.id LEFT JOIN vives_db.tipologia as t on st.id_tipologia = t.idtipologia LEFT JOIN vives_db.formatos f ON f.id = s.formato LEFT JOIN vives_db.subtipomaterial sm ON sm.idsubtipomaterial = s.subtipomaterial left join vives_db.tipomaterial tm on s.tipomaterial = tm.idtipomaterial WHERE 1 = 1 AND s.vigente = 1 AND t.idtipologia = 8 GROUP BY nom ORDER BY id desc, s.nom ;