products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_23V23KTE2PCG"
This data as json, CSV (advanced)
Suggested facets: 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_26Q4Q0WH5Y70 | CNT_13J7ZZK3Z940 | If the Villainess and Villain Met and Fell in Love CNT_23V23KTE2PCG | CNT_23V23KTE2PCG | 2 | 1 | 1 | Volume 1 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 1 | Contracted with a no-name spirit, Brigitte Meidell is a disappointment to her noble family and the mockery of her peers at the Otoleanna Academy of Magic—except for one. Yuri Aurealis is intelligent, handsome…and oh so arrogant. He’s made enemies of the same people as Brigitte, meaning the two should get along just fine. However, his boorishness accidentally sparks a rivalry between them. It’s a competition that has the potential to bring the two closer than they ever thought…! | 01KH3H00ZG32MGAEBP8H7K47MX | 1.0 | 2023-08-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | If the Villainess and Villain Met and Fell in Love, Vol. 1 | 2024-02-20T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2Q630QRBHD90 | CNT_3XB2J2FAY130 | If the Villainess and Villain Met and Fell in Love CNT_23V23KTE2PCG | CNT_23V23KTE2PCG | 2 | 1 | 1 | Volume 2 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 2 | Brigitte’s affinity for spirits earns her a strong start in the magic-stone hunt, but she’ll need to give it her all to have any chance at dethroning Yuri. However, the competition screeches to a halt when a jealous rival falsely accuses Brigitte of something unspeakable! But in that moment, when her classmates turn their backs on her and Brigitte’s at her lowest—it is Yuri who stands by her side and breathes life back into the sputtering embers of the Red Fairy’s heart. Was he merely sticking up for a friend? Or has Yuri’s icy facade finally begun to melt away…? | 01KGB9RMHY5Q7Z6VAEQFYHYZK1 | 2.0 | 2024-06-18T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | If the Villainess and Villain Met and Fell in Love, Vol. 2 | 2024-11-26T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2R5J6SNW8JY0 | CNT_37AWY9PM3MN0 | If the Villainess and Villain Met and Fell in Love CNT_23V23KTE2PCG | CNT_23V23KTE2PCG | 2 | 1 | 1 | Volume 3 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 3 | Faced with such kindness, the feelings she’d been holding back began to overflow. It’s time for Brigitte and Yuri’s rematch, as they go head-to-head in the magic stone hunt! But a false accusation against Brigitte by Joseph’s new flame, Lisa, puts a pause on their competition! As the weight of suspicion by her peers threatens to suffocate Brigitte— Yuri’s voice reaches out to save the Red Fairy’s heart. | 01KGBHNQ80T2DQS93X2A6GB4HY | 3.0 | 2024-11-11T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | If the Villainess and Villain Met and Fell in Love, Vol. 3 | 2025-04-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2XBE9XPNGG2G | CNT_060VPDRX3R9G | If the Villainess and Villain Met and Fell in Love CNT_23V23KTE2PCG | CNT_23V23KTE2PCG | 2 | 1 | 1 | Volume 5 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 5 | If Brigitte was hoping for a relaxing break to study with her friends, she’s out of luck. Questions loom about her mysterious new contracted spirit, whose manifestation shot a pillar of light into the sky. Yuri’s flirtatious quips make her heart twinge, cutting through her defenses like icicles. But most of all, Prince Joseph’s renewed pursuit of her favor makes for a very complicated summer vacation. Brigitte’s love for Yuri has grown from embers to a steady flame, but the entitled prince’s advances threaten to ruin everything! Which means the only way to save the budding flame of her and Yuri’s yet unspoken love is the one thing Brigitte could never do—stand up to her former fiancé... | 01KP0B39GBNXGZJQG6ZZE8D5TX | 5.0 | 2025-10-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | If the Villainess and Villain Met and Fell in Love, Vol. 5 | 2026-04-28T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3KMA3VCF0T00 | CNT_2ZK7Q1WRNEFG | If the Villainess and Villain Met and Fell in Love CNT_23V23KTE2PCG | CNT_23V23KTE2PCG | 2 | 1 | 1 | Volume 4 | [] | If the Villainess and Villain Met and Fell in Love, Vol. 4 | Yuri never mentioned having a younger brother, but a wandering Brigitte seems to have found him all the same. The boy certainly has Yuri’s sharp tongue. And while his words cut deep, they offer Brigitte something she never thought possible—a way to speak with her contracted spirit! Brigitte wants nothing more than to finally communicate with hers, but the path there lies beyond the fire she’s cowered from since that fateful day years ago. Does Brigitte have the strength to conquer her fear and walk through the flames to finally hear the voice of her very own spirit…? | 01KG9QGND7HNBTJYPVZTHPD1VC | 4.0 | 2025-04-07T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | If the Villainess and Villain Met and Fell in Love, Vol. 4 | 2025-09-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);