SELECT sp.`stranka` AS id,COUNT(p.`id`) AS pocet FROM `stranky_produkty` AS sp LEFT JOIN `produkty` AS p ON p.id=sp.`produkt` LEFT JOIN kurzy_men AS k ON p.mena=k.mena AND (k.platne_do IS NULL OR k.platne_do > NOW()) WHERE sp.`stranka` IN (173) AND (p.`visible`=1 AND p.`jazyk`='cz') GROUP BY sp.`stranka`