Convert Omnivore SQLite database for importing into Raindrop.io

omnivore2raindrop.sql

-- Omnivore timestamp is based on 2001-01-01 (978303600)
select
	item.ZDOWNLOADURL as url,
	null as folder,
	item.ZSITENAME as title,
	null as note,
	GROUP_CONCAT(label.ZNAME, ', ') as tags,
	datetime(item.ZCREATEDAT + 978303600, 'unixepoch') AS created
from ZLINKEDITEM item
left join Z_2LABELS rel on item.Z_PK = rel.Z_2LINKEDITEMS
left join ZLINKEDITEMLABEL label ON label.Z_PK = rel.Z_3LABELS1
group by item.Z_PK