dnet50/modules/dnet-wds/trunk/src/main/resources/eu/dnetlib/msro/workflows/dedup/querySimilaritiesBySet.sql.st @ 43444
| 1 |
SELECT * FROM ( |
|---|---|
| 2 |
SELECT g.id, date, entitytype, array_agg(sg.objidentifier) as group |
| 3 |
FROM groups g LEFT OUTER join similarity_groups sg ON (g.id = sg.groupid) |
| 4 |
WHERE g.actionsetid = '%s' |
| 5 |
GROUP BY g.id, date, entitytype) AS T |
| 6 |
WHERE array_length(T.group, 1) > 1 |