products

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

4 rows where series_id = "CNT_2MVBVR23QSNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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_03W79CCB73WG CNT_0E1R9WMM8R70 Flower Demon Door of the Sakaimeya CNT_2MVBVR23QSNG CNT_2MVBVR23QSNG 2 1 1 Volume 3 []   Flower Demon Door of the Sakaimeya, Volume 3   Aren't you someone that just kills humans? Shichinin Misaki is a yokai that only kills humans. They are mourned and hated but their wish is for all Shichinin to be saved. After believing such an uncertain rumor, Ichihiko eagerly helps. This is the final volume of the mysterious story of humans and yokai that will warm your hearts.   01KG9CN6K83JSV568C5JXKGCBK 3.0 2020-06-18T07:00:00.000Z Coamix LAB_28S99QQ57PGG GEO_1PKAG51AEAQG Flower Demon Door of the Sakaimeya, Volume 3 (C)2012 by MAKO OIKAWA/COAMIX   2020-07-14T07:00:00.000Z   0 0
PRD_1JR9FVS0E8NG CNT_12DJ8BK2XSP0 Flower Demon Door of the Sakaimeya CNT_2MVBVR23QSNG CNT_2MVBVR23QSNG 2 1 1 Volume 1 []   Flower Demon Door of the Sakaimeya, Volume 1   To all the yokai, I am here to make sure you live peacefully together with the humans. Our world and the yokai world is connected by the Flower Demon Door. We of the Sakaimeya profession are summoned to teach those yokai that want to live in the human world how to, even though things don't always go according to plan. Teaching Yokai how to feel humanity leads to a heart-warming story.   01KG9BTFH1BT6YJEFNB627NTEA 1.0 2020-05-12T07:00:00.000Z Coamix LAB_28S99QQ57PGG GEO_1PKAG51AEAQG Flower Demon Door of the Sakaimeya, Volume 1 (C)2012 by MAKO OIKAWA/COAMIX   2020-05-19T07:00:00.000Z   0 0
PRD_2M4MK8QVK9HG CNT_08F37JEW8DJ0 Flower Demon Door of the Sakaimeya CNT_2MVBVR23QSNG CNT_2MVBVR23QSNG 2 1 1 Volume 2 []   Flower Demon Door of the Sakaimeya, Volume 2   Sakaimeya are those that support kind Yokai in how to live in the human world. A new Yokai has come to Minoru-kun's side. A one-eyed girl named, Komari, wants to be a model. A mermaid, Sumiko, wants to live like her idol. A rough thunder-beast, Yoruhiko, only knows how to be violent. They are pure Yokai that try their hardest to learn how to be human. This is the highly anticipated second volume that will warm your hearts.   01KGA96ZR9NA8CDE8TF110C6BC 2.0 2020-05-21T07:00:00.000Z Coamix LAB_28S99QQ57PGG GEO_1PKAG51AEAQG Flower Demon Door of the Sakaimeya, Volume 2 (C)2012 by MAKO OIKAWA/COAMIX   2020-06-16T07:00:00.000Z   0 0
PRD_3T9TT0Y012SG CNT_2AZ4XVTW3PT0 Flower Demon Door of the Sakaimeya CNT_2MVBVR23QSNG CNT_2MVBVR23QSNG 2 1 1 Volume 4 []   Flower Demon Door of the Sakaimeya, Volume 4   Aren't you someone that just kills humans? Shichinin Misaki is a yokai that only kills humans. They are mourned and hated but their wish is for all Shichinin to be saved. After believing such an uncertain rumor, Ichihiko eagerly helps. This is the final volume of the mysterious story of humans and yokai that will warm your hearts.   01KG9CW5A9XB6ZDCFFGD07QZNR 4.0 2020-07-27T07:00:00.000Z Coamix LAB_28S99QQ57PGG GEO_1PKAG51AEAQG Flower Demon Door of the Sakaimeya, Volume 4 (C)2012 by MAKO OIKAWA/COAMIX   2020-08-18T07: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);