trees

Custom SQL query returning 1 row (hide)

select rowid, TreeID, qLegalStatus_id, qSpecies_id, qAddress, SiteOrder, qSiteInfo, PlantType, qCaretaker_id, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, [Fire Prevention Districts], [Police Districts], [Supervisor Districts], [Zip Codes], [Neighborhoods (old)] from trees where "Neighborhoods (old)" = :p0 and "qSpecies_id" = :p1 and (qAddress > :p3 or (qAddress = :p3 and ((rowid > :p2)))) order by qAddress, rowid limit 101

Query parameters

p0

p1

p3

p2