BookWalker

home / database

series_tags

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

7 rows where tag_id = "TAG_2BME287X87G0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0FCGAWQZ00C0,TAG_2BME287X87G0 Apprentice Nail Artist in a Foreign Land CNT_0FCGAWQZ00C0 CGN004030 TAG_2BME287X87G0
CNT_0TCW7NVZ05MG,TAG_2BME287X87G0 OctoPiece CNT_0TCW7NVZ05MG CGN004030 TAG_2BME287X87G0
CNT_0YBA1BXHEZJG,TAG_2BME287X87G0 Time is a Closet CNT_0YBA1BXHEZJG CGN004030 TAG_2BME287X87G0
CNT_200HM7393V90,TAG_2BME287X87G0 I Picked Up a No-Good, Useless Prince CNT_200HM7393V90 CGN004030 TAG_2BME287X87G0
CNT_27ZFHN6VHNQ0,TAG_2BME287X87G0 Bride of Ignat CNT_27ZFHN6VHNQ0 CGN004030 TAG_2BME287X87G0
CNT_2ARZ8RAN1570,TAG_2BME287X87G0 The Tale of Luvelia Kingdom CNT_2ARZ8RAN1570 CGN004030 TAG_2BME287X87G0
CNT_3J60D7VRGFW0,TAG_2BME287X87G0 Dear Demon King CNT_3J60D7VRGFW0 CGN004030 TAG_2BME287X87G0

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 8.271ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS