products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_3CKPW9H1G9A0"
This data as json, CSV (advanced)
Suggested facets: copyright, 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_1EWC41QQ20J0 | CNT_2SX5KFVJEYY0 | A Tale of the Secret Saint CNT_3CKPW9H1G9A0 | CNT_3CKPW9H1G9A0 | 2 | 4 | 2 | Volume 1 | [] | A Tale of the Secret Saint Vol. 1 | Born into a long line of knights, Fia is determined to become a knight herself, just like all her siblings. But a brush with death awakens memories of her past life as a Saint--a woman who wields rare, powerful healing and protection magic--along with the ability to use that magic herself! The downside is that Fia also remembers her past life's untimely death, and the danger she will be in if anyone finds out what she really is. She vows to stay on her knighthood path and keep her powers a secret forever! But how can she resist using her newfound powers when they're just so useful? | The Secret is Out! | 01KGBQVSA039V9BSBTWR8T7QSE | 1.0 | 2025-07-03T07:00:00.000Z | Seven Seas Siren LAB_13Q4428H6SGG | GEO_1PKAG51AEAQG | A Tale of the Secret Saint Vol. 1 | © Touya, chibi 2019 | 2025-07-17T07:00:00.000Z | 0 | 0 | ||||
| PRD_2TVASAGKPBQ0 | CNT_2PEFEJ2RM2KG | A Tale of the Secret Saint CNT_3CKPW9H1G9A0 | CNT_3CKPW9H1G9A0 | 2 | 4 | 2 | Volume 2 | [] | A Tale of the Secret Saint Vol. 2 | Fia finally achieved her dream of becoming a knight, and was even assigned to the prestigious First Knight Brigade! But her unusual feats of strength and magic are already attracting unwanted attention. Keeping her saint powers a secret is proving harder than expected. Now, a black dragon has been sighted in Starfall Forest, and Fia is sent on a mission to find it...but does this black dragon have anything to do with her familiar, Zavilia? | DRAGONS AND DISCOVERIES | 01KGBV6Y0ZD5TY4EW4B4B487T2 | 2.0 | 2025-09-19T07:00:00.000Z | Seven Seas Siren LAB_13Q4428H6SGG | GEO_1PKAG51AEAQG | A Tale of the Secret Saint Vol. 2 | © Touya, chibi 2019 | 2025-11-13T08:00:00.000Z | 0 | 0 | ||||
| PRD_3XS19E222WXG | CNT_33XH1SK9HN1G | A Tale of the Secret Saint CNT_3CKPW9H1G9A0 | CNT_3CKPW9H1G9A0 | 2 | 4 | 2 | Volume 3 | [] | A Tale of the Secret Saint Vol. 3 | Now back with the First Knight Brigade, Fia heads to Sutherland with its lord, Captain Cyril. Fia remembers Sutherland fondly from her past life's memories and is excited to go--but tension is high between the captain and his subjects. Worse, the people of Sutherland become convinced that Fia is the reincarnation of the Great Saint--which she is, of course, but there's no way they could know that! Now Fia will have to pretend that she's pretending to be the Great Saint, all while keeping her true identity hidden from Captain Cyril and the other knights! | TWO LIES MAKE A TRUTH | 01KH2TYX4J3818DMEJ36KBZH2B | 3.0 | 2025-12-10T08:00:00.000Z | Seven Seas Siren LAB_13Q4428H6SGG | GEO_1PKAG51AEAQG | A Tale of the Secret Saint Vol. 3 | © Touya, chibi 2020 | 2026-03-19T07: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);