Country structure orphans - Revision history

Alnaucler at 12:31, 2 June 2017

2017-06-02T12:31:12Z

@@ Line 11: / Line 11: @@
 gazetteer.parentgazetteer_guid IS NULL AND
 gazetteerlevel.seqno <>  '1'
 </pre>

Dionysia at 08:36, 13 February 2014

2014-02-13T08:36:14Z

← Older revision		Revision as of 10:36, 13 February 2014
Line 26:		Line 26:
	Parent.gazetteer_guid IS NULL		Parent.gazetteer_guid IS NULL
	</pre>		</pre>

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 16:58, 12 February 2014

2014-02-12T16:58:22Z

← Older revision		Revision as of 18:58, 12 February 2014
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]]

Alnaucler at 16:02, 10 February 2014

2014-02-10T16:02:03Z

← Older revision		Revision as of 18:02, 10 February 2014
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

Alnaucler: Created page with "

SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gaz..."

2014-02-10T16:01:18Z

Created page with "<pre>SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gaz..."

New page

<pre>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

</pre>
[[Category:NoPublic]]

Country structure orphans - Revision history

Alnaucler at 12:31, 2 June 2017

Dionysia at 08:36, 13 February 2014

Alnaucler at 16:58, 12 February 2014

Alnaucler at 16:02, 10 February 2014

Alnaucler: Created page with "SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gaz..."

Alnaucler: Created page with "
SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gaz..."