NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
<pre>
SELECT
gazetteer.gazetteer_localid,gazetteer.gazetteername,gazetteerlevel.`level`
FROM
gazetteer
INNER JOIN gazetteerlevel ON gazetteer.gazlevel_guid = gazetteerlevel.gazlevel_guid
WHERE
gazetteer_localid IS NULL OR length(trim(gazetteer_localid)) = 0
ORDER BY
gazetteer.gazetteername ASC
</pre>
<pre>
SELECT
organisation.org_localid,organisation.orgname,organisation.parentorg_guid
FROM
organisation
WHERE
org_localid IS NULL OR length(trim(org_localid)) = 0
ORDER BY
organisation.orgname ASC
</pre>
<pre>
SELECT
place.place_localid,place.placename
FROM
place
WHERE
place_localid IS NULL OR length(trim(place_localid)) = 0
ORDER BY
place.placename ASC
</pre>
<pre>
SELECT
task.localid,task.`name`
FROM
task
WHERE
task.localid IS NULL or length(trim(task.localid))=0
ORDER BY
task.`name` ASC
</pre>
<pre>
SELECT
work_item.localid,work_item.`name`
FROM
work_item
WHERE
work_item.localid IS NULL OR length(trim(work_item.localid)) = 0
ORDER BY
work_item.`name` ASC
</pre>