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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.bila = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.bezova = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.cervena = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.modra = 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.univerzalni = 1
AND tbl_filtr.zluta = 1
Žlutá (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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.cerna = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.hneda = 1
Hnědá (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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.zelena = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.oranzova = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.seda = 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.zluta = 1 AND tbl_filtr.univerzalni = 1
AND tbl_filtr.fialova = 1