diff options
| -rw-r--r-- | gentoobrowse/console/packagemasks.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/console/packagemasks.xml b/gentoobrowse/console/packagemasks.xml index 261ee9b..fd03528 100644 --- a/gentoobrowse/console/packagemasks.xml +++ b/gentoobrowse/console/packagemasks.xml @@ -29,7 +29,7 @@ </project2:sqlmerge> <project2:sqlmerge name="masks" datasource="postgres" targettable="ebuild_masks" useview="yes"> <sql> - SELECT s.setno, ebuildfilter(REGEXP_SPLIT_TO_TABLE(tm.atoms, '\n')) ebuildid + SELECT DISTINCT s.setno, ebuildfilter(REGEXP_SPLIT_TO_TABLE(tm.atoms, '\n')) ebuildid FROM tmpmasks tm, masksets s WHERE tm.dateadded = s.dateadded AND tm.n = s.n |