products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_0AGA154FF6F0"
This data as json, CSV (advanced)
Suggested facets: listed_at, geoblock_id, 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_15Z9PH5100YG | CNT_3S2HB90MKJT0 | Tales of the Kingdom CNT_0AGA154FF6F0 | CNT_0AGA154FF6F0 | 2 | 1 | 1 | Volume 5 | [] | Tales of the Kingdom, Vol. 5 | The crown prince of Sharibalte walks the lonely halls of his vast palace, his mother’s sanity lost, his brother turned against him, and his father, the king, dead. Ascending to the throne at last, the bold new ruler, now known as the Moonlight King, launches a war of conquest against the neighboring countries. Drunk on his victories, he demands the seaside nation of Péan hand over their twelfth princess as his consort—only to discover his new bride is still but a young girl… | 01KGBAR98KNRVVDQ8XVTMQKF9P | 5.0 | 2024-06-05T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PKAG51AEAQG | Tales of the Kingdom, Vol. 5 | 2024-09-17T07:00:00.000Z | 0 | 0 | ||||||
| PRD_21JNKCKPQ400 | CNT_04F1MG431G40 | Tales of the Kingdom CNT_0AGA154FF6F0 | CNT_0AGA154FF6F0 | 2 | 1 | 1 | Volume 2 | [] | Tales of the Kingdom, Vol. 2 | Shao and Dao: twin brothers who face an uncertain future. One will be chosen to lead the clan, while the other’s family line will end. As the superior rider and archer, Shao seems the obvious choice, but when a terrible injury leaves him unable to do either, the elders’ decision becomes less straightforward. Far from wishing the worst for his brother, but fearful of facing that fate himself, Dao’s conflicted feelings lead him and Shao to forge a new path ahead—one that only one brother may tread... | 01KGB2QKN089WD4M7ZXM214HPF | 2.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Tales of the Kingdom, Vol. 2 | 2022-12-13T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2MJTXK5RNJ30 | CNT_1E8KX6W2BCR0 | Tales of the Kingdom CNT_0AGA154FF6F0 | CNT_0AGA154FF6F0 | 2 | 1 | 1 | Volume 4 | [] | Tales of the Kingdom, Vol. 4 | Two young men, one woman. Two princes, and only one throne. On the path to power, many sacrifices have been made, and more still will be required. How far are the brothers willing to go in pursuit of their deepest desires—and vengeance…? | 01KH3G8D26N1W5FJ0TEDZ601DR | 4.0 | 2023-08-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Tales of the Kingdom, Vol. 4 | 2024-02-20T00:00:00.000Z | 0 | 0 | ||||||
| PRD_37RW0MHQWEMG | CNT_2YM2Y9V160G0 | Tales of the Kingdom CNT_0AGA154FF6F0 | CNT_0AGA154FF6F0 | 2 | 1 | 1 | Volume 1 | [] | Tales of the Kingdom, Vol. 1 | Purple-eyed Adarte, blue-eyed Adolte. One enveloped in light—the graceful son—and one shrouded in darkness—the prisoner. Even as their souls are drawn together, destiny would tear them apart. Elsewhere in the kingdom, a heroic king is served by an enigmatic aide from a faraway land. His path has torn him from his dearest kin and placed him in the halls of power—to what end...? The first of Asumiko Nakamura’s beautifully wrought tales set in a fantastic kingdom of intrigue and heartache... | 01KGAH4HBGBGFJWSFQCAMJ8A0D | 1.0 | 2022-07-11T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Tales of the Kingdom, Vol. 1 | 2022-08-09T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3P56GB4H3FB0 | CNT_2S32PMHD3B10 | Tales of the Kingdom CNT_0AGA154FF6F0 | CNT_0AGA154FF6F0 | 2 | 1 | 1 | Volume 3 | [] | Tales of the Kingdom, Vol. 3 | Though the attempt on Dao’s life was thwarted by the king’s intervention, salvation has come at a price. He was ready to acquiesce to whatever was demanded of him in return for his life, but nothing could have prepared Dao for what he would encounter in the king’s private chamber— or what service he would be asked to perform. A king and his attendant, each haunted by painful memories of the past, each with a role to play in the future of the kingdom... | 01KGB3YPQRS2MYHXCASV2SJEGV | 3.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1GPSER10N8P0 | Tales of the Kingdom, Vol. 3 | 2023-04-18T00: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);