products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
2 rows where series_id = "CNT_1MV069R00GDG"
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_3N9X91VSXKM0 | CNT_0JQ62540THJG | If the Villainess and Villain Met and Fell in Love CNT_1MV069R00GDG | CNT_1MV069R00GDG | 2 | 4 | 2 | Volume 2 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 2 | When Prince Joseph broke off his engagement to Brigitte, her life was shattered—but meeting Yuri helped her start putting it together again. The two may have started off as rivals, yet the more she learns about him, the more she's come to appreciate him...Unfortunately, Joseph is ready to turn everything upside down again, suddenly attempting to reinstate their engagement. Brigitte is far from eager to go back, but her relationship with Yuri is getting complicated. Not only that, but it seems her weak, no-name spirit might be something else entirely...! | THE SMALLEST SPARK CAN GROW INTO A FIRE. | 01KG7ABJKBBV3938JH4Z82PW6C | 2.0 | 2025-12-23T08:00:00.000Z | Yen Audio LAB_34QX5FTMWAZ0 | GEO_1PQM5BDYSMG0 | If the Villainess and Villain Met and Fell in Love, Vol. 2 | 2026-01-13T08:00:00.000Z | 0 | 0 | |||||
| PRD_3NTAV7H8MEMG | CNT_2PCV3ZXX567G | If the Villainess and Villain Met and Fell in Love CNT_1MV069R00GDG | CNT_1MV069R00GDG | 2 | 4 | 2 | Volume 1 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 1 | SOMETIMES FIRE AND ICE ARE PERFECT FOR EACH OTHER.Brigitte Meidell belongs to a noble family, which means high expectations were placed upon her spirit contract. However, her bonded spirit turned out to be a weak no-name, and ever since, she has been a source of shame to her family. She thought her engagement to the prince would turn her life around, but when he publicly breaks off their relationship, she finds herself alone again. After her haughty, villainous behavior as the prince's brideto- be, no one shows her much sympathy—except for the duke's son Yuri, who attends the same magic academy. Yuri is feared for his incredible abilities and icy personality, but with him on her side, her fortunes might have changed... | 01KGC0ND3F8Z32JQZVCRS6CN5V | 1.0 | 2025-10-16T07:00:00.000Z | Yen Audio LAB_34QX5FTMWAZ0 | GEO_1PQM5BDYSMG0 | If the Villainess and Villain Met and Fell in Love, Vol. 1 | 2025-10-23T07: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);