<pre>SELECT
geopoint.userinputformat,
Count(geopoint.geopoint_guid)
FROM
geopoint
GROUP BY
geopoint.userinputformat
HAVING
(geopoint.userinputformat <> 'X and Y' AND
geopoint.userinputformat <> 'Bearing and distance') OR
geopoint.userinputformat is null
</pre>
Note: This query is in 5.x format
[[Category:NoPublic]]