commit f803de9: [Minor] Joins cleanup

[Vsevolod Stakhov]

Author: Vsevolod Stakhov
Date: 2019-04-08 16:55:33 +0100
URL: https://github.com/rspamd/rspamd/commit/f803de985a63f31321f3f4fcbed656b692d7d756

[Minor] Joins cleanup
Issue: #2251
Submitted by: @beiDei8z

---
 src/libstat/backends/sqlite3_backend.c | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

diff --git a/src/libstat/backends/sqlite3_backend.c b/src/libstat/backends/sqlite3_backend.c
index 8a3dcdc0c..5b5a6b896 100644
--- a/src/libstat/backends/sqlite3_backend.c
+++ b/src/libstat/backends/sqlite3_backend.c
@@ -151,10 +151,8 @@ static struct rspamd_sqlite3_prstmt prepared_stmts[RSPAMD_STAT_BACKEND_MAX] =
 	[RSPAMD_STAT_BACKEND_GET_TOKEN] = {
 		.idx = RSPAMD_STAT_BACKEND_GET_TOKEN,
 		.sql = "SELECT value FROM tokens "
-				"LEFT JOIN languages ON tokens.language=languages.id "
-				"LEFT JOIN users ON tokens.user=users.id "
-				"WHERE token=?1 AND (users.id=?2) "
-				"AND (languages.id=?3 OR languages.id=0);",
+				"WHERE token=?1 AND users=?2 "
+				"AND (language=?3 OR language=0);",
 		.stmt = NULL,
 		.args = "III",
 		.result = SQLITE_ROW,