Carrelage effet betón
Grès cérame et revêtements muraux effet ciment
Une apparence neutre, urbaine, au style contemporain. Le béton céramique est un des effets esthétiques les plus utilisés en design intérieur pour son aspect intemporelle et son caractére fonctionnelle. C'est un effet de matière idéal pour les revêtements de sol et de murs aux designs illimités parmis lesquelles choisir.
SELECT s.id id, s.nom nom, f.nom_cm formato, s.tipomaterial tipid, s.subtipomaterial subid, tm.tipomaterial_fr tipnom, sm.subtipo_fr subnom, LOWER(t.nom_fr) 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] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [1] => Array ( [id] => 815 [nom] => STRAVAGANZA [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => ciment ) [2] => Array ( [id] => 791 [nom] => TOKIO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [3] => Array ( [id] => 790 [nom] => DOHA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => ciment ) [4] => Array ( [id] => 786 [nom] => CHICAGO [formato] => 80X80 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [5] => Array ( [id] => 785 [nom] => MONTREAL [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => ciment ) [6] => Array ( [id] => 729 [nom] => KAMALA [formato] => 45X120 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => ciment ) [7] => Array ( [id] => 712 [nom] => NASSAU [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [8] => Array ( [id] => 661 [nom] => DANXIA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => ciment ) [9] => Array ( [id] => 642 [nom] => RIFT [formato] => 80X80 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [10] => Array ( [id] => 627 [nom] => WORLD STREETS [formato] => 20X20 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [11] => Array ( [id] => 621 [nom] => MORTHIER [formato] => 10X20 [tipid] => 2 [subid] => 5 [tipnom] => faïence [subnom] => faïence pâte rouge [tipol] => ciment ) [12] => Array ( [id] => 591 [nom] => RIBADEO [formato] => 30X30 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) [13] => Array ( [id] => 539 [nom] => RUHR [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => ciment ) )
