From cd171a38bfade36bc8772ddf20502744b7193643 Mon Sep 17 00:00:00 2001 From: APTX Date: Sat, 15 Mar 2014 16:14:53 +0100 Subject: [PATCH] Fix query for myListSearch. --- localmylist/database.cpp | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/localmylist/database.cpp b/localmylist/database.cpp index b853619..83eb130 100644 --- a/localmylist/database.cpp +++ b/localmylist/database.cpp @@ -225,11 +225,13 @@ QList Database::myListSearch(const QString &query, int limit) QSqlQuery &q = prepare(R"( SELECT at.title_id, at.aid, at.type, at.language, at.title FROM anime_title at + WHERE at.title ILIKE :query AND (SELECT count(f.fid) FROM file f WHERE f.aid = at.aid) > 0 - ORDER BY at.title <-> :query ASC + ORDER BY at.title <-> :query2 ASC LIMIT :limit )"); q.bindValue(":query", query); + q.bindValue(":query2", query); q.bindValue(":limit", limit); if (!exec(q)) -- 2.52.0