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.kvetinova = 1
AND tbl_filtr.bila = 1
Bílá (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.kvetinova = 1
AND tbl_filtr.bezova = 1
Béžová (60)
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.kvetinova = 1
AND tbl_filtr.cervena = 1
Červená (44)
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.kvetinova = 1
AND tbl_filtr.modra = 1
Modrá (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.kvetinova = 1
AND tbl_filtr.zluta = 1
Žlutá (34)
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.kvetinova = 1
AND tbl_filtr.cerna = 1
Černá (20)
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.kvetinova = 1
AND tbl_filtr.hneda = 1
Hnědá (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.kvetinova = 1
AND tbl_filtr.zelena = 1
Zelená (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.kvetinova = 1
AND tbl_filtr.oranzova = 1
Oranž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.kvetinova = 1
AND tbl_filtr.seda = 1
Šedá (66)
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.kvetinova = 1
AND tbl_filtr.fialova = 1
Fialová (8)
