Country structure orphans: Difference between revisions

From IMSMA Wiki
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