From 27f3b334cec1e4ca523885bb1e0c2cb721ba31d3 Mon Sep 17 00:00:00 2001 From: APTX Date: Sat, 27 Apr 2013 18:28:20 +0200 Subject: [PATCH] Fix State column values for anime entries. --- localmylist/mylistnode.cpp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/localmylist/mylistnode.cpp b/localmylist/mylistnode.cpp index fe8c163..b629b46 100644 --- a/localmylist/mylistnode.cpp +++ b/localmylist/mylistnode.cpp @@ -600,8 +600,8 @@ QString MyListAnimeNode::baseQuery() " UNION " " SELECT f.my_state " " FROM file f " - " JOIN episode e ON (e.aid = a.aid) " - " JOIN file_episode_rel fer ON (fer.eid = e.eid) " + " JOIN file_episode_rel fer ON (fer.fid = f.eid) " + " JOIN episode e ON (e.eid = fer.eid AND e.aid = a.aid) " " ) AS sq) AS sq) AS my_state, " " %1 " " FROM anime a ") -- 2.52.0