BookWalker

home / database

series_tags

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

25 rows where series_id = "CNT_0YSH03EYC2J0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0YSH03EYC2J0,TAG_0AMNE3F46BR0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 complete TAG_0AMNE3F46BR0
CNT_0YSH03EYC2J0,TAG_0M42TYMY92W0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Comedy TAG_0M42TYMY92W0
CNT_0YSH03EYC2J0,TAG_15HDDYY3R140 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Kind Male Lead TAG_15HDDYY3R140
CNT_0YSH03EYC2J0,TAG_17KHA2S9A570 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Heterosexual TAG_17KHA2S9A570
CNT_0YSH03EYC2J0,TAG_19N5382V53K0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Best Friends TAG_19N5382V53K0
CNT_0YSH03EYC2J0,TAG_1GBABM09YKD0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Supernatural TAG_1GBABM09YKD0
CNT_0YSH03EYC2J0,TAG_1H35VN34FSE0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Tall Male Lead TAG_1H35VN34FSE0
CNT_0YSH03EYC2J0,TAG_1MDKJNBVT5S0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Working TAG_1MDKJNBVT5S0
CNT_0YSH03EYC2J0,TAG_1RRBVSGJ70J0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Modern Era TAG_1RRBVSGJ70J0
CNT_0YSH03EYC2J0,TAG_1SEMDMPR46P0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Office Worker TAG_1SEMDMPR46P0
CNT_0YSH03EYC2J0,TAG_1TCY4V5T9HS0 Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Male Lead TAG_1TCY4V5T9HS0
CNT_0YSH03EYC2J0,TAG_2M852Y701XZG Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Shoujo TAG_2M852Y701XZG
CNT_0YSH03EYC2J0,TAG_2MBNBKTGHS0G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Romance TAG_2MBNBKTGHS0G
CNT_0YSH03EYC2J0,TAG_30EJ7HVZM13G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Female Lead Falls in Love First TAG_30EJ7HVZM13G
CNT_0YSH03EYC2J0,TAG_34JBCRYY334G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Important Non-Romantic Relationship TAG_34JBCRYY334G
CNT_0YSH03EYC2J0,TAG_35K590QBG0VG Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Kind Female Lead TAG_35K590QBG0VG
CNT_0YSH03EYC2J0,TAG_3AN762EDEW9G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Adult Couple TAG_3AN762EDEW9G
CNT_0YSH03EYC2J0,TAG_3BD0MB7NCFSG Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Appearance Different from Personality TAG_3BD0MB7NCFSG
CNT_0YSH03EYC2J0,TAG_3DNND7FD8P9G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Coworkers TAG_3DNND7FD8P9G
CNT_0YSH03EYC2J0,TAG_3G0KHVC06Y5G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Super Powers TAG_3G0KHVC06Y5G
CNT_0YSH03EYC2J0,TAG_3K01KKPB9JPG Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Special Ability TAG_3K01KKPB9JPG
CNT_0YSH03EYC2J0,TAG_3KY6Q5W995AG Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Slice of Life TAG_3KY6Q5W995AG
CNT_0YSH03EYC2J0,TAG_3MBVN3JK26BG Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Workplace Romance TAG_3MBVN3JK26BG
CNT_0YSH03EYC2J0,TAG_3S0C96F0W45G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Office Lady TAG_3S0C96F0W45G
CNT_0YSH03EYC2J0,TAG_3TG7EMZGHF5G Kijima-san & Yamada-san CNT_0YSH03EYC2J0 Love Triangle TAG_3TG7EMZGHF5G

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE series_tags (
      series_id TEXT NOT NULL,
      tag_id TEXT NOT NULL,
      PRIMARY KEY (series_id, tag_id),
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (tag_id) REFERENCES tags(id)
    );
CREATE INDEX idx_series_tags_tag ON series_tags(tag_id);
Powered by Datasette · Queries took 9.796ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS