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 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 = 8 GROUP BY nom ORDER BY s.nom) ORDER BY id desc;
Array ( [0] => Array ( [id] => 824 [nom] => SALERNO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [1] => Array ( [id] => 815 [nom] => STRAVAGANZA [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => concrete ) [2] => Array ( [id] => 791 [nom] => TOKIO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [3] => Array ( [id] => 790 [nom] => DOHA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => concrete ) [4] => Array ( [id] => 786 [nom] => CHICAGO [formato] => 80X80 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [5] => Array ( [id] => 785 [nom] => MONTREAL [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => concrete ) [6] => Array ( [id] => 729 [nom] => KAMALA [formato] => 45X120 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => concrete ) [7] => Array ( [id] => 712 [nom] => NASSAU [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [8] => Array ( [id] => 661 [nom] => DANXIA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => concrete ) [9] => Array ( [id] => 642 [nom] => RIFT [formato] => 80X80 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [10] => Array ( [id] => 627 [nom] => WORLD STREETS [formato] => 20X20 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [11] => Array ( [id] => 621 [nom] => MORTHIER [formato] => 10X20 [tipid] => 2 [subid] => 5 [tipnom] => wall tiles [subnom] => red body [tipol] => concrete ) [12] => Array ( [id] => 591 [nom] => RIBADEO [formato] => 30X30 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) [13] => Array ( [id] => 539 [nom] => RUHR [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => concrete ) )
