BookWalker

home / database

series_tags

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

8 rows where tag_id = "TAG_3T5QJ6711STG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_063GAHX9WERG,TAG_3T5QJ6711STG Case Closed CNT_063GAHX9WERG Mahjong TAG_3T5QJ6711STG
CNT_09CF9PR13JS0,TAG_3T5QJ6711STG Saki & FINAL FANTASY XIV CNT_09CF9PR13JS0 Mahjong TAG_3T5QJ6711STG
CNT_1JHW2Q8VEN5G,TAG_3T5QJ6711STG The Voynich Hotel CNT_1JHW2Q8VEN5G Mahjong TAG_3T5QJ6711STG
CNT_1WCF746HAPG0,TAG_3T5QJ6711STG Alice in Borderland CNT_1WCF746HAPG0 Mahjong TAG_3T5QJ6711STG
CNT_22S2M4P27NQG,TAG_3T5QJ6711STG INVESTOR-Z CNT_22S2M4P27NQG Mahjong TAG_3T5QJ6711STG
CNT_2R8NMC5FBM4G,TAG_3T5QJ6711STG Mahjong Parlor of Love CNT_2R8NMC5FBM4G Mahjong TAG_3T5QJ6711STG
CNT_33V4SAD6956G,TAG_3T5QJ6711STG Saki CNT_33V4SAD6956G Mahjong TAG_3T5QJ6711STG
CNT_3B4DZVBZ7ZK0,TAG_3T5QJ6711STG Rai Rai Rai CNT_3B4DZVBZ7ZK0 Mahjong TAG_3T5QJ6711STG

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