products

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

5 rows where series_id = "CNT_0WWPHGJSDF1G"

✎ 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_0809SWVH3YNG CNT_0EWSG4G93V00 Desert Eagle CNT_0WWPHGJSDF1G CNT_0WWPHGJSDF1G 2 1 1 Volume 3 []   Desert Eagle 3   Assault, robbery, arson, murder... In the dark neighborhood of Shinjuku, there's an outlaw security firm that protects the people the law can't help out. From nightclub security to guarding restaurants and keeping VIPs safe, it provides everything a red-light district needs to survive. And when Ichigo encounters its president Kuromitsu Shishigami, it changes his entire life!   01KGAJH7A2WMDC8G21F66AHYFQ 3.0 2022-08-18T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Desert Eagle 3 Desert Eagle Ken Wakui/Kodansha Ltd.   2022-09-06T07:00:00.000Z   0 0
PRD_0A795P188STG CNT_3RJ2B3TVFBJ0 Desert Eagle CNT_0WWPHGJSDF1G CNT_0WWPHGJSDF1G 2 1 1 Volume 1 []   Desert Eagle 1   Ichigo Washio is a young man with a bright future—a bright future, that is, within the gangs of Shinjuku. When he meets Ringo Takamizawa, a fellow student hell-bent on revenge on those who took everything from his mother, the gregarious Ichigo doesn't think twice about helping Ringo—even when it means it'll pit Ichigo against men he's looked up to his whole life. But Ichigo knows he's in the right, and with his new friends and a healthy dose of stupidity to guide him, he's ready to return justice to Shinjuku's streets! From the author of Tokyo Revengers!   01KGAH16SXX3XJ9MTWVRHH75BV 1.0 2022-06-17T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Desert Eagle 1 Desert Eagle Ken Wakui/Kodansha Ltd.   2022-07-05T07:00:00.000Z   0 0
PRD_18F9VFK0D000 CNT_2PJMS68PSK5G Desert Eagle CNT_0WWPHGJSDF1G CNT_0WWPHGJSDF1G 2 1 1 Volume 2 []   Desert Eagle 2   The Kabukicho neighborhood of Shinjuku, Tokyo is a chaotic mixture of everything at once—beauty, ugliness, justice, and injustice. Into this town was born a child with just one dream—to protect his friends Ringo and Sakura. Whether it's the Kaburagi gang, the Ten'Ichi Union, or the mysterious Grimm, Ichigo Washio is ready to struggle among all these evil giants to win a future for himself!   01KGAJ77X9FG2JZKFWPM95H3CY 2.0 2022-07-21T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Desert Eagle 2 Desert Eagle Ken Wakui/Kodansha Ltd.   2022-08-02T07:00:00.000Z   0 0
PRD_27T8YBB5R4F0 CNT_0W2ANJW3ZGD0 Desert Eagle CNT_0WWPHGJSDF1G CNT_0WWPHGJSDF1G 2 1 1 Volume 5 []   Desert Eagle 5   A shadowy organization looms large over the Kabukicho neighborhood-a red-light district Ten Kunimiya's attempting to seize for himself! With the previous balance between the area's underground gangs demolished, only one man can stop him now. Reunited with his friend Apple, Ichigo Washio-once all alone in the world-now has a small army on his side as he prepares for the final confrontation!   01KGB2FB9G3179T90R2T3Q5SKW 5.0 2022-11-10T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Desert Eagle 5 Ken Wakui/Kodansha Ltd.   2022-11-29T08:00:00.000Z   0 0
PRD_3YE542AC2GV0 CNT_1SGNCWQ89D3G Desert Eagle CNT_0WWPHGJSDF1G CNT_0WWPHGJSDF1G 2 1 1 Volume 4 []   Desert Eagle 4   Ichigo's taken on an under-the-table bodyguard job for a woman who's about to default on a huge amount of money! Through all his trials and tribulations at the "illegal" security firm Li-On, he's learned a thing or two about what it means to protect someone...but the Ten'ichi Union is about to hatch a conspiracy that could rock not only Shinjuku, but all of Japan!   01KGB2078R8PD9ZXBVJW8G5KWW 4.0 2022-09-22T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Desert Eagle 4 Desert Eagle Ken Wakui/Kodansha Ltd.   2022-10-04T07: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);