t_wの輪郭

.txt 添付ファイル

duckdb ./t_w-rinkaku.duckdb "SELECT fg.title as fgtitle, bg.title as bgtitle FROM post as fg, PostRelation, post as bg WHERE regexp_extract(fg.title, '([あ-ん]|[ｂ-ｚ])+')=fg.title AND LEN(fg.title) > 1 AND LEN(bg.title) > 1 AND PostRelation.fg = fg.kno AND PostRelation.bg = bg.kno ORDER BY fg.title;" --json | jq ".[] | .fgtitle + \"\t\" + .bgtitle + \"\t名詞\t\"" -r > import.txt

.txt 添付ファイル

.txt 添付ファイル