Changes

Jump to: navigation, search

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

Navigation menu