products

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

3 rows where series_id = "CNT_3HZ155222QR0"

✎ 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_0S70XNZQN7CG CNT_09AF3G3HQCPG The Reprise of the Spear Hero CNT_3HZ155222QR0 CNT_3HZ155222QR0 2 2 1 Volume 1 []   The Reprise of the Spear Hero Volume 1   Summoned to another world to serve as the Spear Hero, Motoyasu Kitamura is a pitiful young man who eventually finds himself only able to love filolials. But after being fatally injured in battle, Motoyasu wakes up yet again in the exact circumstances of when he was first summoned. It turns out that his spear possesses an ability known as Time Reversal! With his stats unaffected by the reset, Motoyasu decides to fight once more. His motivation: to once again see the smile of Filo, the filolial that he loves more than any other! Could this be considered the start of a new game in god mode?! The long-awaited otherworldly redemption fantasy begins!   01KGA3RY3C29583PKYHMBQZCZJ 1.0 2018-10-22T15:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 The Reprise of the Spear Hero Volume 1 (c)Aneko Yusagi 2017   2018-10-25T07:00:00.000Z   0 0
PRD_13HK0FX60H9G CNT_1HRMMYYNK6A0 The Reprise of the Spear Hero CNT_3HZ155222QR0 CNT_3HZ155222QR0 2 2 1 Volume 2 []   The Reprise of the Spear Hero Volume 2   Having obtained the ability Time Reversal, the Spear Hero Motoyasu Kitamura uses his power to change the past in his quest for world peace and to fulfill the wishes of his beloved Filo. In order to achieve his goal, he must protect the life of Naofumi Iwatani, whose safety is one of the conditions of the time loop. Under the belief that Naofumi's life is in danger in Melromarc, Motoyasu and Naofumi travel to Siltvelt. But even in Siltvelt, what disasters will befall them? Though Motoyasu finds Naofumi's plan to overcome their treacherous circumstances unbearable, he still proclaims: "I, Motoyasu Kitamura, shall guarantee victory no matter the odds!" Let the second chapter of this epic redemption fantasy begin!   01KG9CAR4JD6RH9XMGPH8R5WB3 2.0 2020-07-29T07:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 The Reprise of the Spear Hero Volume 2 (c)Aneko Yusagi 2017   2020-09-29T07:00:00.000Z   0 0
PRD_1M3P2Y1Y8H6G CNT_0MTM9DEQTNJG The Reprise of the Spear Hero CNT_3HZ155222QR0 CNT_3HZ155222QR0 2 2 1 Volume 3 []   The Reprise of the Spear Hero Volume 3   Back to the beginning all over again. Can our heroes finally create a better future? Armed with the ability to turn back time, Motoyasu Kitamura has reset the time loop again and again as he gropes around blindly for a way to meet his beloved Filo. Along the way, the waves of destruction hit Melromarc, and history repeats itself. The Bow Hero, Itsuki, is tricked by the king into a duel with Naofumi! Motoyasu declares, "Well, there isn't any problem with me fighting Itsuki as Father's representative, is there, now?" In a world that keeps getting reset, will the effects of changing roles finally become clear? The much anticipated third installment of this otherworldly fantasy adventure begins now!   01KG9DYY9VASBJ7RTVB0954R2E 3.0 2021-01-28T08:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 The Reprise of the Spear Hero Volume 3     2021-02-09T08: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);