series_tags

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

11 rows where tag_id = "TAG_3EWZJPS9T7AG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_04WNP877M4EG,TAG_3EWZJPS9T7AG Classroom of the Elite: Year 2 CNT_04WNP877M4EG Calligraphy TAG_3EWZJPS9T7AG
CNT_08YN2KRMS200,TAG_3EWZJPS9T7AG Barakamon CNT_08YN2KRMS200 Calligraphy TAG_3EWZJPS9T7AG
CNT_0FJ2SYSXV380,TAG_3EWZJPS9T7AG From Roommates To Bedmates In A Heartbeat -My Clingy Childhood Friend Likes It Rough- CNT_0FJ2SYSXV380 Calligraphy TAG_3EWZJPS9T7AG
CNT_0P36ZDEZXZHG,TAG_3EWZJPS9T7AG Classroom of the Elite: Year 2 CNT_0P36ZDEZXZHG Calligraphy TAG_3EWZJPS9T7AG
CNT_0QT41FMEGJEG,TAG_3EWZJPS9T7AG Heaven Official's Blessing: Tian Guan Ci Fu CNT_0QT41FMEGJEG Calligraphy TAG_3EWZJPS9T7AG
CNT_0VFD89M016VG,TAG_3EWZJPS9T7AG Handa-kun CNT_0VFD89M016VG Calligraphy TAG_3EWZJPS9T7AG
CNT_19Y3R01Z6950,TAG_3EWZJPS9T7AG Salt & Pepper and Pudding CNT_19Y3R01Z6950 Calligraphy TAG_3EWZJPS9T7AG
CNT_2HDB0K4N8520,TAG_3EWZJPS9T7AG Shy CNT_2HDB0K4N8520 Calligraphy TAG_3EWZJPS9T7AG
CNT_2P27PX4JSD10,TAG_3EWZJPS9T7AG The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10 Calligraphy TAG_3EWZJPS9T7AG
CNT_2SSXVJWX8S6G,TAG_3EWZJPS9T7AG The Lines that Define Me CNT_2SSXVJWX8S6G Calligraphy TAG_3EWZJPS9T7AG
CNT_36BGXY16BDX0,TAG_3EWZJPS9T7AG Hoteri Hotette First Kiss CNT_36BGXY16BDX0 Calligraphy TAG_3EWZJPS9T7AG

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);