marble look tiles
Marble-effect porcelain stoneware and wall tiles
The charm and beauty of marble plus the added value and technical benefits born from ceramic tiles. VIVES has a wide range of marble effect tiles in different sizes, finishes and looks such as Calacata, Marquina marble or warm cream tones, which are ideal for all types of design projects.
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 = 4 GROUP BY nom ORDER BY id desc, s.nom ;