From f803de985a63f31321f3f4fcbed656b692d7d756 Mon Sep 17 00:00:00 2001 From: Vsevolod Stakhov Date: Mon, 8 Apr 2019 16:55:33 +0100 Subject: [PATCH] [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, -- 2.39.5