products

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

6 rows where series_id = "CNT_17KSVMGPDGQG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, listed_at, on_sale_at, 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_01WM7T0TA5SG CNT_3EBH7YD38ZM0 Laughing Under the Clouds CNT_17KSVMGPDGQG CNT_17KSVMGPDGQG 2 1 1 Volume 3 []   Laughing Under the Clouds, Volume 3   Soramaru's quest to grow stronger brings him to the leader of the Yamainu, Abe no Sousei.  Sousei proposes a trade: training in exchange for information.  In search of the information required, Soramaru disguises himself and — with the help of youngest brother Chutaro — infiltrates the very prison he's taken so many criminals to: Gokumonjo.  But nothing is ever as easy as it seems, and although Soramaru finds the information he needs to make a deal, eldest Kumo brother Tenka suddenly finds himself under arrest and in dire straits...   01KG9FFZJF26HGH28HYHZFBHZ4 3.0 2021-05-20T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Laughing Under the Clouds, Volume 3 ｺﾋﾟｰﾗｲﾄなし   2021-05-20T07:00:00.000Z   0 0
PRD_034B0CPDJDG0 CNT_2S57M42NDGRG Laughing Under the Clouds CNT_17KSVMGPDGQG CNT_17KSVMGPDGQG 2 1 1 Volume 6 []   Laughing Under the Clouds, Volume 6   Under the curse of Orochi, the great demon serpent reborn every 300 years, Japan has been shrouded in clouds for as long as anyone can remember... The era of the samurai is at an end, and carrying swords has been outlawed. To combat the rising crime rates, an inescapable prison was built in the middle of Lake Biwa. When brothers Tenka, Soramaru and Chutaro Kumo are hired to capture and transport offenders to their final lodgings in this prison, they unexpectedly find themselves faced with a greater destiny than any of them could have imagined.   01KG9H18AWM0PP3FJ65ATCRCE3 6.0 2021-09-15T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Laughing Under the Clouds, Volume 6 ｺﾋﾟｰﾗｲﾄなし   2021-09-29T07:00:00.000Z   0 0
PRD_1T5HTH05X2S0 CNT_12GXETQQCCNG Laughing Under the Clouds CNT_17KSVMGPDGQG CNT_17KSVMGPDGQG 2 1 1 Volume 1 []   Laughing Under the Clouds, Volume 1   Under the curse of Orochi, the great demon serpent reborn every 300 years, Japan has been shrouded in clouds for as long as anyone can remember... The era of the samurai is at an end, and carrying swords has been outlawed. To combat the rising crime rates, an inescapable prison was built in the middle of Lake Biwa. When brothers Tenka, Soramaru and Chutaro Kumo are hired to capture and transport offenders to their final lodgings in this prison, they unexpectedly find themselves faced with a greater destiny than any of them could have imagined.   01KG9E55GXZ7TNN5FSQ3MNBYB8 1.0 2021-03-23T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Laughing Under the Clouds, Volume 1     2021-03-26T07:00:00.000Z   0 0
PRD_20KQAXCKSSYG CNT_17ZNMKJCZD10 Laughing Under the Clouds CNT_17KSVMGPDGQG CNT_17KSVMGPDGQG 2 1 1 Volume 5 []   Laughing Under the Clouds, Volume 5   In the early Meiji era, against civil unrest and the end of the samurai way of life, Japan's crime rate skyrocketed. As prisons overflow, the government has no choice but to build a new, inescapable prison. This prison is Gokumonjo, located in the center of Lake Biwa, which means it relies on the three sons of the Kumo family to transport criminals to it. But is Gokumonjo truly just a prison for petty criminals...?   01KG9GTAQWG89FW6TJERXDK454 5.0 2021-08-27T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Laughing Under the Clouds, Volume 5 ｺﾋﾟｰﾗｲﾄなし   2021-09-07T07:00:00.000Z   0 0
PRD_2Z6X3YQK06B0 CNT_0FCDMBXPMGVG Laughing Under the Clouds CNT_17KSVMGPDGQG CNT_17KSVMGPDGQG 2 1 1 Volume 2 []   Laughing Under the Clouds, Volume 2   In the early Meiji era, against civil unrest and the end of the samurai way of life, Japan's crime rate skyrocketed. As prisons overflow, the government has no choice but to build a new, inescapable prison. This prison is Gokumonjo, located in the center of Lake Biwa, which means it relies on the three sons of the Kumo family to transport criminals to it. But is Gokumonjo truly just a prison for petty criminals? A dreaded murderer intrudes on the Kumo family's peace and brings with him news of an ancient calamity: Orochi. As Soramaru realizes his elder brother Tenka has been hiding things from him, he begins to look to outside sources to help him become stronger. At the same time, still other outside forces begin to reach out to Tenka for his knowledge of this ancient evil. The race to find and control Orochi's vessel begins!   01KG9FG22BS0CKP04DRN9V3PMZ 2.0 2021-05-20T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Laughing Under the Clouds, Volume 2 ｺﾋﾟｰﾗｲﾄなし   2021-05-20T07:00:00.000Z   0 0
PRD_3KNH7EGK0RR0 CNT_2SNZG4ZT0JPG Laughing Under the Clouds CNT_17KSVMGPDGQG CNT_17KSVMGPDGQG 2 1 1 Volume 4 []   Laughing Under the Clouds, Volume 4   In the early Meiji era, against civil unrest and the end of the samurai way of life, Japan's crime rate skyrocketed. As prisons overflow, the government has no choice but to build a new, inescapable prison. This prison is Gokumonjo, located in the center of Lake Biwa, which means it relies on the three sons of the Kumo family to transport criminals to it. But is Gokumonjo truly just a prison for petty criminals...?   01KG9FQEYJ2PHKPEP04VAT4785 4.0 2021-07-16T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 Laughing Under the Clouds, Volume 4     2021-07-27T07: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);