BookWalker

home / database

series_tags

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

6 rows where tag_id = "TAG_1M4K4ECTTE70"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0YKW27YXQN70,TAG_1M4K4ECTTE70 Punch Drunk Love CNT_0YKW27YXQN70 Water sports TAG_1M4K4ECTTE70
CNT_16HDEKHEDEBG,TAG_1M4K4ECTTE70 Lover Boy CNT_16HDEKHEDEBG Water sports TAG_1M4K4ECTTE70
CNT_2D6Y137JH3MG,TAG_1M4K4ECTTE70 Prison School CNT_2D6Y137JH3MG Water sports TAG_1M4K4ECTTE70
CNT_2P3A1RJMMQG0,TAG_1M4K4ECTTE70 Parallel Paradise CNT_2P3A1RJMMQG0 Water sports TAG_1M4K4ECTTE70
CNT_2WRZNQAVJ8CG,TAG_1M4K4ECTTE70 The Handsome Salesman At My Office Is My Ideal Master CNT_2WRZNQAVJ8CG Water sports TAG_1M4K4ECTTE70
CNT_35ZNAR53P4RG,TAG_1M4K4ECTTE70 Dr. Ginkaku and The Guinea Pig [Complete Version] CNT_35ZNAR53P4RG Water sports TAG_1M4K4ECTTE70

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);
Powered by Datasette · Queries took 6.97ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS