products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_0JFA2WPW9R10"
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_037F2M88VVCG | CNT_0WJ0RKQKEGQG | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 2 | [] | Reign of the Seven Spellblades, Vol. 2 | As night falls on Kimberly Magic Academy, the halls transform into a dark and deadly labyrinth...with Oliver and his friends still inside! Faced with a maze of evershifting passages and upperclassmen who hardly have their well-being in mind, the dark side of the school will test their mettle. However, even as they run from certain death, they have to stop Nanao from walking toward it. Just what mysteries does her fierce past hold...? | 01KGADBG4B3TTA0QQ6EJS489J7 | 2.0 | 2022-01-18T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 2 | 2022-02-22T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0PMPPX7K2PBG | CNT_21A1DT414TM0 | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 1 | [] | Reign of the Seven Spellblades, Vol. 1 | It’s springtime at Kimberly Magic Academy, and that means the arrival of a fresh crop of first-year students. Whether it’s the quiet and studious Oliver Horn or Nanao Hibiya, a samurai girl from a distant land, they come with wands and swords at their waists, ready to take their first steps on the road to magical mastery. However, beneath its brilliant facade of cherry blossoms, the academy hides countless dangers and dark secrets, ready to take the lives of the unprepared…! | 01KG9G0EVVG7PR664CNYRPCTHT | 1.0 | 2021-09-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 1 | 2021-11-16T08:00:00.000Z | 0 | 0 | ||||||
| PRD_11M7FS76J5EG | CNT_0VA60QCCSNC0 | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 6 | [] | Reign of the Seven Spellblades, Vol. 6 | Chela, Nanao, and Oliver against Stacy, Fay, and the indomitable Joseph Albright. A worthy match to be sure—but down in the labyrinth, there are no witnesses to cry foul if a duelist fights dirty! In a clash of blades and emotions, the battle to determine the strongest first-year heats up! | 01KGB6GM3BJ613ZWTCJQ3XGK6G | 6.0 | 2023-05-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 6 | 2023-08-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_21RCBEARPY8G | CNT_0V0KX9BNNACG | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 5 | [] | Reign of the Seven Spellblades, Vol. 5 | As the battle to determine the strongest first-year heats up, Katie comes to her friends with a daring proposal—to build a secret base within the labyrinth! Having a shared workshop would be a great boon for each of their personal projects, but the dark corridors under the school are a perfect spot for an ambush. With new opponents entering the fray nursing grudges against the group, Oliver and the others will have their work cut out for them if they want to stake their claim! | 01KGB2N01V2EVRMV6DS014NKJD | 5.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 5 | 2023-02-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2N7WWXTZYG9G | CNT_03KM6JY7ZJHG | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 8 | [] | Reign of the Seven Spellblades, Vol. 8 | The end is near as Ophelia is soon to manifest the Salvadori spell. All hope seems lost for Oliver and his friends as they are surrounded by danger from all directions. Will the first-years succeed in their rescue mission and live to tell the tale or will this be the conclusion to their Kimberly days ...?! | 01KGBCJE5XEBZXHZTYXMR05P4A | 8.0 | 2024-08-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 8 | 2025-02-18T08:00:00.000Z | 0 | 0 | ||||||
| PRD_34PEFB2B03R0 | CNT_24E5J5Z050EG | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 4 | [] | Reign of the Seven Spellblades, Vol. 4 | <P>  The clashing of blades echoes in the depths of the labyrinth, and Oliver takes his first steps onto the path of blood. As he plots his vengeance from the shadows, though, other students are putting their own schemes into motion. Despite Oliver’s best attempts to remain obscure, he and Nanao have attracted the attention of their classmates with their magical prowess. “Who is the strongest first-year?” they wonder. Well, there’s only one way to find out—a battle royal–style tournament! </P> | 01KGAJD4K5QCTQ44A80K2NYDD4 | 4.0 | 2022-07-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 4 | 2022-08-30T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3A1QGNHS6N6G | CNT_0KN5AAXDY5GG | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 7 | [] | Reign of the Seven Spellblades, Vol. 7 | Ophelia Salvadori has been consumed by the spell, and Pete has fallen into her clutches. Unwilling to give up hope, Oliver and the others prepare to descend into the depths of the chimera-filled labyrinth. Their mission—to save their friend…! | 01KGAXZX9GSBAJTF3EKPEVQRG0 | 7.0 | 2024-01-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 7 | 2024-07-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3CV232363K80 | CNT_125RMYKST6DG | Reign of the Seven Spellblades CNT_0JFA2WPW9R10 | CNT_0JFA2WPW9R10 | 2 | 1 | 1 | Volume 3 | [] | Reign of the Seven Spellblades, Vol. 3 | Kimberly Magic Academy has lived up to its shadowy reputation in Oliver’s first weeks as a student, with him and his friends encountering one mystery after another. Why did a garuda appear in the underground Colosseum? Why did the troll attack Katie during the entrance ceremony? As the final pieces of the puzzle fall into place, the stage is set for a deadly duel! | 01KGAGHMK0PMJ24Q2Q3B7QV4NE | 3.0 | 2022-04-25T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 3 | 2022-05-31T00: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);