series_tags

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

9 rows where tag_id = "TAG_351MCTV50Z2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_08GQ36KQVAE0,TAG_351MCTV50Z2G A Bride's Story CNT_08GQ36KQVAE0 LGBT Subtext TAG_351MCTV50Z2G
CNT_0AMDQN8J0H5G,TAG_351MCTV50Z2G The Wolf's Head Café CNT_0AMDQN8J0H5G LGBT Subtext TAG_351MCTV50Z2G
CNT_1SP0ZPGJGAXG,TAG_351MCTV50Z2G From the New World CNT_1SP0ZPGJGAXG LGBT Subtext TAG_351MCTV50Z2G
CNT_1SXHKQ5BKJRG,TAG_351MCTV50Z2G Ayakashi Triangle CNT_1SXHKQ5BKJRG LGBT Subtext TAG_351MCTV50Z2G
CNT_2ATFJJZZTT0G,TAG_351MCTV50Z2G Land of the Lustrous CNT_2ATFJJZZTT0G LGBT Subtext TAG_351MCTV50Z2G
CNT_2EFEYX45CC60,TAG_351MCTV50Z2G The Faraway Paladin CNT_2EFEYX45CC60 LGBT Subtext TAG_351MCTV50Z2G
CNT_32P9RE7ZED20,TAG_351MCTV50Z2G Bee-Sting Babe and the Gorgeous Guy CNT_32P9RE7ZED20 LGBT Subtext TAG_351MCTV50Z2G
CNT_3H34TCR868C0,TAG_351MCTV50Z2G Like a Boss -the Tyrant and Me in Bed til the End- CNT_3H34TCR868C0 LGBT Subtext TAG_351MCTV50Z2G
CNT_3WDZ1HVB8J20,TAG_351MCTV50Z2G The Great Jahy Will Not Be Defeated! CNT_3WDZ1HVB8J20 LGBT Subtext TAG_351MCTV50Z2G

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