<pre>SELECT
geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord
FROM
geopoint
INNER JOIN geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid
WHERE geopoint.longitude > '180' OR
geopoint.longitude < '-180' OR
geopoint.latitude > '90' OR
geopoint.latitude < '-90' OR
geopoint.latitude IS NULL OR
geopoint.longitude IS NULL OR
geopoint.userenteredcoord IS NULL
</pre>
Note: This query is in 5.x format
[[Category:NoPublic]]