Skip to content

Instantly share code, notes, and snippets.

View Denubis's full-sized avatar

Brian Ballsun-Stanton Denubis

View GitHub Profile
select uuid, response, hex(asbinary(geospatialcolumn))
from latestnondeletedarchentidientifiers
join latestnondeletedarchent using (uuid)
join createdModifiedAtBy using (uuid)
WHERE arowid in (SELECT pkid
FROM idx_archentity_geospatialcolumn
WHERE pkid MATCH RTreeIntersects(?, ?, ?, ?)
)
order by createdAt
limit ?;