products

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

5 rows where series_id = "CNT_2YR8N9DTT02G"

✎ 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_0E2EANRXQHN0 CNT_3SEH5QJQ95X0 Demonizer Zilch CNT_2YR8N9DTT02G CNT_2YR8N9DTT02G 2 1 1 Volume 5 []   Demonizer Zilch, Vol. 5   Haruomi and the Seventh Gospel Organization have arrived to rescue Murohime, but Hellentza has designs on the buxom agent as well. What's more, Zilch's bizarre behavior only adds to the chaos-will the true identity of her second personality finally come to light?! Discover the fate that awaits the heroines in the climactic conclusion to Demonizer Zilch!   01KGA3K2YCCTH1PZD32MW7TV1T 5.0 2018-10-30T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Demonizer Zilch, Vol. 5     2018-10-30T07:00:00.000Z   0 0
PRD_1CXDDSPFPGY0 CNT_1T7HVTKY5SQ0 Demonizer Zilch CNT_2YR8N9DTT02G CNT_2YR8N9DTT02G 2 1 1 Volume 3 []   Demonizer Zilch, Vol. 3   Ever since his sister disappeared ten years ago, Haruomi's held a grudge against the mysterious organization Goetia. But when the demonic "Branches" Leraje and Berith go after both Haruomi's dad and Zilch, things get even more personal! Will Haruomi and Zilch be able to fend off the encroaching devils...and get into some sinful situations while they're at it?   01KG9ZAPJB6S11QV5366EPEMBJ 3.0 2017-08-21T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Demonizer Zilch, Vol. 3     2017-08-21T15:00:00.000Z   0 0
PRD_2G5196KV49NG CNT_0M7B9SVJHKX0 Demonizer Zilch CNT_2YR8N9DTT02G CNT_2YR8N9DTT02G 2 1 1 Volume 1 []   Demonizer Zilch, Vol. 1   Haunted by the untimely deaths of his mother, little sister, and a childhood friend, listless high schooler Haruomi Io has trouble engaging with anything or anyone. Of course, that doesn't mean others have trouble engaging with him-a fact he discovers to his dismay when he finds himself the target of a trigger-happy group calling themselves the "Seventh Gospel Organization." Having newfound enemies may be rough, but Haruomi's unexpected ally in the form of a demoness calling herself Zilch may turn out to be even more of a handful...Still, there's something to be said for a dose of the supernatural (and more than a few buxom girls) when it comes to casting off the doldrums!   01K5G9Y0BDSTK8C15BSXYYE1FV 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Demonizer Zilch, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_3F2PV39X3Z6G CNT_22AFA2N1C8ZG Demonizer Zilch CNT_2YR8N9DTT02G CNT_2YR8N9DTT02G 2 1 1 Volume 4 []   Demonizer Zilch, Vol. 4   Haruomi, Zilch, and Murohime have stormed Goetia’s headquarters to rescue Haruomi’s father. Within Goetia’s walls, they find signs of an internal power struggle. Who is Beelzebub, and why is the Ring of Solomon ineffective against her? As the mysteries surrounding the “Branches” grow, Haruomi discovers that the bonds between Zilch, Murohime, and himself run far deeper than he realized!   01KG9VVE0C2TK3ENFZT9NQK8V7 4.0 2017-11-14T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Demonizer Zilch, Vol. 4     2017-11-14T08:00:00.000Z   0 0
PRD_3PRSG1MMRABG CNT_06CKE992ZD8G Demonizer Zilch CNT_2YR8N9DTT02G CNT_2YR8N9DTT02G 2 1 1 Volume 2 []   Demonizer Zilch, Vol. 2   Haruomi awakens to the power of the Ring of Solomon and decides to take up the role of Annihilator in the Seventh Gospel Organization, a society of demon hunters, in order to grant Zilch her wish. Under orders from the organization, Haruomi and Zilch begin a covert investigation to find a new "branch" at Kanmeikan High School, where they're joined by none other than Murohime. What adventures await them there...?!   01KG934TSEJWW9VEGEF29Q2HKZ 2.0 2016-10-03T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Demonizer Zilch, Vol. 2     2016-10-03T15: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);