NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
SELECT
gazetteer.parentgazetteer_guid,
GrParent.gazetteername AS GreatParent,
GParent.gazetteername AS GrandParent,
Parent.gazetteername AS Parent,
gazetteer.gazetteername,
gazetteerlevel.level,
Count(gazetteer.gazetteer_guid)
FROM
gazetteer
Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gazlevel_guid
Inner Join gazetteer AS Parent ON gazetteer.parentgazetteer_guid = Parent.gazetteer_guid
Inner Join gazetteer AS GParent ON Parent.parentgazetteer_guid = GParent.gazetteer_guid
Inner Join gazetteer AS GrParent ON GParent.parentgazetteer_guid = GrParent.gazetteer_guid
GROUP BY
gazetteer.parentgazetteer_guid,
LOWER(gazetteer.gazetteername) COLLATE utf8_bin,gazetteerlevel.level,LOWER(Parent.gazetteername) COLLATE utf8_bin,LOWER(GParent.gazetteername) COLLATE utf8_bin,LOWER(GrParent.gazetteername) COLLATE utf8_bin
HAVING
Count(gazetteer.gazetteer_guid) > '1'
ORDER BY
5,1
</pre>
