[299050] Translation Hints unusably slow
diff --git a/html/callback/getTranslationHints.php b/html/callback/getTranslationHints.php
index 672e47c..0a81b4c 100644
--- a/html/callback/getTranslationHints.php
+++ b/html/callback/getTranslationHints.php
@@ -24,13 +24,25 @@
}
-$query = "SELECT DISTINCT t.value
+/* $query = "SELECT DISTINCT t.value
FROM translations as t
INNER JOIN strings AS s ON s.string_id = t.string_id
WHERE s.value like '%" . addslashes($tr_string). "%'
AND t.is_active
AND t.language_id = '".addslashes($language)."'
ORDER BY LENGTH(t.value) ASC LIMIT 15";
+*/
+
+$query = "SELECT DISTINCT t.value
+FROM translations as t
+ INNER JOIN strings AS s ON s.string_id = t.string_id
+ INNER JOIN files AS f ON s.file_id = f.file_id
+ INNER JOIN release_train_projects AS tr ON tr.project_id = f.project_id AND tr.version = f.version
+WHERE s.value like '%" . addslashes($tr_string). "%'
+ AND t.is_active
+ AND tr.train_id = 'galileo'
+ AND t.language_id = '".addslashes($language)."'
+ORDER BY LENGTH(t.value) ASC LIMIT 15";
# print $query."\n";
$res = mysql_query($query,$dbh);
