products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_02TZMBKRBK20"
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_309KWK73HJRG | CNT_397RBJPSHGF0 | The Villainess Is a Marionette CNT_02TZMBKRBK20 | CNT_02TZMBKRBK20 | 2 | 1 | 1 | Volume 2 | [] | The Villainess Is a Marionette, Vol. 2 | DISPOSING OF THE ROTTEN APPLESKayena’s efforts to manipulate people’s perceptions of her finally prove fruitful when she is handed authority over the palace staff. She immediately begins to amass trustworthy allies by summoning her previously exiled nanny and a small, exclusive group of new ladies-in-waiting—but a sudden run-in with the obsessive Lord Gillian shakes her to her very core. The appearance of her cruel husband from her first life serves as a harsh reminder of just how much she has to lose…Will Kayena be able to change things this time around, or will the chains of fate prove too strong to escape? | 01KGBV0M2WA9T66GC0P9708YC3 | 2.0 | 2025-08-27T07:00:00.000Z | Ize Press LAB_1A358A3NHWA0 | GEO_1PQM5BDYSMG0 | The Villainess Is a Marionette, Vol. 2 | 2025-08-28T07:00:00.000Z | 0 | 0 | ||||||
| PRD_32VQ68D1GR9G | CNT_3D3BPHNQFQQG | The Villainess Is a Marionette CNT_02TZMBKRBK20 | CNT_02TZMBKRBK20 | 2 | 1 | 1 | Volume 1 | [] | The Villainess Is a Marionette, Vol. 1 | EVERY ROSE HAS ITS THORNSKayena Hill, the princess in the novel The Lady of the Black Rose, is the most exquisite beauty of the empire…and the empire’s biggest fool. A mere puppet in her brother’s schemes, she’s fated to be married off to an obsessive and abusive man and left to die. Except…it isn’t just fiction, not when this is her second life as the princess herself and third overall! Armed with her memories of what’s to come, Kayena must now rewrite her story and win her freedom. This time, she’ll be the one pulling the strings! | 01KGBQQWFP5JYSW52MB536J49Y | 1.0 | 2025-06-04T07:00:00.000Z | Ize Press LAB_1A358A3NHWA0 | GEO_1PQM5BDYSMG0 | The Villainess Is a Marionette, Vol. 1 | 2025-06-05T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3YKXJ2WXAWZ0 | CNT_2BTKZJ9ST570 | The Villainess Is a Marionette CNT_02TZMBKRBK20 | CNT_02TZMBKRBK20 | 2 | 1 | 1 | Volume 3 | [] | The Villainess Is a Marionette, Vol. 3 | NEW ALLIES, OLD FOESThe rest of the new ladies-in-waiting Kayena chose have arrived at the palace, and with that, it’s time to enact the next part of her plan: laying the groundwork for Lady Olivia and Lord Kidrey’s fateful first encounter! After all, to successfully escape Regef’s grasp and win her freedom, she needs Raffaello’s help, and what better way than speeding up his romance with the heroine of the story? The only problem is, he doesn’t seem to have the slightest interest in Lady Olivia! However, Lord Kidrey’s confusing behavior is the least of Kayena’s problems, as Lord Gillian’s obsession with her grows by the day, and he seems to have a far more sinister scheme for the princess in mind… | 01KGC0MVNQN0X15NE6MBADBR1S | 3.0 | 2025-11-19T08:00:00.000Z | Ize Press LAB_1A358A3NHWA0 | GEO_1PQM5BDYSMG0 | The Villainess Is a Marionette, Vol. 3 | 2025-11-20T08: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);