SQL Saved search No geo data

Note: These queries are in 5.x format Accident

SELECT
accident.accident_localid
FROM
accident
WHERE
accident.hasgeodata =  '0'
ORDER BY
accident.accident_localid ASC

Hazard

SELECT
hazard.hazard_localid
FROM
hazard
WHERE
hazard.hasgeodata =  '0'
ORDER BY
hazard.hazard_localid ASC

Haz Red

SELECT
hazreduc.hazreduc_localid
FROM
hazreduc
WHERE
hazreduc.hasgeodata =  '0'
ORDER BY
hazreduc.hazreduc_localid ASC