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.hneda = 1
AND tbl_filtr.barokni = 1
Barokní (4)
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.hneda = 1
AND tbl_filtr.designova = 1
Designová (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.hneda = 1
AND tbl_filtr.grafika = 1
Grafická (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.hneda = 1
AND tbl_filtr.klasicka = 1
Klasická (4)
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.hneda = 1
AND tbl_filtr.kvetinova = 1
Květinová (35)
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.hneda = 1
AND tbl_filtr.prouzkova = 1
Proužková (6)
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.hneda = 1
AND tbl_filtr.retro = 1
Retro (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.hneda = 1
AND tbl_filtr.prirodni = 1
Přírodní (88)
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.hneda = 1
AND tbl_filtr.domaci = 1
Domácí (74)
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.hneda = 1
AND tbl_filtr.strukturova = 1
Strukturová (23)
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.hneda = 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.hneda = 1
AND tbl_filtr.univerzalni = 1
Univerzální (4)
