NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "Note: These queries are in 5.x format '''Accident''' <pre> SELECT accident.accident_localid FROM accident WHERE accident.hasgeodata = '0' ORDER BY accident.accident_localid A..."
Note: These queries are in 5.x format
'''Accident'''
<pre>
SELECT
accident.accident_localid
FROM
accident
WHERE
accident.hasgeodata = '0'
ORDER BY
accident.accident_localid ASC
</pre>
'''Hazard'''
<pre>
SELECT
hazard.hazard_localid
FROM
hazard
WHERE
hazard.hasgeodata = '0'
ORDER BY
hazard.hazard_localid ASC
</pre>
'''Haz Red'''
<pre>
SELECT
hazreduc.hazreduc_localid
FROM
hazreduc
WHERE
hazreduc.hasgeodata = '0'
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
'''Accident'''
<pre>
SELECT
accident.accident_localid
FROM
accident
WHERE
accident.hasgeodata = '0'
ORDER BY
accident.accident_localid ASC
</pre>
'''Hazard'''
<pre>
SELECT
hazard.hazard_localid
FROM
hazard
WHERE
hazard.hasgeodata = '0'
ORDER BY
hazard.hazard_localid ASC
</pre>
'''Haz Red'''
<pre>
SELECT
hazreduc.hazreduc_localid
FROM
hazreduc
WHERE
hazreduc.hasgeodata = '0'
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
