From 65e1803cdc01bc5f78e650933682174e7f8cd38a Mon Sep 17 00:00:00 2001 From: APTX Date: Sun, 28 Apr 2013 14:45:24 +0200 Subject: [PATCH] Account for file/ep relations for the total episodes watched in an anime. --- localmylist/mylistnode.cpp | 17 ++++++++++++----- 1 file changed, 12 insertions(+), 5 deletions(-) diff --git a/localmylist/mylistnode.cpp b/localmylist/mylistnode.cpp index b629b46..cd57eb4 100644 --- a/localmylist/mylistnode.cpp +++ b/localmylist/mylistnode.cpp @@ -585,11 +585,18 @@ QString MyListAnimeNode::baseQuery() " (SELECT COUNT(e.eid) " " FROM episode e " " WHERE e.aid = a.aid), " - " (SELECT COUNT(DISTINCT f.eid) " - " FROM episode e " - " JOIN file f ON (f.eid = e.eid) " - " WHERE e.aid = a.aid " - " AND f.my_watched IS NOT NULL), " + " (SELECT COUNT(DISTINCT eid) " + " FROM " + " (SELECT e.eid FROM episode e " + " JOIN file f ON (f.eid = e.eid) " + " WHERE e.aid = a.aid " + " AND f.my_watched IS NOT NULL " + " UNION " + " SELECT e.eid FROM episode e " + " JOIN file_episode_rel fer ON fer.eid = e.eid " + " JOIN file f ON f.fid = fer.fid " + " WHERE e.aid = a.aid " + " AND f.my_watched IS NOT NULL) sq), " " (SELECT CASE WHEN array_length(my_state_array, 1) > 1 THEN -1 ELSE my_state_array[1] END " " FROM " " (SELECT array_agg(my_state) my_state_array " -- 2.52.0