products

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

4 rows where series_id = "CNT_0MHH6YPRDJF0"

✎ 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_14PF8RFTMMEG CNT_306X1APE3E7G Absolute Duo CNT_0MHH6YPRDJF0 CNT_0MHH6YPRDJF0 2 1 1 Volume 1 []   Absolute Duo Vol. 1   At Koryo Academy, students battle with weapons forged from their souls. Kokonoe Tor, however, is an Irregular. He doesn't have a weapon--he has a shield! To gain the strength he seeks--and thus unravel the truth of his tragic past--he must form a Duo with another student. But first, he has to figure out how to share a room with a girl, the graceful fighter Julie Sigtuna, and not die of total awkwardness. BLAZING SHIELD 01KG98PDGDVBFWSJ56WF9K5FKZ 1.0 2017-08-29T04:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Absolute Duo Vol. 1 (C) Shinichirou Nariie 2013 (C) Takumi Hiiragiboshi 2013   2017-08-29T04:00:00.000Z   0 0
PRD_1KMQ65MYBJTG CNT_0B8T8CZ81ST0 Absolute Duo CNT_0MHH6YPRDJF0 CNT_0MHH6YPRDJF0 2 1 1 Volume 2 []   Absolute Duo Vol. 2   The students of Koryo Academy have only just formed their Duos--including Tor and silver-haired Julie--but the first fight with their Blazes is already swiftly approaching. Tor and Julie are at the top of their game, but their friend Miyabi still has a long way to go. Will she be ready by the time the battle begins? BATTLE READY 01KGA199RW5VY3ASP02V4PPY5J 2.0 2017-12-19T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Absolute Duo Vol. 2 (C) Shinichirou Nariie 2014 (C) Takumi Hiiragiboshi 2014   2017-12-26T08:00:00.000Z   0 0
PRD_35ED4PCPT82G CNT_3PMJHSAYZ45G Absolute Duo CNT_0MHH6YPRDJF0 CNT_0MHH6YPRDJF0 2 1 1 Volume 3 []   Absolute Duo Vol. 3   Tor has learned the dark secret of Koryo Academy: the Blaze weapons, formed from the students' very souls, can be used to kill. Does Tor, an Irregular whose Blaze manifests as a protective shield, have what it takes to end lives? Moreover, will he stay loyal to his partner Julie when another beautiful blonde shows up to try and steal him away? The gorgeous Lilith Bristol has arrived from England and she only has one goal: Take Tor as her partner, however she can. DEADLY COMBAT 01KGA36HAJFT99ZNFJ39RHZJEF 3.0 2018-02-28T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Absolute Duo Vol. 3 (C) Shinichirou Nariie 2015 (C) Takumi Hiiragiboshi 2015   2018-04-03T07:00:00.000Z   0 0
PRD_389TGM39JE40 CNT_0S5X9JMC2KE0 Absolute Duo CNT_0MHH6YPRDJF0 CNT_0MHH6YPRDJF0 2 1 1 Volume 4 []   Absolute Duo Vol. 4   The Koryo Academy's island branch campus is an ideal place for some extra training--and for its ladies to show their stuff in swimsuits. Things are looking up for Tor. He may have to put up with the ongoing efforts of Lilith to seduce him away from?his Duo partner, but the island is a place to unwind and meet old friends. Unfortunately, all that is not to last: a mysterious enemy is preparing to make a move against the Academy! SEASIDE SUMMER CAMP! 01KGA3KK731T3YKC7AXAPJM9PK 4.0 2018-10-29T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Absolute Duo Vol. 4 Shinichirou Nariie 2017, Takumi Hiiragiboshi 2017   2018-11-27T08: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);