products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
14 rows where series_id = "CNT_0TWFMXV67PMG"
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_04JDN781HFKG | CNT_2DXJS39S4190 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 5 | [] | Reign of the Seven Spellblades, Vol. 5 | <P> VENGEANCE WILL BE HIS </P><P> The Sword Roses are blossoming into proper Kimberly mages, but that growth doesn’t come without trials: Magical biology continues to bring Katie anguish, and an upperclassman is putting Guy through labyrinth boot camp. Meanwhile, Oliver has set his sights on his next target-Enrico Forghieri. </P><P> When Enrico whisks Pete off to his laboratory with Nanao and Oliver hot on their heels, the three friends get a horrifying glimpse of the longstanding conflict between mages and Gnostics. This may be the perfect opportunity for Oliver to finally exact his revenge on the mad old man...! </P> | 01KGAGJ0K3WR8M8C15M5ZQDV5W | 5.0 | 2022-04-25T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 5 | 2022-05-03T00:00:00.000Z | 0 | 0 | ||||||
| PRD_081QZTAQ5CM0 | CNT_35NQBZ0Z5MT0 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 14 | [] | Reign of the Seven Spellblades, Vol. 14 | The Sword Roses have miraculously made it to their fifth year fully intact. The six friends continue to study hard and turn their thoughts to what they want to do after graduation—except for one of them. Meanwhile, the Kimberly Magic Academy faculty members are dispatched across the Union to handle an approaching threat. However, they soon realize they’ve walked right into a trap! With the school in an unprecedented crisis, Oliver, Nanao, and their classmates find themselves on the front lines, face-to-face with the enemy. Who will come out on top? And what fate lies in store for the Sword Roses…? | 01KQ640DYFXZ59NSCA10MRE9MA | 14.0 | 2025-11-06T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 14 | 2026-04-14T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0AVGH14Q13GG | CNT_39DJ1S1K4XD0 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 3 | [] | Reign of the Seven Spellblades, Vol. 3 | A DESCENT INTO MADNESS Pete’s abduction at the hands of Ophelia Salvadori’s chimeras has the entire academy in a frenzy and Oliver’s group reeling. After all, what can a bunch of first-years do to save their friend from Salvadori, who’s been “consumed by the spell”? At this pivotal moment, a certain someone offers a deal to help rescue Pete from the witch holding him captive within the depths of the school’s perilous labyrinth…but will Oliver and his classmates succeed in their desperate mission and live to tell the tale? | 01KG9FPNHXHVGEFWVS2X0BV4T9 | 3.0 | 2021-06-29T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 3 | 2021-07-27T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0RQ70YF5D3EG | CNT_2M8CFE7MR7H0 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 4 | [] | Reign of the Seven Spellblades, Vol. 4 | DON’T LET THE MASK SLIP Another year gone at Kimberly Magic Academy means a new crop of first-year students. Oliver and his classmates, now second-years, see their studies becoming increasingly intense. The reality of life as a mage is a cold slap in the face... Nanao, meanwhile, is grabbing attention left and right due to her skills with a blade and her broom-riding talents. Dying for a reprieve, the six friends take a brief trip to the magicity of Galatea…but is their bond proving detrimental to Oliver’s clandestine duties…? | 01KG9HDNP267C1YZ1E7M5VCNNH | 4.0 | 2021-11-25T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 4 | 2021-12-07T08:00:00.000Z | 0 | 0 | ||||||
| PRD_0TCTD0RNN3C0 | CNT_3H11X1AN13T0 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 11 | [] | Reign of the Seven Spellblades, Vol. 11 | With a lengthy vacation before their fourth year begins, the Sword Roses set out to visit several nations within the Union. But between the boat rides, cultural exchanges, and bonding experiences, there’s just one thought on every friend’s mind—this may be their final chance to enjoy time outside of Kimberly. | 01KGAXS9QCKTVANE79XCTZ628Y | 11.0 | 2023-12-21T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 11 | 2024-05-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1DWS8HGD6A8G | CNT_0D6XARWV453G | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 10 | [] | Reign of the Seven Spellblades, Vol. 10 | THE PAST RISES TO THE FORE It’s the final round of the combat league. Godfrey and Leoncio clash like titans, and Kimberly gets a new student body president. As the dust settles, Oliver is faced with Nanao’s desires, Yuri’s absence, and his comrades’ plans to strike down a third target: Demitrio. The faculty’s investigation demands swift action—so the battle begins. Demitrio reveals secrets from the age of the divine. The comrades’ path to victory collapses beneath them. And the desperate struggle begins to uncover even more dire secrets: ones trapped deep within Oliver’s past… | 01KH3HKMT6N413TQQQ797GKP0N | 10.0 | 2023-08-21T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 10 | 2024-01-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1TTMWTF70CG0 | CNT_3E2TJ2W01Y30 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 13 | [] | Reign of the Seven Spellblades, Vol. 13 | WHAT ARE FRIENDS FOR?Guy has awoken as a curse wrangler, but that separates him from the Sword Roses (albeit temporarily), leaving the whole friend group rattled. This happens right when it’s time for fourth-years to pick a seminar, which has everyone thinking seriously about their futures. It’s not just Oliver’s inner circle that’s undergoing a transformation—relations between students in their year as a whole are shifting, and as they all get closer to honing their magecraft, things will never be the same… | 01KGBHP2ZXRNH3HEWQY8RNT15B | 13.0 | 2024-11-11T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 13 | 2025-07-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1V7W9AM4QN20 | CNT_37B5SM143ZWG | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 2 | [] | Reign of the Seven Spellblades, Vol. 2 | ONE CHALLENGE AFTER ANOTHER! Halfway into the school year, Oliver’s and Nanao’s magical prowess has garnered them considerable respect from their classmates. Nevertheless, the question remains: Who is the strongest first-year at Kimberly Magic Academy? So begins a battle royal-style tournament to defeat Oliver and Nanao in combat, and many competitors are eager to throw down the gauntlet. Some, however, will use this opportunity to set their own nasty schemes in motion... | 01KG9E14P39VFXMDYRH3B4S0R8 | 2.0 | 2021-04-22T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 2 | 2021-05-04T07:00:00.000Z | 0 | 0 | ||||||
| PRD_20KDXWHK20VG | CNT_0HMY8P7TVCVG | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 8 | [] | Reign of the Seven Spellblades, Vol. 8 | DEATH COMES FOR US ALL The Kimberly Magic Academy combat league is heating up with the upperclassmen now going head-to-head! Meanwhile, the Sword Roses—joined by several seniors—delve deeper into the labyrinth in pursuit of Rivermoore, who has stolen one of Godfrey’s bones for purposes unknown. They find themselves on the necromancer’s home turf, a veritable kingdom of the dead where hordes of skeletal beasts and ghastly foes are at his beck and call. Will Oliver and friends manage to fend off his onslaught and recover Godfrey’s missing sternum? What role does the coffin on Rivermoore’s back playin his schemes…? | 01KGB4F76TNKXZAMFTH151E1B4 | 8.0 | 2023-02-07T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 8 | 2023-05-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_23MQPDZV7SCG | CNT_2Y7R3VGK1W8G | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 9 | [] | Reign of the Seven Spellblades, Vol. 9 | THE COMPETITION HEATS UP, BUT AN ICY GAZE LINGERS The combat league is reaching its climax, and the four teams that fought tooth and nail to get there are ready to take center stage. First is Oliver’s team against Team Valois, a group of tricky sword arts users whose leader harbors an unnatural loathing that’s ready to bubble up to the surface. Next, Team Cornwallis faces the favorite to win the league: Team Andrews, a ragtag trio combining dynastic talent with unbridled chaos. Demitrio, the astronomy instructor, makes a rare appearance among the spectators; he seeks the culprit behind the faculty murders, and his eyes are trained on Oliver’s team… | 01KGB6DD83DZ4XBP15X74ZYQYJ | 9.0 | 2023-04-24T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 9 | 2023-09-19T00:00:00.000Z | 0 | 0 | ||||||
| PRD_24JZAVGKQPVG | CNT_0TM4JE4MTAR0 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 1 | [] | Reign of the Seven Spellblades, Vol. 1 | FROM A CLASH OF SWORDS, AN UNSHAKABLE BONDSpringtime at Kimberly Magic Academy brings a new batch of first-year students, all bright-eyed and bushy-tailed as they begin their journey to become full-fledged mages. Among these newcomers are Oliver Horn, a studious boy equally skilled with the wand and the blade, and Nanao Hibiya, a strong-willed samurai girl from the distant nation of Yamatsu. The wheels of fate bring these two souls together at Kimberly, where they become both comrades and rivals in equal measure. However, lurking within the academy’s halls are countless dangers and dark secrets guaranteed to threaten not only their friendship—but their very lives... | 01KG9CEMN6J6XB3HHM9ZKJVAGT | 1.0 | 2020-10-28T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 1 | 2020-12-01T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2GK08EAYJFCG | CNT_162KCNWXKCS0 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 6 | [] | Reign of the Seven Spellblades, Vol. 6 |  TAKE TO THE SKIES<BR /> A second faculty member’s disappearance in as many years sends shock waves through Kimberly Magic Academy. Without any clues as to the culprit’s identity, the headmistress is treating everyone as a suspect. Amid this turbulent state of affairs, the student body presidential election is fast approaching, and the incumbent president, Godfrey, has yet to back a successor. Meanwhile, Nanao endeavors to help star athlete Ashbury, who’s hit a wall trying to improve her broomriding speed. To top it all off, there’s a shady new transfer student prowling the school! Yet as friendly as he is, no one seems to know much about him… | 01KGAJCY33MWZSP9PN025DKT2M | 6.0 | 2022-07-29T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 6 | 2022-09-06T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2YPG6770R250 | CNT_3CVS5JX98E70 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 7 | [] | Reign of the Seven Spellblades, Vol. 7 | There’s no “I” in “Team”<BR /> The Kimberly Magic Academy combat league approaches, and the school’s future may be riding on it! Now third-years, Oliver and his friends jump at the opportunity to showcase their growth, splitting into three-person teams and entering the event. However, the competition’s extravagant rewards are merely a ploy by the headmistress to ascertain who murdered Instructors Grenville and Forghieri; what’s more, the results of the combat league will influence the outcome of the looming school election. Yuri, meanwhile, is pursuing the culprit behind the Case of the Stolen Bones: seventh-year Cyrus Rivermoore. Just what is that warlock planning…? | 01KGB2NY44DYCQZM3WP25JWJKJ | 7.0 | 2022-12-07T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Reign of the Seven Spellblades, Vol. 7 | 2022-12-13T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3W7AMKF5XRC0 | CNT_2QFCV924GC80 | Reign of the Seven Spellblades CNT_0TWFMXV67PMG | CNT_0TWFMXV67PMG | 2 | 2 | 1 | Volume 12 | [] | Reign of the Seven Spellblades, Vol. 12 | SOMETHING WICKED THIS WAY COMES…With their brief respite over, our heroes begin their fourth year at Kimberly Magic Academy. The school is still shaken by the “disappearance” of the philosopher Demitrio—and a lineup of oddball new teachers arrives to fill in the gaps. Chief among them is the great sage Rod Farquois, a reversi. Concerned for his friends and certain that the new winds Farquois brings will lead to storms, Oliver urges caution. Meanwhile, Pete and Guy seek further bonds and strengths, hoping to match their comrades’ accomplishments. But a mage’s life is hell, and it will give them no solace. Once more, in the labyrinth’s depths…someone will be consumed by the spell. | 01KGBC08270RZ04F6D7VGPAKSX | 12.0 | 2024-07-23T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1PQM5BDYSMG0 | Reign of the Seven Spellblades, Vol. 12 | 2024-12-17T08: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);