Coordinate display rules
SELECT geopoint.userinputformat, Count(geopoint.geopoint_guid) FROM geopoint GROUP BY geopoint.userinputformat HAVING (geopoint.userinputformat <> 'X and Y' AND geopoint.userinputformat <> 'MGRS' AND geopoint.userinputformat <> 'Bearing and distance') OR geopoint.userinputformat is null
Note: This query is in 5.x format