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 'LIMIT 1' at line 5

SELECT name, link_rewrite FROM `tj_category_lang`
            WHERE id_category = 3
              AND id_lang = 1
              AND id_shop = 1
            LIMIT 1 LIMIT 1