Fliesen in Steinoptik
Stein Effekt Feinsteinzeug und Wandfliesen
Erzielen Sie mithilfe unserer Auswahl an Keramikfliesen in Steinoptik das Ergebnis, von dem Sie immer geträumt haben. Eine breite Palette an Designs und Formaten, die von diesem schönen Material inspiriert sind, steht Ihnen dabei zur Verfügung. Dank der innovativsten Techniken bildet VIVES mit großer Realitätsnähe die natürlichsten grafischen Designs, Texturen und Reliefs nach, um die Wände und Böden Ihrer Räume mit natürlicher Inspiration zu erfüllen.
SELECT s.id id, s.nom nom, f.nom_cm formato, s.tipomaterial tipid, s.subtipomaterial subid, tm.tipomaterial_de tipnom, sm.subtipo_de subnom, LOWER(t.nom_de) 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] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [1] => Array ( [id] => 562 [nom] => NARPES [formato] => 44,3X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [2] => Array ( [id] => 582 [nom] => MURO [formato] => 19,4X59,3 [tipid] => 2 [subid] => 6 [tipnom] => wandfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [3] => Array ( [id] => 632 [nom] => WORLD FLYSCH [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [4] => Array ( [id] => 638 [nom] => ALPHA [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [5] => Array ( [id] => 655 [nom] => CEPPO DI GRE [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [6] => Array ( [id] => 663 [nom] => BETA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [7] => Array ( [id] => 727 [nom] => LAMBDA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [8] => Array ( [id] => 726 [nom] => RHO [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => steinoptik ) [9] => Array ( [id] => 708 [nom] => DELTA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [10] => Array ( [id] => 710 [nom] => OMICRON [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => steinoptik ) [11] => Array ( [id] => 754 [nom] => SEINE [formato] => 80X180 [tipid] => 3 [subid] => 7 [tipnom] => bodenfliesen [subnom] => Farbpaste Feinsteinzeug [tipol] => steinoptik ) [12] => Array ( [id] => 769 [nom] => YONNE [formato] => 45X120 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => steinoptik ) [13] => Array ( [id] => 770 [nom] => OISE [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => steinoptik ) [14] => Array ( [id] => 790 [nom] => DOHA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => steinoptik ) [15] => Array ( [id] => 791 [nom] => TOKIO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [16] => Array ( [id] => 804 [nom] => PANGEA [formato] => 120X120 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) [17] => Array ( [id] => 815 [nom] => STRAVAGANZA [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => steinoptik ) [18] => Array ( [id] => 824 [nom] => SALERNO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => steinoptik ) )
