dotaz: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'all,100) GROUP BY rok ORDER BY rok ASC' at line 1
Pro dotaz:
SELECT rok FROM oceneni WHERE cena IN(all,100) GROUP BY rok ORDER BY rok ASC

dotaz: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND OC.kategorie < 1000 ORDER BY OC.rok ASC' at line 3
Pro dotaz:
SELECT OC.*,CEN.value_cz as cena_text, KAT.value_cz as kat_text FROM oceneni as OC LEFT JOIN nikis_cis_oceneni_ceny as CEN on CEN.id=OC.cena LEFT JOIN nikis_cis_oceneni_kategorie as KAT on KAT.id=OC.kategorie WHERE OC.cena =all AND OC.kategorie < 1000 ORDER BY OC.rok ASC