Expresivní kolekce tapet na stěnu GENTLE od Erismann

Filtr

Typ

Barva

SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.bila = 1 Bílá (29) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.bezova = 1 Béžová (8) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.cervena = 1 Červená (16) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.vliesova = 1 AND tbl_filtr.modra = 1 Modrá (171) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.zluta = 1 Žlutá (15) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.cerna = 1 Černá (9) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.hneda = 1 Hnědá (17) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.zelena = 1 Zelená (39) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.oranzova = 1 Oranžová (5) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.seda = 1 Šedá (29) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.fialova = 1 Fialová (6)

Vzor

SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.barokni = 1 Barokní (1) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.designova = 1 Designová (57) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.grafika = 1 Grafická (84) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.klasicka = 1 Klasická (5) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.kvetinova = 1 Květinová (50) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.prouzkova = 1 Proužková (9) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.retro = 1 Retro (12) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.prirodni = 1 Přírodní (94) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.domaci = 1 Domácí (65) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.strukturova = 1 Strukturová (15) SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.etno = 1 SELECT COUNT(DISTINCT zbozi.id) AS pocet FROM zbozi INNER JOIN tbl_filtr ON zbozi.id = tbl_filtr.id_zbozi WHERE zbozi.kategorie = ? AND tbl_filtr.modra = 1 AND tbl_filtr.vliesova = 1 AND tbl_filtr.univerzalni = 1 Univerzální (1)

Material

tapety, koberce, fototapety - E-color

Tapeta na zeď GENTLE od Erismann, trees tyrkysová

Tapeta na zeď GENTLE od Erismann, trees hnědá