diff options
| author | Arno <am@disconnect.de> | 2013-07-07 08:52:53 +0200 |
|---|---|---|
| committer | Arno <am@disconnect.de> | 2013-07-07 08:52:53 +0200 |
| commit | 1013140a8b66968de1cfa0d07a353b47b8234899 (patch) | |
| tree | 04dc986ff30f6d61f3f3203359da090ec3844c08 | |
| parent | 6484a0197f193bf10a9f764acd25c52896edb1e7 (diff) | |
| download | SheMov-1013140a8b66968de1cfa0d07a353b47b8234899.tar.gz SheMov-1013140a8b66968de1cfa0d07a353b47b8234899.tar.bz2 SheMov-1013140a8b66968de1cfa0d07a353b47b8234899.zip | |
Prevent duplicates in ArchiveTree
Well, select DISTINCT :)
| -rw-r--r-- | archivemodel.cpp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/archivemodel.cpp b/archivemodel.cpp index d6a30ef..ecd4e3d 100644 --- a/archivemodel.cpp +++ b/archivemodel.cpp @@ -722,14 +722,14 @@ void ArchiveCollector::fetchSeries(const QVariant &id, SmTreeItem *parent){ void ArchiveCollector::fetchParts(const QVariant &id, SmTreeItem *parent){ QSqlQuery partsQuery(mDb); if(mSortOrder == ArchiveModel::SeriesName){ - partsQuery.prepare("SELECT iseriesparts_id, iseriespart, bfavorite, tsubtitle FROM seriesparts WHERE iseries_id = :id ORDER BY iseriespart"); + partsQuery.prepare("SELECT DISTINCT(iseriesparts_id), iseriespart, bfavorite, tsubtitle FROM seriesparts WHERE iseries_id = :id ORDER BY iseriespart"); partsQuery.bindValue(":id", parent->data(ArchiveModel::GenericId)); }else if(mSortOrder == ArchiveModel::Genre){ - partsQuery.prepare("SELECT seriesparts.iseriesparts_id, iseriespart, bfavorite, tsubtitle FROM seriesparts, seriesparts_genremap WHERE iseries_id = :id AND seriesparts.iseriesparts_id = seriesparts_genremap.iseriesparts_id AND seriesparts_genremap.igenres_id = :genreid ORDER BY iseriespart"); + partsQuery.prepare("SELECT DISTINCT(seriesparts.iseriesparts_id), iseriespart, bfavorite, tsubtitle FROM seriesparts, seriesparts_genremap WHERE iseries_id = :id AND seriesparts.iseriesparts_id = seriesparts_genremap.iseriesparts_id AND seriesparts_genremap.igenres_id = :genreid ORDER BY iseriespart"); partsQuery.bindValue(":id", parent->data(ArchiveModel::GenericId)); partsQuery.bindValue(":genreid", id); }else if(mSortOrder == ArchiveModel::Actor){ - partsQuery.prepare("SELECT seriesparts.iseriesparts_id, iseriespart, bfavorite, tsubtitle FROM seriesparts, seriesparts_actormap WHERE iseries_id = :id AND seriesparts.iseriesparts_id = seriesparts_actormap.iseriesparts_id AND seriesparts_actormap.iactors_id = :actorid ORDER BY iseriespart"); + partsQuery.prepare("SELECT DISTINCT(seriesparts.iseriesparts_id), iseriespart, bfavorite, tsubtitle FROM seriesparts, seriesparts_actormap WHERE iseries_id = :id AND seriesparts.iseriesparts_id = seriesparts_actormap.iseriesparts_id AND seriesparts_actormap.iactors_id = :actorid ORDER BY iseriespart"); partsQuery.bindValue(":id", parent->data(ArchiveModel::GenericId)); partsQuery.bindValue(":actorid", id); } |