diff options
| -rw-r--r-- | gentoobrowse/console/packageimport.xml | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/gentoobrowse/console/packageimport.xml b/gentoobrowse/console/packageimport.xml index 82ab447..84872ed 100644 --- a/gentoobrowse/console/packageimport.xml +++ b/gentoobrowse/console/packageimport.xml @@ -17,6 +17,7 @@ (REGEXP_MATCHES(filename, '^[^/]+'))[1] AS cat, (REGEXP_MATCHES(filename, '/(.+)-[0-9]'))[1] AS name FROM files f + WHERE f.filetypeid = 1 GROUP BY cat, name) f LEFT OUTER JOIN filecache fc ON fc.fileid = f.fileid AND fc.line = 8, categories c |