series_tags

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

28 rows where series_id = "CNT_3K8FNQKY1BQG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3K8FNQKY1BQG,TAG_0AMNE3F46BR0 23:45 CNT_3K8FNQKY1BQG complete TAG_0AMNE3F46BR0
CNT_3K8FNQKY1BQG,TAG_0NPD5CER9Y80 23:45 CNT_3K8FNQKY1BQG Shounen TAG_0NPD5CER9Y80
CNT_3K8FNQKY1BQG,TAG_11A4ZJ5WX3Y0 23:45 CNT_3K8FNQKY1BQG Ghosts TAG_11A4ZJ5WX3Y0
CNT_3K8FNQKY1BQG,TAG_16K7DS0XXSG0 23:45 CNT_3K8FNQKY1BQG Glasses-Wearing Protagonist TAG_16K7DS0XXSG0
CNT_3K8FNQKY1BQG,TAG_1BQ91XX2Q7J0 23:45 CNT_3K8FNQKY1BQG Amnesia TAG_1BQ91XX2Q7J0
CNT_3K8FNQKY1BQG,TAG_1CZKT8ATGE20 23:45 CNT_3K8FNQKY1BQG College TAG_1CZKT8ATGE20
CNT_3K8FNQKY1BQG,TAG_1GBABM09YKD0 23:45 CNT_3K8FNQKY1BQG Supernatural TAG_1GBABM09YKD0
CNT_3K8FNQKY1BQG,TAG_1JDY9R0Q0QC0 23:45 CNT_3K8FNQKY1BQG Shounen Ai TAG_1JDY9R0Q0QC0
CNT_3K8FNQKY1BQG,TAG_1P3QSYSHW6X0 23:45 CNT_3K8FNQKY1BQG Tragedy TAG_1P3QSYSHW6X0
CNT_3K8FNQKY1BQG,TAG_1QD1MDDEDRA0 23:45 CNT_3K8FNQKY1BQG Urban Fantasy TAG_1QD1MDDEDRA0
CNT_3K8FNQKY1BQG,TAG_1TCY4V5T9HS0 23:45 CNT_3K8FNQKY1BQG Male Lead TAG_1TCY4V5T9HS0
CNT_3K8FNQKY1BQG,TAG_1WN0XQJKJR90 23:45 CNT_3K8FNQKY1BQG Primarily Male Cast TAG_1WN0XQJKJR90
CNT_3K8FNQKY1BQG,TAG_1X0XMNRA3Q20 23:45 CNT_3K8FNQKY1BQG School TAG_1X0XMNRA3Q20
CNT_3K8FNQKY1BQG,TAG_1XYX86683VP0 23:45 CNT_3K8FNQKY1BQG Roommates TAG_1XYX86683VP0
CNT_3K8FNQKY1BQG,TAG_1YF6BWCNN250 23:45 CNT_3K8FNQKY1BQG Part-Time Job TAG_1YF6BWCNN250
CNT_3K8FNQKY1BQG,TAG_2M2AXCZQH3EG 23:45 CNT_3K8FNQKY1BQG Drama TAG_2M2AXCZQH3EG
CNT_3K8FNQKY1BQG,TAG_2M5T60D610KG 23:45 CNT_3K8FNQKY1BQG Boys Love TAG_2M5T60D610KG
CNT_3K8FNQKY1BQG,TAG_2MBNBKTGHS0G 23:45 CNT_3K8FNQKY1BQG Romance TAG_2MBNBKTGHS0G
CNT_3K8FNQKY1BQG,TAG_36MZ9CS5N77G 23:45 CNT_3K8FNQKY1BQG Glasses-Wearing Male Lead TAG_36MZ9CS5N77G
CNT_3K8FNQKY1BQG,TAG_3ATPBNQZYPYG 23:45 CNT_3K8FNQKY1BQG Afterlife TAG_3ATPBNQZYPYG
CNT_3K8FNQKY1BQG,TAG_3G43TZ3GPVEG 23:45 CNT_3K8FNQKY1BQG Suicide TAG_3G43TZ3GPVEG
CNT_3K8FNQKY1BQG,TAG_3JT71RGD8WJG 23:45 CNT_3K8FNQKY1BQG Seeing Things Other Humans Can't TAG_3JT71RGD8WJG
CNT_3K8FNQKY1BQG,TAG_3KY6Q5W995AG 23:45 CNT_3K8FNQKY1BQG Slice of Life TAG_3KY6Q5W995AG
CNT_3K8FNQKY1BQG,TAG_3Q5S38CN507G 23:45 CNT_3K8FNQKY1BQG Unexpected Feelings TAG_3Q5S38CN507G
CNT_3K8FNQKY1BQG,TAG_3QESHZBP57SG 23:45 CNT_3K8FNQKY1BQG Urban TAG_3QESHZBP57SG
CNT_3K8FNQKY1BQG,TAG_3X845AY38F6G 23:45 CNT_3K8FNQKY1BQG School Life TAG_3X845AY38F6G
CNT_3K8FNQKY1BQG,TAG_3YVF3WW3WQBG 23:45 CNT_3K8FNQKY1BQG Otaku TAG_3YVF3WW3WQBG
CNT_3K8FNQKY1BQG,TAG_3ZA83YSAT31G 23:45 CNT_3K8FNQKY1BQG Primarily Adult Cast TAG_3ZA83YSAT31G

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