Comment 1 for bug 503697

I had Tom Haddon run this query to try to find the offending entry:

select
    po1.id as po1id, po2.id as po2id,
    pot1.id as pot1id, pot1.name as pot1name,
    pot2.id as pot2id, pot2.name as pot2name,
    po1.path, distroseries.name, sourcepackagename.name
from
    pofile po1, pofile po2, potemplate pot1, potemplate pot2,
    distroseries, sourcepackagename
where
    po1.id <> po2.id and
    po1.potemplate = pot1.id and
    po2.potemplate = pot2.id and
    po1.path = po2.path and
    pot1.distroseries = pot2.distroseries and
    pot1.sourcepackagename = pot2.sourcepackagename and
    pot1.distroseries = distroseries.id and
    pot1.sourcepackagename = sourcepackagename.id;

The output is attached, is has twice as many lines as needed because the "<>" up there should have been a "<", so please ignore every other line.

So, some of these come about through inactive templates but others don't. I am not sure what is wrong here, code or data integrity.