series_tags

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

8 rows where tag_id = "TAG_1EV7N3012SQ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_00FHZ9BPY3H0,TAG_1EV7N3012SQ0 RVing My Way into Exile with My Beloved Cat: This Villainess Is Trippin' CNT_00FHZ9BPY3H0 Camping TAG_1EV7N3012SQ0
CNT_043NZDQGY420,TAG_1EV7N3012SQ0 Lust Geass CNT_043NZDQGY420 Camping TAG_1EV7N3012SQ0
CNT_052KGXEKXCFG,TAG_1EV7N3012SQ0 The Fable CNT_052KGXEKXCFG Camping TAG_1EV7N3012SQ0
CNT_0T1B3F6DJNM0,TAG_1EV7N3012SQ0 Insomniacs After School CNT_0T1B3F6DJNM0 Camping TAG_1EV7N3012SQ0
CNT_1JQBQ4HPFT20,TAG_1EV7N3012SQ0 At Your Service in Another World CNT_1JQBQ4HPFT20 Camping TAG_1EV7N3012SQ0
CNT_2GWS6Z5RB04G,TAG_1EV7N3012SQ0 The Fool's Mountain Night CNT_2GWS6Z5RB04G Camping TAG_1EV7N3012SQ0
CNT_3BVWA8FY4110,TAG_1EV7N3012SQ0 Golden Kamuy CNT_3BVWA8FY4110 Camping TAG_1EV7N3012SQ0
CNT_3J2E0YD4J1HG,TAG_1EV7N3012SQ0 Laid-Back Camp CNT_3J2E0YD4J1HG Camping TAG_1EV7N3012SQ0

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