products

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

3 rows where series_id = "CNT_2DCEZZ7W4530"

✎ 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_0KNVK66M7FJ0 CNT_3XC8CAPGP9HG COUNTDOWN 7 DAYS CNT_2DCEZZ7W4530 CNT_2DCEZZ7W4530 2 1 1 Volume 2 []   COUNTDOWN 7 DAYS Vol. 2   Finding himself at the Sheol School for the Afterlife, Onigawara isn't really wanting to learn about being dead...he wants to collect on the deal he made with teacher Mitamura. Complete the set task within seven days and get his life back. The clock is ticking but there is one thing Onigawara is as yet unaware of. Once you're dead, you stay that way. Will Mitamura's machinations come to light, or does he know something no one else does? One thing is for certain, if things can go wrong, they will.   01K5GABV95P8ST3G889M5VTZ0B 2.0 2015-04-07T15:00:00.000Z DMP LAB_1CTNJZHP92M0 GEO_1PQM5BDYSMG0 COUNTDOWN 7 DAYS Vol. 2 (C) Kemuri Karakara. English language translation rights reserved by Digital Manga, Inc.   2015-04-07T15:00:00.000Z   0 0
PRD_31KSSTF3Q2E0 CNT_3R24DHZF2DNG COUNTDOWN 7 DAYS CNT_2DCEZZ7W4530 CNT_2DCEZZ7W4530 2 1 1 Volume 1 []   COUNTDOWN 7 DAYS Vol. 1   Lonely Mitamura may be a teacher at the exclusive Sheol Soul School ? an academy dedicated to the afterlife ? but he has a lot to learn about human emotions and helping others. In fact, his star pupil Tsuru thinks she’ll teach him a little lesson by running off during a field trip in the living world. Now, Mitamura has only seven days to track Tsuru down with the help of a brand-new (deceased) sidekick. Will the clock run out before they find her?   01K5G79KSXR62T2AYSV81ZAKMT 1.0 2015-04-07T15:00:00.000Z DMP LAB_1CTNJZHP92M0 GEO_1PQM5BDYSMG0 COUNTDOWN 7 DAYS Vol. 1 (C) Kemuri Karakara. English language translation rights reserved by Digital Manga, Inc.   2015-04-07T15:00:00.000Z   0 0
PRD_3408BD95K1D0 CNT_1VCHD3NQHCPG COUNTDOWN 7 DAYS CNT_2DCEZZ7W4530 CNT_2DCEZZ7W4530 2 1 1 Volume 3 []   COUNTDOWN 7 DAYS Vol. 3   Hanasuke and Mitamura are playing a cat-and-mouse game with Karasuma…but have they finally become trusting partners and friends? When a surprising blunder suddenly fixes the link between Sheol and the living world, the fates of many hang in the balance. But will the vicious cycle of life and death spin on and on no matter what? Countdown 7 Days fuses action and delirious drama in a twisted landscape where one opened gate can spell the end of everything! It’s hard to know who’s got your back when chaos erupts around each and every corner. Will the feistiest of fighters find a way to secure a peaceful existence?   01K5GAC7VEPEDT114SCVH0TDV7 3.0 2015-04-07T15:00:00.000Z DMP LAB_1CTNJZHP92M0 GEO_1PQM5BDYSMG0 COUNTDOWN 7 DAYS Vol. 3 (C) Kemuri Karakara. English language translation rights reserved by Digital Manga, Inc.   2015-04-07T15: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);