products

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

3 rows where series_id = "CNT_0JJPX4GADXDG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_0J4E9TSJBAKG CNT_3Q4VG2XBWY5G Goblin Slayer Side Story II: Dai Katana CNT_0JJPX4GADXDG CNT_0JJPX4GADXDG 2 2 1 Volume 1 []   Goblin Slayer Side Story II: Dai Katana, Vol. 1   Not so very long ago, the Death began stalking the continent. The King of Time issued aproclamation: “Find the source of this Death and seal it away.”The source: the Dungeon of the Dead. A fortress city that arose at the mouth of thedungeon serves adventurers who seek companions, challenge the dungeon, battle, find loot… and sometimes die.You are an adventurer who has come to the fortress city in hopes of reaching the dungeon’s lower– most depths—but can you and your party conquer the untold evils that lurk beneath the surface?   01KG9CFW83DFNMGX8QZJRKD7DS 1.0 2020-11-26T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 Goblin Slayer Side Story II: Dai Katana, Vol. 1     2020-12-15T08:00:00.000Z   0 0
PRD_1HVSKTGTKEBG CNT_2HM6YBJEY90G Goblin Slayer Side Story II: Dai Katana CNT_0JJPX4GADXDG CNT_0JJPX4GADXDG 2 2 1 Volume 3 []   Goblin Slayer Side Story II: Dai Katana, Vol. 3   From beyond the walls of the fortress city comes a flood of refugees. The shadow of the Death’s terror threatens to assault the landscape. Nonetheless, you and your party return to the Dungeon of the Dead to take care of some unfinished business. This is the beginning of the end; no more, no less. The climax is nearly here. Six heroes have assembled—the six who may save the world in this final installment of Goblin Slayer Side Story II: Dai Katana!   01KH3HK9C3RYXCS3YZ3G70Z5VM 3.0 2023-08-21T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1HQTK5SKDE9G Goblin Slayer Side Story II: Dai Katana, Vol. 3     2024-01-30T00:00:00.000Z   0 0
PRD_3592A06JGGEG CNT_00Q7APV8YB70 Goblin Slayer Side Story II: Dai Katana CNT_0JJPX4GADXDG CNT_0JJPX4GADXDG 2 2 1 Volume 2 []   Goblin Slayer Side Story II: Dai Katana, Vol. 2   The party has successfully made it past the initial dangers of the Dungeon of the Dead, but the struggle continues as they head deeper. Strange new monsters await our heroes, and that’s not all-a group of adventurers somehow connected to Bishop declares a dungeon?exploration contest, bringing the party face?to?face with the infamous dark zone… “We don’t have time to bother with the likes of goblins! Because I…we…are going to save the world!   01KG9E18P4GYRXQR5XHTXKTDWG 2.0 2021-05-26T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 Goblin Slayer Side Story II: Dai Katana, Vol. 2     2021-07-13T07: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);