products

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

2 rows where series_id = "CNT_1W09TY18XTX0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_1ZTVBF0H8S2G CNT_2P9F7M2ND530 The Ancient Magus' Bride CNT_1W09TY18XTX0 CNT_1W09TY18XTX0 2 2 1 The Silver Yarn Vol. 1 []   The Ancient Magus' Bride: The Silver Yarn Vol. 1   The world of The Ancient Magus' Bride is bigger than Elias and Chise, and many are the folk and spirits who cross their lives' path. Their tales are woven into a tapestry, words like silver yarn, twining together emotions and warmth. Held within these pages are new stories of Kore Yamazaki's fantastic Britain, penned by the author herself and a star-studded lineup of Japanese authors. From the story of a very strange brownie to gangsters and dragon eggs, and a mage who finds a clutch of magical silkworms, let this spell-binding collection return you to the hidden corners of a beloved fantasy world. The second Ancient Magus' Bride short story collection! 01KG9B1XWMFW4S5YAC29PPZ44D 2.0 2019-02-05T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Ancient Magus' Bride: The Silver Yarn Vol. 1 Kore Yamazaki 2017, Yuichiro Higashide, Megumi Masono, Chikashi Yoshida, Sako Aizawa, Yoshinobu Akita, Suzuki Ootsuki, Yuu Godai 2017   2019-03-19T08:00:00.000Z   0 0
PRD_23YESG0K88XG CNT_1WS1V9H2SX5G The Ancient Magus' Bride CNT_1W09TY18XTX0 CNT_1W09TY18XTX0 2 2 1 The Golden Yarn Vol. 1 []   The Ancient Magus' Bride: The Golden Yarn Vol. 1   The world of The Ancient Magus' Bride is bigger than Elias and Chise, and many are the folk and spirits who cross their lives' path. Their tales twist together in a tapestry, words like golden yarn, a weaving of memories and secrets. Contained within these pages are new stories of Kore Yamazaki's fantastic Britain, penned by the author herself and a star-studded lineup of Japanese authors. From a Celtic vampire in love with a human, to a gemstone knight, and even a glimpse into what Silky does in her spare time, let this enchanted collection take you to the hidden corners of a beloved fantasy world. The first Ancient Magus' Bride short story collection! 01KGA3S27NC5GN0J83APM3VYR0 1.0 2018-10-29T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Ancient Magus' Bride: The Golden Yarn Vol. 1 Kore Yamazaki 2017, Makoto Sanda, Aotsuki Kairi, Hikaru Sakurai, Sakura Sato, Junichi Fujisaku, MIWA=Kiyomune, Yu Godai 2017   2018-12-11T08:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE products (
      id TEXT PRIMARY KEY,
      content_id TEXT NOT NULL,
      series_id TEXT NOT NULL,
      parent_content_id TEXT,
      level INTEGER NOT NULL,
      content_type INTEGER NOT NULL,
      product_type INTEGER NOT NULL,
      title TEXT NOT NULL,
      alt_titles TEXT NOT NULL,
      subtitle TEXT NOT NULL,
      display_title TEXT NOT NULL,
      display_title_short TEXT NOT NULL,
      description TEXT NOT NULL,
      description_short TEXT NOT NULL,
      image_id TEXT NOT NULL,
      display_order REAL NOT NULL,
      listed_at TEXT NOT NULL,
      label_id TEXT NOT NULL,
      geoblock_id TEXT,
      display_name TEXT NOT NULL,
      copyright TEXT,
      on_presale_at TEXT,
      on_sale_at TEXT NOT NULL,
      off_sale_at TEXT,
      add_on INTEGER NOT NULL,
      add_on_campaign_only INTEGER NOT NULL,
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (label_id) REFERENCES labels(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);