products

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

4 rows where series_id = "CNT_12K4Z5N1MWJ0"

✎ 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_0NSZZY0XB2V0 CNT_2D70GYNMFDVG The Boy and the Beast CNT_12K4Z5N1MWJ0 CNT_12K4Z5N1MWJ0 2 1 1 Volume 4 []   The Boy and the Beast, Vol. 4   Ichirohiko has suffered, caught in the space between human and beast, and has succumbed to the darkness. Kyuta leaves Kumatetsu, on the brink of death, in the care of the others and heads to the human world in pursuit of Ichirohiko. It's the start of a life and death battle in the streets of Shibuya to settle things not only with Ichirohiko, but with the darkness in his own heart...!! What can he do to save everyone? The times has come for Kumatetsu, Kyuta, and Kaede to each make their own decisions...   01KGA6FDB5TSVG2DK1QAE7D8XD 4.0 2019-02-19T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG The Boy and the Beast, Vol. 4     2019-02-19T08:00:00.000Z   0 0
PRD_0REEAH27Q1T0 CNT_0CHXG8BWTD4G The Boy and the Beast CNT_12K4Z5N1MWJ0 CNT_12K4Z5N1MWJ0 2 1 1 Volume 2 []   The Boy and the Beast, Vol. 2   Having accidentally wandered into the beast world of Jutengai, Kyuta has gotten himself a master--Kumatetsu. But it turns out Kumatetsu's not quite as good at teaching as he is at brawling. The Grandmaster sends teacher and student alike on a pilgrimage, asking all the wisest beasts in the world a simple question: What is true strength? But are the boy and the beast ready for the answer?   01KGA6FAPE3CGM0D72RX1J07ES 2.0 2019-02-19T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG The Boy and the Beast, Vol. 2     2019-02-19T08:00:00.000Z   0 0
PRD_2T17G8K291AG CNT_3CW707GRNXB0 The Boy and the Beast CNT_12K4Z5N1MWJ0 CNT_12K4Z5N1MWJ0 2 1 1 Volume 3 []   The Boy and the Beast, Vol. 3   Kyuta has been spending more and more time back in the human world. He's about to take an exam that will let him go to college! But does this mean saying goodbye to his master and his life in Jutengai forever? Can he be a part of both worlds, or will he have to choose...?   01KGA6FBC5PAVP50BN5066JN6Y 3.0 2019-02-19T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG The Boy and the Beast, Vol. 3     2019-02-19T08:00:00.000Z   0 0
PRD_2YQP3VD4N09G CNT_1C6M3H510WM0 The Boy and the Beast CNT_12K4Z5N1MWJ0 CNT_12K4Z5N1MWJ0 2 1 1 Volume 1 []   The Boy and the Beast, Vol. 1   Fleeing tragedy and mistreatment, a young boy named Ren hides among the crowds in Tokyo's busy Shibuya ward. His efforts to run away are more successful than he realizes when he ends up in the world of the beasts! A rough-living bear named Kumatetsu gives Ren a new life and a new name--Kyuta--but is Kumatetsu really up to the job of being a mentor?   01KG9B1NP6YTWXFKV1Z8620DZX 1.0 2019-02-19T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG The Boy and the Beast, Vol. 1     2019-02-19T08: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);