products

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

4 rows where series_id = "CNT_1GC67S9R8CX0"

✎ 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_0BGF20661P40 CNT_30SYATMJ21FG Scarlet Empire CNT_1GC67S9R8CX0 CNT_1GC67S9R8CX0 2 1 1 Volume 1 []   Scarlet Empire, Vol. 1   Kotetsu Miyasaka is a kendo prodigy. While his twin brother, Yayoi, practices the sport, though, he lacks his sibling's skill, enrolling in a different school to try and differentiate himself. When things go wrong at Yayoi's new school, though, Kotetsu finds himself caught up in a potentially life-or-death confrontation -- only to suddenly find himself swept back to Edo period Japan where the stakes are infinitely higher! Taking in by Souzou Sagara and his roshi band of samurai, Kotetsu must find a way to survive in the past and possibly help shape Japan's future!   01KG94JYWG3G97DPMPGKTZ4H3G 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Scarlet Empire, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_2CE66XKDBNTG CNT_23S1TD5YPFR0 Scarlet Empire CNT_1GC67S9R8CX0 CNT_1GC67S9R8CX0 2 1 1 Volume 2 []   Scarlet Empire, Vol. 2   Kotetsu and the rest of the Satsuma roshi band set out to protect the life of Lord Sakamoto who has been targeted for assassination. Turns out, though, that this isn't the easiest guy to defend! Can Sagara and his men stand against the bloodthirsty Shinsengumi and carve out a more just future for Japan...?   01KG95HJ7D47RZ8MACZ9STS79J 2.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Scarlet Empire, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_2MQ7CR5HXTQ0 CNT_1R0QH8FZDMWG Scarlet Empire CNT_1GC67S9R8CX0 CNT_1GC67S9R8CX0 2 1 1 Volume 3 []   Scarlet Empire, Vol. 3   Sakamoto has been successfully scooped off the streets of Kyoto to the safety of the Satsuma mansion once again. But even under constant guard, the Hero of Japan--and his amorous inclinations--cannot be contained! Despite the dangers, Sakamoto ventures out again, heedless of the mounting threat against him--or the trouble he's making for his guard, Kotetsu!   01KG95GR60JVTQRAEGB1MQGZCW 3.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Scarlet Empire, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_31Y96HH8WV7G CNT_1ERHQSB86630 Scarlet Empire CNT_1GC67S9R8CX0 CNT_1GC67S9R8CX0 2 1 1 Volume 4 []   Scarlet Empire, Vol. 4   Despite his hopeful ideals for the future of the empire, Sagara remains troubled by his past. With Kotetsu's support, the two visit the home of one of Sagara's former students, Seitarou, hoping to learn what became of him and what may be driving the vengeful Shikyou Kawase to pursue the roshi band. It turns out both Sagara and Kotetsu have a history with Seitarou Miyasaka! Meanwhile, the Satsuma clan takes advantage of Sagara's absence to launch a violent assault, undermining all of the roshi captain's careful diplomatic plans. When the flames are extinguished and the ash settles, the Sagara's fire seems to go out with it. Perhaps through Kotetsu, Sagara can glimpse the future Japan and regain his hopeful outlook, even as his own path darkens...   01K5G9XTMQMBFJ3YP4BESBHW01 4.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Scarlet Empire, Vol. 4     2016-06-30T15: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);