NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "<pre>SELECT gazetteer.gazetteer_localid, gazetteer.gazetteername, gazetteerlevel.level FROM gazetteer Inner Join gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gaz..."
<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]]
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]]