products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
6 rows where series_id = "CNT_0CHB1EXTW2NG"
This data as json, CSV (advanced)
Suggested facets: 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_05KK45YE6CQG | CNT_153DDWA0H0KG | Demon from Afar CNT_0CHB1EXTW2NG | CNT_0CHB1EXTW2NG | 2 | 1 | 1 | Volume 4 | [] | Demon from Afar, Vol. 4 | A hidden identity is laid bare in Volume 4 of this black magic fantasy! On the trail of a great evil, Sorath happens upon the completion ceremony of the Ziggurat, a giant broadcasting tower. There, a chess match of ominous proportions is being played out by humans manipulated like pawns by the lies of a demon. And to his great shock, Sorath encounters someone whom he never expected to see again amid this game ...someone he thought had died by his own hand...?! The evil spirits of the Imperial Capital appear before Sorath once more!! | 01KGA6AVQ7EDWDQ3KBSWGQC4ZD | 4.0 | 2019-01-29T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Demon from Afar, Vol. 4 | 2019-01-29T08:00:00.000Z | 0 | 0 | ||||||
| PRD_06X0TJWBTDGG | CNT_35RGDJNR21JG | Demon from Afar CNT_0CHB1EXTW2NG | CNT_0CHB1EXTW2NG | 2 | 1 | 1 | Volume 6 | [] | Demon from Afar, Vol. 6 | At long last.........the final showdown is nigh...... When he realizes that his erstwhile friend has become warped enough to use his own daughter as a pawn to further his own aims, Sorath resolves to fight Garan. From Kiyora, the tortured living sacrifice of the great Lord of Terror's seal to the traitorous Leice to the imprisoned Nonoha--many fates hang in the balance as a century of resentment and intrigue comes to a head in the climactic battle at the Ziggurat, the gateway to the netherworld! The black-magic fantasy peaks with explosive intensity in its final volume! | 01KGA6AZ2B3VDRWAE8ABYP863K | 6.0 | 2019-01-29T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Demon from Afar, Vol. 6 | 2019-01-29T08:00:00.000Z | 0 | 0 | ||||||
| PRD_0GMRNN5YMAVG | CNT_2K6J02HW7YZG | Demon from Afar CNT_0CHB1EXTW2NG | CNT_0CHB1EXTW2NG | 2 | 1 | 1 | Volume 1 | [] | Demon from Afar, Vol. 1 | Pinky swear-- An imperial capital in an era of splendor and romanticism... Orphaned in an earthquake, Sorath is taken in by Baron Kamichika, the lord of "Blood Blossom Manor." There, he pledges eternal friendship with Garan, the Baron's heir, and Kiyora, Garan's fiancée. But their friendship turns grisly by events none of them could foresee. The tender feelings each secretly harbors, the machinations of Baron Kamichika, and his strange and seductive female companion, and a fateful encounter with a young girl with bizarre powers...all draw them to the Walpurgis Night and the nightmare's climax! | 01KG9AWKFW44TW5PHWD2MHFJXF | 1.0 | 2018-12-18T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Demon from Afar, Vol. 1 | 2018-12-18T08:00:00.000Z | 0 | 0 | ||||||
| PRD_27A8KVF8RC00 | CNT_05DPXVGW8H20 | Demon from Afar CNT_0CHB1EXTW2NG | CNT_0CHB1EXTW2NG | 2 | 1 | 1 | Volume 5 | [] | Demon from Afar, Vol. 5 | Backed into a corner with no way out, Sorath glimpses a fleeting glimmer of hope. But what does it hold for him......? At the Ziggurat, the giant broadcasting tower everyone has been talking about, Etsurou's true identity is revealed as......Garan?! Sorath is stunned by the reappearance of the best friend he thought he had killed...and by the traps Garan proceeds to set for him!! What will Sorath do when Garan's machinations break up his team?! | 01KGA6AXEMDJRVRM55KHDM6FNE | 5.0 | 2019-01-29T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Demon from Afar, Vol. 5 | 2019-01-29T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2JFG3CTSPA40 | CNT_1KHVGSPR1FE0 | Demon from Afar CNT_0CHB1EXTW2NG | CNT_0CHB1EXTW2NG | 2 | 1 | 1 | Volume 2 | [] | Demon from Afar, Vol. 2 | From the ultimate nightmare that is Walpurgis Night, Sorath escapes to modern Japan. There, he lives in an unconventional household that includes Nonoha, the daughter of his dearest friend, and Mephistopheles, the Duke of Hell, who bides his time for a chance to kill his master. This time, these hands will protect my loved ones-- That's Sorath's wish, but somehow Nonoha is slipping through his fingers. Will Sorath's hands once again be stained by the blood of the person he cherishes most? | 01KGA687WBZD3G89FMEES3SHEX | 2.0 | 2018-12-18T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Demon from Afar, Vol. 2 | 2018-12-18T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3C68A2BM8BMG | CNT_0KW50GVKRZYG | Demon from Afar CNT_0CHB1EXTW2NG | CNT_0CHB1EXTW2NG | 2 | 1 | 1 | Volume 3 | [] | Demon from Afar, Vol. 3 | I never want to feel that sadness again--! With Nonoha spirited away by demons, Sorath infiltrates their territory only to find himself bearing witness to a horrific public execution dubbed the "Divine Judgment." Surrounded by countless sacrifices, reeling from Leice's betrayal, and faced with his beloved Nonoha having been taken hostage, Sorath's memory is rekindled, and the night when he lost his dearest friend comes rushing back to him. Will Sorath clash once more with the fearsome being who preys on human lives, the Lord of Terror?! | 01KGA689H2F7R5MP61K63CGA5C | 3.0 | 2018-12-18T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Demon from Afar, Vol. 3 | 2018-12-18T08:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);