-- Open renda.sqlite read-only. All 119 codes are provided in English. SELECT code,lang,title,body,href FROM passages WHERE lookup='FC07' AND lang='EN'; SELECT p.code,p.title,p.href,snippet(search,2,'[',']','…',18) AS excerpt FROM search JOIN passages p ON p.id=search.rowid WHERE search MATCH 'ethics' AND p.kind='codex' ORDER BY bm25(search),p.id LIMIT 8; SELECT code,title,body FROM passages WHERE lookup='S04' AND lang='EN';