mysql/core_translate_lookup.sql
authorAlan Knowles <alan@roojs.com>
Wed, 9 Dec 2020 07:09:13 +0000 (15:09 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 9 Dec 2020 07:09:13 +0000 (15:09 +0800)
mysql/core_translate_lookup.sql

index d5efd4b..30e130a 100644 (file)
@@ -30,6 +30,8 @@ RETURNS TEXT NOT DETERMINISTIC READS SQL DATA
             on_col = in_col
             AND
             lang = in_lang
+            AND
+            active = 1
         LIMIT 1;
             
         IF v_id < 1 OR LENGTH(txt) < 1 THEN