NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "SELECT geopoint.userinputformat, Count(geopoint.geopoint_guid) FROM geopoint GROUP BY geopoint.userinputformat HAVING (geopoint.userinputformat <> 'X and Y' AND geopoint.u..."
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
[[Category:NoPublic]]
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
[[Category:NoPublic]]
