Carrelage effet pierre
Grès cérame et revêtements muraux effet pierre
Obtenez le résultat rêvé au travers de notre sélection de pierres céramiques. Une large gamme de design et de formats inspirée de ce matériaux. Grâce aux techniques de fabrications les plus innovantes, VIVES recrez avec grand réalisme les dessins, textures et reliefs les plus naturelles pour vos surfaces.
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 = 3 GROUP BY nom ORDER BY s.nom);
Array ( [0] => Array ( [id] => 2 [nom] => ANCILES [formato] => 29,3X59,3 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [1] => Array ( [id] => 562 [nom] => NARPES [formato] => 44,3X89,3 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [2] => Array ( [id] => 582 [nom] => MURO [formato] => 19,4X59,3 [tipid] => 2 [subid] => 6 [tipnom] => faïence [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [3] => Array ( [id] => 632 [nom] => WORLD FLYSCH [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [4] => Array ( [id] => 638 [nom] => ALPHA [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [5] => Array ( [id] => 655 [nom] => CEPPO DI GRE [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [6] => Array ( [id] => 663 [nom] => BETA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [7] => Array ( [id] => 727 [nom] => LAMBDA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [8] => Array ( [id] => 726 [nom] => RHO [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => pierre naturelle ) [9] => Array ( [id] => 708 [nom] => DELTA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [10] => Array ( [id] => 710 [nom] => OMICRON [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => pierre naturelle ) [11] => Array ( [id] => 754 [nom] => SEINE [formato] => 80X180 [tipid] => 3 [subid] => 7 [tipnom] => carrelage [subnom] => grès cérame pâte coloré [tipol] => pierre naturelle ) [12] => Array ( [id] => 769 [nom] => YONNE [formato] => 45X120 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => pierre naturelle ) [13] => Array ( [id] => 770 [nom] => OISE [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => pierre naturelle ) [14] => Array ( [id] => 790 [nom] => DOHA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => pierre naturelle ) [15] => Array ( [id] => 791 [nom] => TOKIO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [16] => Array ( [id] => 804 [nom] => PANGEA [formato] => 120X120 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) [17] => Array ( [id] => 815 [nom] => STRAVAGANZA [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => faïence [subnom] => faïence pâte blanche [tipol] => pierre naturelle ) [18] => Array ( [id] => 824 [nom] => SALERNO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => carrelage [subnom] => grès cérame émaillé [tipol] => pierre naturelle ) )
