on PA.package = PFA.package and PA.version = PFA.version and PA.release = PFA.release
where PA.status in ('installing', 'installed')
group by path
- having (count(distinct
- printf('%s:%s:%s:%s', PFA.filetype, PFA.mode, PFA.username, PFA.groupname)
+ having (count(distinct printf('%s:%s:%s:%s', PFA.filetype, PFA.mode, PFA.username, PFA.groupname)
) > 1 or count(distinct PFA.hash) > 1)
)
select PFH.*,