series_tags

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

14 rows where tag_id = "TAG_0NAFC9T5P700"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0EJ05G6Q36EG,TAG_0NAFC9T5P700 Legend of Exorcism: Tianbao Fuyao Lu CNT_0EJ05G6Q36EG Adopted Male Lead TAG_0NAFC9T5P700
CNT_0KA0GESGCZ8G,TAG_0NAFC9T5P700 The Lady Knight and the Beast-Eared Child CNT_0KA0GESGCZ8G Adopted Male Lead TAG_0NAFC9T5P700
CNT_0NN926TJCAK0,TAG_0NAFC9T5P700 Legend of Exorcism: Tianbao Fuyao Lu CNT_0NN926TJCAK0 Adopted Male Lead TAG_0NAFC9T5P700
CNT_19ND0D4NH2TG,TAG_0NAFC9T5P700 Jiangshi X CNT_19ND0D4NH2TG Adopted Male Lead TAG_0NAFC9T5P700
CNT_1CFXMCV87WE0,TAG_0NAFC9T5P700 Dragon Quest: The Adventure of Dai CNT_1CFXMCV87WE0 Adopted Male Lead TAG_0NAFC9T5P700
CNT_1XQXGN6A4ZNG,TAG_0NAFC9T5P700 The Husky and His White Cat Shizun: Erha He Ta De Bai Mao Shizun CNT_1XQXGN6A4ZNG Adopted Male Lead TAG_0NAFC9T5P700
CNT_28NF1MJ2FTR0,TAG_0NAFC9T5P700 Engage CNT_28NF1MJ2FTR0 Adopted Male Lead TAG_0NAFC9T5P700
CNT_2BMYAZDJQJJG,TAG_0NAFC9T5P700 Fiance of the Wizard CNT_2BMYAZDJQJJG Adopted Male Lead TAG_0NAFC9T5P700
CNT_2C88RSWS62EG,TAG_0NAFC9T5P700 My Sister, The Cat CNT_2C88RSWS62EG Adopted Male Lead TAG_0NAFC9T5P700
CNT_2HHT2PC5BMXG,TAG_0NAFC9T5P700 The Husky and His White Cat Shizun: Erha He Ta De Bai Mao Shizun CNT_2HHT2PC5BMXG Adopted Male Lead TAG_0NAFC9T5P700
CNT_2WTT1MC575Q0,TAG_0NAFC9T5P700 My Not-So-Fair Lady is Doomed! (But Not If I Can Help It) CNT_2WTT1MC575Q0 Adopted Male Lead TAG_0NAFC9T5P700
CNT_30GZ55C3B5GG,TAG_0NAFC9T5P700 MamaYuyu CNT_30GZ55C3B5GG Adopted Male Lead TAG_0NAFC9T5P700
CNT_39E3FDR6CB20,TAG_0NAFC9T5P700 His Little Amber CNT_39E3FDR6CB20 Adopted Male Lead TAG_0NAFC9T5P700
CNT_3K6SHXBDADP0,TAG_0NAFC9T5P700 Dad's Assassin CNT_3K6SHXBDADP0 Adopted Male Lead TAG_0NAFC9T5P700

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