-- @query albums_thumb_resolve
-- @db thumbnailCache 9.0
-- @param resource_ids TEXT
SELECT driveItemId, id, 0 AS isLocalOnly
FROM thumbnailCache.thumbnail_metadata
WHERE driveItemId IN (SELECT value FROM json_each(?resource_ids))