Country structure orphans: Difference between revisions
Jump to navigation
Jump to search
Created page with "<pre>SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gaz..." |
No edit summary |
||
| Line 9: | Line 9: | ||
gazetteer.parentgazetteer_guid IS NULL AND | gazetteer.parentgazetteer_guid IS NULL AND | ||
gazetteerlevel.seqno <> '1' | gazetteerlevel.seqno <> '1' | ||
---------------------------------------------------------------------------------------------- | |||
This query has to be verified | This query has to be verified | ||
Revision as of 17:02, 10 February 2014
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