products

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

3 rows where series_id = "CNT_11S4GJBDNP9G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, 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_04BWWAK5CE60 CNT_3DPJA9S16KC0 Die Wergelder CNT_11S4GJBDNP9G CNT_11S4GJBDNP9G 2 1 1 Volume 2 []   Die Wergelder 2   A mysterious murder takes place in a shopping arcade in China, while in Japan a yakuza gang discovers a large amount of money is missing. These volatile ingredients will combine to set off an explosion of violence on a remote island, that will eventually grow to consume more and more lives across the world!   01KGA5GVEF8T1TVR68JERM0N0K 2.0 2018-11-20T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Die Wergelder 2 (C) Hiroaki Samura / Kodansha Ltd.   2018-12-18T08:00:00.000Z   0 0
PRD_124W90VFHGCG CNT_0TEX0BVPQ3QG Die Wergelder CNT_11S4GJBDNP9G CNT_11S4GJBDNP9G 2 1 1 Volume 1 []   Die Wergelder 1   Wergelder: In Germanic law, the money paid by a murderer or his family to the victim's family in atonement. A mysterious deal goes down on a remote island known as a red light pleasure district. An insane fight between a blonde sniper and an assassin in a Chinese dress brings up questions about who the players are in this deal.   01KG935TW8VJXJ2S21QW029FCV 1.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Die Wergelder 1 (C) Hiroaki Samura / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_2ZN2HDVTSK00 CNT_2RJ7VT66EZ40 Die Wergelder CNT_11S4GJBDNP9G CNT_11S4GJBDNP9G 2 1 1 Volume 3 []   Die Wergelder 3   OLD GHOSTS COME TO CALL Wergelder: In Germanic law, the money paid by a murderer or his family to the victim's family in atonement. Reeling from a roller coaster of revelations, Shinobu and her ragtag band of allies must contend with capable foes determined to keep them silent, while Jie Mao pulls on a thread that may lead her to more than just the truth she seeks. The gross underbelly of the Hill-Myna Corporation continues to be pulled into the light, and with it a forgotten face from Nami's past!   01KGB2EKEHATVYS7J8VA855WY7 3.0 2022-12-13T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Die Wergelder 3 Hiroaki Samura/Kodansha Ltd.   2022-12-13T08: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);