pokud by měl někdo problém s vybráním keší, které mají nenulovou souřadnici finále a zároveň atribut ověřovátka, tak stačí použít následující SQL dotaz (třeba ve Smart Filtru). Vygenerovaný odkaz směřuje rovnou k ověřovátku (kotva ctl00_ContentBody_uxCacheChecker). A už se těším na funkční Checker s implementací oficiálního ověřovátka....
SELECT g.id,
g.name,
w.prefixid,
w.x,-- https://www.geocaching.com/geocache/GC8NQ5R
w.y,
'N ' || substr('00' || CAST (w.x AS INT), -2, 2) || '° ' || substr('00' || CAST ( (w.x - CAST (w.x AS INT) ) * 60 AS INT), -2, 2) || '.' || substr('000' || CAST (round( (w.x - CAST (w.x AS INT) - CAST (CAST ( (w.x - CAST (w.x AS INT) ) * 60 AS INT) AS DOUBLE) / 60) * 60 * 1000, 0) AS INT), -3, 3) || ' E ' || substr('000' || CAST (w.y AS INT), -3, 3) || '° ' || substr('00' || CAST ( (w.y - CAST (w.y AS INT) ) * 60 AS INT), -2, 2) || '.' || substr('000' || CAST (round( (w.y - CAST (w.y AS INT) - CAST (CAST ( (w.y - CAST (w.y AS INT) ) * 60 AS INT) AS DOUBLE) / 60) * 60 * 1000, 0) AS INT), -3, 3) geocheck,
'https://www.geocaching.com/geocache/' || w.id || '#ctl00_ContentBody_uxCacheChecker' url
FROM geocache g
JOIN
(
SELECT *
FROM waypoint
WHERE wpttype = 'Final Location' and x<>0 and y<>0
)
w ON w.id = g.id AND
dtfound = 0 AND
g.id IN (
SELECT id
FROM geotag
WHERE ptrkat in (select key ptrkat from geotagcategory where value='attribute')
and ptrvalue in (select key ptrvalue from geotagvalue where value = 'hqsolutionchecker-yes')
)
ORDER BY w.id, w.prefixid