Country structure orphans: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | This query checks if parentgazetteer_guid is null | ||
<pre> | |||
SELECT | |||
gazetteer.gazetteer_localid, | gazetteer.gazetteer_localid, | ||
gazetteer.gazetteername, | gazetteer.gazetteername, | ||
| Line 9: | Line 11: | ||
gazetteer.parentgazetteer_guid IS NULL AND | gazetteer.parentgazetteer_guid IS NULL AND | ||
gazetteerlevel.seqno <> '1' | gazetteerlevel.seqno <> '1' | ||
</pre> | |||
This query has to be verified | This query has to be verified | ||
<pre> | |||
SELECT | SELECT | ||
Child.gazetteername, | Child.gazetteername, | ||
| Line 23: | Line 25: | ||
gazetteerlevel.seqno <> '1' AND | gazetteerlevel.seqno <> '1' AND | ||
Parent.gazetteer_guid IS NULL | Parent.gazetteer_guid IS NULL | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 17:58, 12 February 2014
This query checks if parentgazetteer_guid is null
SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gazlevel_guid WHERE gazetteer.parentgazetteer_guid IS NULL AND gazetteerlevel.seqno <> '1'
This query has to be verified
SELECT Child.gazetteername, gazetteerlevel.seqno FROM gazetteer AS Child Left Join gazetteer AS Parent ON Child.parentgazetteer_guid = Parent.gazetteer_guid Inner Join gazetteerlevel ON Child.gazlevel_guid = gazetteerlevel.gazlevel_guid WHERE gazetteerlevel.seqno <> '1' AND Parent.gazetteer_guid IS NULL