products

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

5 rows where series_id = "CNT_18KTRZ7C48P0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, 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_1KA262T959CG CNT_259Z2WWR25BG Frau Faust CNT_18KTRZ7C48P0 CNT_18KTRZ7C48P0 2 1 1 Volume 3 []   Frau Faust, Volume 3   Mephistopheles's right leg has been found, and it turns out that a member of the church has been using the leg's blood for nefarious purposes! But behind the scenes lurks another demon. Now Johanna must thrust herself into battle to stop a girl who is no longer among the truly living... Will Johanna and her cohorts retrieve her demon's limb unscathed, or will they become dinner for the undead?   01KGA1A10D56TJRNXS1CVQNFH3 3.0 2023-12-14T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Frau Faust, Volume 3 Kore Yamazaki/Kodansha Ltd.   2018-01-23T08:00:00.000Z   0 0
PRD_214621XHMVPG CNT_07K9BDAN9PHG Frau Faust CNT_18KTRZ7C48P0 CNT_18KTRZ7C48P0 2 1 1 Volume 4 []   Frau Faust, Volume 4   After a surprise reappearance by a recently defeated demon, Johanna and her companions find themselves under attack. The demon Ino has been ordered to capture Dr. Faust, and this time, nothing will stop Ino from accomplishing her goal. Soon, Johanna finds herself in the heart of enemy territory, but the Doctor's smirk as she faces her captors seems to suggest that the series of events leading to her defeat may have all been according to plan...   01KGA2WBZNH60BARWNQDN28TTF 4.0 2023-12-14T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Frau Faust, Volume 4 Kore Yamazaki/Kodansha Ltd.   2018-03-06T08:00:00.000Z   0 0
PRD_258GZMR7Z420 CNT_0092Q1DQGDK0 Frau Faust CNT_18KTRZ7C48P0 CNT_18KTRZ7C48P0 2 1 1 Volume 2 []   Frau Faust, Volume 2   After narrowly escaping a battle with Lorenzo, Johanna falls unconscious. In her wounded state, the century-old memories of her first contract with Mephistopheles run through her head. In these memories are answers Marion is beginning to understand: what is the nature of his master's immortality, and how is her curse inextricably tied to the body of her demon? Faust, Marion, and Nico's immediate aim is to find Mephisto's right leg, a mission that becomes more urgent when evidence of a young girl using demonic power comes to light. To find the next piece of her precious demon, Johanna may even need to form a tenuous deal with Lorenzo...   01KG9VSZT7VT6T7EX16DX2HSEA 2.0 2023-12-14T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Frau Faust, Volume 2 Kore Yamazaki/Kodansha Ltd.   2017-11-14T08:00:00.000Z   0 0
PRD_2T1SCE5XE7QG CNT_0YM5DJ9DQ0EG Frau Faust CNT_18KTRZ7C48P0 CNT_18KTRZ7C48P0 2 1 1 Volume 1 []   Frau Faust, Volume 1   More than a century after an eccentric scholar made an infamous deal with a devil, the story of Faust has passed into legend. However, the true Faust is not the stuffy, professorial man known in fairy tales, but a charismatic, bespectacled woman named Johanna Faust, who happens to still be alive. Searching for pieces of her long-lost demon, Johanna passes through a provincial town, where she saves a young boy named Marion from a criminal's fate. In exchange, she asks a simple favor of Marion, but Marion soon finds himself intrigued by the peculiar Doctor Faust and joins her on her journey. Thus begins the strange and wonderful adventures of Frau Faust!   01KG9VDFV9JNEJBMD6YCX1HSRG 1.0 2023-12-14T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Frau Faust, Volume 1 Kore Yamazaki/Kodansha Ltd.   2017-09-26T04:00:00.000Z   0 0
PRD_3YGDXBA68AE0 CNT_29YCCC6RNFM0 Frau Faust CNT_18KTRZ7C48P0 CNT_18KTRZ7C48P0 2 1 1 Volume 5 []   Frau Faust, Volume 5   With the help of Marion and Nico the homunculus, Johanna reaches the great belfry where Mephistopheles' head is kept. Johanna is nearly finished with the century-long game she's played with her demonic companion, but with Johanna's body slowly shrinking away and the church stopping at nothing to prevent her unholy reunion, will she accomplish her goal before it's too late? FINAL VOLUME   01KGA3JZXEBZ4P8WPDWQ4EZ0MV 5.0 2018-10-16T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Frau Faust, Volume 5 Kore Yamazaki/Kodansha Ltd.   2018-11-06T08: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);