Changes

Country structure orphans

8 bytes removed, 17:58, 12 February 2014

no edit summary

This query checks if parentgazetteer_guid is null<pre>SELECT

gazetteer.gazetteer_localid,

gazetteer.gazetteername,

gazetteer.parentgazetteer_guid IS NULL AND

gazetteerlevel.seqno <> '1'

~~----------------------------------------------------------------------------------------------~~</pre>

This query has to be verified

<pre>

SELECT

Child.gazetteername,

gazetteerlevel.seqno <> '1' AND

Parent.gazetteer_guid IS NULL

</pre>

[[Category:NoPublic]]

[[Category:SQL Queries]]

6,632

edits