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 s.id id, s.nom nom, f.nom_cm formato, s.tipomaterial tipid, s.subtipomaterial subid, tm.tipomaterial_en tipnom, 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.id IN (SELECT MIN(s.id) id FROM vives_db.series s LEFT JOIN vives_db.serie_has_tipologia AS st ON st.id_serie = s.id WHERE 1 = 1 AND s.vigente = 1 AND st.id_tipologia = 4 GROUP BY nom ORDER BY s.nom) ORDER BY id desc;
Array ( [0] => Array ( [id] => 828 [nom] => LUNA [formato] => 119,3X119,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => marbles ) [1] => Array ( [id] => 781 [nom] => MARBLELOUS [formato] => 79,3X179,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => marbles ) [2] => Array ( [id] => 733 [nom] => NIKOI [formato] => 120X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => marbles ) [3] => Array ( [id] => 706 [nom] => LESOLO [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => marbles ) [4] => Array ( [id] => 702 [nom] => DONEY [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => marbles ) [5] => Array ( [id] => 622 [nom] => WILSON [formato] => 10X20 [tipid] => 2 [subid] => 5 [tipnom] => wall tiles [subnom] => red body [tipol] => marbles ) [6] => Array ( [id] => 615 [nom] => DANDY [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => marbles ) [7] => Array ( [id] => 524 [nom] => TITÁN [formato] => 59,3X59,3 [tipid] => 3 [subid] => 4 [tipnom] => floor tiles [subnom] => porcelain clay [tipol] => marbles ) )
