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.bila = 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.bila = 1
AND tbl_filtr.designova = 1
Designová (55)
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.bila = 1
AND tbl_filtr.grafika = 1
Grafická (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.bila = 1
AND tbl_filtr.klasicka = 1
Klasická (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.bila = 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.bila = 1
AND tbl_filtr.prouzkova = 1
Proužková (21)
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.bila = 1
AND tbl_filtr.retro = 1
Retro (3)
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.bila = 1
AND tbl_filtr.prirodni = 1
Přírodní (62)
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.bila = 1
AND tbl_filtr.domaci = 1
Domácí (69)
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.bila = 1
AND tbl_filtr.strukturova = 1
Strukturová (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.bila = 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.bila = 1
AND tbl_filtr.univerzalni = 1
Univerzální (1)
