products

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

3 rows where series_id = "CNT_0A1HWDHKS620"

✎ 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_1R7PAA0J15RG CNT_2SR3JKST3ZT0 MAIL CNT_0A1HWDHKS620 CNT_0A1HWDHKS620 2 1 1 Volume 3 []   MAIL Volume 3   Private detective Reiji Akiba has a theory about those awkward moments and weird coincidences we all encounter in life. They are actually encounters with the dead-their way of sending us a message. But you may not want to open such strange mail from beyond-not unless you can see the ghostly attachment, like Akiba can. And not unless you carry a tool that can kill what isn't alive, like Akiba's sanctified gun Kagutsuchi . . . digging a divine grave to lay to rest the evil dead! Volume Three opens with Detective Akiba taking a trip down memory lane, to his childhood, when as a young blind boy, he befriended a little girl in the woods near his house. In ""Un-notifying,"" Detective Akiba must help a young woman terrorized by the ghost of a lonely girl whose lifeline to the world of the living is an old cell phone.   01K5GACH0HV2V86548YR7TCBRN 3.0 2015-04-11T15:00:00.000Z Dark Horse Comics LAB_1964HD7DQ34G GEO_1PQM5BDYSMG0 MAIL Volume 3 (C) Housui YAMAZAKI (YEAR) First published in Japan in (YEAR*) by KADOKAWA SHOTEN Publishing Co., Ltd., Tokyo. English translation rights arranged with KADOKAWA SHOTEN Publishing Co., Ltd., Tokyo, Through TOHAN CORPORATION, Tokyo.* volume 1-2 2004, volume 3 2005.   2015-04-11T15:00:00.000Z   0 0
PRD_1WM6NX2MD4ZG CNT_0S2GJXE2EYV0 MAIL CNT_0A1HWDHKS620 CNT_0A1HWDHKS620 2 1 1 Volume 2 []   MAIL Volume 2   In Volume Two, detective Akiba comes to the aid of a terrorized man who is being stalked by what appears to be a possessed doll. But possessed by whom? Does the ""victim"" know more than he is letting on? Akiba's job is never done, however, as his travels introduce him to a tormented young bride whose new husband has a mysterious past; a woman trapped in a haunted elevator; the lone survivor of a landslide whose not-so-lucky friends are trying to lure her to the afterlife; and more tales of ghostly terror by up-and-coming creator Housui Yamazaki!   01K5GACG6ESWY3A9FQRMHPMW6Q 2.0 2015-04-11T15:00:00.000Z Dark Horse Comics LAB_1964HD7DQ34G GEO_1PQM5BDYSMG0 MAIL Volume 2 (C) Housui YAMAZAKI (YEAR) First published in Japan in (YEAR*) by KADOKAWA SHOTEN Publishing Co., Ltd., Tokyo. English translation rights arranged with KADOKAWA SHOTEN Publishing Co., Ltd., Tokyo, Through TOHAN CORPORATION, Tokyo.* volume 1-2 2004, volume 3 2005.   2015-04-11T15:00:00.000Z   0 0
PRD_3GVCMVT0V7B0 CNT_17E30DJ50J8G MAIL CNT_0A1HWDHKS620 CNT_0A1HWDHKS620 2 1 1 Volume 1 []   MAIL Volume 1   Private detective Reiji Akiba has a theory about those awkward moments and weird coincidences we all encounter in life. They are actually encounters with the dead-their way of sending us a message. But you may not want to open such strange mail from beyond-not unless you can see the ghostly attachment, like Akiba can. And not unless you carry a gun that can kill what isn't alive, like Akiba's aptly named Kagutsuchi, ""the tool between God and earth"" . . . digging a divine grave to lay to rest the evil dead. Volume 1 of Mail opens with a model's photo shoot at what was a lovely riverside. But someone's thrown their trash away here: human bones. When the negatives in the darkroom reveal hidden horror, it's time for the magazine to hire Akiba. The answers lie in the secret basement of a shunned house . . . but they don't lie peacefully!   01K5G79NZ44P5PJ5HWJDQCQT1X 1.0 2015-04-11T15:00:00.000Z Dark Horse Comics LAB_1964HD7DQ34G GEO_1PQM5BDYSMG0 MAIL Volume 1 (C) Housui YAMAZAKI (YEAR) First published in Japan in (YEAR*) by KADOKAWA SHOTEN Publishing Co., Ltd., Tokyo. English translation rights arranged with KADOKAWA SHOTEN Publishing Co., Ltd., Tokyo, Through TOHAN CORPORATION, Tokyo.* volume 1-2 2004, volume 3 2005.   2015-04-11T15: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);