Fliesen in Holzoptik
Wandfliesen und Feinsteinzeug Holzimitat
Finden Sie in unserem umfangreichen Katalog Keramik in Holzoptik, die am besten zu Ihnen passt: Fußböden aus Steinzeug- und Feinsteinzeugfliesen, die aussehen wie Parkett, Holz im nordischen Stil, Vintage oder gebeiztes oder verbranntes Holz und sogar Holz, das von Grobspanplatten inspiriert ist. Genießen Sie die Wärme und Natürlichkeit des Holzes mit den Vorteilen der keramischen Bodenfliesen.
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 = 5 GROUP BY nom ORDER BY s.nom);
Array ( [0] => Array ( [id] => 65 [nom] => POLINESIA [formato] => 14,3X119,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [1] => Array ( [id] => 71 [nom] => ORSA [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [2] => Array ( [id] => 74 [nom] => ARHUS [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [3] => Array ( [id] => 518 [nom] => ORSA BASIC [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [4] => Array ( [id] => 554 [nom] => PARAMO [formato] => 14,3X119,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [5] => Array ( [id] => 579 [nom] => FARO [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [6] => Array ( [id] => 605 [nom] => EVIA [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => wandfliesen [subnom] => weisscherbige wandfliesen [tipol] => holzoptik ) [7] => Array ( [id] => 606 [nom] => EFESO [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [8] => Array ( [id] => 610 [nom] => NORA [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [9] => Array ( [id] => 629 [nom] => WORLD WOODS [formato] => 19,2X119,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [10] => Array ( [id] => 658 [nom] => STRAND [formato] => 59,3X59,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [11] => Array ( [id] => 665 [nom] => GAMMA [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [12] => Array ( [id] => 685 [nom] => MONTGOMERY [formato] => 19,2X119,3 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [13] => Array ( [id] => 730 [nom] => BELICE [formato] => 26X180 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [14] => Array ( [id] => 796 [nom] => BOWDEN [formato] => 26X180 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [15] => Array ( [id] => 798 [nom] => KOKKOLA [formato] => 19,4X120 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [16] => Array ( [id] => 799 [nom] => NIVALA [formato] => 19,4X120 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) [17] => Array ( [id] => 800 [nom] => OTTAWA [formato] => 19,4X120 [tipid] => 3 [subid] => 3 [tipnom] => bodenfliesen [subnom] => feinsteinzeug [tipol] => holzoptik ) )
