products

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

4 rows where series_id = "CNT_2QB6RJ54E840"

✎ 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_0228CX0CRZV0 CNT_3DATEPWMZSBG ASHIDAKA - The Iron Hero CNT_2QB6RJ54E840 CNT_2QB6RJ54E840 2 1 1 Volume 3 []   ASHIDAKA - The Iron Hero 3   While searching for a mechanic that can modify and enhance their Arms, Ashidaka and his friends encounter Tsuchi, a mechanic with a deep-seated grudge for "multi-arms." Having sworn not to hurt others, Ashidaka is seriously hurt by Tsuchi's assault...but then takes surprising measures to help them become teammates! Meanwhile, the rest of the team is polishing their battle skills as they await Ashidaka's return...as a new, and overwhelmingly powerful, centipede attacks!   01KG9FP4K151BWVCB8TEPTP40P 3.0 2021-06-23T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG ASHIDAKA - The Iron Hero 3 ASHIDAKA -The Iron Hero - Ryo Sumiyoshi/Kodansha Ltd.   2021-07-13T07:00:00.000Z   0 0
PRD_0DAFXVWM0D90 CNT_18QWP99SNHZ0 ASHIDAKA - The Iron Hero CNT_2QB6RJ54E840 CNT_2QB6RJ54E840 2 1 1 Volume 2 []   ASHIDAKA - The Iron Hero 2   The Demon Dismantling Army has been formed to defeat the "centipede," the colossal monster with a hundred pairs of lethal metal arms—and after clashing with them, Ashidaka's nearly lost his life! But after his own Arms are rebuilt at astonishing speed, Ashidaka loses his mind and goes on a berserk rampage...and when he finally wakes up, it's just in time for an attack from the "blue demon," a new centipede. He sets off with Dismantling Army assault expert Honchi to take it down, only to be amazed at what he sees on scene...   01KG9DYFA3159GP40Y4YXWDA4Y 2.0 2021-01-27T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG ASHIDAKA - The Iron Hero 2 ASHIDAKA -The Iron Hero - Ryo Sumiyoshi/Kodansha Ltd.   2021-02-09T08:00:00.000Z   0 0
PRD_2574NXAGEY8G CNT_2490K343W3B0 ASHIDAKA - The Iron Hero CNT_2QB6RJ54E840 CNT_2QB6RJ54E840 2 1 1 Volume 1 []   ASHIDAKA - The Iron Hero 1   In a world where everyone bears metal arms, a demon bearing a hundred pairs of metal arms threatens total destruction on the world and everyone who lives within it. But even in the face of total hopelessness, a group of warriors is ready to tackle this desperate challenge! A boy named Ashidaka, with two pairs of metal arms of his own, gathers his companions for the sacred war to come...   01KG9CB92Y6ZHPT7TBWACAT0K8 1.0 2020-08-18T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG ASHIDAKA - The Iron Hero 1 ASHIDAKA -The Iron Hero - Ryo Sumiyoshi/Kodansha Ltd.   2020-08-25T07:00:00.000Z   0 0
PRD_3EPFA7E39MS0 CNT_217R4931R8T0 ASHIDAKA - The Iron Hero CNT_2QB6RJ54E840 CNT_2QB6RJ54E840 2 1 1 Volume 4 []   ASHIDAKA - The Iron Hero 4   Between a new centipede and an unexpected attack from former Eight Legions member Yaksha, the Dismantling Army has its hands full healing Geji and repairing their base. Meanwhile, Hakutai discovers that the remaining centipedes are on the move--in order to birth an army of new clones! If they spawn, the world is doomed...and to stop them, Ashidaka and his allies take up the Legions' old Arms and set off for the final battle!   01KGADADMAVYFQ72T4KRP41Y9T 4.0 2022-01-07T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Ashidaka 4 ASHIDAKA -The Iron Hero - Ryo Sumiyoshi/Kodansha Ltd.   2022-02-01T08: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);