Menu E-shop

SELECT katalog.*, COALESCE(katalog_trans.nazev,katalog.nazev) AS nazev, COALESCE(katalog_trans.kratky_popis,katalog.kratky_popis) AS kratky_popis, COALESCE(katalog_trans.popis,katalog.popis) AS popis, COALESCE(katalog_trans.odkaz_viditelny,katalog.odkaz_viditelny) AS odkaz_viditelny FROM katalog INNER JOIN menu_katalog_relace ON menu_katalog_relace.id_produktu = katalog.id LEFT JOIN katalog_trans ON katalog.id = katalog_trans.id_par AND katalog_trans.lang_code='cs_CZ' WHERE katalog.aktiv='1' AND () GROUP BY katalog.id ORDER BY kat_c desc LIMIT 0,10

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 ') GROUP BY katalog.id ORDER BY kat_c desc LIMIT 0,10' at line 5