tapety, koberce, fototapety - E-color

Wish List 0

Filtr

Typ

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.grafika = 1 AND tbl_filtr.moderni = 1 Moderní (339) 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.grafika = 1 AND tbl_filtr.typ_prirodni = 1 Přírodní (85) 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.grafika = 1 AND tbl_filtr.klasicke = 1 Klasické (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.grafika = 1 AND tbl_filtr.skladem = 1 Skladem (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.grafika = 1 AND tbl_filtr.detske = 1 Dětské (43) 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.grafika = 1 AND tbl_filtr.pretiratelne = 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.grafika = 1 AND tbl_filtr.omyvatelne = 1 Omyvatelné (15)

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.grafika = 1 AND tbl_filtr.bila = 1 Bílá (95) 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.grafika = 1 AND tbl_filtr.bezova = 1 Béžová (122) 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.grafika = 1 AND tbl_filtr.cervena = 1 Červená (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.grafika = 1 AND tbl_filtr.modra = 1 Modrá (86) 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.grafika = 1 AND tbl_filtr.zluta = 1 Žlutá (32) 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.grafika = 1 AND tbl_filtr.cerna = 1 Černá (63) 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.grafika = 1 AND tbl_filtr.hneda = 1 Hnědá (108) 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.grafika = 1 AND tbl_filtr.zelena = 1 Zelená (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.grafika = 1 AND tbl_filtr.oranzova = 1 Oranžová (18) 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.grafika = 1 AND tbl_filtr.seda = 1 Šedá (147) 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.grafika = 1 AND tbl_filtr.fialova = 1 Fialová (12)

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.grafika = 1 AND tbl_filtr.barokni = 1 Barokní (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.grafika = 1 AND tbl_filtr.designova = 1 Designová (377) 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.grafika = 1 Grafická (523) 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.grafika = 1 AND tbl_filtr.klasicka = 1 Klasická (13) 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.grafika = 1 AND tbl_filtr.kvetinova = 1 Květinová (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.grafika = 1 AND tbl_filtr.prouzkova = 1 Proužková (42) 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.grafika = 1 AND tbl_filtr.retro = 1 Retro (37) 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.grafika = 1 AND tbl_filtr.prirodni = 1 Přírodní (112) 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.grafika = 1 AND tbl_filtr.domaci = 1 Domácí (184) 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.grafika = 1 AND tbl_filtr.strukturova = 1 Strukturová (47) 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.grafika = 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.grafika = 1 AND tbl_filtr.univerzalni = 1 Univerzální (3)

Material

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.grafika = 1 AND tbl_filtr.papirova = 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.grafika = 1 AND tbl_filtr.profilova = 1 Profilová (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.grafika = 1 AND tbl_filtr.vinylova = 1 Vinylová (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.grafika = 1 AND tbl_filtr.vliesova = 1 Vliesová (517)

Zrušit výběr

V databázi není pro tuto kategorii žádný záznam, zde jsou naše novinky.

27,87 EUR