NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
Note: These queries are in 5.x format<br />
'''Accident'''
<pre>
hazard.hazard_localid ASC
</pre>
'''Haz RedHazRed'''
<pre>
SELECT
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
'''Location''
<pre>
SELECT
location.location_localid
FROM
location
WHERE
location.hasgeodata = '0'
ORDER BY
location.location_localid ASC
</pre>
'''MRE'''
<pre>
SELECT
mre.mre_localid
FROM
mre
WHERE
mre.hasgeodata = '0'
ORDER BY
mre.mre_localid ASC
</pre>
'''QA'''
<pre>
SELECT
qa.qa_localid
FROM
qa
WHERE
qa.hasgeodata = '0'
ORDER BY
qa.qa_localid ASC
</pre>
'''Task'''
<pre>
SELECT
task.localid
FROM
task
WHERE
task.hasgeodata = '0'
ORDER BY
task.localid ASC
</pre>
'''Victim'''
<pre>
SELECT
victim.victim_localid
FROM
victim
WHERE
victim.hasgeodata = '0'
ORDER BY
victim.victim_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
